• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month
Page
1. 1
1
2. 2
2
3. 3
3
4. 4
4
5. 5
5
6. 6
6
7. 7
7
8. 8
8
9. 9
9
10. 10
10
11. 11
11

# 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

# Related AS and A Level Computer Science essays

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

in the form of wage types for other important amounts (statutory net pay or transfer amount). The organizational assignments valid for all periods are also created within Payroll as well as special cost assignments, and the wage types are assigned to this information.

2. ## Computing Project

The shop clerk will then go into the stock room and obtain that DVD and give it to the customer he will then create a record in the 'Loans table' which will contain the member ID, Copy Number, the date borrowed, the return date and the rental cost.

1. ## Smart Card System

database statements and return the results to the client. This distribution of processing reduces network traffic and improves performance. Site autonomy can also be increased by limiting database modifications to locally executing applications. Remote Procedure Call (RPC). The Remote Procedure Call (RPC) is a mechanism that allows programs to communicate with each other.

2. ## With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

by means of a circuit called a demultiplexer, and routed to the proper end users. A two-way communications circuit requires a multiplexer/demultiplexer at each end of the long-distance, high-bandwidth cable. When FDM is used in a communications network, each input signal is sent and received at maximum speed at all times.

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

Microsoft Word is mainly to do with typing text and can't produce a table like the ones in Microsoft Access. However, Microsoft Access and the Internet were very useful to me. Access helped me quite a lot because the program has wizards, which helped me create the structures.

2. ## Computing Project

Price per lesson Number, Decimal (5,2) �19.00 How much the student pays for each lesson Date and time of next lesson Text/ Number 11/11/07.13.00 The next lesson student has booked. AVAILABILITY DETAILS Instructor Field name Type, Max range Example Description AvailableSlots Date/time, Variable Friday 01/02/08 13:00 A day, date and

1. ## Ilford Cricket Team Data Analysis Project.

A copy of the answered questionnaire can be seen in the appendix. Identification of the prospective user (s), and identification of user's needs and acceptable limitations (using appropriate methods - summarised as necessary) The prospective user of the system will be the team captain and the coach, the coach will

2. ## Evalutation of a Spreadsheet

* Calculations are done quickly - after telling Excel which type of calculation a user would like to perform, the calculation is done instantly. If done by hand, it would be a lot more time consuming. * Versatility and portability - once a spreadsheet has been saved it can be duplicated and sent to other people instantly.

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