Academic year/semester: 2024/25/1

ECTS Credits: 6

Available for: All OU students

Lecture hours: 0
Seminarium:0
Practice: 3
Laboratory: 14
Consultation: 0

Prerequisites: none

Course Leader: Gergely Mészáros

Faculty: Ybl Miklós Faculty of Architecture and Civil Engineering, 1146 Budapest, Thököly út 74.

Course Description:
During the course students gain application-level knowledge of data management and calculation. Learn basic data management theory and solve practical engineering problems using generic spreadsheet and database management systems. Practical training takes place in computer labs at our Faculty during the semester.

Competences:
data management, problem solving

Topics:
14 WEEKS SCHEDULE:
1. week: Spreadsheet basics 1.
2. week: Spreadsheet basics 2.
3. week: Data management in spreadsheets
4. week: Solving engineering problems 1.
5. week: Solving engineering problems 2.
6. week: Test #1: Spreadsheet calculations
7. week: Database basics
8. week: Data queries in SQL
9. week: Database design basics
10. week: Database planning and optimalization basics
11. week: Data extraction, manipulation
12. week: Advanced queries
13. week: Test #2/#3: Databases and IT concepts
14. week: Supplementary exams

Assessment: lab tests (computational tasks and multiple choice test)

Exam Types:

Test Exam

Compulsory bibliography: none

Recommended bibliography: none

Additional bibliography: none

Additional Information: none