UNIT 4: Analyze and Interpret Student Data

In this unit, you’ll learn:

• How to use conditional formatting to efficiently display results.
• How to analyze large data sets with pivot tables
• How to interpret academic trends in data sets using motion charts
• How to customize your data view using filters

If you already know this material, feel free to skip to the Unit Review at the end.

Applying Conditional Formatting Video

Google Sheets

• Create a Chart or Graph in Google Sheets including a Motion Chart, Radar Chart
• Chart Types
• Create a Pivot table to analyze large data sets
• Use functions including Sort, Filter, CountIF, SumIF, Sum, Unique
• Use the Filter Tool and Filter Views
• Import Data Sets and Spreadsheets
  • Choose a form response destination