Course Information


Course Information
Course Title Code Semester L+U Hour Credits ECTS
BASİC İNFORMATİON TECNOLOGY - II ADA124 2. Semester 2 + 0 2.0 2.0

Prerequisites None

Language of Instruction Turkish
Course Level Associate's Degree
Course Type Compulsory
Mode of delivery
Course Coordinator
Instructors MERAL GÜNEŞ ERGİN
Assistants
Goals Growing up people who have required information and capability to effective using of office applications in daily life, labour, education and communication.
Course Content Word Processing Software, Template Creation Document, Spreadsheet Tools account, use the formula in the table, Database Software, Database Creation Logic, Desktop Publishing Tools, brochures, newsletters and be able to Create Magazine
Learning Outcomes 1) 1) Know/Write interface components of word processing softwares. Know different file types and their features Perform opening and saving documents.
2) 2) Know font types and font styles. Search/Find/Replace text in documents. Organize paragraphs in documents.
3) 3) Know adding objects(image, shape, table, smartart etc.) into documents. Organize location of objects. Create documents with letterhead. Save document as petiton.

Weekly Topics (Content)
Week Topics Teaching and Learning Methods and Techniques Study Materials
1. Week 1) Know/Write interface components of word processing softwares. Know different file types and their features Perform opening and saving documents. Lecture; Question Answer; Case Study; Role Play; Demonstration

 Presentation (Including Preparation Time) Project (Including Preparation and presentation Time)
2. Week 2) Know font types and font styles. Search/Find/Replace text in documents. Organize paragraphs in documents. Lecture

 Presentation (Including Preparation Time)
3. Week 3) Know adding objects(image, shape, table, smartart etc.) into documents. Organize location of objects. Create documents with letterhead. Save document as petiton. Lecture; Question Answer

 Presentation (Including Preparation Time)
4. Week 4) Perform page format/appearances options. Know adding content table, footer and resources. Know/Write matching address-letter composition. Lecture

 Homework
5. Week 5) Know printing operation. Correct document faults. Edit documents to print well. Question Answer

 Presentation (Including Preparation Time)
6. Week 6) Know spreadsheet, table, row, column and cell concepts. Know/Write interface components. Know opening-adding-editing operations of sheet and workbook. Lecture; Question Answer

 Presentation (Including Preparation Time)
7. Week 7) Know ading-deleting table and cell formats. Format cell data with conditional statements. Lecture; Question Answer

 Presentation (Including Preparation Time)
8. Week 8) Use adding function concept. Know writing, editing, practising formulas. Know/Perform operators of formulas. Lecture; Question Answer

 Presentation (Including Preparation Time)
9. Week 9) Know/Perform creating subtables from supertables, applying filter operations, creating graphics. Know defining primitives in tables. Lecture; Question Answer; Problem Solving

 Presentation (Including Preparation Time)
10. Week 10) Know Database and data concepts. Perform creating form, query and report. Know/Perform defining new data types Lecture; Question Answer

 Presentation (Including Preparation Time)
11. Week 11) Know/Write Desktop publishing softwares. Know creating design criter. Question Answer; Problem Solving

 Presentation (Including Preparation Time)
12. Week 12) Know creating basic templates for designing Bulletin, Advertisement, Brochures, Series, Newspaper etc. Question Answer; Problem Solving

 Presentation (Including Preparation Time)
13. Week Desktop Publishing Software Features, Publishing and Design Concept, Desktop Publishing Program Interface Components, Creating Different Types of Files (Bulletin, Brochure, Magazine, Newspaper, Ad, Web Page, etc.) Lecture; Question Answer

 Presentation (Including Preparation Time)
14. Week Working with Templates, Different Types of File Recording, Adding Objects to Image (Image, Shape, Table etc.) Color Schemes, Fonts Question Answer

 Presentation (Including Preparation Time)

Sources Used in This Course
Recommended Sources
Gürkan, O. (2010) Microsoft Office 2010 Ankara: Nirvana Yayınları
Gürkan, O. (2010)Yeni Başlayanlar İçin Bilgisayar Windows 7 - Office 2010 Ankara: Nirvana Yayınları
http://kursiyernet.meb.gov.tr
http://www.megep.meb.gov.tr (Mesleki Gelişim Program Modülleri)
Yıldız, B. (2010) Office 2010 Ankara: Kodlab Yayın Dağıtım

Relations with Education Attainment Program Course Competencies
Program RequirementsContribution LevelDK1DK2DK3
PY55555

*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 4
Presentation (Including Preparation Time) 1 1
Report (Including Preparation and presentation Time) 1 1
Activity (Web Search, Library Work, Trip, Observation, Interview etc.) 1 1
Practice (Teaching Practice, Music/Musical Instrument Practice , Statistics, Laboratory, Field Work, Clinic and Polyclinic Practice) 1 1
Seminar 1 1
Midterm Exam 1 1
Final Exam 1 1
1 1
1 1
1 1
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