Import Scores from Illuminate to PS :: PowerTeacher Gradebook

The basic import function provides you with the required tools needed to bring assignment score information into PowerTeacher Pro. Before performing an import, you must have an import file available containing the data you want to import.

Exporting From Illuminate

1. Go to the 'Assessments' tab and click on List Assessments
2. Once you select an assessment, navigate to Reports > Student Responses
3. Performance band should be set to All Performance Bands. Click Submit
4. Download Raw Student Response Data as an Excel file 
5. Reformat the data to your liking. You will only need two columns: the Local Student id and Percent Correct. Make sure that the file is limited to students in your section ONLY. If you teach multiple sections, create a new file for each class.
6. Save the file as a csv (comma delimited file) in a computer folder that's easily accessible, or on your desktop.

Importing to PowerSchool

1. Login to PowerTeacher via kippnj.okta.com
2. Create an assignment with Score Type set to Percent, Points set to 100, and Category set to either Formative or Summative Assessments. The date should be set to when the assessment took place.
3. Click on the cogwheel and select Import Scores       
4. Choose Browse Files > Recent Places > and select your csv Illuminate export
5. If you are importing a file with multiple score columns, select the column to import
6. Students' scores will appear on the scoresheet!