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: cell range, formula, function, function library, function tool, numerical formula, spreadsheet, summation function


Primary Objectives:

  • Student learns to use functions in a spreadsheet.
  • Student learns the correct notation and format to use functions in a spreadsheet.
  • Student is introduced to the functions for mathematical sum, mean, minimum, and maximum.
  • Student learns how to apply a function across multiple cells.
  • Student is introduced to the function library and how to use the function tool.
  • Student gains additional experience using the summation command.
  • Student learns to specify cell ranges in functions in a spreadsheet.
  • Student gains additional experience using numerical formulas in a spreadsheet.

Secondary Objectives:

  • Student will learn to use digital tools to gather, organize and evaluate information.
  • Student will understand and be able to use functions in spreadsheets.
  • Student will gain more experience using the different tools available in spreadsheet software.
  • Student will learn how to work more efficiently in a spreadsheet program by using automated functions when analyzing data.

Subjects:

Arithmetic

Mathematics > Number Operations > Mean > Arithmetic

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 

Displays

Mathematics > Statistics Probability > Computation/Technology > Displays

Graphic Organizers (Venn Diagrams,etc.) 

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

Maximum/Minimum

Mathematics > Statistics Probability > Data > Maximum/Minimum

Spreadsheets

Mathematics > Number Operations > Computation/Technology > Spreadsheets

Spreadsheets

Mathematics > Statistics Probability > Computation/Technology > Spreadsheets

Spreadsheets

Information Technology > Software Applications > Spreadsheets

Spreadsheets 

Information Technology > Software Applications > Spreadsheets 

Technical / Specialized

Language Arts > Communication > Listening Strategies / Context > Content Specific > Technical / Specialized

Use appropriate tools strategically

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

Teacher Notes:

  • Functions are generally harder to grasp than formulas, despite the function simply being a more automated version of a formula. Copying and pasting sometimes is not as intuitive for students. Students will need practical experience with the functions available, but it may be best to limit focus to the mean, minimum, and maximum functions. Introduce other functions as needed.

Extension Ideas:

  • Students can break into groups or pairs to explore and experiment using a function available in the function library. The instructor can assign the specific functions randomly or allow students to choose, but try to avoid having too many teams covering the same functions. Teams can teach the class how to use the function in a brief presentation or demonstration.

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