Skip to content

Algorithm to calculate the attendance from Microsoft Teams

Notifications You must be signed in to change notification settings

bprajeeth/Teams-attendance-Project

Repository files navigation

Microsoft Team's Attendance Calculator 🧑‍💻

Team's attendance calculator is a Desktop Application that's an easy-to-use attendance calculator that can be used with a click of a single button that can save teachers loads of time and a log-book with precise and accurate details of attendance which has been compiled for many timestamps and stored in an excel file chronologically, to refer from. This is one among my project that creates a lot of impact both among the students and teachers.

Faculty’s Note ✒️

I want to take the time to thank Prajeeth for the fantastic job. He did an excellent job by creating an attendance App. During this pandemic with all the new technology for teaching, teachers found it difficult to manage the students online. The App created by Prajeeth called TEAMS ATTENDANCE CALCULATOR has the following features:

  • Just one click on the downloaded attendance from team.
  • Sorting and giving attendance is done automatically by the App.
  • Each day attendance is updated in an excel sheet.
  • It gives attendance to those students who attend at least for a stipulated time set by the teachers. This makes a huge difference in the students to stay fully for the one-hour class. Keep it up Prajeeth, I appreciate your thought to create this App. Also, I am really thankful for your efforts to make this work. Thank you once again!

With deep appreciation for your efforts,
Dr. N. PadmapriyaAssociate Professors


User Guide 📝

Open the Attendance calculator app. The app opens with the user interface shown below. Click the button present on the screen. Once you click the button a dialog box will open and will prompt you to select your file of choice.

  • Once the user has selected the file, the user’s job is done! , the app does all the hard- work from here on.

  • It then displays the message according to the file you have selected. If you are selecting a new file, then it will calculate the attendance and the following message will be displayed. If you have selected a file for which attendance has already been calculated, the following message will be displayed.

All the attendance is calaculated and accounted for in the excel file where the detailed report is stored. !!!

The Excel file and its Features 🗃️

The excel file has 2 sheets. One for storing the concise details and other for the detailed information. This excel file is stores the entire semesters attendance in a every time the a new entry is made from the app.

  • The sheet 1 has the concise details of all the calculated and colour coded attendance in chronological order.

  • The sheet 2 has the details information about all the absentees such as total time of presence, name, registration number, count of all the absentees. Both the sheets will have the attendance information in chronological order.

This can be further modified manually for any additional changes.

About

Algorithm to calculate the attendance from Microsoft Teams

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages