MOA611S - MEDICAL OFFICE APPLICATION 2A - 2ND OPP - JULY 2024


MOA611S - MEDICAL OFFICE APPLICATION 2A - 2ND OPP - JULY 2024



1 Page 1

▲back to top


r
" nAmI BIAunIVER sITY
OF SCIEn CE Ano TECHn OLOGY
FACULTYOF COMMERCE;HUMAN SCIENCESAND EDUCATION
DEPARTMENTOF GOVERNANCE& MANAGEMENTSCIENCES
QUALIFICATION: Bachelor of Business and Information Administration
QUALIFICATION CODE: 07BBIA
LEVEL: 6
COURSE: Medical Office Applications 2A
COURSE CODE: MOA611S
DATE: July 2024
DURATION: 2 Hours
SESSION: Practical Paper
MARKS: 160
EXAMINER(S)
MODERATOR:
SECOND OPPORTUNITY - QUESTION PAPER
Ms L Beukes
Ms Petrina Witbeen
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 7 PAGES (Excluding this front page)

2 Page 2

▲back to top


Question 1
Marks: 30
Academic research seminars focus on instruction that is designed for the attendee or participant to gain
specific knowledge within the academic area. As the project co-ordinator you have the responsibility
to co-ordinate this project to organise the quarterly research seminar for the department. This event
will take place on the 3rd August 2024. Please start planning least from the 1'1July 2024.
NR NAME OF TASK
1. Define the Seminar's Objectives
2. Book a Venue (NUST-Auditorium 1)
3. Identify Target Audience
4. Develop Curriculum
5. Discuss the Budget and secure funding
6. Gather Resources
7. Prepare Snacks and Beverages
8 Schedule Sessions
9. Printing of Programmes
10. Media and Photographer
11 Prizes for Participants
12. Programme Facilitator
13. Confirm Participants
14. Final check-ups and logistics
TASK
RESOURCES
DURATION
1 Day
1 Day
2 Days
2 Days
2 Days
2 Days
3 Days
2 Days
2 Days
2 Days
1 Day
2 Days
2 Days
1 Days
Adelaide
Philemon
Chris
Chris
Philemon
Adelaide
Adelaide
Chris
Chris
Philemon
Chris
Adelaide
Philemon
Chris
1. The Milestones for this event will be the following:
Deposit of 70 % to be paid for the:
(a) Venue
(b) Printing of Programmes
(c) Prizes for Participants
Full Payments to be made for the:
(a) Snacks and Beverages
(b)
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 (Autofit to 1).

3 Page 3

▲back to top


·2-
Question 2
July 2024
Question 2
Marks: 40
As Office Administrator of Comfort Tours, type the following Main Document in font Arial,
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 R Nitzborn, the Excel Spreadsheet as well as the Mail merged
document.
<<Name>>
<<Address>>
<<Town>>
<<Country>>
Typist, the address below is
the sender's address. Please
type in the con-ect position.
Comfort Tours, PO Box 123,
Swakopmund, NAMIBIA
Today's date
Dear <<Salutation>>
TOUR: <<Adventure > >
Thank you for your questioning regarding our tours of the <<Adventure>>. To
ensure that you receive a true value-for-money package, the following points are
brought to your attention.
2.We include <<Inclusive>> in your itinerary. 3. The tour price
includes <<Special>> arrangements and entertainment.
1.Our agency guarantees centrally located hotels in most cities
Please type in
>- chronological
order, D/S
and towns. Taxi fares alone could cost you < < Cost> >each way.
Our Comfort Tours are renowned as the best value-for-money in <<Destination>>.
Yours faithfully
You are the Office Administrator who must
also sign this letter. Please end of
the letter properly.

4 Page 4

▲back to top


