Senior Project - LEM

The General Chemistry Program within the Department of Chemistry and Biochemistry provides undergraduate courses in inorganic chemistry to about 3,500 students a year. Most of these courses have a laboratory component requiring students to check into a locker containing most of the glassware that they will need during the semester. Each locker contains several dozen pieces of lab equipment and students also borrow special items from the stockroom for specific experiments. Lockers in one lab room contain different equipment from another laboratory used for a different course. Students are responsible for the cost of any glassware breakage. Laboratory staff currently maintain paper records for the contents of about 2,000 lockers and all the special items loaned to students. At the end of each semester, charges must be transferred from these paper records to "computer bubble sheets" for use by the Bursar's office.

The goal of this project was to produce a system for a Windows PC that would download the required student and course information from the Student Information System (SIS), integrate this information with student equipment lists, breakage records, price lists, inventory, etc., then electronically transfer the student charges at the end of each semester to the Bursar's office. The project was developed using Microsoft Access.