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: 22 Ana lays de la Table Encaje sien y tacle calder O Note: The CALCULATOR button must have loop instructions such as: "Do, while, for next, Do Until". You decide which one to use. OM 1 3. Submit the assignment using a PDF format in the Blackboard platform. It must include your, flowchart, pseudocodes, and VBA code. 4. Total points 30 5. The deadline for taking the assignment is indicated on Tool", which is located in Calendar in the Blackboard" platform. B C D 1 Price information 2 5% 3% 7% 3 Product code 4 C3972 5 C4758 6 L6332 7 P3064 8 07257 9 04218 10 J8639 11 A8218 12 13870 13 G3677 14 H1947 15 E4374 16 N2872 17 D5527 18 G4254 19 E7138 20 E8484 21 P4987 22 E6561 23 13293 24 K7486 25 H4300 26 C2112 27 M8300 28 B6342 29 W6149 30 A4419 31 M4455 32 G2954 33 L5609 34 W6726 35 R9610 36 S1956 37 15069 38 59033 39 B5765 40 D7568 41 A6918 42 P2341 43 G1920 44 06570 Unit cost $52 $110 $77 $65 $64 $53 $96 $110 $57 $55 $82 $72 $246 $137 $51 $77 $86 $93 $97 $86 $131 $106 $88 $62 $110 $113 $76 $96 $90 $111 $63 $105 $54 $56 $81 $108 $67 $82 $103 $74 $60 Minimum purchase quantity for discount Discount 20 7% 20 20 3% 5 3% 10 10 3% 10 3% 10 7% 5 7% 5 3% 5 5% 20 7% 5 7% 5 3% 10 3% 10 3% 10 10 5% 20 7% 5 5% 5 5% 20 3% 10 7% 10 5% 20 5% 10 3% 10 5% 20 7% 20 5 5% 10 3% 5 3% 5 5% 10 7% 5 3% 20 5% 10 5 5% 10 3% 5 5% 5 5% 5% 7% B C D 20 45 M6378 46 N4648 47 F4684 5% 3% 3% 5% 5 10 10 20 20 5 10 5% 7% 5% 7% 5 20 20 7% 7% 3% 5% 5% 7% 7% 5 10 20 10 5 5 20 20 5 3% 5% 3% 7% 3% 5 20 $87 $87 $124 $123 $64 $54 $141 $68 $176 $69 $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 $119 $126 $107 $228 $56 5% 7% 3% 3% 48 W5573 49 E5838 50 M6955 51 K9838 52 K2185 53 F2761 54 W4335 55 D1067 56 F5260 57 C2220 58 S6642 59 D6221 60 R1872 61 01680 62 R8949 63 H2376 64 C9873 65 G3529 66 02257 67 M7530 68 N8876 69 T2989 70 M6953 71 R1295 72 T5488 73 R2449 74 K9260 75 R6450 76 E4491 77 H4298 78 J2568 79 A2605 80 P1103 81 W3758 82 H4728 83 F7612 84 A8958 85 L3071 86 F7035 87 E3767 88 L7960 89 D4921 5 3% 10 10 10 20 5 7% 5% 5% 5 5 5 10 5% 7% 5% 3% 20 20 10 20 20 5% 7% 5% 3% 5% 5 5% 3% 5 3% 5 5 10 20 10 10 5% 3% 7% 5% 3% . 20 5 10 20 D 3% 5% 3% 3% 5% 5% 3% 5 10 5 20 5 20 20 3% 5 3% 7% 3% 7% 7% 3% 7% 10 10 5 3% 10 5 10 20 10 20 7% 3% 5% 3% B $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 $60 $123 $68 $60 $65 90 D9342 91 18921 92 S4573 93 A4380 94 C2650 95 N2687 96 13575 97 M6230 98 A4957 99 T7841 100 N9186 101 E5690 102 T7264 103 S3996 104 E8189 105 R5149 106 R9571 107 C9150 108 K7191 109 N6999 110 P6951 111 P9377 112 K7876 113 01532 114 C2649 115 A5533 116 P6878 117 G9991 118 A4956 119 W1688 120 G3491 121 T2841 122 N7263 123 E4452 124 M2493 125 K2301 126 M9570 127 J9606 128 D1495 129 11761 130 K2878 131 15761 5 5 10 5 10 5 3% 3% 5% 5% 7% 3% 7% 10 7% 10 10 10 20 7% 7% 3% 5% 5 10 10 10 5 20 10 7% 7% 7% 3% 3% 5% 7% 10 3% 5 10 5% 3% 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: 22 Ana lays de la Table Encaje sien y tacle calder O Note: The CALCULATOR button must have loop instructions such as: "Do, while, for next, Do Until". You decide which one to use. OM 1 3. Submit the assignment using a PDF format in the Blackboard platform. It must include your, flowchart, pseudocodes, and VBA code. 4. Total points 30 5. The deadline for taking the assignment is indicated on Tool", which is located in Calendar in the Blackboard" platform. B C D 1 Price information 2 5% 3% 7% 3 Product code 4 C3972 5 C4758 6 L6332 7 P3064 8 07257 9 04218 10 J8639 11 A8218 12 13870 13 G3677 14 H1947 15 E4374 16 N2872 17 D5527 18 G4254 19 E7138 20 E8484 21 P4987 22 E6561 23 13293 24 K7486 25 H4300 26 C2112 27 M8300 28 B6342 29 W6149 30 A4419 31 M4455 32 G2954 33 L5609 34 W6726 35 R9610 36 S1956 37 15069 38 59033 39 B5765 40 D7568 41 A6918 42 P2341 43 G1920 44 06570 Unit cost $52 $110 $77 $65 $64 $53 $96 $110 $57 $55 $82 $72 $246 $137 $51 $77 $86 $93 $97 $86 $131 $106 $88 $62 $110 $113 $76 $96 $90 $111 $63 $105 $54 $56 $81 $108 $67 $82 $103 $74 $60 Minimum purchase quantity for discount Discount 20 7% 20 20 3% 5 3% 10 10 3% 10 3% 10 7% 5 7% 5 3% 5 5% 20 7% 5 7% 5 3% 10 3% 10 3% 10 10 5% 20 7% 5 5% 5 5% 20 3% 10 7% 10 5% 20 5% 10 3% 10 5% 20 7% 20 5 5% 10 3% 5 3% 5 5% 10 7% 5 3% 20 5% 10 5 5% 10 3% 5 5% 5 5% 5% 7% B C D 20 45 M6378 46 N4648 47 F4684 5% 3% 3% 5% 5 10 10 20 20 5 10 5% 7% 5% 7% 5 20 20 7% 7% 3% 5% 5% 7% 7% 5 10 20 10 5 5 20 20 5 3% 5% 3% 7% 3% 5 20 $87 $87 $124 $123 $64 $54 $141 $68 $176 $69 $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 $119 $126 $107 $228 $56 5% 7% 3% 3% 48 W5573 49 E5838 50 M6955 51 K9838 52 K2185 53 F2761 54 W4335 55 D1067 56 F5260 57 C2220 58 S6642 59 D6221 60 R1872 61 01680 62 R8949 63 H2376 64 C9873 65 G3529 66 02257 67 M7530 68 N8876 69 T2989 70 M6953 71 R1295 72 T5488 73 R2449 74 K9260 75 R6450 76 E4491 77 H4298 78 J2568 79 A2605 80 P1103 81 W3758 82 H4728 83 F7612 84 A8958 85 L3071 86 F7035 87 E3767 88 L7960 89 D4921 5 3% 10 10 10 20 5 7% 5% 5% 5 5 5 10 5% 7% 5% 3% 20 20 10 20 20 5% 7% 5% 3% 5% 5 5% 3% 5 3% 5 5 10 20 10 10 5% 3% 7% 5% 3% . 20 5 10 20 D 3% 5% 3% 3% 5% 5% 3% 5 10 5 20 5 20 20 3% 5 3% 7% 3% 7% 7% 3% 7% 10 10 5 3% 10 5 10 20 10 20 7% 3% 5% 3% B $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 $60 $123 $68 $60 $65 90 D9342 91 18921 92 S4573 93 A4380 94 C2650 95 N2687 96 13575 97 M6230 98 A4957 99 T7841 100 N9186 101 E5690 102 T7264 103 S3996 104 E8189 105 R5149 106 R9571 107 C9150 108 K7191 109 N6999 110 P6951 111 P9377 112 K7876 113 01532 114 C2649 115 A5533 116 P6878 117 G9991 118 A4956 119 W1688 120 G3491 121 T2841 122 N7263 123 E4452 124 M2493 125 K2301 126 M9570 127 J9606 128 D1495 129 11761 130 K2878 131 15761 5 5 10 5 10 5 3% 3% 5% 5% 7% 3% 7% 10 7% 10 10 10 20 7% 7% 3% 5% 5 10 10 10 5 20 10 7% 7% 7% 3% 3% 5% 7% 10 3% 5 10 5% 3%