Tag: software development

How to create a Microsoft Excel dashboard to monitor the progress of a software development project (part 3 of 3)

This article is the last part of a 3 posts series on software development project dashboards with Microsoft Excel. Episode 1 of the series discussed a software defect statistic dashboard, Episode 2 talked about a test progress and test success dashboard. Today’s post focuses on monitoring change requests, one of the biggest threats to complex software projects.

Change requests (CR) raised already during the development of the software lead to additional time and cost needed, threaten the project plan and the budget, bear the risk of additional defects and lead to an instable baseline of the software to be tested by Quality Assurance. That’s why you should definitely keep an eye on the development of change requests throughout the development phase of your software project.

Today’s post provides a minimalist dashboard for monitoring and reporting the actual status of change requests and their development over time. As always including the Microsoft Excel workbook for free download.

(more…)

How to create a Microsoft Excel dashboard to monitor the progress of a software development project (part 2 of 3)

This is the second part of a 3 post series on software development project dashboards with Microsoft Excel. Episode 1 of the series discussed a dashboard to monitor the software defect statistics. Today’s article addresses to another very relevant facet in a software development project: The progress and success of testing.

Testing as the process of validating and verifying quality and suitability of the developed system is at least as important as the number of defects detected. Actually, it goes without saying that testing is the prerequisite of finding software defects. Having said this, it probably would have been better to start the series with this part, but I recognized this too late. My bad.

Anyway: Today’s post provides a minimalist dashboard to monitor test progress and test success within a software development project. As always including the Microsoft Excel workbook for free download.

(more…)

How to create Microsoft Excel dashboards to monitor the progress of a software development project (part 1 of 3)

When it comes to manage software development projects, you have to monitor a lot of different quantitative and qualitative metrics in order to  answer the main question:

“Where are we?”

As in any other project you have to take care of the usual suspects in project controlling like the completion rate of tasks, the milestones and quality gates, the budget adherence, etc. In software development projects, however, there are a couple of very important specific additional facets to be monitored closely:

1. The actual status and the trend of software defects
2. The test progress, test coverage and test success
3. The actual status and the development of change requests

Today’s article is the first of a 3 post series on how to create minimalist, dynamic software project dashboards with Microsoft Excel; this time a software defect monitor dashboard including the Microsoft Excel workbook for free download.

(more…)