Create scrum board in excel

Create A Scrum Board
.

Projects that conform to the Agile methodology often use something called a scrum board. You can think of a scrum board as a digital whiteboard containing yellow "stickies," each listing a task, posted beneath categories such as "to do," "in process," in testing," and so forth. Using a scrum board in this way allows all project members to see where important tasks are in the overall project process quickly and easily.

For this learning team assignment, you will collaborate with your team members to create an Agile scrum board based on the project charter you created with your team in Week 2.

Note that in an industry situation, you would most likely use a specialized software tool to manage your scrum board such as Jira, Rally, Asana, or Basecamp. However, in this course, you will be using a tool that you may already be familiar with—Microsoft® Excel®—to create your scrum board and other deliverables. It is the organization and assignment of tasks that is important about a scrum board, not the specific software tool you use to create and manage the scrum board.

To complete this learning team assignment:

Review the Learning Team Scrum Board Example (attached) spreadsheet. (Note: Click the Board tab that appears at the bottom of the spreadsheet to see the scrum board example.)

Create a scrum board in Microsoft® Excel® format similar to the linked example. The scrum board you create should align with the project charter you created in the Week 2 Project Charter learning team assignment. Be sure your finished scrum board incorporates a project budget.

Board
Sprint User Story/ Scenario Design Development Test UAT Release
1 U - Deposit
S - Deposit Transaction x
S - View deposits B
Scenarios
User Story Scenario As a … I want to … so that … Notes Status
Deposit Deposit transaction bank customer deposit check money is in account
COS
User Story/Scenario Given (precondition) When (trigger) Then (result) Notes Status
Deposit Transaction user takes picture of check in phone app user presses 'Deposit' user account is updated