Question Description
Question 3: Continue on a new tab in the excel spreadsheet attached.
Overview
We know that attendance at school has a direct impact on a scholar’s success. We expect all scholars to be in school on time every day, because every minute matters. Teachers submit attendance, and it is Ops’ responsibility to do Whatever It Takes to communicate to all families and to drive towards 100% attendance.
Task
Below are the two charts that our Dean of Students sends to our staff in a daily email with our key culture “health stats” regarding our school’s attendance, homework completion, and uniform rates for the day. As the Office Coordinator, it’s your job to make this ready to go for the Dean of Students – all she should have to do is copy and paste in to her email.
Our daily “health stats” Summary Chart [“Percentages” tab in Excel file]:
Attendance Notes [“Attendance Events” tab in Excel file]:
Here are more details on the current process and data:
- The Excel file attached contains the raw charts and data for your reference. (Note that the numbers/names do not exactly match.)
- Homeroom teachers log the attendance data directly into our student information system (Infinite Campus) each morning by 7:40am.
- You can pull a report for the school’s attendance data details.
- You begin to call families of absent scholars at 7:45am and track any notes for all staff’s reference.
- You update the Health Stats Summary Chart manually with the day’s attendance and on-time percentages.
- Teachers-in-Residence check HW binders for completion and enter it into our online tracking system (Kickboard). It produces a raw data extract as in the Excel file (“KB Export” tab).
- Teachers-in-Residence manually calculate and update the day’s HW completion and uniform percentages.
Using the information above, please:
- Edit the Excel file to make each day’s refresh of the percentages as automated/efficient as possible. You are welcome to manipulate the workbook in any way you see fit, including editing any fields or creating new sheets. (If there are any assumptions that need to be made about the process or the data, please detail these in your final submission.)
- Suggest other process improvements (outside of Excel) to improve our Health Stats tracking and communication system. Be creative and innovative!
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Place Order” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.