PREMIUM LOGIN

ClassTools Premium membership gives access to all templates, no advertisements, personal branding and other benefits!

Username:    
Password:    
Submit Cancel

 

Not a member? JOIN NOW!  

QR Challenge: Excel Review

Created using the ClassTools QR Treasure Hunt Generator

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

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. What formula would you use to find the total?=Sum
2. How do you identify a row?By the numbers
3. What does your mouse look like when you want to copy something?black cross
4. What formula would you use to find the average of a range of cells?=Average
5. Name one example of a cell referenceF4
6. How do you subtract one number from another number in a spreadsheet?=b7=b11
7. What formula do you use to find the highest number in a range of cells?=max
8. What does your mouse look like if you wanted to adjust your column size?two headed black arrow
9. What is it called when we combine a range of cells?Merge and Center
10. What formula would you use to find the smallest number in a range of cells?=Min
11. How do you identify a column?Letters
12. All formulas must begin with an...Equal Sign
13. What ribbon would I click on to find a column chart?Insert
14. What is the intersection between a column and a row called?Cells
15. What does my mouse look like if I wanted to select a range of cells?White cross

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=What_formula_would_you_use_to_find_the_total?

Question 1 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=How_do_you_identify_a_row?

Question 2 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=What_does_your_mouse_look_like_when_you_want_to_copy_something?

Question 3 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=What_formula_would_you_use_to_find_the_average_of_a_range_of_cells?

Question 4 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=Name_one_example_of_a_cell_reference

Question 5 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=How_do_you_subtract_one_number_from_another_number_in_a_spreadsheet?

Question 6 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=What_formula_do_you_use_to_find_the_highest_number_in_a_range_of_cells?

Question 7 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=What_does_your_mouse_look_like_if_you_wanted_to_adjust_your_column_size?

Question 8 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=What_is_it_called_when_we_combine_a_range_of_cells?

Question 9 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=What_formula_would_you_use_to_find_the_smallest_number_in_a_range_of_cells?

Question 10 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=How_do_you_identify_a_column?

Question 11 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=All_formulas_must_begin_with_an...

Question 12 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=What_ribbon_would_I_click_on_to_find_a_column_chart?

Question 13 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=What_is_the_intersection_between_a_column_and_a_row_called?

Question 14 (of 15)

 



Excel Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=What_does_my_mouse_look_like_if_I_wanted_to_select_a_range_of_cells?

Question 15 (of 15)