Importing and Exporting Scores

On this page:

You can export information for a single assignment into a comma-separated values (CSV) text file using the PowerTeacher Scores Template (PST). Alternatively, you can import scores for a single assignment using a variety of file formats from third-party applications. If you use your own file format to import assignment score information, the file must contain, at minimum, a student identifier column (school-defined student number) and a score column. You can also include columns such as a student name column, or additional score columns (if maintaining assignment score information for several assignments within a given import file).

Although the PowerTeacher Pro import function only imports scores for a single assignment at a given time, your import file can contain assignment score information for several assignments.

Export Scores Template

Use the Export Scores Template to export an assignment score template with or without scores included. This file can then be used to work on your scores outside of PowerTeacher Pro. Once you are finished recording assignment scores, you can then import the updated information back into PowerTeacher Pro.

1. From the main navigation menu, choose Grading, then Assignment List.
2. Select an assignment.
3. Click the gear icon, then choose Export Score Template. If scores exist for the assignment, you can include the scores in the export, or opt to export only the assignment and student information.

To display the export scores template, navigate to the export scores template saved location and open the template. The download location is determined by your browser settings.

If you open the downloaded template using Microsoft Excel, be sure to save it as a .csv file before you import the scores back into PowerTeacher Pro. Click File, then choose Save As. From the File Format, choose Comma Separated Values UTF-8 (.csv). If you are using a different version of Microsoft Excel, contact your PowerSchool administrator for assistance.

Import Scores

The basic import function imports assignment score information into PowerTeacher Pro. Before completing an import, you must have an import file available containing the data you want to import.
If the reporting term or class is locked, you are unable to import scores.

1. From the main navigation menu, choose Grading, then Assignment List.
2. Select an assignment.
3. Click the gear icon, then choose Import Scores.
4. Click Browse Files, then select the file you want to import.
5. Choose the Format.

   1. If you select CSV or Text, choose from the additional options:

      • Include First Row – Select this option if there is no header row and all rows contain data to import.
      • File Score Type – This is the score type entered in the file you are importing. If the score type of the import file does not match the current score type of the assignment in PowerTeacher Pro, the score will automatically translate to the score-value currently used for the assignment.

      For example, if you enter percentages in the import file, and the assignment is configured to use points, select Percent. When the file is imported, PowerTeacher Pro will automatically translate the percent values to points.

   2. If you select Other, choose from the additional options:

      • Field Separator - Enter the character used to separate fields. If left blank, this defaults to a comma.
      • Line Separator – Enter the character used in the import file to designate a line separator. If left blank, this defaults to the end of the line mark (carriage return).
      

      If you are importing a file that includes multiple score columns, select CSV, Text, or Other. Multi-column import is not supported with PowerTeacher Score Template (PST).

6. Optionally, select Validate Student Names to validate that the student names in the import file match the names enrolled in the class. This identifies possible mistakes in the import file where the student name does not match the student number.
7. Click Next. Click the alert icon to display any resulting error messages.
8. Choose how you want to format the import data:
   
   • If you import a PST file and the Assignment Name does not match the name specified on the third line of the file, you will receive a warning. Make the necessary selection to proceed.
   • If scores already exist, you can keep or overwrite existing scores.
   • If standards scores already exist, you can choose to keep the existing standards scores or recalculate them based on the imported data.
   • If the import file contains scores that are higher than the maximum value set for the assignment, you can choose to keep the existing scores or overwrite them with the maximum value.

   If you import a file with multiple score columns, click on the score column header to select the column you want to import. If you select a column in which a score exceeds the maximum value for the assignment, you can select to keep the existing scores or change them to the maximum value for the assignment. This is useful if you have a file set up to have a separate column for multiple assignments.

9. Click Import. The scores will display on the Scoresheet.

Import a File with Internationalized Characters

You can import a file with internationalized characters using Microsoft Excel for Office 2016. If you are using a different version of Microsoft Excel, or you use a different spreadsheet program, contact your PowerSchool administrator for assistance.

1. Open Microsoft Excel.
2. Choose Blank Workbook to create an empty document.
3. On the Data tab, click From Text, then select the file to import.
4. Complete the following steps within the Text Import Wizard:
   • Choose the Delimited option, and on the File origin menu, select 65001: Unicode (UTF-8). Click Next.
   • Choose Comma as the delimiter and the double-quote character as the Text qualifier. Click Next.
   • Click Finish.