Leaderboards

Maintaining student engagement during online learning was a constant challenge. I developed a system of exporting grade data from learning management systems and using google sheets with SQL and other built in functions to create leaderboards such as the one shown below. Features include:

  • Several different leaderboards comparing overall grades, weekly high-achievers, and best scores by category

  • Animated Avatars that I created from still student submissions as a reward for top performers

Leaderboard

The above page collected data from another spreadsheet that contained grade data exported from a learning management system in the form of CVS files. Data was separated into separate documents to preserve privacy when viewing leaderboards. The source data for the leaderboard above is shown below, with student names redacted. CVS files were uploaded into dated tabs labelled at the bottom of the page. Analysis was done using built-in google sheets sort and lookup functions


Copy of LeaderboardData