Design and create a website for a company of my choice. I have decided to base this project on the company "Belle Du Jour".
Description of task
My task in this project is to design and create a website for a company of my choice. I have decided to base this project on the company "Belle Du Jour". This is a bridal shop which sells dresses for special occasions and bridal accessories. "Belle du jour" would like to increase their business using a different strategy. At the moment their current strategy of increasing their production is by using advertisements in newspapers and magazines to reach there potential customers. I have decided that the best way to help them improve the service they provide is to set up a website for the company so that they can attract more customers. This means that they can advertise globally at a low cost it will also help to expand their business. I think this is the best way to help "Belle Du Jour" as they only have a limited amount of money and this way they will be able to advertise over the internet where people from all over the world could see the company's advertisements. This would also help the company to expand there business from a single business to a chain shop across England.
The website will be eye-catching and informative, but interesting too.
I would like the website to include the following features. This will help to achieve the main goals of the public:
* The site will be easy to use and easy to access.
To accomplish this I will make sure everything is simple. I will include links between pages and make sure that the links can be seen at all times.
* I will use pictures of the products and items that are sold at the shop.
This will mean that potential customers are able to browse through a catalogue of the available items so that they won't need to visit the shop and then find that the company doesn't sell what they're looking for.
* I will use advertisements of any special offers or sale etc.
This will be beneficial for the customers as they can see any current information with all the offers the shop is promoting.
* I will make the background colourful and personalised.
I can do this by producing a wedding-themed background. This will be used by our company and will be personalised.
* I will provide a visitor account/guestbook
Every time you go online you can enter your visitor number into the guestbook so that when you reserve a dress or order one you will not need to enter all the details.
Report
I am producing a website to advertise a shop, called "Belle du jour" so that everyone can be provided with the information needed across the Internet. This will help them to increase their business.
The disadvantages of advertising using traditional methods are
* It can take a lot of time
* Its expensive
* Not many people listen to adverts.
The advantages of advertising using the internet are
* Its cheaper
* Has a wider audience
* Lots of picture to use
This website will improve the company's advertising campaign as it is very sufficient because anyone with the internet can get hold of this website. Using the internet gives everyone an advantage to see all the advertisements being showed, this will develop their advertising campaign as it can be viewed world-wide and it will produce more customers.
The advantages of using the spreadsheet to handle the figures are:
* It does the calculations for you
* Its quicker
* Its clearer
* You can show data in chart format
Using a spreadsheet to handle the figures is an advantage as it has special keys that are excellent for using figures, such as the auto sum key.
I expect this webpage to be an interactive link for everyone. The layout will be attractive and informative. It will have the Basic features of a website e.g. a header, footer, main page, and a index bar.
I will have to research the company's sales and stock list. I will get a catalogue containing the different types of dress outfits and their prices. I will also need to interview the company's managers and co-workers about what they would like to see on their website.
Investigation and Analysis of the problem
Belle du jour - Background information
Belle du jour is a single business that sells dresses for special occasions and bridal accessories. It was first established in 1994 and since the year 2000 they feel that sales have been lacking and they would like the opportunity to increase their business.
Here are the details of the shop.
Shop
Address
category
Store parking
Manager
Belle du jour
3 Clarence Street,
Staines,
TW18 4SU
High street store
No
Josh Brown
The shop sells dress outfits for different occasions but it mainly sells wedding dresses which you can also hire. But now they have expanded their stocks and sells hair accessories along with the dress and other accessories like the jewellery and shoes.
The range of dress items include most occasions such as, wedding, prom and evening.
The dress range contains most accessories, which have connection with the outfit.
Location of the store
Belle Du Jour is located near Staines High Street. Unfortunately there is no store parking as the store is only small and due to the busy roads outside the shop it is not safe and there is also very little room for this. However, there are plenty of Car Parks situated throughout Staines, the nearest is opposite Debenhams Department store and "Belle Du Jour" are just a few minutes walk away in Clarence street.
To access the company by road take the M25 junction 13 or A30 directly into Staines town. There are plenty of Car Parks situated throughout Staines, the nearest is opposite Debenhams Department store. The nearest main line station is Staines, or underground is Hatton Cross. The nearest bus station is opposite the Blue Anchor pub.
Directions from:
Sainsbury Store,
The Causeway,
Staines,
TW18 3AP
Depart on A308 The Causeway. At the first roundabout that you approach keep going forward.
At the next roundabout take the right lane leading to Clarence Street. Keep going until you arrive at the shop along the left-hand side of the road.
By train:
If you take the train to Staines station you come out of it ,turn right and walk through Laleham road then you turn right towards the iron bridge and keep walking until you get to Debenhams then cross the 2 roads and turn right again keep walking until you get to the chip shop and cross the road there. Then turn right and walk on until you see the shop on your left.
Interviews with the key personnel
Josh brown, manager of belle du jour
As manager of "Belle du jour" I believe that it is my responsibility to give my company the opportunities to improve the standard of success. At the moment we are looking to expand our advertising campaigns as we need extra business so that we can expand that company into a chain shop. I have been searching for different methods that will develop our advertising campaigns further and as a result it appears that producing a website for the company will not only help us with are new target but it will gain more customer from worldwide at a low cost.
I would like to see a website that includes a catalogue of our products. The catalogue should have pictures of the products and the prices. It should be updated frequently, showing all the new offers. This would let eager customers to browse through our catalogue without picking it up from the shop. I would also like to add a customer information page where they can search for details of the shop. On there will also be all different ways of contacting us for example; telephone number, email address, fax number and possibly the manager's mobile number. This will provide customers with a positive attitude towards the website as they are aware of how to contact us. It will allow them to ask questions or comment on the shop, this will help us as a company to improve our services.
Colin smith - Technical Director Belle du jour Inc.
I have been conducting research about the idea of producing a website and our staff working at "Belle du jour" is all very enthusiastic about the whole idea. I think that the website will be a success and give us a way forward into the future targets that we will face. We will be aiming to expand our business.
The information I have been researching relates to the facilities of the website. I have found out that the majority of the people will be put off by the slow speed of the websites and I understand the customers will want to see quality websites of high standard. So I would like to see the webpages load relatively quickly. I also noticed that they like to have a personal account for websites so it saves them time when they go to ordering things. They don't like time consuming tasks! I would like there to have a guest book service on there to save us the problems of losing business.
I have discussed with my partners the jobs that will need to be performed. I will be in charge of updating the site whenever it is needed. I will put in a checking system so that if unrecognised data is typed in it will be easy to able and I can alter the data to correct it.
Mr D Houston - purchasing manager
I have been given the responsibility of purchasing the supplies for "Belle du jour". My job involves me to decide how much stock I will need to purchase. The amount varies depending on the product and the occasion.
I think that the website should have the prices of the product and in the future I would like to see a stock checker facility so that customers will be able to check that we have the product they we are looking for in stock as they could run out easily.
The survey
I have created a survey for "Belle du jour" the first survey I have created will help me to produce the website as of the expectations of the public. It will show me the features of people's computer systems so that I know what programmes and type of network they have. This will allow me to find out what I can include on the website. The second survey is shorter and it is asking the public what sort of features they would like to see on the webpages.
. Do you have access to the internet?
Yes
No
2. Have you ever use an online ordering system?
Yes
No
4. Do you feel secure paying over the internet?
Yes
No
3. Are you prepared to wait at least 15 seconds for each web page to load up?
Yes
No
4. Do you like to have your own account to sign in, on the website?
Yes
No
5. Do you think that it is important for the company's logo to appear on the website?
Yes
No
6. Do you prefer a website to have its own personalised theme?
Yes
No
7. Do you want to be able to see links to all pages at all times?
Yes
No
8. Do you prefer pictures to writing?
Yes
No
9. Do you like websites to have frames?
Yes
No
0. Does your computer have acrobat reader so you can read downloaded information?
Yes
No
2. Would you like the website to have a help section?
Yes
No
3. Would you like contact details of the company?
Yes
No
4. Is your computer connected to a printer?
Yes
No
5. Do you have a colour printer?
Yes
No
6. Would you like to receive emails informing you of the latest offers?
Yes
No
Please select what other features you would like to see on the site
Details on the products and items sold
Yes
No
Pictures of the products and items in the catalogue section
Yes
No
Links to other wedding websites
Yes
No
A webpage about the company's services
Yes
No
A webpage about forthcoming events
A page about caring for your dress
Yes
No
A comment page where you can tell us what you think about the company
...
This is a preview of the whole essay
Yes
No
Please select what other features you would like to see on the site
Details on the products and items sold
Yes
No
Pictures of the products and items in the catalogue section
Yes
No
Links to other wedding websites
Yes
No
A webpage about the company's services
Yes
No
A webpage about forthcoming events
A page about caring for your dress
Yes
No
A comment page where you can tell us what you think about the company
Yes
No
Results of survey one
Here are the results of the survey, I have produced separate graphs for each question so that you can see clearly how each question has been answered.
Question one shows that the majority of people do have access to the internet. This means that the setup of their new website would be very useful and effective for use of potential customers.
Question two shows that a lot of people have used an online ordering system. This means that including an online ordering system would benefit the company.
Question three shows that there is little variance between the two answers, some customers do not feel secure using an online payment system and others do. This suggests that I will need to consider different methods of payment.
Question four shows that most of the people asked are prepared to wait 15 seconds for a webpage to load up. This means that we have to put a limit on the amount of space of each webpage.
Question five shows that the majority of the people would like to have their own account to sign into. This means that a guestbook should be available to people so that details can be saved and stored.
Question six shows that most of the people think it is important for the company's logo to appear on the website. This would be beneficial for the company as it will help to personalise the company's website.
Question seven shows that nearly all the participants of the survey would like the website to be personalised. I think this is because it would be easily recognised. I think this would be an advantage to the company and its customers as they will be able to identify who the website belongs to.
Question eight shows that nearly everyone thinks that having links to all pages at all times is a good idea. I think that this is because it will prevent confusion and it would mean that the customers will not need to search for the links. I think this will be beneficial for the company as it will make the website simple and easy to use.
Question nine shows that there is little variance between the two answers, this shows that customers would like pictures and writing available on the website instead on just having everything on one chosen format i.e. pictorial format.
Question ten shows that most of the responses would like the website to have frames. I think this is because it is more structured and there is a simple layout so it will make it easier to use.
Question eleven shows that a lot of the interviewees do have a software program called acrobat reader that allows them to read downloaded information.
Question twelve shows that the majority of people would like a help section. I think this would be really useful for the staff as they need to know how to use the website.
Question thirteen shows that nearly all the responses would like the website to have contact details so that they will be able to get in touch with the company. This would be beneficial for the customers as this means they can have different options of contacting the company.
Question fourteen shows that most of the people are connected to a printer so they can print off any information they need from the website instead of having to go directly to the shop to get the details they need.
Question fifteen shows that the majority of the responses show that the people who are connected to a printer have a colour printer. This means that the colour on the webpage will print out and it will make everything look personalised.
Results of survey 2
Here are the results of the second survey. To show the results of this survey I will be using a combined bar graph. I have decided to use this type of graph as we can compare the demands for different features more easily.
Question one and two shows that all of the people asked would like a catalogue page with pictures and details of the products and items that are sold in the shop.
Question three, four and five show that the majority of people would like to be informed about the company's services and events through the website. They would also like to see links to other wedding companies.
Question six shows that all of the participants of the survey would like to know about how to care for the dress. I think this would be a really good idea as it would be very helpful for the customers to know how to look after their dresses carefully.
From this survey I would say that it has given me an advantage because now I know what type of expectations for the website. I think that I will include all these features on my website as the results of my survey have been very successful and it shows that most people would like these features to be included.
Stock information
Here are the details about the products and items "Belle Du Jour" purchase for there shop.
Belle du jour inc.-stock control
Branch: Belle du jour, Staines
Product:
Product style:
Price to buy:
Price to hire:
Description:
Wedding dresses
Ball Gown
£700+
£400-£700
Available colours: Cream, Ivory or White
A-line
£600-£1,000
£350-£700
Available colours: Cream, Ivory or White
Empire
£500-£1,000
£300-£600
Available colours: Cream, Ivory or White
Column
£500-£1,000
£300-£600
Available colours: Cream, Ivory or White
Mermaid
£500-£1,000
£300-£600
Available colours: Cream, Ivory or White
Fishtail
£500-£1,000
£300-£600
Available colours: Cream, Ivory or White
Bridesmaid / Prom dresses
Ball Gown
£200-£400
£100-£200
Different colours and decorations
A-line
£150-£350
£100-£200
Different colours and decorations
Empire
£100-£300
£50-£150
Different colours and decorations
Column
£100-£300
£50-£150
Different colours and decorations
Mermaid
£100-£300
£50-£150
Different colours and decorations
Fishtail
£100-£300
£50-£150
Different colours and decorations
Tiaras
One size
£20-£40
£5-£10
Different colours and decorations
Veils
One size
£30-70
£10-£50
Different colours and decorations
"Belle Du Jour" order in about 50 stocks of each product and item listed above. This will vary according to the high or low season.
Summary of investigation
When I surveyed the staff at "Belle du jour" I found out what they would like to see on their website:
Source of data
Wish list
Comments
Josh brown, manager of belle du jour
Advertising special offers at low cost
The new deals will be advertised globally over the internet, on their personal website as this is cheaper and more efficient.
Online catalogue
An online catalogue will be easy for customers to access but the speed of the WebPages must be fast.
Contacts page
This should have lots of different methods of contacting the staff and also the address of the shop
Colin smith - Technical Director Belle du jour inc.
Facility to E-mail orders
Product ordered on line will be processed in the same manner as telephone and fax orders. This order will be confirmed by return email and dispatched and charged as usual, at general prices.
High Speed
The website will need to be relatively quick to load up otherwise customers will be put off.
Guestbook
A personal account for each member who registers or orders with us is required for the customer database. The guess book should allow customers to sign in to their account whenever they visit the website to save them time when ordering products.
Mr D Houston - purchasing manager
A page about the stock sales
This will allow customers to view the different stock that the company sell
A stock checker
This allows customers to enter in the product code to find out if we have the product they're looking for in stock.
Results of survey
All of theses suggestions will be considered in the process of making this website.
We will take into account the comments made so it will improve our website.
Specification
Analysis and overview
The different pages that I will create for the website are:
A main page - this is like an introduction to the company's website it has details about the origin of the company. This will be beneficial to the customers as they will have some sort of knowledge about the company they are buying from.
A guestbook - where people can enter register with the company and sign into their account so that when you reserve or order a dress you will not need to enter any details in.
A catalogue - this will show all the items and products sold along with the details of each item. This page will be broken down into two other pages one page will be for the dress section and the other will be for the tiara and veil section.
A search page - this will allow the customers to search for a certain product. This would be an advantage to the users of this website as they can look for specific items and products instead of browsing through the whole website to find what they are looking for.
A comments page - where customers can ask questions and tell the company any problems which have occurred. They will also be able to make suggestions to help improve the company's service. This page would be appreciated by many people as they know the company are making effort to change their service.
A contacts page - this will have all the information of the manager's e-mail, telephone number, fax number, and the location of the shop.
An order form - this will allow customers to order online rather than going directly to the shop to order.
A survey page - where customers can fill out the company's survey and send it to the company. This is sort of like a census and it will help the company to expand.
A stock page - this page allows you to check the stock availability. This means that they don't need to contact the company directly to check that the product they want is currently in stock.
An item care page - this page tells you how to care for your product. It gives you some tips on how too stops creases and stains from staying in the product. I think this page would be very useful as it shows that the company take pride in their service and customers know how to handle these dilemmas.
An offers page - this page will be updated frequently with the latest offers. This will show the company's advertisements.
An events page - this page will have all the details about any forthcoming events that are related to the company.
A services page - this page gives information to the customers about the services "Belle Du jour" offer to their potential clients. This page will give background information about the company and the services they hold.
A Links page - this page will have link to other bridal companies that share a partnership with "Belle Du Jour". This will be useful for the customers as they can browse other products that "Belle Du Jour" is not currently selling.
The layout of the website:
Links to
Webpages
This diagram shows the brief layout of my website. I will have the name of the company at the top of the website so that people will immediately know what website it is. On the left hand side of the website I will an index frame where you always have access to the links so that you won't need to search for them and on the right hand side I will have the main page where all the linked webpages will appear. This part of the website will have the largest amount of space so that the pages can be seen clearly, as this is the most important part of the website.
The special features I will include on my website are:
Frames - this will help to keep the website neat and clear so that the users will not get confused.
Button links - this will help to personalise the company's website and make it look more professional.
Pictures - this will make the website more appealing and interesting for the users.
The maximum file size for each of the webpages on the website is 20 KB.
The maximum file size for pictures are 5KB.
Evaluation Criteria
The features which will be included in my website are:
* An index frame - this is for easy control on the website and so that the users have access to all links at all times. This means that you don't need to search for the links.
* The company name/logo - this is to personalise the webpage so that people will know who owns the website and what website they are visiting.
* Links between the pages - this gives easy navigation to the users so that they will be able to see pages in a click instead of having to search through loads of different pages that are not linked.
* A comments page - this is for customers to let the company know what they think of the website. IT allows you to make complaints, suggestions, problems and praise.
* A search page - this is to help customers find what they are looking for instead of going through the catalogue to see if the product they are looking for is sold at the company. This helps the user to save time and makes the website more efficient.
* Quick downloading pages - this is so that customer's wont get frustrated waiting for pages to download.
Design of solution
This is a development of the diagram of the website completed in the investigation and analysis part. It shows a clearer view of what my final design of website will look like.
I have used frames on the website because it will make the website easy to use with access to the links at all times. I decided to put it on the left hand side because it can be found easily and it looks clearer. For the links I used Yellow/Gold buttons so it looks presentable and professional.
I decided to use the gold swirl theme as it reminds me of celebrations and weddings. I used that theme because it represents the theme of wedding. The gold colour symbolises Valuable things this is why I have used this colour as a wedding is one of the most valuable events of someone's life. The yellow colour I have used symbolises happiness as this is the emotion you have when you celebrate your marriage. Other colours I have used in some of the webpages are blue and pink. I used these colours as blue is sometimes associated with relaxation and pink is a feminine colour which represents love and romance.
The company name is written in gold writing because this is how it was first created when the company had been established. The gold colour was originated from this.
There will be use of text and pictures as both these things are important. The text helps to explain things and the pictures help to show what the text is describing.
Layout of links and pages
I have spilt the site into these sections because it is more organised and easy to control, so that the users can just click on the page they want instead of searching through different links that are no use to them. It will make the website more systematic. At the bottom of each website I have included linked buttons to the home page, the page back and the page forward. These are just for extra assistance. I think this will be beneficial for someone who isn't computer literate as this means that they are many links available for them to use. Some of which do the same function.
I have made it easy for customers to browse through the internet by using a frame on the website so it is organised and easy to find what you want. The links can be seen at all times which make it easier to browse through the website.
The maximum file size is 20 KB for each webpage. I have worked out that the maximum file size for the whole of the website will be 78MB. I decided on this file size because I found that 75MB was too small to store lots of information and pictures on and 75MB was about right but I decided that I will give it 3 more megabytes of storage just in case it will be necessary.
Hardware Resources
I would recommend the following computer for users to run my website on:
Here are some of the features this computer system has.
* 2.8GHz Intel Celeron Processor
* 256Mb DDR RAM
* 80Gb Hard Drive
* DVD RW Drive
* 64Mb GeForce4 Graphics
* Firewire
* 56K Modem
* 17" CRT
* Windows XP Home Operating System
The total cost for this hardware package is £499.99 including VAT. I think that I would also need to include a printer and scanner as this will be needed to upload images onto the website. I have chosen to use an all-in-one printer because this means that you can have all 3 functions in just one printer. It allows you to print, photocopy and scan.
Model - HEWLETT PACKARD PSC1110
Product Code - 978213
This costs £69.99
I recommend this computer system because it uses the standard operating system and it also has a large storage space to save the files in. it has a graphics card so you can view special graphics.
This hardware system will cost £569.98 including VAT.
Software Resources
Here is a list of programs that I can use for completing my project website design with:
Software Package
Features
Chosen
Easy Web Editor
A fast, instructive and powerful web design program with added templates for assistance. Has advanced functions to create a professional looking website.
Drawbacks: Quite expensive and not a lot of people have heard of this website software program.
No
Microsoft FrontPage
Enhanced tools to produce high standard websites. It includes dynamic web templates so you don't have to start from scratch.
Drawbacks: Very expensive software program
Yes
Softline Namoweb editor
Advanced webpage creation creating a dynamic, cutting-edge Web site with advanced web design tools.
Drawbacks: Quite complicated to use, it is for more advanced people to use.
No
Serif internet design suite
A cheap software program with easy-to-use features. It is an award wining program. Produces outstanding webpages.
Drawbacks: Some of the tools are limited.
No
I have chosen to use Microsoft FrontPage because it is a very popular type of software program which enables you to produce sophisticated websites. This software program is used by many business people and a lot of people know how the functions of this program works as it is very similar to the functions in word.
Data collection, data capture and input
I chose these questions for my customer survey and stock control tasks because I believe that the questions will help me to collect research information to give me ideas on how I should produce this website.
The information will give me an average of people's opinions and if the majority of people own a computer with connection to the internet. This survey will allow me to obtain information from the public.
2. Do you have access to the internet?
Yes
No
2. Have you ever use an online ordering system?
Yes
No
4. Do you feel secure paying over the internet?
Yes
No
3. Are you prepared to wait at least 15 seconds for each web page to load up?
Yes
No
4. Do you like to have your own account to sign in, on the website?
Yes
No
5. Do you think that it is important for the company's logo to appear on the website?
Yes
No
6. Do you prefer a website to have its own personalised theme?
Yes
No
7. Do you want to be able to see links to all pages at all times?
Yes
No
8. Do you prefer pictures to writing?
Yes
No
9. Do you like websites to have frames?
Yes
No
0. Does your computer have acrobat reader so you can read downloaded information?
Yes
No
2. Would you like the website to have a help section?
Yes
No
3. Would you like contact details of the company?
Yes
No
4. Is your computer connected to a printer?
Yes
No
5. Do you have a colour printer?
Yes
No
6. Would you like to receive emails informing you of the latest offers?
Yes
No
Please select what other features you would like to see on the site
Details on the products and items sold
Yes
No
Pictures of the products and items in the catalogue section
Yes
No
Links to other wedding websites
Yes
No
A webpage about the company's services
Yes
No
A webpage about forthcoming events
A page about caring for your dress
Yes
No
A comment page where you can tell us what you think about the company
Yes
No
This is the survey that I conducted. The first survey helped me to find out the type how many people own a computer with internet connection and it also helped to find out what type of computer systems people have. The second survey helped to find out what type of webpages they would like on the website.
I designed the customer survey so that it is in a table because it is clear and easy to read. I kept the layout simple so that it wouldn't confuse people and I also made the responses to be closed answers (yes or no). I did this because I wanted straight answers as this would help me to determine if they want something or not, instead of having maybe not sure which wouldn't really help me.
This is the stock control sheet that I created in the Investigation and Analysis section of the project.
Product:
Product style:
Price to buy:
Price to hire:
Description:
Wedding dresses
Ball Gown
£700+
£400-£700
Available colours: Cream, Ivory or White
A-line
£600-£1,000
£350-£700
Available colours: Cream, Ivory or White
Empire
£500-£1,000
£300-£600
Available colours: Cream, Ivory or White
Column
£500-£1,000
£300-£600
Available colours: Cream, Ivory or White
Mermaid
£500-£1,000
£300-£600
Available colours: Cream, Ivory or White
Fishtail
£500-£1,000
£300-£600
Available colours: Cream, Ivory or White
Bridesmaid / Prom dresses
Ball Gown
£200-£400
£100-£200
Different colours and decorations
A-line
£150-£350
£100-£200
Different colours and decorations
Empire
£100-£300
£50-£150
Different colours and decorations
Column
£100-£300
£50-£150
Different colours and decorations
Mermaid
£100-£300
£50-£150
Different colours and decorations
Fishtail
£100-£300
£50-£150
Different colours and decorations
Tiaras
One size
£20-£40
£5-£10
Different colours and decorations
Veils
One size
£30-70
£10-£50
Different colours and decorations
I have created the stock control in a table with heading and subheadings as this will make everything look neater and professional. I have broken down the products into more specific description as this gives you the whole outlook of the products instead of just having a wedding dress, a prom dress and a bridesmaid dress written down. I have also given details about the cost for buying and the cost of hiring these products. I have set it out like this because it shows how much the company earns from these items.
I have designed a spreadsheet to show the stock details of the company "Belle Du Jour".
The spreadsheet is very similar to the stock control sheet. Bellow is the printout of the spreadsheet. I have put the data into a table format so that it is easy to read and change the cells. The layout of the spreadsheet is simple so customers and staff will understand what the data inside the table is showing. I will be creating a link on my stock webpage so that you can view the stock control spreadsheet.
I have created my comments page for the website. The comments page is set out in 4 stages. The first stage asks the user to select the type of comment. The second stage asks what they would like to comment on. The third stage asks you to enter the comment and the fourth stage asks you how you would like to be contacted regarding this matter. I have decided to set the page out like this so all the comments can be sorted into one category and dealt with separately.
Below is the print out of this comments page.
Data verification and validation
I have added Validation checks to the spreadsheet that I produced for the stock information in the last section. I have made sure that all data input has some form of check on it. This means that the data cannot be accidentally deleted. I have also made this document a read only spreadsheet, so it can only be viewed by others but not changed.
This is how I have put in the validation checks:
To add a validation check you need to highlight the column that you want to have a validation check on it. Then go to Data on the top toolbar and go down the menu list to "Validation..."
Select the validation criteria you would like to validate. Then you need to put in the boundaries.
Enter an input message so that every time you click on the cell in that column it will remind you about the validation check. You should also insert an error alert message so that if incorrect data is inserted it will ask you to check the data.
When you finish press ok and the validations will be in place.
I have also changed all cell properties on the spreadsheet to read only, apart from some of the cells that I would like prices to be typed in. This won't let the formulas be accidentally deleted. Read-only is a setting that allows a file be read or copied, but not changed or saved.
To do this I turned on the sheet protection this will secure the data in the table as no-one can edit the changes unless they unprotect the sheet.
Now I am going to check that the validation checks are working.
These are the validation checks I have used:
For the product column the data validation is text length between 0 to 30 characters.
For the product type column the data validation is text length between 4 to 10 characters.
For the description column the data validation is text length between 10 to 50 characters.
For the amount in stock column the data validation is a whole number between 0 and 100.
For the price column the data validation is a decimal between1 0.00 to 1100.00.
All the webpages have been verified on the website by displaying all the pages on internet explorer. This is the standard internet server used by most of the internet browsers in the world. I did this to make sure that the source code is compatible with this browser. Form doing this I can see whether the pages will be displayed correctly.
Data and Program Structures
Below are printouts of my website to show how it has been constructed. I have now created my website; it consists of 14 main links to webpages and some other links to the catalogue and enlargement of pictures. Here is a brief summary of each page on my website.
On the home page I have some text and 3 pictures of dresses as decoration. The text is welcoming the customer onto the website and it tells the user some background information about the company so they know a little about the company's origin.
On the guestbook there is a brief explanation on why you should register with the company. There are some text boxes which you fill in the details it asks you for. At the bottom there is buttons. One of them is to submit the details and the other is to clear the details. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The catalogue is a simple page that asks you to select the type of catalogue you would like to browse. There are two links which will take you to two different catalogues. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The search page tells you how the search engine works and there are two buttons which tell you to either start the search or reset it. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The comments page is set out in 4 stages. The first stage asks the user to select the type of comment. The second stage asks what they would like to comment on. The third stage asks you to enter the comment and the fourth stage asks you how you would like to be contacted regarding this matter. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The contact us page gives you details on how you could contact the company. They give you the address of the shop, the telephone number, the fax number and the e-mail address. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The order page tells you to fill out a form asking you for the details of the product you want to order and the amount and shipping information. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The survey page has text telling you about the survey and why it is so important. It asks you nine simple questions about your opinions and some personal information too. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The stock page is there so that you can check stock availability. To do this you have to enter the product name and model. There is also a link so that customers can view the company's stock control. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The item care page tells you how to care for the product you purchased from the company and show you the different methods you could use to prevent creases and stains from staying in. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The special offers page tells you the latest offers that the company is holding. It is written in coloured test and in fancy boxes for decoration. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The events page encourages customers to come and view fashion parades and exhibitions of wedding dresses etc. It gives you the date, time and place of the forthcoming event. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The services page talks about the company and the service they provide to their customers. The test is written in capital letters as it shows that this is important. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The links page will have a list of links to other bridal companies. At the bottom of the page I have included 3 buttons. One button takes you back a page, the other button takes you forward a page and the next one takes you to the home page.
The printout of the webpages is below. Please note that not all of the information is printed out onto the printouts as there is not enough room. Also the background theme has not printed out but it is shown in the design solution part.
I have printed the full page of each section of the catalogue webpage as when you open it on the website screen you do not see the whole of the page. Also I have printed one example of what the zoom hyperlink does on the catalogue. Please note that the colour on this webpage has not been printed out.
Output format
All the output formats in this project will be able to fit on a full screen. This means they will be screened based. Each webpage is able to fit on a screen resolution of 800*600. The layout of the website is clear and understandable. It has been designed for people with low computer skills so that anyone who wants to go on the website will be able to know how to use it. The website is divided into different sections, it is separated by frames. This will make the website look tidy and professionally made as it will help to enhance the structure of the website. The website has also been personalised so that if someone went onto the website they will immediately recognise that it's the company's website. It has been personalised by the swirl theme. I used swirls as I think it is associated with weddings and celebrations. I have also put in the company's name in the top frame.
On the website it has links to other pages in the left frame, when you click on the link the page will appear in the middle frame otherwise known as the main page frame. I did not use a footer frame as I don't think it will be necessary to have.
Testing of solution
This is a table showing all the areas of my project that will be tested.
Test
Carried out by
Evidence + result
All web links tested
Loading Front page and go to preview the click on the displayed links to make sure that each one works.
Visual results only
Main page to guest book and back
Clicked on link
Correct page displayed
Main page to catalogue and back
Clicked on link
Correct page displayed
Catalogue to dress catalogue and back
Clinked on linked
Correct page displayed
Catalogue to tiara + veil catalogue and back
Clinked on linked
Correct page displayed
Main page to search and back
Clinked on linked
Correct page displayed
Main page to comments and back
Clinked on linked
Correct page displayed
Main page to contact us and back
Clinked on linked
Correct page displayed
Main page to order form and back
Clinked on linked
Correct page displayed
Main page to survey and back
Clinked on linked
Correct page displayed
Main page to stock and back
Clinked on linked
Correct page displayed
Main page to item care and back
Clinked on linked
Correct page displayed
Main page to offers and back
Clinked on linked
Correct page displayed
Main page to events and back
Clinked on linked
Correct page displayed
Main page to services and back
Clinked on linked
Correct page displayed
Main page to links and back
Clinked on linked
Correct page displayed
Viewing pages In an internet browser to see that it displays on the screen correctly
Page loaded in internet Explorer at resolutions of 800*600 and 1024*768
Visual results only
Main page (Home)
As above
Displayed correctly
Guest book
As above
Displayed correctly
Catalogue
As above
Displayed correctly
Search
As above
Displayed correctly
Comments
As above
Displayed correctly
Contact us
As above
Displayed correctly
Order form
As above
Displayed correctly
Survey
As above
Displayed correctly
Stock
As above
Displayed correctly
Item care
As above
Displayed correctly
Offers
As above
Displayed correctly
Events
As above
Displayed correctly
Services
As above
Displayed correctly
Links
As above
Displayed correctly
Validation checks working correctly on Product column
Incorrect data entered into spreadsheet
Validation checks working
Validation checks working correctly on Product type column
Incorrect data entered into spreadsheet
Validation checks working
Validation checks working correctly on description column
Incorrect data entered into spreadsheet
Validation checks working.
Validation checks working correctly on amount in stock column
Incorrect data entered into spreadsheet
Validation checks working
Validation checks working correctly on selling price column
Incorrect data entered into spreadsheet
Validation checks working.
This spreadsheet records the name of the files that is used for the website and the file size. I have added formulas that add up the file size for each page and put in validation checks so that if the file size is too big a warning message will appear.
Page
Filename
File size (KB)
Total Size (KB)
Download time at 6 K/S
Status
Main page
Main.htm
3 KB
9 KB
.5 K/S
OK
Header.htm
3 KB
Index.htm
3 KB
Guestbook
Guestbook.htm
5 KB
5 KB
0.83 K/S
OK
Main Catalogue
Catalogue.htm
5 KB
5 KB
0.83 K/S
OK
Dress Catalogue
Dcatalogue.htm
7 KB
50 KB
8.33 K/S
OK
Zoom1.htm
3 KB
Zoom2.htm
3 KB
Zoom3.htm
3 KB
Zoom4.htm
3 KB
Zoom5.htm
3 KB
Zoom6.htm
3 KB
Zoom7.htm
3 KB
Zoom8.htm
3 KB
Zoom9.htm
3 KB
Zoom10.htm
3 KB
Zoom11.htm
3 KB
Tiara + veil Catalogue
Tiaracat.htm
5 KB
51 KB
8.5 K/S
OK
T1.htm
3 KB
T2.htm
3 KB
T3.htm
3 KB
T4.htm
3 KB
T5.htm
3 KB
T6.htm
3 KB
T7.htm
3 KB
V1.htm
3 KB
V2.htm
3 KB
V3.htm
3 KB
V4.htm
3 KB
V5.htm
3 KB
Search
Search.htm
6 KB
6 KB
K/S
OK
Comments
Comments.htm
1 KB
1 KB
.83 K/S
OK
Contact us
Contact us.htm
5 KB
5 KB
0.83 K/S
OK
Order
Form.htm
7 KB
7 KB
.17 K/S
OK
Survey
Survey.htm
0 KB
0 KB
.67 K/S
OK
Stock
Stock.htm
5 KB
5 KB
0.83 K/S
OK
Item care
Care.htm
7 KB
7 KB
.17 K/S
OK
Offers
Offers.htm
6 KB
6 KB
K/S
OK
Events
Events.htm
9 KB
9 KB
.5 K/S
OK
Services
Services.htm
7 KB
7 KB
.17 K/S
OK
Links
Links.htm
5 KB
5 KB
0.83 K/S
OK
Entire website
------------
----
98 KB
33 K/S
Website OK
I have carried out these tests to make sure that the website is working properly and all the pages will be viewed correctly. The test I have carried out helps me to check that all links in place are working correctly and that the webpages is displayed correctly. I have also checked the file size of each webpage so that I can check the speed of the pages loading up. I have checked that all pages load up under 15 seconds as this was the target time. In the questionnaire I asked if the public were prepared to wait about 15 seconds for each webpage to load up. I found out that the majority of responses would wait this long for the page to load. The entire website will take longer to load up because it has all of the files to load up.
Documentation of solution
Here are instructions on how to load my web page editor:
. Click on the office icon
2. Click on Front page
3. Go to file open
4. Look in "homes on 'joshua' (G:)"
5. Click on website document
Here are instructions on how to use my web page editor:
. Click on preview bottom at the bottom of the frame.
2. Click on the different hyperlinks in the index frame
Here are instructions on how to view the source code and add Java scripts:
. On Front page click on html and the source code appears on the page
2. Type in the source code to add a Java script
Here are instructions on using frames:
. Go into Front Page
2. Click on new page
3. Click on page templates
4. Click on the frames page
5. Choose the frame type you want
Here are instructions on adding video clips:
. Use a digital video camera to record the video
2. Use the software supplied by the manufacturer to move your video to your computer.
3. Upload the video clips to the website.
Here are instructions on adding sound and music:
. Use a digital audio recorder to record the sounds
2. Use Real Audio to edit the sound
3. Upload to website.
Here are instructions on how to create animated pictures:
. Click on graphics icon
2. Click on "Macromedia flash MX"
3. Paste picture and edit it for animation
4. Upload to the website.
These are instructions for basic use of my spreadsheet program:
. Open the file
2. Save a copy to your computer system or Print a copy
Here are instructions on changing the printer:
. Plug in the printer
2. Click the Start button.
3. Chose printers
4. Click on the add printer option
Here are instructions on installing a modem:
. Plug in the modem
2. Open Phone and Modem Options in Control Panel.
3. On the Modems tab, click Add.
4. Follow the instructions in the Install New Modem wizard.
Here are instructions on connecting to the internet:
1. Click on the internet explorer icon and it will connect you to the internet.
Here are instructions on uploading my webpage to the internet:
1. you need an FTP (file transfer protocol) program to send your Home Page from your computer to the Internet server.
2. Run WS FTP by double-clicking on the WS_FTP32.EXE or the WS_FTP.EXE file.
Here are instructions on how to change the validation rules in my spreadsheet:
. Open the File
2. Go to Data on the toolbar
3. Click on validation
4. Edit the checks
Here are instructions on changing the cell settings:
. Click on a cell
2. Go to format in the tool bar
3. Click on cells
4. Change properties.
This is how you protect and unprotect the spreadsheet:
. Activate the worksheet to be protected
2. Choose Tools - Protection - Protect Sheet.
3. You will be asked to provide a password (optional). If you do provide a password, that password will be required to unprotect the worksheet.
Here are instructions on changing the formulas used:
. Click the cell
2. Delete the formula
3. Type in new formula
This is how you save to different formats:
. On the file menu, click save as
2. In the file name box, enter a name for the workbook
3. In the save as type box, click the format you want.
This is how you back up the webpage and the spreadsheet:
. Save to re-writeable CD (keep away from computer)
2. Or save to a floppy disk.
Evaluation of solution
Overall I think the project was very successful but I think there is still room for improvement. I have produced a specialized website for the company. This website is for the customers to browse through, it will help to bring the company more business. I have managed to generate my ideas and achieve all my aims. The website is an easy to use site which helps advertise the company to anyone from around the world.
Here is the evaluation criteria that I completed in the investigation and analysis section.
The features which will be included in my website are:
* An index frame - this is for easy control on the website and so that the users have access to all links at all times. This means that you don't need to search for the links.
* The company name/logo - this is to personalise the webpage so that people will know who owns the website and what website they are visiting.
* Links between the pages - this gives easy navigation to the users so that they will be able to see pages in a click instead of having to search through loads of different pages that are not linked.
* A comments page - this is for customers to let the company know what they think of the website. It allows you to make complaints, suggestions, problems and praise.
* A search page - this is to help customers find what they are looking for instead of going through the catalogue to see if the product they are looking for is sold at the company. This helps the user to save time and makes the website more efficient.
* Quick downloading pages - this is so that customer's wont get frustrated waiting for pages to download.
Below I have listed each of my evaluation criteria points and commented on how they have been achieved.
Evaluation criteria
How successful
An index frame for easy control on the website
I used a frame template from Microsoft FrontPage to do this.
The company name/logo to personalise the website
This was completed by using word art. I chose a fancy font and then used the gold colour to personalise it.
Links between the pages for easy navigation
This was done using a special function on FrontPage.
A comments page for customers to tell the company what they think of the website.
This is easy to produce. It was achieved editing a page template from FrontPage.
A search engine to help users find items in the web site.
This is easy to produce. It was achieved editing a page template from front page.
Quick downloading of pages
This was accomplished by limiting the file size of the pages.
Area for improvement
Reason not implemented
Addition of sound and video clips where suitable
I didn't have the recommended program to add video clips and sound. This would have used a lot of the file size.
Use of Animated pictures
I found it difficult to use the "Macromedia flash MX" program to animate the pictures and it would also take up a lot of the storage space.
