DEGREE PROGRAMS  Associate's Degree (Short Cycle)  Bachelor’s Degree (First Cycle)  Master’s Degree (Second Cycle)

Course Description Course Name : Information Technology In Education II Course Code : BTE134 Course Type : Compulsory Level of Course : First Cycle Year of Study : 1 Course Semester : Spring (16 Weeks) ECTS : 6 Name of Lecturer(s) : Asst.Prof.Dr. M.EMRE SEZGİN Learning Outcomes of the Course : Installs and manages a database and developes database tools (tables, queries, forms). Uses SQL query language. Makes Web designs. Publishes web pages at web servers. Mode of Delivery : Face-to-Face Prerequisites and Co-Prerequisites : BTE133 Information Technology In Education I Recommended Optional Programme Components : None Aim(s) of Course : Installation of database, mail, ftp systems and management. Making web designs. Course Contents : Database programs: Creating a database. Tables, Queries, Forms and Reports. Macros and SQL query language. HTML language and basic labels. HTML editors and web design. Web design and management programs: file operations, menus, properties of menu options and usage, usage of prepared themes, usage of font properties, defining special styles and usage of these styles, adding symbols, animations, pictures and cliparts to the pages, usage of frame structure. Adding ready Javascript codes (buttons, menu scripts, text and Picture effects etc.) to the web pages. Making websites FTP and publishing. E-Mail programs: Using e-Mails, Address Book edition, managing e-mail messages, customization and edition, managing calendar folder, scheduling and managing meetings. Health and Ergonomics at the computer usage. Language of Instruction : Turkish Work Place : Laboratory.   Course Outline /Schedule (Weekly) Planned Learning Activities Week Subject Student's Preliminary Work Learning Activities and Teaching Methods 1 Database definition, history of database technology, installation of database tools, data types. Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 2 Creating tables, data input to the tables, building relationships between tables. Using tables together. Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 3 Forms, queries, reports. Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 4 Macros Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 5 SQL query language definition. Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 6 SQL query language (DDL). Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 7 SQL query language (DML). Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 8 Mid-term Exams Preparing for the exam and reviewing the topics Multiple choice test 9 Web design, HTML language and basic labels. Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 10 Web design, web design with HTML editors. Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 11 Web design, web design and management programs. Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 12 Web design, adding javascript codes to the web pages. Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 13 Publishing web sites. Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 14 Installation and management of e-Mail systems. Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 15 Managing e-Mail messages, customization, edition, managing calendar folder, meeting management, health and ergonomics at the computer usage. Related subjects in the course text book. Lecture, Question-Answer, Drill and Practice, Demonstration. 16/17 Final Assessments Preparing for the exam and reviewing the topics Multiple choice test   Required Course Resources Resource Type Resource Name Recommended Course Material(s)  EFENDİOĞLU, A., SEZGİN, E. (2011), "Her Yönüyle Bilgisayar Eğitimi-2. Baskı", Karahan Kitabevi, Adana. Required Course Material(s)   Assessment Methods and Assessment Criteria Semester/Year Assessments Number Contribution Percentage     Mid-term Exams (Written, Oral, etc.) 1 80     Homeworks/Projects/Others 3 20 Total 100 Rate of Semester/Year Assessments to Success 40   Final Assessments 100 Rate of Final Assessments to Success 60 Total 100   Contribution of the Course to Key Learning Outcomes # Key Learning Outcome Contribution* 1 Utilize concepts and applications of scientific research and basic statistics, which are the basis of scientific thinking, for the conditions in the scope of the field and related fields. 3 2 Explain sub-fields of instructional technologies and integral structure of its process and also its relation to the other fields. 3 3 Put forward the complex structure of the problems related to learning and teaching for the given situations based on the knowledge of instructional technologies and related fields. 5 4 Develop a plan, apply the plan and assess the results based on scientific view for the solution of the problems presented in the scope of the field or related fields. 3 5 Put forward new products or processes on the basis of components of instructional technologies, computer science, for the related situations. 4 6 Develop a personal proposal, a product or a group of processes for the solution of a problem related to the field as an indicator of the skills of working independently and taking responsibility. 3 7 Take responsibility of an individual or group projects and accomplishing his/her undertaken missions. 3 8 Follow current problems and applications and determining information and skills to undertake learning missions for the following stage. 3 9 Explain the integral structure of instructional technologies and information technologies or computer science applications. 5 10 Explain concepts that constitutes the basis for scientific thinking in the scope of the field and the related fields. 3 11 Apply the processes of analysis, design, development, and evaluation on the basis of knowledge of instructional technologies. 3 12 Utilize information technologies and computer science applications in order to create an effective and productive learning environment. 3 13 Apply the solution for the problem on the basis of scientific and ethical values when she/he confronts a learning problem. 5 14 Build a healthy communication with students, teachers, school administration, and the individuals in the study group. 3 15 Comprehend a foreign language in order to follow the international resources that can be utilized for the solution of problems related to the field. 1 16 Take responsibilities for the distribution and dissemination of the developments in the field on local or national range. 3 17 Act on the basis of scientific and ethical values in her/his works and also support preservation and learning of these values. 3 18 Develop and evaluate strategic views on topic related to the future of the field. 4 19 Transfer related progresses in other related fields to the field of instructional technologies. 5 20 Create and maintain a cooperative and productive working environment by developing an insight related to the behaviors of the shareholders. 4 * Contribution levels are between 0 (not) and 5 (maximum).   Student Workload - ECTS Works Number Time (Hour) Total Workload (Hour) Course Related Works     Class Time (Exam weeks are excluded) 14 5 70     Out of Class Study (Preliminary Work, Practice) 14 3 42 Assesment Related Works     Homeworks, Projects, Others 3 5 15     Mid-term Exams (Written, Oral, etc.) 1 10 10     Final Exam 1 10 10 Total Workload: 147 Total Workload / 25 (h): 5.88 ECTS Credit: 6