 |
BAP521S - BUSINESS APPLICATION 1B - 1ST OPP - NOVEMBER 2023 |
|
|
1 Page 1 |
▲back to top |
nAmlBIA unlVERSITY
OF SCIEn CE Ano TECHn OLOGY
FACULTY OF COMMERCE, HUMAN SCIENCESAND EDUCATION
DEPARTMENT OF MANAGEMENT
QUALIFICATION: BACHELOR OF BUSINESS AND INFORMATION ADMINISTRATION
QUALIFICATION CODE: 07BBIA
LEVEL: 5
COURSE CODE: BAP521S
COURSE NAME: BUSINESSAPPLICATIONS 1B
SESSION: NOVEMBER 2023
PAPER: PRACTICAL PAPER
DURATION: 2 HOURS
MARKS: 100
FIRST OPPORTUNITY EXAMINATION - QUESTION PAPER
EXAMINER(S) Ms. S. Klaassen
MODERATOR: Ms. L. Beukes
INSTRUCTIONS
1. Answer ALL the questions.
2. Start each question on a new document and print on a
separate A-4 sheet
THIS QUESTION PAPER CONSISTS OF 9 PAGES (Including this front page)
|
|
2 Page 2 |
▲back to top |
QUESTION 1: PARAGRAPHS
[20]
Type the following PARAGRAPHS according to the display rules. Pay attention to
all manuscript instructions. Use the hanging format for paragraphs. Use margins
of 1" on both sides. Use font, Arial, font size 12. Save your document as
question 1, your name and student number.
Suicide Prevention
4::-
connection
(
ulc, bold, font size 16, cent
Search for a Suicide Prevention Picture on
Google Chrome, similar to the one on the left on
and insert it under the topic. Format the picture
to 1" left and riaht.
A·pu
ensive health approach to suicide prevention can
/trs
decrease risk.
/bDilJf is a serious public health problem that car/have long-lasting effects o_n
individuals, families, and communities. The ood ~ws is that suicide is / und.,,
p~.:4=:
1. Strategies to Prevent Suicide
,,--41 6c0\\ol
1.1 Stren then economic support
L~C... ) un<l
1.1.1 Improve household financial security.
1.1.2 Stabilize housing.
1.2 Create protective environments
l. / Reduce~ to lethal means among persons at risk of suicide.
'(\\. /,,;J;2, .,Createhealthy organizational policies and culture.
.
eevder- ~cl
/, 2,~Reduce substance use through ~m-mun~sed
policies and practices.
2
|
|
3 Page 3 |
▲back to top |
1.3 ~ove acce~ynd delivery o_tsuicide car~
1.3.1 Cover mental health
in health insurance policies.
/ $ f' .
1.3.2 Increase provider availability in underserved areas.
1.3.3
1.3.4
Provide rapid and remote access to help.
.self covilt'o/
- --- Create safer st1-icideca~ through systems change.
3
|
|
4 Page 4 |
▲back to top |
QUESTION 2: EXCEL
[30]
Create a SPREAD SHEET with the following information. Follow all instructions.
Use font Calibri, 12. Save your document as QUESTION 2.
Excelsior Motor Limited (PTY)
I ulc
Comparative Export Figures for 2022 and 2023
/u/c
Country
Germany
France
Holland
Italy
Belgium
Norway
Sweden
TOTAL
AVERAGE
Saloon and Cars Estate
2021
2022
10560
9899
8288
8190
870
68
780
768
525
583
221
45
350
300
Sport Cars/Racina Cars
2021
2021
357
291
168
150
761
75
65
54
52
48
186
40
268
155
4
|
|
5 Page 5 |
▲back to top |
1. Merge and centre cells: A1 :E1. Bold and font size 16. Row Height 40.
2. Merge and centre cells: B1:E1. Bold and font size 14. Row Height 30.
3. Merge and centre cells: A3:A4. Font size 14.
4. Merge and centre cells: B2:B3 and B4:B5. Font size 14. Row Height 30.
5. Centre the years in italics. Row height 20.
6. Calculate the totals for every column.
7. Calculate the averages to 2 decimal places for every column.
8. Bold all Calculations.
9. Row Height from A5:E13 should be 20 pixels and Column Width, 15 pixels.
10. Insert borders.
11. Insert a new sheet and rename it CHART. Highlight cells A3:D13 and insert a
30 Clustered CHART. Change the Chart title to EXPORT FIGURES. Change
the chart to chart style 3.
12. Move the chart to the Chart sheet.
13. Print one copy of the Excel sheet and one copy of the Chart in portrait.
5
|
|
6 Page 6 |
▲back to top |
QUESTION 3: DATA BASE
[30]
Create a DATA BASE with the following information. Follow all instructions.
Save your document as CLIENTS and your name.
• All data types are SHORT TEXT
• PRIMARY KEY: First Name.
RECORD TITLE FIRST
NAME
SECOND
NAME
ADDRESS
CITY
COUNTRY
1
Mr
Katriena Tjongarero P/Bag 56
Kombat
Namibia
2
Mr
Blanche De Koe
PO Box 178 Karasburq
Namibia
3
Mrs Wavlene Volkwvn
PO Box 79 Gideon
Namibia
4
Mrs Veronica Vermeulen PO Box 89 Outjo
Namibia
5
Mrs Alfonsina Nanqolo PO Box 498 Noordoewer
Namibia
6
Ms
Denise
Malqas
P/Baq 15
Okahandja
Namibia
7
Dr
Aurelia
Nobrega
P/Bag 78
Keetmanshoop Namibia
1. Make a copy of the table and name it CLIENTS FINAL and your name.
2. Change the font of the Table to ARIAL, font size 12 and ITALICS.
3. Change the ROW HEIGHT to 30.
4. Change the field SECOND NAME to SURNAME.
5. Add another field: POSITION and complete the records.
RECORD
1
2
3
4
5
6
7
POSITION
Senior Advisor
Junior Advisor
Secretary
Secretary
Sales Representative
Sales Representative
Advisor
6. Add another client: Prof John Swartz, PO Box 123, Windhoek, Namibia,
Director.
6
|
|
7 Page 7 |
▲back to top |
7. The first name of Mr de Koe is wrong, change it to Barend.
8. The title of Katrina should be changed to Ms.
9. Sort the surnames in the ascending order.
10. Add black grid lines.
11. Auto fit all columns to show information clearly.
12. Create a REPORT on the final table and name it REPORT with your name.
13. Print the original table, them and the report in LANDSCAPE.
7
|
|
8 Page 8 |
▲back to top |
QUESTION 4: POWER POINT
[20]
Create the following PowerPoint presentation by using the information provided
below. Follow the instructions carefully. Save our work as: QUESTION 4.
Use the WISP DESIGN slide and style 1.
Use the default font.
Follow all instructions.
SLIDE 1: TITLE AND CONTENT SLIDE
Main Heading: CYBER SECURITY
u/c, bold, font Algerian,
size 60
Search for "Security Picture" on goog/e Chrome
similar to the one on the left and insert it under the
above information.
Centre the picture, Format to fit in space.
8
|
|
9 Page 9 |
▲back to top |
SLIDE 2: TITLE AND CONTENT SLIDE
Main Heading: STAY PROTECTED
u/c, bold font size 48
Sub Title: With so much happening in our lives online,
it's essential to stay safe as you surf the Internet.
These measures are relevant for your laptops,
tablets, phones, and desktop computers:
Type in single with
double line-spacing in
between
Font size 36
SLIDE 3: COMPARISON SLIDE
MAIN HEADING: MEASURES
ulc, bold, font size 48
HINT
ulc, bold
DESCRIPTION
ulc, bold
>-Keepyour software up to date
Minimizing potential hacking
Use a password generator
Update passwords regularly
Use the -1-<
default
font and
font
size
Multi-factor authentication is a must
Avoid public WIFI
Regularly backup your data
Generate two-steps verification codes
Public WIFI is trouble
Follow the 3-2-1 backup rule
Please type your name and surname in the footer in font size 20.
Print ALL slide in landscape.
9