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:

1. Step 1: Open Excel and Set Up the Worksheet
2. Step 2: Understand the Sample Marksheet
3. Step 3: Enter Student Names and Subject Names (5 minutes):
4. Step 4: Enter Sample Marks (10 minutes):
5. Step 5: Calculate Total Marks,Percentage,Rank,Highest marks on each subject
6. 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.