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

**Course objective** : To expand students’ knowledge in the field of working with data and database basics, to teach them how to work collaboratively on projects, and to review the material covered with an emphasis on cybersecurity and IT professions.

## Lesson plan

#### Lesson 1: Introduction to Working with Data and Databases

**Topic** : Concept of database and data structure

**Objectives:**

- To introduce students to the basic concepts of working with data.
- Explain what databases are and why they are used.

**Materials:**

- A program for working with spreadsheets (for example, Excel, Google Sheets).

**Lesson plan:**

**Introduction**(5 minutes): Explanation of the concept of a database and real-life examples (school student database, library book catalog).**Hands-on demo**(10 minutes): Create a simple table in Excel with data (e.g. a list of books or students).**Practical task**(25 minutes): Students create their own table with data (for example, a list of their favorite movies with the genre, year of release and rating).**Conclusion**(5 minutes): Discussion of where and how databases are used in everyday life.

#### Lesson 2: Filtering Data in Tables

**Topic** : Working with tables – filtering data

**Objectives:**

- To teach students to filter data in tables according to various criteria.
- Show how you can quickly find the information you need among a large volume of data.

**Materials:**

- Program for working with tables (Excel, Google Sheets).

**Lesson plan:**

**Introduction**(5 minutes): Explaining what data filtering is and why it is needed.**Hands-on demo**(10 minutes): Filtering data in a table by various criteria (e.g. find all movies of the same genre).**Practical task**(25 minutes): Students work with a table of data and filter it according to given conditions (for example, filter films by year or rating).**Conclusion**(5 minutes): Discussion of where filtering can be used in real life.

#### Lesson 3: Creating Reports and Charts in Tables

**Topic** : Working with data – creating reports and charts

**Objectives:**

- To teach students how to create reports and visualize data using charts.
- Show how data can be presented visually for ease of understanding.

**Materials:**

- Program for working with tables.

**Lesson plan:**

**Introduction**(5 minutes): An explanation of what a report is and how data can be visualized.**Hands-on demo**(10 minutes): Create charts from table data (e.g. pie chart of movie genres).**Hands-on Activity**(25 minutes): Students create their own reports and charts from their data table.**Conclusion**(5 minutes): Discussion of the results and the importance of presenting the data in a visual form.

#### Lesson 4: Preparing a group project

**Topic** : Developing an interactive game or multimedia presentation

**Objectives:**

- To teach students to work in a team on one project.
- Develop programming and design skills.

**Materials:**

- Scratch, PowerPoint, programs for working with images and video.

**Lesson plan:**

**Introduction**(5 minutes): Discussion of the project idea (e.g. interactive game or multimedia presentation).**Group Breakout**(5 minutes): Students are divided into teams, each responsible for a part of the project (programming, design, data collection).**Project Work**(30 minutes): Students work together to create their own project using the skills learned in previous lessons.**Conclusion**(5 minutes): Discussion of progress and next steps.

#### Lesson 5: Team Project – Completion

**Subject** : Completion of the project development and preparation for the presentation

**Objectives:**

- Complete work on a group project.
- Prepare the project for presentation.

**Materials:**

- Scratch, PowerPoint, programs for working with images and video.

**Lesson plan:**

**Introduction**(5 minutes): Discussion of remaining tasks for the project.**Working on the project**(30 minutes): Completion of the project, final adjustments to elements.**Preparing a presentation**(10 minutes): Students prepare a project to present to the class (presentation structure, distribution of roles).**Conclusion**(5 minutes): Discussing the final touches before the presentation.

#### Lesson 6: Presentation of group projects

**Topic** : Presentation of finished projects

**Objectives:**

- Present collective projects to the class.
- Develop public speaking skills.

**Materials:**

- Computers, projector.

**Lesson plan:**

**Introduction**(5 minutes): Discussion of the importance of project presentation.**Project presentation**(30 minutes): Students present their projects, talk about the work process and the results achieved.**Evaluation and discussion**(10 minutes): Discussion of projects, collective evaluation and conclusions.**Conclusion**(5 minutes): Summarizing the project and rewarding the teams.

#### Lesson 7: Review and Discussion of IT Professions

**Topic** : IT professions and the use of IT in life

**Objectives:**

- To introduce students to professions in the field of information technology.
- Discuss how IT is used in different areas of life.

**Lesson plan:**

**Introduction**(5 minutes): Discussion of how IT is applied in life (medicine, education, entertainment).**Presentation of professions**(15 minutes): Overview of professions in IT (programmer, web designer, data analyst, etc.).**Group discussion**(15 minutes): Students discuss which IT professions and tasks they find most interesting.**Conclusion**(5 minutes): Reflection on the importance of IT in modern life.

#### Lesson 8: Cybersecurity and Privacy – Review and Deepening of Knowledge

**Topic** : Review of rules for safe behavior on the Internet

**Objectives:**

- To deepen students’ knowledge of cybersecurity.
- To demonstrate the importance of protecting personal data on the Internet.

**Lesson plan:**

**Introduction**(5 minutes): A reminder of the rules of safe behavior on the Internet.**Threat Discussion**(10 minutes): Overview of online threats (viruses, phishing, malware) and how to protect yourself.**Practical task**(20 minutes): Students develop their own data protection recommendations by creating a presentation or document.**Conclusion**(5 minutes): A summary of the topic of cybersecurity and a discussion of the importance of being mindful online.