Education Information System

Course Information

Course Information

Course Title	Code	Language	Type	Semester	L+U Hour	Credits	ECTS
-	BIT1101	Turkish	Compulsory	1. Semester	1 + 1	2.0	2.0

Prerequisite Courses
Course Level	Associate
Mode of delivery	Face to Face
Course Coordinator
Instructor(s)	Öğr. Gör. Dr. Emin ŞEŞEN (Güz)
Goals	This course aims to teach students how to use word processing, spreadsheet and presentation software at a basic level in order to gain information literacy.
Course Content	Create and manage documents, format text, paragraphs and sections, create tables and lists, create and manage references, add and format graphic elements with word processing software; spreadsheet software to create and manage worksheets and workbooks, manage data cells and ranges, create tables, perform operations with formulas and functions, create graphics and objects; presentation software to create and manage presentations, insert and format text, shapes and images, insert tables, graphics, SmartArt and media, apply transitions and animations, manage multiple presentations.

Learning Outcomes

#	Öğrenme Kazanımı
1	The use of effective and efficient computer
2	Computer literacy
3	creating tables, graphing
4	Made presentations and product demonstrations
5	Using the internet efficiently

Lesson Plan (Weekly Topics)

Week	Topics/Applications	Method
1. Week	Understanding Microsoft Word, Basic Editing	Class Hours (14 weeks) Other Activities Preparation, After Class Study Research
2. Week	Character Formatting, Paragraph Formatting	Class Hours (14 weeks) Preparation, After Class Study Research Other Activities
3. Week	Managing Text Flow, Creating Tables	Class Hours (14 weeks) Preparation, After Class Study Research Other Activities
4. Week	Themes, Style Sets, Backgrounds, Working with Quick Panes and Text Boxes, Using Illustrations and Graphics, Formatting a Research Paper	Class Hours (14 weeks) Preparation, After Class Study Research Other Activities
5. Week	Overview, Working with Microsoft Excel 2016	Class Hours (14 weeks) Preparation, After Class Study Research Other Activities
6. Week	Using Office Backstage, Using Basic Formulas	Research Other Activities Class Hours (14 weeks) Preparation, After Class Study
7. Week	Using Functions, Formatting Cells and Ranges	Research Other Activities Class Hours (14 weeks) Preparation, After Class Study
8. Week	Formatting Worksheets, Managing Worksheets	Other Activities Class Hours (14 weeks) Preparation, After Class Study Research
9. Week	Working with Data and Macros, Using Advanced Formulas	Other Activities Class Hours (14 weeks) Preparation, After Class Study Research
10. Week	Protecting Workbooks, Creating Graphics, Adding Pictures and Shapes to a Worksheet	Preparation, After Class Study Research Other Activities Class Hours (14 weeks)
11. Week	Microsoft PowerPoint with Outlines, Principles of Working with Presentations, Working with Texts	Class Hours (14 weeks) Preparation, After Class Study Other Activities Research
12. Week	Designing a Presentation, Adding Tables to Slides, Using Graphics in a Presentation	Class Hours (14 weeks) Preparation, After Class Study Research Other Activities
13. Week	Create SmartArt Graphics, Add Graphics to a Presentation, Use Animation and Multimedia	Class Hours (14 weeks) Preparation, After Class Study Research Other Activities
14. Week	Preserving and Sharing the Presentation, Presenting the Presentation	Class Hours (14 weeks) Other Activities Preparation, After Class Study Research

*Midterm and final exam dates are not specified in the 14-week course operation plan. Midterm and final exam dates are held on the dates specified in the academic calendar with the decision of the University Senate.

Relations with Education Attainment Program Course Competencies

Program Requirements	DK1	DK2	DK3	DK4	DK5

Recommended Sources

Ders Kitabı veya Notu	Ders Kitabı veya Ders Notu bulunmamaktadır.
Diğer Kaynaklar	Bilgisayarın Temelleri ve Office 2007, Yrd. Doç. Dr. Deniz Mertkan GEZGİ

ECTS credits and course workload

ECTS credits and course workload		Quantity	Duration (Hour)	Total Workload (Hour)
Ders İçi	Class Hours (14 weeks)	14	2	28
Ders Dışı	Preparation, After Class Study	11	1	11
	Research	5	1	5
	Other Activities	5	1	5
Sınavlar	Midterm 1	1	1	1
Sınavlar	Final	1	1	1
Total Workload				51
*AKTS = (Total Workload) / 25,5		ECTS Credit of the Course		25.5 2.0