Design a Letterhead for the Company

Parker's Chicken Chain

Yusef heard that you did Computer Studies SG and asked you for help. Complete the tasks given to you. Create a folder called Your Name Chicken Chain. Save all your work in this folder. Only work in the folder will be marked. On many of the tasks you have to name a file with XX. XX refers to your initials. Print your work as you complete each question, behind this and the answer sheet. Pin your work in the correct order. All the files for this paper are found on the Shared drive / CSSG folder / Chicken folder.

Name: …………………………………. Class: ……………….. Total: ………….

No / Name / Aim - Test / Hand in / Files needed / File saved as … / Mark / Your mark
1 / Salaries of part-time staff / Integration between Word and Excel, Spreadsheet functions and Graphs /

Spreadsheet of salaries of part-time staff and graph, and Answer sheet

/ pictures of a chicken / chicwaxx.xls / 18
2 / Staff for new branch / Integration between Excel and Access, table, query and report /

Report of staff members who live in Pinelands, and Answer sheet

/ chicstaff.xls / chicxx.mdb / 18
3 / Organising and checking of staff / Spreadsheet functions and formulaes /

Answer sheet

/ chicstaff.xls / 8
4.1 / Letterhead for the company / Word processing skills /

Letterhead

/ chicletheadxx.doc / 6
4.2 / Database table of wholesalers / Creation of a database table /

Table of wholesalers

/ chicxx.mdb / 3
4.3 / Merged letter / Integration between Access and Word /

Non-merged letter
Merged letter to Makro
Merged letter to Irvin & Johnson

/ chicformxx.doc
chicmergwholexx.doc / 7
5 / PowerPoint / Elementary and advanced PowerPoint skills /

PowerPoint information file

/ Chickens and poultry.ppt / Chickenxx.ppt / 10
Total / 70

chicken10.doc

Answer sheet Name ………………………………………..

Number / Answer / Formula / Mark
1.2.1 / 1
1.2.2 / 1
1.2.3 / 1
1.2.4 / 1
1.2.5 / 1
1.2.6 / 2
Number / Answer / Query / Field / Mark
2.4.1 / 1
2.4.2 / 1
2.4.3 / 1
2.4.4 / 2
Number / Answer / Formula / Mark
3.1.1 / 2
2
3.1.2 / 2
3.1.3 / 2

Marking sheet

Number / File name / Mark
1 / chicwaxx.xls / 1
2.1 / chicstaffxx.xls / 1
2.2 / chicxx.mdb / 1
2.3 / check drop down list / 1
check names, Mr and Ms / 1
4.1.7 / chicletheadxx.doc / 1
4.3.1 / chicformxx.doc / 1
4.3.4 / chicmergwholexx.doc / 1
Slide title / Command button / Instruction / Mark
Overall /

Make sure that the slides only move in Slide Show view when a box at the bottom of the screen is clicked.

/ 1

Remove the stupid star from every slide.

/ 1
Fast food outlets /

Insert the animation.gif in the centre of the slide
Insert the smlogo and moparkslogo picture from Chicken folder

/ 1
1
Recipes / Salad /

Make the command button bright green.

/ 1
Soup /

Change the colour of the text to red and bold and large

/ 1
Hors-d'Oeuvre /

Make the text bold and the font definitely not Times New Roman or Arial, and big enough to see

/ 1
Main dish /

Replace the command button with a picture of a chicken from the folder Chicken and a background pink colour

/ 1
Recipes / Soup /

To this command button add a user form. Make sure it opens when you click the command button. If it does not open the user form will not be marked.

Make the whole user form brown, the colour of roasted chicken

/ 1

Give the user form the name Soup

/ 1

1Salaries of part-time staff - 18 marks

Create the spreadsheet below. Copy the details below from Word to Excel or type them yourself. Save your document as CHICWAXX where XX represents your initials. [1]

Enum / Title / Name / Hourly Wage / Hours Worked / Gross Salary
1 / Mr / Adams, J. / R5.00 / 50
2 / Miss / Brown, S. / R5.50 / 60
3 / Mrs / Steyn, A. / R5.50 / 40
4 / Mr / Parker, H. / R6.00 / 110
5 / Mr / Cassie, E. / R5.50 / 20
6 / Miss / Cohen, K. / R6.00 / 30
7 / Mrs / Irwin, G. / R6.00 / 125
8 / Mrs / Barnes, B. / R5.50 / 40
9 / Miss / Vorster, P. / R6.00 / 45
10 / Mr / Brown, B. / R6.50 / 20

1.1Use a formula to calculate the Gross Salary of the workers as follows:

Gross Salary = Hourly Wage x Hours Worked

