The target audience is Harry at Harry’s Boarding kennels and any other staff he has now or will employ in the future .
You will need to have a printer , monitor , a mouse for the computer , a keyboard , a computer , a memory stick to back up the solution , wireless router for WIFI
The software required to make the solution is a database software (Access) , a spreadsheet software (Excel) and Word .A search engine for carrying out research .A security network.
The success criteria is what is needed for a successful solution:
* Must include a range of software features including :
* Data Integration across and/or within different software applications
* Password protection
* Validation checks
* Software wizards
* ‘what if’ predictions
* be able to model out different situations as well as data
* must be user friendly (have a user friendly interface) and suitable for the target audience
* the data can be edited/manipulated
* Be fully tested so a minimum amount of errors can occur when the solution is passed over to Harry and his employees
* must make Harry’s jobs more organized and efficient
* let certain data to be searched for within the spreadsheet
* When you alter a cell , the data in the cell next to it should change in sync .
This will allow Harry to store owner details eg Name and telephone number . Store dog details eg name , breed , age , gender , special dietary requirements as well as other relevant information . Use information about a dog’s stay (eg kennel number , number of days stayed and extra services ) to produce an invoice which they can have at the end of each visits including the costs . Calculate income and expenditure every month . Allow Harry to plan future prices by changing the profit and seeing the price required to achieve this profit . Allow for future expansions or changes to the business such as getting more kennels or adding on more extra services .
Outputs to be produced
At the end a spreadsheet , invoices , letters and a graph which is able to manipulate and edit details . There should be filters so Harry for example can see all the dogs with a gluten intolerance .
Test plan and test data
How to improve
The solution must include macros
There should be a button with a label and when you click the button it should send you to the location in the spreadsheet that was stated on the button
The solution must include data validation checks
If there is a phone number , there should be a validation check making sure it is only 11 digits long and no letters are included
There should be error messages
If there is a phone number with more or less than 11 digits typed in , an error message should pop up asking the user to change the data in the cell as it is invalid
Data Validation used appropriately
There should be spell check on certain cells such as where the extra services are stated but no on cells where names are to be typed in , as some first and surnames are not recognized by spell check
Be user friendly and suitable for the target audience
Harry should be able to use and understand the solution with little to no confusion. There should not be over complicated ICT used that Harry will have to use as well . Conditional Formatting is fine as he will not have to edit this afterwards
Must have password protection
Some cells can only be edited by Harry’s Employees to edit the rest they would need the password . There can also be password protection on the whole document .
There should be ‘what if’ predictions
If a certain profit is wanted , you should be able to type this into the profit cells and the prices should change accordingly to reach this profit .
Use vlookups to find the price of a service
After all the information has been entered for the extra services , the user should be able to on a different sheet , enter the extra service and the correct price should be brought up via a vlookup
The data is stored chronologically
You can easily filter between the past and recent stays .
Must show income and expenditure
There must be formulae’s automatically calculating the expenditure and income including the SUM formulae .
Be able to transfer data between applications
Harry’s Employees must be able to access the solution . The solution needs to be saved with macros enabled
Harry needs everything/some cells to be password protected so no one can edit and change the solution without his permission , because that would ruin the time and effort that has been put in to create the solution .