BAP611S - BUSINESS APPLICATION 2A - 2ND OPP - JULY 2022


BAP611S - BUSINESS APPLICATION 2A - 2ND OPP - JULY 2022



1 Page 1

▲back to top


nAmlBIA UnlVERSITY
OF SCIEnCE Ano TECHnOLOGY
FACULTY OF COMMERCE; HUMAN SCIENCE AND EDUCATION
Department of Management
QUALIFICATION: Bachelor of Business and Information Administration
QUALIFICATION CODE: 07BBIA
LEVEL: 6
COURSE: Business Applications 2A
COURSE CODE: BAP611S
DATE: JULY2022
DURATION: 2 Hours
SESSION: FACE-TO-FACE
MARKS: 100
EXAMINER(S)
MODERATOR:
SECOND OPPORTUNITY - QUESTION PAPER
Ms L Beukes
Ms D Olivier
INSTRUCTIONS
1. Answer ALL the questions.
2. Read all the questions carefully before answering.
3. Make sure your name, surname, question number and the date
appear in the Header and Footer.
THIS TEST PAPER CONSISTS OF 5 PAGES (Excluding this front page)

2 Page 2

▲back to top


1
Question 1
Marks: 20
Bank Windhoek is organising a Fundraising event for the Cancer Association which will be in a form
of a Gala Dinner. Theme of the event is "Your Health is your Wealth".
As the Office Administrator in the Marketing Department, you have been tasked to co-ordinate the
planning process. The event date is scheduled for Saturday, the 2nd of July 2022. Planning will start
from the 6th of June 2022.
The Fundraising event team-building event is made up of the following tasks and resources:
NR NAME OF TASK
1. Book a Venue
TASK DURATION
1 Day
RESOURCES
Bianca
2. Design and send out Invitations
3. Decor arrangements
4. Entertainment & Sound System
5 Arrange for Catering
3 Days
1 Day
3 Days
2 Days
Bianca
Hilma
Carlos
Hilma
6. Master of Ceremonies
7. Media and Photographer
8. Programme Design
9. Confirm guest list and sponsors
10. Final check-ups and logistics
2 Days
2 Days
2 Days
2 Days
1 Days
Carlos
Bianca
Carlos
Hilma
Carlos
1. The Milestones for this event will be the following:
Deposit of 60 % to be paid to:
a) Venue
b) Design and send out Invitations
c) Decor
Full Payments to be made for the:
a) Entertainment & Sound System
b) Catering
c) Photographer
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 only page 1 and 2.

3 Page 3

▲back to top


Question 2
Question 2
Second Opportunity
July 2022
QUESTION 2
MARKS: 20
In Ms Word create the following form on one sheet. Adhere to typing rules and instructions
given. Use the font Bookman Old. Please print two copies. One copy which displays the content
controls and another copy which displays the completed form with your personal detail.
SURVEYABOUTEDUCATIONALCHOICES +-
U/C, Bold,Cent, font size 16
=)--:!:: L\\Y'\\.de.rs-\\--o.f-J
-------- We want to appreciate your choice~, and it is therefore important that you answer
according to what is important to you. If.you don't understand a question ,you may leave
\\ I <'\\.'K<:.0-
the question blank. No material will be !r_a_c~,9_tbo_ly~o_u as an individual.
N
rl
q:::
or if none of the alternatives are right for you
QJ
.!::!
.V.) ...
This questionnaire contains questions about you an your en eria, expec ations and plans
C
.2
related to educational choices. First-year students at all Namibian Universities and Colleges
QJ
are invited to participate.
V)
:::::,
~DUt'
.:f'"
answers are important to the study! Thank you very much!
-=I=
1.
tm a Male
Female }
Please insert checkbox at the
beginning of each option
2.
Year of birth: Iinsert Date-oicker UseFull I
rl
rl
QJ
N
3.
I study at (name of University or College): ............................ RichText Control - Strong I
.V.) ...
C
·:\\:=:
.2
QJ
4.
Degree program: ...........................
RichText Control - Strong I
V)
::i
:::%=--
"O
C
C1l
5.
What were your first and second choice of programs in your application?
X
0
·::\\==-
.!:l
Choices: .......................................
-----,,~ Insert dropdown list
.Q.J...
C
4="
t:
6.
Approximately when did you decide on this field of study?
QJ
V)
C
-::f
QJ
In primary school
V)
C1l
During lower secondary school
aQJ:
.....
V)
·5.
v\\
A
During 1st year in upper secondary school
After having studied something else.
The decision emerged slowly over a long period of time }
Pleaseinsert checkboxesat
the beginning of each option
I don't know
'4""
The choices you make today will determine your tomorrow!!

4 Page 4

▲back to top