1.2Answer the following questions on the answer sheet. Indicate the answer as well as the formula.

1.2.1What is the average Hourly Wage?[1]

1.2.2What is the total number of Hours Worked by the part-time staff?[1]

1.2.3What is the maximum number of Hours Worked by a part-time member of staff?[1]

1.2.4What is the minimum number of Hours Worked by a part-time member of staff?[1]

1.2.5What is the Gross Salary of J. Adams?[1]

1.2.6What is the total of the Gross Salary of those who earn R5.50 per hour?[2]

1.3Sort the names of the workers into alphabetical order.[1]

1.4Create a column graph (Clustered Column) of the Names and Wages (as indicated in the diagram).

1.4.1Add the following titles:

1.4.1.1Chart title - Hourly Wages[1]

1.4.1.2X-axis - Names[1]

1.4.1.3Y-axis - Rand[1]

1.4.2.1On the Y-axis scale the minimum amount to 4.[1]

1.4.2.2On the Y-axis scale the major units to 1.[1]

1.4.3Align the names vertically. (If they do not all fit in, do not worry.)[1]

1.4.3Format the names to point size 8.[1]

1.4.4Format the amount on the Y-axis as Rand.[1]

1.4.5Insert a picture of a chicken from the folder to the graph, somewhere and some how.[1]

1.5Fit the graph and table to one page as only one page will be marked.

1.6Insert your name and class as a footer, left. (if there is no name, it will not be marked.)

1.7Save your work.

1.8Print the work.

(18)

2Staff for new branch - 18 marks

Yusef wants to open a new branch in Pinelands.

2.1Copy the file chicstaff.xls to your own folder. Save it as CHICSTAFFXX.xls where XX represents your initials. [1]

2.2Create a database called CHICXX where XX represents your initials. Import the data about his permanent staff from the spreadsheet chicstaffxx.xls Save the new table as Staff. Make the Number field the Primary key if you wish as it is of no concern in this paper. If other numbers are added it is of no concern. [1]

2.3Between the Number and Initial fields add a new field called Title. Make the field a drop down list with the values as Mr and Ms. Make every second person a Mr. Make every second person a Ms. [2]

2.4Using the queries function of the database, answer the following questions on the answer sheet. Give the answer and the query criteria in their respective fields.

2.4.1How many staff members live in Forest Drive?[1]

2.4.2How many staff members live in an area with the 7441 postal code?[1]

2.4.3How many staff members live in a Road (not an Avenue or Crescent)?[1]

2.4.4How many staff members have Surnames longer than 6 digits? [2]

2.5Create a report of staff members who live in Pinelands. Note that there are 16 staff members who live in Pinelands. [1]

2.5.1The report must include the Title, Initial, Surname and Address (1, 2 and 3) fields.[3]

2.5.2Sort in alphabetical order according to Surname. [1]

2.5.3The heading must be Staff who live in Pinelands (Then add your initials).[2]

2.5.4Add your name in the footer area. (If you cannot add your name, be sure to write it on the page with pen and that your initials are in the heading.) [2]

2.6Print the report.

(18)

Number / Initial / Surname / Address1 / Address2 / Address3 / Postal Code
1 / A / Barnes / 10 Glen Garry / Pinelands / 7405
2 / J / Beer / P O Box 11277 / Bloubergrant / 7441
3 / I / Berry / 83 Queen Victoria Street / Claremont / 7700
4 / B / Bougas / 13 Wattle Grove / Pinelands / 7405
5 / M / Brewis / 13 Forest Drive / Pinelands / 7405
6 / T / Damons / 13 Wittebomen Avenue / Constantia / 7800
7 / K / Denine / 15 Rhone / Pinelands / 7405
8 / E / Ebrahim / 136 Forest Drive / Pinelands / 7405
9 / J / Hughes / 8 The Meadow / Edgemead / 7441
10 / G / Irwin / 22 Hobson Court / Edgemead / 7441
11 / N / Ismail / 136 Forest Drive / Pinelands / 7405
12 / E / Jakoet / 7 Oude Molen Close / Pinelands / 7405
13 / M / Johnson / 29 Ambleside / Pinelands / 7405
14 / N / Justus / 7 Meerlust / Pinelands / 7405
15 / M / Kettlety / 21 Friesland Crescent / Edgemead / 7441
16 / M / Kwenda / 21 Friesland Crescent / Edgemead / 7441
17 / S / Langeveldt / 49 Union Ave / Pinelands / 7405
18 / R / Lewis-Thomas / 32 Pleasant Place / Pinelands / 7405
19 / K / Maistry / 14 The Crossing / Pinelands / 7405
20 / T / Marinus / 52 East Way / Pinelands / 7405
21 / C / Mbana / 11 Harmony Road / Hazendal / 7764
22 / N / Mbulawa / 23 Soshanna Road / Kenridge / 7550
23 / R / Michael / 9 Stradford Way / Pinelands / 7405
24 / P / Michels / 7 Paarl Street / Ruyterwacht / 7460
25 / S / Mnyani / 2 Blauwklippen / Kirstenhof / 7945
26 / B / Moon / 24 Zeeland Crescent / Table View / 7441
27 / K / Munro / 11 Sunset Avenue / Llandudno / 7800
28 / S / Nash / 21 Elm Road / Thornton / 7460
29 / K / Ngesi / 602 Garden City Heights / Lonsdale Way / Pinelands / 7405
30 / Z / Pillay / 13 Plane Avenue / Thornton / 7460
31 / M / Plaatjie / 20 Upper Angelina Road / Newlands / 7700
32 / T / Upton / 62 Polo Road / Observatory / 7925
33 / N / Wilson / 32 Daffodil Way / Pinelands / 7405

