Lesson plan | Lesson plan |

What to create | Lesson plan |

Which subject | Computer science |

What topic | excel |

What length (min) | 30 |

What age group | Year or Grade 7 |

Include homework | |

Include images descriptions | |

Any other preferences |

In this 30-minute lesson, students will learn the basics of using Microsoft Excel. They will be introduced to the Excel interface, how to input data, and how to use basic formulas and functions. By the end of the lesson, students will be able to create a simple spreadsheet and understand how to make calculations using Excel.

- Understand the interface of Microsoft Excel
- Input data into Excel worksheets
- Use basic formulas and functions to make calculations
- Create a simple spreadsheet

- Computers with Microsoft Excel installed
- Handouts with step-by-step instructions
- Sample data sets for students to work with

- Begin by introducing the lesson and explaining what Excel is used for
- Show students a sample spreadsheet and explain the different parts of the Excel interface
- Discuss why being able to use Excel is important

- Demonstrate how to input data into a spreadsheet
- Show students how to change cells and add/delete rows and columns
- Have students practice inputting data into a sample spreadsheet

- Explain simple formulas (e.g. addition, subtraction, multiplication, division) and how to create them in Excel
- Introduce basic functions (e.g. SUM, AVERAGE) and show how to use them in calculations
- Have students practice creating formulas and using basic functions in a sample spreadsheet

- Give students a task (e.g. creating a budget) to create a simple spreadsheet using the skills they have learned
- Allow students to work independently or in pairs to complete the task

- Review what students have learned in the lesson
- Assign homework (see below)
- Encourage students to continue practicing and exploring Excel on their own

- Create a simple spreadsheet using the skills learned in class
- Include at least one formula and one function in the spreadsheet
- Save and submit the finished spreadsheet to the teacher by the due date