Manual for a computer science teacher: 6th grade, 4th quarter
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.