|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/90-excel-vba/
课程评论：没有评论
Course Title: 90 分鐘學會 - 遊戲程式設計：系統規劃與 Excel VBA This Coursera course, "90 分鐘學會 - 遊戲程式設計：系統規劃與 Excel VBA," offers a practical introduction to programming concepts through the engaging medium of game development using Excel VBA. Recognizing that programming is increasingly integrated into education globally, this course aims to equip learners with fundamental coding logic that is applicable across various industries and forms the bedrock of advanced fields like machine learning and artificial intelligence. The core of the course revolves around a hands-on project: building a "Horse Racing Game" within the Excel environment. Starting from the third video, learners will be guided step-by-step, using provided course files and video instructions, to construct the complete game framework. Key programming concepts taught include: * **Conditional Logic (If statements):** For decision-making within the game. * **Definite Loops (For loops):** For executing actions a set number of times. * **Indefinite Loops (Do While loops):** For executing actions until a specific condition is met. These fundamental concepts are presented through a "learning by doing" approach, making the learning process intuitive and effective. The course features 10 video modules, with the main game programming starting from video 03. The syllabus includes: * Video 01: Horse Racing Simulation and Course Introduction * Video 02: Course Files and Tips for Program Debugging * Video 03: Horse Track Setup and Horse Loading (Simultaneous Racing) * Video 04: Horse Movement: Instantaneous * Video 05: Horse Movement: Slow Pace * Video 06: Horse Movement: Normal Gallop * Video 07: Horse Track Finish Line Setup (Standard Distance Racing) * Video 08: Horse Racing Betting System Design * Video 09: Determining Race Results (Win/Loss Judgment) * Video 10: Sound Effects Implementation The course specifically leverages **Excel VBA** for the following reasons: 1. **Accessibility:** Excel is readily available on most computers, making VBA accessible without additional software purchases or installations, thus posing no security risks. 2. **Power and Ubiquity:** Combining Excel's robust spreadsheet capabilities with VBA programming significantly enhances workplace productivity. Excel is widely used for data processing, and VBA integration makes sharing and collaboration seamless. 3. **Immediate Feedback:** VBA's interpreted nature allows for "what you see is what you get" development, with the satisfaction of instant results through button-driven actions. 4. **Structured Logic:** Learning programming through VBA's clear structure and logic builds a strong foundation that facilitates the learning of other programming languages in the future. Ultimately, this course aims to empower individuals, and their children, with programming skills that are essential for success in the rapidly evolving technological landscape, enabling them to thrive in any profession.
思考：許多世界先進國家，例如：英國、日本等，皆已將程式設計納入小學生必修的課程，為什麼？90分鐘能做什麼？ 看一場電影、吃一頓大餐、玩一場傳說對決、學一套遊戲程式邏輯。您會選哪一個？您又會讓您小孩選哪一個？最佳的程式設計與編程入門課程!!在未來的訊息技術爆發的世界裡，若您或您的小孩，能瞭解程式設計的運作與邏輯，那麼相信不僅可以在各行各業立於不敗之地，更能發光發熱。短短的 90 分鐘裡（課程中第3個影片起），經由 Excel 環境，透過「賽馬遊戲」，利用課程附檔及視屏，手把手建置完整的遊戲架構，完整學習編程核心「三大觀念」，包括：1.判斷與決策（If 語法），2.確定次數迴圈（For 語法），3.不確定次數迴圈（Do While 語法），這些觀念是編程的基礎，也是您未來解決實務問題的利器，這些觀念也是晚近相當熱門的「機器學習及人工智能」之基石。透過「做中學 (learning by doing) 」的方式，讓您自然而然成為程式設計高手，並活用於生活與職場。本課程共有10個影片，其中主要的「賽馬遊戲」程式設計是由第 03 個影片開始。01 賽馬演練與課程簡介02 課程檔案與程式除錯小技巧03 賽馬場設定與馬匹載入：同樣時間賽馬04 馬匹向前：瞬間移動05 馬匹向前：緩慢移動06 馬匹向前：正常奔馳07 賽馬場終點線設定：同樣距離賽馬08 賽馬籌碼設計與下注09 賽馬結果：勝負判斷10 音效設定：達達的馬蹄聲Why Excel VBA ?1. 容易取得，每一台電腦/計算機都有 Excel：贈送 VBA，隨處可用，無須購買或下載或安裝，無資安問題。2. Excel 試算表功能強大、職場廣泛應用 + VBA 編程：如虎添翼 - Excel 是職場上最受歡迎的資料處理軟件，分享好友、同事隨開隨用。3. VBA 直譯式語言 (Interpreted language)：所見即所得 - 透過按鈕設計，享受迅雷不及掩耳，一鍵完成的愉悅。4. VBA 程式架構完整，邏輯清楚 - 經由 VBA 邏輯訓練，日後其他程式語言，得心應手。
