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.
Be able to utilize the full range of IT resources available to students in the BYU College of Engineering and Technology.
Be able to design and edit web pages in HTML format.
Be able to create sophisticated and professsional Microsoft Powerpoint presentations, including use of themes and animation.
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.
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.
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.
Be able to reference cells and ranges in VB to either extract information from cells or write information to cells.
Be able to add controls to a spreadsheet and associate those controls with VB code.
Be able to use the MsgBox and InputBox objects in VB to present information to users or to prompt for input.
Be able to use objects in VB programming, including properties and methods and be able to explore and research new object classes when necessary.
Be able to use IF statements and conditional expressions to control the flow of logic in VB code.
Be able to use each of the looping strategies in VB to encode iterative programming logic.
Be able to allocate and use arrays in visual basic to process vectors, matrices, tables, and lists of data.
Be able to use the debugging utilities in VB to identify and correct logical errors in your code.
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.
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.
Be able to trap on a variety of different types of events and execute VB code in response to those events.
Be able to utilize the VB string functions in order to manipulate text.
Be able to create custom forms and associate those forms with an excel workbook.