109年第2學期-2820 Excel for Finance 課程資訊

教育目標

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.

基本資料

選修課，學分數：0-3
上課時間：二/7,8,9[M016] 四/9[M025] 一/5,6,7[M219] 三/7,8,9,五/8[M222]
修課班級：國經學程1-4
修課年級：年級以上
選課備註：密集授課 2021/05/23-2021/06/25，限人工加選，週四課程於電腦教室上課。

參考書目

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