|
|
| YZM3006 | Educational Software Design | 2+0+0 | ECTS:4 | | Year / Semester | Spring Semester | | Level of Course | First Cycle | | Status | Elective | | Department | DEPARTMENT of SOFTWARE ENGINEERING | | Prerequisites and co-requisites | None | | Mode of Delivery | Face to face, Practical | | Contact Hours | 14 weeks - 2 hours of lectures per week | | Lecturer | Doç. Dr. Özcan ÖZYURT | | Co-Lecturer | | | Language of instruction | Turkish | | Professional practise ( internship ) | None | | | | The aim of the course: | |
| Learning Outcomes | CTPO | TOA | | Upon successful completion of the course, the students will be able to : | | | | LO - 1 : | Understand the relational dbms softwares (msSqlServer, mySql, Oracle, PostgreSql etc) | 1,3,7 | 1,5, | | LO - 2 : | Perform administrative operations on the relational dbms softwares | 1,3,7 | 1,5, | | LO - 3 : | Understand the nosql and non-relational dbms softwares concepts | 1,3,7 | 1,5, | | LO - 4 : | Understand the architecture and kind of non-relational dbms | 1,3,7 | 1,5, | | LO - 5 : | Development sample applications with non-relational dbms softwares | 1,3,7 | 1,5, | | CTPO : Contribution to programme outcomes, TOA :Type of assessment (1: written exam, 2: Oral exam, 3: Homework assignment, 4: Laboratory exercise/exam, 5: Seminar / presentation, 6: Term paper), LO : Learning Outcome | | |
| Technology enhanced learning, Educational software, Addressing educational software design, General conceptualization for educational software, Intelligent tutoring system, Adaptive educational hypermedia, Examples of educational software, Computer science perspectives and technology enhanced learning, Design of educational software: different realities, Educational software engineering, Characterizing the design context and the software artifact, Methodological considerations. |
| |
| Course Syllabus | | Week | Subject | Related Notes / Files | | Week 1 | Introduction, general concenpts | | | Week 2 | Architecture of msSQLServer, its components, setup and administrative tools | | | Week 3 | Sample applications on msSQLSERVER | | | Week 4 | Architecture of mySQL, its components, setup and administrative tools | | | Week 5 | Sample applications on mySQL | | | Week 6 | Architecture of ORACLE, its components, setup and administrative tools | | | Week 7 | Sample applications on ORACLE | | | Week 8 | Architecture of PostgreSQL, its components, setup and administrative tools | | | Week 9 | Mid-term exam | | | Week 10 | Sample applications on PostgreSQL | | | Week 11 | Non-relational dbms, nosql concepts | | | Week 12 | Non-relational dbms softwares, its kinds and architecture | | | Week 13 | Developments of sample application on nosql dbms | | | Week 14 | Developments of sample application on nosql dbms | | | Week 15 | Developments of sample application on nosql dbms | | | Week 16 | End-of-term exam | | | |
| 1 | Gözüdeli, Y. 2014; Yazılımcılar için SQL Server 2014, Seçkin Yayıncılık, Ankara | | | |
| 1 | Öztürk, Hakan T, 2012, Oracle Database 11g R2, Pusula, istanbul | | | 2 | Ullman, L. 2006, MySQL Books for Beginners, Peachpit Press | | | |
| Method of Assessment | | Type of assessment | Week No | Date | Duration (hours) | Weight (%) | | Mid-term exam | 9 | | | 30 | | Homework/Assignment/Term-paper | 14 | | | 20 | | End-of-term exam | 16 | | | 50 | | |
| Student Work Load and its Distribution | | Type of work | Duration (hours pw) | No of weeks / Number of activity | Hours in total per term | | Yüz yüze eğitim | 2 | 14 | 28 | | Sınıf dışı çalışma | 1 | 14 | 14 | | Arasınav için hazırlık | 2 | 4 | 8 | | Arasınav | 1 | 1 | 1 | | Ödev | 3 | 14 | 42 | | Dönem sonu sınavı için hazırlık | 2 | 3 | 6 | | Dönem sonu sınavı | 1 | 1 | 1 | | Total work load | | | 100 |
|