School Based Assessment-Edited 2017
School Based Assessment-Edited 2017
School Based Assessment-Edited 2017
SBA 2017
---------------------------------------------------------------------------------------------------------------------------------------------------
Guidelines:
Territory (Jamaica)
Teacher
The SBA is designed to give students the opportunity to demonstrate, on a timely basis, their ability to
solve problems using computer applications such as:
o Database
o Spreadsheet
o Word Processing
o Programming Language
Students must ensure they have necessary backups of their work as this will alleviate any undue delay of
submission caused by malfunctioning thumb drives, hard drives, etc. A good backup is for students to
email their work to themselves periodically.
The SBA project is marked out of 90 and is worth 30% of your final CXC-CSEC examination grade.
There is an outbreak of Chic-V in JAMLAND and the Ministry of Health has set up a taskforce (Chic-V
Eradication Task Force) to monitor the affected communities and parishes. The parishes affected are
Queensland, Fairyland, Portabello & Irish Town; the number of reported cases is increasing since the first case
was confirmed August 1, 2014. As of September 17, a total of 50 confirmed cases were reported by personnel
from the health centres in the affected communities.
You have been hired as an Information Systems Specialist whose duties include:
Recording and monitoring information collected from the health centres of persons who have contracted
the disease in a properly maintained database.
Recording information, calculating costs, analysing and presenting information on patients’ visits gathered
from the four parishes using electronic spreadsheets.
Prepare letters to be sent to health officials, et al. of the affected regions inviting them to attend a meeting
to assess the control measures implemented to combat the spread of disease; create a brochure to
inform the public of the dangers of the disease associated and measures to combat the spread of
disease symptoms using a Word Processor.
Develop and test an algorithm using Pseudocode or Flow Chart.
Write a code to implement the algorithm using Pascal Programming Language
Database Management
TASK A
1. Create a database that stores information on all Chic-V patients received from personnel at the health
centres in the affected communities. You may accept at least thirty but no more than forty patients.
VISIT Table
WD03, NN04.
Insurance Name Magicor ( MG01), Medisure (MS02), Warden (WD03) Or None (NN04)
Fees Doctor’s Fees based on the following:
Type of Health Fees $
Centre
Type 1 1550
Type 2 2500
Type 3 3000
INSURANCE Table
FIELD DESCRIPTION
Insurance Code 4 Digit Code identifying the Company MG01, MS02,
WD03 NN04
Insurance Company Name of Insurance Company MG- Magicor, WD,
Warden and MS- Medisure, NN-None (NN indicates
that the patient does not have any insurance
coverage)
Coverage Percentage Coverage
MG – 80%, MS – 70 %,WD – 75% and NN -0%
TASK A
TASK C
Prepare a report which lists the names of all patients insured by a company of your choice. The report must
show each patient’s title, name, registration number, Date of Visit, Fees, insurance amount and parish. The
report should be grouped by parish and sorted by last name. For each grouping level the report must indicate
the total fees, total insurance amount and grand totals. The first line of the report title should read ‘CHIC-V
Eradication Task Force’ The second line of the report title should be ‘Patients Insured by company of your
Choice’.
TO BE PRINTED:
The design (structure) for each table The structure for Each query
Spreadsheet
TASK A
Export a table from the database component with information on Patients: Registration numbers, First name, Last
name, gender, age, parish, date of visit, Health Center Type, Insurance Code and whether or not the patient did
a blood test. Sample worksheet is shown below.
Health Blood
Title First Last Date of Center Insuranc Test
Reg# Name Name Gender Age Parish Visit Type e Code
CV-IT- Ms. Mary Carter F 27 Irish 29/08/2014 T1 MG01 Yes
001 Town
CVFL00 Mr. Sam Bones M 19 Fairy 13/09/2014 T2 NN04 No
2 Land
Some patients have health insurance coverage while others do not. The portion of the total medical bill
that is covered by health insurance is outlined in the following table:
Registration fee is the amount charged for each visit to the health institution.
Doctor’s Fee –Fee for each visit based on type of health centre
Patient’s Amount - the amount that the patient will pay after insurance amount is deducted
The Chairman of the task force suggested you use cell references in formulae so that the spreadsheet can
be used for future calculations with minimum modifications. Use suitable “VLOOK UP” and “IF” functions to
ensure that your spreadsheet is efficient. Use formatting features to allow clarity of your worksheet
TASK B
Copy Patient_Info2 and paste in a new sheet. Name this sheet Patient_Info_3
The information for the third patient was incorrectly recorded. Delete this record.
Sort the worksheet based on Parish in ascending order then by Date diagnosed in descending order.
In an appropriate section of the worksheet use advanced filter to extract information for all patients who
had blood test and do not have insurance coverage. Save results to another section of the spreadsheet.
TASK C
1. Create a Column Chart to compare the number of patients visiting Type1, Type 2 and Type 3 Health
Centers for EACH parish. The chart should be labelled with appropriate title and axis and include a
legend.
3. TO BE PRINTED
a. All worksheets.
b. All formula sheets.
c. Both Charts
Wordprocessing
Develop a letterhead for use by the task force. The letterhead should include the name of the task force,
address, telephone number, fax and email address. Bold and italicize the email address. The letterhead
should be placed in the header. Save as LettHead
TASK A
The coordinator of the Task Force has instructed you to create an attractive brochure on letter size paper to
alert the public on the dangers of the disease, and the associated signs and symptoms. The following
information was supplied:
1. Use the logo from the letter head at an appropriate location on the brochure.
2. Illustrate at least three preventative measures with two or more graphics showing how to combat the
spreading of the disease.
3. Note – Be creative in the design of your brochure to obtain the required marks by using suitable
features of a word processing application (columns, tables, bullets, colour, etc.). Save as Brochure.
TASK B
Using the Taskforce Letterhead and mail merge feature of your word processing application, prepare a letter
addressed to the recipients listed below inviting them to a meeting scheduled for January 5, 2015 at 2:30 PM in
the Conference Room of the Ministry of Health.
The nature of the meeting is to (a) assess the control measures being implemented to combat the spread of the
disease, (b) organize and mobilize resources for the next phase of the project, and (c) to discuss ways in which
the health insurance providers will help in funding the fight against Chic-V by paying their portion of the medical
bills for patients they insure.
It is very important that the insurance providers be in attendance as the government has committed to continue
the “Free Health Care” policy with a proviso that “those who can pay, must pay”. Save the letter as Meeting
Modify the letter to include the report from the database section of the project which shows the amount the
government would recover from Company of your Choice for treatment of patients insured by that company.
Save the letter as Meeting2
Letter should be sent to the following persons: (You must supply name, title and address)
List of officials
The Minister of Health
Head of Epidemiology
For this task save the main document as Meeting2, the data source as Officials and the merged document as
MergeLett.
To be Printed
LettHead
Brochure
Meeting
Meeting 2
Officials
MergeLett
Problem-Solving
2. Design and execute a trace table that accepts patient’s data at clinics in the various
parishes. Data should include registration number, name, registration fee, doctor’s fees
and blood test costs. Patients who are insured may be insured by any of the three
Insurance Companies, Magicor, Medisure or Warden. The table should trace the
increment of each patient’s visit and total costs. There should have at least ten iterations
and a clear indicator that signals the end of the Trace Table
Program Implementation
3. Using the Programming Language Pascal, write program code to implement the
algorithm.