Teacher guide

Move grades into PowerSchool

1. 1

   Step 1: Add your classes once

   Save a starting class list.

   1. In PowerTeacher Pro, choose the class and open any assignment in Grading → Assignment List.
   2. Click the gear, then Export Score Template. Save it without opening or changing it.
   3. In Teacher tools → My classes, add that file. Check the class name and students before saving.

   Open My classes

   For each send, we recommend adding the assignment’s Score Template for each class in step 1. GradeBridge checks the saved list each time a template is added; you choose Update or Keep when it differs. Templates are optional. Which students a template includes has not yet been checked in a live PowerTeacher Pro.

   Ready when: your classes appear in My classes.

2. 2

   Step 2: Get your grades

   Choose your source.

   A CSV is a spreadsheet file ending in .csv.

   Where are your grades?

   Google Classroom

   1. At classroom.google.com, choose the class, then Classwork and the assignment.
   2. Click the number over Turned in or Assigned to open Student work.
   3. Missing or past-due work gets a draft 0 by default. Check each zero before downloading.
   4. Reported issue, not verified here: excused work may export as 0. Check against your originals.
   5. Click Settings (gear) → Download these grades as CSV.

   A Google Forms quiz

   1. In the Google Forms quiz, click Responses → Individual.
   2. Give points for every question Forms could not grade, then Save for each student.
   3. Click Responses → Link to Sheets.
   4. In Sheets: File → Download → Comma-separated values (.csv). (Check on your screen)
   5. Check for names or emails and Score. Scores like 35 / 40 are accepted.
   6. Repeated submissions stay in the file; you choose which counts in GradeBridge.

   Excel or Google Sheets

   1. Use one student-name or number column and one assignment-score column.
   2. Keep student numbers as text, including leading zeros: 001234, not 1234.
   3. Excel: add the .xlsx file as it is. Each filled-in visible sheet is read as its own file.
   4. Sheets: File → Download → Comma-separated values (.csv) for this assignment’s tab. (Check on your screen)
   5. Sheets downloads only the selected tab; keep the original spreadsheet.

   Blank or zero?

   On paper or not typed up yet

   1. In GradeBridge, choose the assignment and classes, then continue to Scores.
   2. Choose Type scores beside the class. Leave a cell blank if it is not graded; type 0 only for a real zero.
   3. Choose Use these scores. Typed scores are never saved and stay only on this page: reloading or closing it clears them.
   4. Prefer a spreadsheet? Use Make a grading sheet, import Student Num as Text, enter scores and save as CSV.

   Make a grading sheet

   Blank or zero?

   Ready when: you have a grades .csv, or are ready to type scores.

3. 3

   Step 3: Send scores in GradeBridge

   Assignment → Scores → Check & download.

   1. Recommended: in PowerTeacher Pro, open the assignment → gear → Export Score Template, once for each class you are sending.
   2. In GradeBridge step 1, add all those templates together. They fill the assignment details and check each saved class list. If a list differs, review the named students and choose Update or Keep my saved list.
   3. Or choose your classes and type the assignment name and points. Confirm they match PowerSchool. The template check is optional; Check & download says which lists were not checked.
   4. On Scores, add your grades file or type scores for each class. Confirm the columns and which class each file belongs to.
   5. On Check & download, decide unclear names, duplicates and blanks yourself. Review every flagged score.
   6. Check your answers, then Download one file for each class. Choose Score Template unless your import refuses it.

   • Avery SampleFile: 35 → Prepared: 35
   • Jordan ExampleFile: 0 → Prepared: 0, a real zero
   • Morgan PracticeFile: blank → Prepared: blank, not a zero

   Several classes or assignments?

   Choose all the classes for the same assignment. Download and import a separate file for each class. For a different assignment, start a new send.

   Ready when: you have downloaded the reviewed file for each class.

4. 4

   Step 4: Import and check

   Use the same class and assignment.

   You import the file yourself. GradeBridge cannot see, change or undo PowerSchool grades.

   Score Template

   1. In PowerTeacher Pro, open that class.
   2. Choose that assignment in Grading → Assignment List.
   3. Click the gear, then Import Scores.
   4. Browse Files: choose your downloaded file.
   5. Format: PowerTeacher Score Template. Turn on Validate Student Names if available.
   6. Click Next; open any alert icon.
   7. Choose whether to keep or overwrite existing scores. (Check on your screen)
   8. For scores above the maximum, choose existing score or maximum. (Check on your screen)
   9. Click Import, then open the Scoresheet.

   Simple CSV

   1. In PowerTeacher Pro, open that class.
   2. Choose that assignment in Grading → Assignment List.
   3. Click the gear, then Import Scores.
   4. Browse Files: choose your downloaded file.
   5. Format: CSV. The first row holds the headings.
   6. Match the columns: student number is Student Number, the score is Score. (Check on your screen)
   7. File Score Type: the same as the assignment (points or percent). (Check on your screen)
   8. Turn on Validate Student Names if available. Click Next; open any alert icon.
   9. Choose whether to keep or overwrite existing scores. (Check on your screen)
   10. Click Import, then open the Scoresheet.

   Check the result

   1. Gear → Export Score Template, including scores. (Check on your screen)
   2. Compare with your originals: a high score, a low score, a blank and every changed row.
   3. Min Entry marks scores your school’s minimum-score policy may have raised. Check those scores.
   4. If scores differ, stop. Do not import again. Check class, assignment, reporting term and import settings.

   Ready when: scores match your originals, including blanks and zeros.

A live PowerTeacher Pro import is not yet verified. The Simple CSV import has not been tried in a live PowerTeacher Pro import. Test one assignment and check every result before using it for more classes.