All how-to topics
The scoresheet clipboard format
A simple text layout for pasting many assignments at once from the clipboard.
Steps
Start with a line that begins #GB-SCORESHEET v1, then a tab, a class key, a tab and the class name.
Next, a line starting Student with one assignment title per column. Use the same names as in PowerSchool when you can.
Optionally add #max (points per column), #due (due dates) and #id lines.
Then one line per student: name, then a cell per assignment. Separate everything with tabs.
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.