{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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
VB Data Types & Arrays 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
Adding & Counting & Average 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) > maxVal then maxVal=x(i) if x(i)<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

{[ snackBarMessage ]}

### 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