Through direct instruction and practice in this engaging and interactive digital lesson, the learners will organize information in a spreadsheet by navigating cells, rows, and columns, editing or deleting data, adding titles, and including labels in a table.
Estimated Time:10 minutes
Score Type:Automatically Graded
Available Languages: English, Spanish
Vocabulary: cell, cell address, column, data, row, spreadsheet, table, worksheet
Adjusts Accordingly / IdentifyLanguage Arts > Communication > Speaking Strategies / Presentations > Audience > Adjusts Accordingly / Identify
CalculatorsScience > Concepts and Processes > Tools / Instruments > Software Tools > Calculators
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
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
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.
|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-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.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.|