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: 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:

Adjusts Accordingly / Identify

Language Arts > Communication > Speaking Strategies / Presentations > Audience > Adjusts Accordingly / Identify

Arithmetic

Mathematics > Number Operations > Mean > Arithmetic

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 

Displays

Mathematics > Statistics Probability > Computation/Technology > Displays

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

Maximum/Minimum

Mathematics > Statistics Probability > Data > Maximum/Minimum

Problem Solving 

Technology Education > Information Technology > Student Use > Problem Solving 

Problem-solving

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

Purpose

Language Arts > Communication > Media Literacy / Viewing > Purpose

Spreadsheets

Mathematics > Number Operations > Computation/Technology > Spreadsheets

Spreadsheets

Mathematics > Statistics Probability > Computation/Technology > Spreadsheets

Spreadsheets

Library Media > Information Technology > Software Applications > 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 

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

  • 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.
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).