Tuesday, July 26, 2016

Using SIS Error Check to identify missing schedules

There are 3 major enhancements to SIS Error Check application:


  • Based on our analysis of just concluded year, we need to make sure each and every student in the system is scheduled correctly. This greatly reduces errors/problems in FTE, Student Record and CCRPI. (Pic 1 & 2)
  • Ability for administrators to be able to turn an error ON or Off, admin users still see ALL errors, error visibility only changes for school-based users. (Pic 2)
  • Ability for administrators to be able to see school counts for each error code. This is important when district users are trying to determine which schools need most help in terms of cleaning up their data. (Pic 3)
  • Identify students in grades K-8 who do not have 4 core courses (English/Lang arts, Science, Mathematics and Social Studies) scheduled. (Pic 4)

Pic 1




Pic 2


Pic 3
Pic4


You only need a read-only connection to your SIS backend database (SQL Server or Oracle)
Contact us if you would like to set this up and verify if every student in the system is scheduled correctly (before schools even start).

Sunday, May 8, 2016

Student Record Changes (April 2016)

New CCRPI Reports



both of these reports use Course History data for High school students along with students' current schedules. So, for these reports to work, necessary data needs to be imported from SIS database into FteTrack database. We already have scripts setup for Powerschool and Infinite Campus to do this, all you need is a read-only access to your SIS database. If you use an SIS other than the two mentioned above, contact us and we will provide file layouts to be used to export data out of your SIS.

Tuesday, March 29, 2016

Handling SLO Errors efficiently with FteTrack

Most school districts are having to deal with 100s or 1000s of the following errors:


  • E5095 - Course reported as SLO Course in Student Class must also be reported in SR System Course
  • E5096 - Course reported as SLO Course in SR System Course must be 'Y' for SLO Course in Student Class.
  • E6008 - If SLO COURSE = Y, then the SLO PRE-MEASURE is required if the MARKING PERIOD is one of the following 'Y1', 'N1', 'N2','N3',‘S1’, ‘S2’,T1’, ‘T2’, ‘T3’, ‘X1’, ‘X2’, ‘X3’,'X4', unless a valid exemption code is reported.
  • E6011 - In the March cycle, if SLO COURSE = Y, then the SLO POST-MEASURE is required if the MARKING PERIOD is one of the following,‘N1’, ‘N2’, 'S1',T1’, ‘T2’,‘X1’, ‘X2’, ‘X3’, 'X4'
Most of these can be fixed by fixing a few courses/sections even when the total number of errors may seem overwhelming (Pic 1).

Tuesday, January 19, 2016

FteTrack Changes (January 2016)

A new Data Element Total Service Minutes has been added to FTE file layout. Official Data Collection Documentation page defines this field as follows:

Report the total number of minutes for all IEP services which were in effect the week of the FTE count. Report for active students only.
One word of caution though, your SIS FTE Extract program may not have this new field in the file yet, so you may see a few of these new errors, but, you can still load the FTE file without this new data element. FteTrack will accept the file in old format, in fact, we encourage users to load their files regularly now and not wait for the DOE window to open, or, SIS vendor to release updates.

FteTrack file load process has been updated to account for this new data element, several new error codes (Fig 1) are associated with this field and can be found under "FTE Errors and Warnings summary". We also have a new report (Fig 2, 3 & 4) under "FTE MENU" with drill down capabilities.

Total Service Minutes has also been added to the Student Detail page (Fig 5)

Another big change that a lot of users have requested, is the ability to assign/remove access to individual applications (buttons on FteTrack Launchpad) for each user. Now, you can do that (Fig 6)
For example, you can give access to HR folks on CPI Track only, or, hide the CPI Track completely for school based users who don't need to deal with CPI information at all.