Scrum and Sheets with MS PROJECT Online

Hi,

in my previous post (https://ntrajkovski.com/2019/10/15/how-to-implement-scrum-with-ms-project-step-by-step/) I’ve created Task board, and I assign Tasks to two of five defined Sprints:

I’ve modified column for each and sprint:

image

OK! We have board. Let me explain different Views for Scrum.

On the top of Sprint Tab we have different options:

image

Let’s start with the Task Board:

image

If I choose it I will get:

image

As you can see, all Task are here, no matter if they are in the sprints or not. You can see for each Task is it (in my example) in Not Stated, Doing, QA or Done status.

If I choose Task Boars sheet, I will get:

image

Here I can also see all Tasks, but I can see Sprint in which if particular Task (if any), Work in hours, what is it Board status, Resources, etc. Her I can also change those- For example, let’s say that Task 1 is Done, and Task 9 is in Sprint 3:

image

Now, back to the Sprint Board(s):

image

and:

image

So, with Task Board sheet you can very easy manage each and every Task, without jumping from board to board.

Now, let me show you planning Tab:

image

With Sprint Planning board I will get:

image

Here, I can see all defined Tasks, and their Sprints. With Sprint Planning sheet, I will get:

image

This is very similar to Task Board Sheet. It has one more column: Show on Board.If I choose: No for particular Task it will not be seen in any board like:

image

and:

image

or:

image

or:

image

If you ask me WHY someone will want to hide some Tasks, my answer will be: “We are in planning”. So, we are not sure that we will do this Task, so no one can put it in some sprint by accident. And therefore, it should not be used like I did, but it should be used (from my point of View), to tasks which are not in the particular sprint.

Finally, Sprint Tab:

image

In this post you have seen Boards for Sprint(s), so I am going to show you Current Sprint Sheet:

image

This sheet is exactly the same as Sprint planning sheet, but it shows only Tasks for current Sprint, and it does not show any hidden Tasks (Task 2, in my example).

To conclude you can manage Sprint projects in many different and efficient ways.

Regards!

About Nenad Trajkovski

Location: Zagreb, Croatia Occupation: Project Manager Interests: Project Management and MS PROJECT He was born in Zagreb, Croatia at 1963. After completing his college he started working on projects in different business areas (banking, manufacturing, automotive industry, distribution, oil companies, etc.) developing and implementing ERP systems into different companies. He has got a lot of experience working with people in different business processes and also possesses great knowledge in information technologies and financial services. Today he works as a business consultant, adn Project Manager in PERPETUUM MOBILE d.o.o. Zagreb. He is a regular lecturer for Project Management in MS Innovation Center in Varaždin, Logosoft Sarajevo in Bosnia and Herzegovina and SEAVUS GROUP in Skopje Macedonia. He was named the best lecturer of WINDAYS 2008 while his lecture was also voted as the best. In addition, he was in TOP 10 lecturers at the MS SINERGY 2009 and MS VISIA 2009, 2010. Shares first place as the best lecturer of KulenDays 2009 and 2010 and PMI Conference 2009 in Zagreb. He is also a regular lecturer in the MS Community. He is a Certified Accountant and a PMP (Project Manager Professional) and a PMI-RMP (Risk Manager Professional), MCP, MCT, and Microsoft Certified Technical Specialist - Microsoft Project 2010. From 01.01.2012 awarded with MVP (Microsoft Most Valuable Proffesional - Microsoft Project)!
This entry was posted in Project Online and tagged . Bookmark the permalink.

Leave a comment