Request More Info

Business Applications

Not a Learning.com customer? Learn More

Teacher-Facing Resources

Type:Lesson

Estimated Time:10 minutes

Grades:2-5

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, table, worksheet


Primary Objectives:

  • Student learns how to delete cells, rows, and columns.
  • Student learns how to select entire rows and columns.
  • Student learns organization skills in a spreadsheet.
  • Student navigates through a spreadsheet.
  • Student places titles on columns.

Secondary Objectives:

  • Student analyzes and interprets information in tables.
  • Student investigates the natural world and identifies some traits of birds.
  • Student practices using tables to organize information.

Subjects:

Adjusts Accordingly / Identify

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

Calculators

Science > Concepts and Processes > Tools / Instruments > Software Tools > Calculators

Create Presentations 

Technology Education > Information Technology > Digital Communications > Create Presentations 

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 

Desktop Publishing 

Technology Education > Information Technology > Software Applications > Desktop Publishing 

Distance Learning 

Technology Education > Information Technology > Basic Operations and Concepts > Distance Learning 

General

Mathematics > Statistics Probability > Graphs and Charts > General

Instructions

Language Arts > Communication > Listening Strategies / Context > Follow Directions > Instructions

Internet

Science > Concepts and Processes > Tools / Instruments > Software Tools > Internet

Listening / Pay Attention

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

Respond

Language Arts > Communication > Listening Strategies / Context > Respond

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 
Show More
  • In this lesson, students delete parts of a table, including cells, rows, and columns. In addition, they clear data. Clearing data erases data contained in cells without changing the structure of the table. The distinction might be confusing for some students, so you might want to discuss the difference between deleting and clearing after the lesson.

  • Students are introduced to the concept of a range of cells. Keep in mind that a range can include any contiguous group of cells.

  • Students are told that table titles should be short and descriptive; therefore, you might want to be prepared to give examples or opinions regarding what constitutes a short and descriptive title.

  • In tables, labels provide quick cues to the types of information contained in columns and rows. Labels are also used in many real-world situations to provide helpful information. To demonstate this, write the numbers 1 through 8 across a chalkboard or whiteboard to represent the rows in a grocery store. Tell students that each number represents an aisle in a grocery store, and then ask the students to tell you the number of the aisle they would go to if they needed to find a can of peaches or a box of cereal. Because the rows are not labeled, the students won't be able to answer your question. Now ask volunteers to provide grocery store aisle labels for each number. For example, Row 1 could be labeled 'Bread', Row 2 could be 'Canned Fruit and Vegetables', and so forth. After the 8 rows are labeled, ask the students where they would find various items and give them a chance to respond. Discuss why they could answer the questions easily after the labels were added.
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.
1A-CS-01 Select and operate appropriate software to perform a variety of tasks, and recognize that users have different needs and preferences for the technology they use. (P1.1)
1A-DA-06 Collect and present the same data in various visual formats. (P7.1, P4.4)
1B-DA-06 Organize and present collected data visually to highlight relationships and support a claim. (P7.1)
1B-DA-07 Use data to highlight or propose cause-and-effect relationships, predict outcomes, or communicate an idea. (P7.1)
ELA-Literacy.SL.2.2 Recount or describe key ideas or details from a text read aloud or information presented orally or through other media.
ELA-Literacy.SL.3.2 Determine the main ideas and supporting details of a text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.
ELA-Literacy.SL.4.2 Paraphrase portions of a text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.
ELA-Literacy.SL.5.2 Summarize a written text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.