{"id":1509,"date":"2026-06-14T03:18:33","date_gmt":"2026-06-13T19:18:33","guid":{"rendered":"https:\/\/aifed.now\/conference\/?page_id=1509"},"modified":"2026-06-14T03:18:33","modified_gmt":"2026-06-13T19:18:33","slug":"%e4%b8%bb%e9%a1%8c%e4%ba%8c%ef%bc%9a%e6%95%99%e5%ad%b8%e5%af%a6%e8%b8%90-%e6%9e%97%e5%a8%81%e5%bb%b6-ai%e9%a0%98%e8%88%aa%e7%87%9f%e5%bb%ba%e6%95%b8%e4%bd%8d%e8%bd%89%e5%9e%8b%ef%bc%9a%e4%bb%a5cha","status":"publish","type":"page","link":"https:\/\/aifed.now\/conference\/?page_id=1509","title":{"rendered":"\u4e3b\u984c\u4e8c\uff1a\u6559\u5b78\u5be6\u8e10 \/ \u6797\u5a01\u5ef6 \/ AI\u9818\u822a\u71df\u5efa\u6578\u4f4d\u8f49\u578b\uff1a\u4ee5ChatGPT\u8f14\u52a9Excel VBA \u5de5\u5730\u7167\u7247\u7ba1\u7406\u7cfb\u7d71\u958b\u767c\u5be6\u52d9"},"content":{"rendered":"<\/p>\n<h3>AI\u9818\u822a\u71df\u5efa\u6578\u4f4d\u8f49\u578b\uff1a\u4ee5ChatGPT\u8f14\u52a9Excel VBA \u5de5\u5730\u7167\u7247\u7ba1\u7406\u7cfb\u7d71\u958b\u767c\u5be6\u52d9<\/h3>\n<\/p>\n<div style=\"display: flex; align-items: center; gap: 15px;\">\n<p>  <img decoding=\"async\" width=\"200\" src=\"https:\/\/aifed.now\/conference\/wp-content\/uploads\/wpxform-uploads\/177950992595c27d0de7-18-Will-2020.jpg\" alt=\"\u6797\u5a01\u5ef6\" style=\"box-shadow: 4px 4px 10px 0px rgba(0, 0, 0, 0.2)\" \/><\/p>\n<p>  <strong>\u8b1b\u8005\/Speaker\uff1a<\/strong> <span style=\"font-weight:bold; line-height:1.5em; background-color:#e7f49c; padding:0px 2px; border:1px; border-radius:10px;\"> \u6797\u5a01\u5ef6, Will Y. Lin <\/span>  <\/p>\n<\/div>\n<p><\/p>\n<div style=\"line-height:1.2em; background-color: #ffffff; margin: 5px; border:1px #19130B solid; border-radius:10px; padding:10px; box-shadow: 4px 4px 10px 0px rgba(0, 0, 0, 0.2)\">\n<p>\u672c\u7814\u7a76\u63a2\u8a0e\u5982\u4f55\u5229\u7528\u5927\u578b\u8a9e\u8a00\u6a21\u578b\uff08LLM\uff09\u89e3\u6c7a\u975e\u8cc7\u8a0a\u80cc\u666f\u5b78\u751f\u5b78\u7fd2\u7a0b\u5f0f\u958b\u767c\u7684\u75db\u9ede \u3002\u71df\u5efa\u73fe\u5730\u5de5\u7a0b\u5e2b\u5e38\u9762\u81e8\u6975\u5176\u7e41\u7463\u7684\u8868\u5831\u7ba1\u7406\u5de5\u4f5c\uff0cVBA \u96d6\u70ba\u81ea\u88fd\u81ea\u52d5\u5316\u7a0b\u5f0f\u7684\u4e00\u5927\u5229\u5668\uff0c\u4f46\u50b3\u7d71\u6559\u5b78\u56e0\u8a9e\u6cd5\u8271\u6f80\u3001\u908f\u8f2f\u8907\u96dc\uff0c\u5e38\u4f7f\u571f\u6728\u7cfb\u5b78\u751f\u7522\u751f\u632b\u6298\u611f \u3002\u672c\u8ab2\u7a0b\u5c0e\u5165 LLM Coding \u5de5\u5177\uff0c\u4f7f\u7528\u300c\u622a\u5716\u8f14\u52a9\u6307\u4ee4\u6cd5\u300d\u8207\u300c\u6f38\u9032\u5f0f\u5c0d\u8a71\u4fee\u6b63\u300d\u6559\u5b78\u3002\u8ab2\u5802\u4ee5\u300c\u5de5\u5730\u7167\u7247\u7ba1\u7406\u7cfb\u7d71\u300d\u70ba\u7bc4\u4f8b\uff0c\u6559\u5b78\u793a\u7bc4\u5982\u4f55\u5c07\u539f\u59cb\u78bc\u622a\u5716\u8207\u5177\u9ad4\u9700\u6c42\u7d44\u5408\u6210 AI \u6307\u4ee4\uff08Prompt\uff09\uff0c\u5f15\u5c0e AI \u8655\u7406\u7a0b\u5f0f\u78bc\u751f\u6210 \uff1b\u540c\u6642\u523b\u610f\u5c55\u793a AI \u7684\u932f\u8aa4\uff08\u5982\u76f4\u5f0f\u7167\u7247\u7e2e\u653e\u4e0d\u7576\uff09\uff0c\u793a\u7bc4\u5982\u4f55\u900f\u904e\u8fed\u4ee3\u5c0d\u8a71\u9032\u884c\u4fee\u6b63\u3002\u7d50\u679c\u986f\u793a\uff0c\u5728\u7d04 40 \u4f4d\u4fee\u8ab2\u5b78\u751f\u4e2d\uff0c\u9ad8\u9054 80% \u7684\u5b78\u751f\u80fd\u7368\u7acb\u900f\u904e AI \u8f14\u52a9\uff0c\u6210\u529f\u958b\u767c\u51fa\u5177\u5099\u81ea\u52d5\u7f6e\u4e2d\u8207\u7e2e\u653e\u529f\u80fd\u7684 VBA \u7a0b\u5f0f\u3002\u6b64\u6a21\u5f0f\u6709\u6548\u964d\u4f4e\u4e86\u7de8\u7a0b\u9580\u6abb\uff0c\u986f\u8457\u63d0\u5347\u5b78\u751f\u7684\u5b78\u7fd2\u4fe1\u5fc3\uff0c\u4f7f\u5176\u80fd\u5c07\u5c08\u6ce8\u529b\u7531\u300c\u6b7b\u80cc\u8a9e\u6cd5\u300d\u8f49\u79fb\u56de\u300c\u61c9\u7528\u6280\u8853\u89e3\u6c7a\u5de5\u7a0b\u554f\u984c\u300d\u7684\u521d\u8877\uff0c\u91cd\u5851\u6578\u4f4d\u5de5\u5177\u958b\u767c\u4e4b\u81ea\u4fe1\u3002<\/p>\n<p>\u00a0<\/p>\n<hr\/>\n<p>This study explores how Large Language Models (LLMs) can alleviate programming learning pains for non-computer science students. While VBA is a powerful tool for civil engineers to automate tedious construction site paperwork, traditional teaching methods often lead to frustration due to complex syntax and coding logic. This course innovatively implements LLM Coding tools through two newly designed methods: \"Visual Prompting\" (utilizing source code screenshots alongside textual instructions) and \"Iterative Correction\". Using a \"Construction Site Photo Management System\" as a case study, the instructor demonstrates how to combine code screenshots with functional requirements into precise AI prompts. Furthermore, the instructor intentionally displays AI imperfections (e.g., improper scaling of vertical photos) to teach students how to refine code through ongoing dialogue. The results show that 80% of the approximately 40 enrolled students successfully and independently developed a functional VBA program with automatic photo alignment and scaling features. This approach effectively lowers the entry barrier, boosts learning confidence, and allows students to focus on solving engineering problems rather than memorizing syntax, thereby reshaping their digital development efficacy.<\/p>\n<p>\u00a0<\/p>\n<\/div>\n<p>\u00a0<\/p>\n<div style=\"background-color: #ffffff; margin: 5px; border:1px #19130B solid; border-radius:10px; padding:10px; box-shadow: 4px 4px 10px 0px rgba(0, 0, 0, 0.2)\">\n<ul>\n<li style=\"padding:10px 5px; line-height:1.5em;\"><strong>\u8ad6\u6587\u5168\u6587\uff1a<\/strong><span style=\"font-weight:bold; line-height:1.5em; background-color:#e7f49c; padding:0px 2px; border:1px; border-radius:10px;\"><a href=\"https:\/\/aifed.now\/conference\/wp-content\/uploads\/wpxform-uploads\/177950992595c27d0de7-16-2026-\u53f0\u7063-AI-\u6559\u80b2\u5e74\u6703\u6559\u5b78\u61c9\u7528\u6295\u7a3f\u6587\u4ef6.pdf\" target=\"_blank\">AI\u9818\u822a\u71df\u5efa\u6578\u4f4d\u8f49\u578b\uff1a\u4ee5ChatGPT\u8f14\u52a9Excel VBA \u5de5\u5730\u7167\u7247\u7ba1\u7406\u7cfb\u7d71\u958b\u767c\u5be6\u52d9<\/a><\/span><\/li>\n<li style=\"padding:10px 5px; line-height:1.5em;\"><strong>\u5f71\u50cf\uff1a<\/strong><span style=\"font-weight:bold; line-height:1.5em; background-color:#e7f49c; padding:0px 2px; border:1px; border-radius:10px;\"> <a href=\"https:\/\/www.youtube.com\/watch?v=5IclrfOB86M\" target=\"_blank\">\u76f8\u95dc\u5f71\u7247<\/a><\/span><\/li>\n<\/ul>\n<\/div>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>AI\u9818\u822a\u71df\u5efa\u6578\u4f4d\u8f49\u578b\uff1a\u4ee5ChatGPT\u8f14\u52a9Excel VBA \u5de5\u5730\u7167\u7247\u7ba1\u7406\u7cfb\u7d71\u958b\u767c\u5be6\u52d9 \u8b1b\u8005\/Speaker\uff1a &hellip; <\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1509","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/aifed.now\/conference\/index.php?rest_route=\/wp\/v2\/pages\/1509","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aifed.now\/conference\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/aifed.now\/conference\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/aifed.now\/conference\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aifed.now\/conference\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1509"}],"version-history":[{"count":7,"href":"https:\/\/aifed.now\/conference\/index.php?rest_route=\/wp\/v2\/pages\/1509\/revisions"}],"predecessor-version":[{"id":1919,"href":"https:\/\/aifed.now\/conference\/index.php?rest_route=\/wp\/v2\/pages\/1509\/revisions\/1919"}],"wp:attachment":[{"href":"https:\/\/aifed.now\/conference\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}