基本素養 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課程大綱介紹、評分方式說明
    2Excel 函數入門
    3Excel 進階功能
    4Excel 進階功能
    5財務報表分析
    6財務報表分析
    7整數型規劃求解
    8整數型規劃求解
    9期中考週
    10水晶球軟體入門
    11水晶球軟體入門
    12風險下資本預算
    13風險下資本預算
    14動態風險規劃求解-投資組合最適化資金配置
    15動態風險規劃求解-投資組合最適化資金配置
    16Excel 統計分析
    17Excel 統計分析
    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