 |
MOA621S - MEDICAL OFFICE APPLICATIONS 2B - 1ST OPP - NOV 2024 |
|
|
1 Page 1 |
▲back to top |
n Am I BI A u n IVER s I TY
OF SCIEnCE Ano TECHnOLOGY
FACULTY OF COMMERCE; HUMAN SCIENCEAND EDUCATION
Department of Governance & Management Science
QUALIFICATION: Bachelor of Business and Information Administration
QUALIFICATION CODE: 07BBIA
LEVEL: 6
COURSE: Medical Office Applications 2B
COURSE CODE: MOA621S
DATE: November 2024
DURATION: 3 Hours
SESSION: Practical Paper
MARKS: 160
EXAMINER(S)
MODERATOR:
FIRST OPPORTUNITY - QUESTION PAPER
Ms L Tripodi
Ms P Lauw
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 OF9 PAGES (Excluding this front page)
|
|
2 Page 2 |
▲back to top |
Question 1
1'1 Opportunity
November 2024
Question 1
Total: 40
Retrieve Question 1 with the Track Changesfrom your folder and adhere to the
instructions.Type document in Calibri, font size 12, sis. Insert page numbers (Bottom of
page - centre) except for the first page. Insert diagonal watermark: ORIGINAL (u/c,
default font. Use Automatic Table2 for the TOC. Insert Reference List.
!Hyphen Hydrogen IEnergyl .................................................................................
--:----- Commented [TL 1]: Pleaseformat as follows:
Font Calibri, size 18, bold, cent
ILl_oderitza,._historic town_on Namibia's_southwestern coast, is set to become_a--··········.
beacon of sustainable energy innovation with the establishment of the new Hyphen ··...
Commented [TL2]: Insert Logo (in folder) on the top right
corner next to the heading, height 0.5''
Hydrogen Energy lcampu~,-- _·-.-·.·-__________-·__·_·_-._.._........ -·__·-____--_-------·-··-__........... .
Commented [TL3]: Insert Drop Cap- 2 lines, bold
1. ilntroductiorl ____._-·_·-·-······-·-·-····-····- ·--------------------- ---------------·---··-------- ·----___
Commented [TL4]: Us the following link to inert an
This ground:breaking project marks a significant step in Namibia's journey towards \\
intext-citation.
becoming a global leader in.9_r:e~!"!-~.Y~~~9.~~-P-~9-~_l}_~~!_q!"!,_l}_t)!i~[r:i.9.lt~.Y.~~tr\\~_11h2~t1tp2~s190:/0/-4~w6wJ8w~8 -.s-ciencedirect.com/science/ article/ pii/5136403
resources to create a sustainable energy future.
\\._ -.
Commented [TLS]: Format as heading 1, Black
2.!AVision for a Green Future l_____·-_··_·_···---·--------·····-·-·-·--------F-o-n-t-size 16
Hyphen Hydrogen Energy, a joint venture between global energy leaders and local
Formatted: Font: (Default) Arial, Bold
partners.is committed to developing Namibia's potential in the green hydrogen
Commented [TLG]: Format as Heading 1, black, font size
sector.
16 bold
2_1 INUST LOderitz Campus l___·-_---------------·-···············-·-·----·---------·---·-··C·o·m·m·e·n·t·ed··-[-T-L-7-J:-F-ormat as Heading 2, font size 14,
The LOderitz campus is the cornerstone of this vision, serving as a hub for:
'-Bl_ac_k_____________
_
!research,
development, and
production of green hydrogen. l__·········-·-·--·················-···--··-··---·--·--·-········---C--o-m-imented [TLSJ: Insert bullets,s/s
-i ~.2Solar Resource~ ....... -·--··----·-- ______.__.__---------··-·--__--·-·_________._.____.__·----_______--_-__Commented
This renewable energy source, produced using Namibia's abundant wind and
solar resources, is seen as a key solution to reducing global carbon
emanations emissions and meeting future energy demands.
[TL9J: Format as heading 2
~.The Impact on LOderitz and Beyonc{ _______·_-_--_-·_---·-···---·----------·-----------------------·-----·C-o-immented [TL 10]: For as Heading 1
The establishment of the 1:fYl:?h~~-Jiy~,:9.9.~_ry_!;!1~r9Y.~?.~J?!,J~.J~-_-1~_:~>Pr!-r_~i_·f·tg·~·,-c--,-l_--t9Formatted: Font: (Default) Arial, Bold, Italic
transformative economic and social benefits to LOderitz and the broader region.
~.1 Employment Opportunitie( _________·_--_-_·-_·_··················-·--·--·----·----·---······-···-···-----C-o-mi mented [TL 11]: Format as Heading 2
The project is e>q:~ectedanticipatedto create numerous employment opportunities,
------i ranging from construction and engineering to research and administrative roles.1........
Commented [TL 121: Delete paragraph 3.1
··---1 ~-~Professionals and lnvestmen~ ·-·---·----·- ------------------------------------------------------------,----- Commented [TL 13]: Replacenumbering with 3.1
Moreover, the influx of P!'~f.~~~f.<?!1~~~.~~~-~IJX~~~ry:,-~!:7!_[~_!i_~~I.Y.J<?_~p_l}[Jh~.-gf_qco~m!hm_en<t?edL. [TL14J: Format as heading 2
local businesses and services, further stimulating the regional economy.
1 ·--...
_ Formatted: Font: (Default) Arial, Bold, Italic
?===============
_,- Commented [TL 15]: Start Nr 4 on new page
14_!,_-_-_B_~!?~?.~~.?~.-r:i_tj.Q~y_~J~p-~f~r?iJ.~J!i_tJ_~_i -_--------------------------
Commented [TL 16]: Format as Heading 1
|
|
3 Page 3 |
▲back to top |
Question 1
1'' Opportunity
November 2024
The campus will host.cutting-edge research. and_.development facilities,·····-:·····{ Formatted: Font: (Default) Arial, Bold
where scientists and engineers can collaborate on advancing hydrogen
·····{ Formatted: Font: (Default) Arial, Bold
technologies. This environment will also foster partnerships with academic
institutions, research organizations, and industry leaders, creating a,y}f?!~.'!..t.-······ Formatted: Font: (Default) Arial, Bold, Italic
ecosystem for innovation.
~- Conclusio~·························································································-······{ Commented [TL 17): Format as heading1
The induction inauguration of the Hyphen Hydrogen Energy campus in
Li.ideritz marks a historic milestone for Namibia's green energy ambitions.
~s.the.project takes shape,.it promises .to bring.significant.economic,.social, and·······-······ Commented [TL18): Insert Drop cap 2 linespace, bold
environmental benefits to the region, setting a precedent for ,sustain_able....................... •· Formatted: Font: (Default) Arial, Underline
development in Africa and beyond.
|
|
4 Page 4 |
▲back to top |
Question 2
TOTAL: 30
Retrieve the Project2024 and adhere to the instructions that follow:
INSTRUCTIONS
1. In the Database Project2024 use the Employees table to display the "Hiring Dates"
of all the employees.
2. Use the table for Employees to create an action query that will display the
employees that work on the project IRS Project X only.
3. Use the table Employees and Project. Create a joint table with that will display
the Project Titles of all the Employees who earn an hourly rate of N$20.
4
Use the tables Head of Department and Departments to create a Crosstabs view
that display the budgets of the Departments. Display table as follows: Head of
Department as rows, Departments as Columns and Budget as a sum and value.
In the Project2024 database, use the tables indicated below to create a form and report
respectively.
Form:
5. Use the table "Employees" to create a Multiple Items Form and format as follows:
Insert a Title: "Global Impact Academy" - Font: Algerian, font size 18, u/c, Text
Align: Centre. Resize all columns to fit on one sheet, Print landscape orientation.
Report:
6. Create a header titled "Global Impact Academy"- Font Arial, Size 16, Bold, u/c, Text
Align: Centre. Print portrait orientation.
7. Insert page numbers which shows the current page only, at the bottom right
position.
8. Insert the Date at the left bottom corner.
9. Insert a textbox for your name and student number in the top left corner.
10. Use the logo, saved in the folder, for "Global Impact Academy" to insert in the top
right corner next to the title.
11. Rename all queries accordingly.
12. Go to layout view and resize all columns to fit perfectly.
13. Print all queries as well as the form and the report.
|
|
5 Page 5 |
▲back to top |
Question 3
1st Opportunity
November 2024
Question 3
Marks: 30
As an Office Administrator of the Khan Academy, you are tasked to design a flyer that
will advertise the Institution for the new academic year. Please create an informative,
attractive flyer, using Ms Publisher 2016.
INSTRUCTIONS:
1. Use the flyer under the heading Built it. Select
Arrows under the grouping Real Estate. Use the
option tear-offs for the contact information.
2. Use customize colour scheme Grove.
3. Please follow all instructions carefully to ensure an
attractive Flyer.
4. Delete place holders and replace with the
information given through the instructions.
5. Print your flyer
|
|
6 Page 6 |
▲back to top |
Question 3
.s
November 2024
------1 Business Name
Khan Academy (Font size 14, Bold)
Organization
l
Replace:
............ Product/ Service}
Information
Logo with Khan Academy Logo (in folder
Replace content with:
Online Education & Trainin Courses
(Font: Georgia,size24, LeiAlign)
with height: 1.27cm),
Organization with Khan Academy (bold,
font size 10, cent)
In the content below in a
textbox (Font: calibri, size 8,
bullets)
Key Features of Khan Academy:
Wide Range of Subjects
Interactive Learning
K-12 Focus
SAT and Test Prep
User-Friendly Interface
Parent and Teacher Tools
Global Reach
Benefits of Using Khan Academy
Free Access
Self-Paced Learning
High-Quality Content
Place text here that introduces your organization and describes your specific
products or services. This text should be brief and should entice the reader
to want to know more about the goods or services you offer.
Delete content and replace with:
T
Khan Academy is a nonprofit educational organization that offers a
wide range of free online courses, lessons, and resources. Founded by
Salman Khan in 2008, the platform aims to provide a free, world-
class education for anyone, anywhere. {Font: Bell MT, Size 14, Cent)
How to Get Started:
Visit the Website
Create an Account
Explore Courses
Engage with Content
Insert Picture from Khan Academy
(In folder). Centre picture and re-size to 8.8cm
Delete and replace with:
Tel: 061-203 25258
lnfo.khanacademy@gmail.com
I
Tel: 555 555 5555
Business Tagline or Motto -----l
Replace Business Tagline or Mato with:
"Empowering Learners, One Lesson at a Time." (Font size 9", Bold & Italics)
______
__....Insert your full name and student nr as---------
tear-offs
|
|
7 Page 7 |
▲back to top |
1,
UULA
Your Health ComesFirst
ELIXIR QUESTION PAPER
MARKS: 60
Muula Health Care is dedicated to providing comprehensive, patient-centered medical services
in the Oshakati region. At Muula Health Care, we prioritize your well-being, ensuring accessible,
effective, and personalized care for all our patients. As the Office Administrator, you are
expected to assist with the setting up of the new Elixir database. Use the information below to
set-up this new practice.
1. Insert the following service Providers:
Provider 1
Dr. Helena Amutenya- General Practitioner
HPCSARegistration -10023589
PO Box 123, Katima Mulilo
E-mail address - oshakati.healthclinic@gmail.com
Cellular - 0812323660
Dispensing - Yes
Dispensing registration - 700565
Provider 3
Dr. Selma lyambo- Physician
HPCSARegistration -10023901
PO Box 363, Rundu
E-mail address -
siyambo@oshakatiwomenhealth.com
Cellular - 0812323662
Dispensing - Yes
Dispensing registration - 700555
Provider 5
Dr. Maria Tuhafeni - General Surgeonr
HPCSARegistration -10023903
PO Box 232, Rundu
E-mail address - mtuhafeni@oshakatiskincare.com
Cellular - 0812323664
Dispensing - Yes
Dispensing registration - 700500
Provider 2
Dr. Petrus Nghipandulwa - Paediatrician Surgeon
HPCSARegistration -10023900
PO Box 432, Oshakati
E-mail address - pediatric@ongwedivaclinic.org
Cellular- 0812323661
Dispensing - No
Provider 4
Dr. Simon Nghilifavali - Cardiologist
HPCSARegistration - 45456987
PO Box 454 Oshakati
E-mail address - cardiology.oshakati@gmail.com
Cellular - 0812323663
Dispensing - No
Dispensing registration - N/A
Provider 6
Dr. Ephraim Kandjengo - Orthopedic Surgeon
HPCSARegistration - 10023904
Private Bag 113, Rundu
E-mail address - ekandjengo@orthopedicosha.com
Cellular - 0812323665
Dispensing - No
Dispensing registration - N/A
2
Create the foIIowIn~ accoun ts for eac h pafIent.
- 1 Account
-
2 NumberSurnamFeirsntamePostAadl dress IDNumber Town
Provider
E-mails
-
3 oool ShikongoMaria POBox102 8201014500O1S0H0 AKATIDrH. elenAamutenyamaria.shikongo@gmail.com
4 0002 UugwangPaetrus POBox324
5 0003 lyambo ElizabePthOBox145
6 ooo4 Angula John POBox876
9201011450O0N10GWEDIVDArP. etruNsghipanduplweatrus.uugwanga@yah-oo.com
8526011450O0S1H0 AKWAETSIDTrM. arTiauhafeni elizabeth.iyambo@hot-mail.com
8307074500O1N00GWEDIVDArS. imoNnghilifavalijohn.angula@outlook.com
7 0005 Nakale Sophia POBox567 7529021010O0S0H0 AKEAATSITDrS. elmlyaambo sophia.nakale@oshaka- ticlinic.org
8 0006 Nekundi Simon POBo2x34 8902021111O4S7H4 AKNAOTRI DTHrE. phraKimandjengsoimon.nekundi@gmail.com
n
I
I
I
I
I
I
I
I
|
|
8 Page 8 |
▲back to top |
7
3. Insert the following Accounting groups to your Database:
3.1 Normal - White
3.2 Private Patients - Orange
3.3 Bad Debts - Yellow
3.4 Overdue Payments - Green
4. Set up the following clinics:
4.1 Oshakati Health Clinic
4.2 Ongwediva Children's Clinic
4.3 Women's Health Centre
5. Load the following Colleagues:
5.1
Dr. Leoni Hoffmann - Dermatologist
Dr. Martin Roxo- Neurologist
HPCSA Registration - 36369874
HPCSA Registration - 12233569
Type: Referring Doctor
Type: Assisting Doctor
E-mail address - lhoffmann@yahoo.com E-mail address - mroxo@mweb.com
Cellular - 0812457896
Cellular- 0814747896
6. Add the following medical aid numbers (references) to the existing accounts.
- 1 Account
Medical AID Medical Aid
2 Number Surname First Name Scheme
Number
3
01 Shikongo Maria
NAMDEB
500711
4
02 Uugwanga Petrus HERITAGE
500712
5
03 lyambo Elizabeth NMCRUBY
500713
6
04
Angula John
PROSPERITY 500714
7
05 Nakale
Sophia NMCGOLD
500715
8
06 Nekundi Simon LIBERTYLIFE 500716
7. You have to add the following reasons to the Suspension list.
7.1 Emigrated
7.2 Account Overdue
8. Select the Account group "Bad Debts" and "Overdue Payments" place a financial
block on it.
9. Please create a new practice template called Test Results and type the following
details on it. Attach this letter to Maria Shikongo and print a copy of it: Type your
student number and name in brackets at the end of the letter and print a copy.
|
|
9 Page 9 |
▲back to top |
<PA TIEN1FIRS1NAME> <PA TIENTSURNAME>
<PATIENllDENllTY>
<PA TIENIBIRTHDA 1E>
<DA TEOFSERVICE>
Subject: Test Results for
Dear <PATIENTTITLE> <PATIENTSURNAME>
I hope this message finds you well. I wanted to inform you about the results of your
recent kidney stone test
Test Name: Kidney Stone
Results: The results show that you have a small kidney stone in your left kidney.I
Key Findings: The stone is small and may pass on its own with increased hydration.
Next Steps: We recommend scheduling a follow-up appointment to discuss treatment
options. We also suggest a follow-up ultrasound in six months to monitor your
condition.
If you have any questions or would like to discuss the results in more detail, please
don't hesitate to contact us at < PRACTJ CE_ TELEPHONEN UMBER>_
Thank you, and take care.
Name & Student Nr of Student
10. Insert the following dependents to the following accounts.
MAIN
MEMBER
Simon Nekunde
Elizabeth lyambo
DEPENDANT
Desiree Nekundi (0006)
Date of Birth: 10 February 2021
Allergies: Atenolol
Isaiah lyambo (003))
DOB: 07 June 2015
Allergies: Loperamide
11. Please create the following Macros:
Macro
Procedure
THY101
Thyroid Infection
CYST02
KID303
Breast Cyst
Kidney Stones
Your Code Description
014E
Y64I
AL2W
U893
C7U4
3D67
48C2
V5Q7
5QU2
08FF
38J6
AGM5
Sterile Zone Kit
Gloves PEHA Soft
Scalpel Medi Safe
Anaesthetics Sys
Maple
Biopsy Gun Super
Tray Dressing Swab
Pain Balance Cap
Surgical Spirit
Ureteric Stent
Pencan Needle 27G
Kidney Stone DRP
Pain Cap
|
|
10 Page 10 |
▲back to top |
q
12. Post the following Macro's to these patients:
Maria - CYST02
Petrus - KlD303
Sophia - THY101
13. Settle all the Payments as cash payments
14. Make the following appointments:
14.1 Ms Karen Fabiano (a new patient) Cell: 0812254222 needs an urgent appoint. Dr
Amutenya is available on the 20th November 2024 at 09:00
14.2 Schedule an appointment for a normal consultation for Sophia Nakale for the 11th
of November 2024 at 11:00.
14.3 Ms Maria Shikongo, walks into the practice, she has an emergency and Dr Petrus
Nghipandulwa is available to see her immediately.
14.4 Ms Karen Fabiano phoned back and needs a longer appointment. Please extend
the appointment until 10:00
14.5 Sophia also called back; requesting that her appointment be postponed due to
work commitments. Please shift the appointment to the Friday of the same week.
15. Print the Daily Transaction Report to verify all the transactions for the day.