Building An Interactive Dashboard To Track Exercise Using Free Tools
Staying motivated to keep exercising can be tough. One way to help yourself data is to have visual feedback on your performance. In this course you will learn how to use simple and free software (Google Sheets & Google Forms) to create a visual dashboard with graphs and multiple metrics on your performance. The dashboard will also display progress versus goals. You will learn many formulas and formatting tricks to make this dashboard work.
Create A Google Form To Gather Data
Use Many Formulas Including "Today()", "VLOOKUP", & "IF"
Use Conditional Formatting To Change Appearance of Data
- What You Will Build (7:01)
- About The Course (2:16)
- Building The Form (2:19)
- Linking Results To Spreadsheet (1:27)
- Installing & Setting Up Copy Down (3:27)
- Formulas For Calendar Heat Map (9:20)
- Formatting The Calendar (6:06)
- Setting Up The Table (5:40)
- Many Many Many More Formulas (9:00)
- More Conditional Formatting (1:49)
- Graph time (6:41)
- Finishing Up (8:38)
About Your Instructor
Paul Heering is a Board Certified Behavior Analyst (BCBA) who was originally certified in 2003. He holds degrees from Western New England College (now "University"--I'm old, it was "College" when I was there) and the University of the Pacific. He has worked in many different settings including ABA Centers, In Home Consultation, Residential Facilities, Public Schools, and Residential Schools. His main areas of interest and experience are in setting up efficient systems, data aggregation and visualization and applying technology to everyday life of a behavior analyst.