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: cloud computing, data, filters, freezing panes, scrolling, spreadsheet, wrap text


Primary Objectives:

  • Student will learn how to save, store and share spreadsheets.
  • Student will understand how different users can work on a spreadsheet at the same time using cloud computing and web-based software.
  • Student learns to wrap text in cells.
  • Student learns to navigate a spreadsheet document by scrolling and freezing panes.
  • Student will learn how to use and apply filters to a spreadsheet.
  • Student will learn how to filter data by one or more values or within specified ranges.
  • Student will learn how to remove filters.

Secondary Objectives:

  • Student will better understand how people can share and collaborate on projects using digital tools and applications.
  • Student will learn to use digital tools to gather, organize and evaluate information.

Subjects:

Cloud Computing 

Information Technology > Networking > Cloud Computing 

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 

Organize/Sort

Mathematics > Statistics Probability > Data > Organize/Sort

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:

  • Google Sheets is a free and easy to use cloud-based spreadsheet program that can allow students to collaborate with one another on a spreadsheet in order to practice the skills taught in this lesson.

Extension Ideas:

  • Encourage students to research basic information for US Presidents (the website for the White House, whitehouse.gov, is a good resource). Students should work in pairs or in small groups to build a spreadsheet to enter this information. Students should apply filters for such information as political party, state of origin, month of birth, et cetera. Students can then use the spreadsheet to find patterns in the data and present their findings.

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