Subject description
Beginner to advanced Excel applications including Charts, Excel Functions, Advanced Excel Formulae, Goal Seeking, Data analysis, Data filtering, Lookup Functions, Pivot Tables, Pivot Reporting, Visual Basic for Applications (VBA) and macros; Solving simultaneous equations, evaluating integrals and differentiation; building complex calculations with advanced functions; creating and using a range of … For more content click the Read More button below.
Equivalence
MINE434 - Computer Applications in Mining Engineering
CIVL296 - Engineering Computing
MINE234 - Computer Applications in Mining Engineering
Delivery
To view information specific to your campus, click on Select availability in the top right of screen and choose from the campus, delivery mode and session options.
Teaching staff
Subject coordinators
Lecturers
Learning outcomes
On successful completion of this subject, students will be able to:
1.
Develop analytical skills for handling and interpreting datasets
2.
Apply Excel spreadsheet to solve practical problems in a systematic process.
3.
Apply Excel for critical analysis and evaluation of data.
4.
Develop advanced numerical solutions to complex problems using Excel.
5.
Develop a more advanced computing skillset relevant and ready for the workplace that will allow a student to hit the ground running and be more efficient in their workplace upon graduation.
Assessment details
Two Excel application projects
Online quiz
Final exam
Work integrated learning
Embedded WIL:This subject contains elements of "Embedded WIL". Students in this subject will experience activities that relate to or simulate professional practice as part of their learning.