Using Schedule Analysis

Schedule Analysis (already installed on FteTrack server) helps you with:

• Identifying students with missing/incomplete schedules
• Reduce potential un-funded students/segments for FTE
• Review class size for various programs & services (identified easily by Course numbers)
• Make sure scheduling rules are followed for each school/ grade level
• Review teacher rosters for TKES/LKES system

Logging on to Schedule Analysis:
It's installed on the same server as FteTrack and you use the same userid and password that you use for FteTrack. URL for schedule analysis is http://[ftetrack server]/SA/index.html , where [ftetrack server] is the name or IP address of the machine where FteTrack is installed. For example, http://ftetrack.k12.ga.us/SA/index.html

Setting up Missing Core Courses Report in Schedule Analysis

Several people (thanks Jodi, Mike, Patricia and Samantha) have suggested that Missing Core Courses Report will be more effective if there was a way to configure the courses required by grade levels.

Now, there is way (see screenshots below). You can choose which courses are required for each grade level and Schedule Analysis will honor your selection when determining which students are missing one or more Core courses for the grade level they are enrolled in. This setup page is available in FteTrack setup menu.

This is how you can update your FteTrack installation files, or, let you know if we can help.

Pic1

Pic 2

CRDC Track

The 2013-14 CRDC will collect information about the 2013–14 school year from a universe of every public school district and school.

The following statement for this document on ED website for CRDC made me chuckle though:

 Public reporting burden for this collection of information is estimated to average 14.2 hours per school survey response and 4.2 hours per local educational agency (LEA) survey response, including time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information.

Are they kidding or just ignorant?

I have known school districts during the last CRDC reporting cycle (2011-12) where they had 3-4 people working full-time for months to be able to compile this massive dataset for all of their school and they had 12 schools.

Anyway, based on the guidelines from OCR website, we can conclude that most of the data elements ( > 80% ) at school level (both Part 1 & 2) can be easily derived from the existing FTE and Student Record datasets that each school district in Georgia already reports to the state.

The way this application works is, you load your October 2013 FTE file (for Enrollments) and 2013-14 Student Record files (for Course & Discipline related data elements). The application pre-fills forms for individual schools with more than 80% of data fields already filled in. Data elements that are not part of either FTE or SR data collection can be manually entered and saved into the form for each school.

Generating GHSA Form A directly from your SIS database

This application is Desktop java application that pulls data directly from Student Information System database (Powerschool and Infinite Campus only at this time), so, you will need the necessary information like your database server name/ip address, port etc.

Since this is a java application, you will need Java run-time environment 7 (JRE 7).

You want to download this file and just double click on the “jar” file, if you have the correct version of JRE installed, you should see the following screen.

Pic 1

If the connection to the PS database is successful, you will see a screen like the following with your High School names:

Pic 2

Pressing on the two buttons above will print the appropriate reports (one PDF per High School) in the same folder where you downloaded the “jar” file.

FteTrack and Schedule Analysis enhancements

FteTrack now gives school districts even more options to customize the application so that it fits a district's unique needs.

Most school districts have an "FTE Manual" that clearly states how to handle each individual DOE errors. Application administrators can now enter error resolution texts for each of these error codes in the application setup page (Pic 1 & 2), so that when a school user logs in and reviews his/her errors s/he will also have one two lines of text (Pic 3) that can guide the user in terms of how that error needs to be resolved.

Pic 1

Controlling Error visibility in Student Record application

One of our users had an interesting request:

She wants to be able to control what her school users see in terms of Errors and Warnings. SR application already allows admin users to turn an Error/Warning code on or off at System level. But, she wanted a more granular control, i.e., to be able to turn specific errors off for individual schools.

With the latest SR application update, you should be able to do this.

Turning off Errors at System level:

Picture 1

New Content Completer validation report

Content Completer data element is mandatory for each Course level record. This element, though new, is a critical data element and will potentially be used for a large number of CCRPI indicators.

There is a lot of confusion out there about how this element is going to be reported and how it's going to be used for CCRPI. Information available through the DOE is complex and confusing at this point. Furthermore, 2 weeks from the end of current school year and the DOE is still trying to finalize the requirements..

Having said all that, we have added a new Course level report that validates Content Completer flag. This exception report looks for the following:

• Content Completer = P and Numeric grade < 70 or Alpha Grade = F or N for any part of the course
• Content Completer = F and no part of the course has Numeric grade < 70 or Alpha Grade = F or N
• More than 1 part of the course being reported with Content Completer = P or F

Screenshots: