 |
BAP611S - BUSINESS APPLICATION 2A - 1ST OPP - JUNE 2024 |
|
|
1 Page 1 |
▲back to top |
n Am I BI A u n IVER s ITY
OF SCIEn CE Ano TECHn OLOGY
FACULTYOF COMMERCE;HUMAN SCIENCEAND EDUCATION
DEPARTMENT OF GOVERNANCE & MANAGEMENT SCIENCES
QUALIFICATION: BACHELOR OF BUSINESS AND INFORMATION ADMINISTRATION
QUALIFICATION-CODE: 07BBIA
LEVEL: 6
COURSE CODE: BAP611S
COURSE NAME: BUSINESSAPPLICATIONS2A
SESSION: JUNE 2024
DURATION: 2 HOURS
PAPER: PRACTICALS
MARKS: 100
FIRSTOPPORTUNITYEXAMINATION QUESTION PAPER
EXAMINER{S} MS L BEUKES
-
MODERATOR: MS PWITBEEN
INSTRUCTIONS
1. Answer ALL the questions.
2. Read all the questions carefully before answering.
3. Number the answers clearly
THIS QUESTION PAPER CONSISTS OF _6_ PAGES (Including this front page)
|
|
2 Page 2 |
▲back to top |
r
Question 1
Health Harmony Medical Centre is about to open their doors in Klein Windhoek.
As the new Office Administrator, you have been appointed as the co-ordinator for
this very important project.
MEDICAL
fr"t:.:,.LIIH'. • :·· •
The event date is scheduled for Saturday, the 28th of September 2024. Planning will start from the
2nd of September 2024.
The Launching of this big event is made up of the following tasks and resources:
NR NAME OF TASK
TASKDURATION RESOURCES
1. Develop a Business Plan
2 Days
Krestina
2. Select a Location/Venue
1 Day
Gizelle
3. Obtain Necessary Licensesand
Permits:
4. Marketing and Branding
2 Days
2 Days
Peter
Peter
5. Invite local stakeholders
3 Days
Gizelle
6. Entertainment & Sound System
2 Days
Krestina
7. Catering {Refreshments for Guests). 2 Days
Krestina
8. Programme Design & Printing
1 Days
Gizelle
9. Photographer & Media release
1 Days
Gizelle
10. Programme Director
1 Days
Peter
11. Confirm guest list
1 Day
Krestina
1.
12. Final check-ups and logistics
1 Days
Peter
1. The Milestones for this event will be the following:
Deposit of 50 % to be paid for the:
(a) Venue
{b) Marketing & Branding
{c) Programme Design & Printing
Full Payments to be made for the:
{a) Photographer & Media release
{b) Programme Director
2. Please add predecessors for each milestone.
3. Assign resources to the tasks as indicated above.
4. Insert your Name in the Header, save your document and print to fit {1 page only).
|
|
3 Page 3 |
▲back to top |
Question 2
June 2024
QUESTION 2
MARKS:30
In Ms Word create the following form on one sheet. Adhere to typing rules and instructions
Given on the next page. Use the font Arial, size 12. Please print one copy which displays the content
controls and information added.
General Admission Registration
¢
(u/c, bold, font Arial Black, size 18, cent)
Personal Information
¢
(u/c, bold, font size 12, cent)
Name: .................................................................
Last Name:......................................................
Email: .................................................................
.,.._.., Gender:
QJ
V)
C
Male
Female
Phone:..................................................................
Diet?ryrestriction~-?--t.> BoId
- t\\i"one.·
V) ·,y~g~tai.i.~h
0.,..._.,
QJ
'GlutenAi'lergy
lacto.~eAller.gy
V)
C
Nut Allergy
Insert CheckBoxes
on the left of the
different options.
;St\\~llfishAlfergyj
Date of Birth: .................................................
Do you require parking?
Yes
No
What is your room preference:
¢
Single Room
}
Shared Room
No Room Needed
What activities will you attend: Award Gala Dinner
Luncheon
Town Hall
}
¢
Are you registering for yourself or someone else?
Myself
}
Someone Else
Insert checkboxeson
the left of eachoption
Insert Drop Down List
Insert
Drop
Down
List
Additional Information:
u/c, bold, centre, size 12
if:.
::i
V)
If registering for someone else, please provide their name and relationship to you:
ro
;::i.
Use
D/S
~RNIaema et·:io·•n··s•·h··"I·p·.··•·•·•·•·•·•·•·•·•·•··•·•·•·•••••·•·•·•••·•·•·•·•·•·•·•·•·•·•·•·•··••••
_..
Insert Content controls:
Usethe font Emphasisto format
-:f:.
>-
,r-o+
X,co-+-
X
Any special accommodations needed: Yes No _____. Insert checkboxes
..
¢
t
Q)
V)
C
-cVl' bD
0 .tlO
QJ C
:v:i::) .cco
'Terms_ and Conditions: (bold)
By submitting this registration form, I agree to abide by the rules and regulations
set forth by the organizers of the event/program.
I understand that my registration is subject to approval and may be rejected if
incomplete or inaccurate information is provided
|
|
4 Page 4 |
▲back to top |
3
Question 2
June 2024
Question 2 (Form)
INSTRUCTIONS:
1. Delete dotted lines and insert content controls, and format as
indicated below in brackets. Please replace dotted lines with the
details as indicated below.
Name: Your name (Subtle Emphasis)
Last Name: Your surname (Subtle Emphasis)
Email: Yo"uremail address (Intense Emphasis)
Gender: Your gender
Phone: 0815557896 (Strong)
Date of Birth: Today's date (Full Date)
Do you require parking? Your choice
What is your room preference: Your choice.
What activities will you attend: Your choice.
Are you registering for yourself or someone else? Your choice.
2. Additional information:
Name: Name of classmate
Relationship: Fellow Student
3. Terms and Conditions: Tick both boxes.
|
|
5 Page 5 |
▲back to top |
QUESTION 3
Retrieve the following SalesJournal of Fire Equipment. Adhere to the instructions
to complete the Journal.
Service Date
02/04/2024
09/04/2024
16/04/2024
23/04/2024
30/04/2024
06/05/2024
13/05/2024
20/05/2024
27/05/2024
10/06/2024
Fire Equipment
CO2 Aluminium
ATFF Stored Pressure+A 1:111
Class F (Deep Fats)
Dry Power Stored Pressure
Dry Power Stored Pressure
Dry Power Stored Pressure
ATFF Stored Pressure
ATFF Stored Pressure
ATFF Stored Pressure
Water Stored Pressure
Code
FR10
FR11
CF1
DF2
DF3
DF4
AF1
AF2
AF3
WS1
Quantity
20
50
60
25
90
20
65
90
90
60
cost
Price Rating
107.00 34B
186.63 75B
257.16 TBA
138.61 13A
86.54 27A
111.18 55A
65.34 SA
112.65 13A
115.50 21A
83.81 13A
Sumlf Function
TOTAL
MARl<S: 30
Units
Sold
96
101
106
85
45
75
58
52
75
65
Sale
If
Price Functon
|
|
6 Page 6 |
▲back to top |
--6
Question 3 - Excel
Memo
INSTRUCTIONS:
1. Insert three rows on top ofthe table.
2. Top row:. Insert the heading Fire Equipment (u/c, Arial, font size 16, bold, merge & centre)
Row 2: Insert April 2024 (Arial, font size 12, bold, merge & centre)
3. Use the Sum Function to calcu,~atethe Sale Price (Quantity x Cost Price).
4. Use the correct formula to calculate the Cost Price of the Dry Power Stored Pressure only.
Insert the answer in E18.
5. Use the If-Function to calculate the Sale Price of the Fire Equipment.
If the sale price is smaller than 5500 the equipmentmust be sold on promotion.
6. Insert the correct formula to caculate the total sum of the Sale Price. Insert answer in H19.
7. Change the Date to a full date and centre position.
8. Bold the column headings, all calculated answers and the answers for the IF function.
9. Increase the row height:
Column Headings: 50 Pixels
Rest of the table: 30 Pixels
10. Change the font of the entire table to Calibri and font size to 12.
11. Merge and Centre and right-align the following cells:
Cell A16 & B16 as well as A17 & B17.
12. Print final copy on landscape.
June 2024
|
|
7 Page 7 |
▲back to top |
r'
Question 4 (Pivot Table)
Instructions
QUESTION4
MARKS:20
RetrieveQuestion 4 - Pivot Table (List of Holidays)from your M-drive and adhere to
the instructions that follow.
June 2024
Instructions:
1. Retrieve the following table in Excel and save the workbook as: Question 4 -Pivot Table
2. Rename sheetl to Original
3. Make a copy of table in Original and rename the new sheet as Student Analysis
4. Insert 2 rows above the column headings.
5. Insert Main Heading in row 1 -Student Analysis
(Merge & Centre, Arial Black, 14, u/c)
6. Edit the table as follows:
6.1 Change the font of the entire table to Calibri font size 12.
6.2 Change the column headings to font size (12}, bold, u/c
6.3 Fill Column Headings (White Background 1, Darker 15%} row height 40 pixels
6.4 Resize columns headings and change the row height of the rest of the table to 30 pixels.
6.5 Print table in landscape.
7. Pivot Table:
7.1 Select the Original sheet and create a PivotTable.
7.2 From the PivotTable Field List choose Count of Student by Status to be displayed
in the Report. Add Gender & Programme to the list.
7.3 Move Gender to Column Label and Programme and Status to row label.
Move Count of Students to Values.
7.4 Rename the sheet tab - Report
8. Chart:
8.1 Create a Pie chart from the Report.
8.2 Insert the following Chart Elements:
Chart Title - Student Analysis (Bold, u/c, centre)
Data Lables - Data Callout
Legend - Insert on the left
8.3 Select Style 4 from the chart styles.
8.4 Make sure both the table and chart fit on one sheet and print in portrait.