📊 Stop guessing who to pull for small group. This Teacher Data Dashboard reads your Math Quest game data and instantly tells you which students need help, on which standard, and how urgently — sorted, color-coded, and ready for action. One click to refresh. Zero manual data entry.

★ THE PROBLEM THIS SOLVES ★

You run Math Quest during your review period. Your Google Sheet fills with student data — accuracy rates, time played, mentor views, realms cleared. But raw spreadsheet data is hard to read. You don't have time to sort, filter, and calculate averages for 28 students across 8 standards every day.

This dashboard does it for you. One click, and you see:

✅ Which standards have the lowest class-wide accuracy

✅ Which students to pull for small group — sorted by weakest standard

✅ Whether each student needs HIGH or MEDIUM priority support

✅ A color-coded heat map of every student across every realm

✅ Class KPIs: average accuracy, time played, mentor views, completions

You go from raw data to actionable small groups in 10 seconds.

★ WHAT YOU GET: 4 DASHBOARD TABS ★

📋 TAB 1: CLASS OVERVIEW (Dashboard)

The "at a glance" tab. Open it, see your whole class in one view.

• 6 KPI boxes — total students, average accuracy, average time played, total mentor views, quests completed, average realms cleared

• Standards accuracy table — all 8 standards with class-wide average accuracy, total attempts, mentor views, students cleared, and a color-coded status label (Strong / Developing / Needs Focus)

• Student roster — every student sorted by accuracy (lowest first) with overall accuracy, realms cleared, XP, time played, mentor views, and their weakest standard

The students who need the most help are always at the top of the list.

📋 TAB 2: STUDENT PROFILES (Heat Map)

The "who needs what" tab. A grid of every student across every realm.

• Color-coded cells — Green (80%+ Strong), Yellow (60-79% Developing), Red (below 60% Needs Focus), Gray (Not Attempted)

• Frozen name columns — scroll right through all 8 standards while names stay visible

• Weakest standard column — instantly see which realm each student struggles with most

• Overall accuracy with bold color coding

When you see a row full of red cells, that student needs intensive support. When you see one red cell in a mostly green row, that student needs targeted reteaching on one specific standard. The heat map makes both patterns visible in seconds.

This is the tab to open during parent conferences. The color coding makes it immediately visual — no explanation needed.

📋 TAB 3: SMALL GROUPS (Auto-Sorted)

The "who do I pull today" tab. This is where the dashboard pays for itself.

Students are automatically sorted into groups by their weakest standard:

• Under "Decimal Swamp — 5.NBT.7" you see every student whose weakest area is decimal operations

• Under "Division Dungeon — 5.NF.7" you see every student struggling most with fraction division

• Under each realm header, students are tagged:

→ HIGH priority = this is their absolute weakest standard

→ MEDIUM priority = below 70% accuracy but not their worst

Each group shows the student's real name, hero name, realm accuracy, overall accuracy, and mentor views for that specific realm.

Your daily workflow becomes: Refresh dashboard → Open Small Groups tab → Read the names under today's target standard → Pull those students → Reteach for 10 minutes. That's it. No filtering. No sorting. No guessing.

📋 TAB 4: STANDARDS ANALYSIS (Priority Ranked)

The "what do I reteach next" tab. Standards are ranked by class-wide accuracy, lowest first.

• Priority numbered #1 through #8

• Automatic action labels based on class accuracy:

→ RETEACH WHOLE CLASS (below 60%) — red, urgent

→ SMALL GROUP FOCUS (60-69%) — yellow, targeted

→ MONITOR (70-79%) — blue, watch

→ ON TRACK (80%+) — green, no action needed

• Below 60% count — how many students are struggling per standard

• Above 80% count — how many have mastered it

• Quick Summary at the bottom: how many standards need reteaching, which is lowest, which is highest

This tab drives your weekly planning. On Monday, check which standards are red. Plan your warm-ups and small groups around those standards for the week.

★ HOW IT CONNECTS TO THE GAME ★

Students play Math Quest → Game auto-saves data to your Google Sheet → You click "Refresh Dashboard" → 4 tabs rebuild with live data → You make instructional decisions based on real evidence.

