Spreadsheets are powerful organizational tools that allow the user to manage and understand large amounts of data. In this lesson, students will conduct a survey, create a spreadsheet, and input data into the spreadsheet in order to analyze results.
Application Exercises give students an opportunity to apply concepts they have learned in previous instruction. Work completed by a student will be graded through a variety of scoring options including participation and teacher assessment via rubric to provide flexibility with the type of grade sent to the Learning Management System (LMS) gradebook. Student work may include open-ended questions, correct/incorrect responses, a final product and/or self-assessment.
Teacher-Facing Resources
Type:Application Exercise
Estimated Time:90 minutes
Grades:6-8
Score Type:Mixed Graded
Available Language: English
Vocabulary: Data, Formatting, Spreadsheets
Objectives:
Subjects:
Adjusts Accordingly / Identify
Language Arts > Communication > Speaking Strategies / Presentations > Audience > Adjusts Accordingly / IdentifyCollaboration
Mathematics > Process Standards > Problem Solving > CollaborationCollection
Mathematics > Statistics Probability > Data > CollectionCommunication
Mathematics > Process Standards > Models/Representations > CommunicationCreate Presentations
Technology Education > Information Technology > Digital Communications > Create PresentationsData Collection for Decision Making
Library Media > Information Technology > Student Use > Data Collection for Decision MakingData Collection for Decision Making
Technology Education > Digital Literacy > Student Use > Data Collection for Decision MakingGeneral / Varied Use
Language Arts > Communication > Multimedia Usage / Production > General / Varied UseGraphic Organizers (Venn Diagrams,etc.)
Technology Education > Information Technology > Software Applications > Graphic Organizers (Venn Diagrams,etc.)Group Projects
Language Arts > Research > Group ProjectsInterpret or compare results
Mathematics > Statistics Probability > Study/Sampling > Interpret or compare resultsOrganize/Sort
Mathematics > Statistics Probability > Data > Organize/SortProblem Solving
Technology Education > Information Technology > Student Use > Problem SolvingSpreadsheets
Mathematics > Statistics Probability > Computation/Technology > SpreadsheetsSpreadsheets
Library Media > Information Technology > Software Applications > SpreadsheetsSpreadsheets
Technology Education > Information Technology > Software Applications > SpreadsheetsStatistical
Mathematics > Statistics Probability > Computation/Technology > StatisticalStatistical Inquiry/Project
Mathematics > Statistics Probability > Statistical Inquiry/ProjectStudent Evaluation and Selection of Tools / Software for Task
Technology Education > Information Technology > Student Use > Student Evaluation and Selection of Tools / Software for TaskSurvey/Investigate
Mathematics > Statistics Probability > Study > Survey/Investigate