 |
MOA611S - MEDICAL OFFICE APPLICATIONS 2A - 2ND OPP - JULY 2025 |
|
|
1 Page 1 |
▲back to top |
nAm I BI A u n IVE RSITY
OF SCIEnCE Ano TECHnOLOGY
FACULTY OF COMMERCE, HUMAN SCIENCES AND EDUCATION
DEPARTMENT OF GOVERNANCE AND SCIENCES, HOSPITALITY, TECHNICAL AND
VOCATIONAL EDUCATION AND TRAINING
QUALIFICATION: BACHELOR OF BUSINESS & INFORMATION ADMINISTRATION
QUALIFICATION CODE: 0788IA
LEVEL: 6
COURSE CODE: MOA611S
COURSE NAME: MEDICAL OFFICE APPLICATIONS 2A
SESSION: JULY 2025
PAPER: PRACTICAL
DURATION: 3 HOURS
MARKS: 150
SECOND OPPORTUNITY E)(AMINATION QUESTION PAPER
EXAMINER(S) Ms Lindie Tripodi
MODERATOR: Ms Petrina Lauw
INSTRUCTIONS
1. Answer ALL the questions.
2. Read all the questions carefully before answering.
3. Number the answers clearly
THIS QUESTION PAPER CONSISTS OF 8 PAGES (Including this front page)
|
|
2 Page 2 |
▲back to top |
Question 1
July 2025
.A.. NI A
U B I!•.:£!,,, IC,, iE B IE E lR. S P· A. [R T rr--.!El [R S. 1H I. rP
Question 1 - Project Planning
Marks: 30
De Beers Namibia is organising its Annual General Meeting {AGM) to discuss key
financial performance, sustainability initiatives, and future strategic plans. As the event
coordinator, you are responsible for ensuring the successful execution of this high-
profile corporate event. Event date: 16 August 2025. Start planning: 21July 2025
Consider the following tasks:
NR NAME OF TASI(
1. Booking the Venue
2. Arrangement for Catering
3. Technology (audio-visual equipment, live
streaming)
4. Arrange for Security and Risk Management
5. Materials (reports, presentations)
6. Stakeholder Communication & Invitations
7. Arrange for Meeting Facilitator
8
Confirm Attendees
9. Arrange for Meeting Administrator
10. Final check-ups and logistics
TASK
DURATION
1 Day
2Day
2 Days
RESOURCES
Adelaide
Philemon
Chris
2 Days
2 Days
2 Days
3 Days
2 Days
2 Days
2 Days
Chris
Philemon
Adelaide
Adelaide
Chris
Chris
Philemon
1. The Milestones for this event will be the following:
Deposit of 70 % to be paid for the:
(a) Venue
(b) Catering
(c) Security and Risk Management
Full Payments to be made for the:
(a)
Use of Technology
(b) Communication and Invitations
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 page 2 in
landscape orientation.
|
|
3 Page 3 |
▲back to top |
Question 2
July 2025
Question 2
Marks: 30
You are an administrative officer at NUST, responsible for sending personalized
invitation letters to graduating students. Using the given information below complete
the mail merge process. Type the following Main Document in font Comic Sans, size
12 and make use of the information at the end of the document to create a
standardised letter for each student.
Print the letter for 1\\/lsEmily White, the Excel Spreadsheet as well as the Mail
merged document.
Date: <Date>
Student Number: <Student Number>
Degree Programme: <Programme>
Dear <Full Name>
Congratulations! We are pleased to inform you that you have successfully
completed your degree programme and are invited to attend the upcoming
Graduation Ceremony. The details are as follows:
Date: <Date>
Time: <Time>
Venue: <Venue>
Please arrive at least 30 minutes before the scheduled time. Kindly confirm your
attendance by 12th of May 2025.
We look forward to celebrating your achievement with you!
Best regards
Registrar
Namibia University of Science & Technology
|
|
4 Page 4 |
▲back to top |
Question 2
July 2025
Student Nr
2024001
2024002
2024003
2024004
2024005
Full Name
John Doe
Jane Smith
Michael Brown
Emily White
David Johnson
Programme
Computer Science
Office Management
Data Analytics
Business
Administration
BCom Accounting
Date
Time
24 May 2025
24 May 2025
24 May 2025
24 May 2025
10:00
10:00
2:00
2:00
Venue
Safari Hotel
Safari Hotel
Safari Hotel
Safari Hotel
24 May 2025 5:00 Safari Hotel
Instructions for Mailing list
1. Type the spreadsheet in font Calibri, size 12.
2. Column Headings - Font size 14, Bold, u/c
3. Records -font size 12.
4. Row Height: Column Headings 40 pixels
Rest of Rows.30 pixels
5. Sort Full Name in ascending order.
6. Insert all borders.
7. Print excel spreadsheet in Portrait.
|
|
5 Page 5 |
▲back to top |
Question 3
QUESTION 3
Type the Pivot Table (Pupkewitz Megatech) below and adhere t
the instructions that follow.
MARKS: 40
Date
Store Location
1 Jan 2024 NewYork
2 Jan 2024 Los Angeles
3 Jan 2024 Chicago
4 Jan 2024 Houston
5 Jan 2024
6 Jan 2024
7 Jan 2024
8 Jan 2024
Phoenix
Philadelphia
San Antonio
San Diego
9 Jan 2024 Dallas
1OJan 2024 San Jose
11 Jan 2024 Austin
12 Jan 2024 Jacksonville
Product Name
Laptop
Phone
Tablet
Monitor
Keyboard
Mouse
Printer
Desk
Chair
Headphones
Camera
Smartwatch
Category
Electronics
Electronics
Electronics
Accessories
Accessories
Accessories
Office
Office
Office
Accessories
Electronics
Electronics
Sales Amount
1500
900
600
400
250
180
500
350
300
220
800
1200
Instructions:
1. Save the workbook as: Question 3 - Pivot Table
2. Rename sheetl to Original
3. Copy the Original sheet, rename the new sheet as Pupkewitz Megatech Store Sales.
4. Insert 2 rows above the column headings.
5. Insert Main Heading in row 1 - Pupkewitz Megatech Store Sales
(U/C, Bold, Merge & Centre, Algerian, size 18)
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 bold, u/c
6.3 Fill the background of the Column Headings (White Background 1, Darker 15%,
row height pixel 55), Row Height for colum heading 40 pixels.
6.4 Resize columns headings and change the row height of the rest of the table to
35 pixels.
6.5 Print formatted table in landscape.
7. Pivot Table:
7.1 Select the Original sheet and create a PivotTable.
July 2025
|
|
6 Page 6 |
▲back to top |
Question 3
7.2 From the options: select Count of Store Location to be displayed in the Report.
8. Add:
Product Name and Sales Amount.
9. Move:
Columns - Values
Rows - Category and Product Name
Values - Count of Store Location and Sum of Sales Amount
Rename the sheet tab - Report
10. Chart:
10.1 Create a Stacked Column chart from the Report.
10.2 Insert the following Chart Elements:
Chart Title - Pupkewitz Megatech Store Sales (Bold, u/c, centre)
Axes: Primary Horizontal & Vertical
Data Lables - Inside End
Legend - Insert on the Right
Gridlines
10.3 Select Style 7 from the chart styles.
10.4 Make sure both the table and chart fit on one sheet and print in portrait.
July 2025
|
|
7 Page 7 |
▲back to top |
Name
QUESTION 4
Question 4
Elixir (Memo)
The Keetmanshoop Health Centre, located in the Karas Region, has requested your
assistance as a Medical Office Administrator to set up their new medical practice.
Your task is to ensure the smooth setup of the practice by completing the following
steps. Please use the provided details to carry out the required tasks.
1.
Create the following service Providers:
July 2025
MARKS: 60
• KEETMANSHOOP
Provider
Discipline
HPCSANR Cellular
Dr. Leonard G. Louw General Practitioner L12345 081234567
Dr. Christina Garas
General Practitioner CG000l 081345678
Dr. Gabriel Hawaseb Optometrist
GH3112 081456789
Dr.Sophia Engelbrecht General Surgeon SE4221 081567890
Dr. Neriene Goreses Homeopath
NG5522 0811255698
2.
Create the following accounts for each patient.
Dispensing Dispensing Registration
Yes
987654321
No
NIA
Yes
2232321
SurnameInitials FirsNt amAe ddressTown MedicAaildSchemIeDNumber Provider Email
Awaseb P.J. Phillip POBox12KeetmanshoNoapmmed
8501230500D12rl3ouw phillip@domain.com
Uiseb C. Chel)'l POBox3T23ses
lnvestmed
9002010740D23rG4 aras chel)'l.u@gmailcom
NekongoG. Niel POBox25B8erseba Vitality
7801120134D56rH7awaseb nnekongo@gmail.com
Witbooi N. Neriene POBox22K2oes NHPGold
7003280538D79rE0ngelbrechtnwitbooi@gmailcom
Mouton S. Sophia POBox1A24roab Napotel
8512240670D98rG2 oreses sophia.m@gmail.com
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 Keetmanshoop Clinic
4.2 Private Clinic
5.
Load the following Colleagues:
5.1 Dr. Cedric Hammond - HPCSA:CH2345 - Neurosurgeon, Referring Doctor
5.2 Dr. Cynthia Helmut - HPCSA:CH2001- Neurologist, Referring Doctor
5.3 Dr. Kevin Beukes - HPCSA:KB77800 - Anaesthetist, Assisting Doctor
6.
Add the following medical aid numbers (references) to the existing accounts.
Surname
Awaseb
Uiseb
Nekongo
Witbooi
Mouton
Medical Aid Scheme Numbers
Namdeb
NAM144
lnvestmed
INV445
Vitality
VIT787
NHPGold
NHP4789
Napotel
NAP3696
|
|
8 Page 8 |
▲back to top |
Name
1
Question 4
Elixir (Memo)
July 2025
7.
You have to add the following reasons to the Suspension list.
7.1 Account Overdue
7.2 Emigrated
7.3 Deceased
8.
Select the Account group "Benefits exceeded" and place a financial block on it.
9.
From your existing accounts, please open the following accounts and add the following children as
dependants on their accounts.
Patient
Phillip Awaseb
Sophia Mouton
Dependent
Nerro Awaseb
Aiden Mouton
Relationship
Child
Child
Date of Birth
12 December 2012
10 September 2009
Allergies
Citric Acid
Ibuprofen
10. Please create a new practice template called Wellness Awareness Day and type the following
details on it.
<PATIENTFIRSTNEA>M<PTAIBHSURNAEM>
<ADORES&\\>
<ADDRESSB>
Dear<PATIENTTITL<EP>ATIENTSURNAME>
Wearepleasetdo inviteyoutoourupcorrunWgelnesAswarenesDsayon10thofJuly2025at
ourClinicpremiseisnKeetmanshoop.
Thiscommunietyvenwt ilflocusonHelathlyivingn, utritiona,ndmanagincghronicondttions,
withtalksfromourmedicaplrofessionaflrse,escreeningasn, dwellnestsips.
Joinusandtakeasteptowardbetterhealth!
Yoursingoodhealth,
NameofStudent
PRACTICMEANAGER
11. Use the Mail Merge function and Merge the account of Cheryl Uiseb with this letter.
Type your student number and name in brackets at the end of the letter and print a copy.