Database for Excel:
....,
;::>
Question 2
July 2024
NAME
ADDRESS TOWN
COUNTRYSALUTATION ADVENTURE COST INCLUSIVE SPECIAL DESTINATION
Mr JJacobs POBox140 RUNDU
Namibia DearMr Jacobs SafariTour
N$200,00 Hiking
Dinner Tanzania
Mr PPetrus POBox253 SWAKOPMUNDNamibia DearMr Petrus PhoptographTyour N$500,00 Sightseeing
Breakfast Holland
MsATjivi
POBox440 WINDHOEK Namibia DearMsTjivi
TuscanyWineTour N$300,00 Excursions
Lunch Italy
MsJl(arumbe POBox220 OSHAKATI Namibia DearMs Karumbe RhineRiverCruise N$600,00 Exploringthecity Lunch Germany
MsRNitzborn POBox589 OKAHANDJA Namibia DearMsNitzborn BritishIsland
N$700,00 Daytours
Breakfast Europe
I11structions for Mailing List:
1. Type the spreadsheet in font Calibri, size 10.
2. Insert N$ for all the amounts add two decimals after the comma.
3. ColumnHeadings - Font size 10, Bold, u/c
4. Records - font size 11.
5. Row Height: Column Headings 40 pixels
Rest of Rows.30 pixels
6. Sort Town in ascending order.
7. Insert all borders.
8. Print excel spreadsheet in Landscape.

5 Page 5

▲back to top


Marks: 30
In Ms Word, please DRAW the following Table and complete the information in the
font Arial, size 12, You are the secretary of a company called Namibia Connect
Technologies. As Office Administrator you are responsible for the purchasing and
ordering of the products.
For this purpose, you have set up the following spreadsheet for the Finance Department:
Sales: Namibia Connect Technologies
Products
Routers
Switches
Modems
Motherboards
Mice
Graphics Processing Unit
Keyboards
Touchpads
Quantity
160
185
130
145
145
65
145
120
Cost Price
360
900
540
1800
90
2700
1080
720
Total Cost
Adhere to the following editing instructions for the table:
1. Draw the Table
2. Auto fit table to content.
3. Set row height to 0.3" and bold column headings.
4. Insert the correct formula to calculate the total cost for each product.
5. Insert a Total row at the end and calculate all the columns, and bold answers.
6. Sort Table according to Product in ascending order.
7. Convert Table to chart which only displays the:
o Products
o Total Cost
8. Pre-set the table: Grid Table 2, Dark Accent 1
9. Format Chart:
9.1 Insert Chart Title: Namibia Connect Technologies (u/c, Bold, cent).
9.2 Insert Gridlines.
9.3 Select Style 4 for the chart.
9.4 Insert Legend to the right.
10. Insert caption below the table: Table 1: Namibia Connect Technologies (Bold)
11. Insert your name and student number in the header and print one copy.

6 Page 6

▲back to top


s-
QUESTION 4
MARKS: 60
Start Elixir and log into the General Practice option.
The Kuisebmond Health Care, in the Walvisbay, 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.
-
Dispensing
Provider
EmaiAl ddresses
Discipline HPCSANRCellular DispensingRegistration-
DrAndreThaniseb athaniseb@iway.na NeuroSurgeon 1002502812323568 No
-
DrEliseTjivera etjivera@hotmail.com Opthalmologist
DrJohnPauBl laauwjpblaauw@africaonlineU.nraologist
DrInaNhinda inhinda@gmail.com Cardiologist
1002503812323569 Yes
1002504812323570 Yes
1002505812323571 Yes
2467-
2444-
2222-
2.
Create the following accounts for each patient.
I
I
I
Surname Firstname ID NUMBERS PostalAddress Town EmailAddress
-
Provider
Nakale Eileen
7509090025410 POBox477 WALVISBAY enakale@gmail.com DrAThaniseb
Mutanga Helmut 9008180025410 POBox125
HENTIES hmutanga@nust.na DrETjivera
-
Ward Terrence 8205150001478 POBox547 SWAKOPMUNtDward@iway.com DrJPBlaauw
Visser Gerda
921210001425P0 rivateBag2211 OMARURU gvisser@telecom.na Ori Nhinda
-
Lombard Leonard 9307110002563 POBox232 OKAHANDJAllombard@gmail.com DrAThaniseb
I
I
'
'
3.
Insert the following Accounting groups to your Database:
3.1 Normal - White
3.3 Private Patients - Orange
3.4 Payment overdue - Green
3.5 Bad Debts - Yellow
4.
Set up the following Clinics:
4.1 Coastal Clinic
4.2 Narraville Clinic
4.3 Walvisbay Clinic
5.
Load the following Colleagues:
Dr Sydney Cloete, HPCSA: SC445575, Referring doctor- Biokinetics, PO Box 221,
Windhoek.
5.2 Dr Charlie Brown, HPCSA:GH3112 -Assisting doctor-Anaesthetist, Private Bag 131,
Swakopmund.

7 Page 7

▲back to top


6. Add the following medical aid
numbers (references) to the
existing accounts.
Surname
Nakale
Mutanga
Medical AID
First name Scheme
Eileen
NMCRUBY
Helmut
NHPGOLD
Medical Aid -
Number
NMC1133
-
NHP2121
Ward
Terrence LIBERTYLIFE
LIB1235
Visser
Gerda
Cor-JlPLIMED PLUS COM6622
Lombard Leonard PROSPERITY
'
PR08989
'
7. The following new service provider has joined the medical field
Details
Discipline
HPCSA Registration
Cellular
Email Address
Dispensing
Dispensing Registration
Dr John Coraizin
Biokinetics
BI05522
0811255698
jcoraizin@mweb.na
Yes
00221
8.
You have to add the following reasons to the Suspension list.
8.1 Account Overdue
8.2 Emigrated
8.3 Deceased
9. Select the Account group "Bad Debts" and place a financial block on it.
10. From your existing accounts, please open the following accounts and add the following
children as dependants on their accounts.
MAIN MEMBER
Eileen Nakale
Terence Ward
DEPENDANT
Geraldo Nakale (Husband)
DOB: 12 December 1974
Allergies: Loperamide
Alice Ward (Wife)
DOB: 10 July 1984
Allergies: Cyclizine
DEPENDANT
Jane Nakale (Daughter)
DOB: 22 September 2001
Allergies: Benzocaine
11.
11.1
11.2
11.3
11.4
Make the following appointments in the Elixir Diary:
Gerda Visser phone the practice for a normal consultation with Dr Nhinda for the 15th
August 2024 at 14:00.
A new patient Ms Meriam Damaseb, had an emergency, she has not been there before.
Book an appointment for her for 11th September 2024 at 10:00 with Dr Blaauw.
Gerda Visser phoned back and wanted a longer appointment. Please extend the
appointment until 15:00.
Please move the appointment of Ms Damaseb to the 18th of September 2024, the
following week.

8 Page 8

▲back to top


f
12. Please create a new practice template called Prescription Letter and type the following
details on it.
24 July 2024
<PATIEN'TFIRSTNA.\\!E>< PATIE!\\TfSUR.L"-:AME>
<A.DDRESSA>
<A.DDRESSB>
De2t <PATIENTFlRSTNAa\\!E>
I hope this letter findsyouwell. Follo\\\\iog our recentconsultationon 11thof May2024, I amwritingto
pro\\idc you \\\\ith a prescriptionfor mcdk2tionto help manageyourhigh bloodprcsrurc.
Presc1"iptionDetails:
lledic:1Uoo ~awe: Amlodipfoc(genericfor Nor\\'asc)
DOS11g5em: gtablets
Instructions: T2keone tabletby mouthonce daily,preferablyat the sametime eachday. of water.
Quaoti~~ 30 tablets(one month's~pply)
Rdill£ 6 Monthsrepeat
A.mlodipineis a dcium channciblockerthatworksby rcia;<jngtheblood ,·essds, allowingblood to
flowmoreeasilyandloweringbloodprcs~rc. It helpsrcdu~ the risk of heart attack,stroke,and other
cardiovamarcomplic2tions associated\\\\ith hypettt!nsion.Yourhealth :mdwell-beingareour top
priorities,2ndwe arc here to supportyouthroughoutyour trC31mcnt.
Thankyou for entrustingus with yourcare. We look forwardto hearingaboutyour progressa%your
nc~t appointment.
W211Ir1egards,
prJ Vermeulen
Srudt!ntName&SrudentNumber
13. Use the Mail Merge function and Merge the account of Gerda Visser with this letter.
Type your student number and name in brackets at the end of the letter and print a copy.