Contents
The School Program

This application keeps track of Students and Teachers, and the Courses and Classes they take or teach.

Specific features of this application include:

A photograph of each student is stored in a BLOB field in the database (not in a separate file on disk). This photograph is then printed on each Student’s ID card.

Grades for a Mid-Term Exam, Final Exam, and a Term Paper are recorded for each class a Student takes. Final Grades for each class are calculated by adding the Mid-Term Exam, Final Exam (worth double), and Term Paper, then dividing the result by 4. These grades are calculated when printing the Final Grades report.

The Mid-Term Exam, Final Exam, and Term Paper grades can be updated using a Browse list demonstrating edit-in-place.

Drag and drop techniques have been used every place an entry control’s value should come from another data file.


TopSpeed University

This is the main frame for the application.  All activity starts from here.  The individual components of the program are accessed from pulldown menus located across the top of the window.

The program can be minimized to an icon by clicking the  - image located in the top right corner.  The program can be closed by clicking the X image located in the top right corner or double-clicking the envelope icon in the upper left corner.

File Menu

Print Setup	Displays a standard Windows printer window which will allow the selection of  certain printing parameters, such as paper size, orientation and destination.

Exit	Closes the program.

Edit Menu

Cut 	Copies the highlighted text to the Windows clipboard and removes it from the highlighted position on the screen. Enabled when option is valid.

Copy	Copies the highlighted text to the Windows clipboard.  Enabled when option is valid.

Paste	Takes any information stored in the Windows clipboard and inserts it at the place where the cursor is currently located. Enabled when option is valid.

Trees Menu

Class Tree	Display the Class Tree to show all the classes associated with each course and the students enrolled in each class.

Student Tree	Display the Student Tree to show all the Students and the classes in which they are enrolled.

Browse Menu

Students	Display the window that lists all the Students.

Teachers	Display the window that lists all the Teachers.

Classes	Display the window that lists all the individual Classes taught.

Enrollment	Display the window that lists all the Students enrolled in each Class.

Courses	Display the window that lists all the Courses.

Majors	Display the window that lists all the Majors.

Reports Menu

Student Class Schedules	Creates a report of all the Classes in which a Student is enrolled.

Teacher Class Schedules	Creates a report of all the Classes to which a Teacher is assigned.

Attendance Sheets	Creates a report of all the Classes and the Students enrolled in that class.

Course Enrollment	Creates a report of all the Courses, the Classes taught for each, and the Students enrolled in each class.

Course Enrollment Summary	Creates a summary report of all the Courses, the Classes taught for each, and the number of Students enrolled in each class.

Final Grades	Creates a "report card" for each student, with final grades and GPA calculated.

Student IDs	Prints an Identification card for each student, complete with their picture.

Window Menu

Tile	Arranges all currently open windows so that all windows are visible on the screen and are all sized to the same dimensions.

Cascade	Arranges all currently open windows so that all the title bars of each window are visible and one window is "stacked" on top of another.

Arrange Icons	Arranges all currently open windows that are minimized to icons into a straight and orderly fashion.

Help Menu

Contents	Displays the main screen of the help document.

Search for Help On	 Displays the help window with the capability to search for a particular topic.

About	Displays the window with general information about this application.

The toolbar provides the following navigation, data entry, and help buttons:

Scrolls to the first row in a list or to the previous parent item in a hierarchical list. For update screens, saves the current item before scrolling.

Scrolls up one page in a list or to the previous item on the same level in a hierarchical list. For update screens, saves the current item before scrolling.

Scrolls up one row in a list or to the previous item on any level in a hierarchical list. For update screens, saves the current item before scrolling.

Locates the requested item in the list.

Scrolls down one row in a list or to the next item on any level in a hierarchical list, expanding the collapsed level if necessary. For update screens, saves the current item before scrolling.

Scrolls down one page in the list or to the next item on the same level in a hierarchical list. For update screens, saves the current item before scrolling.

Scrolls to the last row in the list or to the next parent item in a hierarchical list. For update screens, saves the current item before scrolling.

Selects the highlighted row in the list.

Calls an update procedure to add a new item.

Calls an update screen to change the item highlighted in the list.

Deletes the item highlighted in the list.

On an update screen only, pastes into the field with focus, the corresponding value from the previously processed item. In other words, repeat the value from the previous saved item.

Displays the on-line help for the active window.


Class Tree

This window displays a Tree control of all the Courses, all the Classes for each Course, and the Students enrolled in each Class. The Tree opens displaying just the Courses.

