Business Applications

Not a Learning.com customer? Learn More

Type:Application Exercise

Estimated Time:65 minutes

Score Type:Auto Score

This application exercise automatically provides a score to your gradebook

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

Information Technology > Student Use > Data Collection for Decision Making

Data Collection for Decision Making 

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

Information Technology > Software Applications > Spreadsheets

Spreadsheets 

Information Technology > Software Applications > Spreadsheets 

Timelines / Diagrams / Maps

Language Arts > Writing > Visual Aids > Graphs / Charts > Timelines / Diagrams / Maps
Show More

Standards:

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
Feedback