How to make a readiness monitoring using a simple wellness questionnaire. Addendum

How to make a readiness monitoring using a simple wellness questionnaire.

Addendum

Just a quick update – My free Screencast account reached maximum bandwidth so the videos are not available any more. I decided to put the video files in my Dropbox account. So, if you haven’t had a chance to take a look at the videos, please make sure to download them (and other material) HERE. 

Another idea how to save paper and make things more automatic is to use Google Docs, especially the Forms. You can create same questionnaire and email it to the players. I would suggest putting Name and Jersey number fields in the questionnaire as well so you know from who did you get the data (I am still trying to figure out non-anonymous survey, where I get the email of the sender). Here is the great overview how to do it.

 

Another thing I am trying to figure out in Excel, is how to make the same analysis but filter the data based on the criteria like (a) how many days after a game the survey was done and (b) how many days before a next game survey was done. This way we can compare same scores to the same context. I know how to summarize it using Pivot Table, but I am not sure how to pull the data out of it. I am just learning VBA so maybe I will come back about this project. Stay tuned.