 |
BAP611S - BUSINESS APPLICATION 2A - 2ND OPP - JULY 2024 |
|
|
1 Page 1 |
▲back to top |
nAmI BIA unIVE RSITY
OF SCIEn CE Ano TECHn OLOGY
FACULTYOF COMMERCE;HUMAN SCIENCESAND EDUCATION
DEPARTMENTOF GOVERNANCE& MANAGEMENTSCIENCES
QUALIFICATION: Bachelor of Business and Information Administration
QUALIFICATION CODE: 07BBIA
LEVEL: 6
COURSE: Business Applications 2A
COURSE CODE: BAP611S
DATE: July 2024
DURATION: 2 Hours
SESSION: Practical Paper
MARKS: 100
EXAMINER(S)
MODERATOR:
SECOND OPPORTUNITY - QUESTION PAPER
Ms L Beukes
Ms Petrina Witbeen
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 |
Question 1
Marks: 30
Academic research seminars focus on instruction that is designed for the attendee or participant to gain
specific knowledge within the academic area. As the project co-ordinator you have the responsibility
to co-ordinate this project to organise the quarterly research seminar for the department. This event
will take place on the 3rd August 2024. Please start planning least from the 1st July 2024.
NR NAME OF TASK
1. Define the Seminar's Objectives
2. Book a Venue (NUST-Auditorium 1)
3. Identify Target Audience
4. Develop Curriculum
5. Discuss the Budget and secure funding
6. Gather Resources
7. Prepare Snacks and Beverages
8 Schedule Sessions
9. Printing of Programmes
10. Media and Photographer
11 Prizes for Participants
12. Programme Facilitator
13. Confirm Participants
14. Final check-ups and logistics
TASK
RESOURCES
DURATION
1 Day
1 Day
2 Days
2 Days
2 Days
2 Days
3 Days
2 Days
2 Days
2 Days
1 Day
2 Days
2 Days
1 Days
Adelaide
Philemon
Chris
Chris
Philemon
Adelaide
Adelaide
Chris
Chris
Philemon
Chris
Adelaide
Philemon
Chris
1. The Milestones for this event will be the following:
Deposit of 70 % to be paid for the:
(a) Venue
(b) Printing of Programmes
(c) Prizes for Participants
Full Payments to be made for the:
(a) Snacks and Beverages
(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 (Autofit to 1).
|
|
3 Page 3 |
▲back to top |
·2-
Question 2
July 2024
Question 2
Marks: 40
As Office Administrator of Comfort Tours, type the following Main Document in font Arial,
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 R Nitzborn, the Excel Spreadsheet as well as the Mail merged
document.
<<Name>>
<<Address>>
<<Town>>
<<Country>>
Typist, the address below is
the sender's address. Please
type in the correct position.
Comfort Tours, PO Box 123,
Swakopmund, NAMIBIA
Today's date
Dear< <Salutation>>
TOUR: <<Adventure > >
Thank you for your questioning regarding our tours of the <<Adventure > >. To
ensure that you receive a true value-for-money package, the following points are
brought to your attention.
2.We include <<Inclusive>> in your itinerary. 3. The tour price
includes <<Special>> arrangements and entertainment.
1.0ur agency guarantees centrally located hotels in most cities
Please type in
>- chronological
order, D/S
and towns. Taxi fares alone could cost you < < Cost> >each way.
Our Comfort Tours are renowned as the best value-for-money in <<Destination>>.
Yours faithfully
also sign this letter. Please end of
the letter properly.
|
|
4 Page 4 |
▲back to top |
Database for Excel:
3
Question 2
July 2024
NAME
ADDRESS TOWN
COUNTRYSALUTATION ADVENTURE
COST INCLUSIVE
SPECIAL DESTINATION
Mr JJacobs POBox140 RUNDU
Namibia DearMr Jacobs SafariTour
N$200,00 Hiking
Dinner Tanzania
Mr PPetrus POBox233 SWAKOPMUNDNamibia DearMr Petrus PhoptographTyour N$5DO,OOSightseeing
Breakfast Holland
MsATjivi
POBox440 WINDHOEK Namibia DearMsTjivi
TuscanyWineTour N$300,00 Excursions
Lunch Italy
MsJ Karumbe POBox220 OSHAKATI Namibia DearMsKarumbe RhineRiverCruise N$600,00 Exploringthecity Lunch Germany
Ms RNitzborn POBox589 OKAHANDJA Namibia DearMs Nitzborn British Island
N$700,00 Daytours
Breakfast Europe
Instructions for Mailing List:
1. Type the spreadsheet in font Calibri, size 10.
2. Insert N$ for all the amounts add two decimals after the comma.
3. ColumnHeadings - Font size 10, Bold, u/c
4. Records - font size 11.
5. Row Height: Column Headings 40 pixels
Rest of Rows.30 pixels
6. Sort Town in ascending order.
7. Insert all borders.
8. Print excel spreadsheet in Landscape.
|
|
5 Page 5 |
▲back to top |
Question 3
Marks: 30
TECHNQl_OGY ~0
In Ms Word, please DRAWthe following Table and complete the information in the
font Arial, size 12. You are the secretary of a company called Namibia Connect
Technologies. As Office Administrator you are responsible for the purchasing and
ordering of the products.
For this purpose, you have set up the following spreadsheet for the Finance Department:
Sales: Namibia Connect Technologies
Products
Routers
Switches
Modems
Motherboards
Mice
Graphics Processing Unit
Keyboards
Touch pads
Quantity
160
185
130
145
145
65
145
120
Cost Price
360
900
540
1800
90
2700
1080
720
Total Cost
Adhere to the following editing instructions for the table:
1. Draw the Table
2. Auto fit table to content.
3. Set row height to 0.3" and bold column headings.
4. Insert the correct formula to calculate the total cost for each product.
5. Insert a Total row at the end and calculate all the columns, and bold answers.
6. Sort Table according to Product in ascending order.
7. Convert Table to chart which only displays the:
• Products
• Total Cost
8. Pre-set the table: Grid Table 2, Dark Accent 1
9. format Chart:
9.1 Insert Chart Title: Namibia Connect Technologies (u/c, Bold, cent).
9.2 Insert Gridlines.
9.3 Select Style 4 for the chart.
9.4 Insert Legend to the right.
10. Insert caption below the table: Table 1: Namibia Connect Technologies (Bold)
11. Insert your name and student number in the header and print one copy.