IT Fundamentals, Section 9.3: Data Analysis – TestOut

Objective: 

After finishing this section, you should be able to:

  • Describe the importance of data-driven business decisions.
  • Describe the relationship between data and information assets.
  • Identify the basic steps in the data analytics process.
  • Use Microsoft Excel tables and charts to analyze data.
    • Format cells as a table with total rows.
    • Sort table columns to better interpret data.
    • Use Excel charts to display aggregate data.
    • Modify Excel chart settings to better interpret data.
  • Analyze data using Microsoft Access reports.
    • Open an Access report based on a sales query.
  • Interpret Access reports.

Links:

Key Terms:

  • Data Analytics
  • Microsoft Excel

Topics Discussed:

  • Why do businesses need data to make decisions?
  • How can spreadsheets make it easier to interpret data?
  • How do charts make it easier to interpret data?

Assignment:

  1. Access the TestOut Courseware through the provided link.
  2. Study 9.3: Data Analysis and complete Labs/Activities 9.3.5, 9.3.7 & 9.3.9 and the 10 question Exam to complete the Section.

Assigned: May 7th, 2024
Teacher Pacing Due Date: May 8th, 2024

AZ CS Standard: Computing Systems – HS.CS.T.1