You can expand a level by clicking on the + box, or contract a level by clicking on the - box. Right-click displays a pop-up menu allowing you to Insert, Change, or Delete any record at any level of the Tree, or Expand and Contract all the Tree levels.

Expand All	Press this button to expand all the levels of the Tree to display all the Classes and Students.

Contract All	Press this button to contract all the levels of the Tree to display just the Courses.

Close	Press this button to close the window.


Student Tree

This window displays a Tree control of all the Students and all the Classes in which they are enrolled. The Tree opens displaying just the Students. Some Classes display in Red (representing danger), because the student has a Mid-Term, Final Exam, or Term Paper grade less than 70.

You can expand a level by clicking on the + box, or contract a level by clicking on the - box. Right-click displays a pop-up menu allowing you to Insert, Change, or Delete any record at any level of the Tree, or Expand and Contract all the Tree levels.

Expand All	Press this button to expand all the levels of the Tree to display all the Classes for each Student.

Contract All	Press this button to contract all the levels of the Tree to display just the Students.

Close	Press this button to close the window.


Browse Students

This window displays a LIST control of all the Students. The three Tabs allow you to choose the sort order in which to view the Students List – by their Major, Last Name, or Graduation Year.

Right-click displays a pop-up menu allowing you to Insert, Change, or Delete a record.

Close	Press this button to close the window.


Browse Teachers

This window displays a LIST control of all the Teachers. The two Tabs allow you to choose the sort order in which to view the Teachers List – by their Department or Last Name.

Right-click displays a pop-up menu allowing you to Insert, Change, or Delete a record.

Close	Press this button to close the window.


Browse Classes

This window displays a LIST control of all the Classes. The two Tabs allow you to choose the sort order in which to view the Classes List – by their Class Number or Course Number.

Right-click displays a pop-up menu allowing you to Insert, Change, or Delete a record.

Close	Press this button to close the window.


Browse Enrollment

This window displays a LIST control of all the Students enrolled in each Class. The two Tabs allow you to choose the sort order in which to view the List – by the Class Number or Student Number.

Right-click displays a pop-up menu allowing you to Insert, Change, or Delete a record.

Close	Press this button to close the window.


Browse Courses

This window displays a LIST control of all the Courses offered. There is only one sort order in which to view the List – by the Course Description.

Right-click displays a pop-up menu allowing you to Insert, Change, or Delete a record.

Close	Press this button to close the window.


Browse Majors

This window displays a LIST control of all the Majors offered. There is only one sort order in which to view the List – by the Major Description.

Right-click displays a pop-up menu allowing you to Insert, Change, or Delete a record.

Close	Press this button to close the window.


Update Grades

This window displays a LIST control of all the Students in each Class and their grades for the Mid-Term, Final Exam, and Term Paper. You can update the grades (only) "in-place" in the List.

Double-click on the grade to change and an edit window appears allowing you to change the grade. When a new value is entered, press tab, or double-click on another grade to change and the changed grade is written to disk.

Close	Press this button to close the window.


Update Students

This window displays one Student’s information.  It also has a list of all Classes in which the Student is enrolled on the Enrollment tab. The Photo tab displays a picture of the Student that is stored directly in the database (not in a separate image file).

General Tab	Displays the Student’s General information.

First Name	The Student’s Christian name.

Last Name	The Student’s surname.

Address	The Student’s street address.

Address2	A second address line, if required.

City	The city in which the Student resides.

State	The state in which the Student resides.

Zip	The ZIP postal code for the Student’s residence.

Telephone	The Student’s phone number.

Grad Year	The year in which the Student expects to graduate.

Number	The Student’s Social Security Number, which is also used as the Student Number.

Major	The code number of the Student’s Major. When adding a new student, the Drag Major toolbox automatically appears to allow you to drag the appropriate Major and drop it on the Major entry control. To change an existing Student’s Major, press the … button to the right of the entry control to re-display the Drag Major toolbox.

Enrollment Tab	Displays a LIST control of all the Classes in which the Student is enrolled (not visible when adding a new record). Right-click displays a pop-up menu allowing you to Insert, Change, or Delete a record.

Photo Tab	Displays a picture of the Student that is stored directly in the database (not in a separate image file).

Image File Name	When adding a new Student, or changing a Student’s picture, either enter the name of the image file containing the picture (GIF, PCX, BMP, WMF, JPG, or ICO) or press the … button and select the file from a standard file open dialog. This picture is then displayed on screen and is stored directly in the database when you press the OK button.

