Outcomes
In order to successfully complete this course, the student will:
1. Import data into data table and format and manipulate data in data tables in spreadsheets
2. Create formulas using both built-in and user defined functions to format, manipulate or perform calculations on data stored in data tables in spreadsheets
3. Create conditional expressions to format, manipulate or perform calculations on data tables in spreadsheets
4. Create x-y scatter plots using a spreadsheet, choosing correct scale and labels. Create interactive graphs and control the format of those graphs using a spreadsheet. Use parametric equations to generate charts using a spreadsheet
5. Apply various regression models to data tabulated in spreadsheets. Create graphs including regression models using a spreadsheet
6. Apply solvers and other tools to solve systems of equations or fit data to equations using a spreadsheet
7. Import data into data structures in code written in a structured programming language
8. Create formulas using built-in and user-defined functions to manipulate or perform calculation on data stored in a data structure or data file using code written in a structured programming language
9. Create conditional expressions and use logical operators to control the execution of code written in a structured programming language
10. Create 2D and 3D plots and subplots using code written in a structured programming language, choosing the correct scale and labels. Create interactive graphs and control the format of those graphs using a spreadsheet. Use parametric equations to generate charts using a structured programming language
11. Apply various regression models to data stored in data structures and files. Create graphs including regression models using a structured programming language
12. Use flowcharts and pseudo code to design and direct the creation of structured programs
13. Apply if/else, switch-case, selection structures, for loops, while loops, and repetition structures to create code to solve problems useful to engineering students in a structured programming language