# Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.

8 Pages

### 21

Course: CS 105, Spring 2008
School: University of Illinois,...
Rating:

Word Count: 400

#### Document Preview

Statements When Case do we use a Ca se Sta tement? Wha t does Ca se El se mea n? Wha t i s Ca se I s? Cour se Gui de p. 207 #1 Setti ng up the Case Statement First, you need to tell VBA which variable or expression that you are checking Select Case vntTest ---Or--Select Case vntTest + 1 CS 105 Fal l 2006 #2 Di ffer ent Expr essi ons T hr ee types: Ca se 2, 6, 8 Ca se 2 T o 8 Ca se I s &lt;= 8 CS 105...

Register Now

#### Unformatted Document Excerpt

Coursehero >> Illinois >> University of Illinois, Urbana Champaign >> CS 105

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Statements When Case do we use a Ca se Sta tement? Wha t does Ca se El se mea n? Wha t i s Ca se I s? Cour se Gui de p. 207 #1 Setti ng up the Case Statement First, you need to tell VBA which variable or expression that you are checking Select Case vntTest ---Or--Select Case vntTest + 1 CS 105 Fal l 2006 #2 Di ffer ent Expr essi ons T hr ee types: Ca se 2, 6, 8 Ca se 2 T o 8 Ca se I s <= 8 CS 105 Fal l 2006 #3 The Case Statement Preferable to the IF statement for a multi-branch situation Sel ect Ca se vntT emp Ca se 90 Ra nge("A2").I nter i or .Col or = vbYel l ow Ca se 80 Ra nge("A2").I nter i or .Col or = vbGr een Ca se 70 Ra nge("A2").I nter i or .Col or = vbRed Ca se El se Ra nge("A2").I nter i or .Col or = vbBl ue CS 105 Fal l 2006 #4 Sel ect Case Exampl e We can use thi s l ater i n l oops! Select Case vntPercentage Case Is > = 0.90 strGrade = "A" Case Is >= 0.80 strGrade = "B" Case Is > = 0.70 strGrade = "C" Case Is > 0.60 = strGrade = "D" Case Else strGrade = "Less than D" End Select CS 105 Fal l 2006 #5 Checki ng a var i abl e, showi ng a pi ctur e (hi de al l the pi ctur es each ti me you cl i ck on the button) i ntM onth = I nputBox ("T ype the number of the month", _ "M onth", 12) Sel ect Case i ntMonth Case 12, 1, 2, 3 i mgCol d.Vi si bl e = Tr ue Case 4 To 6 i mgSpr i ng.Vi si bl e = Tr ue Case 7 To 8 i mgSun.Vi si bl e = Tr ue Case 9 To 11 i mgFal l .Vi si bl e = Tr ue Case El se (show a message box) End Sel ect CS 105 Fal l 2006 #6 i ntM onth = I nputBox("Enter the number of a month", _ "Entr y must be between 1 and 12") Sel ect Case i ntM onth Case 1 str M onth = "J anuar y" Case 2 str M onth = "Febr uar y" Case 3 str M onth = "M ar ch " (and so on...) CS 105 Fal l 2006 #7 Case To Summar i ze: One val ue i s bei ng checked, often a var i abl e The or der of statements i s VERY i mpor tant thi nk about i t! CS 105 Fal l 2006 #8
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

