Google Sheets for Sports Science Course – Module 2: Dashboard

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.

Google Sheets Course

Ready to watch this course?
Take advantage of our promotional offer

Master Google Sheets

Learn New Skills And Become Google Spreadsheet Power User!

Take this CoursePromo Discount: 33% OFF

OR

Go Annual and Get All Bonuses for FREE!

Join Us TodayAnd Instantly Save $1705

Premium Membership
$350 per year

Course Navigation

Introduction

Module 1: Basics

Module 2: Dashboard

Module 3: Reports

Module 4: Strength Template

mm
I am a former sport scientist, now I just build Excel systems and work with software tools (CRM, Salesforce, PM, Sharepoint) and technology. My day job requires me to sit between the IT department and the sports performance department to make sure that Strength and Conditioning Coaches, Nutritionists, Performance Analysts etc have the hardware and software tools they need to do their jobs. Read More »
free-memeber-button
free-memeber-button

Welcome to Complementary Training Community! Forums Google Sheets for Sports Science Course – Dashboard Part 1

This topic contains 3 replies, has 3 voices, and was last updated by  Quinn Henoch 4 months, 1 week ago.

Viewing 3 posts - 1 through 3 (of 3 total)
  • 06/11/2020 at 07:47 #30071

    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

    mm
    09/11/2020 at 12:13 #30090

    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.

    13/02/2021 at 22:47 #31199

    @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!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.