基本素養 Basic Literacy
■ 理論與實務並重
具備處理、分析與溝通企業會計資訊之實務能力
Practical Application
To ensure that the students develop a capability of processing, analyzing and conveying accounting information
□ 企業倫理與社會責任
維護專業道德、倫理及社會責任
Social Responsibility and Business Ethics
To encourage and help the students to develop social awareness and ethics in the accounting profession
□ 人文與法治涵養
培養人文素養與法治觀念
Humanities and Rule of Law
To help the students develop Humanities and understand the rule of Law
■ 創意學習
發展並運用新奇的、原則的或發明的學習方法
Creative Learning
Developing and using the novel, original or inventive learning methods
□ 國際觀
培養學生成為具有國際觀之會計專業人才
Global Awareness
To turn the students into accounting professionals with an international vision
□ 國際交流
鼓勵學生參與國際交換學生計畫
International Exposure
To encourage student to participate in international student-exchange programs.
核心能力 Competence
■ 專業知識能力
擁有理論和實務兼備的會計相關專業知識與態度
Professional Knowledge
To educate the students to possess professional knowledge and attitude in both accounting-related theories and practices
□ 領導溝通與合作
有效溝通及團隊合作的能力
Leadership, Communication and Cooperation
To help the students cultivate a capability of effectively communicating and cooperating with peers
□ 創新思考能力
提出創新性的會計及財務解決方案的能力
Development and Innovation Ability
To help the students to be able to tackle accounting and finance challenges in an innovative manner
■ 創造性地解決問題
辨識、分析及創造性地解決會計及財務問題的能力
Ability to solve problems innovatively
To train the students to grow ability to identify, analyze and solve accounting and finance problems in an innovative manner
□ 批判能力
培養學生成為具有批判性思維之會計專業人才
Critical Thinking
To train the students to be accounting professionals who are able to think critically
課程概述 Course Description
介紹如何運用足夠的Excel函數在試算表中解決各種繁複的財務問題。
介紹如何運用足夠的Excel函數在試算表中解決各種繁複的財務問題。
課程學習目標 Course Objectives
熟悉Excel的各種內建函數、分析工具應用Excel分析財務、會計、統計等領域問題應用TEJ下載上市櫃公司財報資訊和熟悉Oracle水晶球分析軟體
課程進度 Progress Description
| 進度說明 Progress Description |
1 | 課程大綱介紹、評分方式說明 |
2 | Excel 函數入門 |
3 | Excel 進階功能 |
4 | Excel 進階功能 |
5 | 財務報表分析 |
6 | 財務報表分析 |
7 | 整數型規劃求解 |
8 | 整數型規劃求解 |
9 | 期中考週 |
10 | 水晶球軟體入門 |
11 | 水晶球軟體入門 |
12 | 風險下資本預算 |
13 | 風險下資本預算 |
14 | 動態風險規劃求解-投資組合最適化資金配置 |
15 | 動態風險規劃求解-投資組合最適化資金配置 |
16 | Excel 統計分析 |
17 | Excel 統計分析 |
18 | 期末考週 |
以上每週進度教師可依上課情況做適度調整。The schedule may be subject to change.
有關課程其他調查 Other Surveys of Courses
1.本課程是否規劃業界教師參與教學或演講? 否
Is there any industry specialist invited in this course? How many times? No
2.本課程是否規劃含校外實習(並非參訪)? 否
Are there any internships involved in the course? How many hours? No
3.本課程是否可歸認為學術倫理課程? 否
Is this course recognized as an academic ethics course? In the course how many hours are regarding academic ethics topics? No
4.本課程是否屬進入社區實踐課程? 否
Is this course recognized as a Community engagement and Service learning course? Which community will be engaged? No
教師上傳大綱內容
本資訊僅提供本校師生參考。有著作權,非本校人員若欲使用本資訊,請洽本校取得授權。
© (2008-2023) National Cheng Kung University ALL RIGHTS RESERVED.
商業應用軟體_課程大綱_Autumn 2020.pdf