Fundamentals of Additive Manufacturing

Link to Home page
PACE Home
Courses
Course Catalogue
Fundamentals of Additive Manufacturing

Overview

Course Date:
19 Mar 2025 to 19 Mar 2025
Registration Period:
10 Feb 2025 to 05 Mar 2025
Duration/Frequency:
Total 8 hrs/ 1 Day 19 March 2025
Mode of Training:
Classroom
Venue:
Singapore Polytechnic
Funding:
-

This course provides a thorough introduction to utilise Python with Microsoft Excel for sophisticated data analysis and task automation for manufacturing processes. The course shows participants how to construct and manipulate workbooks and sheets while introducing the fundamentals of Excel automation using Python modules like openpyxl. To insert and format data, the participants will learn how to combine and separate cells, add comments, and use conditional formatting. In addition, the course covers how to apply formulas and data validation in Excel, as well as a variety of chart styles, such as column, line, pie, and bubble charts.

Course Objective

The course will equip participants with core technical knowledge related to common Additive Manufacturing practices. They will get to know the process flow of the technology with a facility tour of SP Innovation Centre for Additive Manufacturing.

Course Outline

By the end of the course, participants will be able to:

Apply Microsoft Excel visualisation tools for Manufacturing Data Analysis
Automate Excel tasks of manufacturing process using Python-based libraries, like openpyxl
Manipulate data, tables, and images in Excel using Python
Handle Excel files using Python in read-only or write-only modes
Setup print settings in Excel
Generate various types of charts such as columns, lines, bars, areas, and combos using Python
Filter and sort data in Excel for better data analysis
Use formulas to perform calculations in Excel

Topics to be covered

Advanced Microsoft Excel tools including Excel function, Power Query, Data Model and Pivot table
Setting Up Python Environment for Excel
Manage Files and Folders
Manage Worksheets and Cells
Analysing Data with Pandas and Numpy
Manage Formulas and Functions with Python
Manage Tables and PivotTables with Python
Creating Charts and PivotCharts with Python

Minimum Requirements

ITE/Diploma in any discipline

Certification / Accreditation

• Certificate of Attendance (electronic Certificate will be issued)
A Certificate of Attendance will be awarded to participants who meet at least 75% attendance rate

• Certificate of Completion (electronic Certificate will be issued)
A Certificate of Completion will be awarded to participants who pass the assessment and meet at least 75% attendance rate

Suitable for

Aerospace Sector: Manufacturing Engineers / Production Engineers (Manufacturing) / Senior Operations Managers / Senior Production Managers / Senior Manufacturing Managers / Senior Technicians (Manufacturing) / Technicians (Manufacturing)

Marine and Offshore: Assistant Production Engineers / Production Engineers / Supervisors / Chargehand/Foreman / Assistant Manufacturing Managers / Section Managers