| 當期課號 |
3020 |
Course Number |
3020 |
| 授課教師 |
何金玲 |
Instructor |
HO,CHIN LING |
| 中文課名 |
財務套裝軟體應用 |
Course Name |
Computer Packages for Financial Manager |
| 開課單位 |
財務金融系(二進)四B |
Department |
|
| 修習別 |
必修 |
Required/Elective |
Required |
| 學分數 |
3 |
Credits |
3 |
| 課程目標 |
本課程之教學內容旨在使學生熟悉Windows基本原理及操作、應用Excel做資料處理，統計圖表及樞紐分析以及應用Word作文書編輯，圖表排版及圖文並排。 |
Objectives |
As an advanced course of computer packages, this course includes word processing and page formatting techniques. In addition, spreadsheets and macros manipulation is included. A semester project for financial analysis by using spreadsheets and macros is Required,. A well type-set final report is expected to be prepared. |
| 教材 |
1、Excel 商用 2003範例實作
2、Excel 函數與分析工具
3、Excel 實戰手冊
4、Excel 2003 高手攻略 |
Teaching Materials |
|
| 成績評量方式 |
1、作業（4～5次）*15％
2、出席率及上課狀況*15％
3、期中考（上機實做）*35％
3、期末考（上機實做）*35％ |
Grading |
|
| 教師網頁 |
|
| 教學內容 |
本課程之教學內容係以 Excel 2003 為主要工具，使用範例以循序漸進方式介紹該工具在財務計算、統計分析...等範疇之應用。除介紹 Excel 2003 各項指令之使用技巧外，亦會略涉獵VBA以及巨集之設計、Excel在Web上之應用、Excel與其他與其他資料庫之整合、合併列印、表單設計、樞紐分析與資料預測分析等。 |
Syllabus |
Office Excel 2003 is the main application tool in this course. We will introduce this tools step by step by using some examples in the financial affairs, statistical analysis and so on, except those functions’ skills, we will also mention the design of VBA, MACRO. |