• 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. Financial Model to help organise the year eleven prom

    I limited this to 2 decimal places as I thought it was appropriate. Welcome screen I came up the idea of a welcome screen so the committee had a choice of what sheet they wanted to go to, whether it was the "user input" sheet to work out the price

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

    It gives me the opportunity to have contact with people I usually wouldn't. Facebook has often been criticised as a place where privacy is too easy to be broken. However, I can limit what exactly Facebook can show of mine to my friends using the privacy options and thus stopping people from seeing things I don't want them to see.


    Sheets("Pivot A").Select ' sort out pivot to add accurate fields to pivot Range("A4").Select ActiveSheet.PivotTables("PivotTable1").AddFields RowFields:="First" Range("A13").Select PivotItems("(blank)").Visible = False ' Select Chart Sheet Sheets("Chart1").Select 'Add Titles to chart ActiveChart.ChartTitle.Select ActiveChart.PlotArea.Select With ActiveChart .HasTitle = True .ChartTitle.Characters.Text = "Average Mark, By Student" 'Edit X axis .Axes(xlCategory, xlPrimary).HasTitle = True .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text

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

  2. ICT Coursework (MarcoS)

    On the last sheet, there will be the balance of the project, with a graph and with the result between loss and incoming of money. User skill level Accountants: There are 3 persons that are working to keep the account, and all of them are able to use Microsoft Excel

  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. The impact of ICT on a person with special/particular needs

    What makes it easier is the special keyboard. But this also slows down Sarah's work speed and makes her work quite difficult to finish. Lastly, it can all be a bit confusing due to Sarah's lack of control over herself. Sarah can easily get overwhelmed and be unable to control the computer due to her physical restraints.

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