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

ICT Project: Identification procedures

Extracts from this document...


Identification The Problem The On-Site Computer Service is a company that runs a mobile computer repair service. Recently, the management has noticed that expenditure is rising above the limits set. This seems to be because the employees are buying things they think are needed, without checking with the management first. For this reason, they want some method of keeping an eye on any money that is spent by the employees. Solving the Problem After thinking about possible solutions, I have come to the conclusion that there is only one way to solve this problem. A system needs to be created that will record all of the money spent by employees, and also tell them how much is left. The users of the system will be the employees of the company (in order to enter their expenditure into the system and see how much they have left), and the management (will use it to view the entered information). ...read more.


Getting employees to show their spending etc. in a summary, which must be continually updated. Also, to make a summary of the whole department's spending. 4. Getting an employee to create an overall summary of the spending of the entire company. This could be done, but it would take a very long time, as every time new information is added the whole lot must be modified manually. This would take up a lot of time and effort, and would discourage the employees from filling it out properly. It would also mean that it is more likely that the employees will make errors when they are calculating the data, as they have to calculate a lot of data. It may also mean that employees forget about using the system altogether due to the effort and time consummation. For these reasons, I feel that the manual solution is not a very feasible solution. PC Solution: Within the PC solution, there are different software solutions available for me to use. ...read more.


It can also be used to create a summary of all the data in a table or spreadsheet. This means that it will save more of the employees' time. Finally, when a formula is inputted, it will automatically update any summaries whenever the data is changed. Overall, this leads me to conclude that Microsoft Excel is the best program to use in my solution. I have decided to use the PC solution to create my system. Within this, I will use the program, Microsoft Excel, as I can use it to create spreadsheets that will save time and effort for the employees. It will perform calculations automatically, update summaries and show employees how much they have left to spend. By the end of this project, I plan to fill these criteria: * The spreadsheet will show all employees how much they have spent, and how much they have left to spend. * The spreadsheet will show a summary for each employee, each department, and an overall summary. * The spreadsheet will have a warning message for when an employee and/or department overspends. Billy Murphy 11B Page 1 Mrs Wyatt ...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

    must be able to register and update customers details with the shop and should give them a unique membership ID in the process which can be used by the rental shop to identify the member * The system must be able to add new DVD's to the existing catalogue and

  2. Hardware and software ICT revision notes

    Deciding to produce your own program is a big step. Programming can be very complex and time-consuming. Before starting to produce a program you must: * know what you want to achieve * be sure that it is not already available at reasonable cost (as an 'off the shelf' program)

  1. Computing Project

    The instructor want something that he can have transaction done on, ideally a database that will do transactions, that include calculate a cost, update availability for next lesson and update the file with student lesson. The instructor would be very grateful if we were to include something that will show

  2. Ilford Cricket Team Data Analysis Project.

    I will be able to insert formulas into my spreadsheet, which will do all the calculations for me and therefore will leave me with no mistakes in calculations. Also MS Excel will create all graphs and outputs to forecast the game for me leaving me with no need to employ skilled workers whom know how to make graphs.

  1. Security Project

    Give reasons for each of your choices. The four most necessary security measures I think Peter Evans should choose to install are as follows: - > To ensure that the whole building is secure and has an intruder alarm system and if necessary a closed circuit television system (CCTV)

  2. Introduction to spreadsheets

    TextBox2.WordWrap = True End Sub Checkouts What I used on the checkout sheets? * VB code * Tick boxes * Command Buttons * Textboxes On the checkout sheet I have not used any Marcos because I did not need them but I have used VB code, I have used it on the send button and on the text box.

  1. White Soul System Designs - creating a computer system.

    15" Colour CRT Monitor Reason: To be display the chosen program. 3. Printer, possibly colour with 600dpi resolution of better Reason: To print out forms or other things needed on the system. * Software Needed 1. Operation system - MSDOS or Windows Reason: This software is needed to run the program 2.

  2. AS ICT Corsework - Mr Brookes K-Fit Ltd

    in the ordering and decision for product * Ability to view products from home * A good system to track orders Investigation I have interviewed my client to find out what exactly it is he wants for his ICT system to aid his company (see appendix 1).

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