All how-to topics

Several assignments from a spreadsheet

Copy a Google Sheets or Excel gradebook with one column per assignment, and paste every column in one go.

Steps

  1. Put one student per row, with the name in the first column (or last and first name side by side) and one column per assignment.

  2. Give each assignment column its own title in a header row, like Quiz 1 or Lab 4. Put the points it's out of in the title, like Quiz 1 (10) or Lab 4 /20, or add a Points possible row under the header.

  3. Select the whole table, header row included. In Google Sheets, right-click and choose Copy Grades with GradeBridge, or open GradeBridge and click Copy grades. In Excel, press Ctrl+C (⌘+C on Mac).

  4. From Google Sheets, a list of the assignments appears on the page with every one ticked. Untick any you don't want and confirm.

  5. In PowerSchool, open the scoresheet for the same class and click Paste grades. If you copied from Excel, switch the paste section to Clipboard first.

  6. One combined preview shows every assignment with the PowerSchool column GradeBridge picked for it. Change any column, then paste.

Example

Student         Quiz 1 (10)   Lab 4 (20)   Unit 2 Test (50)
Rivera, Ana     9             18 late      46
Chen, Marcus    #N/A          missing      41
Okafor, Jade    10            17           44
Class average   9.5           17.5         43.7

A sample sheet: three assignments, one Missing tag, an #N/A that is skipped and a class average row that is ignored. Sample names.

Good to know

  • Each column title becomes the assignment name, and GradeBridge uses it to pick the matching PowerSchool column.
  • Titles like Quiz 1 (10), Quiz 1 /10, Quiz 1 out of 10, Quiz 1 (max 10) or 10 pt Quiz give the out of. So does a row labeled Points possible, Max points or Out of above the students. If a score is higher than the out of, that column is read as percents and the preview says so.
  • Columns for student ID, email, dates, period, comments or notes are ignored, and so are Average, Total and other summary rows.
  • Spreadsheet errors like #N/A and #DIV/0! are skipped and listed in the preview, never pasted as 0.
  • Columns titled only Total, Score or Percent don't count as assignments. If two columns have the same title, or only one column has a title, GradeBridge copies a single assignment instead.
  • Decimals like 0.85 with no out of: GradeBridge asks whether to read them as percents. Decimal commas like 8,5 are read as 8.5.
  • Type Missing, Late, Exempt, Absent or Incomplete in a score cell to set that tag, as with a single assignment.
Google Sheets to PowerSchool with GradeBridge →

Related