Request More Info

Shown a spreadsheet, the student is asked to identify the cell address that holds the value 48

Preview this lesson

Spreadsheets: Parts

During this engaging and interactive digital lesson, the learners will receive direct instruction and practice with spreadsheets. Learners will gain experience with worksheets, cells, rows, columns, cell addresses, labels, navigating tables, and entering data.

Teacher-Facing Resources

Type:Lesson

Estimated Time:9 minutes

Grades:2-5

Score Type:Automatically Graded

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

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.

ISTE

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.

CSTA

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)

CCSS

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.

Aligned to National and State Standards

See how our curriculum can help you meet your instructional goals

Check it out