Request More Info

Business Applications

Not a Learning.com customer? Learn More

Teacher-Facing Resources

Type:Lesson

Estimated Time:12 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, border, cell, cell address, column, data, fill color, formatting, merge cells, row, spreadsheet, table


Primary Objectives:

  • Student learns how to add borders to a cell or group of cells.
  • Student learns how to add color to a cell or group of cells.
  • Student learns how to format cells data, including number, date, and general formats.
  • Student learns how to merge cells.
  • Student learns how to perform cell alignment.
  • Student learns how to select a group of cells.
  • Student learns to indent content inside cells.

Secondary Objectives:

  • Student investigates the natural world of mustelids (weasels).
  • Student practices using art skills in tables by identifying and modifying elements such as color, borders, and white space.
  • Student practices using tables to organize information.
  • Student recognizes decimal places while comparing numbers.

Subjects:

Adjusts Accordingly / Identify

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

Create Communication Products 

Technology Education > Information Technology > Digital Communications > Create Communication Products 

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 

Distance Learning 

Technology Education > Information Technology > Basic Operations and Concepts > Distance Learning 

Formatting and Preparation

Library Media > Information Literacy > Student Use - Digital Media > Student Projects/Presentations > Formatting and Preparation

Formatting and Preparation

Technology Education > Digital Literacy > Student Use > Student Projects/Presentations > Formatting and Preparation

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

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 

Vocabulary Development

Language Arts > Communication > Listening Strategies / Context > Vocabulary Development
Show More
  • In spreadsheet programs, cell formatting includes applying Number Formats. This Lesson shows students how to use Number Formats. You might want to point out that the Number Formats settings include number and non-number types of formatting, such as dates, dollars, times, percentages, times, text, general, special, and so forth.

  • Students should be familiar with the ideas of alignment (left, right, center), white space, borders, indenting, and color palettes. A good rule of thumb when using color palettes is to use light colors that occur together naturally in nature.

  • The animals used in this Lesson's sample table are mustelids. Mustelids are the animals that make up the weasel family, including badgers, ferrets, polecats, otters, skunks, weasels, wolverines, and so forth.

  • This Lesson refers to decimal places. Students should know what showing two decimal places means.

  • Students can practice some table formatting techniques by using clay. Each student should have three different colored pieces of clay that can be used to create a small (e.g., 3-column, 3-row) table. Tell students to use a different color of clay for each part of the table (title, labels, data). After students have the color-coded cells in line, tell them to merge the top row to make a long title cell that spans across the three columns. Then, have students add white space around the data cells. Students could also add borders using yarn, string, pipe cleaners, or other supplies on hand.
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.
S.6.a Students choose the appropriate platforms and tools for meeting the desired objectives of their creation or communication.
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.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.