User:Saroj Neupane Real Teaching Lesson Plan 29

Subject: Computer Science

Class:9

Time:45 Minutes

Number of Students: 40

Unit:4

Topic:Find, Remove Duplicates, Drop-Down Lists, Open Links, and Merge Cells in MS Excel

Period: 2nd

School: Shree Okhreni Secondary School

Specific Objectives

• At the end of the class students will learn how to efficiently manage data in Excel by finding and removing duplicates, creating drop-down lists, opening links, and merging cells.

Teaching Materials

• Computers with Microsoft Excel installed
• Projector or screen for demonstration
• https://www.javatpoint.com/how-to-find-duplicates-in-excel

Teaching Learning Activities

Introduction (5 minute)

• Briefly introduce the importance of data management in Excel for better organization and analysis.
• Explain that today's lesson will cover finding and removing duplicates, creating drop-down lists, opening links, and merging cells.

Finding and Removing Duplicates (10 minute)

Demonstration:

• Open a sample Excel spreadsheet.
• Select a column with potential duplicates.
• Go to the "Data" tab.
• Click on "Remove Duplicates."
• Explain the options and choose the appropriate columns.
• Execute the removal process.

Practice:

• Students will open their own Excel files.
• Identify a column with potential duplicates.
• Follow the steps to remove duplicates.

Creating Drop-Down Lists (10 minute)

Demonstration:

• Choose a column where you want to create a drop-down list.
• Go to the "Data" tab. Click on "Data Validation."
• Set criteria and choose a source for the list (a range of cells or a specific list).

Practice:

• Students will create a drop-down list in a column of their choice.
• Add various items to the list and observe how it functions.

Opening Links (10 minute)

Demonstration:

• Insert a hyperlink in a cell by right-clicking and selecting "Hyperlink."
• Navigate to a webpage or file and link it to the cell.
• Show how to open the link by clicking on the cell.

Practice:

• Students will insert hyperlinks in a cell.
• Link to a webpage or document.
• Test the link by clicking on the cell.

Merging Cells (10 minutes)

Demonstration:

• Select a range of cells.
• Go to the "Home" tab.
• Click on the "Merge & Center" option.

Practice:

• Students will merge cells in a selected range.
• Observe how the content is centered in the merged cell.

Conclusion (5 minutes)

• Recap the key points: finding and removing duplicates, creating drop-down lists, opening links, and merging cells.
• Encourage students to practice these skills on their own projects for better data management in Excel.

Homework

• Assign a task that requires students to apply these skills in a real-world scenario, such as organizing a set of data or creating a more complex spreadsheet.

Assessment

• Students will be assessed based on their ability to successfully find and remove duplicates, create a functional drop-down list, open a hyperlink, and merge cells in Excel within a given dataset.