Contents
Installing Class Scheduler
Getting started
Using Class Scheduler
Working with Class Scheduler Data
Configuring Class Scheduler
Custom reporting
Customizing HTML reports
Multi-language support
Frequently Asked Questions
Copyright © CyberMatrix® Corporation, Inc. 2000 - 2005. All rights reserved.
Getting Started
Ways Class Scheduler Can be Used
There are three ways Class Scheduler can be used. Class Scheduler can be used for student-based scheduling, block scheduling and requirements-based scheduling. Student-based scheduling is used in most high schools, colleges and universities. In student-based scheduling, scheduling is done on a student by student basis where students have their own unique class schedule. Block scheduling is often used in elementary and middle schools where scheduling is done with groups of students at a time. Requirements-based scheduling is used to setup class times and the assignment of rooms and instructors before student scheduling actually takes place.
Entering Data
The first step in using Class Scheduler is to enter your data. Your data will include information about your students, classes and instructors. When you first use the program, there should be some sample data. Once you have finished experimenting with this data you should erase it and enter your own data. Data is erased and added in the Data Manager screen. See the Data Manager link for more details on deleting old data and entering new data.
Entering Class Data
The first step is to enter data for all your classes. First, you need to enter all the different class types. Class types are your core courses. Enter all your Class Type data in the Class Types table using the Data Manager. Classes are the different representations of your core courses. For example, if you teach History 101 this would be the Class type but you would have potentially several different History 101 classes, each at a different time, in a different room or with a different instructor. Class data is entered in the Classes table using the Data Manager. If you plan to use the requirements-based scheduling feature, you do not need to enter Classes data, as it will be automatically created for you.
Grades
Grades can be assigned to students and class types. When grades are assigned in this way, students in a particular grade can only be assigned courses that have been assigned the same grade. If a class has not been assigned a grade it can be assigned to any student regardless of what grade that student is in.
Pre-requisites
To setup the pre-requisites feature you first need to enter the pre-requisites into the Class Types table.
Requirements
If you plan to use the requirements-based scheduling feature, you will need to populate the Requirements table.
Related topics: Using Class Scheduler, Viewing and Editing Table Data
Using Class Scheduler
Getting to know the Main Screen
Assigning classes to students or groups
Auto scheduling a student or group
Auto assigning rooms to classes
Auto assigning instructors to classes
Auto assigning students to groups
Auto scheduling by requirements
Changing schedule filter
Searching for students
Viewing student gradebook and report cards
Viewing schedule reports
Viewing the Student Roster Report
Exporting schedule to CSV
Accounts Receivable
Working with Class Scheduler data
Getting to know the Data Manager
Viewing and Editing Table Data
Class Scheduler Tables
Viewing SQL Queries
Executing SQL Queries
Deleting records
Inserting Records
Re-indexing Tables
Backing up data
Restoring data
Importing and Exporting CSV Data
Avoiding data problems
Getting to know the Data Manager
The Class Scheduler program uses several data files. To view this data choose View | Data Manager from the main menu. The following screen will appear:
The Data Manager screen consists of the menu bar, the data navigator bar and the data tabs.
The Menu Bar
The menu bar has four sections: File, Search, Records and Help.
File Section
The File section contains the following functions:
Export to CSV - Exports the current table to CSV file format. See also: Importing and Exporting Data in CSV Format
Import CSV file - Imports a CSV file into the selected table.
New SQL File - Opens the Notepad text editor to allow you to create a new SQL file. See also: Viewing SQL Queries
Edit SQL File - Opens the Notepad text editor to allow you to edit an existing SQL file.
Open SQL File - Allows you to choose an existing SQL file and shows the results of that query in the detail tab data grid.
Execute SQL File - Allows you to choose an existing SQL file and executes that query.
Re-index Table - Re-index the currently selected table. See also: Re-indexing Tables
Close - Closes the Data Manager screen.
Search Section
The Search section allows you to find records when in the detail tab view. To search for a record you must first click in or tab over to the field in which you want to search. Then choose Find from the Search menu. In the dialog that pops up, enter the text you want to search for then press the Find Next button. To find the next occurrence of that text press the Find Next button again.
Records Section
The Records section contains the following functions:
Insert Record - Inserts a record above the current record. See also: Inserting Records
Delete Selected Records - Delete all the selected records. See also: Deleting records
Delete All Records - Deletes all the records in the current table.
Backup Data - Makes a time-stamped backup file of all tables. See also: Backing up Data
Restore Data - Replaces your existing data with the tables from a previous data backup. See also: Restoring data
E-Mail Data Backup - Makes a time-stamped backup file of all tables and brings up the e-mail form to allow you to send your data to someone. Useful when asking for support for data-related problems.
The Data navigator Bar
The bar at the top is the data navigator. The data navigator is for navigating the records of the current table. The first button |< will move to the first record of the current table. The second button < will move to the previous record. The third button > will move to the next record. The fifth button >| will move to the last record. The + button will add a new record. The - button will delete the current record. The button with the check mark will save changes made to the current record. The x button will cancel any changes made to an unsaved record. The last button refreshes the current table to show the latest changes made to it.
The Data Tabs
The data tabs show all the tables used in Class Scheduler and allow you to view and edit the data in them. See the Viewing and Editing Table Data section for more details.
Viewing and Editing Table Data
There are two ways to enter table data: in form view and in detail view.
Entering data in form view
To enter data by form view choose the tab corresponding to the table for which you wish to enter data. A form will appear showing all the fields in that table. To add a new record press the + button on the data navigator bar. A blank record field will appear. Enter data in the fields and press the check mark on the data navigator bar. This saves the record changes.
Entering data in detail view
To view the data for a table in detail view first choose the Detail tab. The screen should look like this:
To view the data in a table choose the table's radio button in the left box. The table's data should then appear in the grid to the right. The data may now be edited directly in the grid. After editing a record, the changes will be saved after you move off the edited record.
Currently, data from SQL queries may not be edited in this way.
You can cancel any changes you made to a record by either clicking the Cancel button (the big X) on the Database Navigator at the top of the screen or by simply hitting the ESC key.
Editing existing records
If you need to edit an existing record, first move to that record. You can use the arrow keys in the left part of the data navigator bar. The first button |< will move to the first record of the current table. The second button < will move to the previous record. The third button > will move to the next record. The fourth button >| will move to the last record.
When you've found the record you want to edit, make your changes and save them by pressing the data navigator bar button with a check mark or just move to another record. If you want to cancel the changes you just made, click the data navigator bar button with an x in it or press the Esc key.
Key Fields
Most tables have what are called key fields. Key fields are required fields that make each record unique. If you add a record but fail to enter the key fields, you will get an error something like "FieldX must have a value" when you try to save the record. In such a situation, you will have to either enter the key fields or cancel the changes.
Class Scheduler Table Details
Class Scheduler has 20 tables: AccountsReceivable, Attendance, Buildings, Classes, ClassTimes, ClassTypes, Gradebook, Groups, Holidays, Instructors, Requirements, Rooms, Students, StudentClasses, StudentDiscipline, StudentHealth, StudentPreReqs, Terms, Users and Security. The field sizes and descriptions for all the tables are detailed below. Required fields are shown in bold.
Accounts Receivable
This table keeps track of students enrollment payments. Here are the field sizes and descriptions:
Invoice - AutoInc - unique
StudentID - String - 15
Term - String - 10
Amount - Currency
InvoiceDate - Date
PayDate - Date
PaymentType - Unsigned Integer
CardNumber - String - 16
CardExpireDate - String - 5
CardSecurityCode - String - 4
AuthorizationNumber - String - 8
Phone - String - 20
BillingAddress - String - 250
Notes - String - 250
Attendance
This table keeps track of attendance of individual students. Here are the field sizes and descriptions:
StudentID - String - 15 - unique
AttendanceDate - Date - unique
Class - String - 15
InstructorID - String - 15
Note - String - 250
PartialDay - Boolean
The StudentID field links to the StudentID field of the Students table. The ClassID field links to the Class field in the Classes table. The InstructorID field links to the InstructorID field in the Instructors table.
Buildings
This table lists all buildings containing classrooms. Here are the field sizes and descriptions:
Building - String - 10 - unique
Description - String - 20
Classes
This table lists all the available classes. Here are the field sizes and descriptions:
Class - String - 15 - unique
ClassType - String - 15
Description - String - 30
Term - String - 5
Room - String - 10
Capacity - Integer
Security - String - 1
StartTime - Time
EndTime - Time
StartDate - Date
EndDate - Date
Days - String - 20
Notes - String - 250
Instructor - String - 10
Building - String - 20
Email - String - 30
RoomType - String - 10
Color - Integer
CreditHours - Integer
The Class field is a unique identifier for the class. Every different class must have it's own ID. The Class Type field identifies which class type to which the class belongs. The ClassType field links to the ClassType field in the ClassTypes table. The description can be anything you like. It is used to assign a name to the class ID. The Term field is optional. It indicates which term the class falls in. The Term field links to the TermID field in the Terms table. The optional Room field indicates in which room the class takes place. The Room field links to the RoomID field in the Rooms table. The Capacity field indicates the maximum number of students that can take this class. The Security field can be set to either A (Administrator) or U (user). When the security is set to A, only administrators can assign this class to a student. The Start and End Time fields indicate at which time the class will start and when it will end. The optional Start and End date fields indicate on which day the class starts and when it ends. The Instructor field indicates who will be teaching the class. The Instructor field links to the InstructorID field in the Instructors table. The optional Building field indicates which building the class takes place in. The Building field links to the Building field in the Buildings table. The optional E-mail field is for placing an e-mail address of the person responsible for this class. When the class is dropped and the Notify On Class Drop configuration setting has been set, a drop notice will be sent to this address. The RoomType field links to the RoomID field in the Rooms table.
The Days field indicates on which days of the week the class will occur. The Days field can contain any combination of days in the format [Mo,Tu,We,Th,Fr,Sa,Su]. The days must be separated by commas. The best way to add days is to click the ellipsis button to the right of the Days field. A selector box will pop up. Hold down the Ctrl key and click the days the class will occur. Then click the OK button. The optional Room Type field indicates the special kind of room the class requires. For example, a chemistry class would require a special chemistry lab. The RoomType field links to the RoomType field in the Rooms table.
The Color field indicates the color a class will have when viewed in the main screen. To change the color, click the ellipsis button to the right of the Color field. A color selector box will pop up. Click the color you want and press OK. If both a class and its class type have different colors associated with them, the class color will take precedence.
The CreditHours field indicates how many credit hours this course counts towards on completion.
ClassTimes
This tables lists all the possible time periods for your class schedules.
Here are the field sizes and descriptions:
StartTime - Time
EndTime - Time
Day - String - 2
Description - String - 20
Break - Boolean
There are two ways the ClassTimes table is used: to break up the schedule into visible time periods and to assign different time periods for different days for use in requirements scheduling. The day field can contain any single day in the format [Mo,Tu,We,Th,Fr,Sa,Su]. The Day field can also be blank. Times where the Day field is blank are used to setup the schedule's visual time periods. The break field if set true will cause that time period to be shown as grayed out in the schedule.
ClassTypes
This table lists all the class types. Class types are used to group together the unique classes. For example, Math30a and Math30b are unique class names that would belong to the Math30 Class Type.
Here are the field sizes and descriptions:
ClassType - String - 15 - unique
Description - String - 30
PreReqs - String - 250
Grade - Integer
Color - Integer
Cost - Currency
The Class Type field is a unique identifier for the class type. Every different class type must have it's own ID. The description can be anything you like. It is used to assign a name to the ID. The Grade field is optional. Grades can be assigned to students, groups of students and class types. When grades are assigned in this way, students in a particular grade can only be assigned courses that have been assigned the same grade. If a class has not been assigned a grade it can be assigned to any student regardless of what grade that student is in. The Pre-Reqs field is also optional. It identifies any pre-requisite class types that must be completed before a student can be enrolled in the current class type. Each class pre-requisite is separated by a comma. It is very important that each pre-requisite is an existing class type. If a ClassType requires no pre-requisites, just leave this field blank. The best way to add pre-requisites is to click the ellipsis button to the right of the Pre Reqs field. A selector box will pop up. Hold down the Ctrl key and click the class types that are pre-requisites for the current class type. Then click the OK button. The Color field indicates the color a class with this class type will have when viewed in the main screen. To change the color, click the ellipsis button to the right of the Color field. A color selector box will pop up. Click the color you want and press OK. The Cost field indicates how much it costs to take this class.
Gradebook
This table lists all the student grades. Here are the field sizes and descriptions:
StudentID - String - 15
ClassID - String - 15
GradeDate - Date
PercentGrade - Float
LetterGrade - String - 2
Note - String - 250
Groups
This table lists all the student groups. Here are the field sizes and descriptions:
Group - String - 10 - Unique
Grade - Integer
Capacity - Integer
The Group field is a unique identifier for the group. Every different group must have it's own ID. The Grade field is optional. Grades can be assigned to students, groups of students and class types. When grades are assigned in this way, students in a particular grade can only be assigned courses that have been assigned the same grade. If a class has not been assigned a grade it can be assigned to any student regardless of what grade that student is in. The capacity field indicates the maximum number of students can belong to each group.
Holidays
The Holidays table lists all the statutory holidays. Currently this table is not used by the program. Here are the field sizes and descriptions:
HolidayDate - Date - unique
Holiday - Text - 30
Instructors
This table lists all class instructors. Here are the field sizes and descriptions:
InstructorID - String - 15 - unique
Name - String - 30
Classifications - String - 50
Phone - String - 20
Address1 - String - 25
Address2 - String - 25
City - String - 15
State - String - 2
PostalCode - String - 10
Notes - String - 250
ClassQualifications - String - 250
Priority - Integer
AvailableFrom - Time
AvailableTo - Time
MaxClassSize - Integer
MaxClasses - Integer
The InstructorID field links to the LoginID field of the Security table. The InstructorID field is a unique identifier for the instructor. Each different instructor must have their own ID. The Classifications field indicates any special classifications the instructor might have. For example, this field might be used to identify instructors that have knowledge of CPR. The ClassQualifications indicates which ClassTypes the instructor is able to teach. Multiple class types are separated by commas. The Priority field is used when using the Assign Instructors to Classes feature. The lower the number the greater the priority the instructor will be assigned to classes first. The AvailableFrom and AvaliableTo fields indicate which times of day the instructor is available to teach classes. The MaxClassSize field indicates the maximum number of students the instructor is willing to teach. The MaxClasses field indicates the maximum number of classes the instructor is willing to teach in a given term.
Requirements
This table is used to enter the requirements used in the Auto Schedule by Requirements feature. Here are the field sizes and descriptions:
ClassType - String - 15
NumberOfClasses - Integer
InstructorID - String - 15
RoomType - String - 10
Days - String - 20
StartTime - Time
EndTime - Time
ClassDuration - Integer
The Class Type field identifies to which class type the class belongs. The ClassType field links to the ClassType field in the ClassTypes table. The NumberOfClasses field indicates the number of number of classes of this type you want scheduled. The Instructor field links to the InstructorID field in the Instructors table. The optional Room Type field indicates the special kind of room the class requires. For example, a chemistry class would require a special chemistry lab. The RoomType field links to the RoomType field in the Rooms table. The Days field can contain any combination of days in the format [Mo,Tu,We,Th,Fr,Sa,Su]. The days must be separated by commas. The StartTime and EndTime fields indicate within which times of day the class can be taught. If the StartTime and EndTime fields are left blank, the class is assumed to be available all day long. The ClassDuration field indicates how long in minutes the class will last.
Rooms
This table lists all classrooms. Here are the field sizes and descriptions:
RoomID - String - 5 - unique
Description - String - 30
RoomType - String - 10
Capacity - Integer
The Room field is a unique identifier for the room. Every different room must have it's own ID. The capacity field indicates the maximum number of students can occupy each classroom. The optional Room Type field indicates the special kind of room the class requires. For example, a chemistry class would require a special chemistry lab.
Security
This table lists all user names and their associated passwords. It is used to enforce security and is therefore encrypted. Here are the field sizes and descriptions:
LoginID - String - 15 - unique
Password - String - 10
StudentClasses
This table lists all the students' currently enrolled classes. Here are the field sizes and descriptions:
StudentID - String - 15
Class - String - 15
Paid - Boolean
Each record in this table forms a unique pair.
The StudentID field links to the StudentID field of the Students table. The Class field links to the Class field in the Classes table. The Paid field indicates whether the student has paid for this class.
StudentDiscipline
This table lists all the students' disciplinary actions. Here are the field sizes and descriptions:
StudentID - String - 15
DisciplineDate - Date
Notes - String - 250
The StudentID field links to the StudentID field of the Students table.
StudentHealth
This table lists all the students' health records. Here are the field sizes and descriptions:
StudentID - String - 15
VisitDate - Date
Notes - String - 250
The StudentID field links to the StudentID field of the Students table.
StudentPreReqs
This table lists all the students' passed classes that count as pre-requisites for other classes. Here are the field sizes and descriptions:
StudentID - String - 15
Class - String - 15
Each record in this table forms a unique pair.
The StudentID field links to the StudentID field of the Students table. The Class links to the ClassType field in the ClassTypes table.
Students
This table lists all students. Here are the field sizes and descriptions:
StudentID - String - 15 - unique
Name - String - 30
Classifications - String - 50
Phone - String - 20
Address1 - String - 25
Address2 - String - 25
City - String - 15
State - String - 2
PostalCode - String - 10
Notes - String - 250
Group - String - 10
Grade - Integer
Phone2 - String - 20
Phone3 - String - 20
Phone4 - String - 20
AltAddress1 - String - 25
AltAddress2 - String - 25
Ethnicity - String - 1
Gender - Boolean
BirthDate - Date
Color - Integer
The StudentID field is a unique identifier for the student. Each different student must have their own ID. The StudentID field links to the LoginID field of the Security table. The Grade field is optional. Grades can be assigned to students, groups of students and class types. When grades are assigned in this way, students in a particular grade can only be assigned courses that have been assigned the same grade. If a class has not been assigned a grade it can be assigned to any student regardless of what grade that student is in. The Group field indicates to which group the student belongs. This field is only needed if you plan to schedule using groups of students instead of individual students. The Group field links to the Group field in the Groups table. The Classifications field indicates any special classifications the student might have. For example, this field might be used to identify students that have knowledge of CPR.
Currently the Color field is not used.
Terms
This table lists all class terms. Here are the field sizes and descriptions:
TermID - String - 5 - unique
Description - String - 20
Users
This table lists all the users of the software. Here are the field sizes and descriptions:
LoginID - String - 30 - unique
LastIn - TimeStamp
LastOut - TimeStamp
Viewing SQL Queries
It is possible to view the results of simple SQL statements stored in external text files. SQL stands for Structured Query Language; it is a way to communicate with databases using English-like commands.
To work with SQL queries you must be in the Detail tab of the Data Manager. To create a new SQL file either create one using any text editor or choose File | New SQL File from the menu. Save the SQL file to a folder, usually the Class Scheduler Data folder.
To open a previously saved SQL file choose File | Open SQL File from the menu. A file select dialog will pop up allowing you to choose a SQL file. After selecting a file, you should see the results of the query in the data grid.
Here is an example of simple SQL Select query:
SELECT [Name], [Class]
FROM Students T1, StudentClasses T2
WHERE [Classifications] like "%Band%" And T1.StudentId=T2.StudentId
ORDER BY Name
This query shows the names of all band students and their classes.
For more information on SQL, consult a good introductory database textbook. There is also some documentation on the supported SQL calls in the database engine manual. To read this manual choose Help | DB Engine Manual from the Data Manager menu.
Executing SQL Queries
It is possible to execute simple SQL statements stored in external text files. SQL stands for Structured Query Language; it is a way to manipulate information from databases using English-like commands.
To create a new SQL file, either create one using any text editor or choose File | New SQL File from the menu. Save the SQL file to a folder, usually the Project Clock Data folder. Remember to save with the .SQL extension.
To open a previously saved SQL, file choose File | Open SQL File from the menu. A file select dialog will pop up allowing you to choose a SQL file. After selecting a file, you should see the results of the query in the data grid.
Here is an example of a simple SQL Update query:
UPDATE Classes SET ClassType='Bio300' WHERE ClassType='Bio3'
This query will update all time records where the ClassType is "Bio3". For these records, the ClassType will be renamed to "Bio300".
For more information on SQL, consult a good introductory database textbook. There is also some documentation on the supported SQL calls in the database engine manual. To read this manual, choose Help | DB Engine Manual from the Data Manager menu.
Deleting records
To delete a record when in form view, navigate to the record and press the - button on the navigator bar.
To delete one or more records in the detail view, select the records to delete. To select multiple records, click on the first record then hold down the [Ctrl] Key and click to select individual records or hold down the [Shift] key to select a range of records. To delete the selected records either press the [Ctrl]+[D] key combination or choose File | Delete Selected Records from the menu. To delete all the records in the current table choose File | Delete All Records from the menu.
Inserting Records
To insert a record when in form view, press the + button on the navigator bar.
To insert a record in the detail view, click on the record above which you wish to insert a record. Then either press the [Ctrl]+[I] key combination or choose File | Insert Record from the menu.
Re-indexing Tables
Over time, one of your tables may become corrupted. This sounds worse than it is. When a table becomes corrupted it usually just means the table's index has been compromised and needs to be rebuilt. See the section Avoiding Data Problems to learn more about table corruption. Usually when a table is corrupted, you will see an error message such as:
DBISAM Engine Error #9217 Error reading From Data File C:\Program Files\ClassSched\data\Students.dat
Re-indexing (repairing) the table is simple. Just select the affected table in the detail view and then choose File | Re-index Table from the Data Views menu. It does no harm to re-index a non-corrupt table.
DBSys
If you are unable to open the application to re-index a table, you can get the DBSys utility. DBSys is a utility from Elevate Software, the makers of the database engine used in Class Scheduler. Use this program to repair the affected table.
Last Resort
If after trying all these solutions you still have problems, use the Data Backup feature (see section below) to create an archive of the problem data files and e-mail it to UNCONVERTED WINHELP MACRO:! ExecProgram("support@cybermatrix.com",)CyberMatrix support.
Related topics: Avoiding data problems
Backing up Data
To create a backup of your data choose Records | Backup Data from the menu in the Data Manager screen. Running this function will create a zip file in the Data\Backup folder. The zip file will have a name consisting of the current date and time the archive was completed.
Related topics: Restoring Data
Restoring data
To restore previously archived data choose Records | Restore Data from the Data Manager menu. A file select dialog will pop up allowing you to choose the archive you would like to restore.
Related topics: Backing up data
Importing and Exporting Data in CSV Format
Importing Data
Class Scheduler can import data in the form of comma-separated CSV files. If you have existing data from another application, this data can be imported into Class Scheduler provided it is saved in the right format. CSV files used for importing must follow the exact same format as the table into which they will be imported. That is, if you look at a table in the detail view of the Data Manager you will notice the order of the fields in the table. This is the same order in which your CSV file must be. Most spreadsheet programs like Microsoft Excel allow you to easily load in CSV file and move columns around.
See the section Class Scheduler Tables for more details on field types and sizes.
To import a CSV file first select the table you want to import into from the Data Manager. Then choose File | Import From CSV from the Data Manager menu. A file select dialog will allow you to select the CSV file to import.
NOTE: any date or time fields must be in the exact same format as that format used in the Regional Setting control panel settings. Otherwise data import may not work correctly.
Exporting Data
Data can also be exported in CSV file format from Class Scheduler. This data can be imported into other applications that can handle CSV imports.
To export a CSV file first select the table to export from the Data Manager. Then choose File | Export To CSV from the menu. A file select dialog will allow you to select the CSV file to export.
Related topics: Viewing and Editing Table Data
Getting to Know the Main Screen
On running the program, the following screen will appear.
The Class Scheduler main screen consists of the menu bar, the tool bar, scheduler view and the status bar.
The menu bar
The menu bar has five sections: File, Search, View, Tools and Help.
The File section
The File section contains the following functions:
Export schedule to CSV - Exports the current schedule to the CSV data format. This feature was added to enable blind students a way to access their schedules. See also: Exporting schedule to CSV
Login - Allows Administrator or user to login to the system. This item is only seen if security has been enabled.
Logout - Allows Administrator or user to log out of the system. This item is only seen if security has been enabled.
Change Password - Brings up the change password dialog that allows you to change your log in password.
Open Site - Brings up the Choose Site dialog that allows you to choose a different site. See also: Site Editor tab
Language - Contains a sub menu of all the different language available for this program. To change to a different language just select the desired language from the sub-menu. See also: Multi-Language Support
Exit - Closes Class Scheduler.
The Search section
The Search section contains the following functions:
Find Student - Searches for student schedules by class and student classification. See also: Searching for Students
Find Next - Brings up the next student's schedule.
The View section
The View section contains the following functions:
Data Manager - Brings up the Data Manager screen. The Data Manager is used to manipulate the data used in Class Scheduler. See also: Class Scheduler data
Configuration - Brings up the configuration screen. The configuration screens allows you to customize Class Scheduler to a certain extent by changing several different options. See also: Configuring Class Scheduler
Filters - Brings up dialog to allow changing the schedule filter. See also: Changing Schedule Filter
Show All Classes - Shows all classes on the schedule with the filtered classes white and the other classes silver. See also: Adjusting Classes From the Schedule
Reports - Brings up the Report screen to view schedule reports. See also: Viewing schedule reports
Print Schedule Report - Sends the current screen schedule to your printer.
Schedule HTML Report - Brings up an HTML report matching the screen schedule.
Student Roster - Brings up the student roster report screen. The student roster report enables you to see a list of all the students enrolled in a particular class. See also: Student roster report
Student Gradebook - Brings up the student gradebook screen. The student gradebook screen enables you to enter grades for all the students. See also: Student gradebook
Refresh Schedule - Refreshes the current schedule with the most recent data from the database.
The Tools section
The Tools section contains the following functions:
Edit Class Enrollment - Brings up a dialog to allow assignment of classes to students or groups. See also: Assigning classes to students or groups
Auto Schedule Student - Automatically generates a list of possible schedules for individual students given a list of desired classes. See also: Auto scheduling a student or group
Auto Schedule Students in Bulk - Automatically generates schedules for students in bulk given a list of students and their desired classes. See also: Auto scheduling a student or group
Assign Rooms to Classes - Runs a function to automatically assign rooms to classes as efficiently as possible. See also: Auto assigning rooms to classes
Assign Instructors to Classes - Runs a function to automatically assign instructors to classes as efficiently as possible. See also: Auto assigning instructors to classes
Assign Students to Groups - Runs a function to automatically assign students of the same grade to groups. See also: Auto assigning students to groups
Auto Schedule by Requirements - Runs a function to automatically setup classes based on entered class requirements. See also: Auto scheduling by requirements
Assigning classes to students or groups
If Class Scheduler has been configured to schedule by groups (blocks) of students instead of individual students, classes will be assigned to groups. Otherwise, classes will be assigned to individual students.
To assign classes to a student or group choose Tools | Edit Class Enrollment from the main menu. The following screen will appear:
To view the assigned classes and available classes for a student or group choose that student or group from the Student/Group pull-down list. To enroll a student in classes or assign classes to a group, select the desired classes in the Available Classes box to the right. Then either drag them with the mouse to the Enrolled Classes box to the left or click the < button.
If you do not want to bother with pre-requisite classes be sure to check the Override pre-requisites box.
Double click on a class to see it's details.
Press the Save button to save changes or the Exit button to ignore any changes and return to the main screen.
Related topics: Schedule tab options
Auto scheduling students or groups
The auto-schedule feature automatically generates a list of possible schedules given a list of desired classes. Auto scheduling can be done individually for each student or block or for all students.
If Class Scheduler has been configured to schedule by groups (blocks) of students instead of individual students, schedules will be automatically generated for groups. Otherwise, schedules will be automatically generated for individual students.
Auto Scheduling Individual Students
To auto schedule an individual student or group choose Tools | Auto Schedule Student from the main menu. The following screen will appear:
To view the available classes for a student or group choose that student or group from the Student/Group pull-down list. To generate a schedule for the student or group, select the desired classes in the Available Classes box to the right. Then either drag them with the mouse to the Desired Classes box to the left or click the < button.
Press the OK button to generate a list of schedules or the Cancel button to return to the schedule screen.
After pressing OK the Select Schedule screen will appear:
This screen lists all the possible schedules the student could have. To preview a schedule click the schedule to select it and then click the Preview button. A schedule report will appear showing the schedule. Select the schedule you prefer and press OK. These classes will now be assigned to the student or group.
Auto Scheduling Students in Bulk
To auto schedule students or groups in bulk choose File | Auto Schedule Students In Bulk from the main menu. A dialog box will appear asking you to choose a CSV file containing a list of all students and the desired classes they want. The CSV file should consist of comma separated values starting with the student ID and then the list of classes that student wants. The records should not contain any spaces. Here is an example CSV file:
dennese,Hist10,Math30,Soc30
ksumner,Hist10,Math30,Soc30
Select the CSV file and then click the Open button. The schedules will then be created.
Auto assigning rooms to classes
The Assign Rooms to Classes feature automatically assign rooms to classes as efficiently as possible. If the different classes have the RoomType field populated, only rooms of that type will be assigned to these classes. If the rooms and classes have the Capacity fields populated, rooms will be assigned to only to classes that most closely match their capacity without going over.
To auto assign rooms to classes choose Tools | Assign rooms to classes from the main menu.
Auto assigning instructors to classes
The Assign Instructors to Classes function automatically assigns instructors to classes as efficiently as possible. If the Priority field in the Instructors table has been set, those instructors with the highest priority (0 would be highest) would be assigned to classes first.
To auto assign instructors to classes choose Tools | Assign instructors to classes from the main menu.
Auto assigning students to groups
The Assign Students to Groups feature automatically assign students of the same grade to groups taking into account the group's capacity if any.
To auto assign students to groups choose Tools | Assign students to groups from the main menu.
Auto scheduling by requirements
The Auto Schedule by Requirements feature automatically sets up classes based on entered class requirements.
If you need different class times for different days you can use the Add Daily Schedule Times feature in the Schedule tab of the Configuration Screen. See: Schedule Options
To auto schedule by requirements first populate the Requirements table using the Data Manager. Then choose Tools | Auto Schedule by Requirements from the main menu. Note that for this function to work each room must have been assigned a capacity.
Changing Schedule Filter
By changing the schedule filter, you can see schedules for individual students/groups, teachers, classes and rooms. To change the schedule filter choose View | Filters from the main menu. The following screen should appear:
Select either a class, a room, student/group or instructor from the corresponding pull-down lists. You must also choose a term. For advanced filters, you can use the SQL filter box. In this box enter a SQL WHERE clause for the classes table without the WHERE keyword. Pressing the OK button will change the schedule filter. Pressing the Cancel button will leave the existing filter unchanged.
Searching for Students
It is possible to search for student schedules by class and student classification. To search for a student press the Ctrl + F key combination or choose File | Find Student from the main menu. The following screen should appear:
Enter either a search term in either the Class field or the Classification field, or both. In the above example, all students enrolled in any history classes that are also classified as band students would be found. After pressing the Find button you'll return to the main schedule window with the first student's schedule appearing that matches your search criteria. To see the next student's schedule, press the F3 key.
Adjusting Classes From the Schedule
Classes can be adjusted by administrators right from the schedule view. To delete a class first select the class by right clicking on it. From the pop-up menu select Delete class.
The pop-up menu contains three other items. Add class, Assign to room and Assign to Instructor. These three item only work when all classes are shown on the schedule and you right click on a silver-colored class. To show all classes on the schedule choose View | Show All Classes from the main menu. This causes all classes to be displayed on the schedule with the filtered classes white and the other classes silver. Classes can be added only when filtering by student. To add a class first select an available class. Available classes will be silver. Then right click on the class. From the pop-up menu select Add class.
Only when filtering by room will the Assign to room feature be available. Only when filtering by instructor will the Assign to instructor feature be available. The Assign to room feature allows the selected class to be assigned to the currently filtered room. The Assign to instructor feature allows the selected class to be assigned to the currently filtered instructor.
The start and end times can be adjusted by moving the class to a different position within the same day. To move a class first select it by clicking on it. Then hold down the mouse button and drag the class to the desired position. If there is a conflict you will see a message and the class will move back to where it originally was. Class duration times can also be increased or decreased by dragging the top and bottom edges of the class.
Viewing schedule reports
Choosing View | Reports from the main menu will bring up the following screen.
To view a schedule, first choose what type of schedule you want to see. Schedules can be seen by student, instructor, class or room. Next, filter the schedule if desired and choose a term from the Term pull-down list. For example, to see student schedules select Student from the Report On radio box. If you wish to see a schedule only for a single student choose the desired student from the Student pull-down list. If no student is chosen schedules for all the students will be printed. Pressing OK will preview the report.
Schedules can be filtered by term or date. To filter by term select Term from the Date filter radio box. Then select the term for which you wish to see the schedule. To filter by date select Date from the Date filter radio box. Then select the date for which you wish to see the schedule.
To set advanced filters you can use the SQL filter. You will need to know SQL to use this feature. To filter by SQL merely enter the WHERE clause of a SQL statement in the SQL memo field without including the WHERE term. For example, suppose you wanted to see schedules for all students in band. You would then enter this in the SQL field: [Classifications] like "%Band%"
Printing a report
To print a report from the preview screen simply click the printer icon.
Exporting reports
The reports in this software can be exported to several different formats:
Report file
Adobe Acrobat PDF File - can be viewed by Adobe Acrobat.
HTML File - can be viewed in web browsers.
Excel Table File (OLE) - can be viewed in Microsoft Excel.
Excel Table File (XML) - can be viewed in Microsoft Excel.
RTF (Rich Text Format) - can be viewed in most word processors like Word.
Text File - can be viewed in and text editor.
CSV File - can be viewed in spreadsheet programs like Excel.
Email - can be sent out in an email.
To export a report first preview by selecting File | Print Preview from the menu. When the report comes up on the screen click on the export icon to the right of the floppy disk icon on the toolbar. A list of report formats will appear. Click on the desired format. A Export dialog will appear. Press OK. Type in the desired file name and choose the file type you would like the report exported to. Then press the Save button.
Related topics: Custom reporting
Student roster report
The student roster report enables you to see a list of all the students enrolled in a particular class.
This screen can also be used to quickly find details about a certain class, such as the number of seats available.
To view a student roster report choose View | Student Roster from the main menu. The following screen will appear:
Select a class and press the Preview button to view the student roster for that class.
Student gradebook
The student gradebook screen enables you to enter grades for all the students. To view the student gradebook screen choose View | Student Gradebook from the main menu. The following screen should appear:
The student pull-down list at the top allows you to see the grades for a particular student. When choosing a new student from this list notice the data in the grid below changes to show that student's grades. To view a report card for the current student press the Preview button.
Exporting schedule to CSV
The current schedule can be exported to the CSV data format by choosing File | Export schedule to CSV from the main menu. This feature was added to enable blind students a way to access their schedules.
Accounts Receivable
Class Scheduler comes with a feature to print invoices and track payments made for student's classes. Accounts receivable records are added in the Accounts Receivable screen. To use the Accounts Receivable screen choose Tools | Accounts Receivable from the main menu. The following screen will appear:
To add a new record select the student you want from the Student pull-down list. That student's previous account records will appear in the grid at the bottom.
To add a new record click the New button. The fields will clear and allow you to enter information in them. When you are finished entering the data press the Save button to save the information.
To edit a record click on the desired record in the grid at the bottom. The fields will populate with the data. Then press the Edit button and make your changes. When you are finished press the Save button to save the changes.
Avoiding data problems
This software uses a local database to store its data. Unfortunately, local databases are susceptible to indexing problems (also known as corruption) if the computer is shut down abnormally. Indexing problems can occur if the program is in the middle of writing to the database and the program is prevented from completing the write. For this reason, you should always perform proper shutdowns. You should never shut off the computer or reset it while Windows is still running. Perform a proper shutdown by choosing Shut Down and either Restart or Shutdown from the start menu. If your system starts to act abnormally try exiting Class Scheduler first and then perform a proper shutdown.
If your system appears frozen first try hitting the Ctrl + Alt + Delete key combination. This should bring up a task list. You may be able to end the task that is no longer responding. Sometimes the system will crash so hard that you cannot even bring up the task list. If this happens reset the machine and re-index any corrupted Class Scheduler tables if necessary.
Related topics: Re-indexing Tables
Frequently Asked Questions
Questions for users new to computers and the Internet
Questions about CyberMatrix Software
Database/Multi-user questions
Questions about Class Scheduler
Questions about Class Scheduler
Q. When I Start Class Scheduler the following error message comes up:
DBISAM Engine Error #9217 Error reading From Data File C:\Program Files\ClassSched\Data\Classes.Dat
A. This is a table indexing error (known as corruption). Class Scheduler uses a local database to store its data. Indexing problems can happen in any local database when a system is shut down abnormally. You should never shut down or restart a Windows machine without doing a proper Windows shutdown first (i.e., choosing Shut Down from the Start menu.) To re-index the table, select the affected table in the Data Manager screen, in this case the Classes table, in the data views screen and then choose File | Re-index table.
DBSys
If you are unable to open the application to do a repair you can get the DBSys utility. DBSys is a utility from Elevate Software, the makers of the database engine used in Class Scheduler. Use this program to repair the affected table.
Last Resort
If after trying all these solutions you still have problems, you can zip up the files and e-mail them to UNCONVERTED WINHELP MACRO:! ExecProgram("support@cybermatrix.com",)CyberMatrix support. To zip up your data do a backup by choosing Records | Backup Data from the Data Manager menu. This will create a time-stamped file in your Data folder, usually C:\Program Files\Class Scheduler\Data\Backup. E-mail that file as an attachment.
Q. I have setup Class Scheduler on an NT 4.0 station. When only one person access the program, everything is fine. When other machines use Class Scheduler, everything slows to a crawl. What's going on?
A. This is an NT4 issue, and most likely related to opportunistic locking settings and the SP level. Due to bugs in early versions of NT4 a lot of servers had opportunistic locks turned off, but since this has been fixed they haven't turned them back on. The other thing that can cause slowdown problems is using NetBeui in conjunction with TCP/IP. It is recommended that you get an NT server administrator to look at the server and make sure that it's configured properly.
Installing Class Scheduler
There are three ways Class Scheduler can be installed:
On a single user's machine.
On a shared network location where the program and data is accessed by all users.
On every user's machine with only the data stored on the network.
Note: if installing this software for use by multiple people, all people must have read/write access to the Data folder on the shared drive.
Installing Class Scheduler on a single user's machine or a fully shared network location
Use the setup program to make the initial install on a local drive for a single-user. When prompted for an installation type, choose the first option, Standard. The data will be stored in the user Application Data\CyberMatrix\ClassScheduler folder. E.g. C:\Documents and Settings\Administrator\Application Data\CyberMatrix\ClassScheduler. If you want to use a data folder in another location, you should choose the Client Only option when at the installation type selection screen. Otherwise, you will have to change the Data Path setting in the configuration screen. The DataPath setting is stored in a text file called ClassSched.ini. This file can be found in the user Application Data\CyberMatrix folder. E.g. C:\Documents and Settings\Administrator\Application Data\CyberMatrix\ClassSched.Ini.
Installing Class Scheduler on one or more machines with network-shared data
There are two ways Class Scheduler can be installed in order to share data with multiple people: fully-shared and shared-data-only. In a fully-shared setup the program and all data are installed on a shared network location. Users will use icons to access the software. To tell the program where the shared data is located you will need to either:
1) Enter the data path when you see the file missing message after trying to run the software on each client or
2) Copy over a ClassSched.ini file containing the DataPath setting to each client's C:\Documents and Settings\[UserName]\Application Data\CyberMatrix\ folder.
In a shared-data-only setup, just the data resides on a shared network location. The software and other support files reside on the user's own computer. Installing Class Scheduler in this way will generally be faster since the program executable will not always be pulled down through the network. However, installation and applying updates will involve significantly more work.
To install only the data on the network and install Class Scheduler on one or machines with network-shared data do the following:
Run the setup program on a single machine.
Choose the Data Only option when at the installation type selection screen.
After installing the data, run the setup program again to install Class Scheduler on all the other user's machines. If you are sharing the entire application on the network just install to this machine.
Choose the Client Only option when at the installation type selection screen.
At the "Enter Network Data Location" prompt screen, enter the network data folder location where you installed the data previously.
Setting up the User's Workstations
In a fully shared multi-user setup, the Class Scheduler program files and data will reside in a common directory on the network. You will need to manually setup icons for your users.
Configuring Class Scheduler
To configure Class Scheduler bring up the Class Scheduler Administrator by selecting View | Configuration from the main menu. The Class Scheduler Administrator consists of seven tabs: the General tab, the Schedule tab, the Schedule Script tab, the Site Editor tab, the Data tab, the Terms tab and the E-mail tab. To view a section click on the labeled tab corresponding to that section.
General options
This is what the General options tab looks like.
Program Options
Show Splash Screen
If this option is checked, the starting splash screen will be shown.
No Lines in Schedule Reports
If this option is checked, the schedule report will not have lines.
Teach class more than once a day
If this option is checked instructors will not be assigned to the same class type more than once a day when using the Assign Instructors to Classes feature.
Security options
The security section allows the Class Scheduler administrator to enable security and to change the password for the Administrator.
Enable Security
If this option is checked, the security system is enabled. Note that when security is enabled for the first time the Administrator uses the default password of "magic". You should change this password immediately after enabling security to ensure a secure system. Write down your new password and store it in a secure location such as a safe.
When security is enabled a login dialog will popup on program start. The Administrator can login as well as any users who have been setup in the Security table. To setup the users in the Security table and to change the current passwords use the Detail tab of the Data Manager. See also: Using the Security Features. After logging in, users will only be able to create and edit their own schedules.
Users Read Only
If this option is set, users can only view their schedules, they cannot change them.
Secondary Help File
The secondary help file option allows Class Scheduler to use an additional help file. This file could be in Windows help format or anything else. The custom help file will show up as another option in the Class Scheduler main help menu.
Although this option was specifically designed for help files, any other kind of file could be used including HTML files. For this to feature work properly the file extension type must be associated or registered with an appropriate application on each user's machine.
Secondary Help Filename
Enter a filename in this box or click the browse button to bring up a file selection dialog.
Secondary Help File Description
Enter a description of what the secondary help file is. This description will show up as another option in the Class Scheduler main help menu.
Schedule options
This is what the Schedule options tab looks like.
Schedule Time Period
Setting Start and End Times
The Start time specifies the earliest time classes may be scheduled.
The End time specifies the latest time classes may be scheduled.
Schedule Interval
This number indicates the number of schedule intervals in an hour. For example:
30 - split the hour into two intervals i.e. 8:00 - 8:30
15 - split the hour into four intervals i.e. 8:00 - 8:15
10 - split the hour into six intervals i.e. 8:00 - 8:10
Days
Indicates the days to show in the schedule. Highlight the days you want shown using the mouse and the Ctrl and Shift keys.
Re-create Schedule Times
When pressed, the ClassTimes table will be emptied and then re-created using the entered start/end times and class interval.
Add Daily Schedule Times
When pressed, times for the selected days will be added to the ClassTimes table using the entered start/end times and class interval. This feature would be used for those wanting to use the requirements-based scheduling feature. It allows you to have different class times for different days.
Schedule Options
Fractional Hour Time Schedule
If this option is checked, the appointment schedule on reports will show fractions of hours as well as hours in the first column.
Minimum Column Width
This specifies the minimum column width to use in the schedule screen.
Minimum row height
This specifies the height of the grid line rows in the scheduler grid. Use a higher number to get larger rows.
Scheduling Type
The scheduling type can be either by students or by groups. If Class Scheduler is configured to schedule by groups (blocks) of students instead of individual students, classes will be assigned to groups. Otherwise, classes will be assigned to individual students.
Schedule script
This is what the Schedule options tab looks like.
Schedule script
This script is used to determine which information is shown for each class in the schedule grid.
Scripts consist of text and special macros. The macros are enclosed in percent marks and represent special fields in the database. For example, the %Class% macro represents the class name. When text and a macro is enclosed within squiggly brackets, the text will not be shown if that macro value is blank. For example, if we wanted to show the room field with a descriptor in front of it we could place {Rm: %Room%} in the script. If the room field is empty for any class the Rm: text will not be seen.
Here is a list of available macros:
%Class% - class name
%Room% - room the class is in
%Notes% - class notes
%Instructor% - who is teaching the class
Site Editor options
The Site Editor is used to maintain a list of sites and their network path locations. When sites are setup in this way the main screen will have an item in the File menu called Open Site. Choosing this option will bring up a screen allowing the user to select a site. After pressing OK the user will now be able to view and edit the bookings at this site.
If there are no classes setup for a site, the admin password dialog will pop up. After logging in the configuration screen is shown allowing the site's resources to be entered.
This is what the Site Editor tab looks like.
When a new site is added, empty tables will be created in the directory you specified. To populate these tables first open the site using the main menu, then populate the data as you normally would using the Data Manager.
Data options
The Data tab is used to change where the data files for the program reside. To change the data path click on the button to the right of the Data Location edit box. Use the path explorer to choose a new path. Make sure the newly chosen path has data files in it.
This is what the Data options tab looks like.
Term options
The terms tab is used to change key terms used in Class Scheduler. For example, if you want the program to show the term "Teacher" instead of the term "Instructor" change the Instructor term to "Teacher".
This is what the Term options tab looks like.
Email options
The E-mail tab is used to configure e-mail options for Class Scheduler.
This is what the Email options tab looks like.
Mail Options
Notify on class drop
If checked an e-mail will be sent out whenever a class is dropped. The e-mail will be sent to the e-mail address listed in the Classes table for that particular class.
Use MAPI
If checked one of your MAPI e-mail clients will be used to send e-mails instead of the included SMTP e-mail client.
SMTP server options
Enable Authentication
Check this box if your mail server requires password notification before sending mail.
Authentication Login ID
Enter your SMTP authentication login ID here.
Authentication Password
Enter your SMTP authentication password here.
SMTP Mail Host
This is the SMTP mail host used on your network. Usually it is mail but enter whatever you set for configuring other mail programs. If this option is not entered correctly, the e-mail features will not work.
Default from e-mail
This is the e-mail address that will show in the From field of any e-mails sent.
Domain
This is the domain that will show in the From field of any e-mails sent. Make sure to include the @ sign.
Using the Security Features
By default, there is no security in place for Class Scheduler. This means that in a multi-user environment, any user will be able to view and edit any other user's schedule data. To prevent this you can implement the security option (see the Options screen). When security is in place, an administrator must login in order to see all users' schedule data as well as access the security options screen.
When security is enabled a login dialog will popup on program start. The Administrator can login as well as any users who have been setup in the Security table. To setup the users in the Security table and to change the current passwords use the Detail tab of the Data Manager. See the Data Manager section for help in working with tables. After logging in, users will only be able to create and edit their own schedules.
Passwords can also be changed from the main screen by choosing File | Change Password from the main menu.
Logging In
To see all users' data, a user must login as Administrator. To login choose File | Login from the main menu. Enter Administrator as the UserID. The default password is "magic". You should change this password if it is important to prevent users from viewing or changing other user's data.
Important: write down and store your changed password in a secure location such as the company safe.
Logging Out
To log out as Administrator choose Admin | Logout from the main menu.
See the Security Options section for more details.
Custom reporting
This software comes with a powerful report designer feature. With the report designer, you can create your own unique reports or edit existing ones.
Editing an Existing Report
The easiest way to create a new report is to edit an existing one. This software comes with several pre-built reports. To edit one of these select Custom Reports | Edit from the Report Selector menu. A file select dialog will pop up allowing you to choose a report. After selecting a report, the report designer will appear. In the report designer you can add graphics and text to the report or even move fields around or add new ones. See the report designer help file for more details.
Creating Reports
There are several steps to create your own reports.
First, create the report:
Start the report designer by selecting Custom Reports | New from the Report Selector menu.
Next assign the datasets
Datasets are assigned in the Data tab to the right. Double click where it says No data available. In the selection dialog check frxDBDataset1. You will see the available data fields appear.
Now create the SQL variable:
From the menu choose Report | Variables.
Click on the New Category button (the button with a glinting yellow folder icon). This will create a new category.
Name the category something like ReportVariables.
Click the New Variable button (the glinting fx button).
Call the new variable SQL.
In the Expression box, enter your SQL query. For example: SELECT * FROM Classes.
Click OK to save the new variable.
Note that the existing template.fr3 report has this step completed for you already.
Now add bands to the report:
Click on the Insert Band button (the button with the three squares and plus sign).
A list of band types will appear.
Click on Report Title, Page Header, Master Data (select the frxDataset1 Dataset) and Page Footer bands.
Now add fields to the report:
In the Data tab to the right select the fields of the query you want to see on your report and drag them onto the Master Detail band positioning them where you want them.
Note that the fields available may not match what you have added to the SQL variable. If that is the case you will have to save the report (if you haven't already), close the report designer and reopen it. This will update the query to use the SQL the report is based on.
Now add field labels to the report:
Click on the Text Object button (the button with the ab on it).
No click on the Page Header band where you want the first field caption to appear.
A dialog will pop up allowing you to type the text for the field label. Type the text and press the green check mark to save.
Repeat this for all other field labels.
Your report should now work. Save the report. Press the Close button to return to the Reporting Screen. Choose Custom Reports | Preview Report from the menu. Select your new report and press OK to see what your report will look like when printed.
Note that choosing File | Preview from the report designer menu may not work depending on what fields you've added to the report. To get the report to preview correctly from the report designer you will need to save the report (if you haven't already), close the report designer and the preview the report from the report selector screen. This will update the query to use the SQL the report is based on.
Other Variables
There are two other variables that you can use to make special reports. If you want to create a schedule report you must create and set the Schedule variable. This variable is created the same way the SQL variable is created. For schedule reports, you must set the Schedule variable to 'True'. The DIV variable function allows you to perform integer division on two numbers.
Additional Help
See the UserManual-en.pdf help file for more details on report design.
Customizing HTML Reports
The HTML reports in Class Scheduler can be customized by editing the Cascading Style Sheet (CSS) of each report. The style sheets are located in the same folder as the main executable and have the extension css. The style sheet for the schedule report is named sched-style.css. The style sheet for the roster report is roster-style.css. These files can be viewed and edited with any text editor such as Windows Notepad.
To learn more about Cascading Style Sheets try these tutorials:
webmonkey
CSS School
Introduction to Style Sheets
Multi-Language Support
This program can be configured to support almost any language. Currently only English is supported. However, users of this software may easily create support for their own language.
This software uses language files to store all its internal text strings. These files end with the .lng extension. To create a language file for your language do the following:
Simply open the existing English.lng file with any text editor such as Notepad.
You will see that the language file is split into two sections [Translations] and [Messages]. To convert to your language replace all the strings to the right of the equal sign (=) with your language's equivalent.
Note that menu captions use the ampersand (&) to enable a hot key on the character following it.
Finally, save the modified text file to the name of your language, E.g. Francais.lng.
To try out your language file select File | Language from the main menu and select your language.
Please be sure to send us your translations so we can allow everyone else to use your language with this software as well. Contributors will be noted on this page.
Purchase information
You may freely evaluate the trial version Class Scheduler without any costs for the period of 30 days. If you wish to continue using the program after 30 days, you must purchase it from CyberMatrix. If you do not wish to purchase the program after 30 days, you must uninstall it from your computer.
After 30 non-consecutive days from the time of installation, the software will cease functioning.
Rates
The following license rates apply to the CyberMatrix Class Scheduler program:
single license $100
10 seats $500
25 seats $1000
50 seats $1500
100 seats $2000
Company Site License $3500. (For up to ten different sites.)
Additional User Blocks (if a license has previously been purchased):
single seat $50
10 seats $450
25 seats $950
50 seats $1450
100 seats $1950
Example:
If you need Class Scheduler to accessed from 37 people's machines your license fee would be:
$1000 (25 seat) + $450 (additional 10 seats) + $100 (additional 2 seat) = $1550.
Shipping Options
Internet download - Free
Ship CD by postal mail - $5 ($10 registered)
Ship CD by courier - $25 - ($60 outside North America)
Non-profit Discount
Not for profit agencies are entitled to a 10% discount when software is purchased directly from CyberMatrix.
Purchasing
There are several ways to purchase Class Scheduler:
All CyberMatrix software can be purchased directly from CyberMatrix by secure Internet web form, fax, telephone, purchase order, funds transfer or by regular postal (snail) mail. Note that all prices are listed in U.S. dollars.
Fax
For fax orders click here to fill out the order form and fax to 1-866-425-2670.
Internet Secure Server
Licenses can also be purchased by credit card on the Internet using a secure server. See the CyberMatrix store web page at http://www.cybermatrix.com for details.
Telephone
For telephone orders using a credit card, you may call CyberMatrix directly at (250)503-1009.
Toll Free
For telephone orders, you can also call toll free in Canada and the U.S. at 1-888-664-0383.
Purchase Order
Companies and government agencies may purchase this software by way of purchase orders. Standard credit references are required before PO's may be processed. This information may be faxed to 1-866-425-2670.
Funds Transfer
Funds may be transferred directly from your bank account to ours. Contact us for account information. There is an additional $10 charge on orders under ($300) for using this option.
Snail Mail
To purchase a license, print out the registration form and send a company check or money order (in US funds) to:
CyberMatrix Corporation
P.O. Box 76081
240 70 Shawville Blvd SW
Calgary, AB T2Y 2Z0
Canada
After Purchasing
After you have purchased Class Scheduler, if you did not order the software on disk, you will receive instructions on obtaining the commercial version of Class Scheduler. You will also receive a registration key that will register the program to you or your organization. You may use the registration key with as many copies of Class Scheduler as you have purchased licenses for, installed on as many computers. More than one person is allowed to use one licensed copy of the software on the same computer, as long as no two people use it at the same time. Just like a book can be read by many people, but only by one person at a time.
If more than one person needs to use the software at the same time, you must purchase a license for each person. Discounts apply for bulk purchases.
When your order and payment has been received and you did not order the software on disk, you will promptly be emailed a registration key and instructions on obtaining the commercial version. It is therefore important to include a valid email address when you place your order. Instructions will be provided on how to use the registration key.
Upgrade Information
All registered users of Class Scheduler are guaranteed all future product revisions, both major and minor will be provided free of charge for a minimum of six months after the date of purchase.
Any major revisions (i.e. v4 to v5) after six months may accompany an upgrade fee that will be not more than 50% of the suggested retail price for said revision.
All upgrades will be made available for electronic download.
Related topics: Registration Form
Class Scheduler order form
Remit To:
CyberMatrix Corp.
P.O. Box 76081
240 70 Shawville Blvd SW
Calgary, AB T2Y 2Z0
Canada
Fax: 1-866-425-2670
Name: _________________________________________
Company: _________________________________________
Address: _________________________________________
_________________________________________
_________________________________________
Ship To: _________________________________________
_________________________________________
_________________________________________
(For credit card orders, the name and address must be exactly as they appear on your credit card and statement.)
Telephone: _________________________________________
Email: _________________________________________
[All prices in U.S. Dollars.]
Registration details
___________ single license $100
___________ 10 users $500
___________ 25 users $1000
___________ 50 users $1500
___________ 100 users $2000
___________ Site License $3500.
___________ Send program on CD by postal mail - $5 ($10 registered)
___________ Send program by courier - $25 ($60 outside North America)
___________ Send download instructions by e-mail - FREE (Make sure to include e-mail address.)
___________ Use bank funds transfer ($10 for orders under $300)
___________ Total
Payment method
[ ] Check
[ ] Money Order
[ ] Visa - Card #: ______________________ Expire Date: ___________
[ ] MasterCard - Card #: ______________________ Expire Date: ___________
[ ] Amex - Card #: ______________________ CID #:___________ Expire Date:___________
[ ] Discover - Card #: ______________________ Expire Date: ___________
[ ] Purchase Order: ______________________
(For P.O.'s, please fax your standard credit references form to 1-866-425-2670.)
Where did you hear about Class Scheduler?
________________________________________________________________