Class: Senior Secondary School 1 (SSS 1)
Term: 3rd Term
Week: 6
Age: 15 years
Duration: 45 minutes
Subject: Data Processing
Curriculum Theme: Technology
Previous Lesson: Managing Data in Spreadsheet: Sorting and Filtering.
Topic: Creating charts in spreadsheet: Creating different types of charts
Subject Matter: creating pie chart, creating line chart, creating column chart, creating bar chart, selecting data range for chart creation, editing chart titles and labels

Specific Objectives

By the end of the lesson, pupils should be able to:

Cognitive Domain:

Identify different types of charts such as pie, line, column, and bar charts.

Affective Domain:

Appreciate the importance of charts in representing data clearly.

Psychomotor Domain:

Select the appropriate data range for chart creation in a spreadsheet.
Create pie, line, column, and bar charts using spreadsheet software.
Edit chart titles and labels accurately.

Collaborate with peers to create and interpret various types of charts.

Reference Materials

The following resources were used in planning this lesson:

9 Years Basic Education Curriculum for Data Processing
State Unified Scheme of Work for Senior Secondary Schools
Data Processing for Senior Secondary Schools by J.O. Olaniyan
https://www.gcfglobal.org/en/excel/charts/1/
https://support.microsoft.com/en-us/office/create-a-chart-from-start-to-finish-0baf392b-810a-40a1-a67b-1172a6b4130d

Instructional Materials

The teacher will teach this lesson with the aid of:

Computer set
MS Excel software
Sample datasets for chart creation

Rationale for the Lesson

This lesson helps pupils understand how to visually represent data using charts, which makes information easier to interpret and analyze. Learning to create charts also builds practical skills in using spreadsheet software, which is useful in many academic and professional fields.

Prerequisite/Previous Knowledge

Pupils should have basic knowledge of spreadsheet interfaces and data entry operations.

Lesson Content/Board Summary

Creating Charts in Spreadsheet Software

Introduction to Charts

A chart is a graphical representation of data, where the data is represented by symbols such as bars, lines, or slices. Charts help to visualize and understand large amounts of data, showing relationships and trends more clearly than raw numbers.

Types of Charts

The following are common types of charts used in spreadsheets:

Pie Chart: Shows parts of a whole, where each slice represents a percentage of the total. Useful for showing proportions.
Line Chart: Displays data points connected by straight line segments. Often used to show trends over time.
Column Chart: Uses vertical bars to represent data. Good for comparing values across different categories.
Bar Chart: Similar to a column chart but uses horizontal bars. Also good for comparing values across categories, especially when category names are long.

Steps to Create a Chart

The following are general steps to create a chart in spreadsheet software:

Enter or open the data in the spreadsheet.
Select the range of data (cells) that you want to include in your chart.
Go to the ‘Insert’ tab and select the desired chart type from the ‘Charts’ group.
The chart will be created and displayed on the worksheet.

Editing Chart Titles and Labels

After creating a chart, it is important to add clear titles and labels for readability and understanding. This includes:

Chart Title: A descriptive name for the entire chart.
Axis Titles: Labels for the X-axis (horizontal) and Y-axis (vertical) to indicate what data they represent.
Data Labels: Values displayed directly on the chart elements (e.g., on bars or pie slices).
Legend: Explains what each color or pattern in the chart represents.

Teaching Methods/Instructional Techniques

Discussion, Lecture, Demonstration, Question and Answer, Visual Aids

Instructional Procedures

Step 1: Introduction

Time: 5 minutes
Teaching Skill: Set Induction
Teacher’s Activity: The teacher greets the pupils, reviews the previous lesson on basic spreadsheet operations, and then introduces the topic of creating charts by asking pupils how they think large amounts of data can be presented clearly and attractively.
Pupils’ Activity: Pupils respond to questions and listen attentively.
Learning Point: Pupils are prepared for the new lesson on data visualization.

Step 2: Explanation of Charts and Types

