L2-2 COMPUTER SCIENCE - DATABASES
| Title | ΠΛΗΡΟΦΟΡΙΚΗ-ΒΑΣΕΙΣ ΔΕΔΟΜΕΝΩΝ / L2-2 COMPUTER SCIENCE - DATABASES |
| Code | Ε2-2 |
| Faculty | Engineering |
| School | School of Spatial Planning and Development |
| Cycle / Level | 1st / Undergraduate |
| Teaching Period | Spring |
| Coordinator | Dimitrios Kaimaris |
| Common | Yes |
| Status | Active |
| Course ID | 20002264 |
Programme of Study: PPS Tmīmatos Mīchanikṓn CΗōrotaxías kai Anáptyxīs (2020-sīmera)
Registered students: 177
| Orientation | Attendance Type | Semester | Year | ECTS |
|---|---|---|---|---|
| KORMOS | Compulsory Course | 2 | 1 | 5 |
| Academic Year | 2019 – 2020 |
| Class Period | Spring |
| Faculty Instructors |
|
| Weekly Hours | 4 |
| Class ID | 600161753
|
Course Type 2016-2020
- Background
- Scientific Area
- Skills Development
Course Type 2011-2015
General Foundation
Mode of Delivery
- Face to face
Digital Course Content
- e-Study Guide https://qa.auth.gr/en/class/1/600161753
Language of Instruction
- Greek (Instruction, Examination)
Learning Outcomes
Students are expected to take the course
• understand the components of the computer, the operating systems, the computer systems and the principle of operation of the internet
• trained in word processing and web browsing programs
• trained in spreadsheet and presentation programs
• are trained in programming database creation, table creation and design, primary key, data entry and export, query with one and / or more tables, protection of reference integrity, operations between columns and rows, parametric queries, form and complex frame creation; and introduction of rules and validation text in examples with emphasis on the requirements of Urban Planning, Spatial Planning and Geoinformatics.
General Competences
- Apply knowledge in practice
- Retrieve, analyse and synthesise data and information, with the use of necessary technologies
- Adapt to new situations
- Make decisions
- Work autonomously
- Work in an interdisciplinary team
- Appreciate diversity and multiculturality
- Be critical and self-critical
- Advance free, creative and causative thinking
Course Content (Syllabus)
Components of PC - Operating Systems - Develop computer systems - Data Files - Internet - Basic concepts of word processing programs and web navigation - Word processing software, spreadsheets and presentations - Computer processing and data management using spreadsheets and systems Data Management - Create Database - Create, anatomy and Table design - Primary Key - Import and Export Data - Create query in one and / or more Tables - Referential Integrity Protection - Operations between columns and rows - Parametric questions - Form Creation - Create complex Framework - Introduction rules and instruments of ratification - Generate reports - Practical applications in disciplines of the department.
Educational Material Types
- Notes
- Book
Use of Information and Communication Technologies
Use of ICT
- Use of ICT in Course Teaching
- Use of ICT in Laboratory Teaching
- Use of ICT in Communication with Students
Description
The lectures take place in the laboratories of the Department, which used digital media teaching / presentation.
The laboratory exercises conducted in the same places and with the same electronic means.
The course has detailed information and data on the elearning, which is a place of communication with students (announcements, etc.). Each week students submit work (elearning).
Course Organization
| Activities | Workload | ECTS | Individual | Teamwork | Erasmus |
|---|---|---|---|---|---|
| Lectures | 20 | ✓ | |||
| Laboratory Work | 32 | ✓ | |||
| Reading Assigment | 55 | ✓ | |||
| Tutorial | 26 | ✓ | |||
| Exams | 2 | ✓ | |||
| Total | 135 |
Student Assessment
Description
The exams performed in the laboratories of the Department at the end of the semester and at the end of 13 weeks of instruction.
Exams each student is required to solve computational processing and data management using spreadsheets and data management systems (Word, Excel, Access).
Student Assessment methods
- Written Exam with Problem Solving (Formative, Summative)
- Labortatory Assignment (Formative, Summative)
Bibliography
Course Bibliography (Eudoxus)
Εισαγωγή στην πληροφορική, 9η Έκδοση, ISBN: 978-960-512-6049, Συγγραφέας: Beekman George,Quinn Michael J., Εκδόσεις: Χ. Γκιουρδα & ΣΙΑ ΕΕ.
Ελληνικό Microsoft Office Professional 2010, ISBN: 978-960-461-418-9, Συγγραφέας: Joyce Cox, Joan Lambert, Curtis Frye, Εκδόσεις: Κλειδάριθμος.
Additional bibliography for study
Ασκήσεις σε ψηφιακή μορφή (αναρτημένες στο elearning)
Last Update
16-11-2020
