|
|
| 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__ | | __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.
| |