QR Challenge: Excel Vocabulary Part 2

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. Absolute cell reference - A cell reference that does not change when copied or moved to a new cell
2. Argument - The value the function uses to perform a calculation, including a number, text, a cell reference, or even a formula that acts as an operand
3. Automatic page break - Excel inserts this whenever it runs out of room on what would be a printed page
4. Chart - A graphical representation of data
5. Conditional formatting - Highlights worksheet data by changing the look of cells that meet a specified condition you create
6. Fill (2nd Meaning) - Copies a cells contents (any numbers, text, or formulas) and formatting into an adjacent cell or range
7. Fill handle - The little box that appears in the lower-right corner of the active cell or range, and is used to fill cells
8. Freeze pane - Rows and/or columns you select to remain visible on the screen as the rest of the worksheet scrolls in the window
9. Function - Shorthand way to write an equation that performs a calculation. For example the SUM function is used to make adding a range easier
10. Manual calculation - Lets you determine when Excel calculates the formulas
11. Manual page break - A page break you insert manually to start a new page
12. Mixed cell reference - Cell references that contain both relative and absolute column or row references
13. Operand - A constant (text or number) or cell reference used in a formula. For example in 8 + 2, the 8 and 2 are the operands
14. Operator - A symbol that indicates the type of calculation to perform on operands. For example, in 8 + 2, the + is the operator
15. Order of evaluation - The sequence used to calculate the value of a formula – exactly the same as order of operation in math
16. Page Break Preview - View that shows where the page breaks are in a worksheet, which is helpful when you prepare a worksheet for printing
17. Point-and-click method - Allows you to point and click (or touch) each cell in a formula rather than typing out cell references
18. Print area - Consists of the cells and ranges you can designate for printing and does not have to be the entire spreadsheet
19. Print title - Rows and/or columns in a worksheet that you assign to print on each page
20. Relative cell reference - A cell reference that changes by adjusting to its new location when copied or moved
21. Scale - Enables you to resize a worksheet to print on a specific number of pages
22. Sort - Rearranging the data in a spreadsheet in a more meaningful order. For example, putting a range in alphabetical order
23. Split - Divides the worksheet window into two or four panes that you can scroll and work in independently from one another
24. Sum button - The button at the top right of the Home tab that makes using functions to write formulas much easier to do

 

---