Class: Senior Secondary School 1 (SSS 1)
Term: 3rd Term
Week: 2
Age: 15 years
Duration: 45 minutes
Subject: Data Processing
Curriculum Theme: Technology
Previous Lesson: Inserting.
Topic: Formatting Worksheets in Spreadsheets
Subject Matter: Typing in a range of cells and aligning content, selecting columns, rows and entire worksheet, inserting and deleting rows and columns, adjusting column width and row height, changing vertical alignment and rotating cell content.

Specific Objectives

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

Cognitive Domain:

Define worksheet formatting in a spreadsheet application.
State the importance of formatting a worksheet.

Affective Domain:

Appreciate the benefits of a well-formatted worksheet for data presentation.
Participate actively in practical demonstrations.

Psychomotor Domain:

Type content into cells and align it appropriately.
Select columns, rows, and the entire worksheet using different methods.
Insert and delete rows and columns in a worksheet.
Adjust column width and row height to fit content.
Change vertical alignment and rotate cell content.

Collaborate with peers during practical exercises.
Share knowledge on different formatting techniques.

Reference Materials

The following resources were used in planning this lesson:

9 Years Basic Education Curriculum for Data Processing (Senior Secondary 1-3)
State Unified Scheme of Work for Data Processing SSS 1
Data Processing for Senior Secondary Schools 1 by J.O. Olaniyi
Microsoft Excel Official Website
Microsoft Excel Help & Learning

Instructional Materials

The teacher will teach this lesson with the aid of:

Computer system with MS Excel software installed
Projector (if available)
Whiteboard and markers
Handouts with practical steps

Rationale for the Lesson

This lesson is important because it equips pupils with practical skills to present data clearly and professionally in spreadsheets. Learning these formatting techniques helps pupils organize information effectively, making it easier to read and understand in various real-world applications.

Prerequisite/Previous Knowledge

Pupils should have basic knowledge of what a spreadsheet is and how to launch a spreadsheet application like Microsoft Excel.

Lesson Content/Board Summary

Formatting Worksheets in Spreadsheets

1. Typing and Aligning Content in Cells

Typing involves entering text or numbers into individual cells. Aligning content refers to positioning the data within a cell. This can be horizontal (left, center, right) or vertical (top, middle, bottom).

To align cell content:

Select the cell(s) with the content.
Use the alignment options in the ‘Home’ tab of the spreadsheet software (e.g., Microsoft Excel).

2. Selecting Columns, Rows, and Entire Worksheet

Selecting allows users to apply actions to a range of cells, a whole column, a whole row, or the entire worksheet.

Ways to select:

Column: Click on the column header (e.g., A, B, C).
Row: Click on the row number (e.g., 1, 2, 3).
Entire Worksheet: Click the ‘Select All’ button (the small square at the intersection of row headers and column headers) or press Ctrl + A.

3. Inserting and Deleting Rows and Columns

Inserting adds new blank rows or columns, while deleting removes existing ones. This helps in organizing or restructuring data.

Steps to insert/delete:

Insert: Select the row/column where you want to insert, right-click, and choose ‘Insert’.
Delete: Select the row/column you want to remove, right-click, and choose ‘Delete’.

4. Adjusting Column Width and Row Height

Adjusting width and height ensures all content is visible and improves readability.

Methods for adjustment:

Manual Adjustment: Drag the boundary between column headers or row numbers.
AutoFit: Double-click the boundary between column headers or row numbers to automatically adjust to the widest/tallest content.

5. Changing Vertical Alignment and Rotating Cell Content

Vertical alignment positions content at the top, middle, or bottom of a cell. Rotating cell content changes the orientation of text within a cell, useful for headings or saving space.

To change vertical alignment and rotate:

Select the cell(s).
Use the alignment group in the ‘Home’ tab.
Click the ‘Orientation’ button to select rotation options (e.g., Angle Counterclockwise, Vertical Text).

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 asks them what they understand by “presentation” in the context of school assignments. The teacher then relates this to presenting data in a spreadsheet, asking how they think a spreadsheet can be made to look neat and readable.
Pupils’ Activity: Pupils respond to the questions, sharing their ideas on presentation and neatness.
Learning Point: Pupils are introduced to the concept of formatting and its importance in data presentation.

