View Premium →

PREMIUM LOGIN

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

Username:    
Password:    
Submit Cancel

 

 

Not a member?

JOIN NOW!

 

QR Challenge: Chapter 7 Excel Vocabulary Terms

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. 1. The process of organizing data so that it can be viewed as a collapsible and expandable outline Hint 191grouping
2. 2. Duplicate values are Values in the row that are an exact match of all the values in another row Hint p.178 duplicate values
3. 3.Excel uses filter rules to determine which worksheet rows to display Hint p.186 filter
4. 4.In ____________, sorted values appear Z to A or highest to lowest Hint p. 180 descending order
5. 5.The __________ are conditions specified to limit which records to include in the result of a sort or filter hint p. 176criteria
6. 6.A sign used in criteria to compare two values Hint p. 189comparison operator
7. 7.Using a(n) _________ allows you to apply a built-in set of filtering capabilities Hint p. 186Autofilter
8. 8.In _________ sort order, values appear A to Z or smallest to largest Hint p.180ascending
9. 9.You can use outline __________ to change the view of an outlined worksheet Hint p.193 symbols
10. 10. You can quickly rearrange the data sequence when you use Excel’s _________ feature Hint p. 180sort

 



Chapter 7 Excel Vocabulary Terms: QR Challenge

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

Question 1 (of 10)

 



Chapter 7 Excel Vocabulary Terms: QR Challenge

https://www.classtools.net/QR/decode.php?text=2._Duplicate_values_are_Values_in_the_row_that_are_an_exact_match_of_all_the_values_in_another_row_Hint_p.178

Question 2 (of 10)

 



Chapter 7 Excel Vocabulary Terms: QR Challenge

https://www.classtools.net/QR/decode.php?text=3.Excel_uses_filter_rules_to_determine_which_worksheet_rows_to_display_Hint_p.186

Question 3 (of 10)

 



Chapter 7 Excel Vocabulary Terms: QR Challenge

https://www.classtools.net/QR/decode.php?text=4.In_____________,_sorted_values_appear_Z_to_A_or_highest_to_lowest_Hint_p._180

Question 4 (of 10)

 



Chapter 7 Excel Vocabulary Terms: QR Challenge

https://www.classtools.net/QR/decode.php?text=5.The____________are_conditions_specified_to_limit_which_records_to_include_in_the_result_of_a_sort_or_filter_hint_p._176

Question 5 (of 10)

 



Chapter 7 Excel Vocabulary Terms: QR Challenge

https://www.classtools.net/QR/decode.php?text=6.A_sign_used_in_criteria_to_compare_two_values_Hint_p._189

Question 6 (of 10)

 



Chapter 7 Excel Vocabulary Terms: QR Challenge

https://www.classtools.net/QR/decode.php?text=7.Using_a(n)___________allows_you_to_apply_a_built-in_set_of_filtering_capabilities_Hint_p._186

Question 7 (of 10)

 



Chapter 7 Excel Vocabulary Terms: QR Challenge

https://www.classtools.net/QR/decode.php?text=8.In___________sort_order,_values_appear_A_to_Z_or_smallest_to_largest_Hint_p.180

Question 8 (of 10)

 



Chapter 7 Excel Vocabulary Terms: QR Challenge

https://www.classtools.net/QR/decode.php?text=9.You_can_use_outline____________to_change_the_view_of_an_outlined_worksheet_Hint_p.193

Question 9 (of 10)

 



Chapter 7 Excel Vocabulary Terms: QR Challenge

https://www.classtools.net/QR/decode.php?text=10._You_can_quickly_rearrange_the_data_sequence_when_you_use_Excel’s___________feature_Hint_p._180

Question 10 (of 10)