Posted: December 6th, 2016

Create an Excel Macro to execute that accomplishes the same calculation task as the Visual Logic file.

Select two tasks a program could perform that would be useful to a small business.

Each task must include the following:

• A conditional step
• Some form of iteration

Example tasks include the following:

• Entering a number of items and calculating sales tax on a sale; include a step offering a warranty for each item
• Converting from Fahrenheit to Celsius or the reverse over temperatures for several days
• Figuring out a total bulk sale price based on price per unit and number of units

These items may build on the tasks used in your Week Two assignment or may be unique.

Obtain approval from your instructor for your items by sending a Private Message.

Create a 1/2-page Word document for each of the tasks. Each document should include:

• A brief description of the task
• The pseudocode associated with the task. Base the pseudocode on the examples provided in Chs. 4, 5, and 6 of Prelude to Programming.

Create Visual Logic^® files to execute each of the tasks.

Save all files in a single folder structure you zip into a single file to submit.

Submit the zip file containing all files using the Assignments Files tab.

OR:

Select a single task a program could perform that would be useful to a small business.

The task must include the following:

• A conditional step
• Some form of iteration

Example tasks include the following:

• Entering a number of items and calculating sales tax on a sale; include a step offering a warranty for each item
• Converting from Fahrenheit to Celsius or the reverse over temperatures for several days
• Figuring out a total bulk sale price based on price per unit and number of units

These items may build on the tasks used in your Week Two assignment or may be unique.

Create a Visual Logic^® file to execute the task.

Create an Excel Macro to execute that accomplishes the same calculation task as the Visual Logic file.

Save all files in a single folder structure you zip into a single file to submit.

Submit a zip file containing the Visual Logic file and the Excel file with macros using the Assignments Files tab