Request More Info

Business Applications

Not a Learning.com customer? Learn More

Teacher-Facing Resources

Type:Application Exercise

Estimated Time:45 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: Computer and Spreadsheets, Data analysis, Data collection, Line graphs, Mean, Median, Mode, Range


Primary Objectives:

  • Students analyze data and a line graph and can communicate trends, differences and similarities among data.
  • Students collect and enter weather-related numerical data into a spreadsheet.
  • Students create a line graph that shows change over time using data collected and entered. 
  • Students learn to customize spreadsheets and line graphs.
  • Students understand the concepts of mean, median, mode, and range and are able to use the formulas to compute each of them in a spreadsheet. 

Secondary Objectives:

  • Student demonstrates originality and inventiveness in work.
  • Student develops, implements, and communicates new ideas to others.
  • Student is open and responsive to new and diverse perspectives.
  • Student acts on creative ideas to make a tangible and useful contribution to the domain in which the innovation occurs.
  • Student exercises sound reasoning in understanding.
  • Student makes complex choices and decisions.
  • Student understands the interconnections among systems.
  • Student articulates thoughts and ideas clearly and effectively through speaking and writing.
  • Student demonstrates creative thinking, constructs knowledge, and develops innovative products and processes using technology. Student applies existing knowledge to generate new ideas, products, or processes.
  • Student demonstrates a sound understanding of technology concepts, systems, and operations. Student understands and uses technology systems.

Subjects:

Central Tendency

Mathematics > Statistics Probability > Statistics > Central Tendency

Construct Display/ Line

Mathematics > Statistics Probability > Graphs and Charts > Construct Display/ Line

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

Graphic Organizers (Venn Diagrams,etc.) 

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

Interpret/Analyze

Mathematics > Statistics Probability > Graphs and Charts > Interpret/Analyze

Line

Mathematics > Statistics Probability > Graphs and Charts > Line

Mean

Mathematics > Statistics Probability > Statistics > Mean

Median

Mathematics > Statistics Probability > Statistics > Median

Organize/Sort

Mathematics > Statistics Probability > Data > Organize/Sort

Problem Solving 

Technology Education > Information Technology > Student Use > Problem Solving 

Range (Spread)

Mathematics > Statistics Probability > Statistics > Range (Spread)

Reflect

Mathematics > Process Standards > Communication > Reflect

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

Student Evaluation and Selection of Tools / Software for Task 

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

Trends

Mathematics > Statistics Probability > Statistical Reasoning > Trends

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.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