Skip to content

samyak1409/online-class-attendance-automator

Repository files navigation

Online Class Attendance Automator (For Google Meet)

What the project does

This project can be used to save the attendance of the students of a class in a proper Attendance Register (a Microsoft Excel Worksheet) in absolutely no time! This project also has options to analyze the students having low attendance (using an Attendance Criteria) and the students with the best attendance.

Why the project is useful

What happens is, for taking attendance in the online classes like on Google Meet, either the teacher has to take it manually every day which waste a lot of time, or the teacher can use some Google Chrome extensions available which integrates with Google Meet and can be used to save the attendance after every class (meet). But again, a huge problem arises here, that the extension just saves the names of the meet attendees like a list in a CSV file every day and so if there will be 90 classes in a semester, the teacher will end up having 90 different CSV files 😬, that is exactly not what the teachers want, and so if they need all the attendance in a single Attendance Register, they'll need to mark 90 x 60 (assuming the class have 60 students) = 5400 entries 🤯, yes, a complete waste of time!!, SO, you guessed it right, this project will do that work for you in seconds!

Installing the Dependencies

After downloading this project to your PC, open the project folder, there, open your command-line interpreter (e.g. Command Prompt for Windows), and run the following:

pip install -r requirements.txt

Steps to get started with the project

1) Add the full names of all the students of your class to Students.data.

2) Make the required changes in some attributes' values in Attributes.py. (Read the instructions written there carefully.)

3) Empty the Attendance CSVs folder and copy all your attendance data (CSV files) to the same.

Don't have attendance data? Generate sample data [FOR TESTING]:

Run Sample Data Generator.py and enter the number of days of attendance you want to generate.

It will generate any number of days of attendance in a few seconds and will save them to Attendance CSVs folder ready to be processed by the main program.

4) Run Main.py.

Make any required changes and start the process, wait for a second, and BOOM!

Complete Attendance Register.xlsx will be ready!

And the names of the students with low attendance and best attendance will be saved to Most Wanted.txt 😝!

Some important things to take care of

  1. Use only Google Meet Attendance List Chrome Extension, because it's format only is being followed in this project, otherwise will not work.

  2. Names that you will add in Students.data must completely match with the names of the students in the Google Meet class, so ask your students to name themselves correctly in Google Meet otherwise their attendance will be skipped.

  3. No duplicate names should be there, if your class have students with same full name, don't forget to make them distinct (e.g. by adding numbering in the end of the names -> "Samyak Jain 1", "Samyak Jain 2"), also remember point 2.

  4. Do export the CSV files on the same date of the class only.

  5. Keep backup of all the files before running the project.

Future Features

  1. Time Restriction - Attendance of the students who were in the class for at least a particular duration of time (say 90% of the class duration) will only be considered! 🔥

  2. Auto report to Parents - A message (maybe mail) will automatically be sent to the parents of the students with low attendance. (Parents data (mail IDs) will be needed.)

  3. Independence from Extension - Making an extension itself will end up giving so many advantages (e.g. no chance of the program breaking because the Extension changed its format a little)

  4. More coming...

Written in Python ❤

Contact me @mail

About

For Google Meet

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages