L2-2 COMPUTER SCIENCE - DATABASES

Course Information
TitleΠΛΗΡΟΦΟΡΙΚΗ-ΒΑΣΕΙΣ ΔΕΔΟΜΕΝΩΝ / L2-2 COMPUTER SCIENCE - DATABASES
CodeΕ2-2
FacultyEngineering
SchoolSchool of Spatial Planning and Development
Cycle / Level1st / Undergraduate
Teaching PeriodSpring
CoordinatorDimitrios Kaimaris
CommonYes
StatusActive
Course ID20002264

Programme of Study: PPS Tmīmatos Mīchanikṓn CΗōrotaxías kai Anáptyxīs (2020-sīmera)

Registered students: 188
OrientationAttendance TypeSemesterYearECTS
KORMOSCompulsory Course215

Class Information
Academic Year2019 – 2020
Class PeriodSpring
Faculty Instructors
Weekly Hours4
Class ID
600161753
Type of the Course
  • Background
  • Scientific Area
  • Skills Development
Course Category
General Foundation
Mode of Delivery
  • Face to face
Digital Course Content
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
ActivitiesWorkloadECTSIndividualTeamworkErasmus
Lectures20
Laboratory Work32
Reading Assigment55
Tutorial26
Exams2
Total135
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