PHS badge

PHS CyberSchool

Computer Studies SG Grade 12 - 2003

Modified 29 May 2003                                                                         

Word processing, Databases and Spreadsheets - 64 marks

Create a folder called YourSurnameFirstName.  Save all your work in this folder.  You may use tip sheets for this exam but watch the time.  Save your work regularly.

Refer to the Appendix for graphic illustrations of examples (Order information and Newsletter).

Question 1 - Labels - 2 marks

  1. Create a set of labels for the firm in the block below.
  2. Include a clipart picture of welding in the label. (1)
  3. The size of each label should be 3.5 x 7 cm, on the page 3 x 8, with no margins, A4 page size. (1)
  4. Save as 1LabelYourSurname
    Powermote Mobile Welding Machines
    Sales Office
    27(011)618-2690

[2]

Question 2 - Address labels - 4 marks

  1. Create a set of address labels to send mail to the names and addresses below.
  2. This must be done from a Word table.
  3. Label size is 3.5 x 7 cm, on the page 3 x 8, with no margins, A4 page size.
  4. Save the table as 2TableYourSurname (1)
  5. Save the labels as 2LabelYourSurname (2)
  6. Save the merge document as 2MergeYourSurname (1)
    Mr Mike Webb
    Reliant Engineering Services
    Silverstone Road
    Killarney Gardens
    7441    		 Mr Jack Nuttall
    Unit G
    23 Echium Road
    Table View
    7441    		 Mr B. Kay
    Roadrunner
    48 Marine Drive
    Paarden Eiland
    7441

[4]

Question 3 - Ordering - 15 marks

  1. Create a Word form to collect data for Ordering. (Example)
  2. Set the tabs at 4.5 cm left aligned. (1)
  3. Today's date must automatically update and have the day, month, year format. (2)
  4. Email, Fax number and Telephone number are text form fields with Regular text, Unlimited length and any text format.
  5. Contact name is a text form field with Regular text, Unlimited length and Uppercase text format. (1)
  6. Contact name needs Help text in two ways with the wording The person responsible for ordering. (2)
  7. Town needs a ready-made list of any five towns in alphabetical order and the words Select here to start the selection. (2)
  8. Check if ordered before needs a check box which is unchecked. (1)
  9. Insert a clipart picture of welding (1) as a watermark (1).
  10. As a footer add the file path. (1)
  11. Identify yourself as the author/creator of the document in the footer. (1)
  12. Save the form in locked format. (1)
  13. Save as 3OrderYourSurname

[14]

Question 4 - Simple DTPed booklet - 12 marks

  1. Open the file welding.doc or zipped welding.zip   (Example of the finished work)
  2. Do the work in the order given.
  3. Add a large text box, with the words WELDING, probably point size 48 aligned (1) as in the Appendix.
  4. Make sure the text is visible on the side of the text box. (1)
  5. Make columns for the text on Arc Welding (1), with a line between. (1)
  6. Make all headings with a single number, a Heading 1. (1)
  7. Make all headings with a something point something number, a Heading 2. (1)
  8. In Styles make all Heading 1s point size 16, bold, left aligned, with no spacing before or after (spacing is found in Paragraphs). Make this feature automatically update.   (1)
  9. In Styles make all Heading 2s point size 12, bold, left aligned, with no spacing before or after (spacing is found in Paragraphs). Make this feature automatically update.   (1)
  10. Adjust the size of the large text box with the word WELDING so that Arc Welding begins at the end of the box (1), and that the columns end on page 1 (1). (Do not delete any text to make it fit in. Do not adjust the margins.)
  11. Remove the numbering so that the work looks similar to that in the Addendum. (1)
  12. On the second page only (1), add a footer with information about the Source. (1)
  13. Save as 4BookletYourSurname

[12]

Question 5 - Database with details - 12 marks

  1. Create a database called 5DetailsYourSurname with the structure (not formatting) as shown below.
  2. Personalise the database with the name Welding Suppliers (1) and an icon. (1)
  3. Add the records for the four firms below in the correct fields. (1)
  4. Format the structure of the database as shown below.
  5. Create a form to add data to the table with the fields in the table. (1)
  6. Add a control text tip to the Name field. Must show - Only one person can represent the firm. (1)

     

    Field Format
    Name Must show as CAPS (1)
    FirmName Primary key (1)
    Address1
    Address2
    Address3
    Address4
    Address5
    TelephoneNumber It is required (1) Format xxx xxxx (1)
    EmailAddress It is required, from now on. (1)
    Validation rule (You decide what it should be.) (1)
    Validation text - An email address is necessary for communication. (1)

     

    Mr M. Dunn
    Spirax Sarco SA (Pty) Ltd
    Montague Drive
    Montague Gardens
    7441
    Tel 5511512
    Email matthew@spirasxs.co.za     		Mr Jack Nuttall
    Unit G
    23 Echium Road
    Table View
    7441
    Tel 5572246
    Email Lesley@minolta.co.za
    Mr Mike Webb
    Reliant Engineering Services
    Silverstone Road
    Killarney Gardens
    7441
    Tel 5568043     		Mr B. Kay
    Roadrunner
    48 Marine Drive
    Paarden Eiland
    7441
    Tel 5119096

[12]

Question 6 - Address labels - 3 marks

  1. Create a set of address labels to send mail to the names and addresses in the database (Question 5).
  2. Label size is 3.5 x 7 cm, on the page 3 x 8, with no margins, A4 page size.
  3. Save the labels as 6LabelYourSurname (2) 

[2]

Spreadsheet problems/Solutions - 18 marks

The following questions come from a welder in New York who has problems in his work which can be resolved with Excel. The following are excerpts from his emails requesting help. (It is his language and grammar with a few improvements from a non-welder.) Clearly demonstrate the solutions to the following questions. If you want to explain something write it in a textbox in/on the spreadsheet.

Question 7 - Yes/No - 2 marks

How do you ...

  1. write the word "yes" in a cell if that cell's value is greater than 1 (1)
  2. write the word "no" if the value is 1 (1)
  3. Save this answer as 7YesNoYourSurname

[2]

Question 8 - Colour - 6 marks

How do you print the word of a color if the cell's value is

  1. between 4.95 & 5.1 the cell should say "green" (1)
  2. between 4.8 & 4.95 the cell should say "yellow" (1)
  3. between 4.65 & 4.8 the cell should say "blue" (1)
  4. between 4.5 & 4.65 the cell should say "red" (1)
  5. anything more than 5.4 the cell should say 0 (1)
  6. anything below 4.5 the cell should say "FALSE" (1)
  7. Save this answer as 8ColourYourSurname

[6]

Question 9 - Format - 6 marks

I need to format cell readouts.

  1. After all the calculations they display the results as compound fractions. (Hint - A compound fraction is: 3/23, 4/12, 7/19 or 23/90).  I would like to round them UP and DOWN to the nearest ?/8 (3)
  2. but also I would like the lowest denominator after that - 6/8 would be 3/4 and so on (3).  I am a welder (not a math guy) but I made a small spreadsheet to help my guys cut steel and they cannot read things like 2/8, 4/8, 6/8 don't know why ? Could you please help me I have been looking forever and searched all over.
  3. Save this answer as 9FormatYourSurname

[6]

Question 10 - Hide - 4 marks

How do I only show the area that I have selected as "important area" (making all the info on the sides with my formulas hidden)?

  1. Save this answer as 10HideYourSurname

[4]

This work may be freely copied for non-commercial use only. Copyright © Pam Miller.