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 

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

Listening / Pay Attention

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

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