View Premium

PREMIUM LOGIN

ClassTools Premium membership gives access to all templates, no advertisements, personal branding and many other benefits!
 

Username:    
Password:    
Submit Cancel

 

 

Not a member?

JOIN NOW!

 

QR Challenge: CA 2 Vocabulary

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

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. Cell address that does not change when copied in a formulaAbsolute Reference
2. Values or cell references (included between parentheses) that a function needs to complete its calculationArgument
3. Sort order arranging text or numbers from A to Z, from smallest to largest, or from earliest to latestAscending
4. Built-in set of formatting instruction that applies fonts, colors, borders, and other formats to a rangeAutoFormat
5. Preset formatting including shading that can be applied to a tableAutoFormat
6. Built-in mathematical function that determines the average of a block of cellsAverage Function
7. Data is represented by horizontal barsBar Graph
8. What is shown in a chart, created from row or column headingsCategory Axis
9. Portion of a table that is formed by the intersection of a row and columnCell
10. Optional title or name for a chartChart Title
11. Vertical group of cells in a tableColumn
12. A break that can happen automatically when a column is full and items automatically flow to the next columnColumn Break
13. A chart in which data is represented by vertical barsColumn Chart
14. To trim a picture so only a portion of the original image showsCrop
15. Format data using commas and dollar signsCurrency Format
16. Object that explains the colors, patterns, or symbols used in a chartData Marker
17. One value from a data seriesData Point
18. Contains variable information that is inserted into the main document during the mail-merging processData Source
19. Collection of data organized in a manner that allows access, retrieval, and use of dataDatabase
20. Sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliestDescending
21. A single characteristic of data that appears in a table as a columnField
22. One piece of information – i.e., a name or a street addressField
23. A feature that allows the user to copy or fill data in cells adjacent to the original cellFill
24. Allows user to merge or group pieces of information in the data source to match certain criteriaFilter
25. Printing option that allows user to change page scalingFit To
26. Text that appears in the bottom margin of a page throughout a section or documentFooter
27. A database view that allows the user to see all fields for one row and enter them one at a timeForm
28. A method of keeping certain rows or columns visible at all times (such as headings or certain labelsFreeze Title
29. Built-in mathematical formulaFunction
30. Lines that mark the boundaries of cells in a tableGridlines
31. Page break inserted manually at a specific point in a document used to end the current pageHard Page Break
32. Text that appears in the top margin of a page throughout a section or documentHeader
33. A page layout in which documents are printed across the length of a page, making the page wider than it is tallLandscape Orientation
34. Object that explains the colors, patterns, or symbols used in a chartLegend
35. Chart in which data is represented by linesLine Graph
36. Feature used to mass produce form letters and other types of documents by combining the information in two documents, a main document and a data sourceMail Merge
37. Contains both standard text and formatting that appears in the merged document, contains merge fields representing where variable information will be placedMain Document
38. Function that returns the highest number in a range of cellsMax Function
39. A feature that combines a data document with a main document to mass produce personalized letters or other documentsMerge
40. Codes placed in mail-merge documents to input pieces of information from data sourcesMerge Fields
41. Function that returns the lowest number in a rangeMin Function
42. Cell address that adjusts either the row or column when a formula is copiedMixed Reference
43. Alternative term for order of precedenceOrder of Operations (PEMDAS)
44. Formatting instructions applied to a paragraph; may include alignment, line spacing, paragraph spacing, indents, and character formattingParagraph Style
45. A format that converts a decimal number to a percentagePercentage Format
46. Data is arranged in the shape of a pie with data represented by various various percentages of the piePie Chart
47. Rectangular area bound by the category and value axesPlot Area
48. A page layout in which documents are printed across the width of a page, making the page taller than it is widePortrait Orientation
49. A field that uniquely identifies a record in a tablePrimary Key
50. A question presented in a way that allows the database to process and generates specific data from one or more tablesQuery
51. The collection of fields organized into a related group for mail-mergingRecord
52. A collection of fields that appear as a row in a database or tableRecords
53. Cell address that adjusts to the row or column where a copied formula is locatedRelative Reference
54. A document that uses data from tables and/or queries; the user controls which items in the database will appear in the report and how it is filtered or sortedReport
55. Horizontal line of cells in a tableRow
56. Portion of a document that has its own unique formattingSection
57. Markers to indicate the beginning and end of a sectionSection Break
58. Page break that is inserted automatically when a page is filled; these breaks adjust as changes are made to the documentSoft Page Break
59. To arrange a list alphabetically (text) or numerically (numbers), in ascending or descending orderSort
60. Sets of formatting specificationsStyles
61. A database view of information arranged in a grid of rows and columnsTable
62. Agrid of rows and columns that intersect to form cellsTable
63. Design and formatted document on which new documents are basedTemplate
64. An automatic feature that moves text to the next line when a line is full and text can no longer fitText Wrapping
65. Horizontal or vertical grouping of values from the worksheetValue Axis
66. Projecting with a spreadsheet by changing the dataWhat-if Analysis
67. A feature that allows text to be included with pictures, shapes, or tables without covering or hiding under the image, giving the user control over how the text is positionedWrap Text

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Cell_address_that_does_not_change_when_copied_in_a_formula

Question 1 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Values_or_cell_references_(included_between_parentheses)_that_a_function_needs_to_complete_its_calculation

Question 2 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Sort_order_arranging_text_or_numbers_from_A_to_Z,_from_smallest_to_largest,_or_from_earliest_to_latest

Question 3 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Built-in_set_of_formatting_instruction_that_applies_fonts,_colors,_borders,_and_other_formats_to_a_range

Question 4 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Preset_formatting_including_shading_that_can_be_applied_to_a_table

Question 5 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Built-in_mathematical_function_that_determines_the_average_of_a_block_of_cells

Question 6 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Data_is_represented_by_horizontal_bars

Question 7 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=What_is_shown_in_a_chart,_created_from_row_or_column_headings

Question 8 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Portion_of_a_table_that_is_formed_by_the_intersection_of_a_row_and_column

Question 9 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Optional_title_or_name_for_a_chart

Question 10 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Vertical_group_of_cells_in_a_table

Question 11 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_break_that_can_happen_automatically_when_a_column_is_full_and_items_automatically_flow_to_the_next_column

Question 12 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_chart_in_which_data_is_represented_by_vertical_bars

Question 13 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=To_trim_a_picture_so_only_a_portion_of_the_original_image_shows

Question 14 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Format_data_using_commas_and_dollar_signs

Question 15 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Object_that_explains_the_colors,_patterns,_or_symbols_used_in_a_chart

Question 16 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=One_value_from_a_data_series

Question 17 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Contains_variable_information_that_is_inserted_into_the_main_document_during_the_mail-merging_process

Question 18 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Collection_of_data_organized_in_a_manner_that_allows_access,_retrieval,_and_use_of_data

Question 19 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Sort_order_arranging_text_or_numbers_from_Z_to_A,_largest_to_smallest,_or_latest_to_earliest

Question 20 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_single_characteristic_of_data_that_appears_in_a_table_as_a_column

Question 21 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=One_piece_of_information_–_i.e.,_a_name_or_a_street_address

Question 22 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_feature_that_allows_the_user_to_copy_or_fill_data_in_cells_adjacent_to_the_original_cell

Question 23 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Allows_user_to_merge_or_group_pieces_of_information_in_the_data_source_to_match_certain_criteria

Question 24 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Printing_option_that_allows_user_to_change_page_scaling

Question 25 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Text_that_appears_in_the_bottom_margin_of_a_page_throughout_a_section_or_document

Question 26 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_database_view_that_allows_the_user_to_see_all_fields_for_one_row_and_enter_them_one_at_a_time

Question 27 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_method_of_keeping_certain_rows_or_columns_visible_at_all_times_(such_as_headings_or_certain_labels

Question 28 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Built-in_mathematical_formula

Question 29 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Lines_that_mark_the_boundaries_of_cells_in_a_table

Question 30 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Page_break_inserted_manually_at_a_specific_point_in_a_document_used_to_end_the_current_page

Question 31 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Text_that_appears_in_the_top_margin_of_a_page_throughout_a_section_or_document

Question 32 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_page_layout_in_which_documents_are_printed_across_the_length_of_a_page,_making_the_page_wider_than_it_is_tall

Question 33 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Object_that_explains_the_colors,_patterns,_or_symbols_used_in_a_chart

Question 34 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Chart_in_which_data_is_represented_by_lines

Question 35 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Feature_used_to_mass_produce_form_letters_and_other_types_of_documents_by_combining_the_information_in_two_documents,_a_main_document_and_a_data_source

Question 36 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Contains_both_standard_text_and_formatting_that_appears_in_the_merged_document,_contains_merge_fields_representing_where_variable_information_will_be_placed

Question 37 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Function_that_returns_the_highest_number_in_a_range_of_cells

Question 38 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_feature_that_combines_a_data_document_with_a_main_document_to_mass_produce_personalized_letters_or_other_documents

Question 39 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Codes_placed_in_mail-merge_documents_to_input_pieces_of_information_from_data_sources

Question 40 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Function_that_returns_the_lowest_number_in_a_range

Question 41 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Cell_address_that_adjusts_either_the_row_or_column_when_a_formula_is_copied

Question 42 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Alternative_term_for_order_of_precedence

Question 43 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Formatting_instructions_applied_to_a_paragraph;_may_include_alignment,_line_spacing,_paragraph_spacing,_indents,_and_character_formatting

Question 44 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_format_that_converts_a_decimal_number_to_a_percentage

Question 45 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Data_is_arranged_in_the_shape_of_a_pie_with_data_represented_by_various_various_percentages_of_the_pie

Question 46 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Rectangular_area_bound_by_the_category_and_value_axes

Question 47 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_page_layout_in_which_documents_are_printed_across_the_width_of_a_page,_making_the_page_taller_than_it_is_wide

Question 48 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_field_that_uniquely_identifies_a_record_in_a_table

Question 49 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_question_presented_in_a_way_that_allows_the_database_to_process_and_generates_specific_data_from_one_or_more_tables

Question 50 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=The_collection_of_fields_organized_into_a_related_group_for_mail-merging

Question 51 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_collection_of_fields_that_appear_as_a_row_in_a_database_or_table

Question 52 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Cell_address_that_adjusts_to_the_row_or_column_where_a_copied_formula_is_located

Question 53 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_document_that_uses_data_from_tables_and/or_queries;_the_user_controls_which_items_in_the_database_will_appear_in_the_report_and_how_it_is_filtered_or_sorted

Question 54 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Horizontal_line_of_cells_in_a_table

Question 55 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Portion_of_a_document_that_has_its_own_unique_formatting

Question 56 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Markers_to_indicate_the_beginning_and_end_of_a_section

Question 57 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Page_break_that_is_inserted_automatically_when_a_page_is_filled;_these_breaks_adjust_as_changes_are_made_to_the_document

Question 58 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=To_arrange_a_list_alphabetically_(text)_or_numerically_(numbers),_in_ascending_or_descending_order

Question 59 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Sets_of_formatting_specifications

Question 60 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_database_view_of_information_arranged_in_a_grid_of_rows_and_columns

Question 61 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Agrid_of_rows_and_columns_that_intersect_to_form_cells

Question 62 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Design_and_formatted_document_on_which_new_documents_are_based

Question 63 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=An_automatic_feature_that_moves_text_to_the_next_line_when_a_line_is_full_and_text_can_no_longer_fit

Question 64 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Horizontal_or_vertical_grouping_of_values_from_the_worksheet

Question 65 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=Projecting_with_a_spreadsheet_by_changing_the_data

Question 66 (of 67)

 



CA 2 Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=A_feature_that_allows_text_to_be_included_with_pictures,_shapes,_or_tables_without_covering_or_hiding_under_the_image,_giving_the_user_control_over_how_the_text_is_positioned

Question 67 (of 67)