Class: Senior Secondary School 1 (SSS 1)
Term: 3rd Term
Week: 3
Age: 15 years
Duration: 45 minutes
Subject: Data Processing
Curriculum Theme: Technology
Previous Lesson: .
Topic: Formatting the worksheet: Transferring data, Merging cells, Inserting and removing borders and gridlines
Subject Matter: transferring data from one worksheet to another workbook, merging cells, inserting borders, removing borders, removing gridlines and restoring gridlines

Specific Objectives

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

Cognitive Domain:

Explain the process of transferring data between worksheets and workbooks.
Define cell merging and state its purpose.
Identify the steps to insert and remove borders and gridlines in MS Excel.

Affective Domain:

Appreciate the importance of proper data formatting for readability and presentation.
Show interest in using advanced formatting features in MS Excel.

Psychomotor Domain:

Demonstrate the ability to transfer data from one worksheet to another workbook.
Perform the action of merging and unmerging cells correctly.
Apply and remove borders and gridlines from a worksheet.

Collaborate with peers to practice worksheet formatting techniques.
Share knowledge on efficient data management using MS Excel features.

Reference Materials

The following resources were used in planning this lesson:

9 Years Basic Education Curriculum for Senior Secondary Schools.
State Unified Scheme of Work for Data Processing SSS 1.
Data Processing for Senior Secondary Schools 1 by J.O. Olaniyan.
Microsoft Excel 2016/2019 Help Documentation.

Instructional Materials

The teacher will teach this lesson with the aid of:

A computer set with MS Excel software installed.
Projector (if available).
Whiteboard and marker.
Charts showing steps for various formatting tasks.

Rationale for the Lesson

This lesson helps pupils understand how to effectively format data in spreadsheets. Learning to transfer data, merge cells, and manage borders and gridlines enables pupils to present information clearly and professionally, which is a valuable skill in academic and future work settings.

Prerequisite/Previous Knowledge

Pupils should have basic knowledge of MS Excel, including how to open a workbook, enter data into cells, and navigate between worksheets.

Lesson Content/Board Summary

Formatting the Worksheet: Transferring Data, Merging Cells, Borders and Gridlines

1. Transferring Data

Transferring data involves moving or copying information from one location to another within a spreadsheet application like MS Excel.

Data can be transferred:

Within the same worksheet: Moving data from one cell/range to another on the same sheet.
Between different worksheets: Moving data from one sheet to another within the same workbook.
Between different workbooks: Moving data from a sheet in one Excel file to a sheet in another Excel file.

Steps to transfer data (e.g., using Copy/Cut and Paste):

Select the cell(s) or range of data to be transferred.
Right-click and choose “Copy” (to duplicate) or “Cut” (to move) or use Ctrl+C / Ctrl+X.
Navigate to the destination (another cell, worksheet, or workbook).
Select the destination cell where the data should start.
Right-click and choose “Paste” or use Ctrl+V.

2. Merging Cells

Merging cells is the process of combining two or more adjacent cells into a single, larger cell. This is often used for creating titles or labels that span across multiple columns or rows.

Steps to merge cells:

Select the range of cells you want to merge.
Go to the “Home” tab on the Excel ribbon.
In the “Alignment” group, click on the “Merge & Center” button (or click the arrow for other merge options like Merge Across, Merge Cells).

To unmerge cells, select the merged cell and click the “Merge & Center” button again.

3. Inserting and Removing Borders

Borders are lines that can be added around cells or ranges of cells to improve readability, highlight specific data, or create a structured appearance.

Steps to insert borders:

Select the cell(s) or range where you want to add borders.
Go to the “Home” tab.
In the “Font” group, click the arrow next to the “Borders” button.
Choose the desired border style (e.g., All Borders, Outside Borders, Thick Box Border).

Steps to remove borders:

Select the cell(s) or range from which you want to remove borders.
Go to the “Home” tab.
In the “Font” group, click the arrow next to the “Borders” button.
Choose “No Border”.

4. Inserting and Removing Gridlines

Gridlines are the faint grey lines that separate cells on a worksheet. They are visible by default but can be hidden for a cleaner look, especially when printing.

Steps to remove gridlines:

Go to the “View” tab on the Excel ribbon.
In the “Show” group, uncheck the “Gridlines” checkbox.

Steps to restore gridlines:

