| 當期課號 | 1007 | Course Number | 1007 |
|---|---|---|---|
| 授課教師 | 林泓毅 | Instructor | LIN,HUNG YI |
| 中文課名 | 財務套裝軟體應用 | Course Name | Computer Packages for Financial Manager |
| 開課單位 | 財務金融系(二日)四A | 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. |
| 教材 | Excel 2003 商業財會 範例實作/ 旗標 | Teaching Materials | |
| 成績評量方式 | 五次隨堂作業 3*15%，期末專題25%，平時出席成績30% | Grading | Class-works 3*15%, Final project 25%, Attendance and usual performance 30% |
| 教師網頁 | http://www.cvyut.edu.tw/~linhy | ||
| 教學內容 | 本課程之教學內容主要在使學生熟悉財務資料的各種基本操作與處理, 並模擬各種基本財務運算, 亦介紹內建函數的使用與進階運算設計, 期望學生能使用Excel進行許多財務計算與統計分析. 另外,圖表製作,巨集製作和樞紐分析也是本課程的重要主題，學生必須有能力完整詮釋資料處理後的內涵與意義。 | Syllabus | The goal of the course is to enhance students the ability for processing, and analyzing numeric data for manay finanical applications. The implementation and handle financial computation and statistical analysis are important in this course. In addition, histgrams, charts and macros manipulation are also included. Using spreadsheets and macros to finish a semester project for financial analysis is required. |