Request More Info

Business Applications

Not a Learning.com customer? Learn More

Teacher-Facing Resources

Type:Application Exercise

Estimated Time:65 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: Border, Currency, Fill Tool, Format, Insert Row, Merge Cells, Rounding, Sort and Filter, Spreadsheet, Sum


Objectives:

  • Students interpret data and organize it in an efficient manner.
  • Students demonstrate how to insert rows and label information with titles in a spreadsheet.
  • Students show how to merge cells, format dates, and format currency in a spreadsheet.
  • Students use borders and align data in cells.
  • Students identify how to round numbers to the whole dollars, sort and filter alphabetically and in descending order.
  • Students choose the sum feature on information that should be totaled.
  • Students use the fill tool to highlight information.
  • Students use critical-thinking skills to demonstrate understanding and analysis of information.
  • Students use problem-solving skills to design user-friendly spreadsheets.
  • Students compare and contrast the features and functionality of spreadsheets by implementing basic formatting techniques.
  • Students learn to organize thoughts and information in patterns that are easy to understand.
  • Students understand how spreadsheets can make everyday projects easy to read, interpret, and share with others and support clear writing practices.
  • Students determine which formatting features in spreadsheets increase a document's usability.

Subjects:

Bold Italicized Headings Layout

Language Arts > Writing > Visual Aids Fiction > Text Features > Bold Italicized Headings Layout

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 

General Use

Language Arts > Writing > Visual Aids > General Use

Labels Labeling

Language Arts > Writing > Products / Formats > Labels Labeling

Peer Self / Teacher Evaluation reflection

Language Arts > Research > Project Evaluation > Peer Self / Teacher Evaluation reflection

Spreadsheets

Mathematics > Number Operations > Computation/Technology > Spreadsheets

Spreadsheets

Library Media > Information Technology > Software Applications > Spreadsheets

Spreadsheets 

Technology Education > Information Technology > Software Applications > Spreadsheets 

Timelines / Diagrams / Maps

Language Arts > Writing > Visual Aids > Graphs / Charts > Timelines / Diagrams / Maps
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.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.2a Introduce a topic; organize ideas, concepts, and information, using strategies such as definition, classification, comparison/contrast, and cause/effect; include formatting (e.g., headings), graphics (e.g., charts, tables), and multimedia when useful to aiding comprehension.
ELA-Literacy.W.7.2a Introduce a topic clearly, previewing what is to follow; organize ideas, concepts, and information, using strategies such as definition, classification, comparison/contrast, and cause/ effect; include formatting (e.g., headings), graphics (e.g., charts, tables), and multimedia when useful to aiding comprehension.
ELA-Literacy.W.8.2a Introduce a topic clearly, previewing what is to follow; organize ideas, concepts, and information into broader categories; include formatting (e.g., headings), graphics (e.g., charts, tables), and multimedia when useful to aiding comprehension.
ISTE seal of compliance for proficiency student standards ISTE seal of compliance for readiness student standards