Request More Info

Business Applications

Not a Learning.com customer? Learn More

Student-Facing

Healthy Habits (Updated!)

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:

Students determine appropriate format for organizing data.
Students arrange spreadsheet rows and columns to match data set.
Students draw conclusions from data set.
Students organize, manage, sort, and share data.
Students demonstrate how to modify existing spreadsheet to accommodate updates to data set (e.g., adding, deleting, adjusting rows/columns).

Subjects:

Collaboration

Mathematics > Process Standards > Problem Solving > Collaboration

Collection

Mathematics > Statistics Probability > Data > Collection

Communication

Mathematics > Process Standards > Models/Representations > Communication

Data Collection for Decision Making

Library Media > Information Technology > Student Use > Data Collection for Decision Making

Data Collection for Decision Making

Technology Education > Digital Literacy > Student Use > Data Collection for Decision Making

Graphic Organizers (Venn Diagrams,etc.)

Technology Education > Information Technology > Software Applications > Graphic Organizers (Venn Diagrams,etc.)

Group Projects

Language Arts > Research > Group Projects

Interpret or compare results

Mathematics > Statistics Probability > Study/Sampling > Interpret or compare results

Organize/Sort

Mathematics > Statistics Probability > Data > Organize/Sort

Spreadsheets

Mathematics > Statistics Probability > Computation/Technology > Spreadsheets

Spreadsheets

Library Media > Information Technology > Software Applications > Spreadsheets

Spreadsheets

Technology Education > Information Technology > Software Applications > Spreadsheets

Statistical

Mathematics > Statistics Probability > Computation/Technology > Statistical

Statistical Inquiry/Project

Mathematics > Statistics Probability > Statistical Inquiry/Project

Survey/Investigate

Mathematics > Statistics Probability > Study > Survey/Investigate

	EXCEEDS (4)	MEETS (3)	APPROACHES (2)	DOES NOT MEET (1)
Directions and Participation	The student followed all directions and went above and beyond in answering all questions in the assignment.	The student followed all directions and answered all questions in the assignment.	The student followed most directions and answered most questions in the assignment.	The student did not follow directions or answer the questions in the assignment.
Required Final Product Components	The final product includes additional elements to enhance the assignment beyond the required components.	The final product includes all components required by the assignment.	The final product includes most of the components required by the assignment.	The final product does not demonstrate the components required by the assignment.
Organization and Originality	The final product is exceptionally well designed, includes additional elements, contains no spelling, grammar or punctuation mistakes and reveals student’s creative insights into the assignment.	The final product is neat, includes all components required by the assignment, contains minimal spelling, grammar or punctuation mistakes and includes some creative elements.	The final product is adequate but lacks neatness and creativity, contains some spelling, grammar and punctuation mistakes and is missing required components.	The final product is not neat or creative, is missing required components and contains many spelling, grammar or punctuation mistakes.
Digital Literacy Skills Application	The final product clearly demonstrates an accurate and deep level of understanding of the concept.	The final product demonstrates an accurate and appropriate level of understanding of the concept.	The final product demonstrates some understanding of the concept.	The final product demonstrates little to no understanding of the concept.

ISTE

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.
S.7.b	Students use collaborative technologies to work with others, including peers, experts or community members, to examine issues and problems from multiple viewpoints.
S.7.d	Students explore local and global issues and use collaborative technologies to work with others to investigate solutions.

CSTA

2-DA-08

Collect data using computational tools and transform the data to make it more useful and reliable. (P6.3)

CCSS

Math.Practice.MP4

Model with mathematics.