This guide is restricted to dashboard admins. Sign in with your Brentwood work Google account to view it.
What this dashboard does, who can see what, and exactly how to control every part of it. No technical background needed.
This is a living dashboard for the IT department — a running record of the metrics we track every year (tickets, network infrastructure, digital literacy scores, etc.) and the achievements we log every few months. It's meant to be shown to staff and leadership, and it's built to keep growing: new years, new metrics, and new achievement reports get added right in the browser, with nothing to install and nothing that needs a developer going forward.
Anyone with the link can view the dashboard — no login required. Editing is restricted to a small list of admin accounts (see Adding/removing admins). A visitor who isn't an admin simply sees the data with no edit controls anywhere on the page.
Once signed in, a small Edit mode switch appears in the top-right. Flip it on and the whole page becomes editable: chart bars, titles, the metrics table, and the achievements list all light up with edit controls. Flip it off and the page goes back to a clean, read-only view — useful when you want to show it to someone without any edit clutter visible.
The four stat tiles at the top show the headline numbers, each with a small trend line and a colored arrow comparing it to the year before. A "Viewing year" dropdown appears above them once there are two or more years of data — pick any past year to see what the tiles looked like at that point in time.
Which metrics appear here (and whether an arrow is green or red for going up) is controlled per metric in the Full Metrics Table — look for the KPI tile? checkbox and Trend dropdown on each row.
Below the KPI tiles, every metric gets its own smooth line chart across all years, grouped by category, with a soft gradient fill underneath and small numbers on the left showing the highest and lowest value on that chart.
These mark the best and worst year for that metric — decided automatically from the "Trend" setting (Higher is better / Lower is better) on that row in the table. Hover the dot to see it spelled out ("— best year" / "— worst year"). Metrics marked "Neutral" (like raw ticket counts, where more isn't necessarily good or bad) never get colored — that's intentional, not a bug.
If a year has no data, the line still connects straight across it (so the chart doesn't look broken into disconnected fragments), but that year keeps its own small gray dot and an honest "No data" on hover — it's never faked or interpolated as a real value.
Staff Literacy Score and Student Literacy Score are overlaid as two colored lines on a single chart with a legend, since they share the same 0-10 scale. This is driven by the "Combine as" column in the Full Metrics Table — give two metrics the exact same text there (only when they're genuinely on the same scale/unit) and they merge into one chart.
Hovering any dot pops up the exact year and value. In Edit Mode, clicking a dot lets you type in a new value for that year directly — no need to open the table for a quick fix.
Click "Show table" on the Full Metrics Table card (it opens automatically once Edit Mode is on) to see and edit every number at once.
Click "+ Add Year Column" and type the year. You shouldn't usually need this — every January the dashboard automatically adds the new calendar year as a blank column the next time an admin loads the page.
Click "+ Add Report", pick the date, type the first achievement, and click Create. Once it exists, click "+ Add bullet" on that card to keep adding more, or click directly into any bullet's text to edit it, or the ✕ to remove one.
Click "Import from text" and paste a block of text where each report starts with a line in exactly YYYY-MM-DD format, followed by one achievement per line, e.g.:
2026-04-10 Deployed Vivi across all classroom displays Resolved 6,122 support tickets 2026-02-17 Secured Apple Distinguished School status ...
A small grid above the timeline shows how many achievements were logged each month, going darker red the more that were logged. It's a year-by-month grid rather than a day-by-day one, since reports land every couple of months, not daily — a daily grid would just be hundreds of empty squares with a handful of dots in it. Hover any square to see the exact count for that month. It only appears once at least one achievement report exists.
In Edit Mode, a small ✏️ pencil appears next to every piece of page text: the topbar name and its subtitle, the big page heading and its subheading, the Achievements Timeline heading and its subheading, and the footer. Click any pencil, type the new text, and it saves instantly. That's the only place to edit that text — there's no second copy of these settings hiding anywhere else.
Click "Dashboard Settings" next to the Edit Mode switch for everything that doesn't live directly on the page:
Just the browser tab title lives here — the one piece of text with nowhere on the page to put a pencil next to it.
Choose what year the KPI tiles should show the moment anyone opens the dashboard, instead of always defaulting to the newest year with data.
Inside Dashboard Settings, the Admins section lists everyone who can currently sign in and edit.
In Dashboard Settings, this downloads every metric and achievement to a file on your computer — a safety copy that exists independent of the website, in case you ever want an offline record.
The other half of the button above — pick a backup file you downloaded earlier and it restores the whole dashboard to that point: every metric, every achievement, and the site-info text. It shows you what's in the file (date, counts) and asks you to confirm first, since this replaces everything currently live.
Every time a title/text is changed (via a pencil or the browser tab title field), the previous version is automatically saved here first. Open the History tab in Dashboard Settings to see every past version with a timestamp, and click Restore to bring one back — restoring also saves whatever's currently live first, so you can never lose a version by going backward. This is separate from the file-based backup above and only covers headings/titles/footer text, not metrics or achievements.
In Dashboard Settings, under Print / Export, click Print dashboard… to open your browser's print dialog with a condensed, presentation-ready version of the page — just the heading, KPI tiles, and trend charts. The topbar, admin controls, Full Metrics Table, Achievements Timeline, heatmap, and footer are all left out, and dark mode is forced back to a light, ink-friendly layout regardless of what theme you're viewing in.
No — a brand-new year gets added automatically as a blank column each January, and it stays blank until someone fills in real numbers. The headline number up top still shows the most recent year that actually has data.
On narrow screens, Edit mode / Dashboard Settings / Sign out collapse behind a "⋮" button in the topbar instead of being crammed in as separate buttons. Tap it to open the same controls in a dropdown; tap anywhere else to close it. Desktop is unaffected.
No — once you're an admin, everything in this guide is something you can do yourself, directly in the browser, with nothing to install.
No. Anyone who isn't a signed-in admin sees a completely read-only page — there's nothing for them to click that changes anything.