165
edits
User:Saroj Neupane Real Teaching Lesson Plan 29: Difference between revisions
User:Saroj Neupane Real Teaching Lesson Plan 29 (view source)
Revision as of 00:05, 31 January 2024
, 31 Januaryno edit summary
(Created page with "esson Plan: Excel Tips and Tricks - Find, Remove Duplicates, Drop-Down Lists, Open Links, and Merge Cells ==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-ex...") |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<div style="column-count: 2; column-gap: 20px;"> | |||
{| class="wikitable" | |||
|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 | |||
|- | |||
|} | |||
</div> | |||
==Specific Objectives== | ==Specific Objectives== | ||
| Line 13: | Line 31: | ||
==Teaching Learning Activities== | ==Teaching Learning Activities== | ||
===Introduction (5 minute)== | === Introduction (5 minute) === | ||
*Briefly introduce the importance of data management in Excel for better organization and analysis. | *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. | *Explain that today's lesson will cover finding and removing duplicates, creating drop-down lists, opening links, and merging cells. | ||
| Line 20: | Line 37: | ||
===Finding and Removing Duplicates (10 minute)=== | ===Finding and Removing Duplicates (10 minute)=== | ||
Demonstration: | '''Demonstration:''' | ||
Open a sample Excel spreadsheet. | * Open a sample Excel spreadsheet. | ||
Select a column with potential duplicates. | * Select a column with potential duplicates. | ||
Go to the "Data" tab. | * Go to the "Data" tab. | ||
Click on "Remove Duplicates." | * Click on "Remove Duplicates." | ||
Explain the options and choose the appropriate columns. | * Explain the options and choose the appropriate columns. | ||
Execute the removal process. | * Execute the removal process. | ||
Practice: | '''Practice:''' | ||
Students will open their own Excel files. | * Students will open their own Excel files. | ||
Identify a column with potential duplicates. | * Identify a column with potential duplicates. | ||
Follow the steps to remove duplicates. | * Follow the steps to remove duplicates. | ||
===Creating Drop-Down Lists (10 minute)=== | ===Creating Drop-Down Lists (10 minute)=== | ||
Demonstration: | '''Demonstration:''' | ||
Choose a column where you want to create a drop-down list. | * Choose a column where you want to create a drop-down list. | ||
Go to the "Data" tab. | * Go to the "Data" tab. Click on "Data Validation." | ||
Click on "Data Validation." | * Set criteria and choose a source for the list (a range of cells or a specific list). | ||
Set criteria and choose a source for the list (a range of cells or a specific list). | |||
Students will create a drop-down list in a column of their choice. | '''Practice:''' | ||
Add various items to the list and observe how it functions. | |||
* 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)=== | === Opening Links (10 minute)=== | ||
Demonstration: | '''Demonstration:''' | ||
Insert a hyperlink in a cell by right-clicking and selecting "Hyperlink." | * Insert a hyperlink in a cell by right-clicking and selecting "Hyperlink." | ||
Navigate to a webpage or file and link it to the cell. | * Navigate to a webpage or file and link it to the cell. | ||
Show how to open the link by clicking on the cell. | * Show how to open the link by clicking on the cell. | ||
Students will insert hyperlinks in a cell. | '''Practice:''' | ||
Link to a webpage or document. | |||
Test the link by clicking on the cell. | * 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)=== | ===Merging Cells (10 minutes)=== | ||
Demonstration: | '''Demonstration:''' | ||
* Select a range of cells. | |||
* Go to the "Home" tab. | |||
* Click on the "Merge & Center" option. | |||
'''Practice:''' | |||
Practice: | |||
Students will merge cells in a selected range. | * Students will merge cells in a selected range. | ||
Observe how the content is centered in the merged cell. | * Observe how the content is centered in the merged cell. | ||
===Conclusion (5 minutes)=== | ===Conclusion (5 minutes)=== | ||