1. Homepage
  2. Law
  3. Course Plans
  4. Hesaplamalı Yöntemler ve Araçlar

PDF

COURSE DESCRIPTION AND APPLICATION INFORMATION

Course Name Code Semester T+A+L (hour/week) Type (C / O) Local Credit ECTS
Computational Methods and Tools MIS 204 Spring 02+00+02 Elective 3 6
Academic Unit: Management Information Systems
Mode of Delivery: Face to face
Prerequisites: MIS103
Language of Instruction: English
Level of Course Unit: Undergraduate
Course Coordinator: - -
Course Objectives: To provide basic numerical methods and equip students with computational tools such as MS-Excel and Matlab.
Course Contents: Introduction to basic numerical analysis and methods. Taylor series. Methods for root finding. Advanced excel, writing macros, MATLAB: constants, variables, control structures, loops, and writing functions, drawing 2 and 3 dimensional graphs.
Learning Outcomes of the Course Unit (LO):
  • 1- Ability to understand a problem and to gain skills to solve it
  • 2- Ability to apply basic numerical methods to MIS problems
  • 3- Ability to analyze business problems and solve business problems using MS-Excel
  • 4- Ability to analyze business problems and solve business problems using mathematical package, such as Matlab
Planned Learning Activities and Teaching Methods: In class lectures, problem solving cases, homework, quizzes, midterm and final exams.


WEEKLY SUBJECTS AND RELATED PREPARATIONS

WeekSubjectsRelated Preperation
1 Overview of computers and programming Chapter 1 of [1]
2 Solving Problems Skills: Algorithms Chapter 2 & Chapter 2 of [1]
3 Basic numerical methods: Root finding, polynomials, curve fitting TBD
4 Basic numerical methods: Root finding, polynomials, curve fitting cnt. TBD
5 Introduction to MS-Excel basic Chapters 1-3 of [2]
6 MS Excel Functions Chapters 4 & 5 of [2]
7 MS Excel Programming Chapters 6& 7 of [2]
8 Midterm
9 Introduction to Matlab Chapters 1 & 2 of [3]
10 Control Structures of Matlab Chapters 2 & 3 of [3]
11 Repetition Structures of Matlab Chapters 2 & 3 of [3]
12 Writing functions in Matlab Chapters 3 & 4 of [3]
13 Writing functions in Matlab Cont. Chapters 3 & 4 of [3]
14 Matlab Libraries Chapter 5 of [3]


REQUIRED AND RECOMMENDED READING

1. Overview of Programming and Problem Solving
2. D.Gross, F.Akaiwa, K.Nordquist, Succeeding in Business with MS-Excel 2010 A Problem Solving Approach, International Edition (2011), Course Technology Cengage Learning.
3. Matlab: A Practical Introduction to Programming and Problem Solving, 2nd Edition, Stormy Attaway, Butterworth-Heinemann, 2011.


OTHER COURSE RESOURCES

1. E. Monk, J. Brady, G.S. Cook, (2012) Problem Solving Cases in Microsoft Access and Excel, International Edition, 9e, Course Technology Cengage Learning.
2. Lisa Millar (2009) MIS Cases, Decision Making with Application Software, Fourth Edition, Pearson


ASSESSMENT METHODS AND CRITERIA

Semester RequirementsNumberPercentage of Grade (%)
Laboratory 12 20
Homework Assignments 4 10
Midterms / Oral Exams / Quizes 5 30
Final Exam 1 40
Total: 22 100


WORKLOAD

EventsCountDuration (Hours)Total Workload (hour)
Course Hours14456
Homework Assigments4520
Extra-Class Activities (reading,individiual work, etc.)14342
Midterms / Oral Exams / Quizes5315
Final Exam11515
Total Workload (hour):148


THE RELATIONSHIP BETWEEN COURSE LEARNING OUTCOMES (LO) AND PROGRAM QUALIFICATIONS (PQ)

# PQ1 PQ2 PQ3 PQ4 PQ5 PQ6 PQ7 PQ8 PQ9 PQ10
LO1                    
LO2                    
LO3                    
LO4