MET109 Computer Programming and Applications

This is an introductory course in a computer programming language. Programs are specifically written to be used in the areas of statics, strength of materials, machine design, heat transfer, and fluid mechanics. Applications of the theoretical concepts are covered in the required laboratory. Corequisite(s): MET 109L Credits: 2 (1,2)

Prerequisite: None

Course Learning Outcomes:

• Students will be able to solve mathematical equations commonly used in science and engineering by using MS Excel features.
• Students will be able to calculate linear coefficients of a r3egression fit of data to analyze/estimate behavior of a system.
• Students will demonstrate the commitment to their works and projects by completing them on time while maintaining high quality.

Textbook: Engineering in Excel, Ronald W. Larsen

TOPICS	STUDENT LEARNING OUTCOMES
Introduction to Excel	Students will be able to navigate within the excel user interface. Print worksheet in excel. Format numbers. Insert, delete, and format rows and columns.
Graphing with Excel	Students will be able to create XY scatter, bar, and pie graphs. Edit Data on an existing graph. Format an existing graph.
Excel Functions	Students will be able to use Excel's built-in functions, use simple math functions, use trigonometric functions, use logical functions, use any miscellaneous functions.
Matrix Operations in Excel	Students will be able to apply basic matric operations in Excel, and solve systems of linear equations.
Linear Regression in Excel	Students will be able to use regressing functions, add trendlines to graphs, and use Excel's Regression Analysis package.
Excel's Statistics Function	Students will be able to distinguish samples and populations, use Excel for common statistical calculations including means, standard deviations and variances. Create histogram with Excel's Data Analysis package. Calculate confidence intervals about sample mean values.
Excel's Financial Functions	Students will be able to use built-in Excel functions for present values, future values, and regular payments. Calculate an internal rate of return. Use time-value-of money concepts to make economic decisions. Use Excel's depreciation function.
Iterative Solutions Using Excel	Students will be able to find roots of equations using several iterative solution methods. Solve optimization problems by using Excel's solver. Set up and solve nonlinear regression problems in Excel. Solve linear programming problems in Excel.
Excel Pivot Tables	Students will be able to create a pivot table, sort and filter data in a pivot table.
Numerical Differentiation Using Excel	Students will be able to calculate derivative values from a data set by using finite differences. Use Excel's data analysis package to filter noisy data. Calculate derivative values from a data set by using curve fitting.
Numerical Integration Using Excel	Students will be able to use geometric regions to approximate the area between a curve and the x-axis. Fit an equation to a curve via regression and integrate that equation to find out the area.