Home
企業管理學系
course information of 109 - 2 | 1236 VBA Program Design and Application(VBA程式設計與應用實務)

1236 - VBA程式設計與應用實務 VBA Program Design and Application


教育目標 Course Target

Office 應用程式如 Excel 等都含有 Visual Basic for Applications (VBA),它是一種程式語言,能讓您具有擴充應用程式的能力。 VBA 以執行「巨集」的方式運作。而所謂的巨集就是使用 Visual Basic 語言撰寫之循序漸進的步驟流程。學習撰寫程式聽起來好像很難,但只要有耐心再配合一些範例 (像是本文中所提供之範例),許多使用者都會發現,即使只學會一點點 VBA 程式碼,都對他們的工作有莫大的助益,讓他們可以在 Office 內達成之前做不到的事。只要您學會一部分的 VBA,要學會其他的就簡單多了。所以之前的不可能的現在都變成可能了。 1. 課程設計的全方位內容,主題涵蓋完整,包括在電腦和行動裝置上執行的應用軟體、app、作業系統、公用程式,還有網際網路、全球資訊網與雲端運算的介紹。 2. Excel VBA 3. MS OFFICE課程設計的全方位內容 透過實作,學生能奠定紮實的電腦知識,更懂得 如何運用電腦和善用全球資訊網,了解科技趨勢發展並建立宏觀的想法。Office applications such as Excel include Visual Basic for Applications (VBA), a programming language that gives you the ability to extend your applications. VBA operates by executing "macros". The so-called macro is a step-by-step process written in Visual Basic language. Learning to write programs may sound difficult, but with patience and some examples (like the ones provided in this article), many users will find that learning even a little bit of VBA code has a huge impact on their work. With the help of Office, they can achieve things that they could not do before in Office. Once you learn one part of VBA, it's much easier to learn the rest. So what was impossible before is now possible. 1. The course is designed with all-round content and covers a complete range of topics, including application software, apps, operating systems, and utilities that run on computers and mobile devices, as well as an introduction to the Internet, global information networks, and cloud computing. 2. Excel VBA 3. Comprehensive content of MS OFFICE course design Through practical practice, students can lay solid computer knowledge and better understand How to use computers and make good use of global information networks to understand the development of technological trends and establish macro-ideas.


參考書目 Reference Books

1. 課堂時告知
2. 跟我學Excel VBA:將複雜的操作用一個按鍵就搞定!
作者:江高舉
出版社:碁峰
語言:繁體中文 ISBN:9789862760352
裝訂:平裝
1. Inform during class
2. Learn Excel VBA from me: Complete complex operations with just one button!
Author: Jiang Gaoju
Publisher: Qi Feng
Language: Traditional Chinese ISBN: 9789862760352
Binding: paperback


評分方式 Grading

評分項目 Grading Method 配分比例 Grading percentage 說明 Description
作業與專題作業與專題
Assignments and topics
40
期中考期中考
midterm exam
30
期末考與期末分組專題期末考與期末分組專題
Final exam and final group topics
30

授課大綱 Course Plan

Click here to open the course plan. Course Plan
交換生/外籍生選課登記 - 請點選下方按鈕加入登記清單,再等候任課教師審核。
Add this class to your wishlist by click the button below.
請先登入才能進行選課登記 Please login first


相似課程 Related Course

很抱歉,沒有符合條件的課程。 Sorry , no courses found.

Course Information

Description

學分 Credit:0-3
上課時間 Course Time:Monday/10,11,12[M025]
授課教師 Teacher:黃耀民
修課班級 Class:企管系1-4
選課備註 Memo:一年級學生優先選課。第一週務必到課,未到且請假者視同棄選。
授課大綱 Course Plan: Open

選課狀態 Attendance

There're now 29 person in the class.
目前選課人數為 29 人。

請先登入才能進行選課登記 Please login first