Request More Info

Business Applications

Not a Learning.com customer? Learn More

Teacher-Facing Resources

Type:Quiz

Estimated Time:15 minutes

Grades:6-8

Score Type:Automatically Graded

Work completed by a student will be automatically graded and the grade will be sent to the Learning Management System (LMS) gradebook

Available Languages: English, Spanish


Vocabulary: absolute reference, cell address, chart, data, data analysis, format cell, formula, function, graph, relative reference, sort tool, spreadsheet, summation function


Objectives:

  • Student demonstrates knowledge of the difference between absolute and relative cell address references and how to use each in formulas.
  • Student demonstrates the ability to format cells and pages.
  • Student demonstrates the ability to interpret data in charts and graphs.
  • Student demonstrates the ability to sort data.
  • Student demonstrates the ability to use operators in formulas.
  • Student demonstrates the ability to use the auto sum tool.

Subjects:

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

Nonfiction

Language Arts > Reading / Literature > Comprehension / Analysis > Word Study > Nonfiction

Parts

Mathematics > Statistics Probability > Graphs and Charts > Parts

Problem Solving 

Technology Education > Information Technology > Student Use > Problem Solving 

Spreadsheets

Mathematics > Statistics Probability > Computation/Technology > Spreadsheets

Spreadsheets

Library Media > Information Technology > Software Applications > Spreadsheets

Spreadsheets

Mathematics > Number Operations > Computation/Technology > 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 

Symbols

Mathematics > Number Operations > Operations > Symbols

Use appropriate tools strategically

Mathematics > Process Standards > Common Core > Use appropriate tools strategically
Show More
  • Students will benefit from using a range of menu and toolbar commands to manipulate data in sorted lists or to generate graphs. Emphasis is placed on the special features of spreadsheet software.

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.L.6.6 Acquire and use accurately grade-appropriate general academic and domain-specific words and phrases; gather vocabulary knowledge when considering a word or phrase important to comprehension or expression.
ELA-Literacy.L.7.6 Acquire and use accurately grade-appropriate general academic and domain-specific words and phrases; gather vocabulary knowledge when considering a word or phrase important to comprehension or expression.
ELA-Literacy.L.8.6 Acquire and use accurately grade-appropriate general academic and domain-specific words and phrases; gather vocabulary knowledge when considering a word or phrase important to comprehension or expression.
ELA-Literacy.RI.6.4 Determine the meaning of words and phrases as they are used in a text, including figurative, connotative, and technical meanings
ELA-Literacy.RI.7.4 Determine the meaning of words and phrases as they are used in a text, including figurative, connotative, and technical meanings; analyze the impact of a specific word choice on meaning and tone.
ELA-Literacy.RI.8.4 Determine the meaning of words and phrases as they are used in a text, including figurative, connotative, and technical meanings; analyze the impact of specific word choices on meaning and tone, including analogies or allusions to other texts.
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).