How to Build an Athlete Monitoring System Using Free Google Products
Categories: Google Forms, Google Sheets
About Course
In this course, we will build a robust, budget-friendly system for monitoring athlete performance using free Google products. Along the way, we learn about:
- Athlete Management Systems
- Data collection strategies
- How to organize data
- Using Google Forms
- Integrating Google Forms with Google Sheets
- Using Google Sheets to interact with and communicate information
**Gold Level Members get free access to this course and its materials**
What Will You Learn?
- Data collection strategies
- Data organization strategies
- Google Forms
- Google Sheets
- Interactive dashboards
- **Gold Level Members get free access**
Course Content
Athlete Monitoring Systems
We discuss the importance of athlete monitoring, current solutions, and budgets.
-
Introduction
02:43 -
Athlete Management Systems
05:20
Data Collection and Google Forms
We discuss how to decide what information to collect and take a deep dive into Google Forms, including how to create and send custom forms.
Videos: 8
Total duration: 55 minutes
-
05:53
-
Introduction to Google Forms
01:14 -
15:10
-
Create a Google Form (Screencast)
16:48 -
Send a Google Form (Screencast)
06:45 -
Collecting Responses: Link a Google Form to a New Google Sheet (Screencast)
02:49 -
Collecting Responses: Link a Google Form to an Existing Google Sheet (Screencast)
02:16 -
Google Forms Recap
03:11
Data Organization and Google Sheets
We discuss how to organize data and take a deep dive into Google Sheets.
Videos: 9
Total duration: 1 hour and 15 minutes
-
Data Organization: Key Considerations
05:13 -
Introduction to Google Sheets
18:48 -
Set Up a Database (Screencast)
05:12 -
Database Calculations (Screencast)
10:10 -
Merging Databases (Screencast)
12:26 -
Convert Text Strings Into Numbers (Screencast)
05:52 -
Athlete Profiles (Screencast)
07:13 -
Data Collection and Visualization Framework (Screencast)
01:25 -
BONUS: How to Import Live Data From Google Sheets into Microsoft Excel (Screencast)
09:11
Build an Interactive Team Dashboard in Google Sheets
We build an interactive team monitoring dashboard in Google Sheets that integrates Google Forms responses and data that is collected within Google Sheets itself.
Videos: 10
Total duration: 2 hours
-
Team Dashboard Plan Overview
02:23 -
15:16
-
How to Choose Colors (Screencast)
04:23 -
Build Team KPI Cards (Screencast)
13:04 -
Build a Daily Team Table Report (Screencast)
17:18 -
Calculations for a Dynamic Team Metric Over Time Chart (Screencast)
21:53 -
Build a Dynamic Team Metric Over Time Chart (Screencast)
09:14 -
BONUS: Add Team Availability to a Metric Over Time Chart (Screencast)
12:51 -
Calculations for a Team Performance Chart (Screencast)
11:40 -
Build a Team Performance Chart (Screencast)
11:38
Dashboard Design and Features
We organize the dashboard components into a visually-appealing design.
Videos: 3
Total duration: 25 minutes
-
Dashboard Features and Organization (Screencast)
15:26 -
Dashboard Design and Conditional Formatting (Screencast)
10:03 -
Part 1 Finale: Recognition of Accomplishments
01:34
Build an Interactive Athlete Dashboard in Google Sheets
We create an interactive athlete dashboard using the same data sets and Google Sheet as the interactive team dashboard created in Part 1.
Videos: 13
Total duration: 2 hours and 45 minutes
-
01:50
-
Calculations for Athlete Profile Cards (Screencast)
10:20 -
Headshots and Availability Statuses for Athlete Profiles (Screencast)
13:48 -
Calculations for Athlete KPI Cards, Part 1: Most Recent Dates (Screencast)
20:20 -
Calculations for Athlete KPI Cards, Part 2: Most Recent Scores (Screencast)
25:40 -
Build Athlete KPI Cards (Screencast)
09:03 -
Calculations for a Dynamic Athlete Metric Over Time Chart (Screencast)
13:40 -
Build a Dynamic Athlete Metric Over Time Chart (Screencast)
07:55 -
BONUS: Add Colored Athlete Availability Statuses to a Metric Over Time Chart (Screencast)
18:08 -
Athlete Dashboard Organization and Design (Screencast)
12:37 -
Build Athlete Profile Cards (Screencast)
11:48 -
Final Touches (Screencast)
07:54 -
BONUS: Custom Number Formatting in Google Sheets (Screencast)
14:37
The Most Important Video
The error that I made standalone topic.
-
Transition Form Responses: THE MOST IMPORTANT VIDEO (Screencast)
07:47
Managing the System
We discuss how to manage your athletes and data in the athlete monitoring system.
Videos: 9
Total duration: 45 minutes
-
System Management Overview
01:31 -
Transition Form Responses: THE MOST IMPORTANT VIDEO (Screencast)
07:47 -
04:12
-
Adding Data (Screencast)
03:14 -
Data Validation (Screencast)
07:05 -
Add an Athlete to a Google Form (Screencast)
03:59 -
Add a New Metric or Question to a Google Form (Screencast)
06:23 -
09:27
-
Congratulations and Thank You
00:43