Using Google Sheets to create a Habit Tracker with a Weekly Schedule and Goal Gauges

This video shows how you can set up a Google Sheet for students to set goals with the Gauge chart, track habits, and create a weekly planner. I will show you how you can:

00:31 Use Gauge charts in a data dashboard
03:11 Set up a Habit tracker with Check boxes
04:39 Use a Sparkline to monitor progress
06:14 Use embedded IF function to indicate if goal has been achieved
11:21 Format a weekly plan using Merge Cells and Fill Colour

Feel free to make your own copy by clicking this link:

https://docs.google.com/spreadsheets/d/1YAzXYwWIClOA6wLIMYTy4ny3J_Reeq4U2uyFMq9Tb1k/copy

Students first add data to a dashboard, setting goals to 'move the needle', identifying productive habits, track those habits, and build out a weekly plan.

Видео Using Google Sheets to create a Habit Tracker with a Weekly Schedule and Goal Gauges канала Pakiki