Business problems and solutions.

Side two:

• Text file ‘Opening times and text for leaflet’
• Garden centre photo.
• Range of Products (This is in the opening times text file)
• Garden centre logo.

2.

Desired outcomes:

The quality of the solution:

• It has to be easy to read – needs testing I will ask several people.
• Has to have good use of colour – doesn’t need testing.
• Has to have photos – doesn’t need testing.

The style and layout of any information to be output:

• A plant picture and information about how to look after it.
• Must be well laid out.
• A4 Size.

Plant labels

With the Plant labels I will produce a plant labels and a system to find the right label.

The label will be printed and will be 5cm high by 9cm wide, I will show a screen display of the system to find the label.

I will use mail merge to make the plant labels.

The label must contain:

• The Latin name of the plant (in italics).
• The plant’s eventual height and width.
• The plant’s flowering period.
• The price of the plant (must be clear).
• Garden centre name and logo.
• Colourful border.

I will also use a database to find the plant labels.

Data needed to produce:

• Plant data .csv file (this contains the information).
• Garden centre logo image.
• Image for the plant I am going to use on the example label.

The quality of solution:

• It has to be clear and easy to read - needs testing I will ask several people.
• The labels must not be too big – doesn’t need testing.

The style and layout of any information to be output:

• It has to have the name of the plant, its eventual height and    width and its flowering period – doesn’t need testing.
• The price must be clear- needs testing I will ask several people.
• The Latin name of the plant must be in italics – doesn’t need testing.
• The labels must have a colourful border and the logo on each label – doesn’t need testing.

Web site

The form the output will take:

With the web site I will print out the entire web page with text and graphics and I will also take a screen shot of the web site working.

The web site must contain:

• Pictures of some of the plants (one on each page).
• Must be attractive.
• Must be divided into sections.
• A page for trees and shrubs, one for herbaceous perennials, one for bedding plants, one for rockery plants and one for garden supplies.
• Latin names and prices for the plant pages.
• Item names

Data needed to produce:

• Opening times text file
• Webtext text file
• Plant details .csv file
• Supplies .csv file
• Image and clipart files

The quality of the solution:

• It has to be easy to read. – needs testing
• It has to be attractive. – needs testing
• All of the links have to work. – needs testing
• It has to contain one image of a plant on each page. – doesn’t need testing.
• Each page must contain a link back to the home page. –doesn’t need testing.
• Must include picture and text hyperlinks. – doesn’t need testing.
• The lists of plants and prices must be on the right page. – doesn’t need testing.
• The address and phone number with the name of the garden centre and photo must go on the homepage. Also the text about growing plants also has to be on the homepage. – doesn’t need testing.

The layout of the solution:

• There must be a picture on each page.
• The home page must link to all other pages and the other pages must link back to the homepage.
• Must include picture and text hyperlinks.
• The address and phone number must be on the homepage along with the name of the garden centre, a picture of the garden centre and the text about growing the plants also has to be on the homepage.

Plant stock list

The form the output will take:

With the plant stock list I will produce a list of plants that don’t grow bigger than a given size and will grow in particular light conditions.

This will fit on an A4 sheet of paper.

The information to be output:

The information to be output is the common name, the maximum height and the flowering period.

Data needed to produce the output:

• Plant data file.

The quality of the solution:

• It has to be easy to read. – needs testing.
• It has to be easy to use. – needs testing.

The style and layout of any information to be output:

• The list must have the name of the garden centre, logo and light needed at the top.
• There must be column headings.
• Only the fields common name, max height, max width and flowering period must be displayed.

Pond Cost Calculator

The form the output will take:

For the pond cost calculator I will produce a spreadsheet which will              calculate the cost, the size and how many of certain things that are                

needed. This must fit on a side of A4 paper when printed.

The information to be output:

Cost, size of pond liner, number of decorative plants, cost of decorative plants, number of underwater plants, cost of underwater plants and depth of pond.

Data needed to produce the output:

Length of liner = (2.5 x depth) + length of pond

Width of liner = (2.5 x depth) + width of pond

Size of pond liner = length of pond liner x width of pond liner

Number of decorative plant packs = (length of pond liner + width of pond liner) x 2

Number of bunches of underwater plants = length of liner x width of liner x 5

Cost of pond liner = £4.40 per square metre

Cost of underliner = 90p per square metre

A bunch of underwater plants = 50p

A decorative plant pack = £3.50

A water lily = £8.50

A fountain = £55

The quality of the solution:

• Must be easy to use – needs testing
• Printout must be clear and easy to read – needs testing

The style and layout of any information to be output:

I will use different colours for each of the different places where you put in the data to make the system easier to use.