本課程介紹Excel VBA的操作以及程式語法，由資料型別、函數以及樞紐分析的使用，並透過期未專題制作，提昇學生解決問題能力、實務應用能力、團隊合作能力以及知識整合能力，達到學以致用的目標。This course introduces the operation and syntax of Excel VBA. It uses data types, functions and character analysis, and improves students' problem solving ability, practical application ability, team cooperation ability and knowledge integration ability through period unspecified production, achieving academic achievement The goal of applying it.
Introduce the basic concept of computing systems. Topics include computer hardware, system software, application software and computer network
introduce the BASIC concept of computer systems. topics include computer hardware, system software, application software and computer network
1. Excel 2016 高效實用範例必修16課，文淵閣工作室，碁峰資訊股份有限公司。ISBN:9789864762583
2. 跟我學Excel VBA：從入門變高手，江高舉，碁峰資訊股份有限公司。ISBN：9789864760398
3. Excel VBA：基礎必修課（適用Excel 2010/2013/2016），張志成、吳明哲。碁峰資訊股份有限公司。ISBN：9789864763948
4. 超簡單的Excel巨集&VBA，門脇香奈子，許郁文譯，旗標出版。ISBN: 9789863124177
5. Excel 2010嚴選教材，楊世瑩，碁峰資訊股份有限公司。ISBN: 9789862761434
6. 會計人的Excel VBA小教室，贊贊小屋，碁峰資訊股份有限公司。ISBN: 9789864764150
1. Excel 2016 Efficient Practical Examples Compulsory Courses, Wenjing Studio, Qifeng Information Co., Ltd. ISBN:9789864762583
2. Learn Excel VBA from us: Become a master from entering the door, Jiang Gao, and Qifeng Information Co., Ltd. ISBN: 9789864760398
3. Excel VBA: Basic compulsory courses (Applicable to Excel 2010/2013/2016), Zhang Zhicheng and Wu Mingzhe. Greyfeng Information Co., Ltd. ISBN: 9789864763948
4. Super simple Excel collection & VBA, Tanzanko, Xuyu Wenxuan, Flagmark publishing. ISBN: 9789863124177
5. Excel 2010 Serious Selected Textbooks, Yang Shiying, and Qiufeng Information Co., Ltd. ISBN: 9789862761434
6. Excel VBA classroom, Huanhuang Hut, and Huanfeng Information Co., Ltd. ISBN: 9789864764150
| 評分項目 Grading Method | 配分比例 Grading percentage | 說明 Description |
|---|---|---|
| 實作實作 Implement |
20 | |
| 期中考期中考 Midterm exam |
25 | |
| 期末專題報告期末專題報告 Final issue report |
25 | |
| 平時成績(含出席及參與)平時成績(含出席及參與) Regular results (including attendance and participation) |
30 | 無故缺席一次扣20分 |
