How do you mail-merge gradebook rows into student feedback slips?
Drop your .csv, .tsv, or .xlsx rubric sheet (or paste copied cells), set Assignment title and Course / section, choose 4-up, 2-up, 1-up, or ZIP of separate 1-page PDFs, and export. No Microsoft Word <<MergeField>> codes or Google Workspace add-ons are needed.
Every slip is drawn in device-independent PostScript points (72 points per inch) following the Library of Congress PDF digital format specification using embedded Helvetica and HelveticaBold fonts. Before scoring essays or lab notebooks in a spreadsheet, you can design matching weighted classroom rubric grids and descriptors so students know exact performance expectations upfront.
| Handout format option | Cards per sheet | Header & body type scale | Cut guide lines | Ideal classroom workflow |
|---|---|---|---|---|
4-up quarter-page cut slips |
4 (2 × 2) |
8.5 pt head / 7.8 pt |
Horizontal + vertical [4, 3] |
4–6 rubric rows + concise exit-ticket note |
2-up half-page detailed slips |
2 (1 × 2) |
10.5 pt head / 9.0 pt |
Center horizontal [4, 3] dash |
7–12 criteria + multi-sentence essay coaching |
1-up full page per student |
1 (combined) |
10.5 pt head / 9.0 pt |
None (32 pt full margins) |
Staple-on capstone cover sheets and parent folders |
ZIP of separate 1-page PDFs |
1 PDF per file |
10.5 pt head / 9.0 pt |
None (1 student per file) |
Individual digital uploads in LMS assignment boxes |
US Letter vs A4 paper geometry |
612 × 792 pt |
A4: 595.28 × 841.89 |
Automatic midpoint centering | North American 8.5 × 11 in or ISO 210 × 297 mm |
Mapping spreadsheet headers to rubric criteria, totals, and comments
Setting up traditional word-processor mail merges breaks whenever column names change between Unit 1 and Unit 2. This student feedback slip generator inspects your top header row dynamically and routes each column into a dedicated typographic zone on the card.
Formatting Student ID, Total Score badges, and comment columns
Inside parseFeedbackStudents, the first column matching student, name, or learner anchors the card subtitle alongside any optional Student ID or SIS column in parentheses. A column titled Total, Overall, Final Score, Grade, or Score renders as a right-aligned bold Score: badge inside the shaded header band.
Any column header containing comment, feedback, note, strength, or next step flows into a multi-line word-wrapped paragraph at the bottom of the box. Every remaining populated column becomes a bold left-aligned criterion row with a 0.4 pt divider rule, keeping student records local in alignment with the U.S. Department of Education FERPA student privacy FAQ.
Pasting Google Sheets tabs vs importing CSV and XLSX files
When grading collaboratively in Google Sheets or Microsoft Excel, you do not even need to export a file to disk. Copy your header row plus student rows straight into the monospace Import gradebook spreadsheet or paste CSV / TSV rows editor, or click Switch to text editor at any time after testing an uploaded file.
If your rubric points live in one workbook and formative quiz totals live in another, merge Canvas and Kahoot gradebook exports first to build one master table. LMS summary rows such as Points Possible, Overall Average, and Test Student are ignored automatically during import.
Choosing between 4-up quarter slips, 2-up cards, and full-page PDFs
Paper consumption matters when teaching 120 to 150 students across five class periods. Selecting the right Handout format balances copier sheet count against how many rubric rows and narrative comments each assignment carries.
Paper-saving 4-up and 2-up handouts with dashed cut guides
Choosing 4-up quarter-page cut slips (print & slice) places four bordered cards (28 pt tinted header, 12.5 pt row spacing) onto each US Letter (612 × 792 pt) or A4 (595.28 × 841.89 pt) page. Printing 32 students takes 8 sheets of copier paper, with 0.6 pt dashed crosshairs ([4, 3] dash pattern) marking exact midpoint guillotine cuts.
For AP writing prompts, lab investigations, or seminar critiques with longer narrative feedback, switch Handout format to 2-up half-page detailed slips. Each half-sheet card expands header height to 36 pt, widens criterion spacing to 16 pt, and steps comment text up to 8.8 pt for comfortable reading alongside returned custom OMR multiple-choice bubble answer forms.
Full-page 1-up score sheets for multi-criterion projects
Selecting 1-up full page per student (single PDF) gives every learner a dedicated page framed by 32 pt margins inside one multi-page print job. Single-sided printing ensures you can hand out or staple cover sheets onto physical portfolios without back-side bleed-through.
Vector PDF files for a 30-student section typically weigh 12 KB to 35 KB total and spool instantaneously on departmental laser printers. Always print single-sided when using 4-up or 2-up cut modes so slicing one student’s slip never trims into another learner’s reverse-side report.
Packaging individual student feedback PDFs into a ZIP for LMS return
Uploading a combined 30-page class PDF into a shared course folder exposes every classmate’s score. When returning grades digitally, each learner must receive an isolated file containing only their own rubric breakdown.
Generating per-student filenames for digital LMS upload
Picking ZIP of separate 1-page PDFs (LMS return) under Handout format renders a standalone 1-page PDF for each student row and compresses the batch at deflate level 6 following the Library of Congress ZIP archive format specification. Clicking Download individual student PDFs (.zip) saves <stem>-individual-pdfs.zip straight to your local downloads folder.
Inside the archive, files follow a predictable 01_<StudentID_or_Name>_Feedback.pdf naming pattern with punctuation sanitized to underscores up to 40 characters. That structure makes attaching individual score sheets to Canvas SpeedGrader comments, Moodle feedback boxes, or school emails fast and unambiguous.
Preventing peer grade exposure across US Letter and A4 sheets
All spreadsheet parsing, PDF layout, and fflate ZIP archiving run inside a dedicated browser Web Worker (edu.worker.ts) with 0 bytes sent externally. After reviewing weak criterion columns across a unit test, math teachers often print targeted seeded K-10 math drills ready for reteaching to attach right behind each student’s score card.
Tip: Put max point values inside your spreadsheet column headers, such as
Evidence (30)andReasoning (25), so students immediately see the denominator for every criterion without adding extra columns to your gradebook.