Your task must include the following: You can build on your effort from a previous week or tackle a new challenge. approval from your instructor for your items by sending a Private Message. a 1/2-page Word document, including the following: a Visual Logic file to execute the task. all the files in a single folder structure you zip into a single file to submit. a zip file containing all files using the Assignment Files tab. a task that a program could perform over an array of items that would be used by a small business. Your task must include the following: You can build on your effort from a previous week or tackle a new challenge. a Visual Logic file to execute the task. an Excel Macro to execute that accomplishes the same calculation task as the Visual Logic file. all the files in a single folder structure you zip into a single file to submit. a zip file containing the Visual Logic file and the Excel file with macros using the Assignments Files tab Purchase the answer to view it Purchase the answer to view it

Visual Logic is a programming language that allows users to create flowcharts and simulate the execution of a program. It is often used as a teaching tool in introductory computer science courses to help students understand the logic behind program execution. In this assignment, you are required to create a Visual Logic file that executes a task involving an array of items that would be used by a small business. Additionally, you need to create an Excel Macro that accomplishes the same calculation task as the Visual Logic file.

To begin, you will need to choose a task that a program could perform over an array of items. This task should be something that would be relevant to a small business, such as calculating the total sales for a given period or finding the average salary of employees. Once you have identified the task, you can start building your Visual Logic file.

In your Visual Logic file, you will need to define the array of items that your program will be working with. This can be done using the “Declare Array” statement, where you specify the name of the array and its size. Next, you will need to populate the array with the relevant data. This can be done using a loop that prompts the user for input and stores it in the array.

Once you have the array set up, you can begin implementing the logic to perform the desired task. This may involve iterating over the array using a loop and performing calculations or comparisons on each item. The specific details will depend on the task you have chosen.

In addition to the Visual Logic file, you will also need to create an Excel Macro that accomplishes the same task. This can be done using Visual Basic for Applications (VBA), which is the programming language used in Excel macros. The logic and structure of the macro should be similar to the Visual Logic file, although the syntax and specific commands will be different.

Finally, you will need to organize all the files into a single folder structure and zip them into a single file for submission. This will make it easier for your instructor to review your work. You can use any file compression tool to create the zip file, such as WinZip or 7-Zip.

Overall, this assignment will require you to demonstrate your understanding of flowcharting and programming concepts in both Visual Logic and Excel macros. By successfully completing this task, you will gain practical experience in simulating program execution and learn how to apply programming concepts to real-world scenarios.