Testing
No testing needed beyond checking the leaflet meets the performance criteria.
Task 2 - Dog Training
A system will be made to calculate the price of dog training courses for each dog owner depending on how many dogs are to be trained. For example, walking to heel and not pulling on the lead.
Format of the output
The output will be in the form of a spreadsheet. This will be an interactive screen display, no printing is asked, but it can be if required. There will be columns for the number of dogs on the course, where the course is held, price of course per customer and amount paid to the trainer.
Information to be output
The information to be output will contain, the dog collars, the rewards, the location to train the dogs (the barn, the hall or the sports club). It will contain how many dogs are on each course, the price that each customer has to pay for each course and how much to pay the trainers and the cleaners.
Data needed to produce the output
The data needed to produce the output will be: the number of dogs (less than 15) on the course and where the course is held. These variables will determine how much each customer will have to pay (less than £50) and how much the trainer will get paid (basic rate £20 + £1.10 for each dog). The fixed amounts are: The price of the dog collars (£1.15), the price of the rewards (£1.30), the cleaners (£6 per session). The rent costs are (rent x no. of sessions). I can find all this information from pages 8,9 and 26 of the booklet.
Desired outcomes and performance criteria
The quality of the solution and the style and layout of the output has to give a very clear, easy to read and easy to modify spreadsheet. The maximum number of dogs must be 15 and it must also be colourful. I must have the cost of the dog collars, the rewards, the cleaners and the location that the course will take place.
Testing
Testing is needed in this task to show that the spreadsheet works. I must make sure that the number of dogs is less than or equal to 15 and I must test this. Here is an example of a test where there are 11 dogs in the sports club:
Task 3 – Website
A website must be made for Park view veterinary so they are able to keep up with the technology of the other vets in the area.
Format of output
The output will be a website. The website will have a home page and three other pages. The three other pages will have links from the home page.
Information to be output
On each page there will be a heading to explain what is on the page. I must use treatment costs, dog training courses and animal of the month.
Homepage
On the homepage there will be the name of the surgery, surgery times and the address and phone number. There will be pictures of at least two different animals on this page. The links back to this page will have the word “home” and a little picture next to it.
Treatment costs page
The treatments costs page will have a list of treatments and costs and four pictures. There will be a picture of a cow, a horse, a dog and a cat. This will be to show the range of animals that they treat. It is not just dogs and cats. There will be a picture from clip art for the hyperlink to this page.
Dog training courses page
The dog training courses page will have a picture of a dog and information about the courses. There will be a picture from clip art for the hyperlink to this page.
Animal of the month page
This months animals are cats. It must have information about cats and a picture of a cat. There will be a picture from clip art for the hyperlink to this page.
Data needed to produce the output
The data needed to produce the output will be the name of the surgery, surgery times and the address and phone number (Page 5 of the booklet), pictures of the different animals (file on disk), the treatment costs (Page 26 of the booklet), dog training (Page 26 of the booklet), animal of the month (Page 25 of the booklet) and the pictures for the hyperlinks (clipart, file on disk).
Desired outcomes and performance criteria
The quality of the output has to be very good and easy to read so that members of the public are able to use it. There has to be a title page with three hyperlinks to sub pages. The sub pages are to have hyperlinks to the homepage only. The homepage must have hyperlinks to all the sub pages. The pages must include the following things:
Homepage
On the homepage there will be the name of the surgery, surgery times and the address and phone number. There will be pictures of at least two different animals on this page. The links back to this page will have the word “home” and a little picture next to it.
Treatment costs page
The treatments costs page will have a list of treatments and costs and four pictures. There will be a picture of a cow, a horse, a dog and a cat. This will be to show the range of animals that they treat. It is not just dogs and cats. There will be a picture from clip art for the hyperlink to this page.
Dog training courses page
The dog training courses page will have a picture of a dog and information about the courses. There will be a picture from clip art for the hyperlink to this page.
Animal of the month page
This months animals are cats. It must have information about cats and a picture of a cat. There will be a picture from clip art for the hyperlink to this page.
Testing
Testing is needed to show that all the hyperlinks work and to print out the homepage and all the sub pages.
Task 4 – Template letter (Mail Merge)
I must produce a template letter to produce reminder letters for customers with pets that need a booster vaccination.
Format of output
The output will be in the form of a letter in Microsoft word, although we will also be using a database.
Information to be output
The information to be output is that each animal has to be vaccinated once a year. The pet record has the month and year of the last vaccination. So the customers with cats and dogs who needed a vaccination in November 2003 are the ones who had the vaccination last year at the same time. The name of the pet is in the letter, the name of the person is in the letter, the address of the person is in the letter and the date of the vaccination is in the letter. All these are the variables that we have to change in order for the mail merge to work. It will also have Rachel Burns (surgery manager) signature on the letter.
Data needed to produce the output
The data needed to produce the output will be; the customers name (Page 21 of the booklet), the name of the pet (Page 22 of the booklet), the customers address (Page 21 of the booklet), last year vaccination month and year (Page 22 of the booklet) and the text in the letter (Page 27 of the booklet).
Desired outcomes and performance criteria
The quality of the solution and the style and layout of the output is, it has to be easy to read, you must be able to change the name of the customer, name of the pet, address and the date of the last vaccination on the letter. It has to be set up as shown in the leaflet
Testing
I can test my system by finding the customers with dogs and cats that are due for a vaccination reminder in November 2003.