Education Information System

Course Title	Code	Semester	L+U Hour	Credits	ECTS
Computer I	MAK1151	1. Semester	2 + 0	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. - 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. - 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. - 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
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.	Practice Visual Presentation 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.	Course Hours Practice Visual Presentation Verbal Expression
3. Week	MS Excel - Data manipulation.	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.	Course Hours Verbal Expression Practice Visual Presentation
4. Week	MS Excel - Row and column operations.	Course Hours Verbal Expression Visual Presentation Practice
5. Week	MS Excel - Moving-copying and special paste operations.	Visual Presentation Practice Verbal Expression Course Hours
5. Week	MS Excel - Moving-copying and special paste operations.	Course Hours Visual Presentation Verbal Expression Practice
6. Week	MS Excel - Autocorrect and fill options, find-replace-go, insert clip art and descriptions, use of image toolbar.	Visual Presentation Practice Verbal Expression Course Hours
6. Week	MS Excel - Autocorrect and fill options, find-replace-go, insert clip art and descriptions, use of image toolbar.	Verbal Expression Visual Presentation Course Hours Practice
7. Week	MS Excel - Formatting operations.	Preparation, After Class Study Visual Presentation Course Hours Practice Verbal Expression
7. Week	MS Excel - Formatting operations.	Preparation, After Class Study Verbal Expression Visual Presentation Practice Course Hours
8. Week	MS Excel - Page settings and printing options.	Practice Preparation, After Class Study Verbal Expression Course Hours Visual Presentation
8. Week	MS Excel - Page settings and printing options.	Verbal Expression Practice Visual Presentation Course Hours Preparation, After Class Study
9. Week	MS Excel - Window settings.	Course Hours Visual Presentation Practice Verbal Expression
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.	Verbal Expression Practice Preparation, After Class Study Course Hours
10. Week	MS Excel - Formula writing, use of existing formulas and mathematical functions.	Course Hours Preparation, After Class Study Verbal Expression Practice
11. Week	MS Excel - Formula writing, use of existing formulas and mathematical functions.	Verbal Expression Practice Preparation, After Class Study Course Hours
11. Week	MS Excel - Formula writing, use of existing formulas and mathematical functions.	Preparation, After Class Study Verbal Expression Course Hours Practice
12. Week	MS Excel - Statistical functions, date lookup and text functions.	Practice Verbal Expression Visual Presentation Course Hours
12. Week	MS Excel - Statistical functions, date lookup and text functions.	Verbal Expression Visual Presentation Practice Course Hours
13. Week	MS Excel- Graphic operations.	Practice Course Hours Preparation, After Class Study Verbal Expression Visual Presentation
13. Week	MS Excel- Graphic operations.	Preparation, After Class Study Course Hours Verbal Expression Visual Presentation Practice
14. Week	MS Excel - Data analysis.	Course Hours Preparation, After Class Study Visual Presentation Practice Verbal Expression
14. Week	MS Excel - Data analysis.	Practice Course Hours Verbal Expression Preparation, After Class Study Visual Presentation

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

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