Course                                   Common to all Bachelor of Engineering Courses

Subject Name                        Engineering Computations

Subject Code                         EN114

Duration                                 13 teaching weeks, 1 exam week, 1 mid semester break week

Contact Hours                       6 (4 Lectures, 2 Laboratories)

Credit Points                         18

Delivery Mode                       On campus

Prerequisites                         Nil

Co-requisites                         Nil

Course Coordinator            Mr. Wilson Kepa


The subject introduces student to engineering problem solving though the use of computer-aided engineering software with a strong emphasis on  data collection and analysis tools. It explores the use of Excel, Matlab and SAP JMP as a tool to import, cleanse, analyze, manipulate and reporting of engineering data. Data science methodology are implemented through the use of the Excel VBA framework, Matlab scripts of the Matlab computational software and the  JMP programming language of SAS JMP – emphasis on the trade-off between efficiency and accuracy of computational methods versus algebraic analytical methods.

Subject Topics
  1. Introduces Excel as data handling tool in engineering
    1. Explores the use of formulae on data manipulation using the coordinate system of data cells
    1. Explores the use of charting functions on data collections
    1. Introduces the grammar of the VBA language and uses it to develop automation on data manipulation
    1. Data cleansing process of data importation and data massage into a form that can be manipulated and analyzed
    1. Implement modeling methods using formulae and VBA including; Statistical Analysis, Time Series Analysis, Mathematical functions, Curve Fitting and Regression and Solving Equations
    1. Numerically differentiating, integrating and integration of differential equations for engineering applications.
  • Introduces Matlab as a computational tool for engineering applications
    • Matlab fundamentals: Matlab interface, Matlab data types, Matlab script and function files.
    • Matlab programming: Loop Commands, Logical Branching Statements, Combining Loops and Logic, elementary vectorisation of algorithms
    • Matlab Data Plotting
    • Matlab Engineering Applications: Finding Roots of Equations, Matrix Mathematics, Solving Simultaneous Equations, Numerical Integration, Solving Ordinary Differential Equations, Solving Partial Differential Equations, Solving Nonlinear Algebraic Equations.
  • Introduces JMP SAS for engineering data analytics.
    • Data: Importing Data into JMP, JMP Data Table, Cleaning and Formatting Data, Analyzing Row States.
    • Index of Graphs: Basic Charts, Thematic Maps, Graphs of One, Two and Multiple Columns.
    • Graphing: Using Graph Builder to produce graphs of Data and Maps.
    • Problem Solving with One, Two and Multiple Columns.
Subject Learning Outcomes (SLOs):

On completion of this subject, the students will be able to:

  1. Demonstrate qualitative and quantitative understanding of the use of Excel Spreadsheet.
  2. Develop a working knowledge of the required mathematical solution procedures for engineering analysis.
  3. Illustrate the use of spreadsheets to compute a variety of engineering problems.
  4. Apply Excel built-in features and VBA, Matlab and SAP JMP to compute engineering problems.
  5. Apply necessary skills to design and implement an emerging engineering application.
Assessment Tasks and Weightings:

To obtain a pass grade in this subject a student must achieve 50% overall. There is no final examination for this subject. Students must also refer to the Subject Assessment Details as prescribed by the subject coordinator.

Computer Laboratory Reports and Quizzes are worth 40% of the overall marks for the subject. Assignments and Projects are worth 40% and Tests are worth 20%.

Subject Assessment Task (AT) Details

AT Item                       Component                            Marks                          Week(s)

1. Laboratory      Lab 01                                     3 %                              03

                                    Lab 02                                     3 %                              04

                                     Lab 03                                     3 %                              05

                                    Lab 04                                     3 %                              06

                                     Lab 05                                     3 %                             07

                                     Lab 06                                     3 %                              08

                        Lab 07                                    3 %                              09

                        Lab 08                                     3 %                              10

                         Lab 09                                     3 %                              11

                         Lab 10                                     3 %                              12

2. Quizzes          Quiz 01                                   5 %                              05

                         Quiz 02                                   10 %                            08

                         Quiz 03                                   10 %                            11

