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
Adjusts Accordingly / IdentifyLanguage Arts > Communication > Speaking Strategies / Presentations > Audience > Adjusts Accordingly / Identify
Create Communication ProductsTechnology Education > Information Technology > Digital Communications > Create Communication Products
Create PresentationsTechnology Education > Information Technology > Digital Communications > Create Presentations
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
Desktop PublishingTechnology Education > Information Technology > Software Applications > Desktop Publishing
Distance LearningTechnology Education > Information Technology > Basic Operations and Concepts > Distance Learning
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
InternetScience > Concepts and Processes > Tools / Instruments > Software Tools > Internet
Listening / Pay AttentionLanguage Arts > Communication > Media Literacy / Viewing > Comprehension > Listening / Pay Attention
RespondLanguage Arts > Communication > Listening Strategies / Context > Respond
SpreadsheetsLibrary Media > Information Technology > Software Applications > Spreadsheets
SpreadsheetsTechnology Education > Information Technology > Software Applications > Spreadsheets
Student Evaluation and Selection of Tools / Software for TaskTechnology Education > Information Technology > Student Use > Student Evaluation and Selection of Tools / Software for Task
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.