Request More Info

Business Applications

Not a Learning.com customer? Learn More

Teacher-Facing Resources

Type:Quiz

Estimated Time:15 minutes

Grades:4-5

Score Type:Automatically Graded

Work completed by a student will be automatically graded and the grade will be sent to the Learning Management System (LMS) gradebook

Available Languages: English, Spanish


Vocabulary: cell address, copy and paste, data, formula, function, spreadsheet, summation function, table


Objectives:

  • Student demonstrates ability to write formulas with numbers and relative cell references.
  • Student demonstrates ability to identify and use operators.
  • Student demonstrates knowledge of how the information displayed in the formula bar and a cell interrelate.
  • Student demonstrates ability to select a range of contiguous cells and use them in formulas.
  • Student demonstrates the ability to find the sum and average of a range of contiguous cells.

Subjects:

Arithmetic

Mathematics > Number Operations > Mean > Arithmetic

Create Presentations 

Technology Education > Information Technology > Digital Communications > Create Presentations 

Critical Thinking and Decision Making Process 

Technology Education > Information Technology > Student Use > Critical Thinking and Decision Making Process 

Data Collection for Decision Making

Library Media > Information Technology > Student Use > Data Collection for Decision Making

Data Collection for Decision Making 

Technology Education > Digital Literacy > Student Use > Data Collection for Decision Making 

Internet

Science > Concepts and Processes > Tools / Instruments > Software Tools > Internet

Mathematics 

Technology Education > Information Technology > Connects to Other Disciplines > Mathematics 

Nonfiction

Language Arts > Reading / Literature > Comprehension / Analysis > Word Study > Nonfiction

Problem Solving 

Technology Education > Information Technology > Student Use > Problem Solving 

Spreadsheets

Mathematics > Number Operations > Computation/Technology > Spreadsheets

Spreadsheets

Library Media > Information Technology > Software Applications > Spreadsheets

Spreadsheets 

Technology Education > Information Technology > Software Applications > Spreadsheets 

Symbols

Mathematics > Number Operations > Operations > Symbols

Use appropriate tools strategically

Mathematics > Process Standards > Common Core > Use appropriate tools strategically

Vocabulary Development

Language Arts > Communication > Listening Strategies / Context > Vocabulary Development
Show More
  • Students will benefit from practice creating formulas with numbers and referenced cells.

S.5.b Students collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision-making.
1B-DA-06 Organize and present collected data visually to highlight relationships and support a claim. (P7.1)
1B-DA-07 Use data to highlight or propose cause-and-effect relationships, predict outcomes, or communicate an idea. (P7.1)
ELA-Literacy.L.4.6 Acquire and use accurately grade-appropriate general academic and domain-specific words and phrases, including those that signal precise actions, emotions, or states of being (e.g., quizzed, whined, stammered) and that are basic to a particular topic (e.g., wildlife, conservation, and endangered when discussing animal preservation).
ELA-Literacy.L.5.6 Acquire and use accurately grade-appropriate general academic and domain-specific words and phrases, including those that signal contrast, addition, and other logical relationships (e.g., however, although, nevertheless, similarly, moreover, in addition).
ELA-Literacy.RI.4.4 Determine the meaning of general academic and domain-specific words or phrases in a text relevant to a grade 4 topic or subject area.
ELA-Literacy.RI.5.4 Determine the meaning of general academic and domain-specific words and phrases in a text relevant to a grade 5 topic or subject area.
Math.Practice.MP5 Use appropriate tools strategically.