NCHU Course Outline
Course Name (中) 資料處理(1104)
(Eng.) Data Processing
Offering Dept Department of Applied Economics
Course Type Required Credits 3 Teacher CHENG CHIA YI
Department Department of Applied Economics / Undergraduate Language Chinese Semester 2026-SPRING
Course Description 介紹各式資料處理之軟體,提供同學未來選擇適當、適合軟體之方向,並藉由實際軟體之操作,示範如何與經濟議題應用之結合。
Prerequisites
Relevance of Course Objectives and Core Learning Outcomes(%) Teaching and Assessment Methods for Course Objectives
Course Objectives Competency Indicators Ratio(%) Teaching Methods Assessment Methods
1.對於進行經濟分析前,如何選擇適當的工具進行資料蒐集、清洗、彙整。
2.分析過程中,利用與發揮各種工具之優勢。
3.如何選擇合適的工具呈現分析結果與展示。
2.Economics knowledge application ability
3.Understanding and analyzing cross-cutting issues of economic integration
4.Communication, coordination and team cooperation
5.Independent learning and creativity
50
10
20
20
topic Discussion / Production
Networking / Distance Education
Exercises
Discussion
Other
Lecturing
Written Presentation
Attendance
Oral Presentation
Internship
Assignment
Quiz
Course Content and Homework/Schedule/Tests Schedule
Week Course Content
Week 1 調整放假(2/27)
Week 2 課程說明、資處概論(3/6)
Week 3 資料處理軟體介紹(Excel)、實作與討論(3/13):資料分析函數I
Week 4 資料處理軟體介紹(Excel)、實作與討論(3/20):資料分析函數II
Week 5 資料處理軟體介紹(Excel)、實作與討論(3/27):資料驗證與查詢函數
Week 6 清明連假(4/3)
Week 7 上機小考(4/10)
Week 8 資料處理軟體介紹(Excel)、實作與討論(4/17):資料排序篩選與格式化
Week 9 資料處理軟體介紹(Excel)、實作與討論(4/24):樞紐分析與更新資料
Week 10 勞動節放假(5/1)
Week 11 資料處理軟體介紹(Excel)、實作與討論(5/8):動態儀表板建立I
Week 12 資料處理軟體介紹(Excel)、實作與討論(5/15):動態儀表板建立II
Week 13 資料處理軟體介紹(Excel)、實作與討論(5/22):參照函數、動態巨集應用
Week 14 資料處理軟體介紹(query功能應用/Geoda/Tableau)、實作與討論(5/29)
Week 15 期末報告I (6/5)
Week 16 期末報告II (6/12)
self-directed
learning
   03.Preparing presentations or reports related to industry and academia.
完善期末報告、調整視覺化動態故事地圖
Evaluation
1.出席20%
2.小考、期中考(作業)50%
3.討論與報告30%
Textbook & other References
參考書:
1.SQL Server 2019/2017資料庫設計與開發實務,ISBN:9789865024727。
2.The R Project for Statistical Computing(Online)。
3.The Stata Journal(Online)。
Teaching Aids & Teacher's Website
詳ilearning
Office Hours
Mail另約時間
Sustainable Development Goals, SDGs(Link URL)
include experience courses:N
Please respect the intellectual property rights and use the materials legally.Please respect gender equality.
Update Date, year/month/day:2026/01/07 14:48:40 Printed Date, year/month/day:2026 / 6 / 25
The second-hand book website:http://www.myub.com.tw/