Free Letterhead Template

Document Sample
Free Letterhead Template Powered By Docstoc
					Word Processing

   Business Letters

    Memorandums
   Notice of Meeting and
          Agenda

Spreadsheets
         Format

        Features
                           A guide to the examinable practical elements.
Databases                      Simply click on the links on the left to find
        Features                          revision elements for that topic.
                           Note: Although it is possible to copy and paste
                            from this Presentation you will not be able to
                            in the exam. It is worthwhile taking the time
                             to not copy and paste, to give you a realistic
                                   time frame at how long tasks will take.



  Exam Style Questions
  main




 Ina practical exam you will not be asked to
  describe a business letter.
 You will be asked to create a letterhead or write
  the letter – on rare occasion both!
 Use the links below to find out more about it


             Letterhead         Business Letter



         Practical Question 1   Revision Ideas



         Practical Question 2     Extension
    back                                                       Next




 The letterhead is usually placed at the top of the letter.
  This will usually include the contact details of the
  business and include the business’s logo.
 The business will have this saved as a template so staff
  can re-use it every time they have to write a new letter.
 Things to include on a letterhead:
      •Business Logo
      •Street Address
      •Web Address (URL)
      •Email Address
      •Telephone number
      •Fax number
 However, where they go has to be
 visually appealing – remember it has to
 create a good first impression , create
 a professional look! And conform to
 their house styles!
    back                                                               Next




   A business letter can be sent to a customer or another
    business so it has to make a good impression.
   A badly written letter makes a business look unprofessional
    and is likely to put customers off.
   Fully blocked style is used – where each new line begins to
    the left of the margin.
   There is a set order that elements should be included:
1.   Reference                       Should beof“Dear Mrrefers to
                                     If you writeunique to each
                                     The body a letter Jones”,
2.   The date                        you must usually close “Yours
                                     letter and use the relevant to
                                     its content.
3.   Recipient’s name                sincerely”, practice to use
                                     It is good
                                     the topic. E.g. If writing toat
4.   Recipient’s address and         least write “Dear your
                                     customers about Sir/Madam”,
                                     If youthree paragraphs if
     postcode                        you must use the close
                                     companies latest offers:“Yours
                                     possible.
5.   A greeting/salutation           faithfully”.
                                     offersapr10
6.   Body of the letter
7.   Complimentary Close
8.   Signature
9.   Person’s name and position
back                                                                     Next




   CGH Hotels has proudly become a sponsor for the 2012 London
    Olympics.
   The managing director wants to include the London 2012
    Olympics Logo onto their letterhead to show their commitment
    and update the look of their letterhead for the modern age.
   Create a new letterhead for CGH Ltd using the information below
    and the London 2012 Olympic logo.


                                                             The Peak
                                                                Purton
                                                              Swindon
                                                              SN5 4AT
    Where a good night’s                            Tel: 01793 770 570
    sleep is guaranteed!
                                                   Fax: 01793 770 522



They have a new website www.cgh.co.uk and accept emails through
the address: enquires@cgh.co.uk
    back                                                                           Next




   CGH Hotels has proudly become a sponsor for the 2012 London Olympics.
   The managing director wants to honour the event by offering previous
    customers the chance to come and stay with them during the Olympics
    for a special Olympic holiday.
   He has asked his assistant to put together some ideas of what to include.
   Write the letter outlined below (If you have already completed Practical
    Question 1, use your letterhead template).
The reference should be linked to the event, for a template purpose we should
use the name and address of Mr Forename Surname, Address Line 1,
Address Line 2, Town/City, Postcode
The contents should include details of when the Olympic holiday offer is
available from and to (from 27 July to 12 August 2012) at a price of £79 a night
full board.
Should tell the readers that there is a special event hosted to give them HD
cinemas style access to the Olympic games as well as being within a 5minute
walking distance from a shuttle site.
The Managing Director wants the letter to be up beat and promote the Olympic
experience available at the hotel.
back




 Over  the next week ask the household to
  donate any letters that they dont need
  (nothing personal – junk mail will do)
 Do the letters you have collected conform to
  the rules of business letters? Annotate the
  letters (with permission from the owner) to
  show both good and bad points.
 If they have changed from the rules of a
  business letter – why do you think this is?
 If they haven’t changed from the rues of a
  business letter – why do you think this is?
    back



   Try revising some of your other subjects by writing a business
    letter for it – be as creative as you want to be. For example,
    what do you think is being revised below:                You can always look
                                               ndex                                              back at the letter you
                                                otation                                          have written a week
                                 The Peak, Purton, Swindon, SN5 4AT                              later and revise both
                               Tel: 01793 770 570 Fax: 01793 770 522
               http://www.bbc.co.uk/schools/gcsebitesize/maths/algebra/indicesrev1.shtml         subjects – Index
      Ref: INRev001                                                                              Notation by reading
      12th April 2010
      Miss C Marshall
                                                                                                 the letter and BCS
      The Peak                                                                                   Practical by labelling
      Purton
      Swindon
                                                                                                 the elements and why
      SN5 4AT                                                                                    they are in positions.
      Dear Miss Marshall
      Thank you for expressing an interest in Index Notation for beginners and the possibility of free revision
      resources.
      I am pleased to inform you that we will be able to offer you this at your requested discount. We are
      delighted to tell you that we use Index Notation to represent powers of a number. For example, b3
      means b × b × b and here the index is 3 and if we had a number in front of the variable, for example, 4d 2
      means 4 × d × d.
      Could you please contact me to confirm your receipt of the guidance given.
      Yours sincerely
      C. Marshall
      Miss C Marshall
      Teacher of ICT and Maths
    main




 In a practical exam you will not be asked to describe
  a memorandum is or when they are used
 You will be asked to create a memo using information
  given
 Use the links below to find out more about it



                         Layout and content



           Practical Question 3          Revision Ideas



           Practical Question 4               Extension
    back                                                                               Next



   Memorandums layout is often very simple – ensuring all the details needed are
    included and easy to find.
   They do not usually use the company logo – but can for consistency.



                  To:         All Staff
                                                                   Standard
                  From:       Terry Teacher                        Memo
                                                                   heading
                  Date:       19th April 2010
                                                                              All points
                  Subject     New Technology                                  made are
                  This month’s staff improvement meeting will be held         brief and to
