World Links Curriculum and Technology Integration
E-Learning Project Lessons
STATISTICS ON AIDS IN
GHANA.
Introduction
This is the lesson
plan for my course teaching requirements. In this lesson,
information on the current statistical
data on Aids in Ghana would be sought
from any relevant agency connected with
HIV/Aids in Ghana….
Ghana Aids Commission or the Ministry
of Health. With the help of
MS-Excel, students would be instructed
to use the information gathered
to draw graphs to show the number of
Aids patients in the ten regions of Ghana
or any other relevant information that
would be available from these agencies.
Students would be expected to draw conclusions
on the impact on the awareness
created in Ghana.
Subject and Grade level:MATHEMATICS,
SSS 2
Lesson Goals
To analyse the information and draw graphs indicating the number of Aids
patients
in the ten regions of Ghana.
2. To To gather information on the current statistics on Hiv/Aids in Ghana.
make reasonable deductions and interpretations on the information gathered.
3. To make some print-out on the graphs drawn and post copies on the Students
notice boards.
4. To create the awareness of the trend
of aids menace in Ghana.
Content Objectives
Students would appreciate the usefulness of statistics in various aspects
of our lives.
Students would be able to use Ms-Excel to perform few basic mathematical
operation such as finding the sum and average of numerical data.
Students would learn to use the Spreadsheet to organize, analyze and represent
information graphically.
Students would be
able to draw a reasonable conclusion from the graphical
representation.
Performance Objectives
Students would be able to start the Excel program from the desk top.
Students would be able to make data entries into cells.
Students would be able to use the Sort command in Excel
Students would be able to use the auto sum, paste function and sorting
commands
Students would be able to use the Chart Wizard to draw a histogram(or bar
chart)
and a pie chart
Students would be
able to work as a team.
Technology Objectives
Students would have a better understanding of using Excel to organize,
analyse and interpret numerical data
Students would be able to draw graphs using Excel
·
Students would be able to use the
printer to make hard copies of their results.
Instructional Activities
(teacher component)
Ideally students should have been asked
to go out and look for information either from the net or any of the agencies
concerned with Hiv/Aids education. Unfortunately, in my case our school
is not connected to the internet and because of time constraints I have
to go out and look for the necessary statistics for my students.
This lesson is to cover a period of two
days, 1 hour each day. During the first day the teacher would divide the
class into groups, depending on the number of computers available and the
class size. He would introduce students to the Spreadsheet, highlighting
various components like rows, columns, cells, cell address, the types of
data(label, constant and formula) .
The teacher would teach basic skills
such as entering data, clearing cells, editing text, copy and paste, resizing
columns, commands such as auto sum, paste function(finding averages) and
sorting. The teacher would then teach the students how to use the chart
wizard to draw a histogram(or bar chart) and a pie chart, using a straight
forward and simple example. The source of data could be something pertaining
to the students, e.g. The day of the week on which student was born or
the “House” to which students belong in the school.
The teacher would then guide the students
through how to finally save their work on to floppies and to make a hard
copy of their graphs using the printer. The last ten minutes
would be used in reviewing the day’s
work.
On the second day, the first ten minutes
would be used by the students to practise
what had been learnt the previous day
in readiness for the day’s activities. Meanwhile,
the teacher would distribute the information
on Aids to each group to study.
After the first 10 minutes the teacher
will ask the groups to start entering
their data, organise if possible, edit
and draw a suitable diagram to represent the information.
It is important to ensure that each student
in a group takes part in the activities.
The teacher would go round giving help
where desired. He will ask groups to save
their work and make hard copies for
presentation. He would ask students to
study carefully their drawings and make
reasonable deductions from them.
If time would allow the teacher would
ask the students to write their reflections
on the two-day activities. For lack
of time this should be given as an assignment
to be submitted the next day for appraisal.
Learning Activities(student
component)
Students will take the first day to learn
some basic skill on using Excel, as stated in the teacher’s activities.
Students will learn how to save on to
floppies, how to use the printer to make hard copies of their work.
Students will use the Excel chart wizard
to draw a histogram(or bar chart) and a pie chart.
Students will make some inferences from
the data given
Students will be required to write a
reflection on the two-day activities
Instructional Strategies
Lesson takes two days
Students will work for an hour each day
Teacher puts class into groups
Teacher introduces studentsto basics skills in using Excel, saving onto
diskettes etc
Students use second
day to work on the given data and draw diagrams to represent the information
Project Assessment
Students would be assessed through general
questions during the review session on the first day
Students would be assessed by their
final product
Project Materials and
Handouts
The following would be available for
students use:
Computers, printers, diskettes, Information
sheet on Aids from the Ministry of Health, Kumasi
Lesson Resources
Microsoft Excel 2000, Preliminary edition
by Nita Rutkosky and Meredith Flynn
|