To improve reporting skills and to create more secure and useful documents by using Excel data tools.
Prerequisite(s)
-
Corequisite(s)
-
Special Requisite(s)
-
Instructor(s)
Assist. Prof. Dr. Okay Işık
Course Assistant(s)
Res. Assist. Hasan Hüseyin Çelebi
Schedule
Theori: Friday 09:00-10:45, ATA 2ENDMÜHLAB
Practice: Friday 11:00-12:45, ATA 2ENDMÜHLAB
Office Hour(s)
Friday 14:00-15:00, ATA 2B-01
Teaching Methods and Techniques
Lecture, Practice
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
Introduction to DSS and Excel
Oral presentation, Laboratory
2. Week
Excel Basics and Formatting
Oral presentation, Laboratory
3. Week
Referencing and Names
Oral presentation, Laboratory
4. Week
Functions and Formulas
Oral presentation, Laboratory
5. Week
Functions and Formulas
Oral presentation, Laboratory
6. Week
Charts and Sparklines
Oral presentation, Laboratory
7. Week
Pivot Tabels
Oral presentation, Laboratory
8. Week
Working with large data
Oral presentation, Laboratory
9. Week
Introduction to Visual Basic Environment
Oral presentation, Laboratory
10. Week
Recording Macros
Oral presentation, Laboratory
11. Week
More on Objects
Oral presentation, Laboratory
12. Week
More on Objects
Oral presentation, Laboratory
13. Week
Variables
Oral presentation, Laboratory
14. Week
Variables
Oral presentation, Laboratory
15. Week
Final Exam
16. Week
Final Exam
17. Week
Final Exam
Assessments
Evaluation tools
Quantity
Weight(%)
Midterm(s)
1
35
Quizzes
3
15
Final Exam
1
50
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
Use Excel Functions to perform the required tasks.
LO-2
Able to create charts and sparklines.
LO-3
Manage large volumes of data through the database functions.
LO-4
Know basic concepts of Visual Basic and Visual Basic Environment.