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

 

SIS 2000+ Behavior History Detailed Instructions Last update: 3/28/2001 jmm

This report provides administrators with a list of behavior incidents per student during a defined date range. Each entry displays the student's name and student ID number, incident name, gender, grade level, incident date, ethnicity, behavior incident points, alerts, and behavior reference. The report is highly customizable through the application of queries and by manipulating the sorting order.

See Behavior for more information on how behavior records are created.
 

1. Open the report
From the Behavior 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 "Behavior Report". The title may be edited by the user.
• Incident type -

Using the drop-down list, select a type of behavioral incident to report or select <All Incidents> (default). Selections available have been pre-defined for the district using the Table Editor program.
• Date Range -

Define a date range to report by selecting a beginning date and an ending date. Enter the dates by activating the drop-down calendars. If both boxes are left blank, no date range is used (default). If only the first date is specified, records greater than or equal to that date will be used. If only the second date is specified, records with an incident date less than or equal to that date will be reported. The second date must be greater than the first date.
• Alert -

Checking this option will restrict behavior incidents retrieved to only those that have the Alert field checked in the Behavior database. The Alert is a logical data flag field that will cause a notification to appear in the student's main demographic file (Student Editor). Alert-flagged incidents will be displayed in this Behavior History report with a "Y" in the Alert column. Non-flagged incidents will be blank.
• Points >= -

Enter a numerical value. Only behavior incidents with a point value equal to or greater than this number will be reported. Leave blank to ignore point values. Point values are assigned to each incident in the Behavior application to denote seriousness of the offense.
 
 


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 or sets of 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. Use the vertical scroll bar to view the entire list. The default criteria is "All" for each data field (with the exception of Enrollment). 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). 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 Grade data field with the 'Ninth' and 'Tenth' grades selected for reporting.


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.
 

• Enrollment = Query Type 2. Select one category from five possible system-defined enrollment codes: 'Active Students' (default), 'This Year's Students', 'Future Students', 'Inactive Students', or 'All Students'.
• Student = Query Type 3. A specific student or set of students may be selected for reporting. If none are selected then "All" will be reported.
• Ethnicity = Query Type 1. A specific ethnicity or set of ethnicities may be selected. If none are selected, then "All" will be reported.
• Gender = Query Type 1. A specific gender may be selected for reporting. If none are selected, then Male, Female, Unknown, and '< unset >' will be reported .
• Grade = Query Type 1. A specific grade level or set of grade levels may be selected. If none are selected, then "All" will be reported.
• Student Group = Query Type 1. Students belonging to a specific student group or set of student groups may be selected for reporting. If none are selected, then "All" will be reported. Student groups pre-defined in the Group Editor application.
• Track = Query Type 1. A specific track or set of tracks may be selected. Only tracks defined for the logged on site will be available for reporting. If none are selected, then "All" will be reported. If more than one track is reported, student records from all tracks will be combined during the sorting process. There is no designation for which student belongs to which track.
• Advisor = Students assigned to a specific advisor or set of advisors may be selected for reporting. If none are selected, then "All" will be reported. An "advisor" is a faculty member assigned to advise a student on a per track basis. Advisors are normally assigned at the time of enrollment via the Student Editor application. If the student is enrolled in more than one track at the same time, they could have more than one advisor. Advisor assignments are can be viewed or edited in a student's status records. See Sec. 7, "Edit 'General' Data".

 
 
Define criteria for the above queries and apply the query by clicking on the Done command button within each query screen.
 
 

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 (Fig. 5). Use the vertical scroll bar to view the entire list. 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. 5 - 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:
 
Name (student's last name) = primary sort field
Incident Date = secondary sort field
Incident Type = tertiary sort field
Advisor = fourth sort field
Incident Referred To = fifth sort field


Fig. 6 - 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 by dragging the mover bar with the mouse.
• 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. 7).


Fig. 7 - the sorting direction of the Incident Date field is being changed from Ascending to Descending
 

In the example below (Fig. 8) the Gender field was added to the end of the list. Then the Incident Type field was moved from the fourth position to the position of primary sort field by dragging it to the top of the list. All other fields were subsequently moved down one position. The sorting direction of the Incident Date field was then changed from its default Ascending to Descending.


Fig. 8 - 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