165
edits
Entrance Announcement
MICTE 2080
2080 Magh 07
User:Saroj Neupane Real Teaching Lesson Plan 29: Difference between revisions
Jump to navigation
Jump to search
User:Saroj Neupane Real Teaching Lesson Plan 29 (view source)
Revision as of 00:21, 31 January 2024
, 31 Januaryno edit summary
m (Replaced content with "__notoc__") Tags: Replaced Visual edit |
No 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== | |||
*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. | |||
__notoc__ | |||
==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. | |||
__notoc__ | __notoc__ | ||