QR Challenge: So you think you know Spreadsheets?
Teacher Notes
A. Prior to the lesson:
1. Arrange students into groups. Each group needs at least ONE person who has a mobile device.
2. If their phone camera doesn't automatically detect and decode QR codes, ask students to
- Download a QR reader (e.g. I-Nigma | NeoReader | Kaywa) onto their mobile devices
- Bring these devices into the lesson.
3. Print out the QR codes.
4. Cut them out and place them around your class / school.
B. The lesson:
1. Give each group a clipboard and a piece of paper so they can write down the decoded questions and their answers to them.
2. Explain to the students that the codes are hidden around the school. Each team will get ONE point for each question they correctly decode and copy down onto their sheet, and a further TWO points if they can then provide the correct answer and write this down underneath the question.
3. Away they go! The winner is the first team to return with the most correct answers in the time available. This could be within a lesson, or during a lunchbreak, or even over several days!
C. TIPS / OTHER IDEAS
4. A detailed case study in how to set up a successful QR Scavenger Hunt using this tool can be found here.
Questions / Answers (teacher reference)
Question | Answer |
1. 1. Who has the highest average? | A
|
2. 2. Who finished last – a girl or a boy? | A
| 3. 3. Which 2 people have the same average? | A
| 4. 4. Who got the lowest score in any attempt? | A
| 5. 5. Who got the highest lowest score? | A
| 6. 6. Which Attempt has the highest score? | A
| 7. 7. Whose highest and lowest score is the same? | A
| 8. 8. Which Attempt had the lowest average | A
| 9. 9. Which attempt had the highest score? | A
| 10. 10. Which attempt had the lowest score? | A
| 11. 11. Who has the lowest average – boys or girls? | A
| 12. 12. Which IT class has the highest average and what is the average? | A
| 13. 13. How many people scored a “Hopeless” rating? | A
| 14. 14. How many people scored an “OK” rating? | A
| 15. 15. Which comment only appears once? | A
| 16. 16. What is the difference in percentage between the boys and girls average? | A
| 17. 17. Who finished 17th? | A
| 18. 18. How many girls in the top 10? | A
| 19. 19. How many “complete” badges have been won by each IT Class | A
| 20. 20. How many different functions were used in the spreadsheet? | A |
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=1. Who_has_the_highest_average?
Question 1 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=2. Who_finished_last_–_a_girl_or_a_boy?
Question 2 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=3. Which_2_people_have_the_same_average?
Question 3 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=4. Who_got_the_lowest_score_in_any_attempt?
Question 4 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=5. Who_got_the_highest_lowest_score?
Question 5 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=6. Which_Attempt_has_the_highest_score?
Question 6 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=7. Whose_highest_and_lowest_score_is_the_same?
Question 7 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=8. Which_Attempt_had_the_lowest_average
Question 8 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=9. Which_attempt_had_the_highest_score?
Question 9 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=10. Which_attempt_had_the_lowest_score?
Question 10 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=11. Who_has_the_lowest_average_–_boys_or_girls?
Question 11 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=12. Which_IT_class_has_the_highest_average_and_what_is_the_average?
Question 12 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=13. How_many_people_scored_a_“Hopeless”_rating?
Question 13 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=14. How_many_people_scored_an_“OK”_rating?
Question 14 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=15. Which_comment_only_appears_once?
Question 15 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=16. What_is_the_difference_in_percentage_between_the_boys_and_girls_average?
Question 16 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=17. Who_finished_17th?
Question 17 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=18. How_many_girls_in_the_top_10?
Question 18 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=19. How_many_“complete”_badges_have_been_won_by_each_IT_Class
Question 19 (of 20)
So you think you know Spreadsheets?: QR Challenge
https://www.classtools.net/QR/decode.php?text=20. How_many_different_functions_were_used_in_the_spreadsheet?
Question 20 (of 20)