COURSE UNIT TITLE

: FIELD ELC. 4 (APPLICATION OF INFORMATION TECHNOLOGY)

DEGREE PROGRAMMES

Description of Individual Course Units

Course Unit Code Course Unit Title Type Of Course D U L ECTS
TEK 1016 FIELD ELC. 4 (APPLICATION OF INFORMATION TECHNOLOGY) ELECTIVE 2 0 0 4

Offered By

Computer and Instructional Technologies Teacher Education

Level of Course Unit

First Cycle Programmes (Bachelor's Degree)

Course Coordinator

ELIF ÖZYENGINER

Offered to

Computer and Instructional Technologies Teacher Education

Course Objective

This course aims to teach pre-service teachers studying at the Department of Computer Education and Instructional Technologies at Buca Education Faculty to use an electronic spreadsheet program and a database program effectively in their student and profession. It also aims to provide basic knowledge and skills in subjects such as creating and managing cloud accounts, creating electronic forms and electronic table, using forms, and editing data.

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   Cloud account creation and management.
4   Creating electronic forms and electronic table, using forms, organizing data.

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 General Review, Course Evaluation, Midterm Exam
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 Cloud account creation and management.
14 Creating electronic forms and electronic table, using forms, organizing data.
15 Final Exam

Recomended or Required Reading

Bağcı, Ö. (2022). Ileri Düzey Excel. Ankara: Seçkin.
Gürkan, O. (2016). Microsoft Acces 2016. Nirvana Yayınları

Planned Learning Activities and Teaching Methods

Presentation, research and project development.

Assessment Methods

SORTING NUMBER SHORT CODE LONG CODE FORMULA
1 VZ Midterm
2 FN Semester final exam
3 BNS BNS Student examVZ * 0.40 + Student examFN * 0.60
4 BUT Make-up note
5 BBN End of make-up grade Student examVZ * 0.40 + Student examBUT * 0.60


Further Notes About Assessment Methods

None

Assessment Criteria

Exam and project.

Language of Instruction

Turkish

Course Policies and Rules

To be announced.

Contact Details for the Lecturer(s)

Öğr.Gör. Elif Özyenginer
Dokuz Eylül Üniversitesi
Buca Eğitim Fakültesi
Bilgisayar ve Öğretim Teknolojileri Eğitimi Bölümü
Hasan Ali Yücel Binası, Kat:3, Oda:313
35160 Buca/Izmir/ TURKEY
ozyenginere@gmail.com
elif.dokmetepe@deu.edu.tr

Office Hours

To be announced.

Work Placement(s)

None

Workload Calculation

Activities Number Time (hours) Total Work Load (hours)
Lectures 13 1 13
Practice (Reflection) 13 1 13
Preparing assignments 2 10 20
Preparation for midterm exam 1 10 10
Preparation for final exam 1 10 10
Preparing presentations 2 2 4
Preparations before/after weekly lectures 13 2 26
Midterm 1 1 1
Final 1 1 1
TOTAL WORKLOAD (hours) 98

Contribution of Learning Outcomes to Programme Outcomes

PO/LOPO.1PO.2PO.3PO.4PO.5PO.6PO.7PO.8PO.9PO.10
LO.11311412111
LO.21311412111
LO.31311412111
LO.41311412111

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