Course Information


Course Information
Course Title Code Semester L+U Hour Credits ECTS
COMPUTER I İLE119 1. Semester 2 + 0 2.0 3.0

Prerequisites None

Language of Instruction Turkish
Course Level Bachelor's Degree
Course Type Compulsory
Mode of delivery
Course Coordinator
Instructors
Assistants
Goals This course aims to provide students with the ability to produce complex documents while using a word processing application, to develop printouts and to develop advanced skills that can be used to improve productivity. In addition, it aims to enable students to produce reports using Advanced Spreadsheets, to perform complex mathematical and statistical calculations, and to develop advanced skills that can be used to improve productivity.
Course Content The European Computer Driving License includes advanced computer software first and second modules.
Learning Outcomes 1) He/she can format advanced text, paragraph, columns, and tables.
2) He/she can maintain a consistent design using character and paragraph styles.
3) He/she can work with reference to features such as footnote, last note and subtitle.
4) He/she Can manage quotations and bibliography using a selected quote style.
5) He/she can create table of contents, indexes, and cross-reference tables.
6) He/she can increase productivity by using fields, forms, and templates.
7) He/she can implement advanced mail merge techniques and work with automation features such as macros.
8) He/she can collaborate and review documents locally or online.
9) " He/she can apply Document security features."
10) IHe/she can work with watermarks, sections, and headers and footers in the document.
11) He/she can use synonyms and manage spelling settings.
12) He/she can apply advanced formatting options such as conditional formatting and customized number formatting in tables.
13) He/she can Create graphs and apply advanced graphical formatting.
14) He/she can work with tables and lists to analyze, filter and sort data.
15) He/she can work with tables and lists to analyze, filter and sort data.
16) He/she can verify and control Spreadsheet data.
17) He/she can increase productivity by working with named cell ranges and macros.
18) He/she can use connectivity, embedding and importing to integrate data.
19) He/she can compare and merge electronic tables

Weekly Topics (Content)
Week Topics Teaching and Learning Methods and Techniques Study Materials
1. Week Formatting a Word Processor Lecture; Question Answer
Opinion Pool
Problem Based Learning 		Homework Presentation (Including Preparation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
2. Week Formatting a Word Processor Lecture; Question Answer; Problem Solving; Discussion; Demonstration
Opinion Pool
Project Based Learning 		Homework Presentation (Including Preparation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
3. Week Word Processor Reference Lecture; Question Answer; Discussion; Demonstration
Opinion Pool
Problem Based Learning 		Homework Presentation (Including Preparation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
4. Week Increase Word Processor Efficiency Lecture; Question Answer; Problem Solving; Discussion; Demonstration
Opinion Pool
Project Based Learning 		Homework Presentation (Including Preparation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
5. Week Increase Word Processor Efficiency Lecture; Question Answer; Problem Solving; Demonstration
Opinion Pool
Project Based Learning 		Homework Presentation (Including Preparation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.) Practice (Teaching Practice, Music/Musical Instrument Practice, Statistics, Laboratory, Field Work, Clinic and Polyclinic Practice)
6. Week Word Processor Collaborative Editing Lecture; Question Answer; Problem Solving; Discussion; Demonstration
Opinion Pool
Project Based Learning 		Homework Presentation (Including Preparation Time) Project (Including Preparation and presentation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.) Practice (Teaching Practice, Music/Musical Instrument Practice, Statistics, Laboratory, Field Work, Clinic and Polyclinic Practice)
7. Week Midterm exams Lecture; Question Answer
Opinion Pool
Project Based Learning 		Homework Presentation (Including Preparation Time)
8. Week Preparation of Word Processor Outputs Lecture; Question Answer; Problem Solving; Demonstration
Opinion Pool
Project Based Learning 		Homework Presentation (Including Preparation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.) Practice (Teaching Practice, Music/Musical Instrument Practice, Statistics, Laboratory, Field Work, Clinic and Polyclinic Practice)
9. Week Formatting in Spreadsheets Lecture; Question Answer; Discussion
Opinion Pool
Project Based Learning 		Homework Presentation (Including Preparation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
10. Week Formulas and Functions in Spreadsheets Lecture; Question Answer; Problem Solving; Demonstration
Opinion Pool
Project Based Learning 		Homework Presentation (Including Preparation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.) Practice (Teaching Practice, Music/Musical Instrument Practice, Statistics, Laboratory, Field Work, Clinic and Polyclinic Practice)
11. Week Chart in Spreadsheets Lecture; Question Answer; Problem Solving; Demonstration
Opinion Pool
Project Based Learning 		Homework Presentation (Including Preparation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.) Practice (Teaching Practice, Music/Musical Instrument Practice, Statistics, Laboratory, Field Work, Clinic and Polyclinic Practice)
12. Week Analysis in Spreadsheets Lecture; Question Answer; Problem Solving; Discussion; Demonstration
Opinion Pool
Project Based Learning 		Homework Presentation (Including Preparation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.) Practice (Teaching Practice, Music/Musical Instrument Practice, Statistics, Laboratory, Field Work, Clinic and Polyclinic Practice)
13. Week Verification and Control in Spreadsheets Lecture; Question Answer; Problem Solving; Demonstration
Opinion Pool
Project Based Learning 		Homework Presentation (Including Preparation Time) Project (Including Preparation and presentation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.) Practice (Teaching Practice, Music/Musical Instrument Practice, Statistics, Laboratory, Field Work, Clinic and Polyclinic Practice)
14. Week Increasing Efficiency and Collaborative Regulation on Spreadsheets Lecture; Question Answer; Problem Solving; Demonstration
Opinion Pool
Project Based Learning 		Homework Presentation (Including Preparation Time) Project (Including Preparation and presentation Time) Activity (Web Search, Library Work, Trip, Observation, Interview etc.)
15. Week Final exams Question Answer
Opinion Pool
Project Based Learning 		Homework

Sources Used in This Course
Recommended Sources
Ders Notları

Relations with Education Attainment Program Course Competencies
Program RequirementsContribution LevelDK1DK2DK3DK4DK5DK6DK7DK8DK9DK10DK11DK12DK13DK14DK15DK16DK17DK18
PY15555555555555555555
PY25555555555555555555
PY35555555555555555555
PY45555555555555555555
PY55555555555555555555
PY75555555555555555555
PY145555555555555555555
PY175555555555555555555

*DK = Course's Contrubution.
0 1 2 3 4 5
Level of contribution None Very Low Low Fair High Very High
.

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 2
Midterm Exam 1 1
Time to prepare for Midterm Exam 1 8
Final Exam 1 2
Time to prepare for Final Exam 1 12
Total Workload
Total Workload / 30 (s)
ECTS Credit of the Course
Quick Access Hızlı Erişim Genişlet
Course Information
  • Course Information
  • Weekly Topics (Content)
  • Sources Used in This Course
  • Relations with Education Attainment Program Course Competencies
  • ECTS credits and course workload