• 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

    * know about programming software, which you can use to produce your program Few large programs are new and original creations. Most are developed from existing programs or by combining existing routines and sub programs. For this unit you will learn about two particular purposes of programming.

  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.

    After the scores are input into the spreadsheet, the spreadsheet will automatically create graphs and tables to show progress and comparisons and analysis of the scores, for the coach to use and convey to his captain in order to change his tactics to benefit his team.

  1. Introduction to spreadsheets

    type in how many you have and then on row D you type in the price. Row E is a logic formula which says =if(G4="yes",D4/3,"Not on Offer") this means if G4 equals YES then D4 will be divided by 3 other wise it will say that it is not on offer.

  2. 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)

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

    disk, and second a command in the program that assigns a certain variable to the record structure, and the file on the local disk. To do this I will do the following: In the global variables I used a variable called - stock_file : file of stock; This will make

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

    or a new home base is a city for example but overall I feel that a website would be perfect as well as cost effective. A website can offer a range of things, firstly a quick ordering system that almost everyone can access from home; on top of that there will be a constant string of advertisement for the business.

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