Scheduling Optimizer for Superior Scheduling
Master Schedule Grids
The Master Schedule Grids display the group of course sections associated with each teacher, room or course in a grid, or matrix, format. The grids show one row per term for each teacher, room or course with sections placed in columns by period. Each course section entry displayed in the grid shows the days, teacher, room and number of students assigned to the course section for the given term and period. Use the grids to analyze the utilization of individual teachers and rooms and the distribution of sections within a course. You may use the selection options to analyze all terms together or separately. If course department codes are available, you may select options which group teacher and course grids by department. Options also allow sorting teachers by teacher group.
The Teacher Name Grid by Term, displaying teacher class allocations in teacher name order within each term, is displayed when this group of reports is started. From this window, you can navigate forward and backward through groups of teachers or switch to a different Master Schedule grid display.
Sample Reports
Teacher Name Grid by Term
The teacher grids display one row per term for each teacher in the master schedule showing the classes taught by the teacher in each period during the term.
Room Grid by Term
The room grids display one row per term for each room in the master schedule showing the classes meeting in the room each period during the term.
Course Grid by Term
The course grids display one row per term for each course in the master schedule showing the section meetings for the course each period during the term.
How to Select Other Master Schedule Grids
 |
The reports menu appears near the top of the window.
When you first open the Master Schedule Grids, the menu box displays "--Select
Grid--" and Teacher Name Grid by Term is displayed as the current grid.
To view another report: The report you selected appears on the screen. This may take several seconds. |
Click on the down arrow on the right of the box. The list of available
reports is displayed.What Master Schedule Grids are Available
Master Schedule grids display master schedule data for teachers, rooms or courses according to the view option selected. The following table shows the order in which data is presented for each view option. Run the Reports Demo to see samples of these reports.
| Grid Title | Sort Order |
Teacher Name Grid by Term |
term, teacher name, period, course, section |
| Teacher ID Grid by Term | term, teacher ID, period, course, section |
| Teacher Group Grid by Term | term, teacher group(s), teacher name, period, course, section |
| Room Grid by Term | term, room ID, period, course, section |
| Course Grid by Term | term, course, period, section |
| Department Teacher Name Grid by Term | term, department, teacher name, period, course, section |
| Department Teacher ID Grid by Term | term, department, teacher ID, period, course, section |
| Department Course Grid by Term | term, department, course, period, section |
| Teacher Name Grid | teacher name, term, period, course, section |
| Teacher ID Grid | teacher ID, term, period, course, section |
| Teacher Group Grid | teacher group(s), teacher name, term, period, course, section |
| Room Grid | room ID, term, period, course, section |
Course Grid |
course, term, period, section |
| Department Teacher Name Grid | department, teacher name, term, period, course, section |
| Department Teacher ID Grid | department, teacher ID, term, period, course, section |
| Department Course Grid | department, course, term, period, section |
How to Read the Master Schedule Grids
Each Master Schedule Grid is displayed on one or more pages. Use the Next and Prev buttons to move through the pages. The Start button takes you to the first page, the End button takes you to the last page. On each page use the scroll bar, arrow keys, Edit-Find command and other navigational mechanisms provided by the browser to move through the currently displayed page.
Data Elements
Both the title columns and the contents of the grid cells display differently depending on the report options selected. A title identifying the report currently displayed appears above the report. The following data elements are displayed.
Title |
Description |
Example |
Comment |
Course ID, unique code for course |
0555 |
Left justified as character string, max of 14 wide |
|
Section, sequence number within course |
002 |
3 digits, left zero-filled |
|
Course Title, short title from Course atom |
Physics |
Width truncated at 18 characters |
|
| Tgp | Teacher groups to which teacher belongs | 9-1 | List of up to 4 3-character teacher group codes, separated by a space |
Dept |
Department code for the course from the Course atom |
SCI |
Left justified as character string, max of 4 wide. Title is suppressed if the field is blank. The department shown for a teacher is the one for the course in the first period taught. |
Teacher ID, from teacher atom |
52 |
4 wide, left justified as character string |
|
Teacher Name, last name plus part of first name as space permits |
Davis, J |
Width truncated at 18 characters |
|
Room ID, from room atom |
106 |
Left justified as character string, up to 6 characters |
|
Term |
Term number |
1 |
1 or 2 digits, left justified, 1-26 (displayed in the row label columns) |
Per |
Period |
06 |
2-digits, left zero-filled; period sequence number or, if provided, period code override (displayed in column headings) |
List of day/cycle codes when the class meets |
MTWRF |
Relative positions preserved (e.g. M W F) |
|
Fill |
Seats filled for the given meeting of the class (may vary by term) / Section capacity, the maximum number of students allowed in the class at one time |
27/40 |
Right justified, leading blanks, 0 value displays 0 |
Separator Lines Between Teacher/Room/Course
If you request a "combined terms" version of this report, there is a dark separator line when the rows for all terms for the same teacher/room/course finish and a new one begins. This makes the report easier to read.
Hiding Section Fill Data in Master Schedule Grids
In the Master Schedule Grids, the data content of each cell varies with the report option selected, but all options display the number of seats filled for every class which appears. The class filling data is useful in analyzing simulation results, but becomes outdated as soon as data changes are made. There is a checkbox on the report screen where you indicate whether or not you want section filling data displayed on the report.
- Check the "Hide section fill info" box, then click the Start button and you will see the report without the section filling data.
- To see the section filling data once again, uncheck the box and click the Start button.
Printer Friendly Version
The report offers a printer friendly version. Read more about this.
Using Department Codes
The Scheduling Optimizer relies on reading the department codes associated with courses from SASIxp database files in dBASE IV format. If you run SASIxp using a SQL Server or Oracle database, a workaround is needed to include department data in the Master Schedule Grids: use the xpodbc.exe utility (installed with SASIxp) to export the ACRS file from the database to dBASE IV files, then copy the exported dBASE IV files to the SASIxp DATAFILE subdirectory. You will need to run this procedure when you start a new scheduling year, but unless course department assignments change it does not need to be repeated in the scheduling year. See Department Codes in SQL Server and Oracle SASIxp Installations. (*** Linked to support/sqlorcl_dept.htm)