CE EN 270 - Virtual Lecture
Norm Jones
Brigham Young University
   
Loops, Part 3 - Files & Arrays
   

Instructions: Click on each of the links below, in order. You will need a Shockwave-enabled browser in order to view the lectures. As you view the lecture, use the controls at the bottom of the image to pause, stop, fast-forward, and rewind the lecture.

These lectures contain audio. If you are viewing the lectures in a CAEDM lab, you will need to use a set of headphones to avoid disturbing your fellow students.


Sections
Description
File Looping Introduction to the lecture and a discussion of how to loop over a set of files in folder.
Task #1 In-class task #1: Loop through the files in a folder and display the names in a list.
Task #2 In-class task #2: Loop through the files in a folde. Open each file, change the spreadsheet, and save the spreadsheet.
Arrays Introduction to 1D and 2D arrays
Integration A review of numerical integration using the trapezoidal rule.
Task #3 In-class task #3: Write VB code to compute the area under a curve using numerical integration via the trapezoidal rule.