 |
BAP611S - BUSINESS APPLICATIONS 2A - 1ST OPP - JUNE 2023 |
|
|
1 Page 1 |
▲back to top |
nAmlBIA unlVERSITY
OF SCIEn CE Ano TECHn OLOGY
FACULTY OF COMMERCE; HUMAN SCIENCEAND EDUCATION
Department of Management
QUALIFICATION: Bachelor of Business and Information Administration
QUALIFICATION CODE: 07BBIA
LEVEL: 6
COURSE: Business Applications 2A
COURSE CODE: BAP6115
DATE: June 2023
DURATION: 2 Hours
SESSION: Practical Paper
MARKS: 100
EXAMINER($)
MODERATOR:
FIRST OPPORTUNITY - QUESTION PAPER
Ms L Beukes
Ms S Klaassen
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 4 PAGES (Excluding this front page)
|
|
2 Page 2 |
▲back to top |
i
Question 1
Marks: 20
Adventure sports is a thrilling niche unto itself. Wall-rock climbing works on many levels as a team-
building exercise because it requires a lot of teamwork and it's physically testing.
As the project co-ordinator you have the responsibility to co-ordinate this project to raise funds for
Ndoro Children's Charities a Help4NAm Food bank Organisation. This event will take place on the 29th
July 2023. Please start planning at least one month in advance.
NR NAIVIEOFTASI<
1. Define Your Target Audience
2. Book a Venue (Maerua Mall}
3. Design Posters
4. Music & Sound System
5 Prizes for the Winners
6. Programme Design
7. Media and Photographer
8. Programme Facilitator
9. Confirm Participants
10. Final check-ups and logistics
TASI<DURATION
2 Days
1 Day
3 Days
3 Days
2 Days
2 Days
2 Days
2 Days
2 Days
1 Days
RESOURCES
Joseph
Saraphina
l<aino
Joseph
Saraphina
l<aino
Joseph
Saraphina
Joseph
l<aino
1. The Milestones for this event will be the following:
Deposit of 70 % to be paid for the:
(a) Venue
(b) Design of the posters
(c) Prizes
Full Payments to be made for the:
(a) Music & Sound System
(b} 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
·1>.
June 2023
QUESTION 2
MARl<S: 30
Please insert a textbmc and type the Form below in Font Arial, size 12 unless otherwise
indicated. Adhere to all instructions.
Career Success --1>
Please use Word Art (Gradient Fill: Blue Accent
color 8; Reflection) to type the heading of the
form. Format: U/c, centre, bold
Font: Elephant
Size: 16
Format: Bold, u/c, cent
What we want most for you is
{ what you most want for yourself!
Insert check boxes on the right of each title option
Plain TextControl - Strong
Surname .. . ... .. . . .. ... ... ... ... .. . .. . . .. ... ... . .. ... ... ... . .. Miss
Mrs
Mr
*Fi.rst Names ....P..l.a..i.n..T..e..x..t..C..o..n..t.r..o..l.-..S...t.r.o..n..g....................................................................
.
-:f. . . RichText Control - Intense Emphasis
RichText Control - Intense Emphasis
Pos1t1on ... ... ... ... ... ... ... ... ... ... .. . ... ... ... ... ... .. Company ....................................................
.
PlainText Control - Emphasis
Postal Address ...........................................................................................................
.
-:j:.
,_Subscription: 4-I nsert Dropdown List.<
Privr1te
Company sponsored
Payment Options: <l- Insert check boxes for the Payment
t
Bold. Italics
options underneath each other, d/s
Options: Cash, Debit Card, Credit Card
=I
Official company order number: .......................................................................
.
t
SUBSCRIPTIONFORM: CAREERSUCCESS
Career success annual subscription fee: <l---
u/c, bold, Italics
-:/:
11 Issues= N$85,00 + N$11,90 VAT
For countries outside South Africa = N$120,00
lJ
Post to: Subscription Department, PO Box 751735, Garden view 1 2047
\\
Font size 12, bold, cent
Insert round bullets, d/s
Typist, two copies must be printed.
1. Delete dotted lines and insert content controls as indicate and print.
2. Insert the details as indicated below and print another copy.
3. Type the following headings in font Arial, size 12 and enter the detail as indicated below:
Surname: Your surname
First Name: Your name
Position: Office Administrator
Company: Career Success
Postal Address: Private Bag 13133, Windhoek
Subscription: Choose an option
Official company order number: 12212
|
|
4 Page 4 |
▲back to top |
3
QUESTION 3
MARKS:
Open a MS EXCEL worksheet and key in the following Income Statement. Use the default
margins of the program and follow the instructions carefully. Please type the document in
Arial, font size 12, unless indicated differently.
iNSTRUCTIONS
1. Use the correct formula to calculate the Income for all
employees.
2. In column F apply the ROUND UP function to the Income of
the employees to one decimal place.
3. Use the IF function to identify the employees who worked for
more than 80 hours.
4. Insert two rows at the end. In A14 add Rundu Total Hours.
Use the SUMI F function, calculate only the total hours for the
employees from Rundu. Insert answer in C14.
5. Bold all calculated answers.
6. Insert Borders.
7. Increase the row height of the table from row 5 to 12 to 30
pixels.
8. Wrap Text cell 04.
9. Bold all Column Headings.
10. Print final copy on landscape.
|
|
5 Page 5 |
▲back to top |
QUESTION 4
Retrieve Question 4 - Pivot Table (List of Holidays) from your M-drive and adhere to
the instructions that follow.
MARKS:20
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 Best Buy Travel Agents
4. Insert 2 rows above the column headings.
5. Insert Main Heading in row 1 -Best Buy Travel Agents
(U/C, Bold, Merge & Centre, Arial Black, 16)
6. Edit the table as follows:
6.1 Change the font of the entire table to Arial 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 pixel 50
Wrap Text and centre the following Col headings: Nr of Days, Travel Methods, and
Holiday ID.
6.4 Resize columns headings and change the row height of the rest of the table to 25 pixels.
7. Pivot Table:
7.1 Select the Original sheet and create a PivotTable.
7.2 From the PivotTable Field List choose Number of days by Country to be displayed
in the Report.
7.3 Move Travel Method to Column Label and Country to row label and Nr of Days
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 - Best Buy Travel Agents (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.