Google Sheets is where the season really becomes visible. In Sport Education, record keeping is central. Scores, standings, fair play points, and role performance are tracked over time and used for feedback, motivation, and the building of team traditions (Siedentop, 2002; Wallhead & O’Sullivan, 2005). Sheets does the same job in a digital environment and makes it much easier to keep those records transparent and organised. Instead of keeping everything on a whiteboard that gets erased, a shared spreadsheet can hold the whole story of the unit: which teams are working on which case studies, how they are progressing on “I can” statements, and how they are contributing to the class community.
From an assessment point of view, Sheets fits well with standards based thinking. Lang and Townsley (2021) argue that proficiency scales and multiple pieces of evidence over time are more meaningful than single percentage scores. A spreadsheet can hold exactly that kind of information. Each row can represent a student or a team. Each column can represent a key outcome, such as “uses evidence to support an argument”, “explains power and inequality in context”, or “participates constructively in discussion”. Instead of entering marks, the teacher records levels on the proficiency scale. Conditional formatting can make those levels visible at a glance. Over the course of the season, teams and students can see patterns: where they are strong, where they are still at an emerging level, and where they have completed extension work. This supports the need for competence by making progress concrete and ongoing rather than hidden inside a gradebook (Fernández, 2011; James et al., 2005).
Sheets is also useful for the kind of multi dimensional record keeping that Sport Education research recommends. Wallhead and O’Sullivan (2005) emphasise that if only winning is measured, then only winning will matter. When teachers track fair play, effort, and role fulfilment alongside performance, they send a different message about what counts. In social studies, a spreadsheet might include columns for disciplinary outcomes, collaboration, and contribution to the culminating event. For example, teams could gain points for strong use of sources, for including multiple perspectives, for supporting quieter voices in discussion, and for thoughtful reflection on their own biases. Different colours or tabs can separate “learning records” from “festival points”, keeping the focus on learning while still allowing for a playful competitive element.
Festival organisation is another area where Sheets can carry a lot of weight. Culminating events in Sport Education are often complex. There are multiple games, roles, and ceremonies to coordinate, and the same is true for a social studies town hall, inquiry fair, or simulation (Siedentop, 2002; Wallhead & O’Sullivan, 2005). A spreadsheet can map out the schedule for the day, which teams are presenting when and where, which roles students will take on at each station, and how audience members will rotate. This reduces organisational chaos and makes it easier to communicate expectations clearly, which matters for students’ sense of fairness and safety (James et al., 2005). It also allows students to see the big picture of the event rather than experiencing it as a series of disconnected activities.
Because Sheets can be shared with students, it can also become a tool for self regulation and reflection. Teams can be given view or comment access to certain tabs so they can monitor their own progress on outcomes, check festival schedules, or propose adjustments. This kind of transparency speaks directly to Self Determination Theory’s focus on autonomy and relatedness. Students have some say in how the season unfolds and can see how their work contributes to the group, which supports internalisation of motivation rather than leaving everything at the level of external control (Fernández, 2011; Børhaug & Borgund, 2018).
In practical terms, the spreadsheet does not need to be complicated. A simple layout with one tab for standards based progress, one for team points and records, and one for festival scheduling is enough to hold most of what a Sport Education style social studies season needs. The underlying idea is that Sheets offers a live, shared record of the unit that aligns with standards based assessment, supports the motivational conditions highlighted in SDT, and honours the Sport Education emphasis on records and festivity as part of the learning design rather than as an afterthought (Lang & Townsley, 2021; Siedentop, 2002; Wallhead & O’Sullivan, 2005).