• 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

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

    4 star(s)

    A non ICT solution for the memo is that you could draw it out and where the macro fill-in fields are meant to be, you can in pencil write whatever the fill-in field is, for example "write name here". Then when you come back to the document to fill it

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

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

    Facebook essentially makes what seems to be a social network a 'stalker' network. Facebook makes it so easy to stalk someone. With just their name, you can find out their picture and if they accept you, they can find out even more.

  2. Financial Model to help organise the year eleven prom

    Furthermore I also done this on the raw data screen, either the choice of going back to the welcome screen or the user input screen. Why? I constructed this screen, to make the user's job easier. This is intended because it saves them working out the data in a mathematical way.


    Therefore, I have used the first name. I was going to use the roll number for students, as it is their unique identity, however, this will not be possible for my user to remember each number. After my user has tested my system, if she wants me to make any changes to this I will but for now I think first name is suitable.

  2. ICT and airport and supermarket

    EPOS constantly feeds back information to the store's main computer, so managers can know at any time how much has been sold and how much of a line they have in stock. * Pricing - all prices are input into the store's main computer, so individual items do not need price labels.

  1. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    Once we have the card we have to cross there details out of it either using a pen or tippex. Finally we put the card back into the game case and leave it on the trolley to be put back.

  2. Ict Powerpoint Coursework

    Also the PowerPoint would be easier to print off and save as it will contain less memory using this method. All the pictures could be used in later preference as they are backed up on an external hard drive.

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