District Stats

District Admin acounts have 3 useful Stats tools available in the Toolbox on the right side of their portal. The district-Wide stats give you an online report and graphs of stats for your district. The School and Teacher Statistics produce download files for you to manipulate in Excel.

The default report is a summary of the YTD stats for the district office and all of your school sites (bottom left) based on data we collect from August to June. Using the Report View menu near the top of the page, you can also view graphical stats for the whole district, Plus schools, or Standard Schools. The school reports are available down to the individual school.

What do these numbers mean?

Clicking the School Statistics and Teacher Statistics links will download a text file that contains the usage statistics for either all of the schools in the district or all of the teachers.  Simply click the link and the file will begin to download -- note that you may need to approve the download and/or select the location to which you would like the files to be saved.

The School Statistics file has a single row for each school. Each row has 12 columns of data:

The Teacher Statistics file has a single row for each teacher, and nine columns of data:

These text files are pipe-delimited, meaning that each data point is followed by a "|" symbol indicating the end of that data column and beginning of the next. For this reason, they will be next to impossible to read in a standard text editor. By using Microsoft Excel, you can open these files and split the data into their correct columns. Once the data is split into columns, you can read it and sort the columns as you see fit to find the information you require.

1. Open Microsoft Excel and click File and then click Open (in newer versions of Excel, the file menu may be replaced by a circular icon in the top-left corner).

2. Navigate to the location where the files are stored on your computer.

Note that the files may not show by default -- in that case, use the drop menu at the bottom of the window to select "All Files" or "Text Files" instead of the default "All Excel Files." 

3. Select the file you want to open and click the Open button at the bottom of the window. At this point, Excel will automatically launch an import wizard that will help you easily open these files.

4. On the initial page that appears, choose the radio button marked "Delimited." You can leave the other options on this screen on their default settings. Click the Next button to advance to the next step.

5. On this next page, in the "Delimiters" section, check only the box labeled "Other." In the field next to this option, type a "|" symbol to indicate that the data is pipe-delimited. To the right of this area, find the "Text qualifier" drop menu and select "{none}" from this menu. Leave all other settings on their default.

6. The area at the bottom of the window will show a preview of how the data will look using the settings you've selected -- check to make sure that this area shows the data being split accurately into neat columns, then click the Next button to move to the final step.

7. The final step allows you to customize the formatting of each individual column that is being imported. You should not need to change anything on this page, so just go ahead and click the Finish button to complete the process. The text file will open with the data split neatly into columns. You can edit the text file in this format, or re-save the file in an Excel format, which will allow you to add spreadsheet features such as sortable columns and color-coding.