• 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
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  • Level: GCSE
  • Subject: ICT
  • Word count: 5818

Chessington Motor Centre (CMC) Information Technology System

Extracts from this document...


Project by: Graham Tilley Chessington Community College 2002 Table of Contents ANALYSIS 3 Introduction 3 The current system 3 The current problem 3 Objectives of the new system 3 Data flow diagram of the current system 3 System Boundries 3 Performance of the new system 3 Availability of software and hardware 3 Skill level of users 3 DESIGN 3 Software choice 3 Design of the worksheets 3 Entering of data and validation 3 Macros 3 Security 3 Test Strategy 3 Test Plan 3 Test Data 3 IMPLEMENTATION AND TESTING 3 Overview of System 3 Choice of project 3 Preliminary design choices 3 Commentary on testing 3 EVALUATION 3 USER MANUAL 3 Starting the system 3 Processing a transaction 3 Checking Stock and Prices 3 Exiting the system 3 TECHNICAL MANUAL 3 Changing the default password 3 Changing list of employees 3 Design of Worksheet 3 Macros used in system 3 ANALYSIS Introduction Chessington Motor Centre (CMC) is a small garage specialising in replacing and servicing Vauxhall motorcars. Drivers bring their cars to CMC and have the option of leaving their vehicle while the work is carried out or waiting at the centre, while the mechanics do the necessary work. Work at CMC progresses quite efficiently taking into account the facility only has space for three jobs to be done at once and a further three parking spaces for cars that have been left by owners needing repair. The car owners are then charged according to the parts used and the length of time spent by the mechanics carrying out the repair work. There are three methods of payment accepted by CMC including cash, cheque or most popular - by credit card. Copies of invoices are made allowing one to be kept for the financial records of CMC and another to be taken by the customer for their own records. In the case of credit card, an additional invoice is made as well as the credit card receipt. ...read more.


The cell below should display the correct name. 19 Enter Test Data 4 into Timesheet Sheet should correctly accept data Test Data The data below will be used in testing my system: Test Data 1 Invoice Number: 50 Date: 4th July 2002 Customer Name: Customer One Vehicle Registration Number: M345JWW Vehicle: Corsa Part Codes: cortir x 1, braflu x 1 Test Data 2 Invoice Number: 6352 Date: 26th September 2010 Customer Name: Customer Two Vehicle Registration Number: J523MMR Vehicle: Zafira Part Codes: zafwip x 5, zafhub x 4, zaftir x 4, braflu x 20, antfre x 25 Test Data 3 Invoice Number: 2 Date: 13th January 2003 Customer Name: Customer Three Vehicle Registration Number: A456D55 Vehicle: Astra Part Codes: asttir x 1 Test Data 4 Invoice Number: 50 Customer Name: Customer One Vehicle Registration Number: M345JWW Vehicle: Corsa Date: 4th July 2002 Start Time: 10:15 Finish Time: 10:29 Mechanic ID: cmcmec1 Mechanic Name: Andrew Edwards Type of job: Replacement IMPLEMENTATION AND TESTING Overview of System Sheet 1 - Main Menu This will be the first sheet seen by the user on accessing the system. Buttons link this sheet to the other parts of the system. The sheet will look like this: Sheet 2 - Invoice This sheet shows the user a blank invoice in the same format as the previously used paper ones. A "save" button will save the data, while the "main menu" button will take the user back to the main menu. The "Stock" button will take the user to the stock list if they need to look up a code for a particular part. The sheet will look like this: Sheet 3 - Timesheet This sheet shows the user a blank Timesheet like the Invoices, in the same format as the previously used paper ones. A "save" button will save the data, while the "main menu" button will take the user back to the main menu. ...read more.


