Business Applications

Not a Learning.com customer? Learn More

Type:Lesson

Estimated Time:15 minutes

Score Type:Auto Score

This lesson automatically provides a score to your 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:

Data Collection for Decision Making

Information Technology > Student Use > Data Collection for Decision Making

Data Collection for Decision Making 

Digital Literacy > Student Use > Data Collection for Decision Making 

Data Manipulation

Mathematics > Computer Math > Data Manipulation

Graphic Organizers (Venn Diagrams,etc.) 

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

Spreadsheets

Mathematics > Number Operations > Computation/Technology > Spreadsheets

Spreadsheets

Mathematics > Computer Math > Spreadsheets

Spreadsheets

Information Technology > Software Applications > Spreadsheets

Spreadsheets

Mathematics > Statistics Probability > Computation/Technology > Spreadsheets

Spreadsheets 

Information Technology > Software Applications > Spreadsheets 

Use appropriate tools strategically

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

Word Problem Solving

Mathematics > Computer Math > Word Problem Solving
Show More

Teacher Notes:

  • The order of operations used in this lesson only briefly touches on the rule concerning parentheses and does not focus on exponents.

Extension Ideas:

  • 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?

Standards:

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.
2-DA-08 Collect data using computational tools and transform the data to make it more useful and reliable. (P6.3)
Math.Practice.MP5 Use appropriate tools strategically.
ISTE seal of compliance for proficiency student standards ISTE seal of compliance for readiness student standards
Feedback