帳號:guest(44.192.54.67)          離開系統
字體大小: 字級放大   字級縮小   預設字形  

詳目顯示

以作者查詢圖書館館藏以作者&題名查詢臺灣博碩士以作者查詢全國書目
作者:胡育旋
作者(英文):Hu, Yu-Hsuan
論文名稱(中文):EduTalk: 結合物聯網之3D互動式程式設計教育平台
論文名稱(英文):EduTalk: A 3D Interactive Programming Education Platform with IoT
指導教授(中文):林一平
謝旻錚
指導教授(英文):Lin, Yi-Bing
Shieh, Min-Zheng
口試委員:林一平
謝旻錚
蔡文能
鄭昌杰
林勻蔚
口試委員(英文):Lin, Yi-Bing
Shieh, Min-Zheng
Tsai, Wen-Nung
Cheng, Chang-Chieh
Lin, Yun-Wei
學位類別:碩士
校院名稱:國立交通大學
系所名稱:資訊科學與工程研究所
學號:0756084
出版年(民國):109
畢業學年度:108
語文別:英文
論文頁數:54
中文關鍵詞:物聯網教育感測器3D動畫
外文關鍵詞:Internet of Things(IoT)EducationSensors3D Animation
相關次數:
  • 推薦推薦:0
  • 點閱點閱:81
  • 評分評分:*****
  • 下載下載:0
  • 收藏收藏:0
近年來,全球掀起程式設計的教育浪潮,台灣也在 108 年課綱將程式設計課程 納入國高中必修。然而,在開始寫程式的第一步,安裝所需的環境即需要花費大量時間。 本碩論提出一個網頁應用程式實作的程式設計教學平台--EduTalk,只要有電腦與瀏覽器, 無須安裝即可直接使用,不需要購買額外的硬體或是下載任何軟體。使用者可透過瀏覽 器操作 EduTalk 撰寫 VPython 程式產生 3D 動畫,且本平台會自動產生每個課程的專屬 QR Code,當使用者用手機掃描此 QR Code 後,系統會針對該課程自動建立手機及動畫 之間的連線,之後即可使用手機內建的感測器來控制動畫。上述功能是利用物聯網的觀 念來實踐,也就是將手機視為物聯網中的感測器,執行中的 3D 動畫視為執行器。有此 物聯網的特性,亦可把程式設計教學結合其他課程,例如:利用手機感測器進行物理實 驗後在動畫重現手機移動軌跡,並利用取得的感測器數據推導數學公式。
在此篇論文中,我們將描述系統如何管理課程、如何提供線上程式編輯服 務,以及如何管理物聯網裝置及連線。
In recent years, programming education becomes important worldwide, and programming course has been compulsory for high school students in Taiwan. However, it takes a lot of time to setup environment. We propose EduTalk, an out-of-the-box web-based education platform. Users may write VPython programs to render 3D animation in the browser without installing software or purchasing any hardware. The EduTalk system will automatically create a unique QR Code for each lecture, then user can scan the QR Code with their smartphone to control the 3D animation using smartphone sensors. The core idea of creating a connection between the user's smartphone and the animation is utilizing the IoT concept. A smartphone is considered as a collection of sensors, and the 3D animation program may be considered as a collection of actuators. With IoT features, programming education can also be combined with other fields. For example, user may use smartphone sensors as physics experiment tool. EduTalk is capable of replaying the smartphone movement in animation to help students derive the formula. In this thesis, we will show how we manage lectures, provide online editor, and manage IoT devices and connections.
摘 要 ........................................................................................................................................... i Abstract........................................................................................................................................... ii 誌 謝 ......................................................................................................................................... iii Contents......................................................................................................................................... iv List of Tables .................................................................................................................................. vi List of Figures ................................................................................................................................ vii
Introduction .............................................................................................................. 1 Related Work............................................................................................................ 1 EduTalk ..................................................................................................................... 2 EduTalk Architecture ................................................................................................ 4 The IoTtalk Architecture...........................................................................................4 The EduTalk Architecture ......................................................................................... 7 Graphical User Interface (GUI)................................................................................ 10 Lecture Development and Management ............................................................... 15 The Database System (DB)...................................................................................... 22 The User Related Tables ......................................................................................... 24
The Group Table...........................................................................................................24 The User Table ............................................................................................................. 26 The Lecture Related Tables .................................................................................... 27 The Lecture Table.........................................................................................................27
iv

