IISS EZIO VANONI - MENAGGIO (Como)
INFORMATICA
5th scientific high school SA
mod. 1
Introduction to MySQL and to relational database
Lesson plan
Teacher: LUCIA DIANA INTELISANO
Recipient : 5th scientific high school SA
Date: feb – may 2016
Discipline: Computer Science
Duration: 7 hours
Prerequisites:
- Computer Science: Information systems and computer systems; Organization of resources and processes; Introduction to databases.
- English Language: Knowledge of grammatical and lexical structures needed for an oral and written understanding of one computer-specific topic. Capacity of address simple conversations by expressing own point of view (B1/B2)
Teacher introduces the topic by presenting its general characteristics and contributes to the progressive construction of the meaning of specific terms and fundamental concepts (enable subtitles on video).
Teacher explains how to extract subtitles in text format from the video.
Students extract the text from the video and save it in word format. Next, they add the punctuation by helping with the video view.
Game time! Searchwords explanation.
Students create a document containg a glossary from words found on puzzle
At the end, students produce a powerpoint presentation.
mod. 2
Data Security and Ethical Hacking
Lesson plan
Teacher: LUCIA DIANA INTELISANO
Recipient : 5th scientific high school SA
Date: feb – may 2016
Discipline: Computer Science
Duration: 7 hours
Prerequisites:
- Computer Science: Information systems and computer systems; Basic knowledge of SQL language.
- English Language: Knowledge of grammatical and lexical structures needed for an oral and written understanding of one computer-specific topic. Capacity of address simple conversations by expressing own point of view (B1/B2)
Teacher introduces the topic by presenting its general characteristics and contributes to the progressive construction of the meaning of specific terms and fundamental concepts (enable subtitles on video).
Teacher explains how to extract subtitles in text format from the video.
Students extract the text from the video and save it in word format. Next, they add the punctuation by helping with the video view.
Game time! Searchwords explanation.
Working in groups: students prepare a document containing a glossary with terms and definitions taken from the crossword completed in the previous lesson.
Working in pairs: each student asks for the definition from the term or asks the term from the definition.
Working in groups: simulation of a sql injection attack online. In this interactive tutorial you will understand how SQL injection attacks are used to compromise the security of a web application, and how to write code more securely to protect against this type of attack.
Working in groups: the students produce a presentation containing a summary of the subject, highlighting the glossary words