# 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.