Tracking task progress

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. Which row would you expect to see in a task tracker?

A Design poster | Mia | In progress

B Posters are colourful and fun

2. What is the best way to record a task's status so everyone uses the same words?

A A status drop-down with Not started, In progress and Done

B A blank box where each person types anything they like

3. What is the owner column for?

A It shows who made the spreadsheet file

B It shows who is responsible for each task

4. Jay finishes writing the survey questions. What should he do in the tracker?

A Delete the task's row so it disappears

B Change the task's status from In progress to Done

5. On a to do / doing / done board, where does a task go when someone starts working on it?

A Move it from To do to Doing

B Move it from To do to Done

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Status: Not started \| In progress \| Done		AA status drop-down that lets you pick how far along a task is
2Owner: Mia		BThe owner is 'Everyone', so no single person is responsible and the team can't tell who is doing the task. Each task needs one named owner.
3A to do/doing/done board puts each task card in the column that matches its current status		CEdit video \| Sam \| In progress
4A tracker row records the task, its owner and its status in one place		DTo do: Write script \| Doing: Film clips \| Done: Pick music
5Task: Design poster \| Owner: Everyone \| Status: In progress		EThe status is a made-up phrase. It should be one of the agreed choices: Not started, In progress or Done.
6Task: Write report \| Owner: Jo \| Status: Nearly finished-ish		FThe owner column shows which team member is responsible for the task

Definitions

task tracker

Fill in the Blanks

Complete each line of code by filling in the missing parts.

=_______(C2:C10,"Done")

Task | _____ | Status

To do | _____ | Done

Drop-down options: Not started, ___________, Done

=COUNTIF(______,"In progress")

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Task | Owner | Status

B Poster | In progress | Mia

C Script | Sam | Not started

D Slides | Lee | Done

Question 2

A Task | Owner | Status

B Research | Ava | Done

C Survey | Noah | Finished

D Report | Zoe | Not started

Question 3

A Board: To do | Doing | Done

B Card: Build level 1

C Start work: move to Doing

D Finish work: move to To do

Question 4

A Task | Status

B Design | Jay | Done

C Build | Kai | In progress

Question 5

A Column: Status

B Choices: To do, Doing, Done

C Type: Free text

Answer Key

Tracking task progress

Section A: Quick Questions

A — Design poster | Mia | In progress

A — A status drop-down with Not started, In progress and Done

B — It shows who is responsible for each task

B — Change the task's status from In progress to Done

A — Move it from To do to Doing

Section B: Match the Pairs

Status: Not started | In progress | Done → A status drop-down that lets you pick how far along a task is

Owner: Mia → The owner column shows which team member is responsible for the task

A to do/doing/done board puts each task card in the column that matches its current status → To do: Write script | Doing: Film clips | Done: Pick music

A tracker row records the task, its owner and its status in one place → Edit video | Sam | In progress

Task: Design poster | Owner: Everyone | Status: In progress → The owner is 'Everyone', so no single person is responsible and the team can't tell who is doing the task. Each task needs one named owner.

Task: Write report | Owner: Jo | Status: Nearly finished-ish → The status is a made-up phrase. It should be one of the agreed choices: Not started, In progress or Done.

Section C: Definitions

task tracker — A table or board that lists each task with its owner and status (Not started, In progress or Done), so the team can see who is doing what and how the project is going.

Section D: Fill in the Blanks

=COUNTIF(C2:C10,"Done")

Task | Owner | Status

To do | Doing | Done

Drop-down options:
Not started, In progress, Done

=COUNTIF(C2:C10,"In progress")

Section E: Spot the Error

B — The columns are in the wrong order. The header says Owner then Status, so this row should be Poster | Mia | In progress.

C — The status must be one of the agreed choices: Not started, In progress or Done. 'Finished' is not one of them. It should be Survey | Noah | In progress.

D — A finished task moves to the Done column. Moving it back to To do would make the board show the task as not started.

A — The tracker header has no Owner column, so the team can't see who is doing each task. It should be Task | Owner | Status.

C — A status column should be a drop-down so everyone picks from the same choices. Free text lets people type different words and makes the tracker messy.