Manual for a computer science teacher: 3rd grade, 4th quarter

Objective of the lessons : To deepen spreadsheet skills, introduce children to IT-related professions and strengthen teamwork skills. Special attention will be paid to cybersecurity and data protection.

Lesson plan

Lesson 1: Working with Tables: Basics and Sorting Data

Topic : Introduction to tables, sorting data

Objectives:

Teach children to work with simple spreadsheets.
Show how data can be sorted.

Materials:

Computers with spreadsheet software (e.g. Excel, Google Sheets).

Lesson plan:

Introduction (5 minutes)
- Explain what tables are and what they are used for (for example, to organize data).
Practical demonstration (10 minutes)
- Show how to enter data into a table and how to sort it (for example, sort alphabetically or numerically).
Practical part (25 minutes)
- Children enter data into a table (such as names and grades) and then sort it.
Conclusion (5 minutes)
- Discussion of how sorting helps organize information.

Lesson 2: Creating Simple Charts from Tables

Topic : Building charts to visualize data

Objectives:

Teach children to construct simple diagrams based on data from tables.
Show how charts help visualize information.

Materials:

Computers with spreadsheet software.

Lesson plan:

Introduction (5 minutes)
- Explain what charts are and how they help you better understand your data.
Practical demonstration (10 minutes)
- Show an example of creating a chart (such as a pie chart or a bar chart) based on data from a table.
Practical part (25 minutes)
- Children create charts based on their tables, visualizing various data (e.g. grades in subjects, number of books, etc.).
Conclusion (5 minutes)
- A discussion of how charts help visually represent data.

Lesson 3: Simple Mathematical Operations in Tables

Topic : Performing simple mathematical calculations in tables

Objectives:

Teach children to perform mathematical operations in tables (sum, average).
Show how computing automates working with data.

Materials:

Computers with spreadsheet software.

Lesson plan:

Introduction (5 minutes)
- Explain simple mathematical operations in tables (for example, addition, finding the average value).
Practical demonstration (10 minutes)
- Show how to use formulas to perform automatic calculations (for example, adding numbers in several cells).
Practical part (25 minutes)
- Children perform calculations in their tables (for example, add up scores or find the average result).
Conclusion (5 minutes)
- Discussion of the usefulness of automatic calculations in everyday life.

Lesson 4: Preparing a Group Project (Beginning)

Topic : Teamwork on a multimedia project

Objectives:

Start developing a group project (for example, a multimedia presentation or video).
Teach children to distribute tasks and work in a team.

Materials:

Computers with programs for creating presentations or multimedia projects (e.g. PowerPoint, Canva).

Lesson plan:

Introduction (5 minutes)
- Explain what teamwork is and why it is important.
- Discuss the topic and format of the project (for example, a multimedia presentation or video).
Distribution of roles (10 minutes)
- Children assign roles in the group (for example, who is responsible for the text, who for the graphics, who for the presentation).
Getting Started (25 minutes)
- Each group begins work on its own project, preparing materials (texts, images, etc.).
Conclusion (5 minutes)
- Discussion of progress and plans for the next lesson.

Lesson 5: Preparing a Group Project (continued)

Subject : Continuing work on the project

Objectives:

Continue working on the group project.
To teach children to integrate multimedia elements (video, images, sound).

Materials:

Computers with programs for creating multimedia projects.

Lesson plan:

Repetition (5 minutes)
- Briefly review what was done in the previous lesson.
Working on the project (30 minutes)
- The groups continue to work on the project, adding multimedia elements (images, audio, video).
Conclusion (5 minutes)
- Discussing the final steps to complete the project.

Lesson 6: Presenting Group Projects

Topic : Presentation of collective projects

Objectives:

Give children the opportunity to present their projects.
To summarize the results of the collective work.

Materials:

Computers for project demonstration.

Lesson plan:

Presentation of projects (30 minutes)
- Each group presents their project (for example, a multimedia presentation or video).
Discussion (10 minutes)
- Discussion of successes and difficulties in the process of creating a project.
- Discussion of what could be improved.

Lesson 7: IT Professions and Their Role in Everyday Life

Topic : Introduction to IT related professions

Objectives:

To introduce children to various IT professions.
Explain how IT is used in everyday life.

Materials:

Presentation about professions in IT.

Lesson plan:

Introduction (5 minutes)
- Discussion of the importance of information technology in everyday life.
Presentation (15 minutes)
- A story about various IT professions (programmer, web designer, cybersecurity engineer, etc.).
Discussion (15 minutes)
- Discussion of what professions children find interesting and why.
- How IT helps in everyday tasks (Internet, smartphones, games, etc.).
Conclusion (5 minutes)
- Summing up the discussion.

Lesson 8: Review of Cybersecurity Rules

Topic : Password protection and conscious behavior on the Internet

Objectives:

Review the basic rules of internet safety.
Explain the importance of protecting passwords and personal data.

Materials:

Presentation on cybersecurity.

Lesson plan:

Introduction (5 minutes)
- An explanation of why it is important to follow cybersecurity rules.
Presentation (15 minutes)
- A story about how to create strong passwords and protect your data.
- What is phishing and how to avoid it.
Practical task (20 minutes)
- Children create examples of strong passwords and discuss how to remember them.
Conclusion (5 minutes)
- Wrapping up and discussing the importance of cybersecurity in everyday life.