Entrance Announcement
MICTE 2080
2080 Magh 07
User:Saroj Neupane Real Teaching Lesson Plan 30
| 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.