IND 2010 - Logic Development and Computer Programming for Engineers

• Facilitate the development of process flow documentation including process diagrams, traditional flow charts, pseudo-code, and hierarchical charts, and effectively communicate them
• Demonstrate spreadsheet understanding in the and execution of and use of descriptive statistics, analysis tools, lookup functions, pivot tables, and iterative structures
• Utilize Power BI to produce managerial reports
• Demonstrate VBA programming and logic execution utilizing macro recording, logic and conditional operators, procedures and subroutines, object models, strings, loops, forms, and error handling
• Demonstrate understanding and execution of the SQL language to query and access data from various databases

• Second level calculus

• Process mapping
• Flow diagrams
• Hierarchy diagrams
• Programming process
• Excel basics (formatting, hiding/freezing, filtering/sorting, subtotaling, V/HLOOKUps, pivot tables, conditionals and conditional formatting, time, basic graphing) and “programming” (with an example of a DSS)
• Relevant software programming languages such as: Visual Basic for Applications (basics, macros, VBA hierarchy, statements, declarations, compiler options, constants, variables, message boxes and strings, logical operators, conditionals and branching-IF/THEN/ELSE/ELSEIF etc., looping, basic debugging techniques, linked subroutines and function procedures, basic DOT programming

• A weekly two-hour lab will use defined projects to exercise student skills as defined in the Course Learning Outcomes section