|
Data and Graphical Analysis
When are Data and Graphical Analysis Covered?
Excel graphs and functions are introduced in ENGR111 during Class 4.1* and Class 4.2*.
They are studied further in Class 7.1 and 7.2*.
Data analysis in Excel is revisited in ENGR112 during Class 19.1* and Class 19.2*.
*Explaination of Class numbering System
Objectives
| Class 4.1: |
Introduction to Excel |
|
Learn how to enter data into Excel |
|
Learn how to copy, fill, and plot data |
|
Learn to enter and use formulas |
|
Understand the difference between absolute and relative addresses |
| Class 4.2: |
Excel Graphs and Functions |
|
Learn to use tables and graphs as problem solving tools |
|
Learn and apply different types of graphs and scales |
|
Prepare graphs in Excel |
|
Be able to edit graphs |
| Class 7.1: |
Linear Regression |
|
Understand Linear Regression and how to compute it |
|
Use Excel to compute linear regression |
| Class 7.2: |
Excel Graphs and Functions and Graphical Analysis |
|
Learn to use tables and graphs as problem solving tools |
|
Learn and apply different types of graphs and scales |
|
Prepare graphs in Excel |
|
Be able to edit graphs |
|
Be able to plot data on log scale |
|
Be able to determine the best-fit equations for linear, exponential and power funtions |
| Class 19.1: |
Data Analysis in Excel |
|
Learn to use statistical Excel functions such as average, median, min, max, stdev, stdevp,var, varp, standardize, normdist, normsdist, norminv, and normsinv |
| Class 19.2: |
Breakeven Analysis, Tolerances, and Expected Value |
|
Be able to draw a break-even graph ignoring the time value of money |
|
Calculate the effective cost of manufacturing a part |
Class Agenda
| Class 4.1: |
Introduction to Excel |
|
Lecture on estimation |
|
Individual and team exercise |
|
HW problems assigned |
| Class 4.2: |
Excel Graphs and Functions |
|
RAT-quiz |
|
Lecture on tables, graphs, and solver function in Excel |
|
In class practice example using tables |
|
In class team exercise using graphs and solver |
|
HW assignment given at the end of class |
| Class 7.1: |
Linear Regression |
|
Lecture Material on linear regression and coefficient correlation |
|
Team exercise - 5 min |
|
Leacture on creating a trendline in Excel |
|
HW assignment |
| Class 7.2: |
Excel Graphs and Functions and Graphical Analysis |
|
RAT-quiz |
|
Lecture Material on log scale, best-fit lines and interpolation |
|
8 min pair exercise |
|
3 min team exercise |
|
RAT |
|
10 min pair exercise |
|
5 min individual exercise |
|
HW assignment given at the end of class |
| Class 19.1: |
Data Analysis in Excel |
|
RAT-quiz |
|
Lecture material on statistical functions |
|
8 min team exercise |
|
2 PATs |
|
Think-Pair-Share exercise |
|
HW assignment |
| Class 19.2: |
Breakeven Analysis, Tolerances, and Expected Value |
|
RAT |
|
Lecture material on Breakeven Analysis |
|
In class team exercise |
|
Team HW assignment |
Why are Data and Graphical Analysis Important?
Graphical Analysis of collected data is made possible trhough rough hand sketching or the use of compter tools such as Maple, Excel, MathCAD, or other graphical software.
Various characteristics of Data can be identified using a graphical technique that would otherwise be lost in long lists of numbers and experimentation results. Graphical analysis also allows for formulas to be computed using linear/non-linear regressions and other build-in computer analysis tools.
Links to Class Materials
- Class 4.1 Powerpoint
- Class 4.2 Powerpoint
- Class 7.2 Powerpoint
- Class 19.1 Powerpoint
- Class 19.2 Powerpoint
|
