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.

See how our curriculum can help you meet your instructional goals

Check it out