Entrance Announcement
MICTE 2080
2080 Magh 07
User:Saroj Neupane Real Teaching Lesson Plan 30: Difference between revisions
Jump to navigation
Jump to search
(Created page with "<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:Creating Simple Marksheet in Microsoft Excel |- |Period: 2nd |- |School: Shree Okhreni Secondary School |- |} </div> ==Specific Objectives== *At the end of this class, students will be able to create a basic mark sheet in Microsoft ==Teaching Materials== *Computers with Microsoft Excel inst...") |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 32: | Line 32: | ||
*Emphasize the practical use of Excel for creating organized and efficient mark sheets. | *Emphasize the practical use of Excel for creating organized and efficient mark sheets. | ||
*Follows these steps to create marksheet: | *Follows these steps to create marksheet: | ||
Step 1: Open Excel and Set Up the Worksheet | |||
Step 2: Understand the Sample Marksheet | # Step 1: Open Excel and Set Up the Worksheet | ||
Step 3: Enter Student Names and Subject Names (5 minutes): | # Step 2: Understand the Sample Marksheet | ||
Step 4: Enter Sample Marks (10 minutes): | # Step 3: Enter Student Names and Subject Names (5 minutes): | ||
Step 5: Calculate Total Marks,Percentage,Rank,Highest marks on each subject | # Step 4: Enter Sample Marks (10 minutes): | ||
Step 6: Format the Mark Sheet | # Step 5: Calculate Total Marks,Percentage,Rank,Highest marks on each subject | ||
# Step 6: Format the Mark Sheet | |||
==Conclusion== | ==Conclusion== | ||
| Line 48: | Line 49: | ||
*Provide assistance and address any issues. | *Provide assistance and address any issues. | ||
*Encourage a brief discussion on any challenges faced during the process. | *Encourage a brief discussion on any challenges faced during the process. | ||
[[Category: Lesson Plan]] | |||
__notoc__ | __notoc__ | ||
[[Category: BICTE]] | |||
Latest revision as of 03:35, 12 March 2024
| Subject: Computer Science |
| Class:9 |
| Time:45 Minutes |
| Number of Students: 40 |
| Unit:4 |
| Topic:Creating Simple Marksheet in Microsoft Excel |
| Period: 2nd |
| School: Shree Okhreni Secondary School |
Specific Objectives
- At the end of this class, students will be able to create a basic mark sheet in Microsoft
Teaching Materials
- Computers with Microsoft Excel installed
- Projector or whiteboard for demonstrations
- Sample Marksheet
Teaching-Learning Activities
- Begin with a brief discussion on the significance of mark sheets in academic settings.
- Emphasize the practical use of Excel for creating organized and efficient mark sheets.
- Follows these steps to create marksheet:
- Step 1: Open Excel and Set Up the Worksheet
- Step 2: Understand the Sample Marksheet
- Step 3: Enter Student Names and Subject Names (5 minutes):
- Step 4: Enter Sample Marks (10 minutes):
- Step 5: Calculate Total Marks,Percentage,Rank,Highest marks on each subject
- Step 6: Format the Mark Sheet
Conclusion
- Recap the key steps in creating the mark sheet.
- Discuss the practical applications of Excel skills beyond academic scenarios.
- Encourage students to explore more advanced features and templates available in Excel.
Evaluation
- Ask students to review their mark sheets and check for accuracy.
- Provide assistance and address any issues.
- Encourage a brief discussion on any challenges faced during the process.