 |
MOA611S - MEDICAL OFFICE APPLICATION 2A - 1ST OPP - JUNE 2024 |
|
|
1 Page 1 |
▲back to top |
\\'
nAmI BIA unIVE RSITY
OF SCIEn CE Ano TECHn OLOGY
FACULTY OF COMMERCE; HUMAN SCIENCESAND EDUCATION
DEPARTMENT OF GOVERNANCE & MANAGEMENT SCIENCES
QUALIFICATION : Bachelor of Business and Information Administration
QUALIFICATION CODE: 07BBIA
LEVEL: 6
COURSE: Medical Office Applications 2A COURSE CODE: MOA611S
DATE: June 2024
SESSION: Practical Paper
DURATION: 2 Hours
MARKS: 160
EXAMINER(S)
MODERATOR:
FIRST OPPORTUNITY-QUESTION PAPER
Ms L Beukes
Ms Petrina Witbeen
THIS MEMORANDUM CONSISTS OF 9 PAGES
(Excluding this front page)
|
|
2 Page 2 |
▲back to top |
Question 1
Health Harmony Medical Centre is about to open their doors in Klein Windhoek.
As the new Office Administrator, you have been appointed as the co-ordinator for
this very important project.
MEDICAL
lf.QlffJ~
coc~ lltRI:
The event date is scheduled for Saturday, the 28th of September 2024. Planning will start from the
2nd of September 2024.
The Launching of this big event is made up of the following tasks and resources:
NR NAME OF TASK
1. Develop a Business Plan
TASK DURATION
2 Days
RESOURCES
Krestina
2. Select a Location/Venue
1 Day
Gizelle
3. Obtain Necessary Licenses and
Permits:
4. Marketing and Branding
2 Days
2 Days
Peter
Peter
5. Invite local stakeholders
3 Days
Gizelle
6. Entertainment & Sound System
2 Days
Krestina
7. Catering (Refreshments for Guests). 2 Days
Krestina
8. Programme Design & Printing
1 Days
Gizelle
9. Photographer & Media release
1 Days
Gizelle
10. Programme Director
1 Days
Peter
11. Confirm guest list
1 Day
Krestina
1.
12. Final check-ups and logistics
1 Days
Peter
1. The Milestones for this event will be the following:
Deposit of 50 % to be paid for the:
(a) Venue
(b) Marketing & Branding
(c) Programme Design & Printing
Full Payments to be made for the:
(a) Photographer & Media release
(b) Programme Director
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 to fit {1 page only).
|
|
3 Page 3 |
▲back to top |
Question 2
June 2024
QUESTION 2
MARKS: 30
In Ms Word create the following form on one sheet. Adhere to typing rules and instructions
Given on the next page. Use the font Arial, size 12. Please print one copy which displays the content
controls and information added.
General Admission Registration
¢
(u/c, bold, font Arial Black, size 18, cent)
Personal Information
¢
(u/c, bold, font size 12, cent)
Name: ......................................................... ......
Last Name: ......................................................
-V)
0
......
1.-.
Email: ..................................................................
Gender: Male
Female
QJ
Vl
C
Phone: ..................................................................
Dietary restrictions?
-V)
0....,
1.-.
QJ
None
Vegetarian
Gluten Allergy ·
Lactose Allergy
Vl
C
Nut Allergy
Shellfish AlrergyJ
Bold
Insert CheckBoxes
on the left of the
different options.
Date of Birth: ............................................ ....
Do you require parking?
Yes
No
What is your room preference: Single Room
}
¢
What activities
¢
will you attend:
Shared Room
No Room Needed
Award Gala Dinner
Luncheon
Town Hall
Insert Drop Down List
}
Insert
Drop
Down
List
Are you registering for yourself or someone else?
Myself
}
Someone Else
Insert checkboxeson
the left of each option
Additional Information:
u/c, bold, centre, size 12
*If registering for someone else, please provide their name and relationship to you:
::J
Vr.,,o..,l ..,,..
Use Name: .. -•...... ••.. •.. •--•--·-----•--··----····--·
Insert Content controls:
D/S _.RIea t·ions h'Ip·............ -.....................
••• _., Usethe font Emphasisto format
>- rX,o..,.
O'
0
*
X
Any special accommodations needed: Yes No _.,
Insert checkboxes
....,
1.-.
QJ
Vl
C
V), 0.0
-0 'iCi"o
QJ C
:V:>l
C1l
..c
¢
Terms and Conditions: (bold)
By submitting this registration form, I agree to abide by the rules and regulations
set forth by the organizers of the event/program.
I understand that my registration is subject to approval and may be rejected if
incomplete or inaccurate information is provided
|
|
4 Page 4 |
▲back to top |
.3
Question 2
June 2024
Question 2 (Form)
INSTRUCTIONS:
1. Delete dotted lines and insert content controls, and format as
indicated below in brackets. Please replace dotted lines with the
details as indicated below.
Name: Your name (Subtle Emphasis)
Last Name: Your surname (Subtle Emphasis)
Email: Your email address (Intense Emphasis)
Gender: Your gender
Phone: 0815557896 (Strong)
Date of Birth: Today's date (Full Date)
Do you require parking? Your choice
What is your room preference: Your choice.
What activities will you attend: Your choice.
Are you registering for yourself or someone else? Your choice.
2. Additional information:
Name: Name of classmate
Relationship: Fellow Student
3. Terms and Conditions: Tick both boxes.
|
|
5 Page 5 |
▲back to top |
QUESTION 3
Retrieve the following Sales Journal of Fire Equipment. Adhere to the instructions
to complete the Journal.
Service Date
02/04/2024
09/04/2024
16/04/2024
23/04/2024
30/04/2024
06/05/2024
13/05/2024
20/05/2024
27/05/2024
10/06/2024
Fire Equipment
CO2 Aluminium
ATFF Stored Pressure+A 1:111
Class F (Deep Fats)
Dry Power Stored Pressure
Dry Power Stored Pressure
Dry Power Stored Pressure
ATFF Stored Pressure
ATFF Stored Pressure
ATFF Stored Pressure
Water Stored Pressure
Code
FR10
FR11
CF1
DF2
DF3
DF4
AF1
AF2
AF3
WS1
Quantity
20
50
60
25
90
20
65
90
90
60
Cost
Price Rating
107.00 34B
186.63 75B
257.16 TBA
138.61 13A
86.54 27A
111.18 55A
65.34 SA
112.65 13A
115.50 21A
83.81 13A
Sumlf Function
TOTAL
MARKS: 30
units
Sold
96
101
106
85
45
75
58
52
75
65
~ale
Price
It
Functon
|
|
6 Page 6 |
▲back to top |
Question 4 (Pivot Table)
Instructions
QUESTION 4
Retrieve Question 4 - Pivot Table (List of Holidays)from your M-drive and adhere to
the instructions that follow.
June 2024
MARKS:20
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 Best Buy Travel Agents
4. Insert 2 rows above the column headings.
5. Insert Main Heading in row 1 -Best Buy Travel Agents
(U/C, Bold, Merge & Centre, Arial Black, 16)
6. Edit the table as follows:
6.1 Change the font of the entire table to Arial 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 15%) row height pixel 50
6.4 Resize columns headings and change the row height of the rest of the table to 25 pixels.
7. Pivot Table:
7.1 Select the Original sheet and create a PivotTable.
7.2 From the PivotTable Field List choose Number of days by Country to be displayed
in the Report.
7.3 Move Travel Method to Column Label and Country to row label and Nr of Days
to Values.
7.4 Rename the sheet tab - Report
8. Chart:
8.1 Create a Pie chart from the Report.
8.2 Insert the following Chart Elements:
Chart Title - Best Buy Travel Agents (Bold, u/c, centre)
Data Lables - Data Callout
Legend - Insert on the left
8.3 Select Style 4 from the chart styles.
8.4 Make sure both the table and chart fit on one sheet and print.
|
|
7 Page 7 |
▲back to top |
,6
Question 3 - Excel
Memo
INSTRUCTIONS:
1. Insert three rows on top of the table.
2. Top row: Insert the heading Fire Equipment (u/c, Arial, font size 16, bold, merge & centre)
Row 2: Insert April 2024 (Arial, font size 12, bold, merge & centre)
3. Use the Sum Function to calculate the Sale Price (Quantity x Cost Price).
4. Use the correct formula to calculate the Cost Price of the Dry Power Stored Pressure only.
Insert the answer in E18.
5. Use the If-Function to calculate the Sale Price of the Fire Equipment.
If the sale price is smaller than 5500 the equipmentmust be sold on promotion.
6. Insert the correct formula to caculate the total sum of the Sale Price. Insert answer in H19.
7. Change the Date to a full date and centre position.
8. Bold the column headings, all calculated answers and the answers for the IF function.
9. Increase the row height:
Column Headings: 50 Pixels
Rest of the table: 30 Pixels
10. Change the font of the entire table to Calibri and font size to 12.
11. Merge and Centre and right-align the following cells:
Cell A16 & B16 as well as A17 & B17.
12. Print final copy on landscape.
June 2024
|
|
8 Page 8 |
▲back to top |
Name
QUESTION 5
Elixir Paper
l51 Opportunity
June 2024
MARKS: 60
--.VEIIIPABK
ONGtA/ED:IVA
Ongwediva Medipark recently like to open their doors to the public. Since you were trained in the
software Elixir, the task to help set up a new practice have been allocated to you as the newly
appointed Medical Office Administrator. The information below will assist you with this very
important responsibility to set up the practice. Please add any missing column headings from the
customize property list and delete the columns not being used.
1. Start by creating Service Providers for the practice.
-·-·-·-
----
Provider
EmaAilddresses
'
'
'
Dispensing
Discipline HPCSANCRellularDispensinRgegistration
DrGersoAnmakali gamakali@gmail.cPoamedtrSicurgeon 002100813358600Yes
2562461
DrPeteErfraim pefraim@mweb.naRadiologist
002110813358601Yes
2562463
DrEvaKateta ekateta@gmail.coUmrologist
002120813358602No
-
DrEriTcuyoleni etuyoleni@iway.naNeurSourgeon 002130813358603Yes
DrLorrainUeusiko luusiko@africaonliGne.nnearParlactitioner 002140813358604No
2562465
-
-
DrKareEnlago kelago@gmail.comNeurologist
002150813358605Yes
2562467
2.
Create the following accounts for each patient.
--
Surname Firstname IDNUMBERSPostaAl ddress
Town
EmaiAl ddress
Provider
Vilho Getrude 8003150021540POBox333 WINDHOEK gvilho@mweb@na DrKarenElago
Tshavuka Eva
8802202589001POBox380 OKAHANDJAetshavuka@mweb.naDrEvaKateta
Stefanus Julia
9003120010235POBox422 OTJIWARONGjsOtefanus@gmail.comDrEricTuyoleni
Endjala Andrew 8012010025251POBox252 GROOTFONTEaIeNndjala@iway.com DrPeterEfraim
Kaundje Ruth
7501150012457POBox310 KATIMAMULILOrkaundje@nust.na DrLorraineUusiko
Matheus Simon 4504260001245POBox370
I
TSUMEB smatheus@gmail.comDrGersonAmakali
3.
Add 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 Town Clinic
4.2 Ongwediva Clinic
4.3 Private Clinic
|
|
9 Page 9 |
▲back to top |
Name
Elixir Paper
1st Opportunity
June 2024
5.
Load the following Colleagues:
5.1 Dr Samuel Albertus, HPCSA:SA10102, Assisting doctor, Anaesthetists
Private Bag 212, Rundu
5.2 Dr Paulus Alweendo, HPCSA:PA9911- Referring doctor - Orthopaedic Surgeon, Private
Bag 979, Walvisbay.
6.
Add the following medical aid numbers (references) to the existing accounts.
-
Surname
Vilho
Tshavuka
Stefanus
Endjala
Kaundje
Matheus
First name
Getrud
Eva
Julia
Andrew
Ruth
Simon
I
Medical AID
Scheme
PRIVATE
NAMDEB
NHP SILVER
INVESTMED
NMCRUBY
PROSPERITY
Medical Aid
Number
PRIVS006
NAM7878
NHP5151
INV1235
NMC6622
PR02525
I
7.
The following new service providers has joined the medical field
Details: Dr Deon Louw, Discipline: Anaesthetist, HPCSA Registration: AF23300,
Mobile: 0811255698, Dispensing: Yes, Dispensing Registration: 2562469.
Email Address: dlouw@gmail.com
Details: Dr Willem Nienaber, Discipline: Cardiologist, HPCSA Registration: CA55002,
Mobile: 081122000, Dispensing: No, Email Address: wnienaber@mweb.com
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 "Benefits Exceeded" and place a financial block on it.
10. Add the necessary resources and make the following appointments in the Elixir Diary
10.1 EvaTshavukaphone the practice for an appointment for a normal consultation with
Dr Kateta 8th July 2024 at 08:00.
10.2 A new patient Mr T Kashaka, walks into the practice, he has not been there before. Book
an appointment for him for 17 June2024 at 15:00 with Dr Efraim.
10.3 Make a new appointment for Ms Vilho with Dr Gerson on the 30th May 2024 at 14:00
10.4 Ms Tshavukaphoned back and wanted a longer appointment. Please extend the
appointment until 09:00.
10.5 Mr Kashaka called back; due to unforeseen circumstances he requested that the
appointment be shifted to the 26th June 2024,
|
|
10 Page 10 |
▲back to top |
Name
Elixir Paper
1st Opportunity
June 2024
11. Please create a new practice template called Test Results and type the following details on
it.
23 May 2024
<PATIEN"TTITLE> <P ATIE:t\\lTFIRSTNA1vlE>
<ADDRESSA>
<A.DDRESSB><ADDRESSC>
<PATIEN"T SURNA..1v1E>
Dear <PATIENI'TITLE> -~ATIE:t\\1TS1JRNA1'.iffi>
I hope this letter finds you in good health. FollO\\ving your recent blood tests performed on
<DATEOFSERVICE> I have reviewed the results and would like to share them ,vith you, along
with my recommendations.
Your blood tests have provided us with valuable information about your cholesterol levels, and
blood sugar levels. To ensure that you fully understand your test results and to discuss the next
steps in your care, I recommend scheduling a follow-up appointment. During this visit, we can
go over any questions you may have and outline a detailed plan for any further investigations or
treatments that may be needed.
Please contact our office at 061-233565 to arrange your appointment. \\Ve are here to support
you through this process and to assist in any way possible.
\\Varm regards
Dr R Nghitukwa
Student Name & Number
12. Use the Mail Merge function and Merge the account of Ms Julia Stefan us with this letter.
Type your student number and name in brackets at the end of the letter and print a copy.
13. From your existing accounts, please open the following accounts and add the following
children as dependants on their accounts.
MAIN MEMBER
Ruth Kaundje
Simon Matheus
DEPENDANT
Ralph Kaundje (Husband)
DOB: 10 August 1974
Allergies: Amiloride
Sandra Matheus (Daughter)
DOB: 10 July 2005
Allergies: Cyclizine
DEPENDANT
Rachel Kaundje (Child)
DOB: 25 Septembe 2014
Allergies: Ibuprofen