Required                                                                      the point
                  next Thursday 22nd April in the Main Hall.
response          The meeting will count towards your staff
stated            development points that are required for your end of
                  year evaluation.
                  Please sign up before the end of the day if you intend
                  to attend this meeting.
back                                                                       Next




   WebDesPix wants to train all their sales staff to be aware of all of
    the companies latest products to help them with their selling.
   For these reasons, Tom and Dee (owners and Directors of
    WebDesPix) are calling all the sales staff in for a meeting. This
    meeting will be held on Monday 19th April 2010, one week before
    the products are launched at 6pm.
   Although they will not be paid for their time spent in the
    meeting after work they will receive free dinner on the Monday
    evening.
   Write a memo to encourage sales staff to attend and for them to
    send an email to Tom if they intend to go.
back                                                                    Next




   John, the non-executive chair of WebDesPix, wants all staff to be
    aware that the menu for their free lunch on Friday’s is open to
    negotiation this week.
   John wants any contributions for what staff would like to see
    added or removed from the menu to be returned to him by Friday
    (must work out date).
    They must be informed that a short list will be drawn up of the
    new additions to the menu by a week from today (must mention
    the date) and staff will get to vote for their preferences.
   Create the memo for John ready to send to the WebDesPix
    employees.
back




   Ask your tutor if you can take a look at a copy of the
    school’s green, blue and referral slips.
   What is common between each of these documents?
   Why do you think they share those qualities?
   Do you think there is a reason for their different sizes and
    colours?
   Do you think we can describe these 3 documents as
    Memo’s?

   Memo’s have been replaced by email in many businesses.
    What are the advantages and disadvantages to the Bradon
    making this same switch?
    back



   For many types of revision you can use index cards to tell you the
    important points that you want to remember – you could always
    try putting the cards in the format of a memo.


      To: Miss C Marshall

      From: BBC Bitesize

      Date: 19th April 2010

      Subject: Index Laws

      There are a couple of laws that you need to know off by heart for calculations involving
      indices.

      MULTIPLYING: Add the indices like this: p3 × p7 = p10,
      DIVIDING: Takeaway the indices like this: s5 ÷ s3 = s2
      You cannot simplify an expression like 4p + p2 because 4p and p2 are not like terms.
      SUBSTITUTION: We know that 4p3 means 4 × p × p × p, so when p = 2 we substitute
      this into the expression: 4 × 2 × 2 × 2 (or 4 × 23) = 32

      To revise this throughly visit the bbc bitesize website or ask your teacher for some test
      questions.
    main




 In a practical exam you will not be asked to describe
  they are and why they are used.
 You will usually be asked to create a notice of
  meeting and an agenda as one document.
 Use the links below to find out more about it




            Notice of Meeting        Agenda



           Practical Question 5   Revision Ideas



           Practical Question 6     Extension
    back                                                                         Next



   A Notice of meeting is to let staff know a meeting will take place, kind f
    like an invitation to a meeting.
   It is usually only a few lines long and accompanied by an agenda.
   A memo can be sent to tell staff of an up and coming meeting however, a
    notice of meeting is usually sent closer to the day and will include more
    information about the date, time and location of the meeting.

                                             No logo, but house style in
                                             terms of fonts and layout is used
