This was a VBA for Excel project. The program generates reports for students attending class. Each student is assigned a barcode. Every lesson the students that have attended a class are registered using the barcode reader. The program processes this data and provides attendance reports for classes and students. These reports show what classes the students have been absent, students arrival time in class, what classes each student has been absent in each class . . .
The client for this project required an application for student attendance. The application was required to have the following characteristics:
- Based on each students ID, the program should be able to create a bar code.
- After creating these bar codes, they would be given to the bar code reader device. Each student would be given a card with the bar code on it. Upon entering class, using the bar code reader each students bar code would be read. The application would then record the time the student has entered and left the class.
- The program should be able to print reports for each student. (a) The classes the student has attended and (b)The classes the student has missed.
- The program should be able to print reports for each class. (a) The students absent in each class. (b) The students who have attended each class.
Step 1: In the students worksheet, the user inputs the names an IDs of all the students in the school.
Step 2: By pressing the return key, the program automaticaly generates the barcode associated with the student ID.
Step 3: On a separate sheet the user writes the names of all the classes. The names of the classes are written on the first row. Under each class name the user writes the IDs of the students that have registered in that class. The program automatically updates its database, based on the data input here.
Step 4: Based on the values written on the first row of the previous sheet, the drop down list with the class names is populated.
Step 5: The student IDs and barcodes are given to the barcode reader device. A card is printed for each student. Upon entering the class the instructor would read the students barcode using the barcode reader. What happens is that the barcode reader will print the students ID onto the selected cell. Upon entering the student ID the program will automatically record the students ID, Name and Entry Date. If an entry date is found, then the program will record the outgoing date.
Step 6: Once the class is over and all the data has been read, by pressing the record button, the data for that class will go in the programs database.
Step 6: By pressing the clear button the entries will be cleared for the next class
Step 7: The main functionality of this application is running queries on students and classes. By pressing the search button a user form will open. The user form gives the user two choices, to either run a query on a specific student or a class. By Choosing a student, a new sheet will appear and all the records related to that student will appear. On that sheet it will also indicate which classes the student has missed.
by choosing a class, a new sheet will open and all the records related to that specific sheet will appear. It will show the absent and present students for each class.
Step 8: Another feature of this application is the ability to choose an interval to run the queries. You could choose to list all records related to a student or class between the dates February 11, 2013 and May 27, 2014.
Looking for a VBA programmer? You can hire one of our programmer for only 10$/hour. www.software-solutions-online.com