• 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

    I can also find groups of people with different tastes, thus expanding my own knowledge, culture and myself. Among the various MSN features and activities, emote assistance is one of, if not the best, one of the most useful features out there.

  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

    She doesn't need anything and this pleases her. This adds to the relaxation she receives from this leisure activity. She can just rely on her own eyes and nothing else. The remote for the television is also simple enough for Sarah to use. However, if Sarah is having problems pressing the numbers to get to the channel, she

  1. ICT - revision notes.

    program consists of a sequence of instructions; program/instructions stored in main memory; and can be replaced by another program at any time; instructions are fetched ; instructions are decoded ; Instructions are executed * What is dial-up networking? only connected when in use/when Internet required/non-permanent connection / need to re-connect

  2. System requirements analysis

    Below is a screen shot that shows the patients records: The software allows you to view different aspects of the patients' details. The doctor can search for a patient by typing in their surname or their first name. Having a small search engine like this would save the doctor a

  1. GCSE ICT Coursework Booklet

    It would be to advertise the shop and help bring a wider range of ages. A website would also be created to attract younger people. The layout of the shop will mean three computers will be needed. One in the manager's office, one by the till and one in the storeroom to keep control of stock.

  2. Database design.

    Creating a macro To create a macro you go to macros and this window will open up. It is blank now but when you fill in the actions you want the macro to carry out it will be complete. As you can see I want my macro to open a

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