PHS CyberSchool
Computer Studies SG Grade 12 - 2000
Last updated 16 August 2001
Mock final examination - Mouse Computer School - 80 marks
Create a folder called MOUSE in which to put all the tasks in this exercise.
You are enrolled in a computer course at Mouse Computer School. The following all concern aspects of that school.
Database
Create the following database structure:
| Field name | Data type | Field size | Primary key | Description |
| StudNo | Text | 6 | Yes | Student number (Primary key) |
| Name | Text | 20 |
| Student's name |
| Diploma | Text | 12 |
| CAD, E-Commerce, Networking |
| Courses | Number |
|
| Number of students |
| Fees | Currency |
|
| Tuition fees due (Rand) |
Add the following records to the database structure:
| StudNo | Name | Diploma | Courses | Fees |
| 1111 | White A.B | E-Commerce | 12 | 3050.00 |
| 5555 | Brown B R | Networking | 5 | 1200.00 |
| 4444 | Black K C | CAD | 8 | 2750.75 |
| 9999 | Green W | Networking | 6 | 2000.50 |
| 3333 | Cyan W C | E-Commerce | 6 | 1800.00 |
| 2222 | Red L M | E-Commerce | 6 | 1525.00 |
Create a simple form in which a secretary can add more students' details.
Save your work in the MOUSE folder.
Word processing
Using a word processor design a letterhead for the computer school. The letterhead must contain the following information:
| Name of computer school | Mouse Computer School |
| Postal address | P O Box 674
Table View
7439 |
| Physical address | 145 South Road
Table View
7441 |
| Telephone | 557 1234 |
| Fax | 577 1235 |
| Email address | bmouse@iafrica.com |
| URL | http://www.mouse.co.za |
Save your letterhead with a suitable name such as LETHEAD
Integration
The students whose details are contained in the database will receive accounts at the end of April. Using the letterhead you have to create a form letter to be sent to these students. Use the database and print and hand in letters for any TWO students. The following is the format of the letter:
|
Dear << name >>
Please be informed that you owe the institution the amount of << Fees >> for the << Diploma >> Diploma. We hope that payment will be made by 31 May 2000.
Sincerely
B. Mouse
|
Spreadsheet
You are enrolled in a computer course in which the students are given projects in the local community. You have been assigned to assist Kyle Hardware Store. They want to generate a report that summarises their monthly accounts receivable balance. The monthly information below in the table is available as a trial for test purposes.
Create the spreadsheet below.
|
Account number |
Customer name |
Opening balance |
Purchases |
Payments |
Returns |
Service charge |
New balance |
|
3180 |
Moodley |
2,480.00 |
824.62 |
1,100.00 |
422.60 |
|
|
|
3200 |
Smith |
3,150.00 |
223.00 |
2,155.00 |
223.65 |
|
|
|
1589 |
Peer |
223.15 |
500.00 |
110.00 |
83.50 |
|
|
|
5916 |
David |
759.16 |
112.68 |
445.00 |
245.00 |
|
|
|
1123 |
Abraham |
145.50 |
29.65 |
55.00 |
25.80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Save the file with your initials.
- Enter today's date in the top left-hand corner of the spreadsheet. The date must change to always show the current date.
- Insert a formula for Service Charge for Moodley: Service charge = 25% * (Opening balance - Payments - Returns)
- Insert a formula for new balance for Moodley: New balance = Opening balance + Purchases - Payment - Returns + Service charge
- Copy the formulae down that would complete the table for Service charge and New balance.
- At the base of the Purchases column insert a function that will find the highest amount of Purchases.
- At the base of the Returns column insert a function that will find the lowest amount of Returns.
- Insert an additional column called Type of customer after the column Returns.
- In the Type of Customer column insert an IF statement that will ensure that
customers who have a balance below R200 have the wording "Good" and
those with a balance over R200 have the wording "Poor payer."
- Centralise all the column headings.
- Format all currency columns to Rand.
- Format the column for New balances to 0 decimal places.
- Sort the spreadsheet according to Customer name in alphabetical order.
- In order to see the largest creditor create a pie chart showing the Names and New balances of all Customers.
Print and hand in, fitted to ONE sheet, the data and pie chart.
Return to Grade 12 lessons in 2000 or Computer
Studies lesson plan index of Pinelands High School. The views expressed do not necessarily express those of Pinelands High School. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.