Request More Info

Business Applications

Not a Learning.com customer? Learn More

Teacher-Facing Resources

Type:Lesson

Estimated Time:10 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: copy and paste, data, formula, function, spreadsheet, table


Primary Objectives:

  • Student gains additional experience with formulas in spreadsheets.
  • Student learns that copying and pasting formulas in a spreadsheet is relative and not exact.
  • Student understands the advantages of the relative copy and paste in spreadsheets.

Secondary Objectives:

  • Student analyzes and interprets information in tables.
  • Student identifies some traits of different types of lizards.
  • Student practices adding numbers and dollar amounts.
  • Student practices finding the average of a group of numbers.
  • Student practices using formulas to solve problems.
  • Student practices using tables to organize information.

Subjects:

Arithmetic

Mathematics > Number Operations > Mean > Arithmetic

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 

Data Mining

Library Media > Information Literacy > Reference and Research > Research Skills > Data Mining

Data Mining

Technology Education > Digital Literacy > Reference and Research > Research Skills > Data Mining

General

Mathematics > Number Operations > General

General

Mathematics > Algebra > Formulas > General

Info/Data Collection

Mathematics > Process Standards > Problem Solving > Info/Data Collection

Listening / Pay Attention

Language Arts > Communication > Media Literacy / Viewing > Comprehension > Listening / Pay Attention

Mathematics 

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

Spreadsheets

Library Media > Information Technology > Software Applications > Spreadsheets

Spreadsheets

Mathematics > Number Operations > Computation/Technology > 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
Show More
  • In this lesson, students calculate the costs of feeding lizards in a zoo exhibit. Students should be familiar with using basic operators, calculating monetary amounts, and entering formulas into spreadsheets.

  • The process of cutting, copying, and pasting is the same in spreadsheet programs as in other programs. Students should be familiar with these basic tasks before taking the lesson. One notable difference is that when you paste a formula, the formula calculates data relative to its position. In other words, when you paste a formula, the formula stays the same but the cell names in the formula change to calculate a relative set of data.

  • The syntax used for formulas and functions from one software title to another may differ. For example, a cell range in some spreadsheet software is specified with a colon between the two cells like this: A1:D8, while in others it is specified by two periods like this: A1..D8. In most cases, the differences are slight and syntax is quite similar from one software title to another. Before applying skills with an activity, be sure to review the syntax used in the software title available to your students and make any clarifications necessary with your students.

  • This lesson also involves using a formula to find an average. Students should be familiar with the mathematical process of averaging a set of numbers.

  • As a class, create a list of common breakfast and lunch items and then assign values to each item. Post the list somewhere in the classroom or provide a handout so the values are available to students. Then have students calculate the values for their breakfasts and lunches over the course of a week. At the end of the week, each student should create a table that shows each day's breakfast value, lunch value, and daily total as well as weekly totals for each meal. Then have students find the average cost of breakfast, average cost of lunch, and average daily cost for both meals. After students complete their tables, discuss with the class how they created their tables and compare students' results.
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.SL.4.2 Paraphrase portions of a text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.
ELA-Literacy.SL.5.2 Summarize a written text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.
Math.Practice.MP5 Use appropriate tools strategically.
ISTE seal of compliance for proficiency student standards ISTE seal of compliance for readiness student standards