Education Information System

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

Prerequisite Courses

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/Applications	Method
1. Week	MS Excel - Introduction to Excel, page and cell concepts, cursor types.	Course Hours Verbal Expression
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 Course Hours Practice Verbal Expression
3. Week	MS Excel - Data manipulation.	Practice Verbal Expression Course Hours Visual Presentation
4. Week	MS Excel - Row and column operations.	Course Hours Visual Presentation Verbal Expression Practice
5. Week	MS Excel - Moving-copying and special paste operations.	Practice Verbal Expression Visual Presentation Course Hours
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 Preparation, After Class Study Verbal Expression Visual Presentation Practice
8. Week	MS Excel - Page settings and printing options.	Verbal Expression Preparation, After Class Study Practice Course Hours Visual Presentation
9. Week	MS Excel - Window settings.	Practice Verbal Expression Visual Presentation Course Hours
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.	Verbal Expression Preparation, After Class Study Practice Course Hours
12. Week	MS Excel - Statistical functions, date lookup and text functions.	Visual Presentation Verbal Expression Practice Course Hours
13. Week	MS Excel- Graphic operations.	Course Hours Practice Visual Presentation Verbal Expression Preparation, After Class Study
14. Week	MS Excel - Data analysis.	Practice Verbal Expression Course Hours Preparation, After Class Study Visual Presentation

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

Program Requirements	Contribution Level	DK1	DK2	DK3	Measurement Method
PY1	3	3	3	3	40,60
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