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 […]
Author: eamon
How to … process Cambridge exam results
The results are stored on dropbox, analysed in Google Sheets and recorded on the student history records in LangLion. These notes have been written for both FCE and CAE, but use the CAE sheet as an example. The structure of the spreadsheets is pretty much the same, but the individual cell references may not be exactly the same. If you’re not sure, check the video. prepare the results spreadsheet In Google Drive – CAE Results […]
How to … Mark group schemes
to navigate to mark group schemes go to secretariat > settings > group settings > mark group schemes to amend a scheme find the scheme, make the changes, and save if you need to delete a line, click on the trash symbol, and save, but you’ll need to refresh to see that it has gone. see video: Screencast Amend mark group scheme to add a new scheme click add scheme (at the bottom of the list) […]
How to … daily sign-up stats
This is the procedure to capture daily movements to the student total. It tracks these movements roughly. The definitive figure is done on a Friday, and these are corrected every Friday, ready for the following weeks movements to be roughly tracked. This is just the daily task, the weekly reconciliation is covered in the How to … weekly sign-ups reconciliation task in LangLion run reports > reports > Groups – Number of free spots look at […]
How to … update teacher.blueballoonguy.com widget
I don’t know if we will continue to use this box in this way in the future. But it’s an area that the teachers can see every day, and in the past it was remarked it was a pity that we didn’t have somewhere to show upcoming events. Anyway, it’s easy and quick, and this is how to update it. Teacher widget update go to asana and move the text to show tomorrow at present […]
How to … use Level Test Stats spreadsheet
This spreadsheet gives stats daily statistics on the number of level tests, both in Vinalopó and Ramón Llull, and compares these to the same day last year. the updating is done daily in September and the earlier part of October, when it quietens down in terms of numbers, we do it weekly. Creating new weeks Usually I create the empty weeks at the beginning of a trimester copy the rows from a full ‘normal’ week […]
How to … remove a person from Asana
go to the the left panel where it says Native English Team, hover over it until you see the settings cog click on the settings cog click on edit team settings click on members hover over the person you want to remove and click Remove click on Remove Access to remove them from the Team click Deprovision to remove them from the Organization See video: Screencast Remove someone from asana
How to … weekly Google Analytics update
go to analytics.google.com using nevalencia15@gmail.com click on the bottom Native English account, and then the 1-Native English Master view enter the dates for Mon to Sun for last week click on compare to previous year amend the previous year dates to also be Mon to Sun of the equivalent week click apply click on audience > mobile > overview take a note of the totals for desktop, mobile and tablet from this year and last […]
How to … understand Google Analytics overview
The Google Analytics data for Native English is held on the nevalencia15@gmail.com account. There are 3 views, as follows: To add a new filter (for IP address) In admin, select 2-Native English test view. In filters choose Add Filter Select Create new filter Enter details and save Enter Filter name (e.g. Vinalopó 23-Jan-17) Select Predefined Choose Filter type of exclude Choose Select source or destination of Traffic from the IP Addresses Select the Expression – That are equal to Save After a […]
How to … update weekly student stats
Student numbers report steps Gather information from LangLion Run the number of free spots report Reports > reports > Choose report > Groups – number of free spots run report – order by name (of group) save as .csv file See video: Screencast of free spots report Note private hours go to Secretariat > groups select Private groups go to Lessons screen change the dates from the Mon to Sun of the previous week tab […]
Recent Comments