Test Score Import

From EDgearWiki
Jump to navigationJump to search

This program will provide a way for the user to import student's test scores.

  • Depending upon the test to be imported, acceptable file extensions include .csv, .txt and other character files but never a .pdf file.
  • Excel files can be converted to a .csv file by right clicking and choosing: Export to: csv.
  • If a user re-imports a file that has the same test date as the previously imported file, then the file will overwrite and not create duplicates. ACT and LEAP are examples of files that have the test date actually built into the file.

Menu Location

Testscoremenu.png

On the left navigation panel, select Grades > Import > Test Score Import.

Setup Options

Tsi.png

District - Default value is based on the user's security settings. It will be limited to their district only.

Year - Defaults to the current year. A prior year may be accessed by clicking in the field and making the appropriate selection from the drop down list.

Test Name - Select the most recent "version" date of the test that you are importing. For EOC/LEAP, additional options will be available for Test Name. EOC (End of Course) is now being replaced by LEAP2025.

Test Date - Select the test date that the student took the test.

  • If the file already has a test date included in the file (Ex: ACT), then that date will display in the Test Score Editor Test Date column.
  • Otherwise, if the date is not in the file, the date the user entered will display in the column.

File - Choose the file that you are importing, from the location it is stored/saved in your computer. Depending upon the test to be imported, acceptable file extensions include .csv, .txt and other character files but never a .pdf file. Check the Description column of Test Name to see if the proper format extension is listed. Also, check the CD that the files are stored on to see if additional file extensions are available.

  • The ELPT uses the .csv format. To download the ELPT scores, go to the Department of Education website.
  • To download your district's ACT scores, go to act.org. The ACT tests, including PreACT, are imported with the .csv file format. Avoid opening the download using Excel as this tends to corrupt the data.
In this program use the "ACT 2019" Test Name to load the ACT file. But when the file was downloaded from act.org, there is now an option for a STEM file in step 5, so under Options>Filter>Scores, uncheck the "STEM" choice. If this is done then the file will load correctly using the "ACT 2019" Test Name.
For PreACT use the "PreACT (DHL Layout)" Test Name.
  • On the Growth To Mastery file, the user will need to "save as" a csv file and remove the top header rows before importing. For High School, use the Growth to Mastery High School (2018.10.12) and for Elementary/Middle, use the Percent to Mastery Elem/Middle Schools (2017.09.26). Both import results are viewable in Test Score Editor for the test by selecting the test name "Growth to Mastery".

After selecting, the name of the file will display to the right of the Choose File button.

OK - Click to continue.

Upon completion, the user will get a confirmation pop up screen of the data being imported, created, and updated after the file is imported,.

To find definitions for standard setup values, follow this link: Standard Setup Options.

Main

Testscoremain.png

Column Headers

Last Name - Student's last name

Suffix - Student's generational suffix

First Name - Student's first name

Middle Name - Student's middle name

Sidno - Student's identification number

Date Changed - The date that data was changed in the program.

To find definitions of commonly used column headers, follow this link: Common Column Headers.

Bottom

Testscorebottom.png

Setup - Click to go back to the Setup box.

Print - This will allow the user to print the report.

Help - Click to view written instructions and/or videos.


Resources

Directions to Download Workkeys Results From Validus



Grades Main Page


JCampus Main Page

Retrieved from EDgear Wiki