* Amend the table accordingly * Re-protect the sheet. (See Changing the default password) Design of Worksheet If for any reason it becomes necessary to edit the formulas or the design of the system, the screenshots below indicate the formulae used and the names of each worksheet. Sheet 1 is called "Main Menu" and contains no formulae Sheet 2 is called "Invoice" and contains the following formulae: Sheet 3 is called "Timesheet" and contains the following formulae: Macros used in system The following Macros have been used in the implementation of the system: Sub auto_open() ' ' auto_open Macro ' Macro recorded 4/18/02 by G TILLEY ' Sheets("Main Menu").Select End Sub Sub exit_system() ' ' exit_system Macro ' Allows user to exit system giving them the option to save any data that has been entered ' ActiveWorkbook.Close ' End Sub Sub invoice() ' ' invoice Macro ' Takes user to a new invoice ready to be completed ' ' Sheets("Invoice").Select End Sub Sub timesheet() ' ' timesheet Macro ' Takes user to a new Timesheet to be completed ' ' Sheets("Timesheet").Select End Sub Sub stock_and_price_list() ' ' stock Macro ' Takes user to a list of stock available for use and sale ' ' Sheets("Stock and Price List").Select End Sub Sub main_menu() ' ' main_menu Macro ' Takes user user to the main menu ' ' Sheets("Main Menu").Select End Sub Sub save_invoice() ' ' save_invoice Macro ' Saves and prints data entered in Invoice ' ' Hide operations from the user Application.ScreenUpdating = False ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True Range("B10").Select Selection.Copy Sheets("Timesheet").Select Range("B6:D6").Select ActiveWindow.ScrollRow = 1 Range("B2").Select ActiveSheet.Paste Sheets("Invoice").Select Application.CutCopyMode = False Selection.ClearContents Range("B13:D13").Select Selection.Copy Sheets("Timesheet").Select ActiveSheet.Paste Sheets("invoice").Select Range("B15").Select Selection.Copy Sheets("Timesheet").Select Range("B8").Select ActiveSheet.Paste Range("B11").Select Selection.ClearContents Range("B13:D13").Select Selection.ClearContents Range("B14").Select Selection.ClearContents Range("B15:C15").Select Selection.ClearContents Range("B18:B22").Select Selection.ClearContents Range("D18:D22").Select Selection.ClearContents ActiveWindow.ScrollRow = 1 MsgBox ("Please complete Timesheet") End Sub Sub save_timesheet() ' ' save_timesheet Macro ' Prints one copy of a the Timesheet ' ' ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Range("B2").Select Selection.ClearContents Range("B6:D6").Select Selection.ClearContents Range("B7").Select Selection.ClearContents Range("B8:D8").Select Selection.ClearContents Range("B12").Select Selection.ClearContents Range("B13").Select Selection.ClearContents Range("B14").Select Selection.ClearContents Range("B15").Select Selection.ClearContents Range("B23").Select Selection.ClearContents Sheets("Main Menu").Select End Sub ?? ?? ?? ?? 1 ...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

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    All of these provide the incentive to switch from the out-dated ticket method to the modernised Oyster card system. What this does for the community is provides them with a much more efficient and cheaper system. An oyster card can be topped up to a maximum of �90.

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

    I can also video call people completely free using nothing more than a webcam and microphone. I can see how my family are doing over in Bangladesh and how my nephews and nieces are growing up, something that I usually would have no chance of seeing.


    Sheet 9-Parent Report This sheet will contain a letter template which will be sent to parent at the end of each term to tell the parent which grade their child has received, or if a student performance is very badly.

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

    1 1 8 1 0 0 0 Each digit in a binary decimal can only be 1 or 0. To convert from decimal x to binary: divide x by highest possible power of 2, then divide left over by highest possible power of 2, repeat until 1 or 0 is left.

  1. Database design.

    The screen will change to the required screen The screen was changed to the required screen Made more macros for the menus 2. Customer and Video table Can letters be typed into the telephone number field I will enter a letter into the field There will be an error message

  2. Business Requirement Analysis - On my paper, I will be discussing the analysis of ...

    With the sales of home appliances, it has become a very completive market with sales and reduce pricing on most to all appliance that anyone sales and a web presence is essential to have within this market. In today's market though, having just one centralized website will not due and

  1. Benefits of using my IT system in the Travel Agents.

    Using criteria's ([Enter], <>, Yes) * First, you should go on Microsoft Access. * Then, you should select on Queries. * After that, Right Click on a query that you've already created and click design view. * Finally, click on Criteria and type in [Enter your "ADDRESS"] etc.

  2. Computer project Alevels

    Double click on it. * You will see a Microsoft Access icon titled "Hospital System". Right click on it and select "Copy". * Go to the drive you want the system to be held in. Right click on the screen and select "Paste".

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