Time: 10 minutes
Teaching Skill: Explanation/Lecture
Teacher’s Activity: The teacher defines what a chart is and explains its purpose in data processing. The teacher then discusses and describes different types of charts (pie, line, column, bar) using examples on a computer screen or projector.
Pupils’ Activity: Pupils listen, take notes, and ask questions for clarification.
Learning Point: Pupils understand the definition and various types of charts.

Step 3: Demonstration of Data Selection for Chart Creation

Time: 8 minutes
Teaching Skill: Demonstration/Practical
Teacher’s Activity: The teacher opens MS Excel software with a sample dataset. The teacher then demonstrates step-by-step how to select the appropriate data range (cells) that will be used to create a chart, emphasizing the importance of selecting only relevant data.
Pupils’ Activity: Pupils observe the demonstration carefully and note the steps.
Learning Point: Pupils learn how to correctly select data for chart creation.

Step 4: Demonstration of Chart Creation

Time: 10 minutes
Teaching Skill: Demonstration/Practical
Teacher’s Activity: Using the selected data, the teacher demonstrates how to insert different types of charts (pie, line, column, bar) from the ‘Insert’ tab in MS Excel. The teacher highlights how the chart changes based on the type selected.
Pupils’ Activity: Pupils watch the teacher create different charts and identify the steps involved.
Learning Point: Pupils observe the process of creating various chart types.

Step 5: Demonstration of Editing Chart Titles and Labels

Time: 5 minutes
Teaching Skill: Demonstration/Practical
Teacher’s Activity: The teacher demonstrates how to add and edit chart titles, axis titles, and data labels to make the charts more informative and professional. The teacher explains the importance of clear labeling.
Pupils’ Activity: Pupils pay attention to how chart elements are edited.
Learning Point: Pupils understand how to label charts for clarity.

Step 6: Guided Practice

Time: 5 minutes
Teaching Skill: Coaching/Supervision
Teacher’s Activity: The teacher provides pupils with a simple dataset and guides them to create one specific type of chart (e.g., a column chart) and add a title and axis labels using the computer systems available.
Pupils’ Activity: Pupils practice creating a chart under the teacher’s guidance.
Learning Point: Pupils apply their knowledge to create a basic chart.

Step 7: Evaluation/Review

Time: 5 minutes

Teaching Skill: Questioning/Assessment

Teacher’s Activity: The teacher evaluates the learning by asking the following questions:

Define a chart and state its main purpose.
Mention any three types of charts.
List two steps involved in creating a chart in spreadsheet software.
Explain why it is important to edit chart titles and labels.

Pupils’ Activity: Pupils answer orally and in writing.

Learning Point: Pupils demonstrate understanding of the lesson.

Step 8: Conclusion

Time: 2 minutes
Teaching Skill: Summarization
Teacher’s Activity: The teacher summarizes the key learning points on creating and labeling charts. The teacher then assigns homework for pupils to create different charts from a given dataset.
Pupils’ Activity: Pupils listen to the summary and copy down the homework.
Learning Point: The lesson is concluded, and pupils have a task to reinforce learning.

Lesson Keywords

Chart – A graphical representation of data.
Spreadsheet – An application used to organize, analyze, and store data in tabular form.
Pie Chart – A circular chart divided into sectors, illustrating numerical proportion.
Line Chart – A chart that displays information as a series of data points connected by straight line segments.
Column Chart – A chart that uses vertical bars to show comparisons among categories.
Bar Chart – A chart that uses horizontal bars to show comparisons among categories.
Data Range – The selection of cells containing the data to be charted.

Differentiation

For pupils who grasp concepts quickly, the teacher can provide more complex datasets or challenge them to explore additional chart formatting options. For pupils needing more support, the teacher will provide closer supervision during practical sessions, offer simplified datasets, and provide step-by-step printouts or visual aids.

Note for teachers using this lesson plan

Ensure that each pupil has access to a functional computer with MS Excel or a similar spreadsheet program for the practical sessions. Prepare diverse sample datasets to make the practice engaging. Encourage collaborative learning during chart creation activities.