• 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)

    The company needs to get faster computers so the employers can do whatever they are doing faster and quickly move on to another task as they are paid by the hour and not for how much they do. End User Requirements Letter * George Mulalay wants a very good designed letter to be created.

  2. ICT notes

    Ensure workstations meet the required standards for health and safety i.e. provide proper computer chairs, foot supports, lighting etc. 2. Plan work so the staff have regular breaks which allow them to do non-computer work. 3. Pay for regular eyesight tests for staff using computers regularly.

  1. ICT - revision notes.

    by a library program program files which are used by other/many applications * Explain one difference between a procedure and a function functions always return some value when called; procedures may return a value * Name and describe a built-in function you have used in your programming work, or when using a generic software package.

  2. a level ict project

    will provide quick data entry through which employees can use to enter information about the cars, their problems, customer details, etc. The new system will be designed to allow Victor to easily search the database and retrieve information within seconds.

  1. Tennis Tournament UNIT 1 GCSE ICT coursework

    It's also good at searching and sorting through data. Chosen method of solution: I have chosen to use a generic application which is an Excel spreadsheet. Software Type Choice: A spreadsheet includes the following features which make it suitable in solving my problem: 1).

  2. System requirements analysis

    as the patient may not be in a state in which they can be contacted. Medics On-call(tm) - Mobile PalmPilot(tm) Access As you can see, the company also allows the doctor to view the system with a PalmPilot. The doctor can be on his/her way to the health centre and they are able to see what forthcoming appointments they have.

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

    It is also quite slow going up Sarah's long stairs. While this can be seen as an advantage due to the safety it provides, Sarah views it as a time waste as she is impatient and very conscious of the time she wastes every time she goes up and down the stairs.

  2. 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.

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