Converting the Exported Literacy Assessment Scores (PowerSchool Admin)

The purpose of this guide is to assist in converting the literacy assessment scores that are exported from PowerSchool into meaningful instructional level expectations.

*NOTE: If you have NOT already exported the Literacy Assessment Scores from the admin side of PowerSchool, please do so by following this guide: Exporting Literacy Assessment Results (PowerSchool Admin).

1. Open the exported file using Microsoft Excel. This can be done a few different ways:
1. Right-Click on the file and choose Open with. Then choose Microsoft Excel from the list of available apps; OR
2. Open Microsoft Excel first. Then select File > Open. Navigate to the export file and open it; OR
3. Adjust your Default Apps in windows settings to always open .text files with Microsoft Excel. Then simply double click the export file.
   
2. Download your own copy of the Literacy Assessment Conversion file by clicking HERE (the file should automatically download, depending on your browser settings).
   
3. Open the Literacy Assessment Conversion file.
   
4. From the Export file: you will be copying the student data (without the teacher-entered scores)
1. Click and drag to select the student data in columns F to J (do not copy column headers).
2. Copy the selected data (right-click and copy or press CTRL + C).
   
5. To the Literacy Assessment Conversion file: you will be pasting the student data while keeping the destination formatting.
1. Right-click on cell A3 and choose Paste Values from the Paste Options section (shown by the icon of a clipboard with numbers). This will retain the embedded sheet formatting.
   
   
6. From the Export file: you will now be copying the teacher-entered scores
1. Click and drag to select the applicable reporting period column of scores.
   R1 (column K) / R2 (column L) / R3 (column M) / R4 (column N)
2. Copy the selected data (right-click and copy or press CTRL + C).
   
7. To the Literacy Assessment Conversion file: you will now be pasting the teacher-entered scores while keeping the destination formatting.
1. Right-click on cell F3 and choose Paste Values from the Paste Options section. This will retain the embedded sheet formatting.
   
8. You should now see the converted scores in column G highlighted based on the value:
   
   You can choose to filter column information as needed using the built in filters in the column headers. Sorting will not work on this protected sheet.