May 18, 2024  
2020-2021 Course Catalog 
    
2020-2021 Course Catalog [ARCHIVED CATALOG]

Add to Portfolio (opens a new window)

EGR 151 - Engineering Visual BASIC

Credits: 2
Lecture Hours: 2
Lab Hours: 0
Practicum Hours: 0
Work Experience: 0
Course Type: General
This course provides students with a solid foundation in structured programming skills for the solution of engineering problems. Students will analyze problems, design solution algorithms, translate the algorithm to Visual BASIC computer code and present the solutions to the problems.
Prerequisite: Minimum ALEKS score of 61 OR
Prerequisite OR Corequisite: MAT 130   OR MAT 211  
Competencies
  1. Understand the basics of computer programming.
    1. Understand the types of programming languages.
    2. Understand the three basic control structures.
    3. Develop an algorithm to solve a problem.
    4. Express the algorithm in terms of pseudocode.
    5. Express the algorithm in flowchart form.
  2. Understand the sequential control structure.
    1. Understand and use the various VBA data types.
    2. Perform mathematical computations.
    3. Use the InputBox function to enter data into the program.
    4. Use the MsgBox function to display results from the program.
  3. Understand the selection (decision) control structure.
    1. Understand and use comparison operators.
    2. Use the IF statement.
    3. Use the IF/ELSE block IF statement
    4. Use the IF/ELSEIF/ELSE block IF statement.
    5. Understand and use logical operators.
  4. Understand the repetition (loop) control structure.
    1. Understand the use of pretest loops.
    2. Use the DO/EXITDO/loop.
    3. Use the FOR loop.
  5. Understand subprograms and functions.
    1. Use built-in functions
    2. Construct and use user-defined functions.
    3. Construct and use subroutines.
    4. Understand the use of a CALL statement.
    5. Understand and demonstrate the ability to pass parameters by value and by reference.
  6. Understand the use of sequential access files.
    1. Understand the structure of a sequential access file.
    2. Understand and demonstrate the use of an OPEN statement for file I/O operations.
    3. Use the INPUT statement to read information from a file.
    4. Use the PRINT or WRITE statement to send information to a file.
    5. Understand and demonstrate the use of the CLOSE statement for file I/O operations.
  7. Understand the use of arrays.
    1. Declare one-dimensional arrays and multidimensional arrays.
    2. Use array subscripts to access data stored in an array.
    3. Use FOR loops for computational and I/O operations involving arrays.
    4. Demonstrate the ability to pass arrays to functions and subroutines. 
  8. Understand the interaction between VBA and the EXCEL spreadsheet program.
    1. Understand the recording of macros.
    2. Demonstrate the ability to obtain values from an EXCEL spreadsheet.
    3. Demonstrate the ability to place values in an EXCEL spreadsheet.



Add to Portfolio (opens a new window)