Thursday, April 16, 2015

Fitness Tracker - emails a google form to people in your fitness group and tracks it

Executive Summary
Problem

As an officer in the National Guard I am responsible for the physical readiness of the soldiers under my charge. Soldiers undergo a semi-annual physical fitness exam to determine their readiness. There two areas tested: Strength, which is tested on push-ups and sit-ups, and cardiovascular endurance, which is tested on a 2-mile run. Because Guardsmen are “citizen soldiers” there is little way to ensure that soldiers are exercising consistently. As a result, too many soldiers perform poorly on physical fitness exams.

Solution
My project is a fitness tracker that will track activity in these two areas, strength and cardiovascular endurance. The program sends out an email with a link to a google form every week to all of my soldiers. It links to the responses on google sheets and pulls in data every time the excel project is opened or anytime the user chooses to refresh the dashboard. Finally, there is a dashboard that displays the data for the user (me) allowing me to see workout and physical fitness testing scores among the groups of soldiers that I am responsible for. Ultimately, I will be able to have data to support discipline among my soldiers in their personal physical readiness.

 Supporting Files

No comments:

Post a Comment