TÜRKÇE
ENGLISH
Information
| Unit | FACULTY OF EDUCATION |
| COMPUTER EDUCATION AND INSTRUCTIONAL TECHNOLOGY PR. | |
| Code | BTE148 |
| Name | Information Technology in Education II |
| Term | 2017-2018 Academic Year |
| Semester | 2. Semester |
| Duration (T+A) | 3-2 (T-A) (17 Week) |
| ECTS | 6 ECTS |
| National Credit | 4 National Credit |
| Teaching Language | Türkçe |
| Level | Belirsiz |
| Type | Normal |
| Label | C Compulsory |
| Mode of study | Yüz Yüze Öğretim |
| Catalog Information Coordinator | Dr. Öğr. Üyesi MEHMET EMRE SEZGİN |
| Course Instructor |
Dr. Öğr. Üyesi MEHMET EMRE SEZGİN
(Bahar)
(A Group)
(Ins. in Charge)
|
Course Goal / Objective
Installation of database, mail, ftp systems and management. Making web designs.
Course Content
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.
Course Precondition
Resources
Notes
Course Learning Outcomes
| Order | Course Learning Outcomes |
|---|---|
| LO01 | Installs and manages a database and developes database tools (tables, queries, forms). |
| LO02 | Uses SQL query language. |
| LO03 | Makes Web designs. |
| LO04 | Publishes web pages at web servers. |
Relation with Program Learning Outcome
| Order | Type | Program Learning Outcomes | Level |
|---|---|---|---|
| PLO01 | - | Explain sub-fields of instructional technologies and integral structure of its process and also its relation to the other fields. Explain the integral structure of instructional technologies and information technologies or computer science applications. Explain concepts that constitutes the basis for scientific thinking in the scope of the field and the related fields. | |
| PLO02 | - | Apply the processes of analysis, design, development, and evaluation on the basis of knowledge of instructional technologies. Utilize information technologies and computer science applications in order to create an effective and productive learning environment. 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. | |
| PLO03 | - | Apply the processes of analysis, design, development, and evaluation on the basis of knowledge of instructional technologies. Utilize information technologies and computer science applications in order to create an effective and productive learning environment. 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. | |
| PLO04 | - | 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. Put forward new products or processes on the basis of components of instructional technologies, computer science, for the related situations. | |
| PLO05 | - | 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. Take responsibility of an individual or group projects and accomplishing his/her undertaken missions. | |
| PLO06 | - | Follow current problems and applications and determining information and skills to undertake learning missions for the following stage. Apply the solution for the problem on the basis of scientific and ethical values when she/he confronts a learning problem. | |
| PLO07 | - | Build a healthy communication with students, teachers, school administration, and the individuals in the study group. Comprehend a foreign language in order to follow the international resources that can be utilized for the solution of problems related to the field. Take responsibilities for the distribution and dissemination of the developments in the field on local or national range. | |
| PLO08 | - | Act on the basis of scientific and ethical values in her/his works and also support preservation and learning of these values. Develop and evaluate strategic views on topic related to the future of the field. Transfer related progresses in other related fields to the field of instructional technologies. Create and maintain a cooperative and productive working environment by developing an insight related to the behaviors of the shareholders. |
Week Plan
| Week | Topic | Preparation | Methods |
|---|---|---|---|
| 1 | Database definition, history of database technology, installation of database tools, data types. | Related subjects in the course text book. | |
| 2 | Creating tables, data input to the tables, building relationships between tables. Using tables together. | Related subjects in the course text book. | |
| 3 | Forms, queries, reports. | Related subjects in the course text book. | |
| 4 | Macros | Related subjects in the course text book. | |
| 5 | SQL query language definition. | Related subjects in the course text book. | |
| 6 | SQL query language (DDL). | Related subjects in the course text book. | |
| 7 | SQL query language (DML). | Related subjects in the course text book. | |
| 8 | Mid-Term Exam | Preparing for the exam and reviewing the topics | |
| 9 | Web design, HTML language and basic labels. | Related subjects in the course text book. | |
| 10 | Web design, web design with HTML editors. | Related subjects in the course text book. | |
| 11 | Web design, web design and management programs. | Related subjects in the course text book. | |
| 12 | Web design, adding javascript codes to the web pages. | Related subjects in the course text book. | |
| 13 | Publishing web sites. | Related subjects in the course text book. | |
| 14 | Installation and management of e-Mail systems. | Related subjects in the course text book. | |
| 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. | |
| 16 | Term Exams | Preparing for the exam and reviewing the topics | |
| 17 | Term Exams | Preparing for the exam and reviewing the topics |
Assessment (Exam) Methods and Criteria
| Assessment Type | Midterm / Year Impact | End of Term / End of Year Impact |
|---|---|---|
| 1. Midterm Exam | 100 | 40 |
| General Assessment | ||
| Midterm / Year Total | 100 | 40 |
| 1. Final Exam | - | 60 |
| Grand Total | - | 100 |