Step 2: Explanation of Worksheet Formatting

Time: 5 minutes
Teaching Skill: Explanation/Definition
Teacher’s Activity: The teacher defines worksheet formatting as the process of changing the appearance of data in a spreadsheet to make it more organized, readable, and visually appealing. The teacher explains that formatting does not change the data itself, but how it is displayed.
Pupils’ Activity: Pupils listen attentively and take notes on the definition and importance of worksheet formatting.
Learning Point: Pupils understand what worksheet formatting is and why it is necessary.

Step 3: Demonstrating Typing and Aligning Content in Cells

Time: 7 minutes
Teaching Skill: Demonstration/Practical
Teacher’s Activity: The teacher projects an MS Excel window and demonstrates how to type data into various cells. The teacher then shows how to use the alignment buttons (left, center, right, top, middle, bottom) to position the text within the cells. Pupils are encouraged to observe carefully.
Pupils’ Activity: Pupils watch the demonstration and note the steps involved in typing and aligning cell content.
Learning Point: Pupils observe the practical application of typing and aligning cell content.

Step 4: Demonstrating Selection Techniques

Time: 6 minutes
Teaching Skill: Demonstration/Instruction
Teacher’s Activity: The teacher demonstrates how to select a single column by clicking its header, a single row by clicking its number, and the entire worksheet using the ‘Select All’ button or Ctrl+A. The teacher explains why selecting is important before applying formatting.
Pupils’ Activity: Pupils observe the different methods of selecting parts of a worksheet and understand their purpose.
Learning Point: Pupils learn how to select columns, rows, and the entire worksheet.

Step 5: Demonstrating Inserting/Deleting and Adjusting Rows/Columns

Time: 8 minutes
Teaching Skill: Demonstration/Application
Teacher’s Activity: The teacher demonstrates how to insert a new row above an existing one and a new column to the left of an existing one. The teacher also shows how to delete a selected row or column. Following this, the teacher demonstrates adjusting column width and row height manually and using the AutoFit feature.
Pupils’ Activity: Pupils pay close attention to the steps for inserting, deleting, and adjusting rows and columns, noting the visual changes.
Learning Point: Pupils learn the procedures for inserting, deleting, and adjusting the dimensions of rows and columns.

Step 6: Demonstrating Vertical Alignment and Rotating Cell Content

Time: 7 minutes
Teaching Skill: Demonstration/Visualisation
Teacher’s Activity: The teacher demonstrates how to change the vertical alignment of text within a cell (top, middle, bottom). The teacher then shows how to rotate text in a cell to different angles, explaining scenarios where this might be useful (e.g., narrow columns for headings).
Pupils’ Activity: Pupils observe the different vertical alignment and text rotation options and their effects.
Learning Point: Pupils understand how to change vertical alignment and rotate text in cells.

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 worksheet formatting.
Mention two ways to select an entire worksheet.
State the steps to insert a new row in a spreadsheet.
Explain how to adjust column width to fit content automatically.

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 briefly summarizes the key formatting techniques discussed and emphasizes their importance for creating professional and readable spreadsheets. The teacher assigns pupils to practice these formatting skills using a spreadsheet application.
Pupils’ Activity: Pupils listen to the summary and note the homework assignment.
Learning Point: Pupils consolidate their learning and are encouraged to practice the skills.

Lesson Keywords

Formatting – Changing the appearance of data to make it organized and readable.
Alignment – Positioning text or data within a cell (e.g., left, center, right, top, middle, bottom).
Column Width – The horizontal size of a column.
Row Height – The vertical size of a row.
AutoFit – Automatically adjusting column width or row height to fit the content.
Rotate Text – Changing the orientation of text within a cell.

Differentiation

For pupils who grasp concepts quickly, the teacher can provide more complex data sets for formatting practice or encourage them to explore advanced formatting options like cell borders and shading. For pupils who need more support, the teacher will provide one-on-one guidance during practical sessions and simplify instructions, focusing on one formatting skill at a time.

Note for teachers using this lesson plan

Ensure that each pupil has access to a computer with MS Excel or a similar spreadsheet application for hands-on practice. Emphasize practical demonstrations and allow sufficient time for pupils to replicate the steps. Encourage questions and provide immediate feedback during the practical exercises.