The dashboard reads from the Progress tab that the game creates. It never modifies your data. It only reads and displays.

★ HOW SMALL GROUP INSTRUCTION WORKS WITH THIS DATA ★

Here's a realistic example of what your daily small group looks like with the dashboard:

1. Students play Math Quest for 20 minutes (individual, self-paced)

2. While they play, you open the Dashboard and click Refresh

3. You check the Small Groups tab: 4 students are tagged HIGH under Decimal Swamp (5.NBT.7) — Maya, Sam, Evan, and Noah all have accuracy below 50%

4. You also check their mentor views: Maya has 12 mentor views on decimals — the game has been teaching her, but she needs face-to-face support

5. You pull those 4 students. You spend 10 minutes working through 2-3 decimal problems together on a whiteboard

6. Tomorrow, those students play Decimal Swamp again. Their accuracy improves. The dashboard reflects the change on the next refresh

That cycle — play, check data, pull group, reteach, check again — is the most effective use of your 40-minute math block during review season. The dashboard makes the "check data" step take 10 seconds instead of 10 minutes.

★ SETUP (5 MINUTES) ★

1. Open your Math Quest Google Sheet (the one with the Progress tab)

2. Go to Extensions > Apps Script

3. Add a new script file called "Dashboard"

4. Paste the Dashboard.gs code

5. Run setupDashboard() once to authorize

6. A "Math Quest Dashboard" menu appears in your Sheet

7. Click it > Refresh All Dashboard Tabs

8. Done. 4 new tabs appear with your live data.

★ COLOR CODING LEGEND ★

The same color system across all 4 tabs:

🟢 Green = 80%+ accuracy (Strong — no intervention needed)

🟡 Yellow = 60-79% accuracy (Developing — monitor or small group)

🔴 Red = below 60% accuracy (Needs Focus — pull for reteaching)

⬜ Gray = Not Attempted (student hasn't reached this realm yet)

★ WHAT THIS PRODUCT INCLUDES ★

• Dashboard.gs — one script file to paste into your existing Apps Script project

• 4 auto-generated tabs: Dashboard, Student Profiles, Small Groups, Standards Analysis

• Custom "Math Quest Dashboard" menu in your Sheet for 1-click refresh

• Complete README with setup instructions, daily usage workflow, and FAQ

• Color-coded heat map, auto small groups, priority-ranked standards, KPI summary

**You can open the gs file with the following apps to copy the code easily:

• Windows: Notepad, Notepad++, VS Code.
• Mac: TextEdit, TextMate, VS Code.

★ REQUIREMENTS ★

• Math Quest: Complete End-of-Year Review (the game that generates the data)

• Google Sheets (the game's Google Sheet with a Progress tab containing student data)

• 5 minutes of one-time setup

This dashboard is an add-on for the Math Quest game. It reads the data the game saves. If you don't have Math Quest yet, visit our store to get the full game or try the free Fraction Forest demo first.

★ FREQUENTLY ASKED QUESTIONS ★

Q: Do I need to enter any data manually?

A: No. The dashboard reads directly from the Progress tab that the game fills automatically. You never type a single number.

Q: How often should I refresh?

A: Before each small group session. The game updates the Sheet in real-time as students play. The dashboard tabs recalculate when you click Refresh.

Q: Will refreshing erase my data?

A: No. The 4 dashboard tabs rebuild from scratch each time, but your Progress tab (the raw data) is never touched.

Q: Can I use this with multiple class periods?

A: Yes. All students appear together. Use a naming convention like "P1-Emma" or "P3-Luis" in the game's real name field, then use Google Sheets' built-in filter to view one period at a time.

Q: Can I edit the dashboard tabs?

A: You can, but changes will be overwritten on the next refresh. Add notes in a separate tab.

Q: Does this work with the free demo version of Math Quest?

A: Yes, but the free demo only has 1 realm, so the dashboard will show data for Fraction Forest only. The full value comes with the complete game (all 8 realms).

Q: What if no students have played yet?

A: The dashboard will show a message saying "No student data found." Once students start playing, the data appears.

♥ If this dashboard saves you time during review season, please leave a rating and review! Your feedback helps other teachers discover this resource.