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: alignment, column, data, formatting, row, sort function, spreadsheet, summation function, table, toolbar


Primary Objectives:

  • Student learns how to insert rows and columns.
  • Student learns how to resize rows and columns.
  • Student learns how to use alphabetical and numerical sort functions.
  • Student learns how to use the summation function.
  • Student practices entering data into a spreadsheet.
  • Student uses alphabetical order to organize information in a table.

Secondary Objectives:

  • Student analyzes and interprets information in tables.
  • Student investigates the natural world and identifies some traits of penguins.
  • Student practices using tables to organize information.
  • Student understands the concept of adding a list of numbers.

Subjects:

Adjusts Accordingly / Identify

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

Create Presentations 

Technology Education > Information Technology > Digital Communications > Create Presentations 

Critical Thinking and Decision Making Process 

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

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 

Data Formats 

Technology Education > Information Technology > Basic Operations and Concepts > Data Formats 

Data Mining

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

Data Mining

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

Design Sorting Algorithms 

Technology Education > Information Technology > Programming > Design Sorting Algorithms 

General

Mathematics > Statistics Probability > Graphs and Charts > General

Info/Data Collection

Mathematics > Process Standards > Problem Solving > Info/Data Collection

Input Devices: Mouse, Keyboard, Remote Control, etc 

Technology Education > Information Technology > Basic Operations and Concepts > Input Devices: Mouse, Keyboard, Remote Control, etc 

Instructions

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

Internet

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

Problem Solving 

Technology Education > Information Technology > Student Use > Problem Solving 

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 

Technical / Specialized

Language Arts > Communication > Listening Strategies / Context > Content Specific > Technical / Specialized

Vocabulary Development

Language Arts > Communication > Listening Strategies / Context > Vocabulary Development
Show More
  • In this lesson, students work with data about penguin traits. Note that while some species are presented in the lesson, 17 species of penguins exist in the world. Further, all penguin species are protected, and their natural habitats are on every continent in the southern hemisphere (and on no continents in the northern hemisphere).

  • The Summation tool is introduced in this lesson as a tool that students can use to sum data. This lesson does not introduce the concept of creating formulas and functions. Formulas and functions are discussed in more advanced spreadsheet lessons.

  • This lesson introduces inserting columns and rows into tables. You might want to make sure that students understand the difference between adding and inserting. Inserting places a column or row between existing data, while adding creates a new column or row after existing data.

  • This lesson states that school lunch menus provide data. You might want to show the school lunch menu to the class and then discuss how the data is organized. The class could hypothesize about why the information is organized in the way it is presented, and you could discuss the pros and cons of the data presentation. Next have students find other data that's organized into tables in their environment. Working independently or in small groups, instruct students to find examples of data that's presented in table format in the classroom or school. Examples can be found on bulletin boards, posters, books, displays, newsletters, and so forth. If possible, provide time in which students can explore rooms in addition to their home room, such as the library, music room, cafeteria, gym, computer lab, and so forth. After students gather their examples, share the examples with the class to compare the students' findings and discuss which tables were more effective than others.
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-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).