Main Help Menu      Return to Reports Menu      General Reporting Procedures      Quick Instructions    Sample Report

 

SIS 2000+ Class Size Report Detailed Instructions Last update: 3/28/2001 jmm

This report is a listing of course sections in the Master Schedule with class enrollment counts for each school day within a user specified date range. A daily running average of the class enrollment is also calculated and printed. This report was originally designed for use in complying with the California Class Size Reduction Act, which sets maximum limits to class sizes in grades K to 3 over a specified range of days.

The user must select the track and the date range to be included on the report. The optional selection criteria include course, course group, faculty, faculty group, and department. The default sorting order for the records reported is by Course Code in ascending order. Each course section is then represented in a sub-grouping by the name of the faculty member teaching the section.

1. Open the report
From the SIS 2000+ Main Menu, click on the Scheduling icon button.

From the Scheduling Menu, click on the Reports icon button. Select the report's title from the list menu that appears. See General Reporting Procedures, Step 1 for more information on finding and opening a report.

Fig. 1 - opening screen, default Options
 

2. Define Parameters
The opening screen of this report (Fig. 1) contains three information screens: 'Options', 'Select', and 'Sort'. Click on each tab to view and define various parameters for the report, or continue to Step 3, "Print Preview" for viewing and/or printing the report using the default parameters.

2.1 Choose Options
Click on the 'Options' tab (Fig. 2). Choose options as follows:

Fig. 2 - sample user-defined options
 
• Title -

The default title for this report is "Class Size Report". The title may be edited by the user.
• Track -

Select an attendance track to report.
• Dates -

Define a date range to report by entering a beginning date and an ending (Through) date. Use the drop-down calendars activated by the field buttons. A maximum of 20 in-school days may be reported. If the date range selected includes more than 20 in-school days an error message will occur.
 
 


Click on the Reset command button to restore all Options to their default selections (Fig. 1).
 

2.2 Apply Select queries
SIS 2000+ reports can be instructed to print specific sets of records through the application of queries. A query is essentially a data filter. By defining criteria (parameters) for selected data fields, specific records can be retrieved. Click on the 'Select' tab. A list of data fields is displayed (Fig. 3). These are the data fields that will available for querying. The default criteria is "All" for each data field. To apply a select query to any data field, continue with Step 2.2.1. If no queries are needed, continue to the sorting procedure in Step 2.3.


Fig. 3
 

2.2.1 Select data fields and apply queries
Select a data field in the list until it is highlighted in gray (Fig. 3) and then click on the Edit command button. A criteria selection screen will open that is specifically designed for the selected data field. The sample in Fig. 4 shows the criteria selection screen for the Department data field with the 'English Department' selected. Click on the Done command button to apply the selection criteria.


Fig. 4 - sample criteria selection screen, Query Type 1

There are several possible types of queries, depending on the data field selected. Instructions on how to select and apply each type of query are found in the document titled General Reporting Procedures.
 

• Course = Query Type 3. A specific course or set of courses may be selected. If none are selected then "All" will be reported. All course sections for the selected course(s) will be printed.
• Course Group = Query Type 1. A specific course group or set of course groups may be reported. If none are selected then "All" will be reported. Course groups are pre-defined in the Group Editor application.
• Department = Query Type 1. A specific department or set of departments may be selected. If none are selected then "All" will be reported. Courses have been assigned to departments using the District Courses application.
• Faculty = Query Type 3. A specific faculty member or set of faculty members may be selected for reporting. If none are selected then "All" will be reported.
• Faculty Group = Query Type 1. A specific faculty group or set of faculty groups may be reported. If none are selected then "All" will be reported. Faculty groups are pre-defined in the Group Editor application.
 

Apply queries as needed for each of the above data fields.
 
 

Note on Query results:  Use caution when making multiple queries across data fields. Only records that satisfy all queries will be reported. Some queries may be mutually exclusive, causing the report to yield no records. In this type of situation there will be no pages to preview or print for the body of the report. This status will be indicated by the following error message appearing at the bottom of the cover sheet:  ***** NO RECORDS SELECTED FOR REPORT *****

 

2.2.2 Review selected parameters
After parameters are set and queries applied as needed, the view will return to the 'Select' screen. Each data field in the list will display a code after its name signifying the parameters currently applied. The sample in Fig. 5 shows the English Department (E) selected for reporting. Review the parameters. If all are satisfactory, continue to the sorting procedure in Step 2.3. If editing is required, repeat Step 2.2.1.


Fig. 6 - sample review



To restore a field's parameters to its default selection, highlight the field name in the 'Select' screen and click on the Reset command button.
 

2.3 Define the Sort order
Click on the 'Sort' tab. The 'Sort' screen (Fig. 6) displays the data fields used for sorting the records in the report. In this report, the default sorting order is:
 
Course Code = primary sort field


Fig. 7 - default sorting order
 

• Additional sorting fields may be added via the Add command button.
• A sorting field may be deleted by first selecting it in the list and then clicking on the Delete command button.
• The sorting order may be changed by shifting the position of a field in the list using the mover bar .
• The direction of a sort field (ascending or descending) may be edited by selecting the sort field from the list and using the Edit command (Fig. 8).


Fig. 8 - the sorting direction of the Course Code field is being changed to from Ascending to Descending
 

In the example below (Fig. 9) the Course Description and the Department fields were added to the list using the Add command button. Then the Department field was moved to the top of the list, making it the primary sorting field and Course Description field was moved to the position of secondary sort field, displacing the Course Code field to the position of the tertiary sort field. The Course Code field's sorting direction was changed from its default Ascending to Descending.


Fig. 9 - sample customized sort order

For further instructions on defining the sort order of a report, see General Reporting Procedures, Steps 2.3-2.3.4

2.4 Resetting global defaults



Global default parameters for all the screens can be reset by clicking on the Reset All command button at the bottom of the main screen.
 
 

The customized or default report can be previewed at any time before actual printing by clicking on the Preview command button. An option to print the report is available when the Preview is exited. For further instructions on previewing reports, see General Reporting Procedures, Step 3
 

4. Print the report to printer or to a file

Click on the Print command button to print the report to a printer or to a file without previewing it. For further instructions on printing reports, see General Reporting Procedures, Step 4
 

5. Exit report

Click on the Quit command button to exit the report screen at any time.

Main Help Menu      Return to Reports Menu      General Reporting Procedures      Quick Instructions    Sample Report