Google Sheets for Sports Science Course
Dashboard – Part 1
This project seeks to revisit and reinforce some of the basic concepts covered in videos 1-3. The foundation steps of dashboard creation are demonstrated including data preparation, construction of two Google Forms for athlete data entry, the use of named ranges and data validation to apply filters to the dashboard, the use of aggregation formula and the building of the first of many charts.
Ready to watch this course?
Take advantage of our promotional offer
Related Articles
This topic contains 3 replies, has 3 voices, and was last updated by 
-
This is great stuff! What is a Session Performance Score? Is it how much load a player has experienced compared to a match based on game values?
Thanks
Hi Andy, don’t take this metric too literally, it was merely a number to demonstrate the technical capabilities of sheets. However, that said, when I worked with the NZ Field Hockey team, the video analyst would collect stats at every session and produce a technical performance score for each player. These numbers were generated from basic activity counts such as tackles made, tackles missed, shooting accuracy, players eliminated in 1 v 1s etc.
@john Lythe – quick question:
In the ‘Dashboarding in Google Sheets Demo’, in the ‘FitnessProfile’ tab – are those Z-scores intra-athlete? As in, are they z-scores based off of the athlete’s individual mean from a repeated test; or are they z-scores based off the individual’s test score compared to the mean of the group for that test? I hope that makes sense. Thank you!
You must be logged in to reply to this topic.
