Introduction to Engineering Computing GEEN 1300 Elizabeth White elizabeth.white@colorado

Introduction to Engineering Computing GEEN 1300 Elizabeth White elizabeth.white@colorado.edu Office Hours: Tues 11am-12:30pm, Thurs 11am-12:30 pm, and by appointment; please send email.

Introduction to Engineering Computing • GEEN 1300 • why • solving problems that are hard or even impossible to do by hand • graphing data • writing computer programs that perform large, complicated tasks • ……..

Introduction to Engineering Computing • GEEN 1300 • what ~13 lectures ~12 lectures

Class Meetings MATH 100 MW 8:00-8:50 • Texts: • R. Larsen, Engineering with Excel, Third Edition, Pearson Prentice Hall, 2009 • H. Moore, Matlab for Engineers, Second Edition, Pearson Prentice Hall, 2009 • Readings for each week are posted on the CULearn calendar • Other Materials on class web page: • http://csel.cs.colorado.edu/~ekwhite/GEEN1300_Summer2010.html

Grading 20% Labs 7.5% Prelabs(online) 7.5% Homework 10% Class participation 15% Project 20% Midterm (in class) 20% Final (Friday, 2 July, 8-10:30am)

Labs Are the real meat of this course Where you learn by doing, not just hearing or reading Start THIS week (beginning Thursday at 8am) Happen in ECCH 107 Are due at the end of the lab period – if you arrive late, you may not finish… Bring a USB drive and the textbook

Lab Grade Policy Make-up labs after the fact only for medical or family emergencies. In some cases, make-up labs may be arranged with the instructor, but you must do so at least one weeks before the beginning of the recitation period Labs CANNOT be done at home and then turned in. Labs also CANNOT be emailed in from home. (But you can certainly work them in advance, then come in.)

Online prelabs Posted on web page Based on the reading, labs, class info Make sure you’re caught up on the reading before you start them To be done by yourself (but you may use the textbook, the web, your course notes, etc.) Due by 8am on Thursdays of lab weeks

Project Provide a more-substantial experience with a bigger problem …and an opportunity to deepen your programming skills Selected from a list of candidates (some from each engineering field) Due during the last week of classes

Homework Where you learn offline, at your own pace Are posted on webpage, along with textbook readings Are due at the beginning of lecture, typically on mondays, in manila folders outside this room Late HW is not accepted Solutions posted on web page after it’s turned in

Midterm • In class TBD (I’ll know by Thursday) • Coverage: Excel & VBA • Tests whether you know what these tools do, how they work, and how to use them to solve engineering problems • Cheat sheet allowed

Final Exam • 8:00-10:30am on 2 July (Friday) • Look at your exam schedule NOW: registrar.colorado.edu/Calendar/calendars_schedules.html • Covers whole course • Targets my learning goals:

Learning goals: • Know what’s in your computational toolbox • …and how/when to use it • Develop the resourcefulness to learn about other tools • Know the basics of computer programming

Academic Ethics All incidents of academic dishonesty will result in academic sanctions In addition, the Honor Code Council will be notified and a non-academic sanction can be issued by them For example, if two identical labs are turned in, that is considered cheating, and for both people That has implications for leaving your files on lab computers! But collaboration is not always cheating If you have any questions about cheating, ASK!

Overview of Excel coverage in GEEN 1300 understanding spreadsheet layout and operations learning skills for efficient use of the software how to set up the solution of typical engineering problems learning VBA: the missing link for most users developing user interfaces and other enhancements

Familiarity with Excel… • don’t know what it is • know vaguely what it is • have seen an Excel spreadsheet at least once • have actually used Excel to create a spreadsheet • have used Excel extensively (i.e., beyond simple spreadsheets)

Syntax for Excel formulas formulas must start with =, + or - ( leftover from 1-2-3) expressions are evaluated left-to-right precedence for arithmetic operators is: negation unary – exponentiation ^ multiplication & division * and / addition & subtraction + and -

Examples… Negation – unary minus algebraic format Excel syntax Result -3^2 9 or –9 ??? [test it if you’re not sure!] Repeated exponentiation algebraic format Excel syntax =x^y^2 =x^(y^2)? =(x^y)^2? [What do you really want to have happen?]

