Here is the prioritization task: I. Prioritization task The Office Manager must be able to juggle a dozen tasks at once and execute flawlessly under enormous time constraints. Let’s say that you walk into school at 6:58 am on Monday morning and are confronted by the situation described below. In what order would you respond to the following demands and how would you proceed to address each demand? ____ An angry parent walks into the office demanding to speak to the Principal regarding a discipline action taken the prior day. ____ Voicemail: The network Managing Director left you a voicemail confirming the lunches that were supposed to be ordered in preparation for a workshop at your campus that day. You forgot to order the lunches. ____ A 2nd grade teacher comes into the office to ask for new homework folders for his students. They have been ripping in recent times and there is a bulk of new ones stored in the basement storage area. ____ A number of students begin trickling in early, 20 minutes before breakfast is scheduled to arrive. The students proceed to throw coins at each other while they sit on the lobby benches and create a lot of noise. You are the only school employee on the first floor. ____ A father comes in to complain that his daughter got in trouble for having a white stripe on her shoes. Her shoes were mostly black but not all black, so she had to sit in the office the entire morning yesterday. ____ Text: Teacher sends you a text message stating the following: “Latisha came in early for tutoring and just got sick outside of Ms. William’s classroom. The custodian is nowhere to be found, the DOO is outside greeting students and it is everywhere. I’ve got breakfast duty and cannot stay. Can you go take care of it and deal with Latisha? Thanks.” ____ The Director of Operations comes to greet you at the door stating that she just received an email from the Director of Development stating that there is a last minute tour scheduled at your campus with major donors who in aggregate fund a majority of your network’s philanthropy dollars. It is expected that there are 20 guests, however you only have 5 visitor folders put together. ____ Two teachers are making last minute copies for today’s classes and the Main Office copier jams. They’ve tried three times to clear the jam, but the machine is still not working.

Here is the Excel task: Gathering and organizing information is an essential part of the work as an Office Manager. Below you will find a list of student names and grades that a teacher just submitted to you. Please create a new Excel spreadsheet with this information, making sure that the spreadsheet has the following: Nice presentation: a header, good spacing/margins, borders, etc. Students put in order from highest grades to lowest grades for both math and English Averages for each student and for the class Whenever possible, use the Excel features to help you.

Correspondence task: At the end of each quarter we distribute report cards for each scholar. In order to pick up the report card, parents must attend a mandatory conference with the teachers. The conference schedule is spread over three days so that teachers can meet with the parents of every child in their class. Each individual conference lasts 20 minutes. Draft a note home to parents informing them of the upcoming parent teacher conferences. The letter should briefly describe the details of the conference dates and times and remind parents that attendance is mandatory. The note should also capture information from parents regarding their availability. Since the conference schedule is spread out over three days, the operations team will want to schedule each scholar’s conference at a time when his/her parents are actually available to attend. This note will be sent home to every scholar two weeks prior to conferences so that the operations team has enough time to organize the schedule for each class. This one-page form should capture all necessary information needed for scheduling conferences in a way that is easy for parents to understand, fill out, and return the next day.