Objectives:
Introduction to basic concepts of relational databases: entity, relation, table, record,
properties, queries, etc.
Introduction to basic concepts of computer programming using visual programming
language (e.g. Scratch): algorithm, input, output, variables, flow control structures.
Content:
1. Introductory lecture and exercises.
2. Data model, entities and their properties
3. Relational database model
4. Primary and secondary key, relations between tables
5. Introduction to computing environment
6. Data integrity
7. Forms and reports
8. Queries
9. Mid-term exam
10. Introducing to visual programming language and programming enviroment.
Sprites and their attributes.
11. Colour, sound, speech, moving, effects, drowing.
12. Variables. Input and output. Control structures. Sequence.
13. Selection.
14. Iteration.
15. Final exam.
|
- ECDL 5.0 (Windows 7, MS Office 2010), , Grundler, Gvozdanović, Ikica, Kos, Milijaš, Smec, Širanović, Zvonarek, PRO-MIL, 2011.
- SCRATCH - Vodič za korisnike i korisnice, , Otvoreno društvo za razmjenu ideja (ODRAZI), ODRAZI, Zagreb, Prevela: Ana Kedveš, .
- Baze podataka - Microsoft Access 2010, priručnik, , Čelebić, Dujlo, Otvoreno društvo za razmjenu ideja (ODRAZI), Zagreb, 2011.
|