Request More Info

Business Applications

Not a Learning.com customer? Learn More

Teacher-Facing Resources

Type:Application Exercise

Estimated Time:90 minutes

Grades:6-8

Score Type:Mixed Graded

Work completed by a student will be graded through a variety of scoring options including participation, student self-assessment 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 opened-ended questions, correct/incorrect responses, a final product and/or a self-assessment

Available Language: English


Vocabulary: Averaging, Calculating, Data, Functions, Maximum, Minimum, Numbers, Spreadsheets


Objectives:

  • Students identify functions for computing numbers within data spreadsheets.
  • Students interpret data calculations (e.g., least #, greatest #, average #, etc.) of the spreadsheets.
  • Students collect data to analyze and draw resourceful conclusions.
  • Students organize data from spreadsheets based on the calculations of functions.
  • Students comprehend data of spreadsheets through analysis.
  • Students create visualizations, models, and simulations to communicate complex ideas clearly and effectively.
  • Students gather and study data samples of information.
  • Students make inferences based on samples of data.

Subjects:

Arithmetic

Mathematics > Number Operations > Mean > Arithmetic

Collection

Mathematics > Statistics Probability > Data > Collection

Communication

Mathematics > Process Standards > Models/Representations > Communication

Compare

Mathematics > Process Standards > Models/Representations > Compare

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 

Displays

Mathematics > Statistics Probability > Computation/Technology > Displays

Maximum/Minimum

Mathematics > Statistics Probability > Data > Maximum/Minimum

Mean

Mathematics > Statistics Probability > Statistics > Mean

Nonfiction

Language Arts > Reading / Literature > Comprehension / Analysis > Follow Directions > Nonfiction

Organize/Sort

Mathematics > Statistics Probability > Data > Organize/Sort

Problem Solving 

Technology Education > Information Technology > Student Use > Problem Solving 

Problem-solving

Mathematics > Process Standards > Models/Representations > Problem-solving

Spreadsheets

Mathematics > Statistics Probability > Computation/Technology > Spreadsheets

Spreadsheets

Mathematics > Number Operations > Computation/Technology > Spreadsheets

Spreadsheets

Library Media > Information Technology > Software Applications > Spreadsheets

Spreadsheets 

Technology Education > Information Technology > Software Applications > Spreadsheets 

Student Evaluation and Selection of Tools / Software for Task 

Technology Education > Information Technology > Student Use > Student Evaluation and Selection of Tools / Software for Task 

Use Technology when Writing

Language Arts > Computer Literacy Skills > Writing > Use Technology when Writing

Use appropriate tools strategically

Mathematics > Process Standards > Common Core > Use appropriate tools strategically
Show More
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.
S.1.c Students use technology to seek feedback that informs and improves their practice and to demonstrate their learning in a variety of ways.
S.4.b Students select and use digital tools to plan and manage a design process that considers design constraints and calculated risks.
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.
2-DA-08 Collect data using computational tools and transform the data to make it more useful and reliable. (P6.3)
ELA-Literacy.W.6.6 Use technology, including the Internet, to produce and publish writing as well as to interact and collaborate with others; demonstrate sufficient command of keyboarding skills to type a minimum of three pages in a single sitting.
ELA-Literacy.W.7.6 Use technology, including the Internet, to produce and publish writing and link to and cite sources as well as to interact and collaborate with others, including linking to and citing sources.
ELA-Literacy.W.8.6 Use technology, including the Internet, to produce and publish writing and present the relationships between information and ideas efficiently as well as to interact and collaborate with others.
Math.Content.6.SP.A.3 Recognize that a measure of center for a numerical data set summarizes all of its values with a single number, while a measure of variation describes how its values vary with a single number.
Math.Content.6.SP.B.5c Giving quantitative measures of center (median and/or mean) and variability (interquartile range and/or mean absolute deviation), as well as describing any overall pattern and any striking deviations from the overall pattern with reference to the context in which the data were gathered.
Math.Practice.MP4 Model with mathematics.
Math.Practice.MP5 Use appropriate tools strategically.
ELA-Literacy.RST.6-8.7 Integrate quantitative or technical information expressed in words in a text with a version of that information expressed visually (e.g., in a flowchart, diagram, model, graph, or table).
null