Course syllabus

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

Course Syllabus

Data entry : Assoc.Prof. Dr.Teeradej Wuttipornpun
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 cleansing 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.)
  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 Performance indicator
    SO1 an ability to identify, formulate, and solve complex engineering problems by applying principles of engineering, science, and mathematics.
    • PI-1.1 Identify the problem and identify key issues/variables
    • PI-1.3 Show solution procedure (or Solving methods)
    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.
    • PI-2.4 Build a solution (or solutions) and analyze performance, ensuring that the solutions meet the specified needs with explicit consideration of public health, safety, and welfare, as well as global, cultural, social, environmental, and economic factors.

7. Brief list of topics to be covered
  • Workshop 1 (Data Cleansing)
  • Workshop 2 (Relation and Power Query)
  • Workshop 3 (PivotTable and Power Pivot)
  • Workshop 4 (Power BI desktop)
8. Course Assessment
Course assessment Weight score (%) Assessment tools Date
Workshop1 15 group discussion, Workshops
Workshop2 15 group discussion, Workshops
Workshop3 15 group discussion, Workshops
Workshop4 30 group discussion, Workshops
Final exam 25 final examination
The grading table
Grading Rank
>= 80% A
73% - 79.99% B+
66% - 72.99% B
59% - 65.99% C+
52% - 58.99% C
46% - 51.99% D+
40% - 45.99% D
0% - 39.99% F

หมายเหตุ - ลำดับเนื้อหาจะมีการปรับเปลี่ยนตามความเหมาะสม