Reviewing the number of changes made to a project plan

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. A student wants a first measure of how well their original plan matched the work. What should they count?

A The number of changes made to the plan

B The number of pages in the final report

2. Where can you find the changes to tally in a project plan?

A In the annotations added to the plan

B In the title of the plan

3. A plan ended up with only 2 changes over 8 weeks. What does this suggest?

A The plan matched the work poorly

B The plan matched the work well

4. A plan ended up with 15 changes over 8 weeks. What does this suggest?

A The original plan did not match the work well

B The original plan was perfect

5. Which is a good way to group changes when reviewing a plan?

A By the colour of the annotation text

B By type, such as task changes and time frame changes

Match the Pairs

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

Left column		Right column
1=COUNTA(C2:C20)		AThe text criterion is missing quotation marks, so the formula errors. It should be "Time frame".
2=COUNTIF(D2:D20,"Task")		B=IF(COUNTA(C2:C20)>5,"Many","Few")
3Show what share of the plan's tasks needed a change, to judge many vs few changes		C=COUNTA(C2:C20)/COUNTA(A2:A20)
4Label the plan as having many or few changes using a set limit		DTallies the change notes recorded in the annotation column to give the change count
5=COUNT(C2:C20)		ECOUNT only counts numbers. The annotations are text, so the result is 0 and the change count is wrong. Use COUNTA.
6=COUNTIF(D2:D20,Time frame)		FCounts only the changes of type Task, grouping the changes by type

Definitions

change count

Fill in the Blanks

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

=______(B2:B20)

=_______(C2:C20,"Time")

changes = ["Task", "Time", "Task"] print(___(changes))

=__(D2>5,"Many","Few")

counts = {"Time": 3, "Task": 2} print(___(counts.values()))

Spot the Error

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

Question 1

A changes = 0

B for note in notes

C changes += 1

D print(changes)

Question 2

A changes = 5

B tasks = 20

C ratio = changes * tasks

D print(ratio)

Question 3

A changes = 0

B for note in notes:

C changes += 1

D print("Total:", chages)

Question 4

A Changes = 0

B if changes < 3:

C print('Few changes')

D else:

E print('Many changes')

Question 5

A changes = 12

B if changes > 10:

C print('Plan was weak')

Answer Key

Reviewing the number of changes made to a project plan

Section A: Quick Questions

A — The number of changes made to the plan

A — In the annotations added to the plan

B — The plan matched the work well

A — The original plan did not match the work well

B — By type, such as task changes and time frame changes

Section B: Match the Pairs

=COUNTA(C2:C20) → Tallies the change notes recorded in the annotation column to give the change count

=COUNTIF(D2:D20,"Task") → Counts only the changes of type Task, grouping the changes by type

Show what share of the plan's tasks needed a change, to judge many vs few changes → =COUNTA(C2:C20)/COUNTA(A2:A20)

Label the plan as having many or few changes using a set limit → =IF(COUNTA(C2:C20)>5,"Many","Few")

=COUNT(C2:C20) → COUNT only counts numbers. The annotations are text, so the result is 0 and the change count is wrong. Use COUNTA.

=COUNTIF(D2:D20,Time frame) → The text criterion is missing quotation marks, so the formula errors. It should be "Time frame".

Section C: Definitions

change count — The number of changes made to a project plan, tallied from its annotations. Few changes suggest the plan matched the work well; many suggest it did not.

Section D: Fill in the Blanks

=COUNTA(B2:B20)

=COUNTIF(C2:C20,"Time")

changes = ["Task", "Time", "Task"]
print(len(changes))

=IF(D2>5,"Many","Few")

counts = {"Time": 3, "Task": 2}
print(sum(counts.values()))

Section E: Spot the Error

B — The for loop that tallies each annotation is missing its colon. It should be 'for note in notes:'.

C — The share of tasks that changed is found by dividing changes by tasks, not multiplying. It should be 'ratio = changes / tasks'.

D — The variable name is misspelt, so Python cannot find it. It should print the tally variable 'changes'.

A — Python is case sensitive, so 'Changes' is a different name from 'changes' used on the next line. The tally should start as 'changes = 0'.

B — The comparison is the wrong way round for the message. Many changes (12 is more than 10) suggest a weak plan, and the program should check 'if changes > 10:'. Wait: the correct line is 'if changes > 10:', so the broken line checks the opposite.