Request More Info

Business Applications

Not a customer? Learn More

Teacher-Facing Resources


Estimated Time:15 minutes


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.


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

Graphic Organizers (Venn Diagrams,etc.) 

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


Mathematics > Number Operations > Computation/Technology > Spreadsheets


Mathematics > Computer Math > Spreadsheets


Library Media > Information Technology > Software Applications > Spreadsheets


Mathematics > Statistics Probability > Computation/Technology > Spreadsheets


Technology Education > 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
  • 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.
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