| 當期課號 |
1288 |
Course Number |
1288 |
| 授課教師 |
武季蔚 |
Instructor |
WU,CHEI WEI |
| 中文課名 |
財務資訊系統 |
Course Name |
Financial Information Systems |
| 開課單位 |
會計系(四日)一B |
Department |
|
| 修習別 |
必修 |
Required/Elective |
Required |
| 學分數 |
3 |
Credits |
3 |
| 課程目標 |
本課程的教學目標在於使學生瞭解財務分析及財務資訊流的概念，課程中將使學生能利用軟體模組或套裝軟體來記錄、彙整、分析、及輸出財務與非財務的資訊。 |
Objectives |
This course introduces the concepts underlying financial analysis and management of information flows. Recording, aggregating, analysis and reporting of financial and non-financial information are studied using software models and packages such as Excel. |
| 教材 |
教課書：
Excel 2007寶典，楊豔、劉啟業、胡娟等譯，人民郵電出版社 (John Walkenbach (2007) Excel 2007 Bible, Wiley Publishing Inc.)
碁峰 EXCEL 2007實力養成暨評量 (解答秘笈)
參考書籍：
陳偉忠、林宏諭 (2007) Excel 2007完全學習與實務應用大全，博碩
碁峰 財務會計幫幫忙
碁峰 Excel會計財管實戰應用
碁峰 Excel VBA應用 2007
全華 Excel會計資訊系統實務大全 |
Teaching Materials |
Textbooks:
John Walkenbach (2007) Excel 2007 Bible, Wiley Publishing Inc.
碁峰 EXCEL 2007實力養成暨評量 (解答秘笈)
References:
陳偉忠、林宏諭 (2007) Excel 2007完全學習與實務應用大全，博碩
碁峰 財務會計幫幫忙
碁峰 Excel會計財管實戰應用
碁峰 Excel VBA應用 2007
全華 Excel會計資訊系統實務大全 |
| 成績評量方式 |
基本需求： TQC 進階 (60%), TQC 專業 (80%) 擇一
整合應用： 會計與財務系統應用 (20%)
TQC兩者皆考的同學，學期成績選擇較高的分數組合 |
Grading |
Basic requirement: TQC Advance Exam (45%)
TQC Expert Exam (45%)
Integration Application: Financial and Accounting System Applications |
| 教師網頁 |
|
| 教學內容 |
1.Excel概要及Excel 2007新增及改善
2.Excel基礎及TQC第一類別練習
3.Excel公式與函數及TQC第二類別練習
4.樞紐分析及TQC第三類別練習
5.Excel資料匯入及匯出及TQC第四類別練習
6.Excel圖表及TQC第五類別練習
7.TQC進階級測驗
8.Excel VBA及TQC學科
9.Excel於財務應用
10.TQC專業級測驗
11.Excel於會計應用
12.系統整合應用 |
Syllabus |
1.Excel Review and Excel 2007 new features
2.Excel Basics and TQC Class 1 Exercises
3.Excel Formula with functions and TQC Class 2 Exercises
4.Pivot Tables and TQC Class 3 Exercises
5.Excel Input and Output and TQC Class 4 Exercises
6.Excel Charts and Graphics and TQC Class 5 Exercises
7.TQC Advance Exam
8.Excel VBA and TQC Discipline
9.Financial applications with Excel VBA
10.TQC Expert Exam
11.Accounting applications with Excel VBA
12.Accounting and Financial Systems Integration |