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
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
Data FormatsTechnology Education > Information Technology > Basic Operations and Concepts > Data Formats
Data MiningLibrary Media > Information Literacy > Reference and Research > Research Skills > Data Mining
Data MiningTechnology Education > Digital Literacy > Reference and Research > Research Skills > Data Mining
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
Vocabulary DevelopmentLanguage Arts > Communication > Listening Strategies / Context > Vocabulary Development
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-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).|
|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.|