Wednesday, 15 June 2011

Final Gantt Chart

This is my final Gantt chart update showing that everything within the project has now been completed and I am now finshed!!! :)

Final Project Review

The project itself was planned using Microsoft Project, this allowed me to enter all of the specific tasks that had to be carried out during the project and then enter the number of days that I thought it would take to complete each tasks; MS Project then plotted these on a Gantt chart so that I could see exactly which tasks had to be started and completed on which day during the project. I feel that using MS Project to plan the project was a good decision because MS Project allowed me to create an easy to read/understand Gantt chart and the features within the program meant that I could update how far through each task I was and this was then marked on the Gantt chart. I could also easily change the Gantt chart if I felt that the time I had allotted for a particular task was too much or too little.

I feel that the planning of the different tasks that were to happen during the project was done well as I think that the tasks I identified on my Gantt chart accurately represented the tasks that I had to carry out during the project; this made my Gantt chart reliable to follow as I could check off tasks with the project that I had completed. As far as each different stage of my project that I planned I feel that overall I planned the timescale for each different stage well. The design stage of project was however quire rushed as I didn't plan enough time to complete it; I feel that this was a bad decision on my part as I should have thought that it would take longer to complete this stage. Due to my bad planning I feel that my designs could have been of a better quality and in more detail if I had given myself more time; if I was to do this project over I would have allotted myself 2-3 days to complete the designs so that they weren't rushed and were to a better standard.

The implementation stage of my project I feel was very well planned and I made good decisions when planning this stage; I was able to meet every deadline within this stage apart from one and I missed that deadline due to running into trouble with one form within the database. I also feel that I gave myself the correct number of days to complete each different task within this stage as apart from the one problem I had each task took the number of days that I said it would to complete. I feel that this was a good decision by me and if I was to change anything within this stage of the project if I was to do it over would be to give myself one more day to complete this stage so that I wouldn't have been late by one day in this stage.

The testing stage of my project was much better planned than I thought it had been; when I started the testing stage I thought that I had given myself too many days to complete it because I didn't think it was going to take very long but it took the full three days that I had given it to complete. The reason it took so long was because there was much more testing to be done within the project than I thought there would be; therefore I am glad that I gave myself 3 days to complete it. The testing itself was 185 pages long; which was much more than I could have imagined but due to the extra time I had given myself I was able to complete the testing on time. If I was to do the project over I wouldn't change anything I did in the testing stage as it took exactly how long I said it would.
In the user guide and technical documentation stage of my project I gave myself exactly the right amount of days again to complete this stage; this is due largely to me making the decision to change the days allotted to this stage after my interim review. This was the best decision I made for this stage because it gave me the perfect amount of time to complete it and I didn't have to rush the documentation at any stage. If I was to do the project over I would have given myself the amount of days I did after my interim review to begin with; that way I wouldn't have had to change my Gantt chart.

Overall I feel that I managed this project well as I only missed one deadline by a day; this meant that I gave myself the correct amount of days to carry out the necessary tasks. I was able to refer to my Gantt chart all through the project as it was easy to follow and tailored to the tasks I had to do within the project. All in all I think the project went very well and I am proud of how I managed the project and the product that was produced at the end.

Tuesday, 14 June 2011

Almost there :D

Quick update, I have now finished the entire database and have completed the tesing, user guide and technical documentation. There is only the final blog post and evaluation left to do :) Very very happy that I am finally at this stage :) !!!!!!!!!!!!!

Blog Update 14/06/11



Coming into the final week of the project I am currently on target to complete the project; the testing of the database is complete and I had thought that I may have given myself too much time to do it in but it took the whole 3 days to complete it, with the testing ending up being 185 pages long!!!!!!!!!!


I am currently not behind on any part of the project and it is fully up to date.

I have talked to my client on the phone yesterday and he is impressed with the project having seen it and was shocked at how much testing I had done on the project. He didn't think it would be half of what it is.

Friday, 10 June 2011

Finally working

Finally the database is completely working, only one day late. The invoice is now fully functional and I can now move on to the testing stage of the project. I am now up to date with all of my goals and now moving on to start the testing of the database. I have met with my client today to show him the finished database and he is very pleased with what I have produced; he understands that until my project is signed off it is not ready for him to use and is waiting paitently for me to hand it over to him.

Thursday, 9 June 2011

Interim Review

At the beginning of the project I created a Gantt chart so that I could plan what to do at different stages of the project; throughout the project I have tried to stick to my Gantt chart to make sure that the project is on track and in general this has been a success.


First off I had to hand my specification in on the 16/05/11, I was able to hand this in on time as I had made sure that I started it earlier on the 13/05/11; also the designs for my database were due in on the same day, this included: the designs for all the forms, the mood boards and data linkage diagram. Although I was able to get these designs in on time they were rushed and I had to do a very long day in order to get them completed; in hindsight I should have given myself at least 2 days to get the designs completed.



Next was the Implementation stage of the project in which I had to create all of the contents for the database; I gave myself 2 days to create the front screen for the database, which was a massive overestimation as I had it created in 30 minutes, this time extra time could have been better assigned to different task. I also gave myself 2 days to create the sub area pages, which again was a massive overestimation as they were created in just over an hour; I had badly planned the first 2 parts of the Implementation stage and if I was to redo the Gantt chart I would have both of these things being created in one day. I gave myself 3 days to create all of the tables for the database and this turned out to be exactly the right amount of time to estimate; as it took 3 days to complete all of the tables due to waiting for client content. The creation of the forms for the database was given 4 days to be completed and for most of the forms this was a suitable amount of time but having run into trouble with one of the forms I have currently overrun with the time allotted; this is due to not being able to foresee for a problem that I didn't understand how to fix. I gave myself 3 days to create all of the queries in the database and this was a good estimation as it took me about three days to complete all of the queries; due to having to create different queries as I went through the creation process. I gave myself 3 days to create the reports within the database, this was an overestimation as it only took me about 1 and half days to create the report in the database; this extra time would have been better assigned to creating all of the forms. I allotted 1 day to create the macros for the database and this was an accurate estimation as in total it only took me 1 day to create all of the macros. Due to falling behind in my form creation I am not going to meet my Implementation stage deadline, which as it's a major deadline is a serious problem with my project planning; if I had correctly allocated days instead of over and under estimating then my Implementetion stage might have been finishing on time.



All of my meetings with my client were met correctly and easily as Friday each week was the best day to have chosen for both me and client. I was on time with most of my blog posts but due to half term and me being at work most of the days I was a few blog posts behind during the half term. I have since back dated these blog posts so that what I was doing on the project during half term has been documented.



As far as the Testing stage and the User guide and Hand over stages of my project are concerned I have re-evaluated how much time will be necessary for each task; this is going on how far I am through the project and what I think will take the least time, also where I have overestimated for tim necessary to do each task.

Tuesday, 7 June 2011

Blog Update 07/06/11



Major success, there is currently only one thing left to fix in the database and although it is a big and final issue it is at least the last one. Since my last blog post I have been able to complete all of the reports and there are only a few macros left. All of the forms are still not complete but this is due to the final issue being on the invoice form. I have talked to the client today about the progress of the project and he is very happy with how the project is progressing.