Go to the “View” tab on the Excel ribbon.
In the “Show” group, check the “Gridlines” checkbox.

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 and reviews the previous lesson briefly. The teacher then asks pupils how they make their notes neat and organized. The teacher introduces the topic by explaining that just like organizing notes, data in Excel can also be formatted to look neat and professional.
Pupils’ Activity: Pupils respond to the teacher’s questions and listen attentively to the introduction.
Learning Point: Pupils recall previous knowledge and are introduced to the new topic of worksheet formatting.

Step 2: Transferring Data

Time: 10 minutes
Teaching Skill: Explanation/Demonstration
Teacher’s Activity: The teacher explains what transferring data means in MS Excel. The teacher demonstrates on a computer how to copy/cut and paste data within a worksheet, between worksheets, and between different workbooks, explaining each step clearly.
Pupils’ Activity: Pupils observe the demonstration, ask questions, and take notes. Some pupils may follow along on their computers if available.
Learning Point: Pupils learn the methods and steps for transferring data effectively in Excel.

Step 3: Merging Cells

Time: 7 minutes
Teaching Skill: Explanation/Demonstration
Teacher’s Activity: The teacher explains the concept of merging cells and its uses (e.g., for report titles). The teacher then demonstrates how to merge a range of cells using the “Merge & Center” option and also shows how to unmerge them.
Pupils’ Activity: Pupils pay attention to the demonstration and practice merging cells on their computers.
Learning Point: Pupils understand how to combine cells and its application in formatting.

Step 4: Inserting Borders

Time: 5 minutes
Teaching Skill: Demonstration
Teacher’s Activity: The teacher explains why borders are used in spreadsheets. The teacher demonstrates how to select cells and apply different border styles (e.g., all borders, outside borders) using the Home tab.
Pupils’ Activity: Pupils observe the demonstration and note the steps. They try to apply borders to their data.
Learning Point: Pupils learn how to enhance data presentation by adding borders.

Step 5: Removing Borders

Time: 3 minutes
Teaching Skill: Demonstration
Teacher’s Activity: Following the previous step, the teacher demonstrates how to remove borders from selected cells using the “No Border” option.
Pupils’ Activity: Pupils practice removing borders from their worksheets.
Learning Point: Pupils learn how to undo border formatting.

Step 6: Managing Gridlines

Time: 5 minutes
Teaching Skill: Explanation/Demonstration
Teacher’s Activity: The teacher explains what gridlines are and demonstrates how to hide and restore gridlines using the “View” tab. The teacher discusses when it might be useful to hide gridlines (e.g., for printing or a cleaner look).
Pupils’ Activity: Pupils observe and practice hiding and restoring gridlines on their computers.
Learning Point: Pupils understand how to control the visibility of gridlines for presentation purposes.

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 cell merging in MS Excel.
List three steps to transfer data from one worksheet to another workbook.
State two reasons for applying borders to cells.
Explain how to remove gridlines from a worksheet.
Mention the steps to merge a range of cells.

Pupils’ Activity: Pupils answer orally and in writing.

Learning Point: Pupils demonstrate understanding of the lesson.

Step 8: Conclusion

Time: 5 minutes
Teaching Skill: Summarization/Assignment
Teacher’s Activity: The teacher summarizes the key points of the lesson, emphasizing the importance of formatting for clear data presentation. The teacher gives pupils an assignment to create a simple timetable in Excel and apply all the formatting techniques learned (transfer data, merge cells for headings, add borders, hide gridlines).
Pupils’ Activity: Pupils listen to the summary and copy down the assignment.
Learning Point: Pupils consolidate their learning and are given practical application for the skills learned.

Lesson Keywords

Transferring Data – Moving or copying information from one location to another within or between spreadsheets.
Merging Cells – Combining two or more adjacent cells into a single larger cell.
Borders – Lines added around cells or ranges to highlight or structure data.
Gridlines – Faint grey lines separating cells in a worksheet, visible by default.
Worksheet – A single page or sheet within an Excel workbook.
Workbook – An Excel file containing one or more worksheets.

Differentiation

For pupils who grasp concepts quickly, the teacher can challenge them to explore more advanced border options or conditional formatting. For pupils needing more support, the teacher will provide one-on-one guidance during practical sessions and provide step-by-step handouts.

Note for teachers using this lesson plan

Ensure that each pupil has access to a computer with MS Excel for hands-on practice. If computers are limited, organize pupils into small groups to share resources, ensuring everyone gets a chance to perform the tasks. Emphasize practical application over theoretical knowledge for this topic.