 |
MOA611S - MEDICAL OFFICE APPLICATIONS 2A - 2ND OPP - JULY 2022 |
|
|
1 Page 1 |
▲back to top |
nAm I BI A un IVE RSITY
OF SCIEnCE TECHnOLOGY
FACULTY OF COMMERCE; HUMAN SCIENCE AND EDUCATION
Department of Management
QUALIFICATION: Bachelor of Business and Information Administration
QUALIFICATION CODE: 07BBIA
LEVEL: 6
COURSE: Medical Office Applications 2A
COURSE CODE: MOA611S
DATE: JULY2022
DURATION: 3 Hours
SESSION: FACE-TO-FACE
MARKS: 160
EXAMINER(S)
MODERATOR:
SECOND OPPORTUNITY - QUESTION PAPER
Ms L Beukes
Ms D Olivier
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 8 PAGES (Excluding this front page)
|
|
2 Page 2 |
▲back to top |
1
Question 1
Marks: 20
Bank Windhoek is organising a Fundraising event for the Cancer Association which will be in a form
of a Gala Dinner. Theme of the event is "Your Health is your Wealth".
As the Office Administrator in the Marketing Department, you have been tasked to co-ordinate the
planning process. The event date is scheduled for Saturday, the 2nd of July 2022. Planning will start
from the 6th of June 2022.
The Fundraising event team-building event is made up of the following tasks and resources:
NR NAME OFTASI<
1. Book a Venue
2. Design and send out Invitations
3. Decor arrangements
4. Entertainment & Sound System
5 Arrange for Catering
6. Master of Ceremonies
7. Media and Photographer
8. Programme Design
9. Confirm guest list and sponsors
10. Final check-ups and logistics
TASK DURATION
1 Day
3 Days
1 Day
3 Days
2 Days
2 Days
2 Days
2 Days
2 Days
1 Days
RESOURCES
Bianca
Bianca
Hilma
Carlos
Hilma
Carlos
Bianca
Carlos
Hilma
Carlos
1. The Milestones for this event will be the following:
Deposit of 60 % to be paid to:
a) Venue
b) Design and send out Invitations
c) Decor
Full Payments to be made for the:
a) Entertainment & Sound System
b) Catering
c) 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
Question 2
Second Opportunity
July 2022
QUESTION 2
MARKS: 20
In Ms Word create the following form on one sheet. Adhere to typing rules and instructions
given. Use the font Bookman Old. Please print two copies. One copy which displays the content
controls and another copy which displays the completed form with your personal detail.
SURVEY ABOUT EDUCATIONAL CHOICES <!-
U/C, Bold,Cent, font size 16
~-:±::. l:..\\"'ders..\\-o-;-~
--------- We want to &J'3f}f--ee~ay-to-uer choice$, and it is therefore important that you answer
according to what is important to you. If.you don't understand a question· ~'you may leave
\\,.-,._\\<..e.~-
th~uestion blank. No material will be !r_a_c9gjJ_I~to_ you as an individual.
N
ri
1
or if none of the alternatives are right for you
(lJ
·N.:;; ·This questionnaire contains questions about you an your cnterra, expec ations and plans
.....
C
,2
related to educational choices. First-year students at all Namibian Universities and Colleges
(lJ
Vl
are invited to participate.
:::i 'l19Li-rt-
¥9e answers are important to the study! Thank you very much!
-4:-
1.
tm a Male
Female }
P/,e•.;Jl§,ein§,e-rt:checkbo;., at t:he·
bef;'inning- of each opt:ion
2.
I I Year of birth: insert Date-oicker Use Full
ri
ri
(lJ
N
.V.l...
C
,2
(lJ
3.
4.
I I study at (name of University or College): ............................ RichText Control - Strong
·F
Degree program: ...........................
I RichText Control - Strong
Vl
::,
;:\\::-
"O
C
ro
X
0
5.
What were your first and second choice of programs in your application?
·t=-
.0
Choices: .......................................
<1. ---~
Insert dropdown list
.(.lJ...
with your two options
C
t:
6.
Approximately when did you decide on this field of study?
(lJ
Vl
C
(lJ
In primary school
Vrol
(lJ
During lower secondary school
a..
During 1st year in upper secondary school
After having studied something else.
Please insert checkboxes at
The decision emerged slowly over a long period of time
I don't know
}
the beginning of each option
The choices you make today will determine your tomorrow!!
u/c, bold,
|
|
4 Page 4 |
▲back to top |
Question 3
Marks: 30
Type the following Main Document in font Times New Roman, 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 J l<arumbe, the Excel Spreadsheet as well as the Mail merged
document.
Today's Date
«NAME»
1 «ADDRESS»
,_, «TOWN»
-(f"
0
«COUNTRY»
0
-> eC
5 DISCOUNTS, Dear Client
J
\\> t>\\ G\\L{_,\\
,5- I want to take a moment to thank you for your continued support of T~
_,I
Were it not for loyal customers like you, we would not be celebrating our -' ic__
10th anniversary on «DATE» , we will be hosting a special May Madness Sale!
_f 3.If yJ°ubuy for more than «AMOUNT» you will qualify for even more discounts.
'<!)
,
(rrChonour of the anniversmyj
<J/1(.);
7S-0
1. EvTrything in the store is available at 10 % throughout the month.
Selected speciq s will be offered for the day at higher discounts, such as:
0\\~~~d,
-~~J, Sunflower seed, Peas,Corn, Carrots, Beans'·->
u~;e&.,.\\t.,,
~>-\\IX 2.
j/ can -r-ea-J.,ie-as,n.e..ecy_~_\\!,en_g_:reater savings by bringing this lµ~,
L
letter with you when you shop.
.1=:::,u l\\-e.}):s.
.~ '
4. Present your k.2,~d
to the cashier at the check~~tfll,oint, to identify ~cJ
yourself as a VIP Customer and receive an additional -:~ISCOUNT-» off your
total bill. Ufe~~
is your ,1--
~p
for all your spring planting needs!
~d
I u\\c
e\\ i l·\\-6--\\
Ms Gloria Shoopala is the General
Manager of The Garden Shop
|
|
5 Page 5 |
▲back to top |
FIELD
NAMES
NAME
ADDRESS
TOWN
COUNTRY
DATE
AMOUNT
RECORD1
Mr J Jacobs
PO Box 140
Rundu
NAMIBIA
30 May 2022
$5000.00
RECORD2
RECORD3
Ms J Karumbe Ms A Kasevera
PO Box 220 PO Box 440
Oshakati
Windhoek
NAMIBIA
NAMIBIA
30 May 2022 30 May 2022
$5600.00
$6700.00
RECORD4
Mr P Paulus
PO Box 233
Swakopmund
NAMIBIA
30 May 2022
$7800.00
Instructions for Excel Spreadsheet:
1. Type the spreadsheet in font Comic Sans, size 12.
2. Insert N$ for all the amounts add two decimals after the comma.
3. Column Headings - Font size 14, Bold, u/c
4. Records - font size 12.
5. Row Height: Column Headings 40 pixels
Rest of Rows.30 pixels
6. Sort Surname in ascending order.
7. All Borders.
8. Print excel spreadsheet in Landscape.
|
|
6 Page 6 |
▲back to top |
~i
~ii
0
i.:~} ~)
c·;irit;
~i~; f-)
7'/c
0
,::::i
D
?~
c,;,;.--p
i\\/larr!<s: 30
In lVlsVVorcl,please DF~/:\\1Athfe following Table and complete the information iri the .. ·
font Calibri, size -12.
.'You are the secretary of a small company called
l\\lliVIPAA (Namibia Institute for Private Assistants'
Association). You are responsible for the record
keeping of all the members and receiving thei1·
membership fees and calculate their salaries.
...;-:,:
i"'
c_,_----~-----'-.....,__
_ ___,
For this purpose, you have se't up the following spreadsheet for the Finance Department:
Salary Scale: j,JJMPAA
fvlember Name
Haufiku Sarah
lpinge Aina
Aukonqo Lihah
Shikongo Launa
Thomas Leena
Van Zyl Retha
Etunda Martha
Kazapua Johanna
~Jes per Hour
150.00
175.00
125.00
140.00
85.00
65.00
120.00
-110.00
Days iiVorkin!=J
20
15
22
18
19
20
16
20
Total Salary
Adhere to ·the followinq editinq instructions for the table:
1. Draw the Table
2. Auto fit table to content.
3. Set row height to 0.3"
4. Insert the correct formula to calculate the salary for each employee.
5. Insert a Total row at the encl and calculate all the columns.
6. Sort Table according to Member Name in ascending order.
7. Convert Table to chart which only displays the:
o Member Name
o Total Salary
8. Pre-set the table: Grid Table 2, Dark Accent 1
9. Insert caption below the table: Table 1: NIM PAA Salaries.
10. Insert your name and student number in the header and print one copy.
....,::,,
f.fc
0
t5
71it
0
t'c:::7-..,
?it
0
€f)
1§
a()
'6"
ig ·cg ic r.:.~---: fj
,·I
i0'.IT:lr.
2i,~
(I
l-a:~
'
€9
?~
?C..,
Q
ta,
'
' 'I-~
|
|
7 Page 7 |
▲back to top |
6
Name
QUESTION 5
Elixir Paper
2nd Opportunity
July 2022
MARKS: 60
Start Elixir and log into the General Practice option.
The community medical clinic in Mariental, Hardap Medi Clinic, requested your assistance as Medical
Office Administrator with the setting up of their new practice. Use the following information to set up the
practice.
1.
Start by creating Service Providers for the practice.
Provider
-·
EmaiAl ddresses
Dispensing
Discipline HPCSANRCellular Dispensing Registration
DrGodfriedNamasesgnamases@iway.na GeneraPl ractitioner001365750812323568 No
.
DrAnthonyHoffman ahoffman@hotmail.coGmeneraSl urgeon 001465760812323569 Yes
4622467
DrSelmaGoreses sgoreses@africaonlineO.pnhcthamologist 001565770812323570 Yes
4612466
DrRudolphBarry rbarry@gmail.com MedicaOl ncologist 001665780812323571 Yes
4602465
2.
Create the following accounts for each patient.
•..- ..
MedicAalID
Surnamelntials irstnamEIDNUMBERSPostaAlddress Town Scheme EmaAilddress
Provider
HoebesCH Chris 2709900025P41ri0vatBeag6147 OSHAKATNI AMDEBchoebes@gmail.cDomrRudopBlharry
PretoriuSsM Selma 100880002541P0OBox889 KATIMMAULILNOHPSILVmERpretorius@nust.nDarGodfrieNdamases
MentzelSA Adele 1506820070814POBox1556 WINDHOEIKNVESTMaEmDentzel@iway.coDmrAnthonHyoffman
SomaseJsH Jeremiah12059200142P5ri6vatBeag511 OSHAKATNI MCRUBjsYomases@telecomDr.SnealmGaoreses
NekundEeN Enzy 11079300025P63OBox1556 ONGWEDIVPAROSPERenITeYkunde@gmail.DcorRmudopBlharry
3.
Insert the following Accounting groups to your Database:
3.1 Normal - White
3.2 Bad Debts - Purple
3.3 Benefits Exceeded - Blue
3.4 Overdue Payments - Green
4.
Set up the following Clinics:
4.1 Mariental Clinic
4.2 Stampriet Clinic
4.3 Empelheim Clinic
5.
Load the following Colleagues:
5.1 Dr Helga Bruintjies, HPCSA:HM3131, Referring doctor - Optometrist, Private Bag 7001,
Keetmanshoop.
5.2 Dr Alfred Mu range, HPCSA:AM3289 -Assisting doctor - Radiologist, Private Bag 771 Kalkrand
5.3 Dr Rudy Richards, HPCSA:RR8901- Referring doctor - Urologist, Private Bag 555, Windhoek
6.
Add the following medical aid numbers
(references) to the existing accounts.
Medical AID Medical Aid
Surname i:jrst namE Scheme
Number
Hoebes Chris
NAMDEB NAM7878
Pretorius Selma NHP SILVER NHP5151
Mentzel Adele INVESTMED INV1235
Somases Jeremiah NMCRUBY NMC6622
Nekunde Enzy
PROSPERITY PR02525
|
|
8 Page 8 |
▲back to top |
-,
Name
Elixir Paper
2nd Opportunity
7.
The following new service providers has joined the medical field
Details
Discipline
HPCSA
Registration
Cellular
Dispensing
Dispensing
Registration
Dr Eva Garises
Cardiologist
EG1166
0811255698
Yes
4558963
Dr Danzel Wentz
Neurologist
DW5588
0811256636
No
N/A
July 2022
8.
You have to add the following reasons to the Rejection list.
8.1 Account in Arrears
8.2 Insufficient Funds
9.
Select the Account group "Overdue Payment" and place a financial block on it.
9.
Please create a new practice template called Overdue Payment and type the following details on
it.
<PATIE1'1Tf ITLE> <PATIENTFIR.STNAlv!E> <PATlENTSURNAl.vfE>
<ADD RE SSA>
<ADD RES SB>
<POSTAL CODE>
Dear <PATIENTTII'LE> <PATIEN""TSURNAi.'v!E>
The above invoice for N$1520-00 hasrecentlybecome overdue for payment. As such. we \\Vould
appreciate you making this payment as soon as possible.
If there is an error on our pan and payment has been made, please contact me immediately so that the
matter can be rectified.
Othenvise, if there is a problem paying this amount owing, please contact me so that an alternative
arrangement for payment can be made.
Yours sincerely
DrS Blom
(Student nr and full name)
10. Use the Mail Merge function and Merge the account of Enzy Nekunde with this letter. Type your
student number and name in brackets at the end of the letter and print a copy.
|
|
9 Page 9 |
▲back to top |
Name
Elixir Paper
2nd Opportunity
July 2022
11. From your existing accounts, please open the following accounts and add the following children as
dependants on their accounts.
MAIN MEMBER
Adele Mentzel
Chris Hoebes
DEPENDANT
Abigail Mentzel
Date of Birth: 12 December 2005
Allergies: Citric Acid
Brandon Hoebes
DOB: 6 May 2005
Allergies: Ibuprofen
DEPENDANT
Rueben Mentzel
DOB: 25 March 2012
Allergies: Atenolol
12. Make the following appointments in the Elixir Diary
121 Jeremiah Somases phone the practice for an appointment for a normal consultation with Dr
Hoffman 8th August2022 at 08:00.
12.2 A new patient Ms Vivian van Wyk, walks into the practice, he has not been there before. Book an
appointment for him for 26th September 2022 at 14:00 with Dr Goreses.
12.3 Make a new appointment for Mr Susan Zimmer (a new patient) Cell: 0812525987 with Dr Namases
on the 7th September 2022 at 11:00
12.4 Jeremiah Somases phoned back and wanted a longer appointment. Please extend the
appointment until 9:00
12.5 Ms Vivian van Wyk called back; unfortunately, she is not able to make the appointment for the
26th September 2022 due to work commitments. Please move the appointment to Friday, the
same week.