Unit Two

Students will understand the fundamental building blocks of all programming languages: variables, arrays, conditionals, loops, and functions
Students will understand how to create simple VBA macros to trigger pop ups and change cell values
Students will gain practice in writing VBA subroutines that utilize variables and conditionals
Students will begin to develop their essential coding skills of syntax recollection, pattern recognition, problem decomposition, and debugging

Students will understand the basic syntax of a VBA for loop
Students will understand how to utilize for-loops in conjunction with conditionals to direct logic flow
Students will understand the value of a nested for-loop and gain basic proficiency in their use
Students will refine their fundamental coding skills (syntax recollection, pattern recognition, problem decomposition, and debugging)

Students will be comfortable formatting spreadsheets using VBA code
Students will understand how to loop through a table using VBA code and check for changes in values

Last updated on Sep 9, 2018