Student Attendance Sheet and Bar code Reader (VBA for Excel)

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

Program Requirements:

  • VBA
  • Excel

Program Description:

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.

User Inputs the students names and IDs

User Inputs the students names and IDs

Step 2: By pressing the return key, the program automaticaly generates the barcode associated with the student ID.

Barcodes are created automaticaly

Barcodes are created automaticaly

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.

List of classes with registered students

List of classes with registered students

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.

Class drop down list

Class drop down list

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.

Barcode readers input

Barcode readers input

Recorded data

Recorded data

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.

Class records

Class records

Database

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.

User form

User form

Query on student

Query on student

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.

Class query

Class query

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.

Choose to use the interval feature

Choose to use the interval feature

Choose the interval

Choose the interval

Looking for a VBA programmer? You can hire one of our programmer for only 10$/hour. www.software-solutions-online.com

Live Chat