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

My mum runs a cleaning business which is based in Lytham, she has many customers and produces her bills on card by hand. This is very slow and due to her busy schedule a waste of valuable time.

Extracts from this document...

Introduction

Page Number Topic 1 Front cover 2 Table of Contents 3 Identify 4 Analysis 5 Analysis continued... 6 Analysis continued... 7 Analysis - Data Flow Diagram 8 Analysis - Questionnaire 9 Design 10 Implementation 11 Evaluation My mum runs a cleaning business which is based in Lytham, she has many customers and produces her bills on card by hand. This is very slow and due to her busy schedule a waste of valuable time. Also hand writing bills can lead to mistakes which will affect her reputation. She wants to be able to produce her bills faster and at a more accurate level. She currently calculates the VAT by calculator which can lead to mistakes and sometimes she even forgets to add the VAT on at all. This is where I come in. I am going to devise a system that can do the bills for her customers on computer, this will be much faster than her current method and cheaper! To solve the problem I am going to use a spreadsheet package. I will go into which one at a later point but first I am going to address the advantages of using a computer. ...read more.

Middle

* Addresses * Telephone numbers * Job (full, half or spring clean) * Cost * Date * VAT * Total The data will be input into the fields by my end user although the fields such as VAT and Date will be automatically built into the system, the type of job will be on a drop down list to help make things easier. The costs of the jobs are shown below. 1. Full Clean - �75.00 2. Half Clean - �50.00 3. Spring Clean - �25.00 The processes I want in my system for my end user are the following things... * Rank, Count, auto sum, VLOOKUP, IF, use of macros, The user will enter the following into the system by hand... * Type of clean * Quantity * Customer name and information The system will automatically update the following... * VAT * Date * Total Cost The outputs I want my system to produce will be... * Bills - the bills need to be produced and duplicated by two, this will be built into the macro for print bills. Two will be produced, one for the customer and one for my mums records. ...read more.

Conclusion

My user feed back is shown below, as well as having an interview before the project started I had one after the system was finished. The results of which are shown below... Are you happy with the overall project, if not why? I am very happy with all parts except the colours are still slightly too jazzy and I wouldn't have minded if they were a little duller. Also, the macro buttons are very handy and easy to use although it would have helped if you could have made a macro button to print directly. Are there any other features you would have liked the system to have had? No, other than the macro button for printing the whole system created was excellent, thank you What are the positives from the system? Everything especially the pictures and style of text used. What would you mark the system out of ten? Probably an 8/10 because the print macro was missing and the colours were still too bright. Thank you for completing the questionnaire. Looking at my end users comments I think they are very helpful and I understand the users idea that a macro to print directly to the printer would have saved much time. If I were to do the project again I would definitely put this part into the project. 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 Computer Science 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 Computer Science essays

  1. Computing Project

    The user will then be able to search through a list of all the records within the Loans table and delete that record. The system will also allow the shop clerk/user to add new DVD's to the existing selection. This will be done by the user manually entering the description

  2. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    A wage type classifies personnel expenses according to tax, insurance, labour legislation, pay scales and other operational characteristics. In Payroll, wage types are also used for saving additional information in the payroll results, for example, in the form of cumulation wage types (total gross amount or gross tax amount), or

  1. System I designed in order to produce a promotion package for her newly formed ...

    For more guidance on any queries, click on help on the menu and click- on either Microsoft Access Help, Contents and index or Microsoft on the Web where you will receive expert on-line guidance. Troubleshooting guide for Microsoft Word I changed the fill, border, shadow, or 3-D effect, but when I create a drawing object, I get the old settings.

  2. Evalutation of a Spreadsheet

    * You have to pay for the software - Microsoft Office is fairly expensive software. * Data corruption - there is a risk that if a spreadsheet has not been backed up, the data could become corrupt and the spreadsheet could become unusable.

  1. Unit 6 - Advanced Spreadsheet Skills

    * Average sales per month * Maximum and minimum sales per box size * Monthly income per box size * Annual income * Profit and lose The spreadsheet will consist of the following worksheets: * Main Menu * Invoice page * Customer Details * Product Details * Order Details * Summary Page 7.

  2. Computing Project

    ways I can solve the problems of the current system, I think upgrading it so that every thing is based around a computer to save time. I think I will be using Visual Basic express to do this, as this is the program that will allow me to do more things.

  1. Ict Analysis

    What kind of storing system would you and your staff prefer? - I personally think the staff would prefer a data handling system on the computer as they will only have to learn it once and it would be really easy to use.

  2. You have been asked to create a database to handle various account combinations of ...

    Be able to be drawn on ordinary paper Models are a communication aid. If we present users with a model that fills the back of a roll of wallpaper then no matter how accurately it may represent the system

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