Request More Info

Business Applications

Not a Learning.com customer? Learn More

Teacher-Facing Resources

Type:Lesson

Estimated Time:15 minutes

Grades:6-8

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: absolute reference, cell, cell name, column, copy and paste, formula, relative reference, row, spreadsheet, summation function


Primary Objectives:

  • Student learns to enter formulas in cells.
  • Student learns how to perform basic arithmetic operations to data in a spreadsheet application.
  • Student learns the correlation between what is typed into a cell and what appears on the screen.
  • Student can identify an individual cell by its row and column location.
  • Student learns to enter cell names in a formula to perform mathematical calculations.
  • Student learns the advantages of using cell names in formulas rather than the values in the cells.
  • Student will understand how relative references function when copying cells in a spreadsheet.
  • Student learns how to copy and paste a formula across multiple cells.
  • Student will understand the difference between absolute references and relative references in formulas.
  • Student learns how to apply absolute references in formulas.
  • Student learns how to use the fill handle to copy and paste across multiple cells.
  • Student gains additional experience using the summation command.

Secondary Objectives:

  • Student will learn to use digital tools to gather, organize and evaluate information.
  • Student will understand and be able to use formulas in spreadsheets.
  • Student will learn the need for the correct order of operations in calculations.

Subjects:

Communication

Mathematics > Process Standards > Models/Representations > Communication

Compare

Mathematics > Process Standards > Models/Representations > Compare

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 Manipulation

Mathematics > Computer Math > Data Manipulation

Draw Conclusions

Language Arts > Communication > Listening Strategies / Context > Interpret / Infer > Draw Conclusions

Graphic Organizers (Venn Diagrams,etc.) 

Technology Education > Information Technology > Software Applications > Graphic Organizers (Venn Diagrams,etc.) 

Identify Message

Language Arts > Communication > Media Literacy / Viewing > Main Idea > Identify Message

Problem-solving

Mathematics > Process Standards > Models/Representations > Problem-solving

Purpose

Language Arts > Communication > Media Literacy / Viewing > Purpose

Spreadsheets

Mathematics > Statistics Probability > Computation/Technology > Spreadsheets

Spreadsheets

Mathematics > Number Operations > Computation/Technology > Spreadsheets

Spreadsheets

Library Media > Information Technology > Software Applications > Spreadsheets

Spreadsheets

Mathematics > Computer Math > Spreadsheets

Spreadsheets 

Technology Education > Information Technology > Software Applications > Spreadsheets 

Student Evaluation and Selection of Tools / Software for Task 

Technology Education > Information Technology > Student Use > Student Evaluation and Selection of Tools / Software for Task 

Use appropriate tools strategically

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

Word Problem Solving

Mathematics > Computer Math > Word Problem Solving
Show More
  • The order of operations used in this lesson only briefly touches on the rule concerning parentheses and does not focus on exponents.

  • There are many real world examples of how spreadsheet software can be used in one's personal life and in the business and professional world. Depending on the time available and the interest of your students, you can give students practice using formulas by asking them to use spreadsheet software to plan and budget four years of college to their dream school. Have students use the same formulas to put in costs for another school. Do the formulas still work?
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.
S.6.d Students publish or present content that customizes the message and medium for their intended audiences.
2-DA-08 Collect data using computational tools and transform the data to make it more useful and reliable. (P6.3)
ELA-Literacy.SL.6.2 Interpret information presented in diverse media and formats (e.g., visually, quantitatively, orally) and explain how it contributes to a topic, text, or issue under study.
ELA-Literacy.SL.7.2 Analyze the main ideas and supporting details presented in diverse media and formats (e.g., visually, quantitatively, orally) and explain how the ideas clarify a topic, text, or issue under study.
ELA-Literacy.SL.8.2 Analyze the purpose of information presented in diverse media and formats (e.g., visually, quantitatively, orally) and evaluate the motives (e.g., social, commercial, political) behind its presentation.
Math.Practice.MP4 Model with mathematics.
Math.Practice.MP5 Use appropriate tools strategically.
ELA-Literacy.RST.6-8.7 Integrate quantitative or technical information expressed in words in a text with a version of that information expressed visually (e.g., in a flowchart, diagram, model, graph, or table).