Scenario from the lesson of practical classes of computer science technician – 7 scenario INF03

Scenario from a practical lesson

Profession: INFORMATION TECHNOLOGIST

Qualification: INF.03. Development and administration of websites and web applications and databases

Class: IV

Number of hours: 15h

Place of holding classes:

SIDCom Dariusz Michaluk, ul. Ciechanowiecka 19e, 17-300 Siemiatycze

School/company computer simulation laboratory/laboratory, headquarters of companies engaged in the development and operation of computer software, service point, computer network administration company, computer store, IT service department of any enterprise,

Practical class topic: Creating forms, queries and reports for data processing

Unit Themes:

Tables in the database on a project basis
Data types and column attributes
Entering data into the database
Programming scripts that automate the process of creating a database structure
Importing data from a file
Export database structure and data to file

OVERALL OBJECTIVE OF THE CLASS:

Developing skills to create and work with databases

OPERATIONAL OBJECTIVES:

The student can:

Use database concepts;
Create E/R diagrams (Entity-Relationship Diagram);
Use database management systems SZBD (Database Management System);
Use Structured Query Language (SQL);
Create relational databases as designed;
Create forms, queries and reports for data processing;
Modify database structures;
Manage the database system;

ACTIVITY OBJECTIVES:

Cognitive: Familiarizing students with the database system
Educational: Master the ability to create forms, queries and reports to process data
Educational: To raise awareness of the opportunities provided by database system structures

IMPLEMENTATION METHODS:

Show
Instruction
Practical exercises

TEACHING METHODS:

Performing and analyzing practical solutions, Instruction with demonstration

TEACHING RESOURCES:

Internal instructions and orders in force at the unit where the student is doing his professional practice
Job descriptions, instructions, specialized software

FORM OF TEACHING:

Individual and group exercises