The learners will receive direct instruction and practice formatting cells in a spreadsheet by merging and grouping cells, applying number formats, aligning cell data, adding borders and color to cells, and indenting data in this engaging and interactive digital lesson.
Estimated Time:12 minutes
Score Type:Automatically Graded
Available Languages: English, Spanish
Vocabulary: alignment, border, cell, cell address, column, data, fill color, formatting, merge cells, row, spreadsheet, table
Critical Thinking and Decision Making ProcessTechnology Education > Information Technology > Student Use > Critical Thinking and Decision Making Process
Data Collection for Decision MakingLibrary Media > Information Technology > Student Use > Data Collection for Decision Making
Data Collection for Decision MakingTechnology Education > Digital Literacy > Student Use > Data Collection for Decision Making
Formatting and PreparationLibrary Media > Information Literacy > Student Use - Digital Media > Student Projects/Presentations > Formatting and Preparation
Formatting and PreparationTechnology Education > Digital Literacy > Student Use > Student Projects/Presentations > Formatting and Preparation
GeneralMathematics > Statistics Probability > Graphs and Charts > General
InstructionsLanguage Arts > Communication > Listening Strategies / Context > Follow Directions > Instructions
Listening / Pay AttentionLanguage Arts > Communication > Media Literacy / Viewing > Comprehension > Listening / Pay Attention
Problem SolvingTechnology Education > Information Technology > Student Use > Problem Solving
SpreadsheetsLibrary Media > Information Technology > Software Applications > Spreadsheets
SpreadsheetsTechnology Education > Information Technology > Software Applications > Spreadsheets
Technical / SpecializedLanguage Arts > Communication > Listening Strategies / Context > Content Specific > Technical / Specialized
Vocabulary DevelopmentLanguage Arts > Communication > Listening Strategies / Context > Vocabulary Development
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.
|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-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.|