Design specification for an IT system for Harry's Dog Kennel business.

Target Audience

The target audience is Harry at Harry’s Boarding kennels and any other staff he has now or will employ in the future .

Hardware requirements

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

Software requirements

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.

Success criteria

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

* Macros

* 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 .

Solution Outline

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

Test Number

Test

Expected Outcome

Actual Outcome

How to improve

1

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

2

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

3

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

4

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

5

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

6

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 .

7

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 .

8

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

9

The data is stored chronologically

You can easily filter between the past and recent stays .

10

Must show income and expenditure

There must be formulae’s automatically calculating the expenditure and income including the SUM formulae .

11

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

Data security

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 .