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.