Question: Assignment 2- Learning Objectives: At the end of this assignment, students should be able to: Use the three control structures to design VBA programs and
Assignment 2- Learning Objectives: At the end of this assignment, students should be able to: Use the three control structures to design VBA programs and graphically model the logic flow using UML Write VBA code that uses all three types of control structures. Instructions: This is an individual assignment. Submit the entire assignment as a single PDF file. Background: In Lab 4, we created a user form to take three integer inputs and the calculation mode, perform calculation, and display result. In Lecture on Monday, 2/19/2018, we discussed the approaches to interact with data in Excel: retrieving data from Excel and fill them into the user form, performing calculation, and storing result in Excel. Task: Develop a graphical model using UML diagrams for the program: chaining the sequential, selection, and repetition structures into a single program. Note that you are allowed to use the initial state (solid circle) and final state (solid circle ina hollow circle) many times, e.g., use the final state to indicate the completion of a control structure, and then use an arrow connecting it to the initial state of a second control structure. Deliverable: A single PDF file of your UML model
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
