Build it once, grade it as it comes in, see the whole year.

Prism is a Google Sheets add-on for teacher teams that builds your common assessment as a Google Form, grades it as students submit and puts the results on a live data wall. Here is each part of it in more detail, from the first question you write to the wall your principal opens.

Build once, reuse next year.

Write your questions in the Question Builder, tag each one with its standards, and Prism makes the Google Form and the tabs that grade it. Every assessment you or a teammate builds goes into your assessment bank, so next year’s test can start from this year’s.

  • Three item types. Short answer, multiple choice and checkboxes. A short answer can accept several right answers and check their format: rational number, ratio or currency.
  • Standards search. Search by code or description and tag a question with one or more standards.
  • The assessment bank. One row per assessment: title, school year, who built it, its questions, standards and versions. It holds no student names, emails or scores.
  • Start from a previous one. Pick an assessment from the bank and its questions, standards and modified versions come with it. Responses, scores and the old Form never do.
How to build an assessment

One assessment. Every student. One wall.

Some students take a modified or accommodated version of the test. Build the assessment once, add up to three versions, assign students privately, and everyone lands on the same wall.

  • Modify, don’t duplicate. Drop a question, trim the answer choices, reword a prompt. Everything else stays tied to the original, so a fix to the answer key reaches every version.
  • Private by design. Each version has its own link, and students only ever see the assessment title. The version name is never shown to them.
  • Scored fairly, aligned on the wall. Every student is scored out of the questions on the version they took. A modified question keeps its number and standards, so Q7 is Q7 for the whole team, with a Version filter when you want a closer look.
How to add a modified version
Prism · Unit 3 Ratios: Post-Test
Versions142 students assigned
Standard118 students · 20 questions Copy link
Modified A14 students · 15 questions · 5 removed Copy link
Modified B10 students · 20 questions · 3 choices each Copy link
Add a modified version
Students seeUnit 3 Ratios: Post-Test — the same title on every version, never the version name.
Up to three versionsStandard plus up to three modified versions per assessment, each with its own Google Form and its own link.
Built for IEPs and 504sSort the roster so students with a plan on file come first when you assign versions.
Wrong link? No lost workA student who opens the wrong version is graded on what they submitted, and Prism flags it so you can reassign or let them retake.

Fix it after it’s live.

Found a wrong answer key after first period took the test? Open Edit Assessment from the Launchpad, make the change in the same Question Builder you built it with, and save. Prism updates the live Form and regrades, so the wall shows the corrected scores.

  • Change any question. Its prompt, answer choices, correct answers, answer format, standards or bonus setting.
  • Add or drop questions. New questions go at the end. Dropping a question also removes students’ answers to it, and Prism warns you before it does.
  • Versions follow. The change reaches the Standard Form and every modified version’s Form, with no separate copies to fix.
  • Past submissions are regraded. Answers already in are scored against the new key, and scores typed on the Manual Entry tab for the questions you kept stay put.
How to edit an assessment

One roster for the whole year.

Paste your roster into one roster file and tell Prism which column is which, once. Every assessment you create copies it, along with any student flags you add.

  • One file per school year. Your roster file sits in that year’s folder. When you start a new school year, your column choices come with you.
  • IEP, 504, ELL and DNQ flags. Paste your flags report into the Flags tab to filter the wall by them. Other codes are ignored, and plan details are never copied.
  • Refresh on demand. When the roster changes mid-year, click Refresh roster & flags in an assessment to bring in the current roster and rescore.
  • Counts you can check. The sidebar shows how many students and flags Prism found, and updates when you edit either tab.
How to set up your roster

A data wall that keeps up.

Each assessment connects to its own Data Studio wall, which updates as responses are graded. Connect a pre, mid and post test and you get a growth wall that shows how far each student moved.

  • Single-assessment and growth walls. One test across every teacher, or Pre, Mid and Post on one wall. Connecting assessments is included with a Prism license.
  • Tiers on your scale. Each student lands in a tier as their score arrives, on a three-, four- or five-tier wall.
  • Click to filter. Click a tier, a teacher or a wrong answer and the rest of the wall follows. Filter by IEP, 504, ELL or DNQ too.
  • Standards in words. Hover a standard in the heatmap or the toughest-standard tile to read its full description.
Loading the wall…

Sample data only: the students, teachers and scores are invented. In your district the same wall runs in Data Studio on your own assessments, and switches pages with the tabs in its title bar.

How to make your data wall

Every student’s answers, ready to print.

Click Score Report on the Launchpad and choose how to group your students. Prism adds a tab for each group to the assessment file, listing every student’s score, tier and answer to each question, marked right or wrong.

  • One tab per group. Group by homeroom, by teacher, by both, or put everyone on one tab.
  • Right and wrong at a glance. ✓ on green for a right answer, ✗ on red for a wrong one, ◐ on yellow for partial credit, with the answer key under the header.
  • Always current. Prism updates the tabs on every grading run, so a report is right minutes after a student submits.
  • Prints from Sheets. The report is ordinary tabs in your assessment Sheet, so you can print or download it like any other tab.
Find it on the Launchpad

The whole year on one wall.

Each grade and content area names its big rocks, the few standards that matter most this year. A Year Overview gathers their results from your teams’ growth sheets into one wall for the building or the district.

  • Big rocks. Add each one with its grade, content area, standard and the month it is planned. One that isn’t linked yet says so instead of showing a zero.
  • Building or district. A district Year Overview links each building’s and rolls them up, carrying only summary data.
  • Minimum group size. The overview holds counts and averages, never student rows, and a group smaller than the minimum group size (five by default) shows no figures.
  • Click for growth. Click a card for its tiers by stage, growth by teacher and how students moved between tiers. Year Overview is included with a Prism license.
Loading the Year Overview…

Sample data only: an invented school, with made-up standards and scores.

How to make a Year Overview

Made for a team, not one teacher.

A team shares one Prism folder: one roster file for each school year and one assessment bank. Everyone creates assessments from the same roster and can reuse anyone’s.

  • Share one folder. One person sets up Prism and shares the top-level Prism folder with the team as editors.
  • Nothing to set up for teammates. They open the team’s roster file and launch Prism. The columns are already mapped.
  • A one-time step. The first time, each teammate picks the team’s roster file and assessment bank so Prism can use them. Each new school year’s roster file is picked once more; the bank never needs picking again.
  • One bank for everyone. Every assessment anyone builds goes into the shared bank, with who built it. Anyone can start the new school year for the whole team.
How to work as a team

Your next PLC could start with the wall already up.

Book fifteen minutes. I'll build an assessment from your standards while you watch, and you'll see the wall fill in as the answers come in. Bring a department head if you can; they're the ones who stop asking "did everyone get theirs in?"

Nothing to install for the demoIt's a screen share. You'll see your own standards in the assessment.
Priced for a PLC, a school or a districtQuotes come from the person who built it, usually the same day.
Your data stays yoursRosters, responses and scores live in your Google Workspace, nowhere else.