• 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

    hospital every day and the system uses all of this data about the staff and it uses it to work out their salary at the end of each month and the system also creates a payslip for each of the staff members in the hospital.

  2. drum kit costing system

    splash � 65.65 Zildjian Avedis 14" Thin crash � 104.00 Zildjian Avedis 16" Medium thin crash � 126.75 Zildjian Avedis 18" Vintage crash � 207.35 Zildjian A Custom 14" crash � 118.95 Zildjian A Custom 20" Sizzle ride � 187.85 Paiste 2002 20 inch ride � 172.50 Paiste Signature 10

  1. Main aims and functions of Buckingham Bingo.

    The complaints may come from customers or employees, but no matter what they have to deal with them. * In the bingo a big LINK game is played and a big NATIONAL is played. If one of the customers are luckily to win it they have to come to the office to claim there money.

  2. Creating an IT system for Rileys an American pool and snooker hall.

    Shahaan - What personal information did Rileys ask you in their membership forum? Customer - They asked me basically my name, age, address, home phone number, E-mail address, County, Town, Mobile number, my occupation And work phone number, I had to also bring proof of address Shahaan - How is this personal information used?

  1. Adam Property Maintenance - System analysis.

    does have access to the WAN (Wide Area Network) and is connected to two printers and some fax machines. Firstly the existing system is in two parts as mentioned above; the manual part of the system is the writing of client's maintenance job from a phone call or fax and gathering information from the client records file, the client

  2. Create an IT system for my karate club.

    and this form is an application form for their karate licence. Everyone needs a karate licence in order to do karate at this club. It simply gives them permission to use karate as a means of self-defence in a dangerous situation.

  1. Develop a spreadsheet application for the Ibis Hotel.

    The records cant be erased or added easily and often these reports have to be re-written which is very difficult and also takes a lot of time. It also increases the cost. * Quality of letter (as typewriter is being used)

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

    Evidence: Question 4 from interview: How is it processed? Manually * The system is not accurate or very reliable. Evidence: Question 13 from interview: How reliable and accurate is the data? Not very accurate as tubs of ice cream may have been put in the wrong box, boxes may be counted twice or not counted at all.

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