User:Ram baduwal Real Teaching Lesson Plan 27

Subject: Computer science

Topic: Introduction to Logo Commands

Time: 45 minutes

Number of student: 25

Class: 9

Period: 5th

School: Shree Okhreni Secondary School

Specific Objectives:

1. Understand the basics of Microsoft Excel.
2. Learn to navigate and work with cells, rows, and columns.
3. Create a simple spreadsheet for data entry and basic calculations.

Teaching Aids:

1. Computers with Microsoft Excel installed
2. Projector and screen
3. Handouts with basic Excel shortcuts and tips

Classroom Activities:(35 min )

• Briefly introduce Microsoft Excel and its significance in organizing data and performing calculations.
• Discuss real-world applications of spreadsheets in various fields.

Overview of Excel Interface

• Open Excel and explain the main components of the interface:

1. Ribbon
2. Cells, rows, and columns
3. Worksheets and workbooks
4. Formula bar

Data Entry and Formatting

• Demonstrate how to enter data into cells.
• Explain formatting options, including changing font styles, cell alignment, and cell borders.
• Discuss the importance of clear and organized data presentation.

Basic Formulas

• Introduce basic Excel formulas such as SUM, AVERAGE, and COUNT.
• Guide students in creating simple formulas for calculating totals and averages.

Cell Referencing

• Explain the concept of cell referencing (relative and absolute).
• Demonstrate how to copy formulas to multiple cells.

Charts and Graphs

• Briefly introduce the creation of charts/graphs from data.
• Show how to select data and choose appropriate chart types.

Practice Time

• Allow students to practice what they have learned by creating a basic spreadsheet with data, formatting, and formulas.
• Walk around to provide assistance and answer questions.

Conclusion:(5min)

• Logo commands empower students to express creativity through programming, fostering logical thinking and problem-solving skills as they manipulate a turtle to create diverse graphical patterns and shapes.

Evaluation:(5min)

• Informally assess students during the hands-on exercises and individual projects.
• Evaluate their understanding of Logo commands and their ability to apply them creatively.