A manual for a computer science teacher
8th grade, 4th quarter (7-8 lessons)
Topics:
- Project activities: development of individual or group projects using all studied technologies.
- Working with big data: basics of data analysis, using programs for analyzing large amounts of data.
- Cybersecurity: data protection on the Internet, information encryption, safe behavior in social networks and instant messengers.
Lesson 1: Project Planning
Objective:
To teach students to plan and structure projects using various technologies.
Lesson plan:
- Definition of the project (10 min).
- What is a project, types of projects (eg website, app, database).
- Choice of topic: individual or group project.
- Project structure (10 min).
- Development stages: setting the task, choosing tools, development, testing and presentation.
- Practical work (20 min).
- Beginning project planning: drawing up a structure, choosing technologies, setting goals.
Homework:
Prepare a project plan, distribute tasks among group members.
Lesson 2: Working with Big Data – Basics of Analysis
Objective:
To introduce students to the basic principles of big data analysis and programs for processing them.
Lesson plan:
- The concept of big data (10 min).
- What is big data, its examples (social networks, search queries, data from devices).
- Data analysis methods: sorting, filtering, visualization.
- Data Tools (10 min).
- Analysis programs: spreadsheets, databases.
- Examples of using charts and graphs to visualize data.
- Practical work (20 min).
- Working with a set of data (for example, in spreadsheets): sorting, filtering, creating charts.
Homework:
Analyze the data set and prepare a report visualizing the results.
Lesson 3: Data Protection and Encryption
Objective:
To teach the basics of data protection and encryption of information on the Internet.
Lesson plan:
- Principles of data protection (10 min).
- What is data protection, methods of storing and transmitting protected information.
- Basics of encryption (10 min).
- What is encryption, its types (symmetric and asymmetric), examples of use.
- Practical work (20 min).
- An example of encrypting and decrypting messages (e.g. using online tools or Python libraries).
Homework:
Study examples of data encryption in popular instant messengers and social networks.
Lesson 4: Safe Behavior on the Internet
Objective:
To teach the rules of safe behavior on the Internet and social networks.
Lesson plan:
- Internet threats (10 min).
- Main types of threats: phishing, hacking, malware, data manipulation.
- Safe behavior on social networks (10 min).
- How to protect accounts, what can and cannot be published, two-factor authentication.
- Practical work (20 min).
- Check security settings on popular platforms (eg Google, Instagram, Facebook).
- Installing and configuring two-factor authentication.
Homework:
Conduct an audit of the security settings of your social media accounts.
Lesson 5: Working with Big Data – Processing and Visualization
Objective:
To develop skills in working with large amounts of data, their processing and visualization.
Lesson plan:
- Data Analysis Methods (10 min).
- How to organize and structure large data sets, examples of application of analysis in various fields (marketing, finance, science).
- Data analysis programs (10 min).
- Use of data visualization and analysis tools (e.g. Google Sheets, Excel, databases).
- Practical work (20 min).
- Download and analyze real datasets (e.g. internet usage statistics, temperature data).
Homework:
Prepare a report based on the results of analyzing a large data set, visualize key points.
Lesson 6: Project Development – Practical Work
Objective:
Continue working on projects integrating programming, web development and data analysis technologies.
Lesson plan:
- Discussion of the project (10 min).
- Discussion of project progress, analysis of difficulties, consultation on issues.
- Practical work (30 min).
- Project development: creation of functional elements, work with databases, integration of data and technologies.
Homework:
Continue developing the project, paying attention to the integration of the studied technologies.
Lesson 7: Finalizing and Presenting Projects
Objective:
To complete the project development and prepare it for presentation.
Lesson plan:
- Completion of work on the project (10 min).
- Final testing and bug fixing, preparation for project presentation.
- Presentation of projects (30 min).
- Students demonstrate their projects (websites, applications, databases), discuss the creation process and the technologies used.
- Discussion and feedback (10 min).
- Analysis of completed work, discussion of the strengths of projects and suggestions for improvement.
Homework:
Prepare a written report on the project, describing the creation process and the results.
This manual helps 8th grade students consolidate the knowledge and skills acquired over the year through project activities and in-depth work with big data and cybersecurity.