Course Information


Course Information
Course Title Code Semester L+U Hour Credits ECTS
INFORMATION AND COMMUNICATION TECHNOLOGIES II DICT201 3. Semester 2 + 0 2.0 2.0

Prerequisites None

Language of Instruction English
Course Level Bachelor's Degree
Course Type Compulsory
Mode of delivery
Course Coordinator
Instructors Mehmet Ali ÇELİKBAĞ
Assistants
Goals It is aimed to acquire basic computer usage skills in daily life and education-training process.
Course Content This course content includes using of advanced word processors, spreadsheet, presentation and database softwares.
Learning Outcomes 1) 1. Uses objects such as tables, forms and graphics by using word processing software.
2) 2. Uses form elements by using word processing software.
3) 3. Uses macro tools by using a word processing software.
4) 4.Uses mail merge by using a word processing software.
5) 5. Performs advanced calculations and draws the charts by using a spreadsheet software.
6) 6. Record and run macros, query and sort operations on data by using a spreadsheet software.
7) 7. Uses advanced formatting and presentation operations on graphics by using a spreadsheet software.
8) 8. Uses appropriate analysis and audit tools for logical, statistical and mathematical operations associated with the functions by using a spreadsheet software.
9) 9. Uses the advanced features of a presentation program.
10) 10. Uses advanced formatting andp repares a presentation with graphics, multimedia and effects by using a presentation program.
11) 11. Edit drawing and image tools by using a presentation program.
12) 12. Using the advanced features of the database program for database organizing, transfer, viewing transactions.
13) 13. There are different ways in which the data is related and organized in database softwares.
14) 14. Uses database program features such as record and run macros, import and export operations.

Weekly Topics (Content)
Week Topics Teaching and Learning Methods and Techniques Study Materials
1. Week Advanced Word Processor Software 1 Lecture; Question Answer

Presentation (Including Preparation Time)
2. Week Advanced Word Processor Software 2 Lecture; Question Answer

Presentation (Including Preparation Time)
3. Week Advanced Word Processor Software 3 Lecture; Question Answer

Presentation (Including Preparation Time)
4. Week Advanced Spreadsheets Software 1 Lecture; Question Answer

Presentation (Including Preparation Time)
5. Week Advanced Spreadsheets Software 2 Lecture; Question Answer

Presentation (Including Preparation Time)
6. Week Advanced Spreadsheets Software 3 Lecture; Question Answer

Presentation (Including Preparation Time)
7. Week Advanced Presentation Software 1 Lecture; Question Answer

Presentation (Including Preparation Time)
8. Week Advanced Presentation Software 2 Lecture; Question Answer

Presentation (Including Preparation Time)
9. Week Advanced Presentation Software 3 Lecture; Question Answer

Presentation (Including Preparation Time)
10. Week Advanced Database Software 1 Lecture; Question Answer

Presentation (Including Preparation Time)
11. Week Advanced Database Software 2 Lecture; Question Answer

Presentation (Including Preparation Time)
12. Week Advanced Database Software 3 Lecture; Question Answer

Presentation (Including Preparation Time)
13. Week Sample Applications 1 Lecture; Question Answer

Presentation (Including Preparation Time)
14. Week Sample Applications 2 Lecture; Question Answer

Presentation (Including Preparation Time)

Sources Used in This Course
Recommended Sources
Bal, H. Ç. (2003) Bilgisayar ve Internet, Akademisyen Yayınevi
http://orgun.ankara.edu.tr/ Dersin ana kaynağı olup öğrencilerimiz burdaki LMS yazılımıyla ders içeriğini etkileşimli olarak almaktadır.
http://orgun.ankara.edu.tr/ Dersin ana kaynağı olup öğrencilerimiz burdaki LMS yazılımıyla ders içeriğini etkileşimli olarak almaktadır.
http://orgun.ankara.edu.tr/ Dersin ana kaynağı olup öğrencilerimiz burdaki LMS yazılımıyla ders içeriğini etkileşimli olarak almaktadır.
http://orgun.ankara.edu.tr/ Dersin ana kaynağı olup öğrencilerimiz burdaki LMS yazılımıyla ders içeriğini etkileşimli olarak almaktadır.
http://orgun.ankara.edu.tr/ Dersin ana kaynağı olup öğrencilerimiz burdaki LMS yazılımıyla ders içeriğini etkileşimli olarak almaktadır.
http://orgun.ankara.edu.tr/ Dersin ana kaynağı olup öğrencilerimiz burdaki LMS yazılımıyla ders içeriğini etkileşimli olarak almaktadır.
http://orgun.ankara.edu.tr/ Dersin ana kaynağı olup öğrencilerimiz burdaki LMS yazılımıyla ders içeriğini etkileşimli olarak almaktadır.
http://orgun.ankara.edu.tr/ Dersin ana kaynağı olup öğrencilerimiz burdaki LMS yazılımıyla ders içeriğini etkileşimli olarak almaktadır.
http://orgun.ankara.edu.tr/ Dersin ana kaynağı olup öğrencilerimiz burdaki LMS yazılımıyla ders içeriğini etkileşimli olarak almaktadır.
http://orgun.ankara.edu.tr/ Dersin ana kaynağı olup öğrencilerimiz burdaki LMS yazılımıyla ders içeriğini etkileşimli olarak almaktadır.
http://orgun.ankara.edu.tr/ Dersin ana kaynağı olup öğrencilerimiz burdaki LMS yazılımıyla ders içeriğini etkileşimli olarak almaktadır.
Koyuncu, B., Numanoğlu, M.,Sevindik, M., Karataş, E., Bağcı, E., Aydın, A., Tuğrul, B. (2006) Temel Bilgisayar Eğitimi, Bıçaklar Kitabevi

ECTS credits and course workload
Event Quantity Duration (Hour) Total Workload (Hour)
Course Duration (Total weeks*Hours per week) 14 2
Work Hour outside Classroom (Preparation, strengthening) 14 1
Midterm Exam 1 1
Time to prepare for Midterm Exam 1 7
Final Exam 1 1
Time to prepare for Final Exam 1 14
Total Workload
Total Workload / 30 (s)
ECTS Credit of the Course