All how-to topics

The scoresheet clipboard format

A simple text layout for pasting many assignments at once from the clipboard.

Steps

  1. Start with a line that begins #GB-SCORESHEET v1, then a tab, a class key, a tab and the class name.

  2. Next, a line starting Student with one assignment title per column. Use the same names as in PowerSchool when you can.

  3. Optionally add #max (points per column), #due (due dates) and #id lines.

  4. Then one line per student: name, then a cell per assignment. Separate everything with tabs.

  5. Copy it, choose Clipboard on the PowerSchool scoresheet and paste.

Example

#GB-SCORESHEET v1	class-p3	Biology P3
Student	Cell Quiz	Lab 4	Unit 2 Test
#max	10	20	50
Rivera, Ana	9	18 late	46
Chen, Marcus		0 missing	41
Okafor, Jade	10	incomplete	

Columns are separated by tabs. Sample data.

Good to know

  • A blank cell means nothing to paste: the PowerSchool cell is left exactly as it is, in Sync and Replace.
  • A cell can hold a score, tags (missing, late, incomplete, absent, exempt, collected), or both, like “80 late”.
  • Without #max, cells are read as percents. Scores are converted to each PowerSchool column's points.
  • Cells GradeBridge can't read are skipped and listed; the rest of the row still pastes.

Related