 |
BAP521S - BUSINESS APPLICATIONS 1B - 1ST OPP - NOVEMBER 2022 |
|
|
1 Page 1 |
▲back to top |
nAmlBIA unlVERSITY
OFSCIEnCEAno TECHnOLOGY
FACULTY OF COMMERCE; HUMAN SCIENCEAND EDUCATION
DEPARTMENT OF GOVERNANCE & MANAGEMENT SCIENCES
QUALIFICATION: BACHELOR OF BUSINESS AND INFORMATION ADMINISTRATION
QUALIFICATION CODE: 07BBIA
LEVEL: 5
COURSE: Business Applications 1B
COURSE CODE: BAP521S
DATE: NOVEMBER 2022
DURATION: 2 Hours
SESSION: PRACTICAL
MARKS: 100
EXAMINER(S)
MODERATOR:
FIRST OPPORTUNITY - QUESTION PAPER
Ms S Klaassen
Ms L Beukes
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.
6
THIS TEST PAPER CONSISTS OF~ PAGES (Excluding this front page)
|
|
2 Page 2 |
▲back to top |
QUESTION 1
[30]
Use MS ACCESS to create a Table in Design View. Save your TABLE as STAFF
INFO with your Name and Surname.
TITLE
Ms
Mr
Prof
Dr
FIRST
NAME
Louwna
Colin
Stephanus
Jenny
Ms
Charne
Prof Rowlan
LAST NAME
Bezuidenhout
Shi pa la
Shipanga
Amupanda
Shimwino
Simpson
ADDRESS
Ausspannplatz
Olympia
Academia
Otjomuise
Khomasdal
Katutura
RANK
Secretary
Secretary
Lecturer
Head of
Department
Personal Assistant
Registrar
YEARS
EXPERIENCE
12
15
10
5
12
7
• All Data types are SHORT TEXT.
• PRIMARY KEY: Last Name.
• Print the table in A4-Landscape
• Make a copy of the table and name it STAFF INFO FINAL and continue with the alterations in the
new table:
• Change the font of the table to Calibri, font size 12 and italics.
1.
Insert an NEW FIELD called SALARY between RANK AND YEARS EXPERIENCEwith the
following records:
Record 1:
Record 2:
Record 3:
Record 4:
Record 5:
Record, 6:
N$20 000
N$20 000
N$40 000
N$40 000
N$30 000
N$80 000
2.
Ms Sharifa Abrahams was added to the staff as Lecturer, with a salary of N$30 000. Her
address is Windhoek West. Years of experience, 2 years.
3.
Rename the field: LAST NAME to SURNAME and sort in descending order.
4.
Rename the field: ADDRESS to TOWN.
5.
Add black grid lines to both table.
6.
Apply an alternate background colour, light grey to the table.
7.
Print a copy of the table in LANDSCAPE.
2
|
|
3 Page 3 |
▲back to top |
QUESTION 2: POWERPOINT
[30]
Create the following PowerPoint presentation by using the information provided
below. Follow the instructions carefully. Use the default font and font size except
where otherwise indicated. Save our work as: QUESTION 2.
1. Use the CIRCUIT DESIGN for this presentation.
2. Change the background style to style 1.
3. Please ensure that you have 4 slides.
4. Make sure that you follow all instructions.
5. Print all slides in landscape on 4 separate pages.
SLIDE 1: INSERT A TITLE SLIDE
• Main heading: JUSTINE
]
• Sub Title: THE BEST IN BEAUTY FOR 49 YEARS
/ulc, bold, cent, font
LUC/DA BRIGHT, font size
48 for both headings
SLIDE 2: INSERT A TWO CONTENT SLIDE
Type: We're giving you the best of science & nature with our nourishing original
Tissue Oil, Fine Fragrances & advanced formulated skincare to enhance
your skin
• Insert a picture of a Justine Tissue Oil bottle from Google Chrome on the
left.
• Type the following next to the picture:
use font
Calibri, font
size 32
Centre all
information
Real ingredients
] upper case, centre
Formulated with Vitamin & Botanicals
SLIDE 3: INSERT A TWO CONTENT SLIDE
Heading: PRODUCTS TO OFFER
/ bold, cent, font Tahoma, font size 36
Hair products
Lady's Perfume
Men's Perfume
Day and Night Creams
Bath Care
Skin Care
Range from as little as N$50
Order from your Agent
Made exclusively for you
*Insert Hollow
Square bullets to all
the information on
the left and right
SLIDE 4: INSERT A TITLE SLIDE
MAIN HEADING:
JUSTINE
cent, font Lucida sans, font size 54
SUB HEADING:
Made for you by South Africans for Southern
African's since 1973
Please type your name and
surname in the footer
u/c,font
Lucido Sans,
font size 32
3
|
|
4 Page 4 |
▲back to top |
QUESTION 3: MS EXCEL
[30]
Design the following table in MS EXCEL and edit it accordingly. Use font CALIBRI
12. Please adhere to all instructions given. Save the document as QUESTION 3.
BLUE BELL BEAUTY PARLOUR
DESCRIPTION
PRODUCTS
Reduce the look of redness
Smooth expression line
Peach and orange blossom
Pine-apple, Apricot & Coconut
Every day is an occasion
Stylish and active
TOTAL
TAX
Tissue Oil
A-Firm Day Cream
Bella Body Spray
Celestial Eau de Parfum
Elegant Handbags
The Ash smartwatch
15%
UNIT
PRICE
200
300
50
350
200
900
NUMBER TOTAL
SOLD
PRICE
20
50
20
15
25
10
INSTRUCTIONS
1. Merge and centre cells A1 :E1. Change heading to bold and font size 16.
Adjust row height to 40 pixels.
2. Highlight cell A2:E2 and change to bold. Wrap text where necessary. Centre
vertically and horizontally. Adjust ow Height to 30 pixels.
3. Row Height for the rest of the document, 20 pixels.
4. Calculate the TOTAL PRICE for each row.
5. Total the columns: Number Sold and Total Price.
6. Calculate the tax on the TOTAL of the TOTAL PRICE column.
7. Insert the $-sign and except for the NUMBER SOLD column.
8.
No decimal places.
CHART
1. Insert a new sheet and rename it Blue Bell.
2. Use the information in sheet 1 B2:B8 and B2:D8 to create a 2D Stacked Column
Chart.
3. Insert a Title to the chart: BLUE BELL BEAUTY PARLOUR, in upper case and
crentre.
4.
Choose style 10 for the chart.
5. Print both documents in PORTRAIT.
4
|
|
5 Page 5 |
▲back to top |
QUESTION 4: TEMPLATE
[20]
Type the following MEMO in proper style. Insert the template MEMO (SIMPLE
DESIGN) to prepare the document. Use the Hanging format for paragraphs. Type
you name and student number in the header. Adhere to the manuscript signs. Save
the document as QUESTION 4.
memo
LEMON TREE HOTEL
/ulc, cent, bold, font Arial 24
To:
From:
CC:
Date:
Re:
Mark Carmichael
George Forman
Jan Brandt, Louise Jansen, Johannes Mfuni
2 October 2022
Partnership planning meeting
!type in uppercase
Commenr·The meeting will take place in the Boardroom on Monday, 10 October
2022 at 09:00.
*insert
Please be on time.
-~
l-L16
1. Apties for absence
2. Minutes of the last meeting
3. Matters arising:
3.1 Decoration of premises for tenders.
4. Correspondence
Use font Arial, font size
ct/$
12 for the whole
document
Type all underlined
headings in upper case
4.1 Letter from LASKI - Loan Fund.
~,15{5Financial report on partnership accounts: Treasurer to identify salient
aspects:-b_
lS\\s
Expansio?; of business: Discussions of proposal to enlarge partnership.
Proposal by Mark Carmichael that junior consultant, Tom Brooks, be
taken into partnership, thus bringing / number of partners to§.
/ type in full
7. { Da~next
b \\S Tuesday.
meeting: Avoid dates of King's holiday. Members prefer a
5