AWEStats

Collecting Monthly AWE Statistics

This applies to almost all AWE machines at MFRL... See below

You can not run this procedure for the current month; you must wait until after the first of the month and run this for the prior month.

1. Insert a flash drive into a usb port (usually on the left hand side of the Early Literacy Station)
2. Press CTRL + ALT + m to get into Administrative Settings – password is: mfrlels
3. At the left bottom of the screen, click the Utilization Statistics then click the Export button.
4. A pop up will ask you to name your file; it should be YYMMDDmachine, ie. 20221019BBELS01
5. Another pop up will appear for successful data export – click OK.
   • There is no way to do the usual “safe to remove” for the flash drive, so simply take it out of the usb port.
6. Click Cancel at the lower right of the screen. The ELS should return to normal operation.

Take the flash drive to a staff computer and connect it to a usb port.

Two files are created on the usb flash drive during the transfer process. They both have the same file name, ie. 20221019BBELS01 but have different file extensions. Use the *.csv/Excel file; the *.9csv can be discarded.

1. From the P-drive go to Public > Forms > Admin Forms;
2. Open AWE_Stats_Reporter.xltm
   • Note: If there is a Macros have been disabled message at the top of Excel, click the Enable Content button.
3. There is a tab Instructions that has more detailed information for transferring the data. Essentially:
   • Select all and then copy all data from the stats file
   • Go to Main tab of Reporter tab
   • Press CTRL + SHIFT + m
4. It may take several minutes to compile the data.
   • View the Answers tab for results.
5. Send the result totals to your Branch Manager

Collecting monthly AWE statistics 2021 Model – This is only BB-ELS01

You can not run this procedure for the current month; you must wait until after the first of the month and run this for the prior month.

1. Insert a flash drive into a usb port on the Early Literacy Station.
2. Press CTRL + ALT + m get into Administrative Settings.
3. Open Admin Panel – password is: mfrlels
4. Open Exports tab; click Export Stats.
5. Select the date range, from the 1st to the last day of the month.
   • The screen has a very dark background and it is difficult to see the calendar but there are arrows for previous and next month.
6. Click Export.
7. Click OK to file created but there is no need to save it.
8. Remove the flash drive.

Take the flash drive to a staff computer and connect it to a usb port.

1. From the P-drive go to Public > Forms > Admin Forms;
2. Open AWE_Stats_Reporter_2021Models.xltm
   • Note: If there is a Macros have been disabled message at the top of Excel, click the Enable Content button.
3. The tab on the bottom has the instructions for transferring the data. Essentially:
   • Select all and then copy all data from the *.usage stats file
   • Go to Main tab of Reporter tab
   • Press CTRL + SHIFT + m
4. It may take five to ten minutes for Excel to compile the data.
   • View the Answers tab for results.
5. Send the result totals to your Branch Manager

Collecting monthly Magic Desktop statistics

Stats are retrieved from the Magic Desktop website

1. Login as celledge@mfrl.org
2. Click on the Usage Stats tab.
3. Choose Last Month from the dropdown

No downloading of files is necessary; just report the number of sessions (and minutes, if desired) for your unit as displayed in the Usage table.