Загрузка
UP

A manual for a computer science teacher

7th grade, 4th quarter (7–8 lessons)

Topics:

  1. Project activities: development of individual or group projects (website, application or game), integration of programming, design and databases.
  2. Working with data: delving into data analysis, working with large amounts of data, creating databases and queries, filtering and sorting information.
  3. Cybersecurity: in-depth study of online threats, protection of personal data, conscious use of social networks.

Lesson 1: Introduction to project work

Objective:
To introduce students to the basics of project work, defining the project topic, and distributing tasks in groups.

Lesson plan:

  1. Introduction to project activities (10 min).
    • What is a project, stages of development, goals and objectives.
  2. Examples of projects (10 min).
    • Examples of successful student projects (website, game, application).
  3. Selecting a project topic (15 min.)
    • Discussion of ideas and distribution of tasks in teams (if the project is a group project).
  4. Getting started with a project (10 min).
    • Initial planning and assignment of roles within the team.

Homework:
Start working on the project idea, collect materials.

Lesson 2: Project Work – Programming and Design Integration

Objective:
To deepen programming skills in the context of project work and design integration.

Lesson plan:

  1. Programming for the project (10 min).
    • Working with programming languages ​​(Python, HTML/CSS, JavaScript) to implement functionality.
  2. Design integration in a project (15 min).
    • Basics of interface design (UI/UX), web page styling, adding graphic elements.
  3. Practical work (20 min).
    • Development of the first components of the project using programming and design.

Homework:
Continue working on the functional and design aspects of the project.

Lesson 3: Working with Databases – Creation and Integration

Objective:
To introduce the basic principles of working with databases, their creation and use in projects.

Lesson plan:

  1. Explaining the concept of databases (10 min).
    • What are databases, their structure, types of databases (relational).
  2. Creating databases (15 min).
    • Introduction to SQL, creating simple tables and queries.
  3. Integration of databases into the project (20 min).
    • Linking a project to a database, an example of working with forms and queries.

Homework:
Add a database to the project and create several queries to work with the data.

Lesson 4: Deep Data Analysis

Objective:
To teach how to work with large volumes of data, analyze information and use tools for data visualization.

Lesson plan:

  1. Working with large amounts of data (10 min).
    • Example of large data sets and their application (financial reports, statistics).
  2. Filtering and sorting data (15 min).
    • Working with large tables and databases, writing complex queries for sorting and filtering data.
  3. Practical work (20 min).
    • Using filters and queries to work with real data in a project (data analysis).

Homework:
Apply filters and sorting of data in the project to perform real-world tasks.

Lesson 5: Cybersecurity – Protecting Personal Data

Objective:
To deepen knowledge about cyber threats and data protection, to develop skills for safe behavior on the Internet.

Lesson plan:

  1. Threats on the Internet (10 min).
    • What is phishing, hacking, viruses, social engineering.
  2. Protection of personal data (15 min).
    • How to protect your data: complex passwords, two-factor authentication, encryption.
  3. Practical work (20 min).
    • Installation and configuration of antivirus programs, discussion of examples of cyber attacks and methods of protection.

Homework:
Review your current cybersecurity measures and update passwords, enable two-factor authentication.

Lesson 6: Cybersecurity on Social Media

Objective:
To teach safe behavior on social networks and conscious use of the Internet.

Lesson plan:

  1. The Dangers of Social Media (10 min).
    • What is cyberbullying, personal data collection, fraud.
  2. Profile protection (15 min).
    • Privacy settings, secure online communication, content filtering.
  3. Practical work (20 min).
    • Setting up privacy for social network profiles, using secure applications for communication.

Homework:
Audit your social media profiles and update your privacy settings.

Lesson 7: Project Completion – Presentation

Objective:
To prepare final versions of projects and present them to the class.

Lesson plan:

  1. Completing projects (20 min).
    • Finishing touches: testing, bug fixing, interface improvements.
  2. Presentation of projects (20 min).
    • Students present their projects to the class, explaining the technologies used and the stages of development.

Homework:
Prepare a written description of the project: goals, technologies used, difficulties and solutions.

Lesson 8: Feedback and Final Discussion

Objective:
To evaluate the results of students’ work, discuss difficulties, and provide feedback.

Lesson plan:

  1. Discussion of projects (20 min).
    • Brief overview of the presented projects, highlighting strengths.
  2. Feedback from teacher and students (20 min).
    • Discussion of what worked and what could be improved, advice on how to improve projects in the future.

Conclusion:
Students receive a grade on their projects and suggestions for further development.