🏁 Mario Kart Data Challenge — Technology 7–8 Visual Novel

🏁
Mario Kart
Data Challenge
Technology 7–8 · Stage 4 Learning Activity
🎮
⭐
🏎️
🎨
📊
Ms Rodriguez
▼ click anywhere to continue
📗 Our Completed Spreadsheet
📗  MarioKart_TimeTrials_Group1.xlsx
Sheet1 ✓
ABC
1Student NameTime (seconds)Notes
2🎮 Jake112.34Mushroom Gorge — fastest! 🏆
3⭐ Emily123.17First time tracking lap times
4🎨 Chloe118.422nd fastest — strong finish!
5🏎️ Marcus135.08Strategist — room to improve
6Group Average=AVERAGE(B2:B5)→ 122.25 seconds
💡 Converting times to seconds makes Excel treat them as numbers — enabling averages, formulas and graphs to work correctly!
📊 Our Data Visualisation
Mario Kart Time Trial Results — Group 1 (seconds)
💡 The column graph makes it instantly clear who was fastest. For multiple trials, a line graph would reveal improvement trends over time!
📋 How This Activity Addresses the Syllabus

🔧 Technology 7–8 (2023)

Addresses key Stage 4 outcomes through authentic project work:

  • TE4-SDP-01 — Students explain relationships between design and production; recording and analysing data is core to evaluating a technology solution
  • TE4-DIG-01 / TE4-DIG-02 — Students use digital technologies (Switch, Excel) and store/share data when designing or producing project work
  • Supports the Digital & Communication Technologies focus area — students research, collect and share information using digital tools

📐 Cross-KLA: Data Representation

Directly aligns with the NSW cross-curriculum data literacy requirements (Stage 4):

  • Students record and organise data in tables with correct units (minutes → seconds conversion)
  • Students create column graphs — a core Stage 4 graphing skill across Technology, Maths and Science
  • Students interpret graphs to identify trends and compare values
  • Students use digital tools to calculate the group AVERAGE formula

🤝 Collaborative Learning & Peer Support

The group structure embeds collaborative learning design:

  • Students work collaboratively to plan and share information — a stated expectation in the Researching & Planning content
  • Peer scaffolding is modelled: Jake explains unit conversion to Emily; Marcus and Chloe receive teacher-guided instruction
  • Mixed ability grouping supports expert/novice discourse patterns naturally
  • One shared spreadsheet supports collaborative data production

💻 ICT & Digital Literacy Skills

Students develop essential digital capabilities:

  • Spreadsheet data entry, formatting and formula use
  • Chart creation, customisation (colours, labels, titles) in Excel
  • Understanding axes, scales, data labels and chart titles
  • Selecting appropriate chart types: column vs. line graph
  • Numeracy integration: unit conversion (m:ss.ms → seconds)
🤔 Three Questions for You, Teacher!
1
Would you keep groups of four, or adjust the group size based on your class dynamics and available devices?
Think about Nintendo Switch availability, screen visibility in the room, and whether you'd want more or less peer interaction built in.
2
Should the visual novel include a second scene showing a line graph across multiple trials — for example, each student doing three time trials to track their improvement?
Chloe raised this idea in the dialogue. It would deepen the data literacy content and connect to Stage 4 trend analysis.
3
Which phase of the activity would you most like the visual novel to expand on: data collection, Excel entry, graph creation, or data interpretation and analysis?
The current version touches all phases briefly. A deeper dive into one area could make this a more targeted teaching tool for your class.