1. Course number and name

010913555-65 การประยุกต์โปรแกรมไมโครซอฟท์ออฟฟิศในงานวิศวกรรมอุตสาหการ (Application Microsoft Office in Industrial Engineering)

2. Credits and contact hours

3(3-0-6)

3. Instructor’s or course coordinator’s name

Assoc.Prof. Dr.Teeradej Wuttipornpun

4. Text book, title, author, and year

1. Teaching materials by Lecturer, 2568
2. Microsoft Office 365 and Power BI available from KMUTNB

5. Specific course information

1. brief description of the content of the course (catalog description)
   Fundamental of data; Data cleaning by fundamental tools and functions; Data relations and transformations by Query; Data visualization by tables and graphs with Business Intelligent (BI) tools; Data with Artificial Intelligent (AI)
2. prerequisites or co-requisites
3. indicate whether a required, elective, or selected elective (as per Table 5-1) course in the program
   Elective :

6. Specific goals for the course

1. specific outcomes of instruction (e.g. The student will be able to explain the significance of current research about a particular topic.)
   1. CLO1 Able to understand the fundamentals of data
   2. CLO2 Able to understand why data cleansing is very important
   3. CLO3 Able to apply data cleansing tools
   4. CLO4 Able to understand the relation of data
   5. CLO5 Able to apply query tools to transform and clean data
   6. CLO6 Able to apply table and graph tools to visualize data
   7. CLO7 Able to apply Business Intelligent tools to visualize data
2. explicitly indicate which of the student outcomes listed in Criterion 3 or any other outcomes are addressed by the course.

   ABET Student Outcome (SO) Listed in Criterion 3	Course learning outcome (CLO)
   SO1 an ability to identify, formulate, and solve complex engineering problems by applying principles of engineering, science, and mathematics.	CLO1 Able to understand the fundamentals of data CLO2 Able to understand why data cleansing is very important CLO4 Able to understand the relation of data
   SO2 an ability to apply engineering design to produce solutions that meet specified needs with consideration of public health, safety, and welfare, as well as global, cultural, social, environmental, and economic factors.	CLO3 Able to apply data cleansing tools CLO5 Able to apply query tools to transform and clean data CLO6 Able to apply table and graph tools to visualize data CLO7 Able to apply Business Intelligent tools to visualize data

7. Brief list of topics to be covered

8. Course Assessment