1 Salaries of Part-Time Staff - 7 Marks

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. All the files for this paper are found on the Shared drive / CSSG folder / Chicken folder.

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

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 / Answer sheet / 7
2 / Staff for new branch / Integration between Excel and Access, Access queries / Answer sheet / chicstaff.xls / 5
3 / Organising and checking of staff / Spreadsheet functions and formulaes / Answer sheet / chicstaff.xls / 8
4 / Networking firms / Spreadsheet functions and formulaes / Answer sheet / netfirms.xls / 9
5 / PowerPoint / Elementary and advanced PowerPoint skills / PowerPoint information file / Chickens and poultry.ppt, Recipe.doc, images in Chicken folder / Chickenxx.ppt / 52
6 / Web design / Advanced web features / Web site / Chicken food for the massesXX / 10
Total / 91

Total: ………….

chicken11.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.3.1 / 1
2.3.2 / 1
2.3.3 / 1
2.3.4 / 2
Number / Answer / Formula / Mark
3.1.1 / 2
2
3.1.2 / 2
3.1.3 / 2
Number / Answer / Formula / Mark
4.2.1 / 1
4.2.2 / 2
4.2.3 / 2
4.2.4 / 4

5 Marking sheet

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.gif and moparkslogo.gif 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
Main dishes / · 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.
· Add 4 large multipages, with the names Pie, Casserole, Oven-roasted and Curried / 1
· The names on the multipages must be point size 14 / 1
· The names on the multipages should be bright yellow / 1
· The tabs should be on the side, see picture at end / 1
Salad / · 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.
· Add 4 multipages to the user form.
· On each page add one picture clear, visible and big enough to see. Use some in the Chicken folder / 4
· On each picture add a text tip with the words "Food for the masses" / 4
· Remove any border from around the pictures / 4
· The background to the pictures should be red. / 4
Hors-d'Oeuvre / · 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.
· Use the information from Recipe.doc in the Chicken folder
· Create a box or something so that the recipe is visible and scrolls down with a scroll bar. [1]
· Be sure that each ingredient is on a separate line. [5]
· Make sure that the instructions are numbered and on separate lines. [5]
· Make the background of the text pale brown or yellow (the colour of cooked chicken wings). [1]
· Make sure it cannot be deleted when viewed. [1]
· Make sure the text is visible against the background by giving it a suitable colour. [1] / 1
5 - all or nothing
5 - all or nothing
1
1
1
Know How / · Add 4 command buttons to quiz user forms. Each form must have a single question about chickens, etc. plus information if the answer is correct or incorrect. / 8

1 Salaries of part-time staff - 7 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.

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.1 Use a formula to calculate the Gross Salary of the workers as follows:

Gross Salary = Hourly Wage x Hours Worked

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

1.2.1 What is the average Hourly Wage? [1]

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

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

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

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

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

[7]

2 Staff for new branch - 5 marks

Yusef wants to open a new branch in Pinelands.

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

2.2 Create a database called CHICXX where XX represents your initials. Import the data about his permanent staff from the spreadsheet chicstaffxx.xls . 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.

2.3 Using 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.3.1 How many staff members live in Forest Drive? [1]

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

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

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

[5]

3 Organising and checking on the new staff - 8 marks

Use the spreadsheet chicstaffxx.xls For each question give the answer and also the formulae on the answer sheet.

3.1 Use any function and or formulae for the following:

3.1.1 On 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.2 How many people live in Edgemead? [2]

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

[8]

4 Networking firms - 9 marks

Yusef needs to install a LAN in the new branch. The names and details of all the Networking firms listed in the Cape Peninsula Yellow Pages 2001 are available as netfirms.xls.

4.1 Copy the file netfirms.xls to your own directory. Save it as NETFIRMSXX where XX represents your initials.

4.2 For each question give the answer and also the formulae on the answer sheet. Use any function and or formulae to answer the following questions:

4.2.1 How many firms have a 7405 postal code? [1]

4.2.2 How many firms are a CC and have CC in their names? [2]

4.2.3 How many firms have za in their email address? [2]

4.2.4 The telephone numbers of all companies will change soon. The numbers 021 have to be added to the front of all Peninsula numbers. Insert a new column between Local phone and Fax. In this column use a spreadsheet feature to quickly add 021 to the front of all numbers. What will be the new numbers of 3Com and Q-Data Network Cabling? [4]

[9]

5 PowerPoint about Chicken as a food - 52 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.

[51]

6 Web design using FrontPage - 10 marks

Create a basic web site with the name Chicken food for the massesXX where XX represents your initials.

It must be meaningful with regard to the theme of the site.

The aim is to show the examiner that you are able to create and use a particular feature. Choose one of the tasks below.

6.1 Create a basic web site using Frames. The site must have 5 pages apart from the main index page.

6.2 Create a basic web site with a main page and Hot Spots from a picture, to the other pages in the site. The site must have 5 pages apart from the main index page.

6.3 Create a basic web site. On the index page create a Crossword with 5 clues and answers.

6.4 Create a basic web site. On the Index page create a meaningful Animation using PaintShopPro telling a story. The animation needs 5 pictures.

6.5 Create a basic web site with Shared borders. It needs to link to 5 pages.

6.6 Create a basic web site with a meaningful Flash introduction. It may not take more than 5 seconds to load.

6.7 Create a basic web site with 5 pages with Roll over links to pages.

chicken11.doc