Faculty of Engineering and Natural Sciences · Industrial Engineering (English 30%) · Undergraduate
Course Objective
The aim of this course is to enable students to effectively perform data management, analysis, and reporting processes in the Microsoft Excel environment. The course aims to equip students with competencies in problem solving, data analysis, and the automation of business processes through the use of both basic and advanced Excel tools.
Course Content
This course provides a comprehensive introduction to Microsoft Excel, covering both fundamental features and advanced functionalities. The course begins with an overview of the Excel user interface and continues with basic calculation methods and essential data processing techniques such as sorting, filtering, and calculating subtotals in tables. Students learn to efficiently manage and analyze data using commonly used logical, text, and lookup and reference functions in Excel. In addition, the course addresses the analysis of large datasets through the use of Pivot Tables and the visualization of data using charts. By the end of the course, students are expected to develop the ability to automate repetitive tasks and improve work efficiency through the use of Excel macro tools.
Required Resources
Lecture notes
Bilişim Teknolojileri, Hüseyin Uzunboylu, Pegem Akademi,2017
Recommended Resources
Office 2016 Türkçe, Bayram Yıldız. 2017, Kodlab, İstanbul.
Bilgisayar I-II (Temel Bilgi Teknolojileri), Zehra Alakoç Burma. 2013, Seçkin Yayıncılık, Ankara
Course Learning Outcomes
- Explain the Microsoft Excel interface, file structure, and fundamental working principles.
- Apply cell, row, and column operations effectively within workbooks and worksheets.
- Enter, organize, and format data to produce clear and professional reports.
- Use basic mathematical, logical, text, date and time, and lookup and reference functions to solve practical problems.
- Perform data analysis by applying sorting, filtering, subtotals, and pivot table techniques to datasets.
- Visualize and interpret data using charts and conditional formatting techniques.
- Develop solutions that reduce errors and automate processes in Excel by using data validation tools and macros.
Core Area Distribution
Teaching Methods
Assessment & Evaluation
ECTS / Workload
| Activity | Quantity | Duration (h) | Total Workload |
|---|---|---|---|
| Course Duration (Including Exam Week) | 16 | 2 | 32 |
| Out of Class Study Period | 16 | 1 | 16 |
| Midterm | 1 | 8 | 8 |
| Quiz | 0 | 0 | 0 |
| Assignment | 1 | 10 | 10 |
| Practice | 1 | 0 | 0 |
| Final | 1 | 8 | 8 |
Course Schedule
| Week | Subject | Preparation |
|---|---|---|
| 1 | Course Introduction, Introduction to Microsoft Excel | Lecture notes |
| 2 | Excel startup options, interface and menu overview, File menu and templates | Lecture Notes |
| 3 | Workbook and Worksheet concepts, page operations, cell operations | Lecture Notes |
| 4 | Data entry and data modification, row and column operations, custom lists, adding comments and notes | Lecture Notes |
| 5 | Cell formatting, cell styles, Format Painter | Lecture Notes |
| 6 | Printing output, page setup, view settings, basic calculations | Lecture Notes |
| 7 | Basic mathematical functions, absolute and relative cell references, sorting, filtering, subtotals, advanced filtering | Lecture Notes |
| 8 | Midterm | Midterm |
| 9 | Logical functions | Lecture Notes |
| 10 | Conditional Formatting, conditional calculations | Lecture Notes |
| 11 | Text functions | Lecture Notes |
| 12 | Lookup and Reference functions, date and time functions | Lecture Notes |
| 13 | Charts, Data Validation | Lecture Notes |
| 14 | Pivot Tables | Lecture Notes |
| 15 | Introduction to Macros | Lecture Notes |
| 16 | Final Exam | Final Exam |