- Fat Fighters Slogan on Spreadsheet – This was a difficult objective to meet as I had found out later on that the Fat Fighters company did not have a slogan so this objective could not have been fulfilled.
- A list of at least 30 exercises/ activities – This was not a difficult objective to meet as a list of food were already given to me by the manager and I had found out the caloric content on the internet.
- A list of at least 60 Foods - This was not a difficult objective to meet as a list of activities were already given to me by the manager and I had found out the caloric expenditure content on the internet.
- Should be interesting - by using appropriate color and images. – I fulfilled this objective by taking out questionnaires when designing the layout of the spreadsheet and asking questions about what colors and images would be used and how to make the spreadsheet interesting.
- Should look professional - by the layout, color and images. I fulfilled this objective by taking out questionnaires when designing the layout of the spreadsheet and asking questions about what colors and images would be used and how to make the spreadsheet look professional.
- Drop Down lists of exercises/activities and Foods should be sorted alphabetically – The drop down list of exercises/activities and Foods sorted alphabetically was a hard thing to do as I did not have the information to sort it out in an automatic way so I had to type them out manually, although this was time consuming the objective was met successfully.
- Should be easily changeable – This was not a hard objective to meet as the information and formulas were easily changed.
-Easy to use - instructions, or just being easily typed in and finding out the answer straight away. - Questionnaires were asked to find out if the spreadsheet was easy to use. The questionnaire results were positive meaning that the objective was met.
- Easy to understand - Appropriate font and colors used to understand what has been written. – Questionnaires were asked to find out if the font was appropriate and if the content was understandable, the questionnaire results were positive meaning that the objective was met.
From the Questionnaire you can see that the spreadsheet project was an overall success, the thing that people liked most were the colours and the background/layout, user/customer 5 thought that the spreadsheet project also looked professional, which meets one of my quantitative objectives.
However some people thought that there was not enough information and they did not like the word art that was chosen, the suggestions on what to change were to use less text and add more information and images.
To make the spreadsheet a success I would add more images onto each spreadsheet page, e.g. on the calculator pages, which would improve the quality of the spreadsheet by making it more interesting therefore helping to meet one of my objectives.
I would have designed the layouts on what they had ended up to be in the first place, this was because I thought it looked better and this would have saved time and made me have more time to work on something else to do with spreadsheet, and I would have had more time to improve it.
I would have also used more verification and validation formulas to decrease the chances of error.
I would have also used less Word art as it was an unpopular choice, I would have maybe chosen a different type of Word art which was more popular with the user/customers.
In order to find out what was popular I could have made a questionnaire using a sample of Word Art types and ask which ones were their favourites.