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 Doç. Dr. Engin NAS
Instructor(s) Doç. Dr. Engin NAS (Güz)
Goals Providing basic level usage skills of MS Excel office application program.
Course Content Basic level use of MS Excel.
Learning Outcomes
# Öğrenme Kazanımı
1 He/She uses the computer effectively and efficiently.
2 He/She will become computer literate.
3 Create tables, draw graphs.
4 They prepare presentations and promote products.
Lesson Plan (Weekly Topics)
Week Topics/Applications Method
1. Week MS Excel - Introduction to Excel, page and cell concepts, cursor types. Interview
2. Week MS Excel - elements of the interface of the spreadsheet program, getting acquainted with the toolbars, working with files, navigating the worksheet. Interview, Presentation (Preparation), Practice
3. Week MS Excel - Data manipulation. Interview, Presentation (Preparation), Practice
4. Week MS Excel - Row and column operations. Interview, Presentation (Preparation), Practice
5. Week MS Excel - Moving-copying and special paste operations. Interview, Presentation (Preparation), Practice
6. Week MS Excel - Autocorrect and fill options, find-replace-go, insert clip art and descriptions, use of image toolbar. Interview, Presentation (Preparation), Practice
7. Week MS Excel - Formatting operations. Preparation, After Class Study, Interview, Presentation (Preparation), Practice
8. Week MS Excel - Page settings and printing options. Preparation, After Class Study, Interview, Presentation (Preparation), Practice
9. Week MS Excel - Window settings. Interview, Presentation (Preparation), Practice
10. Week MS Excel - Formula writing, use of existing formulas and mathematical functions. Preparation, After Class Study, Interview, Practice
11. Week MS Excel - Formula writing, use of existing formulas and mathematical functions.
*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.
The Matrix for Course & Program Learning Outcomes
No Program Requirements Level of Contribution
1 2 3 4 5
1 1. Has basic, up-to-date and applied knowledge about his/her profession.
2 2. Has knowledge about occupational health and safety, environmental awareness and quality processes.
3 3. Follows current developments and applications for his/her profession and uses them effectively.
4 4. Effectively uses information technologies (software, program, animation etc.) related to his/her profession.
5 5. Has the ability to evaluate professional problems and issues independently with an analytical and critical approach and present solution proposals.
6 6. Can effectively present his/her thoughts through written and verbal communication at the level of knowledge and skills and express them in an understandable manner.
7 7. Takes responsibility as a team member to solve unforeseen complex problems encountered in applications related to his/her field.
8 8. Has awareness about career management and lifelong learning.
9 9. Has social, scientific, cultural and ethical values in the stages of collecting, applying and announcing the results of data related to his/her field.
10 10. Follows information in his/her field using a foreign language and communicates with his/her colleagues.
10 10. Follows information in his/her field using a foreign language and communicates with his/her colleagues.
11 11. Explains manufacturing methods and selects appropriate manufacturing methods.
12 12. Makes sheet-metal and volume mold design, computer-aided production and production plan, prepares manufacturing and assembly drawings.
13 13. Explains measurement and control processes and uses precision measuring instruments.
14 14. Makes mathematical calculations related to the field.
Relations with Education Attainment Program Course Competencies
Program Requirements DK1 DK2 DK3 DK4
PY1 0 0 0 0
PY2 0 0 0 0
PY3 3 3 3 3
PY4 4 4 4 4
PY5 2 2 2 2
PY6 3 3 3 3
PY7 0 0 0 0
PY8 0 0 0 0
PY9 0 0 0 0
PY10 0 0 0 0
PY11 0 0 0 0
PY12 0 0 0 0
PY13 0 0 0 0
PY14 0 0 0 0
Evaluation Method
Güz Dönemi
Responsible Personnel Grup Evaluation Method Percentage
Doç. Dr. Engin NAS Vize 40.00
Doç. Dr. Engin NAS Final 60.00
Toplam 100.00
ECTS credits and course workload
ECTS credits and course workload Quantity Duration (Hour) Total Workload (Hour)
Ders İçi
Class Hours 14 1 14
Ders Dışı
Preparation, After Class Study 21 1 21
Sınavlar
Midterm 1 1 1 1
Final 1 1 1
Total Workload 37
*AKTS = (Total Workload) / 25,5 ECTS Credit of the Course 2.0