# Print

## 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

• Bring these devices into the lesson.

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.

### Question

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 bucketFormat Painter
2. 2. Takes the place of a number in a formula. Happens when you click on a cell instead of entering a numberCell Reference
4. 4. What is this an example of: B2Cell
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 anymoreHidden Row or Column
6. 6. This is part of a workbook, it is shown usually as a tab at the bottom with its own nameWorksheet
7. 7. The location of the cell remains relative to the cell that contains the formulaRelative Cell Reference
8. 8. The location of the cell does not change when you move or copy the formula. Formed by using F4Absolute cell reference
9. 9. It is an absolute reference cell. It is made by defining a name for itNamed cell
10. 10. This chart compares parts of a wholePie Chart
11. 11. This chart shows trends in data over timeLine Chart
12. 12. These tabs are activated only when a chart is selectedChart Contextual Tabs
13. 13. This axis runs up and down on a chartVertical Axis
14. 14. This axis runs across the bottom of a chartHorizontal Axis
15. 15. This means if data is changed in the spreadsheet then the chart will change alsoLinked 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 cellConditional Formatting
17. 17. This stands for Comma Separated ValueCSV
18. 18. Pre-existing workbooks that you can use in Excel to save the time of creating new workbooksTemplates
19. 19. This allows you to scroll through a workbook with the headings of the columns or the rows still showing and not disappearingFreeze 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 showingFilter
21. 21. This can put things in alphabetical or numerical order or other optionsSort
22. 22.It allows you to determine the value of a cell based on the outcome of a logical testThe 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

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 1 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 2 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 3 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 4 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 5 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 6 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 7 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 8 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 9 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 10 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 11 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 12 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 13 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 14 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 15 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 16 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 17 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 18 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 19 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 20 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 21 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 22 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 23 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 24 (of 25)

### Spreadsheet Management Vocab Quiz 1: QR Challenge

Question 25 (of 25)