• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

In this document I will begin to explain why I have included the following features in my Exam Spreadsheet. The context is a system which you can order a window for your house or business.

Extracts from this document...

Introduction

In this document I will begin to explain why I have included the following features in my Exam Spreadsheet. The context is a system which you can order a window for your house or business. Spinners - I have used spinners in the sheet 'Find area' in cell D5, as it reduces what the user has to input. This reduces the likelihood of input errors. Its large and intuitive style made it easy for the user to alter data easily, meaning users don't get confused about what to input in. Also, as the spinner is linked with cell B5, the most ignorant users will not input letters into this field. Multiplication - I used the multiplication function in the sheet 'Find area' in cell E6. It will produce a more accurate calculation than a human would perform, and will automatically recalculate the area if the dimensions change. This saves time for the user as they don't have to repeatedly recalculate the dimensions. It makes it much easier to analyse different prices when you alter dimensions with spinners, whilst if you have to perform calculations ...read more.

Middle

Its purpose was to inform the user of what date it was. Therefore, they could realise if it was a public holiday and their order wouldn't process until the following working day. For example, if they ordered a window on a bank holiday, delivery would take 3 days to arrive instead of 2.This has also been outlined in our separate copy of the terms and conditions. If the user does not understand this, they may complain about late arrival. Also, the second use of including this function is to know when your order shall arrive. For example, if the user orders on the 18th and they need their window to arrive the next day, they will know the order 'Express delivery'. VLOOKUP - I used the VLOOKUP function in my sheet 'Order sheet' in cell D10. Its purpose was to collect prices of the individual window styles from the sheet 'Tutorial'. The advantage of this is that you can select styles of window frames, and it will automatically update the price. ...read more.

Conclusion

The purpose of this was to round the finished price. This was a method of validation as the user can quickly check the price without having to pay too much attention to detail. MAX - On the sheet 'Order Placed' in cell D16, I used the MAX function so that the user can quickly assess what was the maximum price for a product they purchased. For example, if a member sees that they spent over £2000 pounds on a product they can return to previous page and alter it. It ensures that the data is reasonable and sensible. MIN - On the sheet 'Order Placed' in cell D17, I used the MIN function so that the user can quickly assess what was the minimum price for a product they purchased. For example they can see what the minimum price is that they purchased. For example, if the cell D17, if it says the minimum price was £1, they'd realise that they accidentally selected the cheapest delivery method as this was the cheapest option on the whole system. Therefore they can return to the previous page and alter the delivery type. ?? ?? ?? ?? A/S ICT Unit 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Management & Manipulation of Information section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Management & Manipulation of Information essays

  1. Designing a booking system for an Estate Agent.

    I could create to make the booking system more efficient to use. The booking system will have a clear layout of the times and dates which the clients are booked for. It will also be organised according to the names of the client and negotiators, the company cars that will

  2. ICT coursework: Designing and implementing a book rental system

    The assistant in Stratford Library said that it would be a good idea because it will help you as well as the customers. He also said that it is very useful because you can add a lot of things, search very quickly, good for numbers and also he thinks that it will make it easier for the staff.

  1. Video World Database as ICT project.

    Price (3 Nights) Combo box- £2.00, £2.50 or £3.00 Currency Staff Attribute name Comments Data type and length Validation StaffID AutoNumber Unique Primary Key Surname Text(50) Firstname Text(50) Address Text (50) Town Text (50) DOB Date Phone Number Text(10) Customer Attribute name Comments Data type and length Validation CustomerID Automatically

  2. The problem that I have chosen to pursue is the Mail-order Company that sells ...

    The invoices will work by mail merge. * A database will have to be made that will hold customer details and orders. * An overdue letter will have to be made that will be sent by mail merge to customers that haven't paid their charges.

  1. I was hired by Mr Davies to create a website for a newly built ...

    * Text Hyperlinks to each page. Type in all pages names. Pick out the right layout. Have a navigation page on the website Contacts Page * Name of Nursery Enter nursery name Have a banner on the website * Logo Have the company's logo on the website.

  2. The purpose of this document is to provide a design for an electronic payment ...

    Implementing using this approach will allow more accurate time estimates and suitable allocation of tasks and makes the whole process easier to intellectually manage. The IEEE has a recommended practice for Software Design Descriptions (SDD) and this will be used as a guide when developing the software system.

  1. Planning a payroll system for a martial arts school.

    However, they are also involved in other services such as helping clients to live a healthier lifestyle and training other clients who want to learn and enhance their self-defence abilities. Tournaments and friendly fights are also organised by Ninja Freestyle in order to boost their reputation and increase their client's experience.

  2. Design An ICT System

    Input Required When a stock check is carried out within the shop, the staff will have to input all the details regarding the CDs they have in stock into their database. This would include inputting the CD title; artist name; CD price, number in stock; supplier name and the supplier number.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work