Business Applications

Not a Learning.com customer? Learn More

Type:Lesson

Estimated Time:10 minutes

Score Type:Auto Score

This lesson automatically provides a score to your 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:

Critical Thinking and Decision Making Process 

Information Technology > Student Use > Critical Thinking and Decision Making Process 

Data Collection for Decision Making

Information Technology > Student Use > Data Collection for Decision Making

Data Collection for Decision Making 

Digital Literacy > Student Use > Data Collection for Decision Making 

Data Formats 

Information Technology > Basic Operations and Concepts > Data Formats 

Data Mining

Information Literacy > Reference and Research > Research Skills > Data Mining

Data Mining

Digital Literacy > Reference and Research > Research Skills > Data Mining

General

Mathematics > Statistics Probability > Graphs and Charts > General

Instructions

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

Listening / Pay Attention

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

Problem Solving 

Information Technology > Student Use > Problem Solving 

Spreadsheets

Information Technology > Software Applications > Spreadsheets

Spreadsheets 

Information Technology > Software Applications > Spreadsheets 

Vocabulary Development

Language Arts > Communication > Listening Strategies / Context > Vocabulary Development
Show More

Teacher Notes:

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

Extension Ideas:

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

Standards:

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-DA-05 Store, copy, search, retrieve, modify, and delete information using a computing device and define the information stored as data. (P4.2)
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.L.2.6 Use words and phrases acquired through conversations, reading and being read to, and responding to texts, including using adjectives and adverbs to describe (e.g., When other kids are happy that makes me happy).
ELA-Literacy.L.3.6 Acquire and use accurately grade-appropriate conversational, general academic, and domain-specific words and phrases, including those that signal spatial and temporal relationships (e.g., After dinner that night we went looking for them).
ELA-Literacy.L.4.6 Acquire and use accurately grade-appropriate general academic and domain-specific words and phrases, including those that signal precise actions, emotions, or states of being (e.g., quizzed, whined, stammered) and that are basic to a particular topic (e.g., wildlife, conservation, and endangered when discussing animal preservation).
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.
ISTE seal of compliance for proficiency student standards ISTE seal of compliance for readiness student standards
Feedback