subtitle
                Notice of Meeting

                A meeting will be held for all Sales Staff in the
                Conference Suite on Friday 23rd of April 2010 at
                10.00am.


     Location, full date and time                    Who has been invited
    back                                                                            Next



   An Agenda tells those invited to a meeting exactly what will be discussed.
   It gives attendees time to prepare for the meeting.
   There are standard items that must be used in every Agenda produced:

                                                          Non Standard Items
    Agenda                                                These will change
                                                          depending on the
    • Apologies for absence                               topic of the meeting.
    •Minutes of last meeting                              For example, if you
                                                               Standard Items
    •Matters arising                                      are discussing Sales
                                                               These are
    •Correspondence                                       figures you might
                                                               always part of
                                                          add 2 points to your
                                                               an Agenda.
    The main business is where the items that will be     Agenda:
    discussed in the meeting are listed. These change     •Sales figures for last
    every meeting.                                        month
                                                          •Predicted Sales for
    •Any other business (AOB)                             next month
    •Details of next meeting                              •New product
                                                          promotion
back                                                 Next




 Bradon Forest School need to prepare a Notice of
  Meeting to inform staff of a meeting to be held
  in the school hall at 3:45 on Thurs 29th April
  2010.
 It must include standard items and include the
  following non-standard items on your document:

     Year 10 School Trip
     Refurbishment of the School canteen
     Mock exam time table
back                                                 Next




 Bradon Forest School need to prepare a Notice of
  Meeting to inform staff and students involved in
  the School Council.
 There will be a meeting for them in H6 on Wed
  7th April, over Easter holidays, at 10am.
 It must include standard items and include the
  following non-standard items on your document:

     School Council promotion
     Displays to get students involved
     Projects for around the school
     Overlap with the SEAL team.
back




   Why not plan a family room meal around a table
   You can even cook if you want!
   Create a notice of meeting (invitation to dinner) and an
    agenda (all the things you want to talk about) to give to
    your guests
   Make sure you include the standard items
       Minutes of last meeting – this one will be difficult if you are doing
        this for the first time. However, if you keep notes you can do this
        again for the next one!


   Note: You should keep note, otherwise known as minutes,
    of everything you talked about. You’ll be suprised at how
    much you get through!
back




   Order of an Agenda Cards
   Cut out the following and put them into the correct order
    they would appear in an Agenda
       Matters Arising             Any other business (AOB)
       Minutes of last meeting     Agenda
       Details of next meeting     Correspondence
       The main business to be discussed


   Explain why it is important that a notice of meeting and an
    agenda is given to all staff.

   After a lesson in school can you create a notice of meeting
    and an agenda for that lesson.
main
    main




 In a practical exam you can be asked to make a
  spreadsheet or use your skills in other programs to
  describe what a spreadsheet is, and their
  benefits/drawbacks.
 Use the links below to find out more.


    Spreadsheet Format        Simple Formulae             Other Formulae and Functions



     Printing Formulae     Cell Referencing and Copying            Sorting


                           Benefits and Drawbacks



    Practical Question 7    Practical Question 8               Revision Ideas
    back                                                                                                         Next



   To tell the computer to make a calculation a formulae must be entered.
   Click in the cell you want the formulae to appear, then enter an equals sign
         A formula must start with an “=” sign – this is how a computer knows it has to calculate
          something!

                                                                           Note: You can do this to a
                                                                           range of cells.
                                                                           E.g. =A2+B2+C2+D2
                                                                           To give us 30

    To add two numbers                  Put the cell reference of the first number, a “+” sign followed by the
                                        cell reference of the second number
                    +                   E.g. =B2+C2 (the spreadsheet above would give us 12)
    To subtract a number from another   Put the cell reference of the number you want to take away from, a
                                        “-” sign followed by the number you want to subtract
                     -                  E.g. =B2-C2 (the spreadsheet above would give us 4)
    To multiply two numbers             Put the cell reference of the first number, a “*” sign followed by the
                                        cell reference of the second number
                     *                  E.g. =A2*C2 (the spreadsheet above would give us 12)
    To divide a number by another       Put the cell reference of the first number, a “/” sign followed by the
                                        cell reference of the second number
                    /                   E.g. =D2/A2 (the spreadsheet above would give us 5)
 back                                                                                            Next




AutoSum   Highlight the cells you want to add together and press the AutoSum
          button.


                                                                                        Click to see


