We need to evidence stats for 23-24

[lauracumming]

Summary
A clear and concise description of what the admin task is.

We need to evidence the following stats.
Please paste query and chart into this doc:
https://docs.google.com/document/d/1AfL7F_4J6TIWdmhDhXmP4PAQdjngzkd2CN3lh8OIYIY/edit?usp=sharing

• with over 700,000 users benefiting since its launch in 2014 (Database)
• During 2023-2024, student logins grew by 9% (Database)
• over 1,900 schools registering and 5,700 classes being created (Database)
• resulting in over 6 million levels of Rapid Router attempted. (Database)
• Despite these impressive figures, we saw a drop in teacher (1.9%) and Independent (15%)logins (Database)

Outcome/deliverable
Evidence for auditor 2025

Deadline
January

Reviewer
@lauracumming

People to contact
@SKairinos @faucomte97

[SKairinos]

Re: 700k users registered - the underlying query is pulling data from a table that was created only a little over a year ago. Did the data come from a different source previously? How would we be able to back-track?
https://github.com/ocadotechnology/codeforlife-portal/commits/master/cfl_common/common/migrations/0042_totalactivity.py

[faucomte97]

https://github.com/ocadotechnology/codeforlife-portal/blob/master/cfl_common/common/migrations/0043_add_total_activity.py