• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20

Creating an Information Technology System for Chin Bookmakers

Extracts from this document...


Creating an Information Technology System for Chin Bookmakers Analysis Introduction Chin Bookmakers is a small independent bookmakers situated on Eden Hill Road in Peterlee. They currently have a small manual credit account for giving credit, on bets, to customers. At present Chin Bookmakers have approximately thirty customers to whom they give credit. They would like to extend the number of customers they presently give credit to but the system they use is time consuming and prone to error. At present amount of credit given to customers has to be checked manually by employees. This means checking backlogs to ensure previous credit has been repaid. The bookmakers would like a computerised system that will allow them to check customers credit allowance quickly and ensure that the information is correct and kept up to date. Also they would like the system to produce charts and graphs to give an overview of credit given and credit repaid on a monthly basis. The Current System An employee of Chin Bookmakers was interviewed to ascertain the exact procedure for entering logs into the credit book. The following was recorded. The customer places a bet in the usual way and asks for the bet to put on his credit account. ...read more.


This will be the only workbook and will contain; * Menu * Customer Database * place bet and paying in sheets. Sheet1 - Menu This sheet will act as the front end and will be selected automatically using an Autoexec macro when the workbook is loaded. It will have 5 options as follows. CHIN BOOKMAKERS Ltd Sheet2 - Customer Database This is where all the customers will be kept on the system. It will include details about the customers and will laid out as follows. Information here will automatically be updated by other sheets in the work book. All cells will be protected to ensure information is not tampered with or so that cells and formulae are not accidentally erased.The sheet will be protected by a password known only to authorised employees. Sheet3 - Place Bet This sheet is required to debit a customers account. The customers account no. is placed in the space provided and their details are automatically displayed. All cells are locked apart from the account no. section and bet amount section which are the only cells from which data is inputted. There is one command button: 1. ...read more.


Initial Design Decisions My first decision was to create a large customer database to hold 100 customers. I asked Mr Chin about this and he said he wasn't sure how many customers he was planning to give credit to. I then decided to use an end of table line to add new rows as they were needed. I also decided to create an add new customer worksheet but thought it more convenient to scrap this and create a macro with the command button situated in the credit book work sheet. Final Design My final design is as shown in the design section, The adding of new customers is very simple with pop up boxes asking for all the information needed. It is a step by step process and any new user should be able to use it. Commentary on Testing Test 3 Test 4 Test 5 Test 6 Program successfully exited. Evaluation Looking back at the objectives and performance indicators the following have been achieved: 1. Trials showed that it took the user about 30 seconds to enter each new customer well within the 60 seconds allocated. 2. User Manual Introduction Installation Backups Adding a customer Placing a bet Paying in Exiting the Application Technical Manual Installing the System Macros ?? ?? ?? ?? 4 20 Michael Charlton Michael Charlton ...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. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    to become attached to their work, users do not develop performance expectations, and best of all, paper prototypes do not depend on the system being available. [GER00] Gerri Akers (2000), what is Prototyping, http://www.umsl.edu/~sauterv/analysis/prototyping/proto.html [BER09] Bernstein (2009), Importance of Software Prototyping, http://www.softpanorama.org/SE/software_prototyping.shtml [ONE10] One Stop Testing (2010), Advantages of Prototyping, Prototype model, http://www.onestoptesting.com/sdlc-models/prototype-model/advantages.asp Rapid Application Development (RAD)

  2. Computing Project

    The forms will not be cluttered and the layout of the buttons must be suitable so that there are spaces and blanks. Items must be placed in a logical way in order to make it easier for the user and to make it look nice.

  1. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    Accommodation Cost, 2. Transportation Cost, 3. Tax Rate, and 4. Food Cost. All this is relevant to the Indian employees who visit USA from India. There is no information available as to how the compensation review takes place for the US nationals in USA.

  2. Form and Function In Design Technology

    Fourth Generation Computers (1971 - present) After the integrated circuits, the only place to go was down - in size, that is. Large scale integration could fit hundreds of components onto one chip this led to very large scale integration in the 1980's allowing thousands of components to be fitted

  1. System I designed in order to produce a promotion package for her newly formed ...

    and the database would be updated, so that the order can be processed. Diagram of system model: Searches I will now produce a series of simple and complex searches to demonstrate what the system can do, with clear explanations. The complex searches will include two examples each of AND, OR and NOT.

  2. The Global Positioning System

    Say the receivers clock is running ?t fast (known as clock bias error). This means that from each pseudo transit time (the transit time with the clock bias error left in), ?t must be subtracted, as below However, ?t is unknown, along with X, Y and Z.

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

    I expect the top.html bar to work consistently and perfectly. Test Nine - Accessibility I am testing that the website is catered for people with impaired or bad vision. I am going to zoom in on the site and check that everything is correct and there is minimal distortion of the text and images.

  2. Explain the different techniques of gathering information to answer an IT Technical problem or ...

    This would mean that the IT Technical Support would be depend on the organisation as in Microsoft would have a big team whilst a charity like Oxfam would not. Company Culture This would depend on the employees. A company like Microsoft, Cisco and IBM would have a professional work culture

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