2824 - Excel for Finance 英授 Taught in English

Excel for Finance

教育目標 Course Target

This course introduces students to the fundamentals of R as used for business applications. R is a both a programming language and a software development environment. It is collaboratively developed under the auspices of the R Foundation for Statistical Computing, and has been available, free of charge, since 1993. Today, it is among the world’s foremost programming languages, and is widely used for statistical analysis and reporting. Learning R will not only enable you to write your own code, but also to use freely downloadable programs developed by a vibrant community of R programmers and researchers.

There are three course goals. The first is to introduce fundamental concepts such as syntax (e.g., comments and statements), structure (e.g., loops and conditional logic), data types, and the process of coding, testing and debugging. These are the building blocks not only of R, but also of other programming languages.

The second goal is to provide opportunities for systematic application of these concepts through a series of exercises. The practice exercises, completed on an individual basis, will involve problems in business, social sciences, and other disciplines.

The third goal is to engage in R development on a larger scale through participation in team projects. The completed projects will be the basis for the in-class presentation at the end of the semester.

This course introduces students to the fundamentals of R as used for business applications. R is a both a programming language and a software development environment. It is collaboratively developed under the auspices of the R Foundation for Statistical Computing, and has been available, free of charge, since 1993. Today, it is among the world’s foremost programming languages, and is widely used for statistical analysis and reporting. Learning R will not only enable you to write your own code, but also to use freely downloadable programs developed by a vibrant community of R programs and researchers.

There are three course goals. The first is to introduce fundamental concepts such as syntax (e.g., comments and statements), structure (e.g., loops and conditional logic), data types, and the process of coding, testing and debugging. These are the building blocks not only of R, but also of other programming languages.

The second goal is to provide opportunities for systemic application of these concepts through a series of exercises. The practice exercises, completed on an individual basis, will involve problems in business, social sciences, and other disciplines.

The third goal is to engage in R development on a larger scale through participation in team projects. The completed projects will be the basis for the in-class presentation at the end of the semister.

參考書目 Reference Books


Business Statistics for Competitive Advantage with Excel 2016 (Cynthia Fraser)
Springer International Publishing, Ltd.
e-book ISBN: 978-3-319-32185-1

Essential Excel 2016 (David Slager)
Apress Publishing
e-book ISBN: 978-1-4842-2161-7


Business Statistics for Competitive Advantage with Excel 2016 (Cynthia Fraser)
Springer International Publishing, Ltd.
e-book ISBN: 978-3-319-32185-1

Essential Excel 2016 (David Slager)
Apress Publishing
e-book ISBN: 978-1-4842-2161-7

評分方式 Grading

評分項目
Grading Method
配分比例
Percentage
說明
Description
Midterm Exam
Midterm Exam
20
Final Exam
Final Exam
20
Project
Project
40
Attendance/Homework
Attendance/Homework
20

授課大綱 Course Plan

點擊下方連結查看詳細授課大綱
Click the link below to view the detailed course plan

查看授課大綱 View Course Plan

相似課程 Related Courses

無相似課程 No related courses found

課程資訊 Course Information

基本資料 Basic Information

  • 課程代碼 Course Code: 2824
  • 學分 Credit: 0-3
  • 上課時間 Course Time:
    Thursday/5,Friday/5[M024] Friday/6[M116]
  • 授課教師 Teacher:
    Carol Anne Troy
  • 修課班級 Class:
    國經學程1-4
選課狀態 Enrollment Status

目前選課人數 Current Enrollment: 59 人

交換生/外籍生選課登記

請點選上方按鈕加入登記清單,再等候任課教師審核。
Add this class to your wishlist by clicking the button above.