• 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
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  46. 46
  47. 47
  48. 48
  49. 49
  50. 50
  51. 51
  52. 52
  • Level: GCSE
  • Subject: ICT
  • Word count: 9560

Develop a spreadsheet application for the Ibis Hotel.

Extracts from this document...


Identify Objective The objective of the coursework is to develop a spreadsheet application for the Ibis Hotel. In the coursework I will discuss four main steps of software development- Identify, Analysis, Design and Implementation & Testing. Using the application software, the hotel can manage its staff and business efficiently and effectively. The objective of the coursework is to produce computerised business letter (using mail merge and other features instead of using a type writer). This is being done so that Ibis Hotel can publish their good works into the open environment and have more people visiting the hotel. This has been done so that the staff at Ibis Hotel will become more relaxed with their work. I will also create labels for the staff so that the hotel can use it for different purposes. E.g. used at the back on envelopes to give a sophisticated look. The two objectives of the coursework are - understanding of the software development and to use varieties of tools and techniques to meet the client requirements. Introduction Ibis hotel is a two star hotel in Stratford, and has 55 bedrooms, all with bathrooms and toilets. I am going to carry out my coursework assignment on the improvement on the computerisation of the hotel by using Information Technology. The hotel is dependant on a great deal on manual administrative work. I have checked with the hotel and asked if I could computerise the old manual system and improve the popularity of the hotel by using Information Technology. This problem is ideally suited to ICT, because a computer is very good for both formatting and typing in text and also for creating eye catching colourful graphics. Ibis hotel is a two star hotel situated in Stratford. Ibis hotel is one of the three other two star hotels in Stratford. Thus, it is a very busy hotel. It contains of 55 bedrooms with bathrooms and toilets, some have attached balconies, which cost a higher rate to the ordinary bedrooms. ...read more.


Information can also be added to these printed labels. The whole process does not have to e taken into consideration again if any of the points have to be done. By going to 'label options' any of the three (add, edit or delete) can be done very easily and is not time consuming at all. I have shown on the next few pages how to add or edit a new set of data into the database, so if any changes do occur in the future then it can easily be changed: At first the database that I have previously made on Ibis Hotel is opened. Now the file that the data has to be changed in will be selected. For instance if the data had to be changed and the data was present in the 'Staff Table' I shall select the file. Say for instance that I wanted to change employees number 7's name and full details as the employee is now not working in Ibis Hotel anymore. I shall edit the row and retype the replacement employee. I shave shown this below: This was the old database that has to be edited: Now I shave shown the edited database below: It can be seen that the Starting date at Ibis Hotel has changed. The database is then saved and this data will automatically be used in the mail merged word-processed documents. On the next few pages are the print outputs after the mail merge was used. First few pages are the personalised letters and the next are the printed address labels: IBIS HOTEL Northern Way Stratford London E15 4NQ 34, Forest Way Chingford London 02/05/2007 Dear Mrs Charlotte Gartley It has been a long period of time since you last stopped over at Ibis Hotel. Throughout you last sojourn, we have taken this precious time into consideration and have had a prospect to enhance the Ibis Hotel. ...read more.


Now these mail-merged letters will be sent to previous visitors that had stayed in Ibis Hotel form Mr Singh, so that they would come and visit they hotel again and enjoy the new services that are provided. The created mail merged address labels are also very handy, and are for the manager of Ibis Hotel to stick on the envelopes in which the letters are to be sent. Microsoft word was a very easy and superlative program to use and especially it helped me a lot in this task. Mail merge that is found in MS Word was a very straightforward and appropriate program. Mail merge helped me send a standard letter to a number of people on the mailing list. The staff at Ibis Hotel now are very familiar the mail merge and is used at all times whenever a standard letter has to be send to a number of people. The system saves time and is a very fast program that produces multiple copies with a template and data that could vary, depending on what type of standard letter it is. Mail merge, the process of producing a personalised letter by merging (putting together) the recipient's personal details stored on the mailing list or the business's database into the standard letter, is a very efficient contrivance and is not time consuming at all. It can get time consuming when the cutting and pasting procedure had to be taken into consideration and when the varying data has to be typed out again and again, this can get too time consuming. However, now Ibis Hotel can create many standard letters and the employee's there find it very easy to use. I have learned how to use mail merge more economically and how to use it in a real business position. My teacher and my GCSE textbook has also given me new techniques to use whistle using MSWord. The mail thing I have learnt is how to link a database to a mail merge. This is a very important factor that is to be known in any business. ...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

    Evaluation of my ICT Database, Spreadsheet and Newsletter

    3 star(s)

    I have used all the data entry types that I think fit this task. Validation I used a range check on my Number of People, Reference Number, etc. To make sure that only a certain number can be entered. Forms My colour scheme for my database is colourful, but not too bright.

  2. The Advantages of Using ICT Over Manual Meethods. Using Paint and Access.

    This is how you use criteria. Creating Forms First click on forms. Then create the forms by 'using the wizard'. Click on the double arrow to move the entire 'Available Fields' to the 'Selected fields' section. Click Next. Select Justified, then Next again. Select the International Design.

  1. a level ict project

    amount charged to the customer: * Macro Action is to be OpenQuery * The query name to select is Amount charged * The view should be set as Design * The data mode shall be set as Edit Macro design to ask the database to calculate the commission amount for

  2. Tennis Tournament UNIT 1 GCSE ICT coursework

    These can change all the time, so in my case the profit and loss and players and mark up. The comments will help the user enter around the right values. Below you can see this and how I did it.

  1. Analysis Spreadsheet Coursework

    Disadvantages of doing this: * The data could still be lost or destroyed * The data could still take up to 5 minutes to find * The data will still take up the same amount of room * The data could get messy again if the files are not kept

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

    She can use the pointer to scroll along keys and click on her desired key much more easily. Disadvantages (How it does not meet Sarah's needs) But it can be quite slow. Compared to a non-disabled person, the WPM count isn't at a particularly good rate.

  1. Ict Unit 2b

    Its advent was brought about by the progressive miniaturization of integrated circuits and by advances in semiconductor technology. You need a microprocessor in Whipps Cross Hospital computer to hand in all the data that they deal with. Storage > Servers; In computing, a server is A computer software application that carries out some task (i.e.

  2. ICT car insurance quotation System Coursework

    To access my system online the end user will have to have web browser, modem or wireless router. Fortunately the dealers have a modem connection and have a moderately powerful desktop computer, so will have the benefit of using Excel if the system needs to be remodernised or altered.

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