QR Challenge: CHS CBA Excel

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 cell reference that does not adjust to the new cell location when copied or moved
2. Active cell	a selected worksheet cell that is ready for data entry
3. Alignment	the position of data within a cell
4. Argument	value, cell reference, range, or text that acts as an operand in a function formula
5. Ascending	sort order arranging text or numbers from A to Z, from smallest to larges, or from earliest to latest
6. Autosum	a function that automatically adds the values in the cells directly above or to the left of the active cell
7. AVERAGE	returns the average (arithmetic means) of its arguments
8. Cell	the space formed by the intersection of a row and a column; the basic unit of a worksheet
9. Cell reference	a unique identifier for a cell which is formed by combining the cell's column letter and row number
10. Chart or graph	a graphic representation of values and their relationships; pie, line, column, bar, scattered
11. Column	a vertical group of cells in a worksheet identified by letters
12. Column chart	a chart that uses bars of varying height to illustrate values in a worksheet
13. COUNT	returns the number of cells in a range that contains numbers
14. Descending sort order	arranging text or numbers from Z to A, largest to smallest, or latest to earliest
15. Fill	to copy a cell's contents and/or formatting into an adjacent cell or range
16. Format	arranging the shape, size, type, and general makeup of a cell or group of cells
17. Formula	an equation that calculates a new value using values currently on a worksheet
18. Freeze	keeps selected rows or columns visible on the screen as the rest of the worksheet scrolls
19. Function	a prewritten formula that makes it easy to perform common calculations
20. Label	alphanumeric text that will not be used in calculations
21. Line chart	a chart that uses points connected by a line to illustrate values in a worksheet
22. MAX	returns the largest value in a set of values
23. MIN	returns the smallest value in a set of values
24. Mixed cell reference	a cell reference that contains both relative and absolute references
25. Operand	a number or cell reference used in a formula
26. Operator	a symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (
27. Order of operation	the mathematical rules used for calculating the value of a formula
28. Pie Chart	a chart that shows the relationship of a part to a whole
29. Range	selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon
30. Relative cell reference	cell reference that adjusts to a new location when copied or moved
31. Row	a horizontal group of cells in a worksheet identified by numbers
32. Sort	to arrange a list of words or numbers in ascending or descending order
33. Spreadsheet	a grid of rows and columns containing numbers, text, and formulas used to perform calculations
34. SUM	adds all the numbers in a range of cells
35. Value	numeric characters that can be used in a calculation
36. What-if analysis	process of changing values in cells to see how those changes affect the outcome of formulas in the worksheet
37. Workbook	a collection of related worksheets
38. Worksheet	the workspace made up of columns and rows where data is entered to create an electronic spreadsheet

 

---