Information Technologies in Education II

Course Code:

CET 102

Course Period:

Spring

Course Type:

Core

P:

2

Lab:

0

Credits:

3

ECTS:

8

Course Language:

İngilizce

Course Objectives:

Create and manage a simple database and develop a web site to use educational porposes

Course Content:

Database systems: Creating a database, tables, queries, forms, reports, macros and SQL. Web design: HTML editors, file operations, frames, creating menus, using web themes; fonts, creating and using style sheets, adding symbols, animation, clipart and figures on pages; using Javascript codes for buttons, menus, and effects; publishing web pages via FTP. E-mail programs: managing e-mails, address books, and agendas for arranging meetings or reminder.

Course Methodology:

1: Lecture, 2: Question-Answer, 3: Discussion, 4: Self-study, 5: Demonstration

Course Evaluation Methods:

1: Testing, 2: Experiment 3: Homework 4: Portfolio 5: Project

Vertical Tabs

Course Learning Outcomes

Learning Outcomes	Teaching Methods	Assessment Methods
Create database with MS Access	4, 9, 11	1,4,5
Create queries with SQL commands	4, 9, 11	1,4,5
Prepare a personal web page with Dreamweaver	4, 9, 11	1,4,5
Insert media and forms into web sites	4, 9, 11	1,4,5
Organise e-mail programs	4, 9, 11	1,4,5
Learn computer ergonomy an know green PC concept.	6	1,2,3

Course Flow

Week	Topics	Study Materials
1	What is a Database? Using purposes
2	MS Access interface, creating a database.
3	Data types, defining keys
4	Tables, forms and querries
5	SQL querry language
6	HTML language
7	HTML editor and web design
8	Web editors: Dreamweaver CS3
9	Using template and customizing templates and styles with DW
10	Adding symbol, animation, image and clipart to the web pages in DW
11	Using Javascript codes in a web page
12	Using FTP programs and DW interface
13	E-mail programs: address book, calendar,
14	Evaluation of course

Recommended Sources

Textbook
Additional Resources

Material Sharing

Documents
Assignments
Exams

Assessment

Mid-terms	1	70
Quizzes	2	10
Assignment	1	20
Total		100
CONTRIBUTION OF FINAL EXAMINATION TO OVERALL GRADE		40
CONTRIBUTION OF IN-TERM STUDIES TO OVERALL GRADE		60
Total		100

COURSE CATEGORY

Expertise/Field Courses

Course’s Contribution to Program

No	Program Learning Outcomes	Contribution
No	Program Learning Outcomes	1	2	3	4	5
1	Know instructional technologies and materials and how to implement these in courses; take role in applications such as educational software, e-learning, distance education and support other people around in need.		X
2	Use process of design, planning, implementation and managing educational technologies efficient; design and prepare needed products, changes and updates examining these processes.		X
3	Organize suitable technology supported education environments taking individual, social, cultural differences of students into consideration and special interest and needs.		X
4	Have efficient usage skill for information and communication technologies within and out instruction process.					X
5	Design and develop technology supported instructional materials to fulfill instruction needs.		X
6	Define needed software and input-output devices for set up optimum computer system.				X
7	Plan, implement and manage learning-teaching process	X
8	Develop and implement projects with knowing the processes of project development.		X
9	Have information about computer software and hardware in level of teaching computer and information and communication technologies courses and supporting other teachers; use informatics and communication technologies (European Computer Driving License, Advanced Level).					X
10	Have enough knowledge, skill and competence about teaching profession.	X
11	Use current information communication technologies (software-hardware) and integrate them to learning-teaching processes.					X
12	Have high level knowledge and can put in force learning teaching approaches, theories, strategies, methods and technics.	X

ECTS

Activities	Quantity	Duration (Hour)	Total Workload (Hour)
Course Duration (Including the exam week: 16x Total course hours)	16	4	64
Hours for off-the-classroom study (Pre-study, practice)	14	2	28
Mid-terms	1	3	3
Quizes 32,16,12	-	-	-
Homeworks	5	8	40
Final examination	1	75	75
Total Work Load			250
Total Work Load / 25 (h)			8,4
ECTS Credit of the Course			8

Search form