QR Challenge: Excel Vocabulary Part 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. Active cell - The cell in the worksheet in which you can type data
2. Active worksheet - The worksheet that is displayed in the work area
3. Alignment – where the text is in relation to the border of the cell
4. AutoFit - Determines the best width for a column or the best height for a row, based on its contents
5. Border - The line around a cell’s edges
6. Cell - The intersection of a row and a column
7. Cell reference - Identifies the cell, and is formed by combining the cell’s column letter and row number
8. Cell style - A collection of formatting characteristics you apply to a cell or range of data
9. Clear - Removes formatting applied to a cell or a range of cells
10. Column - Appears vertically and is identified by letters at the top of the worksheet window
11. Column heading - The column identification, identified by the letter above the column
12. Editing mode - When you double-click the cell, or press the F2 key, and place the insertion point within the cell contents, you enable this mode and are able to edit cell contents
13. Fill (1st Meaning) - Background color of a cell
14. Format Painter - Enables you to copy formatting from one worksheet cell to another without copying the cell’s contents
15. Formula - An equation that calculates a new value from values currently in a worksheet
16. Formula Bar - Appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value
17. Indent - Cell contents are shifted to the right
18. Merge - Combines multiple cells into one cell
19. Name Box - Cell reference area located below the Ribbon, displays the cell reference of the active cell
20. Number format - The way numerical data looks in a cell
21. Orientation - The angle at which the data is displayed within a cell
22. Range - A group of selected cells
23. Range reference - How the range is identified; made up of the cell in its upper-left corner and the cell in its lower-right corner, separated by a colon
24. Row - Appears horizontally and is identified by numbers on the left side of the worksheet window
25. Row heading - The row identification, identified by the number beside the column
26. Sheet tab - Tab at the bottom of the worksheet window that displays the name of the worksheet
27. Spreadsheet - A grid of rows and columns in which you enter text, numbers, and the results of calculations
28. Truncate - Hidden from view
29. Workbook - The file used to store worksheets; what an Excel file is called
30. Worksheet - A computerized spreadsheet, the words spreadsheet and worksheet are interchangeable
31. Wrap text - When the row height adjusts automatically to include additional lines until all the text is visible within the same cell

 

---