• 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
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  • Level: GCSE
  • Subject: ICT
  • Word count: 9080

ICT Job Applications - Enricé's Tapas Bar.

Extracts from this document...

Introduction

AS ICT Coursework Project ICT3 Job Applications - Enric�'s Tapas Bar By Martin Yau Exam No 6079 Barton Peveril College Centre No 58231 Contents Contents 2 Specification 3 Introduction 3 Current system in detail 3 Statement of problem 3 User requirements 3 Users IT skill level 4 Input 4 Processing 6 Output 7 Software Selection 7 Design 8 System Map 8 Timetable Design 12 Total Wage Table Design 12 Letter design 13 On all of the letters 13 Interview 13 Success 13 Menu design 14 Letter Templates 14 Welcome to Enric�'s Tapas Bar 14 Enric�'s Tapas Bar Application Form 14 Enric�'s Tapas Bar Interview Notes 14 Macro design 15 Test Plan 18 Implementation 21 Test Plan 23 User Guide 31 Evaluation 32 About the User Requirements 32 Accuracy of the system 33 Changes to the original system 34 Users Comment and Results about the System 34 Improvements to the System 35 Specification Introduction Enric� is the manager of Enric�'s Tapas Bar. The local business is successful. The staff turnover per annum in his business is high because Enric� does not pay very high wages. Current system in detail If anyone is interested about getting a job at of Enric�'s Tapas Bar are given an application form. The applicants either fill in the paper copy, or enter their details on the office computer. The applications are sorted by job application and then sorted by application date. Then these are stored in a filing cabinet. When a vacancy becomes available, he gets the most recent applications and writes a letter to them, depending on the job type. Successful applicants are sent a letter stating start date and time. Unsuccessful applicants are sent a letter, thanking them for interest in the job they have applied for. This process is time consuming and inefficient. Statement of problem I need to set up a system for Enric�'s Tapas Bar which deals with application forms filled in by anyone who is interested for Enric�'s Tapas Bar. ...read more.

Middle

o Date of Interview o Start Date o Start Time o Working Hours per Week o Hourly Wage * Input mask for the following fields: o Post Code o Phone Number Home o Phone Number Work or Mobile o Date of Birth o National Insurance Number o Date of Application o Date of Interview o Start Date o Start Time * Password protection in the following files: o Enric�'s Tapas Bar - Interview letter o Enric�'s Tapas Bar - Success Letter o Enric�'s Tapas Bar - Rejection Letter o Enric�'s Tapas Bar - Lifeline Letter o Enric�'s Tapas Bar - Application Form o Enric�'s Tapas Bar - Interview Notes o 'Welcome to Enric�'s Tapas Bar' (Front End) * Macros: o In letter, job application form and front end templates: * Automation: * AutoOpen * AutoClose * Query set (Selecting Job Position): * Assistant Chef * Master Chef * Bar Staff * Bouncer * Washer-up * Cleaner * Waiter(ess) * Mail merge * Previous record * Next record * Show Fields and Values * Print Form/Interview Notes (In Enric�'s Tapas Bar - Application Form and Interview Notes Only) * Open Files: * Interview Letter * Absolute Success Letter * Absolute Rejection Letter * Lifeline Letter * Job Application Form * Interview Notes o In Enric�'s Tapas Bar Database * Autoexec * Data Source * Enric�'s Tapas Bar Parameter Query * Enric�'s Tapas Bar Timetable * Enric�'s Tapas Bar Total Wage * Data Source Form * Save Record (In Data Source Form only) * Calculating total wage in MS Access in Total field (only in Enric�'s Tapas Bar Total Wage query) These features are included because in order for the system to be robust, users cannot delete, alter or modify data, letter templates and job application form templates, as these are password protected. Only Enric� has the authority to perform any changes of the system. They cannot input the wrong type of data into the wrong fields in the data source and the input masks help the users to enter the right type of data into the right field. ...read more.

Conclusion

Creating the query table for the purpose in MS Access has solved the problem. Users Comment and Results about the System The pie chart on the right enforces the fact that the system is very easy to use. This is because of clear symbols to inform them which file is which, message boxes to inform the user the file is opened or closed and to inform them that they have executed a particular action. The user comments below suggest this: User A - 'Clear symbols and easy to understand.' User B - 'Clear symbols, not much that you can press to go wrong.' User C - 'Clear information and very detailed.' User D - 'Clear and easy to understand.' The users' comments above and the pie chart on the right suggest that the user guide about the system is easy to understand and use. This is because the user guide contains comprehensive information about how to use the function of the system, what the outputs should look like on screen and paper and trouble shooting information in case the system goes wrong for the user. 30% of the users of the system suggested an improvement to the system; toolbars should stay closed when a file has closed. This is because the letter templates could be vulnerable to alteration or modification. This problem could be solved by modifying Auto Close macros in the following files, to ensure that the toolbars stay closed in the front end; Absolute Rejection Letter, Absolute Success Letter, Interview Letter, Lifeline Letter, Job Application Form and Interview Notes. Improvements to the System The system could be improved by protecting the letter templates and the database completely by using VBA and password protecting the PC, since the system is designed to be used on a stand alone PC. The limitations of the system are the system can be altered by a determined hacker, no matter how well the system is protected in any way. 1 AS Coursework (ICT3) - Word Processing Project 1 Martin Yau - Candidate Number: 6079 ...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

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    We have a lot of documents to look after in our company and that means that if we are looking for a certain document it will be hard to find as our organisation is not very good. Sometimes staff have very messy hand writing and they write a memo on a piece of paper for other staff to read.

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

    Remote assistance takes interactivity to a new level and lets you take control of another's PC. For when a person is too illiterate to follow instructions or general help, remote assistance is perfect. Its main purpose is to help other people with help on their computers.

  1. ICT notes

    Health and Safety Issues Relating to Computer Use The health centre must ensure under the Health and Safety Regulations 1992 that they provide a safe working environment for anyone using computers. The health centre must :Ensure that the computer equipment is safe.

  2. The impact of ICT on a person with special/particular needs

    and straining for Sarah's wheelchair to go unto the stair lift all the time, something which is inevitable as she has to go up and down a lot * It also takes quite a bit of time go up and down, which Sarah finds annoying and damaging to her self-esteem

  1. Tennis Tournament UNIT 1 GCSE ICT coursework

    If the system then goes wrong it would be very expensive to get the program fixed. Also required updates would cost a lot of money. b) Using generic applications software: The applications available to me are; * Spreadsheets * Databases * Word processors * Desk top publisher * Presentation software

  2. ICT - revision notes.

    Intranet Network providing Internet facilities within an organisation/ LAN using Internet protocol; (1 mark) (b) Give an example of: * a domain name; any valid domain name, e.g. aqa.ac.uk; R www.aqa.ac.uk * (ii) an IP address. any valid address in the range 0.0.0.0 to 255.255.255.255 * Explain what is meant

  1. task2-report-template 3

    To allow software to communicate with the hardware. 2.3.3 Reasons for Choice of Hardware and Software [4] Hardware and software that being chosen Comparing with alternative software and hardware Laser printer I chose to use a laser printer instead of dot matrix printer because laser printers produce fast, high-quality print copies.

  2. System requirements analysis

    * Patient and insurance company balances displayed in every patient-related view * Budget billing plan specific to the individual patient * Custom fields available for user-defined information * Automatic computation of all managed care data * Easy viewing of managed care issues such as capitation, referral tracking, copayments, number of

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