An application that provides easy access to meeting organizers to handle the downloaded attendance list.All the professors schedule classes in their respective time slots and download the attendance list at the end of the class. The downloaded attendance list is a mess and to access it professors have to make a list of presentees and absentees which take a lot of time.
This attendance automator manifests the meeting organizers to easily sort the absentees and presentees according to their scholar number. It also generates attendance of each student in percentage and highlights it if it is less than the threshold value.
| VARIABLE | Sample value |
|---|---|
| MONGO_URI | create by using MongoDB atlas |
- install python
- virtual env
python3 -m venv env - activate virtual env
env\Scripts\activate.bat (for windows)env/bin/activate (for Unix or MacOS) - install pandas
pip install pandas - install flask
pip install flask - install numpy
pip install numpy - install openpyxl
pip install openpyxl - install pymongo
pip install pymongo - If you plan to use a local instance of MongoDB database, install MongoDB atlas.
- Create a MongoDB Cloud account.
- Create a MongoDB Atlas cluster.
- Configure network access and create a cluster user.
- Connect to the cluster.
- In the local project directory, create a new file called ".env".
- Setup the environment variables as described above.
- Excel sheet- A file containing scholar number and name of each student of a batch.
- CSV file- Downloaded attendance file from Microsoft Teams
