• 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
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  • Level: GCSE
  • Subject: ICT
  • Word count: 5202

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

Extracts from this document...

Introduction

By Shahaan Arshad 10/3 GCSE ICT Coursework Mr Graebar GCSE - ICT Coursework Description Of Problem The business that I will be studying is Rileys, Rileys is an American pool and snooker hall. Data collection is a problem in this business as there are hundreds of people who want to become member of Rileys and the problem is that the company at the moment are storing the member's information in a filing cabinet, which is not efficient and is hard to find individual records, the data cannot be accessed from other parts of the building or cannot be sent to the company headquarters for reference. Also it is not a safe place in the cabinet were the members personal information is held and easily be accessed by unauthorised users, and staff find it difficult to find individual records of people, for quick reference usage. This affects the customers by them not knowing that there personal information is in safe place to only be viewed by them and the staff, this also affects the workers/management on how to mange the files easily so that they can be found easily and no take a long time to be viewed. This leads to security problems in which if unauthorised people get hold of personal information of the members the people will then sell of the information to companies and advertisement, which will then lead a unsatisfied customer. Investigation & Analysis Of Problem And Specification Of Solution To find out as much as I can about how Rileys collects and stores information I decided to go and interview the manager about how she and her employees store and process the data of members - Shahaan - How do you collect your customer's personal information? Manager - Well we give our customer a membership forum if they decide to become members of a charge of �5.00 for students and �15.00 for adults, and they fill in a membership forum to give us there necessary personal information. ...read more.

Middle

This piece of software is used to design posters and individual leaflets mainly are used in journalism. I feel that this is the best solution as it is needed to produce offers and leaflets to put around the club notifying the members about upcoming tournaments, discounts and opening times. The features that I need is the desktop publishing features how it will be easy to use as it has a wizard to help guide what type of publishing you need to do. Microsoft's Windows xp professional is the world leading operating system and its essential to this business as it has the latest networking functionalities. It is the best solution as it is the world's latest operating system and is also has excellent function and options so the staff can adapt to the software with all user-friendly environments and functions. The main features are that its main features listed below: * Reliable * Secure * High performance * Easy to use * Advanced Networking Functionality I had considered using Windows xp home edition but I didn't as it did n to have as many features as professional, and it was no compatible with networking which is one of the main solutions needed to connect 3 computers together so they can all access all the same database. Internet access is needed so that Rileys can send and receive e-mails to their customers informing them about offers, updates and payment changes also it is good for the members so if they have any complaints they can contact the business easily via e-mail. I will be good to have Broadband internet as would be more faster to access information through the networking computers and sending and receiving e-mails. The hardware that the business will be requiring: * 6 Computers- basic specifications - Intel Pentium 3 / 4 - 1 GHZ + / - 200mhz - 20 GB Hardrive - 128 MB Memory - Networking Enabled - Windows XP Professional - Modem * Printer * Scanner * Web cam * Fax Machine The business will be requiring 6 computers of the specifications listed above. ...read more.

Conclusion

Amount Paid Numeric 4 Numbers The amount of money that the customer has paid for his/her membership (receipt) This is a money only field and only number can be entered so prevent entry there is a range to further reduce the chances of mistakes Membership type Multiple choice Tick 1 of 5 choices Tick 1 of 5 choices, and it is a must answer field It is a multiple choice field so you only have to mark one box it is very unlikely that a mistake will occur also it is a must answer field. Discount Membership Comments Text & Numeric Open Any comments about discounts that the club is offering to the individual and is an open field not a must answer field Mistakes may occur but it is not very important field Screen shots of the software need for the business - Output Format Screen shot of how the data will look on screen when a member of staff is using Pinpoint - The above way of the data laid out is good for this particular situation as all the information of all the customers is displayed on one worksheet and can easily be sorted and searched using the icons situated on the toolbar. Also it can be viewed in the view of the capulation form but that is more difficult as only one members information is laid out on one sheet and its is much harder to manually search and sort the data. The other screen shot is attached to this page is that is how the data will look individually for each members data on screen as a data capsulation form which is more easier to input data than as a spreadsheet screen. Reasons that the above screen shot is good for the staffs situation - * Everything is onscreen * East to understand * Simple instructions to edit database * Organised layout * All members' data displayed * All field displayed Other forms of data presentation are on the next pages of how data could look onscreen in a different format. ...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. Marked by a teacher

    Social Impacts and Threats of IT

    The Data Protection Act is a law passed in 1998 that requires companies that store personal information about people on their computers, to register with the Data Protection Registrar which obligates them to keep to the eight Data Protection Principles.

  2. Different types of technology How I use ICT at home and at school

    This also gives me a competitive nature but with more familiar people instead of strangers. This thus also gives it a social aspect and a chance to build relationships and friendships. The camera of the DSi brings a whole view of things it can do.

  1. I will be analysing the problems defined by the management in the old system ...

    * A report which lists all the repairs by the technicians' names. * A report which lists all the repairs by collection date. In addition to this I will be using MS Word for mail merging so that the secretary's problem of sending mail to the suppliers is handled.

  2. Design and Produce a Monthly Account System For the Hazeldene Sub-Aqua Club.

    Anyone in this age group who have not had a medical check up since 1997 has an outstanding medical inspection. The last age group, 51 and over, are the members that were born on 1 April 1949 and before. Those that have not had a medical inspection since 1999 have overdue medical inspections.

  1. Introduction to information skills and system. An information system is a system that accepts ...

    Common file type: excel, word document Images - An image is an electronic copy of a picture, photo, scanned document etc for display on screen.

  2. Ict coursework full

    Note that the receipt page is also quite lengthy, so I have a screenshot of the important part. Tests Test # Purpose Expected result Actual result 1 Test hyperlinks Pass Pass 2 Test IF statements Pass Pass 3 Test LOOKUP functions Pass Pass 4 Test data validation Pass Pass 5

  1. GCSE ICT Coursework Booklet

    adults and teenagers] including hyperlinks and on-line ordering 4. DTP a catalogue, advertisement or stationery for mail-order purposes. Brief, Analysis and Research 1. For the DATABASE The database is for keeping records of customer contact details, purchase history and interests.

  2. Camelot Restaurant Bookings System - computer system design

    So I created a macro to stop this, it is shown in the commentary on Testing. In B9 the formula: "=IF(SUM(I71:J71)>150,"Overbooked-Too many People in between 12:00 and 14:00"," ")" This was for the validation rule that guests over 150 in two hours means the restaurant is too full, there are

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