Agile Masterclass: Agile for Project Management - Burndown Chart Activity

The video tutorial explains how to create a burndown chart in Excel, starting with setting up a table with columns for dates, estimated work, and actual work. It guides through plotting the estimate and actual lines, highlighting weekends as non-working days. The tutorial concludes with the usefulness of burndown charts in tracking project progress, especially in Agile methodologies.

What is the first step in creating a burndown chart in Excel?

• Insert a pie chart

• Create a three-column table

• Add a trendline

• Highlight weekends in red

Why are weekends highlighted in the burndown chart template?

• To show peak work periods

• To separate weeks

• To mark non-working days

• To indicate holidays

How is the estimated work line plotted in the burndown chart?

• By inserting a scatter plot

• With a line chart using markers

• By manually drawing lines

• Using a bar chart

What happens to the actual progress line when the team completes more tasks than estimated?

• It becomes a dotted line

• It falls below the estimated line

• It rises above the estimated line

• It remains flat

On which date did the team complete three tasks together?

• 4th October

• 5th October

• 9th October

• 6th October

What is the primary purpose of a burndown chart?

• To track financial expenses

• To monitor project progress

• To manage team attendance

• To allocate resources

In which project management methodology are burndown charts commonly used?

• Six Sigma

• Waterfall

• Agile

• Lean