2. To develop skills in developing financial models to solve financial problems and solving them with Microsoft Excel and VBA 3. To utilize and integrate spreadsheet functionalities, programming, and interfaces in financial applications 4. To develop skills in designing, coding, and debugging computer programs. 5. To learn to use Matlab to perform advanced analyses COURSE LEARNING OUTCOMES Aligned Programme Course Learning Outcomes Learning Outcomes (2016 spring version) PLO 1 CLO1. Understand the basic features of Excel spreadsheet functions. CLO2. Analyze and provide optimal solutions for the financial problems related PLO 1, 2, 3, 4 to firms’ cash flows, operations, and financial leverage. CLO3. Understand the basic features of VBA. PLO 1, 3 CLO4. Analyze and assess the fair values of various securities including stocks and bonds PLO 1, 2, 3, 4 CLO5. Understand the pricing tools for European and American options, Including Black-Scholes option formula and binomial trees. PLO 1, 2 COURSE TEACHING AND LEARNING ACTIVITIES Expected Study Load Course Teaching and Learning Activities contact hour (% of study) T&L1. Lectures 36 hours 27.27% T&L2. Assignments 36 hours 27.27% T&L3. Tutorials 12 hours 9.09% T&L4. Self-study 48 hours 36.36% Total 132 hours 100% Aligned Course Assessment Methods Brief Description (Optional) Weight Learning Outcomes A1. Participations 10% 10% CLO 1, 2, 3, 4, 5 A2. Assignments (4) 40% (10% each) 40% CLO 1, 2, 3, 4, 5 A3. Examinations 50% 50% CLO 1, 2, 3, 4, 5 Total 100% 100% STANDARDS FOR ASSESSMENT Course Grade Descriptors Exhibited high level of understanding of the course materials through dedicated participations, A+, A, A- completion of all assignments with almost perfect scores, and excellent performance in final examination. Exhibited reasonably high level of understanding of the course materials through full participations, B+, B, B- completion of all assignments with good scores, and good performance in final examination.
2. To develop skills in developing financial models to solve financial problems and solving them with Microsoft Excel and VBA 3. To utilize and integrate spreadsheet functionalities, programming, and interfaces in financial applications 4. To develop skills in designing, coding, and debugging computer programs. 5. To learn to use Matlab to perform advanced analyses COURSE LEARNING OUTCOMES Course Learning Outcomes Aligned Programme Learning Outcomes (2016 spring version) CLO1. Understand the basic features of Excel spreadsheet functions. CLO2. Analyze and provide optimal solutions for the financial problems related to firms’ cash flows, operations, and financial leverage. CLO3. Understand the basic features of VBA. CLO4. Analyze and assess the fair values of various securities including stocks and bonds CLO5. Understand the pricing tools for European and American options, Including Black-Scholes option formula and binomial trees. PLO 1 PLO 1, 2, 3, 4 PLO 1, 3 PLO 1, 2, 3, 4 PLO 1, 2 COURSE TEACHING AND LEARNING ACTIVITIES Course Teaching and Learning Activities Expected contact hour Study Load (% of study) T&L1. Lectures T&L2. Assignments T&L3. Tutorials T&L4. Self-study 36 hours 36 hours 12 hours 48 hours 27.27% 27.27% 9.09% 36.36% Total 132 hours 100% Assessment Methods Brief Description (Optional) Weight Aligned Course Learning Outcomes A1. Participations A2. Assignments (4) A3. Examinations 10% 40% (10% each) 50% 10% 40% 50% CLO 1, 2, 3, 4, 5 CLO 1, 2, 3, 4, 5 CLO 1, 2, 3, 4, 5 Total 100% 100% STANDARDS FOR ASSESSMENT Course Grade Descriptors A+, A, A- B+, B, B- Exhibited high level of understanding of the course materials through dedicated participations, completion of all assignments with almost perfect scores, and excellent performance in final examination. Exhibited reasonably high level of understanding of the course materials through full participations, completion of all assignments with good scores, and good performance in final examination.
Course_outline_MFIN%206002%202014%20Dec%20Jan%20-%20updated%20PLO.docx