 |
BAP721S - BUSINESS APPLICATIONS 3 - 2ND OPP - JAN 2020 |
|
|
1 Page 1 |
▲back to top |
o
NAMIBIA UNIVERSITY
OF SCIENCE AND TECHNOLOGY
Faculty of Management Sciences
Department of Management
Section Business and Information Administration
QUALIFICATION: Bachelor of Business and Information Administration
QUALIFICATION CODE: O7BBIA
COURSE: Business Applications 3
(PAPER 1)
LEVEL: 7
COURSE CODE: BAP721S
| DATE: January 2020
SESSION: 1_
DURATION: 2 Hours
MARKS: 100
SECOND OPPORTUNITY/SUPPLEMENTARY EXAMINATION QUESTION PAPER
EXAMINER(S)
Ms du Plessis
MODERATOR:
Ms Z du Plessis
THIS QUESTION PAPER CONSISTS OF 6 PAGES
(Excluding this front page)
INSTRUCTIONS
1. Answer ALL the questions.
Write clearly and neatly.
Number the answers clearly.
PERMISSIBLE MATERIALS
Examination paper.
Examination script.
|
|
2 Page 2 |
▲back to top |
QUESTION 1
MS WORD
MARKS: 20
Type the following document
SAVE AS: DIALOG 1
as
it appears.
Font
Tahoma
12.
Honourable Speaker of the National Assembly
Your Excellencies, members of the Diplomatic Corps
Members of the Media
Fellow Namibians
It is with
become
violence
a heavy
an issue
directed
heart that | address the nation today
of national concern. | am referring
against Namibian women and girls,
to talk about a matter that has
to the escalating brutality and
by Namibian men.
Since the
beacon of
Sacrifices
oasfttatbbaoiiltinhtmye,Nnatpmeioabfcieaounranmidenndseepcaeunrndidtey.nwcoem,Oeunr.oufrreceoduonmtrywashasacwhoineveaddmitrhartoiuogn,h
as a
the
It is, therefore, regrettable that hardly a day
beatings or other forms of violence against
SICKENING acts are taking place in almost
perpetrators and victims of all age groups.
passes without reports of murder,
Namibian women and girls by men.
all parts of the country, involving
rape,
These
As a result, the nation
escalating violence.
has
become
outraged
and
angry
about
the senseless
killings and
We
life
will
must remember,
shall be respected
disturb that peace
that
and
and
Ardpteriscotltreeocyt6,edo.fratthhMeeernNathmsaihnbouilabduni,ldCtohoneusrrteiftcouortuein,otnr,yr.efrsatiantesfrotmhatactthieonsr,ightthatto
It is
our
my hope, that
efforts aimed
the implementation of immediate measures,
at addressing gender-based violence, in our
will add
country.
momentum
to
Too many lives have been lost.
including women and girls!
Let’s join hands, to make our country safer, FOR ALL,
| thank you.
Apply track changes as indicated in the following document and Save As:
DIALOG 2. Compare the 2 documents. Apply the Accept/Reject changes as
indicated with (A) and (R) SAVE the Compared document as DIALOG FINAL
BAP721S
2%? OPPORTUNITY EXAMINATION
JANUARY 2020
|
|
3 Page 3 |
▲back to top |
Henourable (R)-Speaker of the National Assembly
Your Excellencies, members (A)-Members of the Diplomatic Corps
Members of the Media
Fellow Namibians
It is with
become
brutality
Namibian
(aaAnm\\he)ein_sa.csvruyueelhtoefyarntaatnidtohnaatvlio| lcaeodnndccreeersnds.iretcht|eeadmnatarigeoafnienrsrttiondgaNyatmo tiotbhietaalnkesaewbaoolmuatetinnag-ma(anAtd)tegriirlntst,heantsbiyhfaysing
Since the attainment
beacen(A)_example
through the sacrifices
of
of
of
our independence, our country has
stability, peace and security. Our
both Namibian men and women.
won admiration, as a
freedom was achieved
~
It is, therefore, regrettable
beatings or other forms of
that hardly a day
violence against
passes without reports of murder,
Namibian women and girls by men.
SICKENING acts-(R) performances (R)_are taking
country, involving perpetraters- Culprits and victims
place
of all
in-almost all-parts-of
age groups.
rape,
These
the
=
As a result, the nation
escalating violence.
has
become
outraged
and
angry
about
the senseless
killings
and
We
life
will
must remember,
shall be respected
disturb that peace
that
and
and
Ardpteriscolttereecyt6edo(.fA)thMe eanbNoalmissihhbo,uiladnr,athCteohrnesrtteihftaonurtei,bouni,rledfrsatoiauntresfcrooutmnhtatrayc.tthieonsr,ightthatto
It is my hope,
momentum to
that
our
the implementation of immediate measures(A)_ actions, will add
efforts aimed at addressing gender-based violence, in our country.
Too many lives have been lost.
including women and girls!
Let’s join hands,
to make
our country safer,
FOR
ALL,
| thank you.
INSERT
YOUR NAME IN
DOCUMENT
THE HEADER
AND PRINT
OF
ONE
THE DIALOG
COPY
FINAL
BAP721S
2"? OPPORTUNITY EXAMINATION
JANUARY 2020
|
|
4 Page 4 |
▲back to top |
QUESTION 2
MS PROJECT
MARKS 40
Open MS Project and search for the Template named
SAVE AS: EXAM
STARTUP
BUSINESS
PLAN
Follow the instructions carefully and save your work regularly.
Gantt View
Format the Gantt Chart to
Timescale Options: Show
Gantt Style, Scheduling
2 Tiers, Size 55
SAVE AS: GANTT
PRINT: 1 PAGE
Styles:
Second
Option.
—_—M¥I-
Add the following Existing Tasks to the Timeline:
New Business
MI Phase 1 — Strategic Plan
M Self-Assessment
MI Define Business vision
M1 Identify available skills
M1 Decide whether to proceed
M Define the Opportunity
Copy the Detailed Timeline, Full size to an A4
the information is clearly readable.
Landscape
Word
Document.
Make sure
SAVE AS: TIMELINE
PRINT: 1 PAGE
Display the Task Sheet, Entry
SAVE AS: ENTRY TABLE
Table
to indicate
the
Gantt
Tracking
Process
PRINT: 1 PAGE
Display the Overallocated Resources
Change both Charts to Quick Layout
SAVE AS: RESOURCES
of the
2 and
Project effectively.
apply suitable Chart
Titles
(u/c,
bold)
PRINT: 1 PAGE
BAP721S
2%? OPPORTUNITY EXAMINATION
JANUARY 2020
|
|
5 Page 5 |
▲back to top |
Illustrate the following in MS Excel (A4 Landscape)
Make sure the illustrations fit on ONE sheet.
as
per
instruction.
1.
Work Overview (2 Charts)
Resource Stats: Quick Layout 8, insert suitable Chart Title u/c and bold
Remaining Availability: 3D
Chart Title u/c and bold
Area
Chart
Type,
Quick
Layout
1, insert suitable
2.
Shapes that display
Work Hours.
%
Work
Complete,
Remaining
Work
Hours
and Actual
a
Chart to represent the
Chart type: Clustered
and bold
Milestones as part of the
Column, Quick Layout 1,
Project Progression.
insert suitable Chart
Title
u/c
SAVE AS: EXCEL
PRINT: 1 PAGE
INSERT YOUR NAME IN THE HEADER OF EACH PAGE
INSERT THE SHEET NAME IN THE FOOTER OF EACH PAGE
TOTAL PAGES TO PRINT: 5
BAP721S
2%° OPPORTUNITY EXAMINATION
JANUARY 2020
|
|
6 Page 6 |
▲back to top |
QUESTION 3
MS EXCEL
MARKS: 40
Create a A4 Landscape sheet
Font Arial 12. Insert the Main
in Excel
Heading
and insert the data below.
in size 14, bold an d the columns
centered and in bold. Save As: MOTORS
headings
Follow the instructions carefully.
PUKEWITZ MOTORS
MAKE
TYPE
NUMBER
2017
2018
SOLD
TOYOTA
FORD
NISSAN
FORD
MAZDA
NISSAN
TOYOTA
MAZDA
TOYOTA
SUV
BAKKIE
SEDAN
| SUV
BAKKIE
SEDAN
BAKKIE
SUV
SEDAN
60
50
100
905
65
95
130
45
85
400000
350000
280000
380000
320000
240000
380000
360000
300000
410000
360000
290000
385000--
330000
250000
400000
390000
330000
Sheet 1
Insert the figures with currency and 2 decimals.
Create a Custom List to sort the vehicles according to their types (Ascending).
Insert a Row Label AVERAGE (bold)
Display the Averages of the Number Sold (no decimals), 2017 and 2018. Insert the
answers in Bold.
Insert a Chart to display the information.
Change the Chart Type to Line Chart with
Insert Chart Title: MOTORS SOLD
Insert Axes Titles (Bold):
Markers
Vertical: PRICE
Horizontal: MAKE
SAVE REGULARLY
Display the Number Sold column with Icon Sets
Display the 2018 prices greater than 380000 with a Light Red fill with dark red text.
Display the 2017 prices with Data Bars.
BAP721S
28° OPPORTUNITY EXAMINATION
JANUARY 2020
|
|
7 Page 7 |
▲back to top |
Rename this sheet: ORIGINAL
Display a
number of
Rename:
summary
vehicles
NUMBER
(Name: NUMBER SOLD)
sold if these numbers were
SOLD
that reflects
increased
the influence
by 5.
on
the
Average
Create a copy of sheet ORIGINAL and create a TABLE
Delete the Chart
The 2017 vehicle prices are
Create a Scenario from this
Rename: INCREASE 2017
increased with
sheet to reflect
$5000.
the difference
in the
2017
average
figure.
Filter the 2017 vehicles that ware sold Above Average price.
Apply a two-way sort Ascending: First by Make and then by Number Sold.
Rename: ABOVE AVERAGE
ee
Insert your name in the Header of ALL 4 sheets
Insert the Sheet name in the Footer of ALL 4 sheets
SAVE and PRINT ALL 4 sheets
BAP721S
2%? OPPORTUNITY EXAMINATION
JANUARY 2020