Full lesson | Create for a teacher a set of content for giving a lesson, beginning with the lesson plan. Each new block of materials must begin with an H1 heading (other subheaders must be H2, H3, etc). When you describe required pictures, write those descriptions in curly brackets, for example: {A picture of a triangle} |
Which subject | Computer science |
What topic | Excel |
What length (min) | 30 |
What age group | Doesn't matter |
Class size | 20 |
What curriculum | |
Include full script | |
Check previous homework | |
Ask some students to presents their homework | |
Add a physical break | |
Add group activities | |
Include homework | |
Show correct answers | |
Prepare slide templates | |
Number of slides | 5 |
Create fill-in cards for students | |
Create creative backup tasks for unexpected moments |
Computer Science
Excel
Doesn't matter (suitable for all levels)
30 minutes
20
This lesson plan aligns with the Australian Curriculum for Digital Technologies, focusing on data representation and management using spreadsheets.
Step Number | Step Title | Length | Details |
---|---|---|---|
1 | Introduction to Excel | 5 minutes | Briefly introduce what Excel is and its applications in data management. Demonstrate the layout of the interface. |
2 | Navigating the Interface | 5 minutes | Show students how to navigate the Excel interface, including menus, toolbars, and worksheets. |
3 | Data Entry | 10 minutes | Guide students in opening a new spreadsheet and inputting simple data (text and numbers). Explain how to edit cells. |
4 | Basic Calculations | 5 minutes | Demonstrate how to perform basic calculations (addition, subtraction, multiplication) using formulas in Excel. |
5 | Formatting Cells | 5 minutes | Teach students how to format cells (font, color, borders) for clarity and presentation. |
6 | Conclusion and Homework Assignment | 5 minutes | Summarize key points of the lesson, explain homework assignment (create a spreadsheet with data and basic calculations), and provide guidance on how to submit it. |
Students will create a simple Excel spreadsheet that includes their personal information, a list of favorite books or movies, and use formulas to calculate totals or averages. Homework will be submitted digitally without individual presentations in class. The teacher will check the homework through digital submissions.