Stop 4

The Data Lab

Where the spreadsheet finally explains itself

Attendance, budgets, enrollment, survey results, assessment summaries. Copilot in Excel answers questions about a table in plain language, builds formulas you'd have to look up, and highlights patterns worth a closer look. Use aggregate and de-identified data here — Copilot is a thinking partner, not a place to paste student records.

Example 01

Ask questions of your data

Instead of building a pivot table, ask the question. Copilot can sort, filter, highlight, and explain what it found in the table in front of you.

Try this — as a…

Task: tell me where my class as a whole struggled on this unit check. Persona: act as an instructional coach. Format: a short list of the three weakest standards with the percent correct, plus one reteach idea each. Audience: me. Tone: constructive. Context: the de-identified score summary in this sheet, by question and standard — do not reference individual students.

Copilot in Excel →

Example 02

Formulas, clean-up, and what-if

Ask for the formula you can never remember, clean a messy export, or model a change before you commit to it.

Try this — as a…

Task: build a formula that calculates a weighted term grade. Persona: act as a spreadsheet expert. Format: the formula, plus one sentence explaining each part. Audience: me — I'm comfortable in Excel but not with nested functions. Tone: instructional. Context: column C is classwork at 40 percent, D is assessments at 50 percent, E is participation at 10 percent.

Formulas with Copilot →