Beyond creating charts and graphs from data in sheets you can create ‘mini tables’ called ‘Pivot Tables.’ If you have 5000 students listed in a spreadsheet with names, grade, sports, town, etc. You can ask Pivot tables to extract and tell you things like ‘How many freshman students play each sport and break it down to see how many for each grade are enrolled in each activity.’
Scenario: You have a spreadsheet for several schools over the course of many years with student scores, funding, etc. You want a snapshot to see what the average was for each school each year and the average of all the schools over the course of each year.
Open this spreadsheet and select 'Use Template': Student Score Spreadsheet
Practice creating a pivot table by following the directions.
Go to the radar chart tab and create a Radar Chart to compare the data.
The tabs underlined in orange are baseline requirements for L2 training. The additional sheets with activities are to provide those with interest in further sharpening their spreadsheet skills.
On Your Own: Check out Conditional Formatting to Visualize Results Quickly
Open the Conditional Formatting Spreadsheet Conditional Formatting Template
Go through each sheet
Some notes ask you to look and observe, others ‘do’
Practice and keep this for reference, especially for your test.
Even more... Learn to Love Sheets Workshop resources covers additional sheets topics such as:
Expand & Move Columns
Select All
Freeze Row
Sort
Filter
Split & Concatenate
Conditional Formatting
Explore Tool
Graphs
Auto Average & Sum
From Unit 4:
One powerful tool is Public Data, which adds the dimension of time to a range of values, creating an elegant representation of the change. This allows their teachers and students to explore data across a wider range of variables. The motion of the colorized data points uncover academic trends over years that would be incredibly difficult to replicate with raw numeric scores.