Created By: Game Audio Resource Ltd Date: 22/08/2018 Version: 1.00
This guide gives a quick overview of why you should create and use a daily task tracker.
STEP 01: Why Use Them?
STEP 02: Overview
Task Time Needed: variable, depending on knowledge of MS Excel
Chapter 02 B – Step 01
Why use them?
The purpose of a daily task tracker is simply to track the tasks that you do and how long the task took.
A few benefits of using a daily task tracker are as follows:
- It will aid reporting your task updates to the main project audio tracker document.
- TIP: in a professional environment, you may have a team meeting regularly so that everyone can present what work they are doing, have completed, and will be doing. This presents visibility to the whole team.
- it will track how well you have progressed over the week, Month or year, depending on how much detail you set up in the tracker document.
- It can also add a bit of motivation to complete X amount of hours per day.
- If you are self-employed, if any questions or issues get raised by your employer, this tracker will aid & justifying when work has been done or submitted, so you can hopefully get paid!
- You will report the actual hours you have completed for a task.
At the end of a project better planning can be made for the next project using the actual task times logged.
There are 2 types of task trackers you could set up.
- MULTIPLE PROJECT TRACKER
For use when working on multiple projects at the same time.
This is the must useful as working for a corporate company or working as a free-lance designer you will no doubt have 2 projects over lapping.
- SINGLE PROJECT TRACKER
If you are lucky enough to focus on one project only or you only want to supply your employer the tasks you have done related to their project, a single project tracker is most useful.
Having the 2 types will help make the right decision for the right project.
Chapter 02 B – Step 02
The basics for either a single or multiple project document could be as follows:
MASTER STATS OVERVIEW tab:
you will have an overview tab that will highlight stats of what tasks hours you have completed. All stats are calculated from the Daily /monthly tasks tab.
DAILY / MONTHLY tab:
This is where you add what you do each day and how long it took you.
With-in these task logs, you could have:
- What tasks are assigned to you for that week and how long you have been scheduled to complete each task. Also, a status column of each task.
- Under each week a daily box that you can fill in the tasks that you do and the time it took you. Also, a task types & project type drop-down menu.
Using variable lists, helps keep the document formulas working correctly. Also, if correctly set up you can add new options without having to add new formats to the Daily / Monthly tab format.
this content gives you extra details to break down a task. This can help assess where a task was under scoped or over scheduled.
If you choose to use a daily task tracker, how you lay it out is generally is up to you.
However, if your colleagues are using a certain format, it would be good practice to unite the same process for all people.