Search Tips
Account Management Apps Attendance Call Alerts Classroom Data Imports Data Security Directory Services Google Classroom Integration Grade Export Gradebook Groups Implementation
Lockers LoopMail Mobile School Loop Partner Gradebooks Portals Publishing Registration Sections School Settings Student Record Student Tracker Unification Webmaster Websites
Frequently Asked Questions Document Library Design Services Gallery of Sample Sites Help & Support
Free Webinars Website Accessibility Course Outlines On-Site Training Website Training
Account Management Grade Submission Gradebook LoopMail Trackers Miscellaneous
New Release Blog Replace Locker Files Teacher Usage Stats

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.

District-Wide Stats

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.

stats.pngstats2.png

What do these numbers mean?

Live Website "Yes" indicates a currently published website.
YTD PageViews The number of page views by all users in the current school year (includes website page views).
YTD Posts The number of posts made in the current school year. (Posts include assignments, events, notes, news, and LoopMail messages).
YTD Events The number of events posted in the current school year.
YTD News The number of news items posted in the current school year.
Groups The number of groups at the school.
Registered Teachers The number of registered teachers.
Teacher Websites The number of teachers with a currently published website.
Registered Students The percentage of registered students at the school.
Households The percentage of students with at least one registered parent.
 

School and Teacher Statistics

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:

Name The name of the school.
DomainName The School Loop URL for the school.
Published "True" or "false," indicating whether the school's School Loop website is published.
Teachers The number of registered teachers at the school.
Pub Teachers The number of teacher websites that are published.
YTD Posts The number of posts made in the current year. (NOTE: Posts include assignments, events, notes, news, and LoopMail messages).
YTD PageViews The number of page views by all users within the School Loop system in the current year (includes website page views).
Groups The number of groups at the school.
Events The number of events posted in the current school year.
News The number of news items posted in the current school year.
Students The number of registered students at the school.
Households The number of students with at least one registered parent.


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

School The teacher's school.
School Code The SIS school code for the school.
Product Which School Loop product that school uses (Standard, Plus Portal, or Plus GB).
First Name The teacher's first name.
LastName The teacher's last name.
Teacher Email The email address listed on the teacher's School Loop account.
Teacher ID The teacher's ID number.
Posts The number of posts in the last 30 days by this teacher. (NOTE: Posts include assignments, events, notes, news, and LoopMail messages.)
Students The number of total students (registered or unregistered) that are enrolled in the teacher's class(es).
Last Published The date and time the teacher last published grades.
Last Exported The date and time the teacher last exported grades.

Opening the Files with Excel

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." 

All Files Menu

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.

Step Two

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.