This engaging and interactive digital lesson provides direct instruction and practice as the learners insert and resize rows and columns, enter data into a spreadsheet, use alphabetical and numerical sort functions, use the summation function, and alphabetically organize information in a table.
Estimated Time:10 minutes
Score Type:Automatically Graded
Available Languages: English, Spanish
Vocabulary: alignment, column, data, formatting, row, sort function, spreadsheet, summation function, table, toolbar
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
Design Sorting AlgorithmsTechnology Education > Information Technology > Programming > Design Sorting Algorithms
GeneralMathematics > Statistics Probability > Graphs and Charts > General
Info/Data CollectionMathematics > Process Standards > Problem Solving > Info/Data Collection
InstructionsLanguage Arts > Communication > Listening Strategies / Context > Follow Directions > Instructions
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 this lesson, students work with data about penguin traits. Note that while some species are presented in the lesson, 17 species of penguins exist in the world. Further, all penguin species are protected, and their natural habitats are on every continent in the southern hemisphere (and on no continents in the northern hemisphere).
The Summation tool is introduced in this lesson as a tool that students can use to sum data. This lesson does not introduce the concept of creating formulas and functions. Formulas and functions are discussed in more advanced spreadsheet lessons.
This lesson introduces inserting columns and rows into tables. You might want to make sure that students understand the difference between adding and inserting. Inserting places a column or row between existing data, while adding creates a new column or row after existing data.
|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).|