Request More Info

Business Applications

Not a Learning.com customer? Learn More

Teacher-Facing Resources

Type:Lesson

Estimated Time:9 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 that a cell location name is based on the cell's row and column.
  • Student learns the concept of a cell.
  • Student learns the concepts of rows and columns, including number and letter labels.
  • Student learns to enter data in individual cells.
  • Student learns to identify and name the components of a spreadsheet, including worksheet, cell, row, and column.

Secondary Objectives:

  • Student analyzes and interprets information in tables.
  • Student investigates the natural world and identifies some traits of snakes.
  • 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 

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

Look for and make use of structure

Mathematics > Process Standards > Common Core > Look for and make use of structure

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
  • Students should be familiar with the concepts of horizontal, vertical, columns, and rows.

  • This lesson likens the worksheet in a spreadsheet program to a piece of graph paper. Consider showing the class a piece of graph paper so they can readily see the likeness.

  • This lesson uses the word venomous to describe poisonous snakes. Students should know that the word venomous means poisonous. If necessary, reassure students that while over 2,900 snake species exist, most snakes live in the tropics, and only about 1 in 10 snakes are venomous.

  • Students can research or draw a particular type of plant or animal. Then the students can summarize specific traits about the plant or animal, including its color, size, and so forth. Traits students summarize should be clearly identifiable and should present a logical means of classifying a plant or animal (such as lays eggs, flowers, etc.). After the students summarize the traits of their plants or animals, divide the class into groups. Each group should draw a table that summarizes the traits of the plants or animals researched by the group members. The tables can then be posted in the room so students can compare the results of each group's summarization.
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.
Math.Practice.MP7 Look for and make use of structure.