CIS 230
Class #20 Lecture
Review selected Ch. 10 Review Questions on p. 438
Review selected Ch. 10 Feedback exercises (pp. 385, 393, 412)
Continue Ch. 10 Lecture
Hands on Programming Exercise:
(user-defined types) Do Feedback 8.3 #1 & 2 (p. 299) on your computer. Place the Type/End Type statement in the general declarations section of the form module but declare it as Private. Create five text boxes allowing the user to enter the 5 pieces of information for a student. Then, create another text box that invites the user to enter an integer between 1 and 100. Finally, create a command button that will insert the 5 data elements from 5 text boxes into the desired position of the array (subscripted from 1 to 100) of 100 students.
(two-dimensional tables) Do Feedback 8.4 (p. 310) on your computer. Use loops efficiently to answer exercises #2 - 4.
(sequential access files) Write a program that simply stores the user's name on the first line of a sequential access file. Use an InputBox to obtain the user's name. (See pp. 435 & 436 to learn how to use the InputBox Function.)
(sequential access files) Write a comma-delimited text file with three records (integers) on each of 5 lines. Create a command button that uses a double nested loop and an Input # statement to input all 15 elements into a 5 x 3 two-dimensional array. As a second exercise, place the same data into an MS Excel comma-delimited (.csv) file and do the same thing.
Homework Assignment: