Topics for the Final Exam

All topics from the Midterm Topics page

Chapter 6

• 6.3 Sub Procedures
• 6.4 Function Procedures
• 6.8 Scope Rules
• Examples
  • Fig. 6.5
  • In class
    • Find min of two numbers as a function. Can be used to find min of several numbers.
    • Calculate area of a rectangle
    • Calculate area of a flat washer
    • Function to return a valid number using an InputBox
    • Boolean function to test if a number is within a range

Chapter 7

• 7.2 Arrays
• 7.3 Declaring Arrays
• 7.4 Examples Using Arrays
• 7.5 Passing Arrays to Procedures
• 7.6 Sorting Arrays
  • Selection Sort covered in class
• 7.7 Searching Arrays
• 7.10 Dynamic Arrays
• Examples
  • Fig. 7.2
  • Fig. 7.3
  • Fig. 7.4
  • Fig. 7.6
  • Fig. 7.7
  • Fig 7.8
  • Fig 7.9
  • In class
    • Swap two values
    • Find location of minimum value in part of an array
    • Selection Sort
    • Find minimum value in an array
    • Using a Count Loop to find all numbers above the average
    • Using a Sentinel Loop to read numbers into an array

Chapter 10

• ComboBox
• ListBox

Chapter 18

• 18.4 ADA Data Control and DataGrid
• 18.5 Biblio.mdb
• 18.6 SQL
• 18.7 ADO Data control and DataGrid again
• 18.9 DataList and DataCombo
• 18.10 Data Environment Designer
• 18.11 Recordsets
• Examples
  • Fig. 18.15
  • Fig. 18.20
  • Fig. 18.22
  • Fig. 18.26
  • In class
    • Sentinel loop for a recordset