A manual for a computer science teacher

6th grade, 4th quarter (7-8 lessons)

Topics:

Project creation: development of a collective or individual project (for example, an interactive website, application, multimedia presentation with programming elements).
Working with data: basics of data analysis, filtering and sorting data in tables, introduction to basic database functions.
Cybersecurity review: protecting personal data, working safely on the Internet, preventing phishing and other threats.

Lesson 1: Project Planning and Preparation

Objective:
To begin developing a collective or individual project, to determine the topic and key stages of implementation.

Lesson plan:

Discussion of project topics (10 min).
- The teacher helps students choose a project topic: a website, an application, or a multimedia presentation with programming elements.
Planning the project stages (15 min).
- Students draw up a work plan for the project: they define key tasks, deadlines and distribution of responsibilities (if the project is a group project).
Practical work (15 min).
- Students begin work on the first phase of a project by creating the structure or basic elements (such as a website wireframe or presentation layout).

Homework:
Think through the details of the project, collect source materials (graphics, text, etc.).

Lesson 2: Project Development – Stage One

Objective:
To begin developing the main elements of the project (e.g. interface, main functions).

Lesson plan:

Brief discussion of the current status of projects (5 min).
- Discussing students’ progress: what difficulties arise at the first stage?
Practical work (30 min).
- Students continue working on their project: creating website home pages, application interfaces, or presentation slides.
Feedback (5 min).
- The teacher helps with technical or design issues.

Homework:
Continue working on the project at home, moving forward according to plan.

Lesson 3: Working with Data – Filtering and Sorting in Tables

Objective:
To teach students to use tables to analyze data, perform sorting and filtering.

Lesson plan:

Introduction to data analysis (10 min).
- The concept of data analysis, examples of using data in life (for example, sorting and filtering financial data, lists of students).
Practical work with tables (25 min).
- Students work with pre-prepared tables (e.g. sales data, academic performance data), sorting and filtering data.
Discussion of results (10 min).
- Students discuss the results of the data analysis and how it can be applied to projects.

Homework:
Prepare tables with personal data (e.g. lists of books, movies) for analysis.

Lesson 4: Working with Data – Introduction to Databases

Objective:
To introduce students to the basics of working with databases, to explain the main functions and operations.

Lesson plan:

What are databases? (10 min).
- Discussion of the principles of database operation: structures, fields, records. Examples of using databases (e.g. school library, banking systems).
Practical work (25 min).
- Students create small databases using simple tools (such as Excel spreadsheets or Google Sheets). They enter data, filter, and sort it.
Discussion of the work (10 min).
- Discussion of results: how databases can be used in projects.

Homework:
Create a database with personal information or data for a project (for example, a table with products, books, etc.).

Lesson 5: Cybersecurity – Protecting Personal Data

Objective:
To teach students the principles of personal data protection and safe use of the Internet.

Lesson plan:

Introduction to personal data protection (10 min).
- What is personal data? How to protect it? Examples of data leaks and ways to prevent them.
Practical work (25 min).
- Students develop rules for protecting their data (e.g. how to create strong passwords, avoid using unsafe networks, maintain privacy on social media).
Discussion of practical examples (10 min).
- Analysis of real cases of data leakage, discussion of protection methods.

Homework:
Write a short instruction for friends on how to protect your personal data on the Internet.

Lesson 6: Cybersecurity – Preventing Phishing and Internet Threats

Objective:
To teach students to recognize phishing and other Internet threats, and to develop online safety skills.

Lesson plan:

What is phishing? (10 min).
- Phishing Explained: How Hackers Try to Gain Access to Personal Data Through Fake Websites, Emails, and Messages.
Practical work (25 min).
- Students analyze examples of phishing emails and websites and learn to identify signs of threats (e.g. suspicious links, requests for personal information).
Group discussion (10 min).
- What other threats exist on the Internet? How can you protect yourself from them?

Homework:
Create a list of tips for staying safe online and share them with family or friends.

Lesson 7: Working on Projects – Final Stage

Objective:
Complete projects by checking functionality and correctness of tasks.

Lesson plan:

Discussion of project progress (10 min).
- Students talk about their successes in working on projects, what tasks have been completed, and what remains to be done.
Practical work (25 min).
- Students complete their projects, test functionality, and fix possible errors.
Preparation for the presentation (10 min).
- Students prepare projects for presentation and discuss how they will demonstrate them.

Homework:
Complete the project and prepare it for the final presentation.

Lesson 8: Presentation of projects

Objective:
To present projects to the class, discuss achievements and opportunities for improvement.

Lesson plan:

Presentation of projects (35 min).
- Each student or group presents their project, demonstrating functionality and design.
Feedback and discussion (10 min).
- The class and teacher provide feedback on projects, discussing achievements and what could be improved.

Conclusion:
The teacher summarizes the project and provides recommendations for further development of skills in programming, data management, and cybersecurity.

Conclusion

This course covers 7-8 lessons, including project work, basic data analysis and filtering, and cybersecurity review. Students create projects, putting their knowledge into practice, and gain skills in protecting personal data on the Internet.