Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Objective: This activity has the purpose of helping students to codify For loops and Do loops (Objective 4). Student Instructions: 1. After studying the control

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Objective: This activity has the purpose of helping students to codify For loops and Do loops (Objective 4). Student Instructions: 1. After studying the control logic and Loops, take the following assignment. 2. Download the Excel file DATA with the form of "Analysis Table". In this form there are 4 options, you must program each option on the calculate button and the same must tell which option you chose the user and present the result in the "Listbox". The reset button must clear the list for other user options. See the picture below: EM Anlaya de Table Encaje clonytece cevi Note: The CALCULATOR button must have loop instructions such as: "Do, while, for next, Do Until". You decide which one to use. lett Delta entai ara s hmi 3. Submit the assignment using a PDF format in the Blackboard platform. It must include your, flowchart, pseudocodes, and VBA code. 1 Price information N w Minimum purchase quantity for discount Discount Unit cost $52 $110 7 $53 $110 Product code C3972 C4758 6 L6332 P3064 C7257 9 04218 1018639 11 A8218 13870 G3677 14 H1947 E4374 16 N2872 D5527 G4254 19 E7138 E8484 P4987 E6561 23 13293 K7486 25 H4300 26 02112 M8300 B6342 $72 $246 $137 17 $86 $131 $106 $88 $62 $110 $113 $76 $96 $90 $111 W6149 A4419 M4455 G2954 L5609 W6726 R9610 $1956 34 $63 $105 $54 15069 $56 59033 $81 B5765 $108 $67 D7568 A6918 P2341 $82 $103 F $87 $124 $123 $64 $54 $141 $68 $176 $69 43 G1920 44 06570 45 M6378 46 N4648 47 F4684 48 W5573 49 E5838 50 M6955 51 K9838 K2185 53 F2761 54 W4335 55 01067 56 F5260 57 C2220 58 56642 59 06221 60 R1872 61 01680 62 R8949 63 H2376 64 09873 65 G3529 66 02257 67 M7530 68N8876 69 T2989 70 M6953 71 R1295 72 15488 73 R2449 74 K9260 75 R6450 7664491 77 H4298 78 J2568 79 A2605 80 P1103 81 W3758 82 H4728 83 7612 84 A8958 $147 $86 $66 $85 $91 $106 $69 $74 $192 $65 $52 $187 $50 $127 $81 $179 $86 $83 $68 $144 $62 $102 $71 $113 $96 $63 $54 $66 $105 $121 85 13071 86 F7035 87 83767 88 L7960 89 D4921 9009342 91 18921 9254573 93 A4380 94 C2650 95 N2687 96 13575 97 M6230 A4957 9977841 100 N9186 101 E5690 102 77264 103 S3996 104 E8189 105 R5149 106 R9571 09150 108 K7191 109 N6999 110 P6951 111 P9377 112 K7876 113 01532 114 C2649 115A5533 116 P6878 117 G9991 118 A4956 119 W1688 120 63491 121 12841 122 N7263 123 E4452 124 M2493 125 K2301 126 M9570 $119 $126 $107 $228 $56 $221 $74 $151 $58 $141 $123 $113 $154 $75 $141 $64 $90 $100 $146 $81 $102 $136 $90 $72 $108 $109 $190 $61 $107 $64 $50 $116 $55 $120 $51 $196 $87 $120 $132 $177 $92 $99 127 9606 128 01495 129 11761 130 K2878 131 15761 $123 $68 $60 $65 Objective: This activity has the purpose of helping students to codify For loops and Do loops (Objective 4). Student Instructions: 1. After studying the control logic and Loops, take the following assignment. 2. Download the Excel file DATA with the form of "Analysis Table". In this form there are 4 options, you must program each option on the calculate button and the same must tell which option you chose the user and present the result in the "Listbox". The reset button must clear the list for other user options. See the picture below: EM Anlaya de Table Encaje clonytece cevi Note: The CALCULATOR button must have loop instructions such as: "Do, while, for next, Do Until". You decide which one to use. lett Delta entai ara s hmi 3. Submit the assignment using a PDF format in the Blackboard platform. It must include your, flowchart, pseudocodes, and VBA code. 1 Price information N w Minimum purchase quantity for discount Discount Unit cost $52 $110 7 $53 $110 Product code C3972 C4758 6 L6332 P3064 C7257 9 04218 1018639 11 A8218 13870 G3677 14 H1947 E4374 16 N2872 D5527 G4254 19 E7138 E8484 P4987 E6561 23 13293 K7486 25 H4300 26 02112 M8300 B6342 $72 $246 $137 17 $86 $131 $106 $88 $62 $110 $113 $76 $96 $90 $111 W6149 A4419 M4455 G2954 L5609 W6726 R9610 $1956 34 $63 $105 $54 15069 $56 59033 $81 B5765 $108 $67 D7568 A6918 P2341 $82 $103 F $87 $124 $123 $64 $54 $141 $68 $176 $69 43 G1920 44 06570 45 M6378 46 N4648 47 F4684 48 W5573 49 E5838 50 M6955 51 K9838 K2185 53 F2761 54 W4335 55 01067 56 F5260 57 C2220 58 56642 59 06221 60 R1872 61 01680 62 R8949 63 H2376 64 09873 65 G3529 66 02257 67 M7530 68N8876 69 T2989 70 M6953 71 R1295 72 15488 73 R2449 74 K9260 75 R6450 7664491 77 H4298 78 J2568 79 A2605 80 P1103 81 W3758 82 H4728 83 7612 84 A8958 $147 $86 $66 $85 $91 $106 $69 $74 $192 $65 $52 $187 $50 $127 $81 $179 $86 $83 $68 $144 $62 $102 $71 $113 $96 $63 $54 $66 $105 $121 85 13071 86 F7035 87 83767 88 L7960 89 D4921 9009342 91 18921 9254573 93 A4380 94 C2650 95 N2687 96 13575 97 M6230 A4957 9977841 100 N9186 101 E5690 102 77264 103 S3996 104 E8189 105 R5149 106 R9571 09150 108 K7191 109 N6999 110 P6951 111 P9377 112 K7876 113 01532 114 C2649 115A5533 116 P6878 117 G9991 118 A4956 119 W1688 120 63491 121 12841 122 N7263 123 E4452 124 M2493 125 K2301 126 M9570 $119 $126 $107 $228 $56 $221 $74 $151 $58 $141 $123 $113 $154 $75 $141 $64 $90 $100 $146 $81 $102 $136 $90 $72 $108 $109 $190 $61 $107 $64 $50 $116 $55 $120 $51 $196 $87 $120 $132 $177 $92 $99 127 9606 128 01495 129 11761 130 K2878 131 15761 $123 $68 $60 $65

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions