COURSE UNIT TITLE

: INFORMATION TECHNOLOGIES IN EDUCATION II

DEGREE PROGRAMMES

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
BLÖ 1010 INFORMATION TECHNOLOGIES IN EDUCATION II COMPULSORY 3 2 0 9

Offered By

Computer and Instructional Technologies Teacher Education

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

INSTRUCTOR ELIF ÖZYENGINER

Offered to

Computer and Instructional Technologies Teacher Education

Course Objective

The aim of this course is to teach the prospective teachers studding at the Department of Computer Education and Instructional Technology how spreadsheet and database software can be used affectively. In addition it teaches basic knowledge and skills on how to use email creating address book opening and monitoring a group health and ergonomics of computer usage.

Learning Outcomes of the Course Unit

1   To be able to use a spreadsheet software
2   To be able to use a database software
3   To be able to use email and organizing an address book.
4   Creating and monitoring a group on the Internet
5   Health and ergonomics of using computers

Mode of Delivery

Face -to- Face

Prerequisites and Co-requisites

None

Recomended Optional Programme Components

None

Course Contents

Week Subject Description
1 Explanation of the objectives of using spreadsheet software, introduction to its screen, explanation of file operations (opening, saving, printing, publishing, closing). Entering erasing moving copying data and creating series.
2 Explanation of how data can be formed, forming on condition and explanation of data characteristics. Forming templates with numbers, words, date etc. Simple calculations.
3 Forming calculation tables by using a spreadsheet, writing formulas, explanation of the usage of pre written functions, making mathematical logical and textual practices
4 Forming graphics, introduction of the characteristics of graphics, graphics formation and its practices
5 Data acquiring, ordering data, filtering, grouping, sub addition etc.
6 Macros, Standard and user defined functions
7 Explanation of the objectives of using spreadsheet software, introduction to its screen
8 Midterm
9 Explanation of the features of data, forming tables, steps of creating a database
10 Forms and reports
11 Questions and getting data from outside
12 Macros and SQL
13 E-mail software, organizing an address book, monitoring e-mails, personalizing and organizing, monitoring calendar file, timing and monitoring meetings
14 Creating and monitoring a group Health and ergonomics of computers.
15 Final exam

Recomended or Required Reading

Üçüncü, H.(2010). Windows 7 ve MS Office 2010 Herkes Için, Alfa Yayınları.
Anadolu Üniversitesi. (2004). Temel Bilgi Teknolojileri. Açık Öğretim Yayınları. Eskişehir.
Güneş, A.(2008). Bilgisayar I ve II. Ankara: PegemA yayıncılık.
Bayram, S (1999). Bilgisayar Destekli Öğretim Teknolojileri. Istanbul: Marmara Üniversitesi Yayınları.

Planned Learning Activities and Teaching Methods

Face to face, discussion,

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 VZ Arasınav
2 DTK Diğer Etkinlik
3 FN Yarıyılsonu Sınavı
4 BNS BNS VZ * 0.30 + DTK * 0.10 + FN * 0.60
5 BUT Bütünleme Notu
6 BBN Bütünleme Sonu Başarı Notu VZ * 0.30 + DTK * 0.10 + BUT * 0.60


Further Notes About Assessment Methods

None

Assessment Criteria

LO1, LO2, LO3, LO4 and LO5 will be evaluated by a midterm and a final exam
LO1, LO2, LO3 and LO4 will be evaluated by an assignment.

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

Instructor Elif Özyenginer
Dokuz Eylül University
Faculty of Buca Education
Department of Computer Education and Instructional Technology
Hasan Ali Yücel Building, Floor:3, Room:313
35160 Buca/Izmir/ TURKEY

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 3 39
Tutorials 13 2 26
Preparations before/after weekly lectures 13 2 26
Preparation for midterm exam 1 5 5
Preparation for final exam 1 7 7
Preparing presentations 10 5 50
Preparing assignments 8 8 64
Final 1 3 3
Midterm 1 3 3
TOTAL WORKLOAD (hours) 223

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10PO.11PO.12PO.13PO.14PO.15PO.16
LO.151143112111
LO.251143112111
LO.3334131
LO.421425
LO.514112

CONTACT INFORMATION
Dokuz Eylül Üniversitesi Cumhuriyet Bulvarı No: 144 35210 Alsancak / İZMİR
Phone: +90(232) 412 12 12 - Fax: +90 (232) 464 81 35

Copyright 2015 DEÜ. BİD

HOME / ABOUT US / DEGREE PROGRAMMES / GENERAL INFORMATION FOR STUDENTS / INTERNATIONAL RELATIONS