QR Challenge: Spreadsheet Management Vocab Quiz 1

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

• 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. This button allows you to apply formatting once, or you can continue to apply formatting if you click it twice. It looks like a paint bucket	Format Painter
2. 2. Takes the place of a number in a formula. Happens when you click on a cell instead of entering a number	Cell Reference
3. 3. Automatically resizes your spreadsheets before printing	Scale To Fit
4. 4. What is this an example of: B2	Cell
5. 5. This will not show up on the worksheet but you can tell it is there because there will be a dark line, and the column or row numbers or letters will not be in order anymore	Hidden Row or Column
6. 6. This is part of a workbook, it is shown usually as a tab at the bottom with its own name	Worksheet
7. 7. The location of the cell remains relative to the cell that contains the formula	Relative Cell Reference
8. 8. The location of the cell does not change when you move or copy the formula. Formed by using F4	Absolute cell reference
9. 9. It is an absolute reference cell. It is made by defining a name for it	Named cell
10. 10. This chart compares parts of a whole	Pie Chart
11. 11. This chart shows trends in data over time	Line Chart
12. 12. These tabs are activated only when a chart is selected	Chart Contextual Tabs
13. 13. This axis runs up and down on a chart	Vertical Axis
14. 14. This axis runs across the bottom of a chart	Horizontal Axis
15. 15. This means if data is changed in the spreadsheet then the chart will change also	Linked data
16. 16. This formatting calls attention to a set of data and applies a rule or rules and modifies the formatting of the cell to match the rule. It can be a change of color, text, etc. to highlight the cell	Conditional Formatting
17. 17. This stands for Comma Separated Value	CSV
18. 18. Pre-existing workbooks that you can use in Excel to save the time of creating new workbooks	Templates
19. 19. This allows you to scroll through a workbook with the headings of the columns or the rows still showing and not disappearing	Freeze Panes
20. 20. This allows you to choose what data to include and what data to filter out. The data is still there, it is just not showing	Filter
21. 21. This can put things in alphabetical or numerical order or other options	Sort
22. 22.It allows you to determine the value of a cell based on the outcome of a logical test	The IF Function
23. 23.Use this to create criteria for cells that limit the possible entries into those cells	Data Validation
24. 24. This can be added to the top of your worksheet and can be used for a title, company name, your name, etc.	Header
25. 25.These can be added to the bottom of your document. Used for page numbers, file names, etc.	Footer

 

---