Overview

The School Statistics and Teacher Statistics options allow users to download a text file that contains the usage statistics for all schools and teachers, respectively. These text files can be opened using Microsoft Excel.

Reference Information

School and Teacher Statistics 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 nearly impossible to read in a standard text editor. By using Microsoft Excel, users can open these files and split the data into their correct columns. Once the data is split into columns, data can be read and sorted as needed to find the required information.

1. Open Microsoft Excel and click File>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: The required files may not show by default. In that case, use the drop-down menu at the bottom of the window to select All Files or Text Files instead of the default All Excel Files.

3. Select a file 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 to easily open these files.
4. On the initial page that appears, choose the radio button marked Delimited. The other options on this screen can be left 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 that have been 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 users to customize the formatting of each individual column that is being imported to Excel. No changes should be required on this page; simply 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.