課程名稱 |
視覺化與現代資料科學 Data Visualization with Modern Data Science |
開課學期 |
110-2 |
授課對象 |
管理學院 工商管理學系 |
授課教師 |
郭耀仁 |
課號 |
BA4009 |
課程識別碼 |
701 41110 |
班次 |
|
學分 |
3.0 |
全/半年 |
半年 |
必/選修 |
選修 |
上課時間 |
星期四7,8,9(14:20~17:20) |
上課地點 |
管二203 |
備註 |
本課程中文授課,使用英文教科書。 限學士班三年級以上 總人數上限:30人 |
|
|
課程簡介影片 |
|
核心能力關聯 |
核心能力與課程規劃關聯圖 |
課程大綱
|
為確保您我的權利,請尊重智慧財產權及不得非法影印
|
課程概述 |
本課程加簽方式為「第 2 類不設定修課人數上限,學生須向教師取得授權碼後,始可上網加選。」
1. 請填寫 Google 表單 https://forms.gle/xTEqgXYycHqup7Jy9 告知學校信箱、姓名以及系級。
2. Google 表單會於 2022-02-20 23:59:59 截止,請有意願加簽的同學注意期限。
3. 加簽授權碼會在 2022-02-22 23:59:59 以前透過 NTU COOL 發送。
4. 課程「不發送紙本授權碼」,無論同學第一堂課是否出席,有加簽意願都請填寫 Google 表單 。
5. 有旁聽意願的同學也請填寫 Google 表單,並在第四個問題註記「是」旁聽。
Due to the use of online lecture and assessment, this course accepts all additional registrations. However, for those who have registered "Programming and Data Analysis" at NTU or "Business Analysis and Programming" at NTNU before, kindly note that the Python part of this course is a lot easier, so there is a risk of wasting time.
由於採用了課程錄影與線上批改測試,這堂課程可以接受所有想加簽的同學,但是對於有修過台大「商管程式設計」、「程式設計與資料分析」或者師大「商業分析程式語言」的同學,請特別注意這堂課的 Python 太過簡單,可能會有浪費時間的風險。
We will start with visualization via Tableau, a widely-used business intelligence software with graphic user interface. Next, we will introduce SQL, short for Structured Query Language, the standard language used to interact with relational databases. Finally, we will introduce Python, a general-purposed programming language that gains extraordinary attentions in data science. |
課程目標 |
- To create common visualizations with Tableau.
- To write intermediate queries in SQL.
- To define functions and classes in Python.
- To wrangle data with Python pandas. |
課程要求 |
- Assignment 1
- Assignment 2
- Assignment 3
- Midterm
- Assignment 4
- Assignment 5
- Assignment 6
- Final |
預期每週課後學習時數 |
|
Office Hours |
每週一 21:00~22:00 |
指定閱讀 |
- Anthony DeBarros, Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data
- Bill Lubanovic, Introducing Python: Modern Computing in Simple Packages 2nd Edition
- Jake VanderPlas, Python Data Science Handbook: Essential Tools for Working with Data 1st Edition |
參考書目 |
- Anthony DeBarros, Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data
- Bill Lubanovic, Introducing Python: Modern Computing in Simple Packages 2nd Edition
- Jake VanderPlas, Python Data Science Handbook: Essential Tools for Working with Data 1st Edition |
評量方式 (僅供參考) |
No. |
項目 |
百分比 |
說明 |
1. |
Assignment 1 |
10% |
|
2. |
Assignment 2 |
10% |
|
3. |
Assignment 3 |
10% |
|
4. |
Midterm |
20% |
|
5. |
Assignment 4 |
10% |
|
6. |
Assignment 5 |
10% |
|
7. |
Assignment 6 |
10% |
|
8. |
Final |
20% |
|
|
週次 |
日期 |
單元主題 |
第1週 |
2022-02-17 |
Introduction |
第2週 |
2022-02-24 |
Getting started with Tableau |
第3週 |
2022-03-03 |
Creating dashboards with Tableau |
第4週 |
2022-03-10 |
Getting started with SQL |
第5週 |
2022-03-17 |
Querying data with SQL |
第6週 |
2022-03-24 |
Data manipulation and definition with SQL |
第7週 |
2022-03-31 |
Reading period |
第8週 |
2022-04-07 |
Midterm |
第9週 |
2022-04-15 |
Getting started with Python |
第10週 |
2022-04-22 |
Functions and classes in Python |
第11週 |
2022-04-29 |
Modules and tips in Python |
第12週 |
2022-05-05 |
Getting started with Pandas |
第13週 |
2022-05-12 |
Data wrangling with Pandas |
第14週 |
2022-05-17 |
Project: data wrangling with Pandas and sqlite3 |
第15週 |
2022-05-26 |
Reading period |
第16週 |
2022-06-02 |
Final |
|