Test Score Import

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.
• When you double click on an ACT .csv file it will automatically open in an excel file and add leading zeros resulting in corruption of the file. Instead right click on the file and choose Open With, then choose Word Pad or Note Pad. 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

Grades > Import > Test Score Import

Setup Options

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.
• LEAP Connect 2021 was created due to the Virtual Learning column being added. It was positioned after the ELA Litho column and this caused the scores to be off by one column. LEAP Connect LAA1 removed this Virtual Learning column in the 2122 year so this means that "LEAP Connect 1920" is once again the current import to use.

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 and and LEAP), then that date will display in the Test Score Editor Test Date column. Just let the defaulted date stay on the setup box. 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.
• Otherwise, if the date is not in the file, the date the user entered in the Test Date field will display in the Test Score Editor Test Date 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 field 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.
• For ACT scores downloading in the Download Hub, 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 see the example below!

Example: When the user downloads the file from ACT.org, using these steps (click on the ACT link): ACT, and then the user gets to the option for a STEM file in step 5, (Options> Filter> Scores), uncheck the "STEM" choice. If this is done then the file will load correctly using the "ACT 2019" Test Name in Test Score Import. If STEM is selected, use the "ACT 2023". For PreACT use the "PreACT (DHL Layout)" Test Name in Test Score Import.

• 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".

• For LA Literacy Screener score information see Screening Test Entry.

• For Workkeys import, use the "ACT WorkKeys 2.0 Validus Data Export".

File Requirements:

• Directions to obtain file in Validus software: Directions to Download Workkeys Results From Validus
• CSV format
• Spanish Test Titles need to be changed to English counterparts.
• Remove rows at top with no test information (leave header row)

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

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

Sasid - State assigned 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

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 ACT Scores

Directions to Download Workkeys Results From Validus

---

Grades Main Page

---

JCampus Main Page