Project Description

PRE-UNIVERSITY II: AUTOMATED VIDEO SURVEILLANCE SYSTEM, CONTROLLED VIA WEB

Pre-University Coding In-a-box II

SCHOOL STAGE: 4th course of Secondary School / Baccalaureate 1 and 2 (Spanish Education System)

RECOMMEDED AGE: 15, 16 or 17 years

PREVIOUS REQUIREMENTS: Students must have previously completed the course PRE-UNIVERSITY I – Autonomous Vehicle Controlled via Web.

AVAILABLE LANGUAGES:

Spanish English

DURATION: 1 school year

TECHNOLOGIES:
Raspberry Pi, JavaScript, PHP, MySQL, MQTT.

Technological Youth Passport TECHNOLOGICAL YOUTH PASSPORT ACCREDITATIONS:

This course is preceded by the PRE-UNIVERSITY 1 course and it is expected to continue it with the PRE-UNIVERSITY 3 for a total of 3 courses.

TYP accreditations in preparation.

GENERAL OBJECTIVE:

VIDEO SURVEILLANCE SYSTEM VIA THE INTERNET

During the second year of the PRE-UNIVERSITY program, students will control a webcam via the Internet. The control is done through a web created by themselves and also using home automation protocols and services. The control will be both of the operation of the camera and the movement thereof, achieved with servomotors. The system of video surveillance will store images in a database. The entire project will be controlled by a Raspberry Pi.
The course will begin by learning the necessary web tools (JavaScript, PHP y MySQL). Then, the project will be completed, and some elements will be added to it, such as home automation with MQTT.
This second project can be integrated with the project of the first year, the “autonomous vehicle”, to create an autonomous “spy vehicle”, equipped with cameras in real time.
The video shows the contents of the two years.

SYLLABUS, PLANNING AND ACCREDITATIONS

MODULES PERCENTAGE TECHNOLOGIES TYP ACCREDITATIONS
JAVASCRIPT 10% Introduction to JavaScript.
Variables.
Type of data.
Creating Forms and Input validation.
Type conversion.
Structures.
Operators.
Predefined functions.
Create objects and methods using JavaScript.
IN PREPARATION
PHP – MySQL 40% Basic concepts.
The model of relational databases.
Other aspects of database management.
Other models and analysis of databases.
IN PREPARATION
DYNAMIC WEBSITE 20% Run a PHP script.
Learn PHP language.
Websites based on using data that uses PHP and MySQL.
PHP applications and MySQL.
IN PREPARATION
HOME AUTOMATION AND SYSTEMS 30% Installing and configuring an HTTP server (web).
Control of actuators (GPIO) via HTTP.
Configuration of publications/subscriptions.
Mosquitto/Public servers.
IN PREPARATION