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: border, cell, cell address, cell alignment, cell justification, column, data, fill color, formatting, row, sort function, spreadsheet, summation function


Primary Objectives:

  • Student learns how to add color to spreadsheets to highlight information.
  • Student learns how to format individual cells, groups of cells, and columns.
  • Student learns to add borders and shading to a cell or group of cells.
  • Student learns to format cell data as currency and adjust decimal places in currency and numerical data.
  • Student learns to insert rows to add titles to spreadsheets and columns within the spreadsheet.
  • Student learns to perform cell justification and merges.
  • Student learns to use the alphabetical and numerical sort functions.
  • Student learns to use the summation function.

Secondary Objectives:

  • Student learns to use digital tools to gather and organize information.

Subjects:

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 Formats 

Technology Education > Information Technology > Basic Operations and Concepts > Data Formats 

Draw Conclusions

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

Formatting and Preparation

Technology Education > Digital Literacy > Student Use > Student Projects/Presentations > Formatting and Preparation

Formatting and Preparation

Library Media > Information Literacy > Student Use - Digital Media > Student Projects/Presentations > Formatting and Preparation

Identify Message

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

Listening / Pay Attention

Language Arts > Communication > Media Literacy / Viewing > Comprehension > Listening / Pay Attention

Organize/Sort

Mathematics > Statistics Probability > Data > Organize/Sort

Purpose

Language Arts > Communication > Media Literacy / Viewing > Purpose

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
  • Cloud computing is adding more options for collaborative tools in the classroom. Cloud-based apps such as Google Drive offer free spreadsheet software that can allow multiple users to add to a spreadsheet simultaneously and can help teams work together. This type of collaboration can become a powerful tool for learning in your classroom and can be accessible on multiple devices and platforms.

  • Students learn how to enter data into more detailed spreadsheets. Students will learn how to enhance the spreadsheet by adding titles, borders, and color to highlight information or organize data. This lesson also teaches students to use the many tools in spreadsheet applications to format cells as well as sort information aphabetically and numerically in order to better organize information.
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.a Students choose the appropriate platforms and tools for meeting the desired objectives of their creation or communication.
S.6.d Students publish or present content that customizes the message and medium for their intended audiences.
2-DA-07 Represent data using multiple encoding schemes. (P4.0)
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.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).