More examples algebraic format Excel syntax =pi()*D^2/(4*L) or =pi()*D^2/4/L =(T-TL)/a*(TH-TL) or =(T-TL)/(a*(TH-TL)) or =(T-TL)/a/(TH-TL)

Which will give you an answer of -9? =-(3^2) -(3^2) =-3^2 (a) and (b) (a) and (c) negation unary – exponentiation ^ multiplication & division * and / addition & subtraction + and -

The formula for the deflection of a cantilever beam is: How do you write this formula in Excel? • =F*L^3/(3*E*I) • = F*L^3/3/E/I • = F*L^3/3*E*I • (a) or (b) • None of these

The formula for the deflection of a cantilever beam is: How do you write this formula in Excel? • =F*L^3/(3*E*I) • = F*L^3/3/E/I • = F*L^3/3*E*I • (a) or (b) • None of these Avoid this decoding issue by using parens!!

Examples algebraic format Excel syntax =PI()*h^2(3*Radius-h)/3 What’s wrong with this? forgot the * operator =SIN(45) What’s wrong with this? arguments to trig functions must be in radians =SIN(45/180*PI()) or =SIN(radian(45))

Examples Logarithms and exponents Remember! LN(y) EXP(X) LOG10(P) 10^(A-B/(T+C)) =LN(x)/LN(a) =LOG(x,a)

Syntax for Excel formulas formulas must start with =, + or - ( leftover from 1-2-3) expressions are evaluated left-to-right parentheses are used to establish order for calculations precedence for arithmetic operators is: negation unary – exponentiation ^ multiplication & division * and / addition & subtraction + and - functions are evaluated first and the result is inserted at the position of the function in the expression

Another example algebraic format Excel syntax =(y+2)*(x-2)/(x^2+x*y+SQRT(y)) Order of evaluation: • put y into SQRT function, return answer to that position • compute y+2 result • compute x-2 result • multiply y+2 result times x-2 result to get numerator result • compute x^2 result • compute x*y result • add up x^2, x*y and SQRT(y) to get denominator result • divide numerator result by denominator result

How to enter cell addresses in a formula? Example: =b1+b2+b3+b4 or=sum(b1,b2,b3,b4) or =sum(b1:b4) • How do you enter those cell references? • How do you enter a range of cells? • By typing or by clicking (and dragging, if it’s a range like b1:b4) • p.s. see the “Insert Function” button on the Formulas tab for a list of Excel’s functions – or use the help docs.

Cell names • Default name: column letter followed by row number • You can give cells other names via the “Name Box” • And then use those names (instead of “B1” et al.) in your formulas • Some names are reserved – watch out! • You can name a bunch of cells at once using “Create from Selection” on the “Formulas” tab

“Filling” Cells • Via the fill handle • Works for formulas too!!

Engineering calculations in Excel Deflection of cantilever beam modulus of elasticity moment of inertia

Deflection of cantilever beam L = 3 ft Basic data: F = 100 N E = 3 x 107 psi b = 1 in d = 2 in Find  in mm

Deflection of cantilever beam Find  in mm Don’t forget your name!

Deflection of cantilever beam Find  in mm

Deflection of cantilever beam • Case studies: • How does  change as L varies? • How does  change as d varies? • How does  change as b and d vary? • Lots of ways to do the one-variable case studies…

Using formula copy: Single formula with only one parameter changing Range of parameter values in adjacent column

Another example: Set up example for case study of f(x) vs x Case study by copying formula range B2:B11 named x

Enrollment Only 35 (40?) people can enroll in GEEN 1300: We cannotadd people over those limits, nor can we add new sections. Computers are the limiting factor. If you’re in, don’t move sections; if you do, the registration computer will instantly give away your spot, leaving you in limbo. If you’re not in, but you’re #1 on the waitlist, you may get in, but you should make backup plans. Come to lab in the meantime. If you’re further down the waitlist, you may wait & see if you get in, but you should really make plans to take this course later (e.g., in the fall) and/or explore other options (e.g., CSCI1300) June 2 is the last day to drop without charge; June 4 is the last easy day to drop; June 14 is the last day without petitioning the Dean, per http://www.colorado.edu/summersession/calendar/index.html

Introduction to Engineering Computing GEEN 1300 Elizabeth White elizabeth.white@colorado