In the past, we tracked sign-up stats daily in September/October when we were getting a lot of sign ups. But it can be useful to track this on a daily basis and have daily movements. It doesn’t warrant doing the weekly task every day, so what we do is track the movements daily, and then reconcile to our student stats (which are the correct figure) weekly.

A reason why these might go out of synch are Exam Super students, who are in 2 class groups, the current LangLion duplicated student history, exam classes from the previous trimester reopened for exam results update, or when we set up the new trimester’s groups, and students sign up.

• open the Sign up stats spreadsheet
• for the Friday entry, update the LSS total, the LSS only and the Spanish class figures (these will have been done in the weekly student stats process).
• amend the Column H Don’t count figure until the adjusted total in Column C matches the total for the end of the week resulting from the weekly student stats process.
• copy and paste the dates for this week (Column A) to create next week
• copy and paste the Friday data (Columns B:L) for Saturday, Sunday and Monday