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: 10

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. Define a graph
  2. State the uses of a graph
  3. Mention and explain the types of 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 database

Students pay attention

STEP 2

EXPLANATION

She defines a graph and states its uses 

Students pay attention and participates

STEP 3

DEMONSTRATION

She mentions and explains the types of graphs

 

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

GRAPHS

A graph is a diagram showing the relationship between varying quantities. It is also a diagram used to indicate the relationship between two or more variable quantities.

 

USES OF GRAPHS

Graphs are used for the following purposes;

  1. To display results of computer mathematical solutions in diagram forms.
  2. To indicate the relationship between two variable quantities.
  3. To measure quantities along two axes set at right angles to each other.
  4. In comparing variables in a table.
  5. In enhancing report presentation.

 

TYPES OF GRAPHS AND THEIR USES

There are different types of charts (graphs) available in spreadsheet programs such as Microsoft Excel, Lotus1,2,3, Sage, and Peachtree. Common charts available and their uses include the following:

1. Column

This chart compares values across columns.

Sub-types include;

  1. Clustered column: This chart compares values across a group.
  2. Stacked column: This chart compares the contribution of each value to total in a group of class. Others are; 100% stacked column, 3-D columns, clustered columnwitha3-Dvisual effect, stacked column with a 3-D visual effect.

2. Bar chart

Sub-types include:

  1. Clustered bar: This chart compares values across a group.
  2. Stacked bar: This chart compares the contribution of each value to total in a group of class. Others are; 100% stacked bar, 3-D bar, clustered bar with a 3-Dvisual effect, stacked bar with a 3-D visual effect.

3. Line graph

This graph displays trends over time or series.

Sub-types include:

  1. Stacked line: this display the trend of the contribution of each value over time or a series. Others are; 100% stacked line, 3-D bar, clustered line with a 3-Dvisual effect, stacked line with a 3-D visual effect.

4. Pie Chart

This chart displays the contribution of each value to a total. Pie chart types include the following;

  1. Pie with a 3-D visual effect: This pie chart has a 3-Dimessional appearance.
  2. Pie with a pie: this is a pie chart with user defined value extracted and combined into a second pie.
  3. Exploded pie: This displays the contribution of each value to the total while retaining individual values.
  4. Exploded pie with 3-D visual effect. Bar of pie: This is a pie chart with user-defined values stacked into a stacked bar.

Other types of charts are; Scatter chart,

Area chart,

Doughnut chart,

Radar chart

etc.

EVALUATION:    1. Define Graphs

  1. State four uses of graphs
  2. Mention and explain four types of graphs

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively