Beyond Classroom Education Project
PRAPAT PONGKIATKUL
Embedded Files
CHAPTER 1
CHAPTER 1
Basic of EXCEL
Basic of EXCEL
Learning Objectives
At the end of lesson, the students will be able to use basic tasks and simple Excel formulas
Data 1: Coffee Shop
Data 2: PM2.5
LECTURE: CHAPTER 1-Basic of EXCEL
LECTURE: CHAPTER 1-Basic of EXCEL
TH Version
TH Version
ENG Version
ENG Version
CHAPTER 2
CHAPTER 2
FORMULA FUNCTION and REPORT
FORMULA FUNCTION and REPORT
Learning Objectives
At the end of lesson, the students will be able to use basic functions and create a report
Data 1: Water Quality
Data 2: Earthquake
LECTURE: CHAPTER 2-FORMULA FUNCTION and REPORT
LECTURE: CHAPTER 2-FORMULA FUNCTION and REPORT
TH Version
TH Version
ENG Version
ENG Version
PIVOT TABLE Workshop
PIVOT TABLE Workshop
TH Version
TH Version
ENG Version
ENG Version
CHAPTER 3
CHAPTER 3
GLOBAL INFORMATION SYSTEM
GLOBAL INFORMATION SYSTEM
Learning Objectives
At the end of lesson, the students will be able to understand GIS and to use the geographical coordinate converter
Geographical Coordinate Converter (EXCEL)
LECTURE: CHAPTER 3-GLOBAL INFORMATION SYSTEM
LECTURE: CHAPTER 3-GLOBAL INFORMATION SYSTEM
TH Version
TH Version
ENG Version
ENG Version
GIS Workshop
GIS Workshop
Question [TH]
Question [TH]
Question [ENG]
Question [ENG]
Solution [TH]
Solution [TH]
Solution [ENG]
Solution [ENG]
Gold mining game
Gold mining game
TH Version
TH Version
ENG Version
ENG Version
TH Version
TH Version
ENG Version
ENG Version
ASSIGNMENT
ASSIGNMENT
ข้อมูลการปริมาณขยะมูลฝอย (MSW) รายวัน ที่เกิดขึ้นของจังหวัด A ระหว่างวันที่ 1 มกราคม 2544 – 31 ธันวาคม 2562 (1 January 2001 – 31 December 2019) (จำนวนทั้งหมด 6,939 ข้อมูล) ได้มีการบันทึกไว้ใน File Excel “Assignment dataset001.xlsx”
Amount of daily municipal solid wastes (MSW) generated in the A province between 1 January 2001 – 31 December 2019 (Totally 6,939 data points) have been recorded in Excel files named “Assignment dataset001.xlsx”.
DATA DOWNLOAD
จากข้อมูลดังกล่าวจงตอบคำถามลงใน file word
TH Version
TH Version
ENG Version
ENG Version
Drainage system design
Drainage system design
Learning Objectives
At the end of lesson, the students will be able to apply advance formula functions in Excel for drainage system design
LECTURE: CHAPTER 5-DRAINAGE SYSTEM DESIGN
LECTURE: CHAPTER 5-DRAINAGE SYSTEM DESIGN
TH Version
TH Version
ENG Version
ENG Version
Page updated
Report abuse