Problem Topic #5: Task Management Scenario: you work as an assistant to a manager who has a very busy and complex worklo

[answerhappygod]

Problem Topic 5 Task Management Scenario You Work As An Assistant To A Manager Who Has A Very Busy And Complex Worklo 1 (37.26 KiB) Viewed 15 times

Problem Topic #5: Task Management Scenario: you work as an assistant to a manager who has a very busy and complex workload. You notice that they have difficulty managing all of their tasks and staying organized. You have tried putting tasks in a paper to do list and sending them email reminders, but it doesn't seem to be working as well as you had hoped. You identify that the main issue is procrastination and subsequently falling behind in work. The manager needs to understand how much time each task will take, when it can fit into their daily schedule, and how much free time they will have every day or every week if they complete the tasks on time instead of putting it off. Task: make a task management tracker/scheduling template in Excel. Test the functionality of the template by using your school, work, and life schedule as a point of reference and input all of the tasks you have to complete on a daily basis. You will have to make assumptions by guessing how much time each task takes to complete every day. You will have to make a detailed table of how you spend your time every day. You may want to consider keeping a journal that you fill out every day throughout the month of February so that it is easier to remember how you spend your time. You may want to consider writing down how long it takes for you to complete a task (e.g. 30 minutes to clean your house, one hour to complete one step of an assignment, etc.) You will have to find a way to automate the calculation of figuring out how many hours per day and per week you would have free for other activities after you complete the tasks assigned to you every day. When you analyze the data and select your advanced features, consider the answers to the following questions and statements:
amount of hours free at the If I work ____ amount of hours per day on this task, I will have end of the week If I finish a specific step of a task, it means I can start working on the next step of the task Is there a way to show which tasks are currently active and which ones are completed? Is there a way for me to see how much time I spend on each specific task using shapes and colour coordination? Submission: submit two Excel workbooks: one template for the instructor to test and one with populated data to prove that it works.