# Computational Methods

Computational Methods
Computational techniques for solving civil engineering problems.
CE EN
270
 Hours 3.0 Credit, 3.0 Lecture, 0.0 Lab Prerequisites MATH 113; or concurrent enrollment. Taught Fall, Winter Programs Containing CE EN 270
Course Outcomes

### 01-compsci

Be able to utilize computer science concepts such as how information is stored in a computer in a digital format to calculate data size and data transfer rates.

### 02-caedm

Be able to utilize the full range of IT resources available to students in the BYU College of Engineering and Technology.

### 03-html

Be able to design and edit web pages in HTML format.

### 04-ppt

Be able to create sophisticated and professsional Microsoft Powerpoint presentations, including use of themes and animation.

### 05-word

Be able to use Microsoft Word to develop complex, lengthy technical documents, utilizing advanced features such as cross referencing and auto-generated tables of contents and figures.

### 06-excel

Be able to use the basic and advanced features in Microsoft Excel including formulas, relative vs. absolute referencing, naming cells, vlookup, IF function, validation, custom formatting, array formulas, charts, goal seek, and the Solver add-on to solve civil engineering problems.

### 07-macros

Be able to record and use macros to automate frequently-used tasks in Excel or to explore what VB code is associated with the task.

### 07-ranges

Be able to reference cells and ranges in VB to either extract information from cells or write information to cells.

### 08-controls

Be able to add controls to a spreadsheet and associate those controls with VB code.

### 09-msgbox

Be able to use the MsgBox and InputBox objects in VB to present information to users or to prompt for input.

### 10-objects

Be able to use objects in VB programming, including properties and methods and be able to explore and research new object classes when necessary.

### 11-ifthen

Be able to use IF statements and conditional expressions to control the flow of logic in VB code.

### 12-loops

Be able to use each of the looping strategies in VB to encode iterative programming logic.

### 13-arrays

Be able to allocate and use arrays in visual basic to process vectors, matrices, tables, and lists of data.

### 14-debug

Be able to use the debugging utilities in VB to identify and correct logical errors in your code.

### 15-functions

Be able to design and code custom functions in VB that can be called from Excel formulas or from other places in your VB code.

### 16-subs

Be able to develop custom subs to perform specific tasks in VB or modify subs created by recorded macros to make the macros powerful or applicable in a variety of applications.

### 17-events

Be able to trap on a variety of different types of events and execute VB code in response to those events.

### 18-strings

Be able to utilize the VB string functions in order to manipulate text.

### 19-forms

Be able to create custom forms and associate those forms with an excel workbook.