Question 3
Marks: 30
Type the following Main Document in font Times New Roman, Font size 12 and make use of
the information at the end of the document to create a standardised letter for your clients.
Create a mailing list of all the clients in Excel spreadsheet. Merge the two documents
together to create personalised letters.
Print the letter to Ms J Karumbe, the Excel Spreadsheet as well as the Mail merged
document.
Today's Date
+
«NAME»
3 «ADDRESS»
«TOWN»
-0
0
suCe
«COUNTRY»
t-
DISCOUNTS,
Dear Client
-> ~\\>r'"\\ ~\\
,5, I want to take a moment to thank you for your continued support of T~
Sho..e_W! ere it not for loyal customers like you, we would not be celebrating our
-zL 10th anniversary on «DATE» , we will be hosting a special May Madness Sale!
ls,k_:~oJ.,di i.
-'
c_.
_{ 3.If yJ°ubuy for more than «AMOUNT» you will qualify for even more discounts.
·
~]
-&. 8
-,-.jj"
(_rn"honourof the anniversary_)
A..,off 1. EJfrything in the store is available at 10 %Jthroughout the month.
J~ Selected specia swill be offered for the at higher discounts, such as:
7\\\\~ e:,:- Pumpk.in seed, Sunflower seed, Peas,Corn, Carrots, Beans -> \\ J;:~e...un~Jee.f.I0e6.,-\\\\.-
[\\ J
2. ~le-tst=erfo-wMithff<yo»uyowuhecnaynofu'esahlisoep,.aacn..eeywe1en..g:reater
savings by bringing this
I...>-'.>~,
e___
l\\"
.i_::::;,u
.\\..,
~J
4. Present your~
to the cashier at the check~-oou;~tJ)oint, to identify
yourself as a VIP Customer and receive an additional "DI8COUt JT» off your
~\\d
total bill.
<"'"~
your,t-
for all yourspringplanting needs!
~d
&::Ae\\ 1 ...L·\\-e.,\\
u\\ I
c....
Ms Gloria Shoopala is the General
Manager of The Garden Shop

5 Page 5

▲back to top


4-·
FIELD
NAMES
NAME
ADDRESS
TOWN
COUNTRY
DATE
AMOUNT
RECORD 1
Mr J Jacobs
PO Box 140
Rundu
NAMIBIA
30 May 2022
$5000.00
RECORD 2
RECORD 3
Ms J Karumbe Ms A Kasevera
PO Box 220 PO Box 440
Oshakati
Windhoek
NAMIBIA
NAMIBIA
30 May 2022 30 May 2022
$5600.00
$6700.00
RECORD 4
Mr P Paulus
PO Box 233
Swakopmund
NAMIBIA
30 May 2022
$7800.00
Instructions for Excel Spreadsheet:
1. Type the spreadsheet in font Comic Sans, size 12.
2. Insert N$ for all the amounts add two decimals after the comma.
3. ColumnHeadings - Font size 14, Bold, u/c
4. Records - font size 12.
5. RowHeight: ColumnHeadings 40 pixels
Rest of Rows.30 pixels
6. Sort Surname in ascending order.
7. All Borders.
8. Print excel spreadsheet in Landscape.

6 Page 6

▲back to top


-~
!.- '~
:--~ ?ie
0
0
---~
~le
0
.s
---..i
~1[~
0
:L-5
c,'~ljL
0
:~ ?
:~
9ii?. ~f ',C
0
i-)
~~-j ~,--.-:,::.:::~
!,!-~--:;,
,'8L c;;:)
7.Je --~
0
?ifl
0
7~
1t!,!:::2:~;,
8
i
i i @
;.R,
w.
~/larks: 30
In Nls VVord, please Di~AV\\/ the following Table and complete the information iri.the .·.·
font Calibri, size '12.
You are the secretary of a small company called
f\\lliVIPAA (f\\lamibia Institute for P1·ivateAssistants'
J-\\ssociation). You are responsible for the record
keeping of all the members and 1·eceivingtheir
membership fees and calculate their salaries.
For this purpose, you have set up the following spreadsheet for the Finance Department:
Salary Scale: NIMPAA
i\\ilember i\\Jarna
Haufiku Sarah
lpinQe Aina
Aukongo Lihah
Shikongo Launa
Thomas Leena
Van Zyl Retha
Etunda Martha
Kazapua Johanna
Wai;ies iJel" Hour
150.00
175.00
125.00
140.00
85.00
65.00
120.00
·110.00
Days V\\Jorkin~J
20
15
22
18
19
20
16
20
Total Salary
Adhere i:o ·the following editing instructions for the table:
1. Draw the Table
2. Auto fit table to content.
3. Set row height to 0.3"
4. Insert the correct formula to calculate the salary for each employee.
5. Insert a Total row at the end and calculate all the columns.
6. Sort Table according to Member Name in ascending order.
7. Convert Table to chart which only displays the:
o Member Name
o Total Salary
8. Pre-set the table: Grid Table 2, Dark Accent 1
9. Insert caption below the table: Table 1: NIM PAA Salaries.
10. Insert your name and student number in the header and print one copy.
;:.,":;:
.;.~
0
0
;;~ t-3 f4
>'i~ 7,it
0
0
7Jt
0
0
i €:)
7iic
~~.:c~
0
0
0
t,~-=-~ ,.7.:-.i
-~
,::m:i
'
~i:.:E::i I-~
?...
i i Q?g
0
'i
,®'
'