Education Information System

Course Title	Code	Semester	L+U Hour	Credits	ECTS
-	BIT1101	1. Semester	1 + 1	2.0	2.0

Prerequisites

None

Language of Instruction	Turkish
Course Level	Associate
Course Type
Mode of delivery	Face to Face
Course Coordinator	Lect. Gülden KABAKÇI
Instructor(s)	Gülden KABAKÇI
Assistants
Goals	Providing basic level usage skills of MS Excel office application program.
Course Content	Basic level use of MS Excel.
Learning Outcomes	- Using MS Excel, you can create a workbook, enter data into cells, and add formulas. - Can create graphs of data using MS Excel and change properties of programs and workbooks and print the document. - It carries out the editing and printing of tables and business letters used in business life.

Week	Topics	Learning Methods
1. Week	MS Excel - Introduction to Excel, page and cell concepts, cursor types.	Verbal Expression Course Hours
2. Week	MS Excel - elements of the interface of the spreadsheet program, getting acquainted with the toolbars, working with files, navigating the worksheet.	Visual Presentation Verbal Expression Practice Course Hours
3. Week	MS Excel - Data manipulation.	Practice Course Hours Verbal Expression Visual Presentation
4. Week	MS Excel - Row and column operations.	Visual Presentation Verbal Expression Practice Course Hours
5. Week	MS Excel - Moving-copying and special paste operations.	Visual Presentation Practice Course Hours Verbal Expression
6. Week	MS Excel - Autocorrect and fill options, find-replace-go, insert clip art and descriptions, use of image toolbar.	Visual Presentation Verbal Expression Practice Course Hours
7. Week	MS Excel - Formatting operations.	Course Hours Verbal Expression Visual Presentation Practice Preparation, After Class Study
8. Week	MS Excel - Page settings and printing options.	Course Hours Verbal Expression Preparation, After Class Study Practice Visual Presentation
9. Week	MS Excel - Window settings.	Course Hours Verbal Expression Practice Visual Presentation
10. Week	MS Excel - Formula writing, use of existing formulas and mathematical functions.	Practice Preparation, After Class Study Course Hours Verbal Expression
11. Week	MS Excel - Formula writing, use of existing formulas and mathematical functions.	Practice Verbal Expression Preparation, After Class Study Course Hours
12. Week	MS Excel - Statistical functions, date lookup and text functions.	Practice Visual Presentation Verbal Expression Course Hours
13. Week	MS Excel- Graphic operations.	Preparation, After Class Study Visual Presentation Verbal Expression Practice Course Hours
14. Week	MS Excel - Data analysis.	Verbal Expression Preparation, After Class Study Visual Presentation Practice Course Hours

Excel for Engineers, Seçkin Publishing. / Excel for Everyone, Abaküs Kitap.

Program Requirements	Contribution Level	DK1	DK2	DK3	Measurement Method
PY4	2	2	2	2	40,60
PY9	3	3	3	3	40,60

*DK = Course's Contrubution.

	0	1	2	3	4	5
Course's Level of contribution	None	Very Low	Low	Fair	High	Very High
Method of assessment/evaluation		Written exam	Oral Exams	Assignment/Project	Laboratory work	Presentation/Seminar

Event	Quantity	Duration (Hour)	Total Workload (Hour)
Course Hours	14	2	28
Other Activities	4	1	4
Preparation, After Class Study	4	1	4
Midterm 1	1	1	1
Final	1	1	1
Classroom Activities	13	1	13
Total Workload			51
ECTS Credit of the Course			25.5 2.0