Max/Min   Type “=” followed by “MAX(”, highlight the numbers you want to find the
          maximum number in, type “)” and press enter.
          Similarly, you can find “=MIN(” in the same way.

Average   Type “=” followed by “AVG(”, highlight the numbers you want to find the
          maximum number in, type “)” and press enter.


IF        To make a decision between one or more items. Type “=IF(” followed by
          any condition you want to match, “B2>C2” means to check if what is in
          cell B2 is bigger than what is in cell C2. Then type “,” followed by what
          you want the cell to say if B2 is actually bigger than C2, E.g. “Yes, it is
          bigger” (note: you need speech marks around words – but not if you want
          numbers), then type “,” followed by what you want the cell to say if B2 is
          not bigger than C2 E.g. “No, it is not bigger” (again – speech marks
          needed here) followed by a “)”.
          So you have: =IF(B2>C2, “Yes, it is bigger”, “No, it is not bigger”)
    back                                                                                         Next


   If you have to create a spreadsheet in your exam, you WILL have to print out your formulae
    at some point. This proves to the examiner that you haven’t “cheated” in your spreadsheet

                                        Select “Tools” from the top of your
                                        screen.




Select the View tab and
tick the box labelled
“Formulas” and click “OK”

                                                              Your spreadsheet may require
                                                              re-formatting. However,
                                                              instead of the answers, you will
                                                              now see the formulae. You can
                                                              print as normal.
    back                                                                                                        Next


   To speed up making formulae and to avoid making mistakes we can use both Relative and
    Absolute Cell References.
                                                     When you click on a cell, making it an active
                                                     cell, there is one corner of the cell that is
                                                     slightly different. If you click on this corner and
                                                     drag it in a direction you copy the contents of
                                                     that cell into the ones you have dragged it into.

   What this looks like depends on what was in the original cell.


       Relative Cell Reference                                   Absolute Cell Reference
Here, when we copy our formula it automatically         Here, when we copy formulae this cell wouldn’t
increases the number of the cell you drag it into.      change.
Or, when you fill horizontally the row letter will      Using Relative cell reference Club members 139 to 145
change.                                                 wouldn’t have to pay any membership.


                                                                                                     Using the $ sign
                                                                                                     before and after the
                                                                                                     column letter
                                                                                                     means that they will
                                                                                                     always use the
                                                                                                     value in that cell – it
                                                                                                     wont change!
    back                                                  Next


   Highlight all of the information in the spreadsheet




   Go to Data and Sort


   Select what you want to sort by
   Here: who pays the most
   Click “Header row”
          If there is a heading selected


   Click OK
 back                                                                     Next




            Benefits                             Drawbacks
It allows you to perform         It   can be quite difficult to use
calculations quickly              There are lots of functions and
Hundreds  of functions and       formulae to remember
formulae available like copying   Training will be required to use the
formulae                          software to its full extent
Itallows you to create graphs    Training can be expensive and take
and charts                        a long time
Ithelps businesses create        It   is easy to make mistakes
professional-looking documents
         back                                                                                                                          Next




           You are the financial assistant of a large chain of gyms. You were asked to arrange a training event for all Gym Managers held in
            London. All Gym Managers were allowed to claim expenses for the training event. They were allowed to claim for travel costs,
            food and overnight accommodation. You need to work out each person’s expenses so you can give the money back.

                A              B            C             D                   E                F        G           H                  I
     Name                 Start Place   End Place   Total Mileage   Total Cost of Mileage   Hotel     Food     Total Expense   Amount Per Mile
     Corey Walton         Swansea       London      372                                     £130.00   £8.00                    £0.30
     Michael Cartwright   Coventry      London      190                                     £128.00   £53.00

     Ethan Gordon         Birmingham    London      232                                     £99.00    £48.00
     Amelia Clements      Wrexham       London      364                                     £110.00   £28.00

     Kieran Watson        Portsmouth    London      150                                     £162.00   £33.00

     Gabriel Kay          Glasgow       London      794                                     £132.00   £47.00
     Kai Bull             Manchester    London      395                                     £110.00   £75.00
     Maddison Hussain     Leeds         London      386                                     £182.00   £45.00

1.          Set up the spreadsheet shown below
2.          Format your spreadsheet to improve its appearance
3.          Work out the total cost of mileage in cells E2 to E9. You will need to use Absolute Cell Referencing here.
4.          Now work out the total expense for each person
5.          There has been a mistake with Gabriel Kay’s hotel bill. It came to £153, not £132, and Amelia Clements’ food bill was £23, not
            £28. Change the cells accordingly.
6.          Print your formulae ensuring you can see all the information. Please ensure this is a landscape page.
7.          Create a column chart showing the total expenses for each person. Make sure you have sensible labels for your chart. Print your
            chart.
back                                                                 Next




      These are extension tasks for Practical
       Question 7
1.     Use an appropriate formula to calculate the average total
       expenses per person.
2.     Use an appropriate formula to find out the highest mileage
       travelled.
3.     Use an appropriate formula to find out the lowest food bill
       of all the managers.
4.     Sort your expenses into ascending order.
5.     Print your formulae ensuring you can see all the
       information. Print onto a landscape page.
back




   Unfortunately, the only way to revise spreadsheets is to
    use them and explore different functions you can use.
   Because you may be asked to create a
    presentation/leaflet/website on Spreadsheets, you need to
    know some of the theory behind using spreadsheets as
    well.
   Using a Word Processor, write a few paragraphs to explain
    the benefits and drawbacks to a company of using
    spreadsheet software to calculate expenses.
   Keep track of your spending for a week in a spreadsheet,
    how many different functions can you use on this
    information?
   Make a presentation of spreadsheet functions. (I’m sure
    your teacher would love a copy of this!)
     main




   In a practical exam you can be asked to make a database (or
    related task) or use your skills in other programs to describe
    what a database is, and their benefits.
   Use the links below to find out more.

        Database Format               What is a database?          Appropriate Data Types


        Creating a table              Changing Data/Edit            Add/Delete a Record


              Sorting                    Simple Queries                  More Queries

                                    Advantages and Disadvantages
    Creating Reports from Queries                                   Printing an Access Database
                                        of a database system


      Practical Question 9                                              Revision Ideas
All information about one person or thing.                              back

                records




                                      fields
                                               Headings in a database
                                                                        Next
    back                                                                Next


   A database is a collection of data stored in a structured way.
   It is structured into fields and records (click here and see)
   A database can be created about any topic; at home you may
    create a database of all your friends’ and family’s details. In a
    business, they may store customer, product and staff details in
    databases.
   Once a database has been set up there are many functions
    available to perform a variety of tasks.
   back                                                                                                  Next




Data Type       Use For

Text            Text or combination of text and numbers, such as addresses. Also numbers that do
                not require calculations, such as phone numbers or Postcodes.

Memo            Lengthy text and numbers, such as notes or descriptions.

Number          Numeric data to be used for mathematical calculations, except calculations involving
                money.

Date/Time       Dates and times.

Currency        Use the currency data type to prevent rounding off during calculations.

AutoNumber      Unique sequential (incrementing by 1) or random numbers automatically inserted
                when a record is added.

Yes/No          Fields that will only contain one of two values, such as Yes/No, True/False, On/Off.

OLE Object      Object such as MS Word or Excel, picture, sound or other binary data can be
                embedded into the access table.

Hyperlink       Field that will store hyperlinks. This is usually the address (URL) of a webpage or an
                email address.

Lookup Wizard   Creates a field that allows you to choose a value from another table or from a list of
                values using a combo box. Choosing this option in the data type list starts a wizard
                to define this for you.
    back                     Next




Click Blank database
Save it where you want it
and name it appropriately
Click “Create table in
design view”
Enter the fields (or
headings) you want to be
in your database.
Select an appropriate data
type for each field.
You can set a number to
be a Primary Key (means
each record will have its
own unique number – a bit
like your STU to log onto
the computer)
Select the Datasheet View
Save, choose an
appropriate table name.
You now have a table you
can add information to.
    back                                                              Next




   When asked to edit data in a database, it basically means
    something must be changed in the data.




   In an exam you might be asked a question like: The estate agent
    made a mistake: property number 191021 is £170,000.00, not
    £150,000.00. Edit the database.
    back                                                               Next


   When asked to delete a record in a database it means it is no
    longer needed. To do this, right click on the grey square on the
    left-hand side of the record that needs deleting, then select
    “delete record”.




   In an exam you might be asked a question like: Property 282202
    has been sold; delete the record.
   Add works in the same way. Right click on a grey square on the
    left-hand side, any of them, then select “Add record”. An empty
    row will appear at the bottom of your database. Enter the new
    information in there.
    back                                                                   Next




   Allows data to be sorted into numerical or alphabetical order.
   There are two options available here: can order by Ascending
    (Alphabetical, A to Z or 1 to 10) or Descending (Opposite, Z to A or
    10 to 1) order.
                                                              Click if you want
                                                              it ascending or
                                                              descending.
                                                               Click on the
                                                               field you want
                                                               to order
                                                               everything by

                                                              Now everything
                                                              is in Price order
   In an exam you might be asked a question like: Sort the field Price
    into descending order. The most expensive property should appear
    at the top.
      back                                                                                    Next


   A query is when a database is searched to find information that match certain criteria.
   Organisations can have extremely large databases so finding information with queries
    saves a lot of time.
To set up a Query:
Click Queries in the database
window and select “create
query in the Design View”

Select the table you want to
make a search on, Click
“Add” and then “Close”

Select the heading you want
to see and search

Add the Criteria you want to
search on

Press Run (!)

Save your query something
meaningful.
    back                                                                         Next


   It is also possible to do queries on more than one field or to compare
    items.
   For example:
          < 120 means less than 120
          > 120 means greater than 120
          = 120 means equal to 120
          <= 120 means less than or equal to
          Yor* would find York, Yorkshire and Yorktown but not New York. So
           Yor followed by anything
          Mar? would find Mark but not Mario, Martin or Omar. So Mar followed
           by just one letter
          F*d would find Fred and Ferdinand but not Frederick.
          Between X And Y to find values in a range of numbers type the
           expression
          <#1/1/98# finds dates earlier than 1 January 1998
          =#27-Sep-50# finds dates equal to 27 September 1950
          Between #5/7/98# And #10/7/98# finds dates no earlier than 5 July
           1998 and no later than 10 July 1998
    back                                                                      Next


   Once you have completed a query, you may want to print the results.
   You could just print the normal view of the query, which is fine but it
    isn’t very professional looking.
   Reports are a better way of displaying database information.
    back                                                                                Next


   Database software is very useful. Its functions include sorting, queries
    and reports. There are some benefits and drawbacks of database
    software.

                Benefits                                Drawbacks
Youcan save time finding information      Equipment  and software can be
compared to a paper database               expensive to buy
You   can sort information into order     Training will be required to use the
You  can search for information that      software to its full extent; this training
meets a certain criteria quickly and       can be costly.
easily                                     Ifthe computers fail, you will not be
You can produce professional looking      able to access your information.
reports                                    There  may be issues with security: it is
You  can select data types such as text   important that when storing personal
or currency; this will help prevent        information, organisations follow the
mistakes                                   Data Protection Act.
    back                                                                      Next


   Usually, printouts from a database will be in the form of a report.
    However, in your exam (if making a database) you will probably be
    asked to give proof of completing tasks as you go along.
   Therefore, you will have to (on occasion) take a screenshot of what the
    question is asking you to show.
   This screenshot should be put into a Word Processor with the required:
    Candidate Number, Your Name, Centre Number (66509) and Question
    Number.



   Note: You have to make sure, when you get your printout, that it is
    readable and shows exactly all that it has to.
    back                                                                                                             Next



The CGH Ltd hotel in London keeps a database with information about its staff. The
following are new members of staff.




(a) (i) Using this information, create a database with 5 fields (STAFF NO, SURNAME, INITIAL, AREA, DEPARTMENT)
         and enter the staff details.
       Print out a copy of the database showing all fields. The copy should be clearly marked with the question
       number, centre number and your name and candidate number.                                         (5 marks)
   (ii) S Sutcliffe has moved to another of CGH Ltd’s hotels. Delete this record.                       (1 mark)
   (iii) J Christie works in the Public Areas Department. Amend this record.
       Print out a copy of the database showing all fields.                                             (1 mark)
(b) (i) Another member of staff has been employed, working in the Restaurant Department which is in the Food
         Area. His name is Raoul Patel and his Staff Number is L2036. Create a new record for him.    (3 marks)
   (ii) Carry out an ascending sort on the SURNAME field.
       Print out a copy of the database showing all fields. The copy should be clearly marked with question
       number, centre number and your name and candidate number.                                         (2 marks)
(c) (i) Search the database for members of staff who work in the Food Area.                             (1 mark)
   (ii) Sort this search on the DEPARTMENT field.
       Print out a copy showing the STAFF NO, SURNAME AND DEPARTMENT fields only. The copy should be
       clearly marked with the question number, centre number and your name and candidate number. (2 marks)
    back


   A lot like spreadsheets, it is very difficult to revise databases
    without practicing them.
       Try thinking of chances you could use a database to help you with revising
        other subjects. For example: Could you use a contacts list? (Names,
        addresses, telephone numbers etc for friends and family) A game list – do
        you know exactly what games you have (Useful to include additional details
        not just the game name, perhaps a link to the store with the current
        cheapest price, the age rating, etc – just in case your friends intend to get a
        copy).
   You could also be asked to describe the features of a database
    using your skills in another program.
       For example, you could be asked to make a presentation of the
        benefits/drawbacks to a company intending on using a database package.
        Here, you will be marked on not only the content but also what your
        presentation looks like.
       Try making a leaflet describing the features of a database, what they are,
        why they are useful and how they benefit the company.
    main




   The practical exam is different for Year 10 and Year
    11 pupils. However, the questions remain fairly
    similar.


                   Year 10 Exam             Year 11 Exam




     Exam Question 1          Exam Question 2          Exam Question 3


     Exam Question 4          Exam Question 5          Exam Question 6


    Exam Question 7          Exam Question 8          Exam Question 9
    main




   This unit of the qualification is worth 25% of the overall grade.
   Assessment of this unit will take the form of a practical exam on Thursday 17th June 2010
   Your work will be sent off by an external examiner to mark.
   You will be told to print various pieces of evidence throughout the exam: YOU MUST make
    sure your details are on each print out or they can not be accepted! (Candidate Number, Your
    Name, Centre Number (66509) & Question Number)
   The exam will consist of two tasks you have to complete during the 1 hour examination.
   Each task will be broken up into smaller tasks.
   To prepare for the exam you should become familiar with the following software:
       Spreadsheets
       Databases
       Word Processing
       Desk Top Publishing
       Web Design
       Graphics
   You should also be able to discuss the above software and its features in detail.
   Other types of software you should be able to discuss are: project management
    software, diary management software and the others discussed in this presentation.
    main




   This unit of the qualification is worth 35% of the overall grade.
   Assessment of this unit will take the form of a practical exam, your teacher will have arranged
    a date for you.
   Your work will be sent off by an external examiner to mark.
   You will be told to print various pieces of evidence throughout the exam: YOU MUST make sure
    your details are on each print out or they can not be accepted! (Candidate Number, Your Name,
    Centre Number (66509) & Question Number)
   The exam will consist of three tasks you have to complete during the 1 hour 30 minute
    examination.
   Each task will be broken up into smaller tasks.
   To prepare for the exam you should become familiar with the following software:
       Spreadsheets
       Databases
       Word Processing
       Desk Top Publishing
       Web Design
       Graphics
   You should also be able to discuss the above software and its features in detail.
   You might also be asked to recall theory topics and to describe them in detail.
     back


     You are the assistant manager of a small furniture shop. You want to start using the
     spreadsheet software to calculate staff wages. Complete the following tasks ; set up a
     spreadsheet with the following headings: Employee ID, Name, Hourly Rate, Hours work
a.   You need to enter the hours each member of staff has worked this week. Enter the following
     data:
         15667 - N Thomas, £6.50, 35
         17223 – T Morgan, £5.75, 41
         12223 – O Williams, £6.75, 42
         194453 – C Simpson, £8.00, 34
         33441 – D Jones, £9.50, 12                                              (5 marks)
b.   O Williams has been given a pay rise: her new pay is £7.50 per hour. Edit it in the spreadsheet.
                                                                     (1 mark)
c.   A new sales person has been employed. The persons name is Y Lewis; their staff ID number is
     182928; they worked 21 hours last week. They will also be paid £7.50 per hour. Insert a new
     row underneath O Williams and enter their data.                           (6 marks)
d.   Create a formula to calculate the weekly pay of N Thomas. Then fill the formula down to
     calculate other staff members’ weekly pay.                                (2marks)
e.   Staff have to pay deductions, such as income tax and National Insurance etc., out of their
     weekly pay: this figure is 26% of their weekly pay. Create a formula in cell G2 to work out 26%
     of N Thomas’ pay. Then replicate the formula down to work out the other members of staff.
                                                                                 (2 marks)
a.   Now work out the take home pay for each member of staff                     (2 marks)
b.   Print your spreadsheet in landscape in the formula view.                    (2 marks)
    back


Part A
    The manager has told you he wants you to organise a full staff meeting.
    The meeting is to be held in the manager’s office at %pm Monday, 1st February 2010
    Write a Notice of Meeting and Agenda including the standard fixed items and the following:
            January Sales
            February’s promotions
            Database Software
    Print your Notice of Meeting and Agenda
                                                                               (12 marks)
Part B
    The manager is considering purchasing database software to store all the stock detail. At the
    moment stock lists are stored in a paper filing system and the system has its problems.
    She would like you to crate a presentation using presentation software to show in the meeting.
    The purpose of the presentation is to explain to her staff what database software is as well as
    features of the database software. You must also explain the advantages and disadvantages of
    the software and explain the impact it could have on the business.
    You will be expected to demonstrate some of the features of the presentation software. You
    will also be expected to provide speaker notes with further information.
    Print your presentation in notes form, back to back.
                                                                               (18 marks)
    back


    Set up a spreadsheet with the following title and data keyed in.                       (5 marks)

                                          QUARTERLY SALES ANALYSIS


                    PACKAGE                PRICE                       NUMBER SOLD

                                                          APRIL           MAY        JUNE

                    Budget                          800           24            33          45
                    Professional                   1000           15            22          34
                    Executive                      1500            8            17          22
                    TOTALS

    Embolden the title and field headings including the month names.                       (2 marks)
    Format the relevant figures for currency £.                                            (1 mark)
    Enter formulae to calculate the Monthly Totals below the figures for each month.       (2 marks)
    Create a new column, to the right of the column for June, with the heading “AVERAGE PER MONTH”, and
     using formulae calculate the average number of each package sold per month.        (1 mark)
    Create a second new column to the right, with the heading “TOTAL NO SOLD” and calculate the total number
     of each package sold for the quarter.                                             (2 marks)
    Enter the text “QUARTERLY TOTALS” under the monthly averages and calculate the total number of all
     packages sold packages sold.                                                     (2 marks)
    Create a third new column to the right, with the heading “% OF QUARTERLY TOTAL” and calculate the
     percentage of the total for each package of the Quarterly Total (Tip: remember to use an absolute cell
     reference when referring to the Quarterly Total in your formula e.g. $F$5).          (2 marks)
    Finally add a fourth column to the right, with the heading “TOTAL INCOME” and calculate the total income for
     each package and for the quarter below them – remember to format for currency.      (2 marks)
    back



   Using the company name initials, design a suitable
    logo for WebDesPix Ltd, with the image of the set
    of ducks below.
   The logo should portray a modern, fun but
    professional corporate image with a colourful but
    stylish house style (font, graphic and background
    colour, size, style etc).
                                              (10 marks)



                               Note: WebDesPix has a slogan of
                               “Like Ducks to Water”
    back


   Set up a database with fields of 6 characters only for these 7 items of information for each record: Company,
    Last Name, First Name, Telephone, Client Number, Email and Package.                                   (6 marks)
   Key in the data of WDP’s clients as given below:

    Circuit Electronics Ltd      Kendrick’s   Amanda      01256 845246           21   kendricksa@circuite.co.uk              Budget
    Baby Wardrobe Ltd            Peters       Andy        01256 838677           57   petersa@babywardrobe.com               Professional
    Bristol Cricket Club         Edwards      Charlie     01256 845987           15   enquiries@bristolcricket.org.uk        Budget
    Avon and Somerset Assoc      Lomax        Chris       01256 849877           38   lomaxc@asa.org.uk                      Professional
    Wrights of Bristol Ltd       Patel        Christina   01256 324560           26   patelc@wrights.co.uk                   Executive
    Clifton Cars Ltd             Arnold       Dale        01256 912344            2   arnoldd@cliftoncars.co.uk              Executive


   Print a first copy of the database.                                                                           (1 mark)
   Circuit Electronics Ltd have gone into liquidation so delete their record.                                    (1 mark)
   Bristol Cricket Club have changed their contact person to James Davidoff, amend their record.                 (1 mark)
   WDP has taken on a new client; Avon Organics Ltd, whose contact is Jan Bergstein, telephone number 01256
    955366 and email is bergasteinj@avonorganics.co.uk. They will be client number 98 and have purchased an
    Executive package. Enter their details on the database and put it into numerical order by client number.
                                                                                                                  (5 marks)
   Print a second copy of the database.                                                                          (1 mark)
   Select the clients who have purchased Executive packages and sort them into alphabetical order.               (6 marks)
   Print a third copy of the database showing these three clients with Executive packages only.               (1 mark)
    back


You are asked to create a landscape book fold leaflet (which is folded down the centre to create 4
    pages).
   On the front page enter the text “WebDes Pix Ltd” in uppercase and in a suitably large font
    with additional text features.                                             (5 marks)
   Underneath centrally position an image of a set of 4 ducks as shown below or a box to indicate
    where an image would go, with the text “Like ducks to water” and your logo.
                                                                                (4 marks)
   Underneath centrally position the text “For all your website design and e-commerce needs” in
    a different size and style to the company name.                             (2 marks)
   On the other 3 pages use one page for each of the following page 1: what a website is and their
    structure, Page 2: Benefits and Drawbacks for a business, Page 3: Package costings (see below)
    and contact information (Tel: 02938 432223, Email: enquiries@webdespix.co.uk, web address:
    www.webdespix.co.uk, Senate House, Tyndall Avenue, Bristol BS8 1TH)        (7 marks)
Each page must have a title, in a consistent font plus an image for each or box to indicate where
   an image will go to in the bottom right hand corner of each page.            (2 marks)
Package Information
   Executive “The complete integrated package for the business or organisation which is going
    places and needs a showcase website to lead the way” £1500 + 10% VAT
   Professional “Combines the features of the Budget package with search engine optimisation
    plus e-commerce data handling and finance management features” £1000 + 10% VAT
   Budget “Includes a number of web pages, e-mail facilities and the costs of hosting the site”
    £800 + 10% VAT
   Additional services available upon request.
    back



    Use the information below to construct a letter to Angus Bradley inviting him for an interview.

    Business letter writing rules:
               Fully blocked style
               Open punctuation except in the main body of the letter
               Main body requires 3 paragraphs
               Salutation and complimentary close must match

   From:      Tom Smith
     WDP
     Kingsley Retail Park
     Bristol
     BS2 5SD
   To:        Angus Bradley
           6 Cranford Way
           Clevedon
           Avon
           SM2 7TD
   Insert Today's date
   Interview for position as Web Designer
   Time of interview: 2.30pm
   Date of interview: Tuesday 5 April 2010
   Meet with Dee Reynolds at 2.15pm in reception
                                                                                   (15 marks)
back



WDP Ltd are organising an Induction morning for three new employees.

Create schedule in a Word document and in a table format to include the
following information:

9.00am meet with Tom and Dee for coffee in the conference room;
9.45am tour of WDP Ltd’s offices; 10.15am health and safety brief with
Dee; meet with Tom at 10.45am to discuss some HR issues; meet with
staff 11.30am for coffee.
                                                              (10 marks)
back



Re-arrange the words below into memo format, and write 2 suitable
memos to include the following information:

Dee wants to meet with Richard the Web Design Assistant to talk about
updating the web pages for WDP Ltd. She wants to meet with him at
10.00 am on Thursday 18 March 2010, in her office. She asks him to
confirm his attendance.

Richard replies to Dee’s memo stating that he is able to make the meeting
and will see her at 10.00 am Thursday 18 March 2010, in her office.
                                                              (10 marks)

				
DOCUMENT INFO
Description: Free Letterhead Template document sample