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, cell address, column, data, row, spreadsheet


Primary Objectives:

  • Student can differentiate between a cell and the row/column in which it is contained.
  • Student can differentiate between a row and a column.
  • Student learns that a spreadsheet is used to organize data.
  • Student learns to enter data in individual cells.
  • Student learns to identify and name the components of a spreadsheet.
  • Student learns to insert, size, and delete rows and columns.
  • Student learns to navigate through a spreadsheet.
  • Student learns to select groups of cells and entire rows and columns.

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 

Graphic Organizers (Venn Diagrams,etc.) 

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

Listening / Pay Attention

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

Spreadsheets

Library Media > Information Technology > Software Applications > Spreadsheets

Spreadsheets 

Technology Education > Information Technology > Software Applications > Spreadsheets 

Technical / Specialized

Language Arts > Communication > Listening Strategies / Context > Content Specific > Technical / Specialized
Show More
  • Usually, spreadsheets are set up so that a row holds a record, or all of the information about one specific thing (like the information about a person); and columns holds the same kind of information for all of the records (like the ages of all the people in the spreadsheet). This format is also used for databases, which can be used to store, search through, and sort significant amounts of information.

  • Depending on available time and resources, students could work in pairs or teams to develop a questionnaire or survey for their fellow students to complete. These surveys can be based on other subjects being taught, community or school issues, personal interests, or current events. Students should choose three or four questions and then present their findings to the class using their spreadsheet. Encourage students to resize columns and rows to enhance visibility for their presentation.
  • To help the students get a better feel for how spreadsheets could be used, have them identify information that them might gather and store in a spreadsheet in their personal lives. This could be such things as cataloging a collection, tracking money earned, etc. Have them identify what columns they would use to classify the information. Then have the students discuss what they chose with the class and how it might be improved.
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)
ISTE seal of compliance for proficiency student standards ISTE seal of compliance for readiness student standards