 |
MOA621S - MEDICAL OFFICE APPLICATIONS 2B - 1ST OPP - NOVEMBER 2022 |
|
|
1 Pages 1-10 |
▲back to top |
|
|
1.1 Page 1 |
▲back to top |
n Am I BI A u n IVER s ITY
OF SCIEnCE Ano TECHnOLOGY
FACULTY OF COMMERCE; HUMAN SCIENCE AND EDUCATION
DEPARTMENT OF GOVERNANCE & MANAGEMENT SCIENCES
QUALIFICATION: BACHELOR OF BUSINESS AND INFORMATION ADMINISTRATION
QUALIFICATION CODE: 07BBIA
LEVEL: 6
COURSE: Medical Office Applications 2B
COURSE CODE: MOA621S
DATE: NOVEMBER2022
DURATION: 3 Hours
SESSION: PRACTICAL
MARKS: 160
EXAMINER(S)
MODERATOR:
FIRST OPPORTUNITY - QUESTION PAPER
Ms L Beukes
Ms A Schroeder
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 QUESTION PAPER CONSISTS OF 10 PAGES (Excluding this front page)
|
|
1.2 Page 2 |
▲back to top |
Question 1
Marks: 35
Retrieve Question 1 with the Track Changes from your folder and adhere to the
instructions. Ensure that you execute all the instructions and that you don't leave out
any important information. Use normal margins and the font.
L----------------------------------------
ff;NG:Y·
,I
f-IANQSI'-----------------------------------.
Whe&-yetH:l&ideto hire a ,4f-tualassislant, you're likely going lo be hiring a 1099 conlrnctor.
Introduction
Commented [BL(1]: Use the link below to insert logo on
the top left corner:
https://www.google.com/search?q=fancy+hands+loga&rlz=
1ClGCEU_enNA967NA967&oq=&aqs=chrome.0.69i59i45018
>=.2=64=8=2'=59=0=0J;,,,·01;,,,·1=S&=s=o=ur=c=ei=d=,,;,,=hr=o=m=
Commented [BL(2]: Insert Word Art:
Fill: Black, Text 1, Outline- Background 1, Hard Shadow-
Background 1
A virtual assistant typically provides low-cost solutions to easy, one-off tasks whereas a remote
executive assistant will nroactivelv look for wavs to add value and enhance vour efficiency
(while effecti\\1ely managing your schedule. inbox. and other complex or sensitive [askgl.,________....-
1. Schedule
Virtual Assistants work their own seHe6-tllesproernmsand take on clients as they want and need. '"'.
There's wiggle room with project management and the responsibilities they decide to take on
based on thei1·:;kill level and deliverables.
Commented [BL(3]: Pleaseuse the following link to Insert
reff!rencefor website
https ://www. lin kedin.com/pulse/executive-assistant-
vlrtual-whats-difference-emilie-given
Formatted: Line spacing: Multiple 1.15 Ii, Numbered +
Level: 1 + Numbering Style: 1, 2, 3, ... + Start at 1 +
Alignment: Left + Aligned at 0.25" + Indent at 0.5''
Formatted: Font Bold, Italic
1.1 Specialized Fields
Formatted: Font: Bold, Italic
Some virtual assistants only specialize in specifics like:
1V~:-;-.-tl}R!ci['ie.\\s:_ign_\\-_York,
Jgpinent:
,.01:
~__:.£QP._Y_-'_~_l ______________________________
__..--f Commented [BL(4]: Insert bullets, s/s
l
2. Executive Requirements
Iv It's important to match the right with ours ecific executive su ort needs, and all the
responsibilities that come with it.
2.1 Difference between Executive Assistant and Virtual Assistant
Formatted: Numbered + Level: 1 + Numbering Style: 1,
2, 3, ... + Start at: 1 + Alignment: Left+ Aligned at:
0.25" + Indent at: 0.5''
.C_o_mff!ented [BL(S]: Type in Full, Bold
g~fl~.!·T&eH_e:&succcedinqg_iffer~ns;beetw~l'<Q1I1~-!!:and V is tti:ere uirement to1ed~ucation.-
IJ.li~.~gai!l,i-s_depepden_0t1),)Vhatyou need·them lo cjo..UL_High-pr9file dl<;n\\s'tn,igh_wt ant [()
~§e fle,ngthy re.sumej:Jefore11rnkin_gadecisi9q. Lll. Qther~1nigh_nto~be_~ ~str.ic(
~.QmJ<Ji~~efi-enqe, a dipi'onw,or-somee~jjege·Ri)'gb~etall _that'·n, e_ede~to_see_urthe,ejob.
2W'4;'yirii;ai assistai1tshave a.wide r_angeofed_ucationand skill leveis. B.utbcC(!UthSeGy a_ro
-Co_mmented [BL(6]: Type abbreviation in full, Bold
Commented [BL(7]: Type in full, Bold
|
|
1.3 Page 3 |
▲back to top |
L---------------------------------------~----
IF,b._NHCA:NYDSIL____________________________________
When you-4ecidcto hire a virtual assistaRt,you~e
lnlroduction
hiring a 1099 contro.cter.-
Commented [BL(1]: Usethe link below to insert logo on
the top left corner:
https ://1vww.google.com/search?q=fancy+hands+logo&rlz=
1ClGCEU_enNA967NA967&oq=&aqs=chrome.0.69i59i45018
~;=-=2=64=8=2=59=0=0;.jO;.jl=S=&=so=u=rc=e=id===cl=,r=om=e&=l=e==U=
Commented [BL(2]: Insert Word Art:
Fill: Black, Text 1, Outline-Background 1, Hard Shadow-
Background 1
A virtual assistant tvpically provides low-cost solutions to easv. one-off tasks whereas a remote
executive assistant will uroactivelv look for wavs to add value and enhance vour efficiencv
(while effectiv ely managine vour schedule. inbox. and other complex or sensitive ~askd).
Commented [BL(3]: Pleaseuse the following link to insert
I. Schedt 1le
------reference for website
https://www.linkedin.com/pulse/executive-assistant-
...... virtual-wh~ts-difference-emilie-given
Virtual Assist ants work their own sch€ffitlesproerams and take on clients as they want and need.
Formatted: Line spacing: Multiple 1.15 Ii, Numbered +
There's wiggl e room with project management and the responsibilities they decide to take on
Level: 1 + Numbering Style: 1, 2, 3, ... + Start at 1 +
based on their :,kill level and deliverables.
Alignment: Left + Aligned at 0.25" + Indent at 0.5"
Formatted: Font Bold, Italic
1.1 Specia lized Fields
Formatted: Font: Bold, Italic
Some virtual assistants only specialize in specifics like:
[gFaj:>Jid'iecsign work,
w~I.i.9_(?.VeloR.J:nent,
~!.~~£11ry~,or
actcicopy, '------------------------------~
2. Executive Requirements
It's important to match the right [v with 'Ours Jecific executive su
responsibilities that come with it.
ort needs, and all the
2.1 Difference between Executive Assistant and Virtual Assistant
[?'f:.( Tl~e~succeeding cl_ifferencebetw~~n an.It;: .and . is the re uii:ement for.educ;ati.on..
Fi'Is~gfii~, is dependent 011what you need thern to do. li.L_High-profile cli~ni~:rQjghtyvant tq
a §~.2-J~hgt4)' reSUJHe_b~foremaking decision. 2.1.3 Others might not I:,eas_~strict,
.
~~~tigh!,en20riei_:icae,d!plo-,or some co.llege_1nigh!beall that;_sneecledt.(! §·ec~!:.et1!~j9b_.
~--- a. [T:g
V-ir·tu.al
assist~ts
..
have
.
wide
range
of
e~uc~ti_O_ruI)1dskill
-·. .
le.vels:
But_bec.a:·u- siehey~e.,
rn_~p_g~K-l-i~~Bt1,they--t1ften-i-l:'l~ffitflu-iltg-eooeafH:ln-eur
as!ii.~~j,FiJns
pjg)_~t(_u~haY(!b_oii1college cm-H,al'ioo,a~ee,;
Virtual assistants have more flexibility with their hours and ru·eself-employed meaning you have
a lower overhead (employment taxes, benefits, and physical space,-ete). Hours delegated are
really dependent upon your budget and need.
[ Cc;,mmented [BL(4]: Insert bullets, s/s
Formatted: Numbered + Level: 1 + Numbering Style: 1,
2, 3, ... + Start at 1 + Alignment Left + Aligned at:
0.25" + Indent at: 0.5"
Coinment~d [BL(S]: Type in Full, Bold
•Commented [BL(6j: Type abbreviation in full, Bold
C_ommented [BL(7]: Type in full, Bold
i'C:ommented [BL(B]: Insert Paragraph Heading: Flexibility
C_ommented [BL(9]: lnserts/s between sub paragraphs
|
|
1.4 Page 4 |
▲back to top |
•..,,,, .,, ', . . .· t~.h_ay~a ~v-id'r"af!g~of_e_~.QC.~atji_:ioits,nki(i'~ey~L..s"' . .
J~hgy.Q_re
~l~_e.ri_~l~~e: .a.cEJ!:lisitig,ci,t~ey-e;/teA-i~iri.e:ol½fln~udl~nqgation,. . _ _~,J{in
..,..,...=,...,_...,,.."""_,.,.,...-{'(j>f-l9...,il-ege-e~cati_on,
Virtual assistants have more flexibility with their hours and are self-employed meaning you have
a lower overhead (employment taxes, benefits, and physical space,--ete).Hours delegated are
really dependent upon your budget and need.
~tly, the big est difference between an EAam!·aVAis salar . The ran es can both be from
high to low, all depending on need, requirements, experience, and deliverables. Also worth
noting, executive assistants are typically hired for full-time work.
J L.-~--~~~~~----------------------------.:-.----
G d=
OO
Communication
;,
Proper Time
Management
;,
Top
Virtual Assistant
C:ommented [BL(8]: InsertParagraphHeading:Flexibility .
<!:ommented [BL(9]: Inserts/s betweensubparagraphs
<!ommented [l!L(1 OJ:Deleteextraline spaces
.<!og!_~_ented[BL(11]: InsertDr<?CPapover2 lines,Bold
<!:pmmented [BL{12]: Typeabbreviationsin full, Bold
Commented [BL{13]: Deletecurrentdrawingboxesand
replacewith your own.
_Usethe drawingtool, selectthe RoundedRectangleto draw
ttie shapes
•Outline 2¼
,Text inside:TimesNewRoman,12
'Typ_elastblockTop Managementin Fontsize14, Bold
t~,,}'.gµj-.g. }is.i_~e~:s ~l!JterJ;V11Y~J!itY.~olf_a1,g19.eoqa,s~i~t_ainstahr)o~tr.r.ice!c::~instesms 9f ~lJ,.atJh;,':lY~Sg™iYl <:;JJ?J!C~
aml life.L____________________________
__ ,•<!ommented [BL(14): Formatthis paragraph:
· .~old,Itali~,center
INSTRUCTIONS:
1. Type Document in Times New Roman, font size 12, s/s.
2. Adhere to all the typing rules.
3. Use the following Heading styles for the Table of Content:
Introduction: Heading 1 (Times New Roman, Black, Font size 16, Bold)
Paragraph Headings 1, 2, 3 - Heading 2 (Times New Roman, Black, and Font size 14, Bold)
Paragraph Headings 1.1, 2.1- Heading 3 {Times New Roman, Black, Font size 12)
4. Insert Page numbers except for the first page (Top of page - center)
5. Insert diagonal watermark: ORIGINAL
6. Use Automatic Table2 for the TOC.
7. Insert Reference List
|
|
1.5 Page 5 |
▲back to top |
4
Question 2
TOTAL: 35
Retrieve the Spreadsheet named "Regional Sales- Households" and adhere to
the following instructions.
Sheet 1 - Erongo Region
Sheet 2 - Omaheke Region
INSTRUCTIONS:
1. The store of these two regions use of the same items/products but they are
paying different prices. Open another sheet - Sheet 3 and rename it as Total
· Cost. Copy the sheet of Erongo Region to sheet 3. Delete all columns except
Description column and Price column (please delete the prices in this column).
Please calculate the prices of both regions and insert it in the Total Cost sheet.
2.
On the Total Cost Sheet:
2.1 Insert two rows:
pt Row - Insert Heading - Total Cost (u/c, Bold, font Arial Black, size 16, merge
& centre)
2.2 Please apply a custom number format for the numbers to show a comma
separator for the Total Cost Colum and add two decimals.
2.3. Apply a custom number format to show the N$ currency sign on all the figures.
2.4 Row Height:
Column Headings row height - 45 pixels
Rest of rows - 35 pixels
2.5 Column Headings (Arial, Bold, Font size 14) with background color of White
background 1, 15%.
Formatting:
3. Copy the Sheet named Omaheke Region from the workbook to a new workbook
and rename the sheet as Original.
3.1 Change the font to Arial, Font size 12.
|
|
1.6 Page 6 |
▲back to top |
5
3.2 Insert two line space on top and add the heading - REGIONAL PROMOTIONS
2022 in the first line (Merge and Centre, Bold, Font Size 16, Font Arial).
3.4 Insert All Borders (excluding the Main headings)
3.5 Row Height:
Column Headings - 45 pixels
Rest of table - 30 pixels
3.6 Column Headings - bold the column headings and insert background color -
White Background 1, Darker 15%
3.7 Apply a custom number format to show the N$ currency sign on all the figures
and add two decimals.
3.8 Print the Original sheet of the Omaheke Region.
Filter:
4. Copy the Original sheet five times and do the following filtering with the renaming
accordingly:
4.1 Sheet 2 - Display the items with the letter "h" only.
4.2 Sheet 3 - Show only the dates for the year 2009.
4.3 Sheet 4 - Please show the addresses that ends with the letter "s".
4.4 Sheet 5 - Please display only the excellent conditions.
4.5 Sheet 6 - Display only the prices between 800 and 2200.
5. Insert the header for each sheet.
6. Print all filtered sheets in portrait.
|
|
1.7 Page 7 |
▲back to top |
6
Question 3
TOTAL: 15
Retrieve the Books2022 and adhere to the instructions that follow:
INSTRUCTIONS
1. In the Database Books2022 use the table Jobs to create a
simple query that will display the job_id and job_desc.
2. Use the table Books to create an action query that will
display the Title, Price and Royalty with a minimum of 10.
3. Use the table Employees and Jobs. Right-click on the current
link and press delete. Create a new joint table with job_id.
Create a query that will display the employees who are
publishers.
In the Books2022 database, under Queries use the table
Publisher to create a report - format it as follows:
2. Create a header titled "Namibian Publisher"- Font Algerian,
Size 20, Bold, u/c, Colour - Blue Green, Theme - Organic
3. Insert page numbers which shows the current page and total
number of pages at the bottom centre position.
4. Insert the Date at the right bottom corner.
5. Go to layout view and resize all columns to fit perfectly.
6. Print all queries as well as the report.
|
|
1.8 Page 8 |
▲back to top |
7
Question 4
IVlarks: 15
As an entrepreneur of a Book Store called The Book Spot, you are planning a
campaign to make people aware of your venture. Please create an informative,
attractive flyer with tear-offs, using Ms Publisher 2016.
INSTRUCTIONS:
1. Use the flyer under the heading Built it, under Flyers select Colour Band under
the grouping Marketing. Use the option tear-offs for the contact information.
2. Use customize colour scheme to Apex.
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. Replace Product/Service Information with The Book Spot (Font Badoni, size
26, u/c, bold - Centre).
6. Find the following pie
description The Book
corner next to the Title.
G1f)
via the search engine Bing with the
Spot logo and place it at top left
7. Delete the content of Product/Service Information and replace with the
following:
About
The Book Spot is a bookstore founded by Reschelle Muller in 2010 which
offer the best, and great selection yet affordable books available in the
market.
Hello Book Spotters!
We are excited that you are taking this journey with us - whether you are
simply curious, interested or just as ecstatic as we are to re-introduce
reading as FUNDAMENTAL.
And that is true not only for kids. Reading for entertainment, to unwind,
process, learn and grow is equally FUNDAMENTAL for adults.
We believe in the strength of community. So, let's GROW places
together!
Type content in Comic Sans MS, font size 10. Type the two paragraph
headings in uppercase and bold.
|
|
1.9 Page 9 |
▲back to top |
8
8. Use search engine Bing to find the following picture of books and insert under
the content I the picture place holder.
9. Use your own Name and Surname for the tear-offs with your cell number.
10. Print your flyer.
|
|
1.10 Page 10 |
▲back to top |
i
ELIXIR QUESTION PAPER
MARKS: 60
Start Elixir and log into the General Practice option.
A new practice, Tsumeb Medical Centre just opened their doors. Since you are the new appointed
Medical Office Administrator, it is your responsibility to assist with the setup of the new practice.
Use the information below to set-up this new practice.
1.
Create the following Service Providers for Tsumeb Medical Centre.
-1
2
Provider
3 Dr.MarvinMbeseni
4 DrRoyRoxin
5 DrSelmaThesen
6 DrGertSichimwa
7 DrEricaDrews
8 DrBertusBergh
-
Discipline
Anaesthetist
GeneralSurgeon
Dermatologist
Homeopath
Orthopist
Radiologist
Dispensing
HPCSANR Cellular
E-mails
Registration
6565680SU323000mmbeseni@gmail.com 5551245
75656908U321111rroxin@iwav.com
0
8565700SU323555sthesen@iafrica.com 5557896
8565710S1232U12gsichimwa(a)gmail.com
0
8565720812323233edrews(a)hotmail.com
0
8565730812323322bbergh@gmail.com
5551478
2
Add the following accounts, resize the columns and remove all the unnecessary headings.
-
I
I
-1 Account
2 Number Surname lntials Firstname
IDNrs
I
Address
Town
I
I
MedicaAlID
Scheme
Provider
3 00016 Shivute F
4 00017 Samuels s
Festus 70010100107P0O0Box4569KARASBURGNAPOTEL Dr.MMbeseni
Sammy 75181200107P0O0Box1236TSUMEB NMCDIAMONDDrRRoxin
5 00018 NamukongLo Lina
80161000107P0O0Box4455ONGWEDIVANHPGOLD DrSThesen
6 00019 Binga E
7 00020 Matamu w
I A
Eva
85121200012P0O0Box2325RUNDU
NMCRUBY DrGSichimwa
Winnifred 92121000102P0O0BOX457K8EETMANSHOPROOFSPERITYDrEDrews
3
Add the following medical aid numbers (references) to the existing accounts.
-1 Account
2 Number
3 00016
4 00017
5 00018
6 00019
7 00020
Medical Aid
Number
222356
222548
222147
222458
222131
4.
Insert the following Accounting groups to your Database and delete others:
4.1 Normal -White
4.2 Rejection - Blue
4.3 Overdue payment- Yellow
5.
Set up the following Clinics:
5.1 Town Clinic
5.2 Lady M Clinic
5.3 Kuvukiland Clinic
|
|
2 Pages 11-20 |
▲back to top |
|
|
2.1 Page 11 |
▲back to top |
6.
You have to add the following reasons to the Suspension list and delete the others.
61 . Emigrated
6.2 Membership Terminated
6.3 Account Overdue
7.
Load the following Colleagues:
7.1 Dr Sheimi Shikulo, Practice nr 2349879, Cardiologist, Referring doctor- Private Bag 7896,
Mariental
7.2 Dr Saima Swartbooi, Practice nr 8989678 -Anaesthetist, Assisting doctor- Private Bag 67675,
Gobabis
7.3 Dr Helen Heibach Practice nr 8901243 - Chriropractitioner, Assisting doctor- Private Bag 876,
Windhoek
8.
From your existing accounts add the following dependants on their accounts.
Shivute Gillian, DOB: 20 December 2012, Medical Aid nr: 800125, Allergies: Amiloride
Namukongo Nelcy, DOB: 15 July 2020, Medical Aid nr: 8004545, Allergies: Ibuprofen
Binga John, DOB: 11 March 2011, Med Aid Nr: 700137, Allergies: Atenolol
9.
Please set the following appointments for the patients.
9.1
Ms Namukongo urgently needs an appointment for Thursday, 27th October 2022 with the
Dermatologist Dr Thesen. The only available time is at 9:00.
9.2 A new patient Ms Sinvula, walks into the practice, her first time visiting the practice. You need to
book an appointment for her for this week still. You find an opening on Friday the 28th of
October 2022 with Dr Bergh at 14:00.
9.3 Ms Namukongo phoned back and requested a longer appointment. Please extend the
appointment until 10:00.
10. Please create the following Macros:
Macro Procedure
Your Code Description
Head
(011)
Gyn
(012)
Head surgery
Gynaecological surgery.
Abdo
(013)
Bypass
(014)
Abdominal surgery
Bypass Surgery
KIR2
B8UE
LIM2
8PHI
IJ10
806E
12L3
RYM7
Y585
XTPI
OMR7
Biopsy
Sterile Pack
Limbitrol Cap
Aspen
Needle
Needle
Syringe
Abdominal Support
Gloves
Injection
Dressing
11. Post the following Macro's to these patients:
Sammy- HEAD011
Lina - GYN012
Eva- ABDO013
12. Settle all the Payments: Receipt Numbers:
12.1 Sammy-00014
12.2 Lina-1100
12.3 Eva- 1122
13. Print the Daily Transaction Report to verify all the transactions for the day.