1 Project Management (7 marks) Consider that you're managing a project for creating a new video-editing tool. You've established a work breakdown structure as follows: Work Breakdown Structure 1. Design User Interface 1.1. Timeline Editor 1.2. Source Clip Listing 1.3. Previewer 1.4. Rendering Progress 2. Implement File 10 2.1. Video Clip Loading 2.2. Audio Clip Loading 2.3. Image Loading 2.4. Video File Rendering 3. Basic Editing Functionality 3.1. Insertion 3.2. Deletion 3.3. Selection 3.4. Cutting 3.5. Resizing 4. Effects 4.1. Fade-In/Out 4.2. Clip Transparency 4.3. Clip Animation 5. Previewing 5.1. Audio/Video Output 5.2. Timeline Progress Display For the purposes of this exercise, estimate a task duration for each subtask, in person-days. Make a series of reasonable (and different!) guesses in the range 1-20 person-days for each subtask. (These estimates do not have anything to do with the numbers in the following table.) Assume that the planned project duration is half of the sum of all your task duration estimates. That is, on average, you plan to make two person-days worth of progress per actual day. (Normally you would calculate the planned project duration from the earliest start/finish times for the tasks, but we'll ignore that for now.) Now, consider that your team has completed the following tasks at specific points in time, expressed in days after the start of the project: Completed Task Completion Time Timeline Editor 9 Source Clip Listing 11 Previewer 11 Rendering Progress 4 Video Clip Loading 18 Audio Clip Loading 16 Image Loading 14 Insertion 25 Cutting 28 The other tasks have not yet been completed. Note: these are not the task durations, but the day when each task is completed; e.g., Cutting" didn't take 28 days to implement, but rather was completed on day 28 of the project (after having been started a few days earlier). Your task is as follows: (a) Produce a spreadsheet-based burn-up chart for this project so far. Specifically: The chart must be embedded in the spreadsheet, which must be in .ods or .xlsx format. You will receive zero marks if you only produce a burn-up chart by itself, without (or independently of) the spreadsheet. The chart must show expected and actual progress. It does not need a scope line. Adhere to the practices from the relevant worksheet. [3 marks] (b) Say your team is using Scrum, with 2-week sprints. Describe what has happened in each sprint so far, and what you would (or could) plan for the next sprint to come. [2 marks] (c) Say your team is also using Kanban (i.e., "Scrumban"), with a kanban board that includes the following middle columns: Coding, Testing and Review". Show what the board would or could look like: (i) Now, assuming you've just finished a sprint. [1 mark] ime that problems were discovered with (ii) Half-way through the next sprint, if we also respect to the Insertion and Previewer tasks. (1 mark]