3Organising and checking on the new staff - 8 marks

Use the spreadsheet chicstaffxx.xls There is no need to print anything in this question. Do not bother to save anything on the spreadsheet. For each question give the answer and also the formulae on the answer sheet.

3.1Use any function and or formulae for the following:

3.1.1On the answer sheet give the logins for M Kettlety and P Michels. The logins must be the initial and then the first 5 letters of their surnames, for example the login for M Kwenda is MKwend (Do not worry about capital and small letters.) [4]

3.1.2How many people live in Edgemead?[2]

3.1.3How many people have surnames beginning with M?[2]

4Form letter - 16 marks

4.1Letterhead for the company

Using Word design a letterhead for the company. Do not use Word Art. You may use an image of a chicken. The letterhead must contain the following information:

4.1.1Name of the company:Parker's Chicken Chain[1]

4.1.2Postal address:P.O. Box 124[1]

Pinelands

7440

4.1.3Physical address:21 Forest Boulevard[1]

Pinelands

7405

4.1.4Telephone:531 1234[1]

4.1.5Fax:531 1239[1]

4.1.6Add your name as a footer, left aligned. (No name - will not be marked.)

4.1.7Save as CHICLETHEADXX where the XX represent your initials.[1]

4.1.8Print the letterhead.(6)

4.2Database table of wholesalers

In the database CHICXX where XX represents your initials, created in Question 2, create a table called Wholesalers of those wholesalers who supply the chain.

4.2.1The following fields are required: Reference number, Name of store, Name of manager, Address1, Address2, Postal code and Telephone number.

4.2.2Enter the following data in the table.

Reference number / Name of store / Name of manager / Address1 / Address2 / Postal code / Telephone number
1 / Makro / Mr J Petersen / P O Box 70 / Milnerton / 7435 / 5506300
2 / Irvin & Johnson / Ms S Philander / P O Box 1628 / Cape Town / 8000 / 4029200

[2]

4.2.3Save the table as WholesalersXX where XX represents your initials.[1]

4.2.4Print the database table called WholesalersXX fitted to one page. (Only one page will be marked.) (3)

4.3Merged letter

4.3.1Copy the following form letter below or type it yourself, to send to the wholesalers informing them about the new branch opening in Pinelands. This must be printed with the letterhead you created in Question 4.1. Save your form letter as CHICFORMXX where XX represents your initials. [1]

Dear <Name of manager>

We are proud to announce the opening of a new branch of our highly successful chicken fast food outlet in the Pinelands area. This area came out tops in our recent market survey and we are confident that the branch will prove profitable and provide a high turnover opportunity for your products.

This letter serves to seek your support for our new branch. The manager of the branch will be contacting you shortly to place our order for some of your products. Your normally good terms of credit will be much appreciated.

Looking forward to a continuation of our mutually profitable business relationship.

Yours sincerely

Yusef

4.3.2Merge the letter above with the WholesalersXX table.

4.3.3Save the non-merged form letter. Print.[3]

4.3.4Merge the form letter and the table Wholesalers. Save the merged documents as CHICMERGWHOLEXX where XX represents your initials. Print the form letters for both wholesalers. [3]

(7)

(16)

5PowerPoint about Chicken as a food - 10 marks

Copy the file Chickens and poultry.ppt from the Chicken folder to your own folder. Save it with the name CHICKENXX where XX represents your initials. Complete the following tasks. Save your work on a regular basis.

Slide title / Command button / Instruction / Mark
Overall /

Make sure that the slides only move in Slide Show view when a box at the bottom of the screen is clicked.

/ 1

Remove the stupid star from every slide.