Review for Exam 3

1
Review for Exam 3

• ITE 285
• Summer 2004

2
Final Exam Topics

• Comprehensive Exam
• (Review Materials from Exams 1 and 2)
• Structures
• Random Access Files
• Indexing
• Collections
• Classes / Objects

3
Structures

• Declaring a Structure
• Access Control Keyword Structure name
• dim variable as datatype
• dim variable as datatype
• End Structure
• Declaring a Variable of the Structure
• dim myExample as StructureName

4
Random Access Files

• Open
• FileOpen (fileNumber, fileName, OpenMode.Random,
  , , Len(structureVar)
• Read
• FileGet (fileNum, structureVar, recNumber)
• Write
• FilePut (fileNum, structureVar, recNumber)
• Close
• FileClose (fileNum)

5
Helpful Methods

• LOF (fileNumber)
• Length of file
• Len(variableName)
• Length of structure
• LOC (fileNumber)
• Record Number of the last record number accessed

6
Random Access Files

• Advantages
• Easier for Searching
• Faster access to individual records
• Can read and write without closing in-between
• Disadvantages
• Takes up more space
• Harder to create and use

7
Indexing

• Ordering System for Random Access Files
• 2 Components
• Index Value
• Pointer Value
• Implemented
• Sequential Access File
• Parallel Arrays
• Array of Structures
• SortedList Collection

8
Collections

• Prepackaged Structures in .Net framework
• Dynamic
• Indexed?
• Sorted?
• Access?
• SortedList collection
• Key / Value pair

9
Classes

• Class definition
• Object Instance of a Class
• Attributes
• Methods
• Constructors
• Method Overloading
• Properties

10
Testing Notes

• Variety of Test Questions Multiple Choice,
  Short Answer, Discussion, Coding
• Know Common Properties, Events, Methods for
  Common Controls (Used in Class, Labs, Programming
  Assignments)
• Partial Answers are better than no answers
• Pseudo-Code if necessary
• A Line of Code requires only a Line of Code
• An Event Procedure required Procedure
  Declarations (Header, End Sub)
• Practice Coding
• Practice Problem Solving If you dont solve the
  problem then the answer is wrong
• Questions Come from Class Discussions /
  PowerPoints / Textbook Chapters 1 9, 12

11
Final Exam

• Tuesday, July 27
• 545 745 p.m.
• Bring a Clean Floppy Disk with a Blank Label
• Dont Be Late