Excel Attendance Tracker Enhancement
Budget: $10 – $30 USD
I am looking for a proficient Excel user who can improve our current student attendance tracking system. The aim is to have a well-organized, visually appealing tracking system that will simplify our attendance tracking and make data interpretation easier.
Features that I would like to see include:
- **Automatic data transfer to graphs:** I want to be able to pull data into graphs automatically. This feature should give us the flexibility to generate graphs based on selected date range, specific students or specific attendance categories to provide a more precise insight.
- **User-friendly interface:** The system should be simple and easy to use. It should provide a straightforward way for us to input data and navigate around.
- **Customizable Attendance Categories:** I want a system where we can create and rename attendance categories as per our unique needs. It should also allow us to set attendance thresholds and opt for different color codes for different categories. Additionally, having a highlightable trend line to show the fluctuation in attendance against classes or periods would be beneficial.
The ideal applicant should be well-versed in Microsoft Excel functionalities such as formatting, graph creation, and automation. Previous experience in creating educational management tools or similar projects would be a plus. I require someone with a keen attention to detail and a knack for converting numerical data into impactful visual reports.
Features that I would like to see include:
- **Automatic data transfer to graphs:** I want to be able to pull data into graphs automatically. This feature should give us the flexibility to generate graphs based on selected date range, specific students or specific attendance categories to provide a more precise insight.
- **User-friendly interface:** The system should be simple and easy to use. It should provide a straightforward way for us to input data and navigate around.
- **Customizable Attendance Categories:** I want a system where we can create and rename attendance categories as per our unique needs. It should also allow us to set attendance thresholds and opt for different color codes for different categories. Additionally, having a highlightable trend line to show the fluctuation in attendance against classes or periods would be beneficial.
The ideal applicant should be well-versed in Microsoft Excel functionalities such as formatting, graph creation, and automation. Previous experience in creating educational management tools or similar projects would be a plus. I require someone with a keen attention to detail and a knack for converting numerical data into impactful visual reports.