 |
MOA611S - MEDICAL OFFICE APPLICATIONS 2A - 1ST OPP - JUNE 2022 |
|
|
1 Page 1 |
▲back to top |
nAm I BIA un IVERSITY
OF SCIEnCE Ano 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: JUNE 2022
DURATION: 3 Hours
SESSION: FACE-TO-FACE
MARKS: 160
EXAMINER(S)
MODERATOR:
FIRST 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 PAPER CONSISTS OF 8 PAGES (Excluding this front page)
|
|
2 Page 2 |
▲back to top |
1
Question 1
Marks: 20
As the Office Administrator in the Marketing Department of lndongo Motors, you have been tasked
to co-ordinate the planning process for their annual event for the Father-son team building. This
fun but relationship building event is scheduled for Saturday, the 6th August 2022. Preparations for
the planning will start from the 11th July 2022.
The planning of the event is made up of the following tasks and resources:
NR NAME OF TASK
1. Book a Venue
TASK DURATION
1 Day
RESOURCES
Angela
2. Set up a Budget
2 Days
Clemens
3. Music and Entertainment
4. Confirm Keynote Speaker
3 Days
2 Days
Selma
Selma
5. Arrange for Prizes
6 Catering Arrangements
7. Master of Ceremonies
8. Photographer and Media Coverage
9. Printing of T-shirts
10. Final check-ups and logistics
3 Days
2 Days
2 Days
2 Days
2 Days
1 Day
Clemens
Selma
Angela
Selma
Clemens
Angela
1. The Milestones for this event will be the following:
Deposit of 60 % to be paid to:
a) Music and Entertainment
b) Photographer
c) Printing ofT-shirts
Full Payments to be made for the:
a) Venue
b) Prizes
c) Catering
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 |
2
Question 2
Marks: 20
Use MS Word to type the following template and table. Adhere to all the
instructions.
1. Please open the MS Word template called Flyer accessibility guide.
2. Event Title - Pizza Specials
3. Event Subtitle - Delete with space.
4. Date/Time - 25 May 2022, 18:00
5. Address - DEBONAIRS, MAERUA, WINDHOEK.
6. Use the draw table tool to create the table and type the text in the font
Colonna MT, font size 12, as shown in the template below.
FLAVOURS
BBQ Chicken
Hawaiian
Margarietha
Meaty Special
Sweet & Sour
QUANTITY
7
10
8
12
15
COST
PER
UNIT
65.00
90.00
75.00
46.50
68.00
TOTAL
COST
Adhere to the following editing instructions for the table:
1. Draw the Table
2. Auto fit to content
3. Align Table: Right with a positioning of 0.2" between the text and the table.
and the row height 0.3"
4. Increase row for Column Headings to insert a wrap text for Cost per Unit &
Total Cost.
5. Column Headings: Bold, u/c
6. Perform the following Calculations: Total Cost for all the Pizzas
7. Add a Total row at the bottom to calculate the totals of all the columns.
8. Type the following text in Colonna MT, size 12 to fit next to the table:
9. Save the document as Question 1 - Flyer Pizza Specials and your name in
brackets).
At Debonairs, we offer our customers the hottest and freshest pizzas with
abundant toppings and amazing sauces. We are committed to providing
our customers with value-for-their money. At Debonairs, we bring people
together. Try something amazing!
|
|
4 Page 4 |
▲back to top |
Question 3.
Type the following lnformacional Letter as the Main Document, as a standardised
letter for your clients. Use the table below to create a mailing list of all the clients.
Merge the two documents to create a personalised letter. Use font Arial, size 12.
Print only the letter for Zelda Abrahams, the Mailing List as well as the 1\\/lailmerged
document.
··
·)
Dear Sir or Madam
Today's Date
Personnel Number: «STAFF NR»
Surname: «FAMILY NAME»
First Name: «NAME»
Date of Birth: «BIRTH DA TE»
Tin Number: «TIN NR»
----
res'--\\\\~~nt
You receive a housing ~l!.o_l!V~Ha:iSs eper your salary "1/and receive a tax benefit on
one third of that amou~,
\\7C\\ijM~T Ghe tax benefit is calculated on the lesser of your actual month Iv_rental or bond
repayment 0R-th&-Gmo.1Jr-Ft-o-f~1{)i:li"'-Cl'HGwSaht'olBueld. your allo .once e><ceedthe
~&y+m,l"ri'/actual
--~~-- -------- expense, you' will be fully taxed on the 6-~i~d"e~ohea.\\mount.
We have calculated the~~~':-~~ amount for you and
rc;,,_,j below are the
M.e.-t\\'\\-S.
amountfs:'.0-t'~- ~o--b<eie.fn_,.:o:,mpleted
as
housing
.9Il~..9Qse and other ~l~-.9~<w:.h~en you complete
your i~~__________,
'--------'
,v
Because of the new changes we need to categorise ·i-heexcess housing
allowance amount as other allowance as it is fully ta><able.·(:-------
Housing allowance
Other allowance (Housing Excess)
Total Housing allowance as per PAYEScertificate.
«HOUSING»
«OTHER»
«TOTAL»
1se attach
return.
a copy of this lette1~ i·o your return when submit-ting your 2022
TYPIST:
Please use the drawing tool to draw a table
and insert the information.
'
|
|
5 Page 5 |
▲back to top |
STAFFNR
100252545
100252546
100252547
100252548
100252549
FAMILY
NAME
NAME
Davids
Gerson
Abrahams Zelda
Green
Felix
Tjitunga
Aletta
Jansen
Helmut
MAILING LIST
BIRTH
TIN NR
DATE
HOUSING
25-Jan-88 TIN1254 90,624.28
30-Apr-89 TIN1255 90,625.29
15-Jun-90 TIN1256 90,626.30
20-Aug-91 TIN1257 90,627.31
10-Oct-92 TIN1258 90,628.32
OTHER TOTAL
89,953.44 180,577.72
90,953.44 181,578.73
91,953.44 182,579.74
92,953.44 183,580.75
93,953.44 184,581.76
INSTRUCTIONS
Table in Excel:
1. Use Font Calibri, 12
2. Column Headings: Bold, u/c, size 14, Row
Height: 35
3. All Borders
4. Rest of row: Row Height: 30
5. Add N$ to all the amounts.
6. Print Mailing List in Landscape.
|
|
6 Page 6 |
▲back to top |
5
QUESTION 4
fVIARKS: 30
Retrieve Question 4 - Pivot Table (Car Sales) from your M-drive and adhere to
the instructions that follow.
Instructions:
1. Retrieve the following table in Excel and save the workbook as: Question 4 -Pivot Table.
2. Rename sheet1 to Original.
3. Make a copy of table in Original and rename the new sheet as Car Sales.
4. On the Sheet of Car Sales, insert 2 rows above the column headings.
5. Insert Main Heading in row 1 - Namibian Car Dealers - 2022.
(U/C, Bold, Merge & Centre, Comic Sans, 16).
6. Edit the table as follows:
6.1 Change the font of the entire table to Comic Sans font size 12.
6.2 Change the column headings to font size (12), bold, u/c.
6.3 Fill Column Headings (White Background 1, Darker 5%) row height pixel 50.
7. Resize columns headings and change the row height of the rest of the table to 35 pixels.
8. Select the Original sheet and create a PivotTable.
9. Rename new worksheet as Report.
10. From the PivotTable Field List choose Final price by Agency to be displayed in the Report.
10.1 Move Values to Column Label and Colour and Angency to row label.
11. Create a PIE chart from the Table.
11.1 Insert Chart Title - NAMIBIAN CAR SALES (Bold, u/c).
11.2 Select Style 9 from the chart styles.
11.3 Make sure both the table and chart fit on one sheet and print.
11.4 Insert your name and student nr in the header before printing.
11.5 Please print the Original, Formatted Table as well as the Report.
|
|
7 Page 7 |
▲back to top |
6
Name
QUESTION5
Elixir Paper
l51 Opportunity
MARKS: 60
June 2022
Start Elixir and log into the General Practice option.
Medipark Ongwediva, recently opened their doors. You are privilege to be their first Medical
Office Administrator to help them set up their new practice. Use the following information to set
up the practice. Please add column heading from the customize property list the columns that are
missing.
1. Start by creating Service Providers for the practice.
I
Provider
""••H••-•--••••
.._...._.__._,____,_._·····--•··•··-- ·····
EmaiAl ddresses
Discipline
Dispensing
HPCSANR Cellular Dispensing Registration
DrSiebertHangula shangula@grnail.comGeneralSurgeon
DrDanielWolff dwolff@mweb.na Homeopath
00656568 0812323561 Yes
00756569 0812323562 Yes
4562461
I·
4572462
DrGeraldGreen ggreen@iway.na MedicalOncologist 00856570 0812323563 No
-
..DrBrianBlake
DrSelmaLutz
bblake@hotmail.com Neurologist
slutz@africaonline.naOptometrist
00956571 0812323564 Yes
00106572 0812323565 No
4592464
-
DrZeldaKotze
zkotze@gmail.com OccupationaTl herapist 00116573 0812323566 Yes
'
'
'
4602465
2.
Create the following accounts for each patient.
MA"•--•~- ,,M.,.... •~••-•·"-
ISurnamelntials Firstname IDNUMBERSPostaAl ddress
loshile s Shameema150380002154P0OBox9700
Town
MedicaAl ID
Scheme
,.,,,N,,,,,,.,,,,,_.,,,,.,_,
•-•
EmaiAl ddress
Provider
WINDHOEK HERITAGHEEALToHshiles@mweb@naDrSiebertHangual
IMentoor S Sunde 2002882589001POBox401 SWAKOPMUNNDHPGOLD mentoors@mweb.naDrDanieWl olff
NiizimbaN Joeline 1203900010235POBox571 OHANGWENANMCSAPHIRE jniizimba@gmail.comDrGeraldGreen
AshikonoF Fiina
101280002525P1OBox1041 WINDHOEK NHPBRONZE fashikono@iway.comDrBrianBlake
AssegaaiG Gert
1501750012457POBox235 SWAKOPMUNCDOMPLIMEPDLUSassegaaig@nust.na DrSelmaLutz
Menette C Carlos 2604450001245POBox731 SWAKOPMUNMDETHEALTH cmenette@gmail.comDrZeldaKotze
3.
Insert the following Accounting groups to your Database:
3.1 Normal - White
3.2 Bad Debts - Yellow
3.3 Paper claims - Green
3.4 Handed over- Blue
4.
Set up the following clinics:
4.1 Ashivolo Clinic
4.2 Medi Clinic
4.3 Public Clinic
5.
Load the following Colleagues:
5.1 Dr Fran Steyn, HPCSA:ST40045, Referring doctor - Biokinetics, Private Bag 7896, Oshakati
5.2 Dr John Johnson, HPCSA:JJ8989-Assisting doctor- General Surgeon, Private Bag 676,
Otjo.
5.3 Dr Uys Gerber, HPCSA:UG8901-Assisting doctor-Anaesthetist, Private Bag 770,
Windhoek.
|
|
8 Page 8 |
▲back to top |
7
Name
6.
Elixir Paper
June 2022
1'1 Opportunity
Add the following medical aid
numbers {references) to the existing
accounts.
;
Medical AID
Surname Firstname Scheme
Oshile Shameema PROSPERITY
'·
Medical Aid
Number
PROS500672
Mentoor Sunde
HERITAGEHEALTH HERS00673
Niizimba Joeline
NHPGOLD
NHP00674
Ashikono Fiina
NMCSAPHIRE
NMC500675
Assegaai Glodina
NHP BRONZE
NHPS00676
Menette Carlos
COMPLIMED PLUS COMS00677
7. The following new service providers has joined the medical field
Details
Discipline
HPCSA Registration
Cellular
Dispensing
Dispensing Registration
Email Address
Dr Samuel Scheepers
Neuro Surgeon
SS0066
0811255698
Yes
4558963
sscheepers@gmail.com
Dr Mercy Geibeb
Optometrist
MG0778
0811256636
No
N/A
mgeibeb@mweb.na
8.
You have to add the following reasons to the Rejection list.
8.1 Insufficient Funds
8.2 Limits Exceeded
9.
Select the Account group "Paper Claims" and place a financial block on it.
10. Please create a new practice template called Missed Appointment and type the following
details on it.
rr==================================~
<PATIENTTITLE> <PATIENfFIRSTNAME>
<ADDRESSA>
<ADDRESSB>
<POSTALCODE>
<PATIENTSURNA.!\\IIE>
Dear <PATIE1'-1TTITLE> <PA TIENfSURNAME>
We notice.d that you have missed your appointment at the iviedipark Ongwediva Care Centre on
the day of 29 April 2022. ·vve have attempted to contact you by phone and have been unable
to reach you.
This is a reminder that you must keep your appointments with us in order for you to remain in
the care of our clinic. Missing two consecutive appointments without rescheduling, or missing
three out of six consecutive appointments, may result in dismissal from the '.Medipark
Ongwediva Care Centre.
If you cannot keep this appointment, contact the clinic at 063-2034545.
\\Ve look forward to seeing you in clinic.
Yours sincere! y
DrR Reeze
(Student nr and full name)
|
|
9 Page 9 |
▲back to top |
Name
11.
Elixir Paper
l51 Opportunity
June 2022
Use the Mail Merge function and Merge the account of Ms Selma Lutz with this letter.
Type your student number and name in brackets at the end of the letter and print a copy.
12. From your existing accounts, please open the following accounts and add the following
children as dependants on their accounts.
MAIN MEMBER
Shameema Oshile
Carlos Menette
DEPENDANT
Geraldo Oshile
Date of Birth: 10 May 2010
Allergies: Amiloride
Charlotte Menette
DOB: 12 September 2005
Allergies: Cyclizine
DEPENDANT
Gina Oshle (002)
DOB: 25 March 2012
Allergies: Ibuprofen
13.. Add the necessary resources and make the following appointments in the Elixir Diary
13.1 Jolene Niizimba phone the practice for an appointment for a normal consultation with Dr
Green 6th June 2022 at 08:00.
13.2 A new patient Mr H January, walks into the practice, he has not been there before. Book
an appointment for him for 25th July 2022 at 14:00 with Dr Kotze.
13.3 Make a new appointment for Ms Mouwers (a new patient) Cell: 0811225698 with Dr
Hangula on the 20th June 2022 at 11:00
13.4 Ms Niizimba phoned back and wanted a longer appointment. Please extend the
appointment until 9:00
13.5 Ms Mowers called back; unfortunately, she is not able to make the appointment for the
20th June 2022 due to work commitments. Please move the appointment to Friday, the
same week.