University of Illinois, Urbana Champaign - CS - 105
ProgramDirection L R D R D L U Num Cells 3 1 1 10 10 10 10 Color REDDrawing BoardRED BLUE GREEN YELLOWRunAuthors: Sections: Date:Test ValidateTest ColorCellTest MoveOneCellClear Test ResultsTEST RESULTS
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: p1.dvi %Pages: 2 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f p1 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: s1.dvi %Pages: 4 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f s1 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
q ifd t HjqfBhHx ht ejegHjifoqn|lx~i xd enj t hi xe t j i x x d n x d n x x x xf v p p p u 'f p p h enR u' jq ' p juu o p q t p f f q t juW o p q &quot;f ht fd t jk |k t j joqne jqgx m x ~ k x p p p
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: p2.dvi %Pages: 2 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f p2 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: s2.dvi %Pages: 3 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f s2 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: p3.dvi %Pages: 2 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f p3 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
6 |bW | |q|q |q| \$qbvUve o|\$x|q d|@tqWm @v |v@ qw | | q4{\$ v\$q |@\$qewo&quot;dqq b|@v&amp;\$m6 v\$ |\$\$Rd|b|\$qwox\$q |y mm 6\$m\$Ryex |@|
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: s3.dvi %Pages: 7 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f s3 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
~ Dv e v { kD B zhehn u gkk &quot;5Y g 5 z h hhzkDhgkrhz v P k W rukR v { ez zhe rm g hz ks r ih
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: p4.dvi %Pages: 2 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f p4 %DVIPSParameters: dpi=600
Cornell - CS - 100
Name(s) &amp; ID(s):_ Assignment P4 CS 100 Summer 1999 Due: Thursday July 29, 1999 at the beginning of class.NOTE: YOU MUST WORK WITH A PARTNER ON THIS ASSIGNMENT. Turn in your assignments according to the instructions given in the first day handout. R
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: s4.dvi %Pages: 5 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f s4 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
2 0 1&quot;( )\$ %&quot; '&quot; &amp;\$ &quot; %# ! V q 6 yrGy {vy%y vrG%{rfvs66 { %ryAl%XvG%ry %r(vrrv{GX vIrvs% yr(v
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: p5.dvi %Pages: 2 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f p5 %DVIPSParameters: dpi=600
Cornell - CS - 100
Name &amp; ID:_ Quiz Q1 CS 100 Summer 1999 Due: Wednesday July 7, 1999 5 minutes after the beginning of class Question 1: What is the difference between a public field and a private field in a class definition?Question 2: Compare and contrast: procedu
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: s5.dvi %Pages: 6 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f s5 %DVIPSParameters: dpi=600
Cornell - CS - 100
Name &amp; ID:_ Quiz Q2 CS 100 Summer 1999 Due: Monday July 12, 1999 5 minutes after the beginning of class Question 1: Suppose that a field x in a class is declared thus: public static int x. What do each of the terms before the variable name (public,
Maple Springs - PHYS - 2040
@ )5s u A ltYtls 1 9 ! q ! 65) 871 0)' &amp; % ) % sYj 65(32et{32 &quot;e0)(&amp; %D ruiH\$D ) % 1 4 % 1 )' % # ! ulutr&quot;q r yssq ! 6 sr s s q lYnuusluu} lu ! s
Cornell - CS - 100
Name &amp; ID:_ Quiz Q3 CS 100 Summer 1999 Due: Wednesday July 14, 1999 5 minutes after the beginning of class Question 1: How would you declare an array of Coordinates where Coordinate is a class as we've defined it in class?Question 2: How would you
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: p6.dvi %Pages: 2 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f p6 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
o u ui o ui l m i r i m ii dtmnrux nxti(n\$ {Fpkm Rx puxei{iu(pux{iPjvm mi mxnBntr\$m\$iu m vbvi w pmn\$nt\$rntx\$e{unxp \$mnx i oi ui m r r l m u m ni {unxp x px\$mxpnui {unxp x \$pmnx \$m l nx l m u m l m u l i o Uti
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: s6.dvi %Pages: 8 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f s6 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
} w~wtu Hp TusWwup t { t r t r r t t { p t p r t r r t t r { uw&quot;~ u t ' zty%8s %~%{w{t q%t Rk } ztv t u&quot;~ u t uep~ tphut vw w~ it D t p { y {vp t t r } ~ u e{Htwt } t y} q Y~ y ztup eeyt&quot;zue{y ey
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: p7.dvi %Pages: 2 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f p7 %DVIPSParameters: dpi=600
Cornell - CS - 100
Name &amp; ID:_ Quiz Q5 CS 100 Summer 1999 Due: Monday July 26, 1999 10 minutes after the beginning of class Question 1: Thinking in Matlab right now, what will the variable a look like after the following statement is executed: a = 10 * [0:9]Question
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: s7.dvi %Pages: 6 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f s7 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: p8.dvi %Pages: 1 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f p8 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: s8.dvi %Pages: 4 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f s8 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: m1.dvi %Pages: 1 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f m1 %DVIPSParameters: dpi=600
Maple Springs - PHYS - 2040
u|t q ap!z~rp uqz5rgyp~rpp uqw n rfk x y y y t | xv y on t y x y y y xs on onl ts ~q &amp; | | f1 d 1 d % y y y Pnuyxn | | | &amp; w W p6| Dh h1 % d &amp;u
Cornell - CS - 100
Name(s) &amp; ID(s):_ Assignment P2 CS 100 Summer 1999 Due: Thursday July 15, 1999 at the beginning of class.Turn in your assignments according to the instructions given in the first day handout. Remember to include sample output when you turn in your
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: mid1_eq.dvi %Pages: 2 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f mid1_eq %DVIPSParameter
Cornell - CS - 100
Method OverloadingIf two methods of a class (whether both declared in the same class, or bothinherited by a class, or one declared and one inherited) have the same namebut different number or types of parameters, then the method name is said to
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: m2.dvi %Pages: 1 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f m2 %DVIPSParameters: dpi=600
Cornell - CS - 100
Name(s) &amp; ID(s):_ Assignment P3 CS 100 Summer 1999 Due: Thursday July 22, 1999 at the beginning of class.Turn in your assignments according to the instructions given in the first day handout. Remember to include sample output when you turn in your
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: sm2.dvi %Pages: 4 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f sm2 %DVIPSParameters: dpi=6
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: mid2_eq.dvi %Pages: 2 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f mid2_eq %DVIPSParameter
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: exam_eq.dvi %Pages: 4 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f exam_eq %DVIPSParameter
Maple Springs - PHYS - 2040
Maple Springs - PHYS - 2040
eqprqU9U9Udp999o9{ xjzl t mzl igec VTS RP H hnf0I}fFphfdba` YWUE@QIG dp9Udp9UdUpdU%pUppUr xvll t zll igec ~ VTS RP H nfh0IhFphfdba` hWUE@QIG 9peU9dpep9p9UU%U%p9dUUp9{ xmvs t vqs igec | VTS RP H nhpuI}piphfdba`
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: prac_rel.dvi %Pages: 2 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f prac_rel %DVIPSParamet
Washington - MATH - 425
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: sol_prac_rel.dvi %Pages: 9 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f sol_prac_rel %DVIP
Maple Springs - PHYS - 2040
rr @HF o r dtHI `@S&amp;txrI F F gF o ys ys rI St HI F n F o I o |I F nHUr y o |0w o| w y ts r ys r txS o u o u ys rr tHU o St H\$I@kdtr\$IrI &amp;tHI UF gF o FF ys ys r |h U QnI gF U n0 o n F o | I 5xHba`VS
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: qprac.dvi %Pages: 1 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f qprac %DVIPSParameters: d
Maple Springs - PHYS - 2040
%!PS-Adobe-2.0 %Creator: dvips(k) 5.86 Copyright 1999 Radical Eye Software %Title: sqprac.dvi %Pages: 4 %PageOrder: Ascend %BoundingBox: 0 0 596 842 %EndComments %DVIPSWebPage: (www.radicaleye.com) %DVIPSCommandLine: dvips -f sqprac %DVIPSParameters:
Maple Springs - PHYS - 2040
sHHbyiiv HyTI%uiYe~HTGTiHGiG iis%HbTdYdTyHbTzvHszjidT%vsii% H di jizdi m jzi jv llavBljv Dm vz v D |eve6ljvlva{%sD{e D
Washington - MATH - 583
Math 583GEOMETRIC MEASURE THEORY IN EUCLIDEAN SPACE AND TOPICS IN ERGODIC THEORY Spring 2008Instructors: Boris Solomyak Oce: Padelford C-328, Oce Phone 685-1307 E-mail: solomyak[at]math.washington.edu Oce hours: Monday 45, Tuesday 1112, or by
Washington - MATH - 480
Washington - MATH - 480
Washington - MATH - 480
Washington - MATH - 480
Washington - MATH - 480
Washington - MATH - 480
Washington - MATH - 480
Washington - MATH - 480
Washington - MATH - 536
Math 536HOMEWORK 1 (due Wednesday, April 9)Spring 2008Do the following problems from Gamelin (point distribution is indicated in parentheses): 13.1: 2, 6, 10 (3 + 3 + 3) 13.2: 3, 6, 7, 9 (2 + 3 + 3 + 3)1
Washington - MATH - 536
Math 536HOMEWORK 5 (due Wednesday, May 14)Spring 2008Do the following problems from Gamelin (point distribution is indicated in parentheses): 15.2: 3, 8 (3 + 3) 15.4: 3 (3) 15.5: 1, 2 (3 + 3) 15.6: 3, 7 (2 + 3)1
Washington - MATH - 534
Math 534HOMEWORK 1 (due Wednesday, Oct. 3)Autumn 20071. (a) Let |a| 1 and |b| &lt; 1. Show a-b 1. 1 - ab When does equality occur? (b) Calculate ( 1i 2 3 6) for all combinations of signs.2. Let a = e2i with Q. Prove that the sequence {an
Washington - MATH - 535
Math 535HOMEWORK 1 (due Wednesday, Jan 16)Winter 2008Do the following problems from Gamelin (point distribution is indicated in parentheses): 8.1: 3, 4, 8 (2 + 3 + 3) 8.2: 2, 6, 8 (2 + 3 + 2) 8.3: 1, 2 (3 + 2)1