Computer Studies - Junior Secondary 3 - Graphs

Graphs

Get it on Google Play
Get it on the Apple App Store
  1. Home
  2. Comprehensive Lesson Plan and Notes
  3. Junior Secondary 3
  4. Graphs

Term: 2nd Term

Week: 11

Class: Junior Secondary School 3

Age: 14 years

Duration: 40 minutes of 2 periods each

Date:

Subject:      Computer studies

Topic:-       Graphs

SPECIFIC OBJECTIVES: At the end of the lesson, pupils should be able to

  1. Create and edit graphs

INSTRUCTIONAL TECHNIQUES: Identification, explanation, questions and answers, demonstration, videos from source

INSTRUCTIONAL MATERIALS: Videos, loud speaker, textbook, pictures

INSTRUCTIONAL PROCEDURES

PERIOD 1-2

PRESENTATION

TEACHER’S ACTIVITY

STUDENT’S ACTIVITY

STEP 1

INTRODUCTION

The teacher revises the previous lesson on Graphs

Students pay attention

STEP 2

EXPLANATION

She outlines the procedures for creating and editing graphs 

Students pay attention and participates

STEP 3

DEMONSTRATION

She demonstrates the creating and editing of graphs on the computer system

 

Students pay attention and participate

STEP 4

NOTE TAKING

The teacher writes a summarized note on the board

The students copy the note in their books

 

NOTE

CREATING A CHART/GRAPH

  1. Start the computer and load Microsoft excel.
  2. Enter the data and ensure there are no blank cells.
  3. Select the data range.
  4. Click Insert menu.
  5. Click on chart wizard.
  6. Click chart types.
  7. Click any of the chart sub-types.

 

EDITING A CHART/GRAPH

When you double-click on a chart, MS excel opens a chart window where you can edit the chart.

You can do the following:

  1. Click the title you want to change.
  2. Type the new text you want.
  3. Press Enter.

 

PRACTICAL ACTIVITY

  1. Using the information on the table below, construct the following:

Subject

English

Maths

Computer

Basic Technology

Basic Science

Scores

60

80

85

75

55
  1. Pie chart
  2. Bar chart

SOLUTION

i. Pie Chart

ii. Bar chart

PRACTICAL ACTIVITY

The table below gives the age of a group of pupils in a school.

Age(yrs)

14

15

16

17

18

Number of pupils

3

6

4

4

4

Draw a bar chart to show the information in the table.

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively