SPORTident Result Analysis

This page is under development.

We're interested in providing a tool for teachers to assess students' progress over time.

Easygec output files

Easygec produces three different CSV files. We want to find one that includes all the courses run by an individual, including repeated course. We also want to know the relative time of each course, so we know which order the student ran the courses in. Note that none of the times show the date, so we need to have a different file for each date. In any application, the user will need to provide the csv file, the date that the event happened, a mapping between SPORTident numbers and students, and the leg lengths (if speed analysis is desired).

• results_per_runner.csv. I think this has what we need.

• detailed_results.csv. I think this also has what we need, but it might be harder to interpret.

• global_results.csv. This only represents each runner on each course once; with their best time.

Plan for development

1. Play with the data in Google Sheets, here. This is from Week 1 of Sunita Williams 2021, the Friday class Grade 3 Santaniello that started at 9:25 am. Note that the times  are between 8:42 and 8:51 in the file (with one outlier that might have been testing the equipment that morning) and the finish times have an extra 1 in the day field. So presumably this is correct for that class, and our controls do not take Daylight Savings Time into account.

2. Read results_per_runner.csv into R.

3. Prepare information about how each runner did: number of times they ran each course; the order in which they ran the courses; how their time per course improved over time. If distance per course is provided, we can also get their average speed and see how that changes over time.

4. For data to use, once I get to multiple classes, I could see whether I can use some of the data from Sunita WIlliams, where I made an effort to save separate Easygec files for different classes. We can pretend that kids had the same card from one class to another for development purposes.

5. Ask Ethan what else he wants.

Step 1: playing with data

I opened the csv file in Google Sheets. It is here.

1. Split text to columns with semicolon as separator

2. Set up the top row as the header (Freeze One Row). Add formatting for header (bold, centered)

3. Add column headers for individual splits

4. Delete empty column.

5. Remove the row with no Finish time (probably did not punch finish). Remove the 10Lion, which was from checking in the morning.

6. Remove the initial 01 from the time; that is some kind of artifact. This is a new column "Time"

7. Copy the Time column into another column, then make room to split, then split on the ":"

8. Calculate total seconds = 60*minutes + seconds. (New column Total Seconds)

9. Sort by (1) Start time, (2) Runner.

10. Color the courses differently. Color the times with darker colors for faster times. Hide a bunch of columns. Add space in between different runners. 

11. Weird things: 

    1. Some double rows, not sure why. Same start time. Same overall time. Maybe downloaded twice. Removing the extras but not recalculating place because it's a hassle.

    2. There is one case where the two start times are the same on the same course for same SI card, and different finish times. Removing one of them. Actually there are two cases of this. 

Analysis of Example Dataset

(See below)

Comments

I think it will be easiest to provide a website where data is uploaded instead of trying to have them manage multiple tabs in a spreadsheet and doing the programming in google scripts. It's faster for me to program in R than javascript. 

There may be other programs out there that can do something similar or could be used to create what we want.

The SPORTident App allows saving runner data; maybe there is a way to allow sharing of SI cards in there, and then all the data would be there?