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

Overview of a new system

Extracts from this document...

Introduction

Choice of Software The software I have chosen to implement the new system is excel. I have chosen spreadsheets excel because of it ability: * To enter a number, formula or text into any cell * For formulae and other data can be copied into groups of cells. * To create macros, which are a series of command crated by the user that the spreadsheet would perform automatically. * To protect worksheets so users cannot accidentally destroy formulae or headings. * To customise menus and toolbars * To format so it is clear to the user where to enter data. System overview The new system would work in two ways the first way is as templates. ...read more.

Middle

Monday, Tuesday etc, names and signing in/out. These labels will be placed at the head of its column. The type of data I would be entering would be mainly numbers. The new system will use simple formulae involved with the process of add and subtracting numbers. The new system will also involve formulae's with more complicated functions like the, IF function and the average function. IF (logical_test, value_if_true, value_if_false) an example of an IF function would be if a number exceeds 60 then the statement will read false, if it is less than 60 the statement will read true. The new system will also be formatted to make it easier for the user. An example of one of the formats the new system would have would be conditional formatting. ...read more.

Conclusion

duties button, add duties data then print out duties sheet * Test briefing time button * Test work performs button * Test validation cells * Test conditional format cells * Test IF functions Test data and expected outcome Signing sheet Morning Afternoon Evening Names In Out In Out In Out Mark 1 1 1 Gary 0 1 0 Sue 1 0 0 Duties sheet Names 8:00am 9:00am 10:00am Break 12:00 Pm 13:00 Pm 14:00 Pm Lunch 16:00 Pm Mark Stock Serve Serve / Chillier Chillier Serve // Serve Gary Stock Serve Serve / Chillier Chillier Serve // Serve Sue Stock Serve Serve / Stock Stock Stock // Serve Performance No.s Outcomes Names Monday Tuesday Etc Total Mark 5 1 6 Average performance Gary 3 4 7 Average performance Sue 7 8 15 Good performance ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. System requirements analysis

    2. easier to understand 3. less time consuming 4. contacting the surgery: a. phone b. email c. physically visiting centre 5. minimal typing 6. data stored at centre point (hardrive/network drive) 7. space (large storage capacity) Limitations to user-draw backs(ur software) 1. LED screens not displayed 2. emails not activated 3.

  2. Create an IT system for my karate club.

    Also input masks add conformity e.g. some people may like to type in phone numbers without the area code and some may add the area code, if you put on an input mask they have to type in say the area code otherwise an error message appears.

  1. drum kit costing system

    Observation I went to Drum Gurus to see for myself how the old system works. As I suspected, the system performed poorly and was slow at loading prices. They recently set up a website which is an improvement on the manual system he used to use, but it is still not sufficient.

  2. Main aims and functions of Buckingham Bingo.

    They then count the money and work out wether the bingo has made money or lost money. The profits/loses are then logged into a record book which can then be used for statistics etc. This information is then passed onto the main office and they then try and figure out

  1. Adam Property Maintenance - System analysis.

    The computers in the network share all the data on all the hard disc storage devices, all programs and all files on the network can be shared. The LAN (Local Area Network) does have access to the WAN (Wide Area Network)

  2. Develop a spreadsheet application for the Ibis Hotel.

    * Finding files can be very problematical. * Many files can also be lost or misplaced. * Validation is also a problem. This is because to check many files manually is very difficult. * Security is not very obtainable. * Whilst editing any problems it can be very hard to rearrange any disorders, as the whole page will have to be re-written.

  1. Analysis of stock ordering for Henley Ice cream Parlour.

    * It is difficult to make comparisons of ice cream sales over a specified period of time. Evidence: Question 14 from interview: Is the information presented clearly so that it can be understood? No, there is not enough lines on the page on which the information is recorded so is easily misinterpreted.

  2. A New System For an Estate Agent

    range is made, many houses cannot be made available because the current price hasn't been updated and the latest price may be out of range. The company is losing a lot of business because it takes a long time to find the right properties for the buyers, the company also

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