MIS/CIT 216: Test #2 - Study Guide

It will be a combination short answers and mutliple choice and small coding snipets.
It will cover concepts reviewed in class, projects 2 and 3 and in class projects 2 and 3.

Hint: a good way to prepare for this test would be to review the inclass projects and to work through the book examples staring on page 113 for each of the FOR LOOP and DO UNTIL, DO WHILE examples

Chapters 4 and 5

 Chapter 4 Concepts

• Know the basic syntax of the following:
  • If... Then ... End If
  • If... Then ... Else ... End If
  • Select Case Statements
    
    
• Know the different relational operators and how used (< > <=, >=, > < )
• Know the different True / False Cases for IF statements with OR, AND, and NOT
  
  
• Know the basic syntax of a FOR  EACH  NEXT series of commands
  • How would you step 2 increments at a time
  • How would you go backwards for your counter
    
    
• Know the basic syntax of a DO WHILE LOOP
  • Especially know how to exit the loop in advance
  • Know the value of any counters when exiting the loop
  • What is the difference between a pre and post test loop?
• Likewise know the basic snytax of the DO UNTIL LOOP
  
  
• What functions does a list box provide versus a text box or label?
• How do you convert strings to numbers?
• How do you check that what is entered into a text box is a number?
  
  

 Chapter 5 Concepts

• What is the benefit of an array?
  • How do you declare a string array versus a typical string variable?
  • How do you place values into an array and then retrieve them

 Chapter 10 Concepts

• What are the major error types discussed in class?
  • Which is the hardest to troubleshoot?
  • How would you prevent them?
  • What were some of the debugging methods used?
  • What does a Try Catch Loop do?

---