The purpose of this course is to give the students an idea of the tools available in Excel. An overview of Excel basic and extended functionalities will be explored throughout course. The basic functionality topics include referencing and names, functions and formulas, charts, pivot tables and other Excel basics. On the other hand, statistical analysis, modeling and solving optimization problems, simulation and working with large data are among the extended functionality topics. Students will learn developing and implementing solutions to the problems arising in industrial engineering area using the popular database management and spreadsheet software Excel.
Prerequisite(s)
None
Corequisite(s)
None
Special Requisite(s)
None
Instructor(s)
Professor Fadime Üney-Yüksektepe
Course Assistant(s)
Res. Assist. Ezgi Yıldırım Arslan & Res. Assist. Oğuz Emir
Schedule
This course is not offered in this semester.
Office Hour(s)
This course is not offered in this semester.
Teaching Methods and Techniques
Lecture, Lab Exercises
Principle Sources
Ekşioğlu, S.D., Şeref, M.M.H., Ahuja, R.K., Winston, W.L. (2011). Developing Spreadsheet-Based Decision Support Systems: Using Excel and VBA for Excel (2nd Edition). Dynamic Ideas, Belmont, Massachusetts.
Other Sources
Course Schedules
Week
Contents
Learning Methods
1. Week
Syllabus Information &
Chapter 1 - Introduction
Oral Presentation, Laboratory
2. Week
Chapter 2 - Excel Basics and Formatting
Oral Presentation, Laboratory
3. Week
Chapter 3 - Referencing and Names
Oral Presentation, Laboratory
4. Week
Chapter 4 - Functions and Formulas
Oral Presentation, Laboratory
5. Week
Chapter 4 - Functions and Formulas
Oral Presentation, Laboratory
6. Week
Chapter 4 - Functions and Formulas
Oral Presentation, Laboratory
7. Week
Chapter 5 - Charts and Sparklines
Oral Presentation, Laboratory
8. Week
MIDTERM EXAM
9. Week
Chapter 6 - Pivot Tables
Course Seminar
Oral Presentation, Laboratory
10. Week
Chapter 7 - Statistical Analysis with Excel
Oral Presentation, Laboratory
11. Week
Chapter 7 - Statistical Analysis with Excel
Oral Presentation, Laboratory
12. Week
Chapter 8 - Solving Mathematical Models
Oral Presentation, Laboratory
13. Week
Chapter 9 - Simulation
Oral Presentation, Laboratory
14. Week
Chapter 10 - Working with Large Data
Oral Presentation, Laboratory
15. Week
FINAL EXAM
16. Week
FINAL EXAM
17. Week
FINAL EXAM
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
30
Quizzes
2
10
Lab Exercises
11
25
Final Exam
1
35
Program Outcomes
PO-1
Ability to apply theoretical and practical knowledge gained by Mathematics, Science and their engineering fields and ability to use their knowledge in solving complex engineering problems.
PO-2
Ability of determining, defining, formulating and solving complex engineering problems; for that purpose develop the ability of selecting and implementing suitable models and methods of analysis.
PO-3
Ability of designing a complex system, process, device or product under real world constraints and conditions serving certain needs; for this purpose ability of applying modern design techniques
PO-4
Ability of selecting and using the modern techniques and devices which are necessary for analyzing and solving complex problems in engineering implementations; ability of efficient usage of information technologies.
PO-5
Ability of designing experiments, conducting tests, collecting data and analyzing and interpreting the solutions to investigate of complex engineering problems or discipline-specific research topics.
PO-6
Ability of working efficiently in intra-disciplinary and multi-disciplinary teams; individual working ability and habits.
PO-7
Ability of verbal and written communication skills; and at least one foreign language skills, ability to write effective reports and understand written reports, ability to prepare design and production reports, ability to make impressive presentation, ability to give and receive clear and understandable instructions
PO-8
Awareness of importance of lifelong learning; ability to access data, to follow up the recent innovation in science and technology for continuous self-improvement.
PO-9
Conformity to ethical principles; knowledge about occupational and ethical responsibility, and standards used in engineering applications.
PO-10
Knowledge about work life implementations such as project management, risk management and change management; awareness about entrepreneurship and innovativeness; knowledge about sustainable development.
PO-11
Knowledge about effects of engineering applications on health, environment and security in global and social dimensions, and on the problems of the modern age in engineering; awareness about legal outcomes of engineering solutions.
Learning Outcomes
LO-1
Create mathematical formulas in Excel using absolute/relative referencing and giving names to the cells
LO-2
Use Excel functions to perform required task
LO-3
Create simple and dynamic charts and sparklines
LO-4
Create frequency tables using pivot table functions in Excel
LO-5
Manage large volumes of data through the database functions