Entrance Announcement
MICTE 2080
2080 Magh 07
User:Saroj Neupane Real Teaching Lesson Plan 29: Difference between revisions
Jump to navigation
Jump to search
(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)=== | ||
Revision as of 00:05, 31 January 2024
| 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.