SCGI 136 Technology in Daily Life
1
Computer System, Hardware and Software
2
Data Visualization: Google Data Studio
2.1
Data Visualization
2.2
Google Data Studio
2.2.1
What is Google Data Studio?
2.2.2
Why Use Google Data Studio?
2.2.3
Working Principles of Google Data Studio
2.2.4
Google Data Studio Interface
2.3
Workshop: Thailand Provincial Dashboard
2.3.1
Data Preparation
2.3.2
Overview of the Dashboard
2.3.3
Creating the Dashboard: Your Turn
Homework
3
Accessing Research Database and Referencing
3.1
What is a Research Database?
3.2
Why Use Research Database?
3.3
What Can You Find in Mahidol Library Databases?
3.4
How Can You Access the Mahidol Library Databases?
3.5
Accessing the Stang Library Website
3.5.1
Searching for Book
3.5.2
Searching for Theses
3.5.3
Searching for Databases
3.5.4
How to Search Effectively
3.5.5
Essential Databases for Mathematics Students
3.6
Plagiarism & Citation
3.6.1
Plagiarism
3.6.2
Why Citation Matters
3.6.3
Citation Style
3.6.4
Citation Tools
3.7
Workshop: Install and Using Zotero
Homework
4
SQL I
4.1
What is a Database?
4.2
What is SQL?
4.3
Relational Databases
4.4
DB Browser for SQLite
4.5
Getting Started
4.5.1
Creating First Database
4.5.2
Creating First Table
4.5.3
Inserting Data
4.6
SQL Commands
4.6.1
CREATE
4.6.2
INSERT INTO
4.6.3
UPDATE
4.6.4
DELETE
Homework
5
SQL II
5.1
SELECT
5.1.1
Basic Select
5.1.2
Select with Constraint (
WHERE
)
5.1.3
Select with Ordering (
ORDER BY
)
5.1.4
Select with Limiting (
LIMIT
)
5.1.5
Data Aggregation and Summary (
GROUP BY
)
5.2
Join Tables
5.2.1
Inner Join
5.2.2
Left Join
5.2.3
Right Join
5.2.4
Full Join
5.2.5
Cross Join
Homework
Fall 2025
SCGI 136 Technology in Daily Life
SCGI 136 Technology in Daily Life
Dr. Minh Bui
Chapter 1
Computer System, Hardware and Software