How to use Mario Kart to teach spreadsheets
Modelling Mario

Context
As part of the WJEC GCSE ICT controlled assessment, students are expected to create a spreadsheet to enable a club manager to work out who has the most points for different categories. The results of this are used to decide who receives the trophies at the club’s presentation evening.
In the following series of lessons, students will take it in turns to complete Time Trials around a specified circuit using Mario Kart on the Nintendo Wii. The students will compile the raw data generated by the class and input these into a suitable spreadsheet. The students will then use basic and advanced skills to improve the look and functionality of the spreadsheet (This will be based on the assessment criteria for the controlled assessment).
As part of the WJEC GCSE ICT controlled assessment, students are expected to create a spreadsheet to enable a club manager to work out who has the most points for different categories. The results of this are used to decide who receives the trophies at the club’s presentation evening.
In the following series of lessons, students will take it in turns to complete Time Trials around a specified circuit using Mario Kart on the Nintendo Wii. The students will compile the raw data generated by the class and input these into a suitable spreadsheet. The students will then use basic and advanced skills to improve the look and functionality of the spreadsheet (This will be based on the assessment criteria for the controlled assessment).
Lesson 1

mario_lesson_1.pdf | |
File Size: | 303 kb |
File Type: |

Mario_Starter.xls | |
File Size: | 720 kb |
File Type: | xls |
Task Sheets

Modelling_Mario_Task_Sheet.pdf | |
File Size: | 709 kb |
File Type: |

Investigating_Mario_Extension_Task.pdf | |
File Size: | 47 kb |
File Type: |
Example Model

Modelling_Mario_Example.xls | |
File Size: | 513 kb |
File Type: | xls |
Resources
Resources for this task.

Modelling_Self_Assessment_Sheet.xls | |
File Size: | 34 kb |
File Type: | xls |

Record_Sheets.pdf | |
File Size: | 204 kb |
File Type: |

Mario_Images.zip | |
File Size: | 1219 kb |
File Type: | zip |
Help Guides
Help guides for this task (Note: Help guides currently only available for Excel 2007)

Creating_Graphs.pdf | |
File Size: | 180 kb |
File Type: |

Creating_the_menu_page.pdf | |
File Size: | 290 kb |
File Type: |

VLookuUp_Help.pdf | |
File Size: | 160 kb |
File Type: |
Lesson 2![]()
Starter![]()
![]()
|