OK	Press this button to write the record to the file on disk and close the window.

Cancel	Press this button to close the window without writing the record to disk.


Update Teachers

This window displays one Teacher’s information.  It also has a list of all Classes to which the Teacher is assigned.

General Tab	Displays the Teacher’s General information.

First Name	The Teacher’s Christian name.

Last Name	The Teacher’s surname.

Address	The Teacher’s street address.

Address2	A second address line, if required.

City	The city in which the Teacher resides.

State	The state in which the Teacher resides.

Zip	The ZIP postal code for the Teacher’s residence.

Telephone	The Teacher’s phone number.

Department	The code number of the Teacher’s department (the same as the Majors). When adding a new student, the Drag Major toolbox automatically appears to allow you to drag the appropriate Major and drop it on the Department entry control. To change an existing Teacher’s Department, press the … button to the right of the entry control to re-display the Drag Major toolbox.

Classes Tab	Displays a LIST control of all the Classes to which the Teacher is assigned (not visible when adding a new record). Right-click displays a pop-up menu allowing you to Insert, Change, or Delete a record.

OK	Press this button to write the record to the file on disk and close the window.

Cancel	Press this button to close the window without writing the record to disk.


Update Classes

This window displays one Class’s information.  It also has a list of all Students enrolled in the Class.

General Tab	Displays the Class’s General information.

Class Number	A unique number identifying the Class, in the format ##-#####.

Course Number	The code number of the Course the Class will teach. When adding a new Class, the Drag Course toolbox automatically appears to allow you to drag the appropriate Course  and drop it on the Course Number entry control. To change an existing Course Number, press the … button to the right of the entry control to re-display the Drag Course toolbox.

Teacher Number	The code number of the Teacher for the Class. When adding a new Class, the Drag a Teacher toolbox automatically appears to allow you to drag the appropriate Teacher and drop it on the Teacher Number entry control. To change an existing Teacher Number, press the … button to the right of the entry control to re-display the Drag a Teacher toolbox.

Room Number	The number of the Room where the Class will be held.

Scheduled Time	The times the Class will be held.

Enrollment Tab	Displays a LIST control of all the Students enrolled in the Class (not visible when adding a new record). Right-click displays a pop-up menu allowing you to Insert, Change, or Delete a record.

OK	Press this button to write the record to the file on disk and close the window.

Cancel	Press this button to close the window without writing the record to disk.


Update Enrollment

This window enrolls one Student in one Class

Student Number	The number of the Student to enroll. When adding a new Enrollment record, the Drag Student toolbox automatically appears to allow you to drag the appropriate Student and drop it on the Student Number entry control. To change an existing Student Number, press the … button to the right of the entry control to re-display the Drag a Student toolbox.

Class Number	The code number of the Class in which to enroll the Student. When adding a new Enrollment record, the Drag Class toolbox automatically appears to allow you to drag the appropriate Class and drop it on the Class Number entry control. To change an existing Class Number, press the … button to the right of the entry control to re-display the Drag Class toolbox.

MidTerm	The Student’s grade on the Mid-Term examination.

Final	The Student’s grade on the Final examination.

Term Paper	The Student’s grade on the Term Paper.

OK	Press this button to write the record to the file on disk and close the window.

Cancel	Press this button to close the window without writing the record to disk.


Update Courses

This window displays one Course’s information.  It also has a list of all Classes scheduled to teach the Course.

Complete Description Tab	Displays a Text box containing a complete description of the Course and its prerequisites.

General Tab	Displays an Entry box containing a short description of the Course.

Classes Tab	Displays a LIST control of all the Classes scheduled which will teach this Course (not visible when adding a new record). Right-click displays a pop-up menu allowing you to Insert, Change, or Delete a record.

OK	Press this button to write the record to the file on disk and close the window.

Cancel	Press this button to close the window without writing the record to disk.


Update Majors

This window displays one Major’s information.  It also has a list of all Teachers (the Majors file is also their Departments file) and Students with this Major.

General Tab	Displays an Entry box containing the name of the Major.

Teachers Tab	Displays a LIST control of all the Teachers in the Department (not visible when adding a new record). Right-click displays a pop-up menu allowing you to Insert, Change, or Delete a record.

Students Tab	Displays a LIST control of all the Students with this Major (not visible when adding a new record). Right-click displays a pop-up menu allowing you to Insert, Change, or Delete a record.

OK	Press this button to write the record to the file on disk and close the window.

Cancel	Press this button to close the window without writing the record to disk.