The Template Table...................................................................................................... 29 The LectureProject Table ............................................................................................. 30 Records Initialization .............................................................................................. 31 EduTalk Event Handler............................................................................................ 34 User Management Procedures............................................................................... 36 Lecture Management Procedures .......................................................................... 37 create_lecture .............................................................................................................. 38 get_lecture_info ........................................................................................................... 40 get_user_lec_code ....................................................................................................... 42 bind_device .................................................................................................................. 42 get_remote_control_info............................................................................................. 44 Conclusion .............................................................................................................. 47 ...................................................................................................................................... 49 Appendix A. Management Procedures...................................................................................52
[1] Resnick, M., Maloney, J., Monroy-Hernández, A., Rusk, N., Eastmond, E., Brennan, K., Millner, A., Rosenbaum, E., Silver, J., Silverman, B., and Kafai, Y. “Scratch: Programming for all”, Comm. ACM, vol. 52, no. 11, pp. 60-67, Nov. 2009.
[2] GlowScript [Online]. Available: https://www.glowscript.org/
[3] JavaScript [Online]. Available: https://www.w3schools.com/js/js_intro.asp
[4] VPython [Online]. Available: https://www.vpython.org/
[5] T. H. Yen, “Design and Implementation IoTtalk based on Message Queuing Telemetry Transport Protocol”, NCTU, Master’s thesis, 2019
[6] C. M. Huang, Y. J. Hsieh, W. L. Lai, Y. J. Liu, C. Y. Juan, S. Y. Chen, C. Y. Chen, J. J. Chue, C. C. Yang, and C. M. Wu, “A Modular Wireless Sensor Platform and Its Applications”, pp. 1-4, IEEE International Symposium on Circuits & Systems (ISCAS), 2017
[7] H. E. Wang, “Design and Implementation of IoTtalk and Its Application”, NCTU, Master’s thesis, 2019.
[8] Y. B. Lin, Y. W. Lin, C. M. Huang, C. Y. Chih, P. Lin, “IoTtalk: A management platform for reconfigurable
sensor devices. IEEE Internet Things J,. 1552–1562, 2017, 4.
[9] Flask. (2020, Jun. 8). Flask (A Python Microframework). [Online]. Available: http://flask.pocoo.org/
[10] Wikipedia, the free encyclopedia. (2020, Jun. 8). Object-relational mapping. [Online]. Available:
https://en.wikipedia.org/wiki/Object-relational_mapping
[11] Flask-SQLAlchemy. (2020, Jun. 8). Flask-SQLAlchemy. [Online]. Available: https://flask- sqlalchemy.palletsprojects.com/en/2.x/
[12] SQLAlchemy. (2020, Jun. 8). SQLAlchemy. [Online]. Available: http://www.sqlalchemy.org/
[13] SQLAlchemy. (2020, Jun. 8). Engine Configuration. [Online]. Available:
https://docs.sqlalchemy.org/en/rel_1_2/core/engines.html
49

[14] SQLAlchemy. (2020, Jun. 8). Session Basics. [Online]. Available: https://docs.sqlalchemy.org/en/12/orm/session_basics.html#what-does-the-session-do
[15] Flask-SQLAlchemy. (2020, Jun. 8). Declaring Models. Available: https://flask- sqlalchemy.palletsprojects.com/en/2.x/models/
[16] Flask-SQLAlchemy. (2020, Jun. 8). API-Configuration. Available: https://flask- sqlalchemy.palletsprojects.com/en/2.x/api/#flask_sqlalchemy.SQLAlchemy
[17] Flask-SQLAlchemy. (2020, Jun. 16). Select, Insert, Delete. Available: Available: https://flask- sqlalchemy.palletsprojects.com/en/2.x/queries/
[18] SQLAlchemy. (2020, Jun. 16). Describing Databases with MetaData-Column. [Online]. Available: https://docs.sqlalchemy.org/en/13/core/metadata.html#column-table-metadata-api
[19] w3schools. (2020, Jun. 16). SQL Unique Constraint. [Online]. Available: https://www.w3schools.com/sql/sql_unique.asp
[20] Python. (2020, Jun. 16). Built-in Functions. [Online]. Available: https://docs.python.org/3/library/functions.html?highlight=property#property
[21] Jinja. (2020, Jun. 16). Jinja. [Online]. Available: https://jinja.palletsprojects.com/en/2.11.x/
[22] Python Software Foundation. (2020, Jun. 25). Python Decorators. [Online]. Available:
https://wiki.python.org/moin/PythonDecorators
[23] Flask. (2020. Jun. 21). Application Object. [Online]. Available: https://flask.palletsprojects.com/en/1.1.x/api/#application-object
[24] Flask. (2020. Jun. 21). Sessions. [Online]. Available: https://flask.palletsprojects.com/en/1.1.x/quickstart/#sessions
[25] Requests. (2020, Jun. 17). Requests: HTTP for Humans. [Online]. Available: https://requests.readthedocs.io/en/master/
[26] David Scherer, Bruce Sherwood. (2020. Mar. 30). VPython/GlowScript - Run Locally. [Online]. Available: https://github.com/vpython/glowscript
50
[27] Alexander Shalamov, Mikhail Pozdnyakov. (2018. Apr. 13). Sensors for The Web. [Online]. Available: https://developers.google.com/web/updates/2017/09/sensors-for-the-web
(此全文20250804後開放外部瀏覽)
電子全文
 
 
 
 
第一頁 上一頁 下一頁 最後一頁 top
* *