3. Assignments        Assignment 01                    5 %                            3 – 6

                                   Assignment 02                      5 %                             7 – 9

                                   Assignment 03                      10 %                          9 – 12

4. Test                          End-Semester Practical Test    10 %               07      

                                    Mid-Semester Practical Test   15 %               13

It is important that all students familiarize themselves with the university’s Assessment Guidelines including those on plagiarism. This can be viewed on the university’s website:

Laboratory Classes

All lab classes start in Week 2, such that week 1 lab sessions will be allocated to software installation required for the labs. Each weekly lab class is 2 hours long.

Laboratory classes give you a chance to practice problem solving, engineering computations, and programming skills on small, guided and well-defined examples. The examples have been chosen to highlight particular aspects of problem solution, and will give you enough grounding in problem solving to assist you in completing your assessable work. Your tutor will be present in your lab class to answer any questions you may have and to assess your competencies.

IMPORTANT: Please note that at the time of marking the lab exercises, the tutor may ask the student to solve other similar problems. You need to demonstrate that you are able to solve lab exercises and related problems, in order to receive any marks for your lab work. In other words, using some else’s lab solution is pointless!

Finally, you can only have your lab work marked during your scheduled lab class. It is not possible to have your work marked in another class.


Quizzes will be conducted for not more than 30 minutes. Quizzes will start from Week 5 and in a span of three successive weeks. The quizzes will challenge student understanding and assess comprehension of course modules delivered.


Assignments give you the chance to practice what you have learned on relatively large problems (compared to the small exercises in the Lab Classes). Assignments are a very important part of this course, therefore it is essential that you attempt them yourself.

There will be four assignments:

  • Assignment 1 is due in Week 6 (requirements available in week 3).
  • Assignment 2 is due in Week 10 (requirements available in week 6).
  • Assignment 3 is due in Week 12 (requirements available in week 10).

Assignments are to be completed in your own time. To maximize the learning benefits from doing assignments, it is essential that you start work on assignments early. Do not leave your assignments until the last minute. If you submit an assignment late, the maximum available mark is reduced by an amount (2%) per day that it is late such that submission beyond 2 days late will not be assessed. Assignments are submitted using the courses Google Classroom submission links.

All assignments are aimed at developing skills in all stages of computational engineering problems which include:

  1. Requirements comprehension,
  2. Design a method to solve the problem,
  3. Design refinement,
  4. Implement and document the design and test extensively to validate that the program meets the requirements.
Test and Examinations

The final End of Semester Practical Test will be held during the examination period. It will examine all materials covered in the course, but will emphasize the material in the second half of the course.

IMPORTANT: It is important that all students familiarize themselves with the PNG University of Technology Assessment guidelines including those on plagiarism.

Subject Mapping

Subject Learning Outcomes (SLO) are mapped to each of; PNG National Qualifications Framework Level 8 (NQF), Course Learning Outcomes (CLO), Unitech Graduate Attributes (GA), Assessment Tasks (AT) and Engineers Australia (EA) Stage 1 Competencies.

All SLOs combine to collectively deliver the CLOs and EA Stage 1 Competencies.

Subject Mapping Matrix
SLOSLO to NQFSLO to CLOSLO to GASLO to ATSLO to EA Stage 1 Competencies
1Knowledge and skills1 & 3Critical thinker1, 41.1, 1.2, 2.2
2Knowledge and skills Application1 & 3Critical thinker1, 41.1, 1.2, 2.1, 2.2, 2.3
3Application & Autonomy1, 3 & 4Critical thinker1, 41.2, 1.3, 1.4, 2.1, 3.2, 3.3, 3.4
4Knowledge and skills Application1, 3 & 4Critical thinker2, 41.1, 1.2, 2.1, 2.2, 2.3, 2.4
5Knowledge and skills Application1, 3 & 4Critical thinker2, 41.2, 1.4, 2.1, 2.2, 2.3, 2.4, 3.1, 3.2, 3.3, 3.4