S11 IE 148 Exam 1 Review

# S11 IE 148 Exam 1 Review - x=x+1 Next I Average=sum/x Min...

This preview shows pages 1–13. Sign up to view the full content.

Click to edit Master subtitle style IE 148 Exam 1 Review Spring 2011 - Sly

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Dim Single, String, Integer 1D Array X(10) as Integer 2D Array X(10, 3) as integer (row,column) Math Functions SIN(x) where x is in radians 1rad = angle*3.14/180 X^2, 6*(7+1) NOT 6(7+1)
Logic T and T = T T and F = F T or F = T F or F = F Tests (a=5) or (x=“d”) evaluate to True or False

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
VBA (strings) VBA #3 Dim str as String = “Dave” 4=LEN(str) “D”=MID(str,1,1) “VE”=MID(str,3) “DAVE” = UCASE(str) “dave”=LCASE(str)
Branching If (a=1) then b=2 If (a=1) then b=2 Elseif (a=3) then b=3 Else b=4 Endif

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Looping (Do Loop) Do if (ans=“Y”) then EXIT Do Loop Do While A<10 Loop Do Loop Until A=10
Looping (For Next) For i=1 to N if (ans=“Y”) then EXIT Do Next i For i=1 to 7 step 3 Next I For r=1 to Row For c=1 to Col Input #1, X(r,c) Next c Next r

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
For i=1 to 10 sum=sum+i

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: x=x+1 Next I Average=sum/x Min and Max maxVal=x(1) minVal=x(1) For i=1 to 10 if x(i) &gt; maxVal then maxVal=x(i) if x(i)&lt;minVal then minVal=x(i) Next I VBA Files Open data.dat for INPUT as #1 Open data.out for OUTPUT as #2 Open data.out for APPEND as #3 Input #1, x Print #2, x Close #1 Excel Graphing Graphing with Power, Exponential and Linear Functions Absolute and Relative Cell References Graphical Analysis Linear Function - Plot as a straight line on uniform grid (rectilinear) paper Y = mx + b Exponential Function -Plot as straight line on semi log paper Y = bemx Power Function -Plot as straight line on log-log paper Y = bxm Exam 1 Review Do Loops For Next If Statements Strings, Integers, Singles, Booleans Files Math Statements Excel Formulas and Graphing...
View Full Document

## This note was uploaded on 08/22/2011 for the course IE 148 taught by Professor Davesly during the Spring '11 term at Iowa State.

### Page1 / 13

S11 IE 148 Exam 1 Review - x=x+1 Next I Average=sum/x Min...

This preview shows document pages 1 - 13. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online