 |
MOA611S - MEDICAL OFFICE APPLICATION 2A - 2ND OPP - JULY 2023 |
|
|
1 Page 1 |
▲back to top |
" nAmlBIA unlVERSITY
OF SCIEnCE Ano TECHnOLOGY
FACULTY OF COMMERCE, HUMAN SCIENCES 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: July 2023
DURATION: 3 Hours
SESSION: Practical Paper
MARKS: 160
EXAMINER(S)
MODERATOR:
SECOND OPPORTUNITY - QUESTION PAPER
Ms L Beukes
Ms S Klaassen
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 |
Question J.
The company Silk :are planning to launch the new product
Citrus Silky which consist of a Body Wash, shampoo,
conditioner and serum. Silk is a smooth and soft product
which is 100% pure organic aroma & ingredients, created to
awaken your body,and uplift your mind.
As the sole owner and office administrator in the Marketing
Department, you have been tasked to co-ordinate the
planning process. The event date is scheduled for Saturday,
the 2nd of September 2023. Planning will start from the 7th
of August 2023.
r,
·--,
I
.,
:.J.
t'.JtlJr
• JIOSllV
ll011
r:·•· ' ..=.:-.
-,=:·
, ..
(
:1r:c II
$:tr.ngl/1
,<~"f;6s:~.,1_,.,i"o
The Fundraising event team-building event is made up of the following tasks and resources:
NR NAME OF T/l.SI{
TASK DURATION RESOURCES
1. Define Your Target Audience
2 Days
Helvi
2. Book a Venue
1 Day
Sunet
3. Design Flyers
3 Days
John
4. Entertainment & Sound System
3 Days
Sunet
5 Gifts and Snacks
2 Days
Helvi
6. Programme Design
2 Days
Sunet
7. Media and Photographer
2 Days
John
8. Programme Director
2 Days
Helvi
9. Confirm guest list
2 Days
Sunet
10. Final check-ups and logistics
1 Days
John
1. The Milestones for this event will be the following:
Deposit of 50 % to be paid for the:
{a) Venue
{b) Design of the Flyers
{c) Gifts
Full Payments to be made for the:
{a) Entertainment & Sound System
{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 and 2.
|
|
3 Page 3 |
▲back to top |
Question 2
Question 2 (Managing Tables)
July 2023
l\\/larks: 20
Use MS Word to type the following template and table. Adhere to all the
instructions.
1. Please open the MS Word template Retail Sale Flyer.
2. Replace SUNFLOWER with SUNFLOWER SALE
3. Delete Don't miss out on your chance to SAVE! and replace with We're All
Golden Sunflowers Inside (u/c, bold, cent)
4. Delete all information on the left of the sunflower picture.
5. Use the draw table tool to create a table in the space you just cleared. Type
the content in the font Calibri, font size 12, as shown in the template below.
Types
Quantity
Price
Total
Common
25
65
Perennial
30
75
Maximilian
50
85
Pale-
40
95
leaved
6. Formahing of table:
Column Headings - u/c, bold
Autofit to content
Insert caption below: Sunflower Prices
Calculations:
Total price of each sunflowers.
Add a Total row at the bottom to calculate the totals of all the columns with
the word TOTALS in cell A6
7. Delete Logo
8. Replace 'Sale prices good through Date'
with
Sale prices: 01- 31 August 2023
9. Store Hours: 08:00 - 17:00
10. Delete the Time indicators.
11. Company Name: Scyscraper (u/c, bold, font size 14)
Address: Sam Nujoma Drive
City: Windhoek
Tel: 061-211232
Website: www.scyscraper.namibia
Delete: 'Additional directions or other information'
|
|
4 Page 4 |
▲back to top |
Name of Student
'I
June 2023
Question 3
Marks: 30
Type the following Letter of Application as the Main Document and standardised
letter for your prospective companies. Use the table at the end of the question to
create a mailing list. Merge the two documents to create personalised letters. Use
font Comic Sans, size 12 to create the main letter.
Print only the letter for Bidvest, the Mailing List as well as the Mail merged
document.
((Co111pany»,«Address» «Town» <1--
Dear «Recipient»
Typist, please display
correctly
APPLICATION LETTER
Are you looking for an effective and productive «Job Title» with
«Number» years of hands-on experience in «Expertise»? }
Knowledge of the latest technology and Ms Office 2019?
Excellent written and oral communication skills?
I insert Bullets, s/s
A passion to learn and to increase his skills?
If so, then you need look no further. You will see from my enclosed resume
that I meet all of these qualifications and more.
1. I would very much like to discuss opportunities with «Company». 2. To
schedule an interview, please call me at «Phone». 3. The best time to reach
<l. me is between 10:00 and 16:00, but you can leave a voice message at any
time, and I will return your call.
Thank you for taking the time to review my resume. I look forward to talking
with you.
Yours sincerely, Ellen de Koe, Bia Student
Typist, please display
correctly
|
|
5 Page 5 |
▲back to top |
Name of Student
· June 2023
'
FIELDNAMESRECOR1D
RECOR2D
Company iNampower · Namwater
Address PrivateBag122 POBox120
Town
Windhoek
Okahandja
'
RECOR3D
'
RECORD4 RECOR5D
BankWindhoek Paratus
BidvestNamibia
PrivateBag311 PrivateBag1300POBox121
Swakopmund Rundu
Gobabis
Recipient
JobTitle
Number
Expertise
Phone
Ms Bock
l\\i1rGreen
Ms Hoebes
MrAngula
MsAndreas
Receptionist OfficeAdministrator PersonaAl ssistant OfficeManager EventCoordinator
10
12
8
6
5
Front-deskduties OfficeManagement Personaal ssistancSEupervisor Events
0812223652 0812223652
0812223652 0812223652 0812223652
Instructions for Table:
1. Use Font Calibri, 12
2. Column Headings: Bold, u/c, size 12, Row Height: 35
3. All Borders
4. Rest of row: Row Height: 30
5. Print Mailing List in Landscape.
|
|
6 Page 6 |
▲back to top |
Question 4
Pivot Table
QUESTION LJ.
Retrieve Question 4- Pivot Table (Property Porfolio) from your M-drive and adhere to
the instructions that follow.
July 2023
MARKS: 20
Instructions:
1. Retrieve the following table in Excel and save the workbook as: Question 4 -Pivot Table
2. Rename sheetl to Original
3. Copy Orinal table and rename the new sheet as Property Porfolio
4. Insert 2 rows above the column headings.
5. Insert Main Heading in row 1 - Property Porfolio and format:
(U/C, Bold, Merge & Centre, Calibri, 18)
6. Edit the table as follows:
6.1 Change the font of the entire table to Calibri font size 12.
6.2 Change the column headings to font size (12), bold,.
6.3 Align column headings in the middle of cell and centre position.
6.4 Fill Column Headings (White Background 1, Darker 15%) row height pixel 45
6.5 Resize columns headings and change the row height of the rest of the table to 30 pixels.
7. Pivot Table:
7.1 Select the Original sheet and create a PivotTable.
7.2 From the PivotTable Field List choose Sum of Bedroom by location to be displayed in the Report.
7.3 Move Location to Column Label and Bathroom and Bedroom to Row label with Type under value
7.4 Rename the sheet tab - Report
8. Chart:
8.1 Create a Column chart from the Report
8.2 Insert the following Chart Elements:
Axes (Horizontal & Vertical Primary)
Chart Title - Property Portfolio (Bold, u/c, Centred)
Data Lables (Outside End)
Gridlines - Primary Major Horizontal
Legend - Insert on the right
8.3 Select Style 13 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 |
Name
QUESTION 4
Elixir Paper
2nd Opportunity
July 2023
MARKS: 60
Start Elixir and log into the General Practice option.
The Nkurenkuru Health Centre, in the Okavango Region, 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.
-
Provider
Dr Immanuel Nehare
Dr Willem Okorusu
Dr Peter Pretorius
Dr Bert Brandt
Email Addresses
inehare@iway.na
wokorusu@hotmail.com
ppretorius@africaonline.na
bbrandt@gmail.com
Discipline
General Practitioner
Plastic Surgeon
Physiotherapist
Cardiologist
HPCSANR Cellular Dispensing
11136575 0812323568 No
11136576 0812323569 Yes
11136577 0812323570 Yes
11136578 0812323571 Yes
Dispensing
Registration
-
112467
112444
112222
2.
Create the following accounts for each patient.
I
MedicaAlID
SumameFirsntame IDNUMBERSPostaAlddress Town Scheme
EmaAil ddress
Provider
Awaseb Phillip 75090900254P1r0ivatBe ag477OTJIWARONNGMOCRUBY paswaseb@gmail.DcorImmanuNelehare
Goosen Adolf 900818002541P0OBox988 RUNDU NHPGOLD agoosen@nust.naDrWillemOkorusu
HaukambFeredericka820515000147P8OBox156 OSHAKATLIIBERLTIYFE fhaukambe@iway.DcorPmetePr retorius
Fisch Eileen 92121000142P5ri0vatBeag2511 TSUMEB COMPLIMPELDUSefisch@telecom.naDrBBrandt
Petrus Abednego930711000256P3OBox1569 ONGWEDIVPAROSPERITYapetrus@gmail.comDrWillemOkorusu
3.
Insert the following Accounting groups to your Database:
3.1 Bad Debts - Orange
3.2 Normal - White
3.3
Private Patients - Pink
3.4
Payment overdue - Yellow
3.5
Benefits Exceeded - Green
4.
Set up the following Clinics:
4.1 Nkurenkuru Clinic
4.2 Okavango Clinic
4.3 Private Clinic
5.
Load the following Colleagues:
5.1 Dr Sophia Engelbrecht, HPCSA: SE4221, Referring doctor - Dermatologist, Private Bag 8811,
Rundu.
5.2
Dr Gabriel Hawaseb, HPCSA:GH3112 -Assisting doctor -Anaesthetist, Private Bag 771 Tsumeb.
5.3
Dr Cheryl Garas, HPCSA:CG000l - Referring doctor- Urologist, Private Bag 222, Tsumeb.
6.
Add the following medical aid numbers
(references) to the existing accounts.
-
Medical AID
Surname First name Scheme
Medical Aid
Number
Awaseb Phillip
NMCRUBY
NMC1133
Goosen Adolf
NHPGOLD
NHP2121
Haukambe Fredericka LIBERTYLIFE
LIB1235
Fisch
Eileen
COMPLJMED PLUS COM6622
Petrus
Abednego PROSPERITY
PR08989
|
|
8 Page 8 |
▲back to top |
7
Name
Elixir Paper
2nd Opportunity
July 2023
7.
The following new service provider has joined the medical field
Details
Discipline
HPCSA
Registration
Cellular
Email Address
Dispensing
Dispensing
Registration
Dr Neriene Goreses
Homeopath
NG5522
0811255698
ngoreses@mweb.na
Yes
2232321
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
Phillip Awaseb
Fredericka Haukambe
DEPENDANT
Nerro Awaseb
DOB: 12 December 2012
Allergies: Citric Acid
Aiden Haukambe
DOB: 10 September 2009
Allergies: Ibuprofen
DEPENDANT
Rachel Awaseb
DOB: 22 October 2001
Allergies: Atenolol
11.
11.1
11.2
11.3
11.4
11.5
Make the following appointments in the Elixir Diary
Fredericka phone the practice for a normal consultation with Dr Pretorius 10th August 2023 at
10:00.
A new patient Ms Hedwig Julius, walks into the practice, she has not been there before. Book an
appointment for her for 26th September 2023 at 14:00 with Dr Brandt.
Make a new appointment for Mr Festus (a new patient) Cell: 0812525987 with Dr Goreses on the
11th September 2023 at 11:00
Fredericka phoned back and wanted a longer appointment. Please extend the appointment until
11:00
Please move the appointment of Ms Hedwig to Friday, the same week, same time.
|
|
9 Page 9 |
▲back to top |
Name
Elixir Paper
2nd Opportunity
July 2023
12. Please create a new practice template called Medical Necessity and type the following details on
it.
<PRACTICE_POST AlADDRESS1 >
<PRACTICE_POST AlADDRESS2>
<PRACTICE_POSTALADDRESS3>
Dear DR PETER PRETORIUS
LETTER OF MEDICAL NECESSITY
I am referring <PATIENTFIRSTNAME> <PATIENTSURNAME> for evaluation and consideration
for a weight management surgical procedure.
I have been <PATIENTFIRSTNAME>'s primary care physician for the past 5 years.
I have supervised several of her weight control diets and programs. None of these
have resulted in any sustained weight loss. Currently my patient suffers from:
1. Hypertension - 3 years
2. Obesity Related - Depression
Losing weight will certainly make these conditions easier to manage. Since non-surgical
programs have failed to provide any long-term benefits for the patient, I feel surgery is
her only option.
Yours sincerely
Dr. Nehare
GENERAL PRACTITIONER
(Student nr and full name)
13. Use the Mail Merge function and Merge the account of Eileen Fisch with this letter.
Type your student number and name in brackets at the end of the letter and print a copy.