Cơ sở công nghệ thông tin UEH - đề ôn nhập liệu và bài thực hành 4

Question 1: Write a formula to determine the Faculty of the students in the main data tabl are the Majors codes and the Table 3 provides the Faculty Question 2: Write the formula to calculate the Scholarship Granted for each student in the Training Point *10 * 200000 VND + Scholarship based on GPA Scholarship based on GPA = 5000000 VND if student has GPA >= 8.5 Scholarship based on GPA = 4000000 VND if student has GPA >= 8.0 (and lo Scholarship based on GPA = 4000000 VND for the rest Provide a statistics table for table 3, showing the total amount of scholarships Filter students majoring International Business (Major code: KD) and trainin in the main data table, knowing that the fifth and sixth characters in the Code The criteria area is located in the yellow area, the filtered result has to be set b Question 3: Question 4: Table 3 Majors code DT KD KI KT LA MA NH NN NT PT QT TC TH TM VG Majors name Investment International Bussiness Auditing Accounting Law Marketing Banking Government Foreign Trade Economic Development Management Finance Information Technology Commerce Appraisal Student Code 31121021743 31121020125 31121021183 31121022363 31121021080 31121023453 31121020876 31121021527 31121021116 Class Code DH38DT002 DH38DT003 DH38KD001 DH38KD001 DH38KD001 DH38KD001 DH38KD001 DH38KD001 DH38KD001 Main data table Number Course 1 K.38 2 K.38 3 K.38 4 K.38 5 K.38 6 K.38 7 K.38 8 K.38 9 K.38 10 K.38 11 K.38 12 K.38 13 K.38 14 K.38 15 K.38 16 K.38 17 K.38 18 K.38 19 K.38 20 K.38 21 K.38 22 K.38 23 K.38 24 K.38 25 K.38 26 K.38 27 K.38 28 K.38 29 K.38 30 K.38 31 K.38 32 K.38 33 K.38 34 K.38 35 K.38 36 K.38 37 K.38 38 K.38 39 K.38 40 K.38 41 K.38 42 K.38 43 K.38 44 K.38 45 K.38 46 K.38 47 K.38 48 K.38 49 K.38 50 K.38 51 K.38 52 K.38 53 K.38 54 K.38 31121023249 31121022766 31121021306 31121022003 31121020333 31121021431 31121022327 31121023077 31121021870 31121021528 31121022643 31121023569 31121020763 31121022553 31121022412 31121021389 31121021735 31121022688 31121021562 31121022873 31121020593 31121021244 31121022149 31121021523 31121022962 31121020543 31121020572 31121021236 31121021082 31121023187 31121022898 31121021506 31121020183 31121021307 31121020445 31121021617 31121021374 31121022560 31121023273 31121022056 31121022244 31121020944 31121020438 31121023001 31121023601 DH38KD002 DH38KD002 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI001 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KI002 DH38KT001 DH38KT002 DH38KT002 DH38KT002 DH38KT002 DH38KT002 DH38KT004 DH38KT004 DH38KT005 55 K.38 56 K.38 57 K.38 58 K.38 59 K.38 60 K.38 61 K.38 62 K.38 63 K.38 64 K.38 65 K.38 66 K.38 67 K.38 68 K.38 69 K.38 70 K.38 71 K.38 72 K.38 73 K.38 74 K.38 75 K.38 76 K.38 77 K.38 78 K.38 79 K.38 80 K.38 81 K.38 82 K.38 83 K.38 84 K.38 85 K.38 86 K.38 87 K.38 88 K.38 89 K.38 90 K.38 91 K.38 92 K.38 93 K.38 94 K.38 95 K.38 96 K.38 97 K.38 98 K.38 99 K.38 31121022494 31121022458 31121021215 31121021089 31121023574 31121020053 31121020777 31121021448 31121020413 31121022314 31121021568 31121022229 31121022672 31121022208 31121020546 31121021378 31121022558 31121022654 31121021124 31121022787 31121020693 31121021333 31121022693 31121021043 31121023303 31121021160 31121020078 31121021280 31121021647 31121020786 31121022623 31121021699 31121020816 31121022859 31121020190 31121021622 31121022735 31121021391 31121020592 31121022286 31121020967 31121021981 31121022121 31121022322 31121022197 DH38KT006 DH38KT007 DH38KT007 DH38KT008 DH38KT008 DH38KT008 DH38KT010 DH38KT010 DH38KT011 DH38KT011 DH38KT011 DH38KT013 DH38KT015 DH38LA001 DH38MA001 DH38MA001 DH38MA001 DH38MA001 DH38MA001 DH38MA001 DH38MA002 DH38MA002 DH38MA002 DH38MA003 DH38MA003 DH38MA003 DH38MA003 DH38NH001 DH38NH001 DH38NH001 DH38NH002 DH38NH003 DH38NH004 DH38NH004 DH38NH006 DH38NH006 DH38NH007 DH38NH008 DH38NH009 DH38NH009 DH38NN001 DH38NN001 DH38NN002 DH38NN003 DH38NT001 100 K.38 101 K.38 102 K.38 103 K.38 104 K.38 105 K.38 106 K.38 107 K.38 108 K.38 109 K.38 110 K.38 111 K.38 112 K.38 113 K.38 114 K.38 115 K.38 116 K.38 117 K.38 118 K.38 119 K.38 120 K.38 121 K.38 122 K.38 123 K.38 124 K.38 125 K.38 126 K.38 127 K.38 128 K.38 129 K.38 130 K.38 131 K.38 132 K.38 133 K.38 134 K.38 135 K.38 136 K.38 137 K.38 138 K.38 139 K.38 140 K.38 141 K.38 142 K.38 143 K.38 144 K.38 31121021039 31121021032 31121022083 31121022323 31121020369 31121022335 31121021170 31121021338 31121022418 31121023188 31121022156 31121022390 31121022201 31121020915 31121020026 31121022509 31121020617 31121020857 31121022279 31121021595 31121020005 31121021708 31121020412 31121022786 31121021928 31121022687 31121022878 31121022676 31121023062 31121022843 31121022567 31121021947 31121022976 31121021398 31121022966 31121022355 31121023060 31121022581 31121023588 31121022645 31121021690 31121023397 31121021178 31121021226 31121022743 DH38NT001 DH38NT001 DH38NT001 DH38NT001 DH38NT001 DH38NT001 DH38NT001 DH38NT001 DH38NT001 DH38NT002 DH38NT002 DH38NT002 DH38NT002 DH38NT002 DH38NT002 DH38NT002 DH38NT002 DH38NT002 DH38NT002 DH38NT002 DH38NT002 DH38NT002 DH38NT002 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38NT003 DH38PT001 DH38QT001 DH38QT002 DH38QT003 145 K.38 146 K.38 147 K.38 148 K.38 149 K.38 150 K.38 151 K.38 152 K.38 153 K.38 154 K.38 155 K.38 156 K.38 157 K.38 158 K.38 159 K.38 160 K.38 161 K.38 162 K.38 163 K.38 164 K.38 165 K.38 166 K.38 167 K.38 168 K.38 169 K.38 170 K.38 171 K.38 172 K.38 173 K.38 174 K.38 175 K.38 176 K.38 177 K.38 178 K.38 179 K.38 180 K.38 181 K.38 182 K.38 183 K.38 184 K.38 185 K.38 186 K.38 187 K.38 188 K.38 189 K.38 31121020340 31121020889 31121020807 31121022009 31121021977 31121021588 31121020070 31121020740 31121021173 31121022557 31121021404 31121022094 31121020684 31121023196 31121020582 31121023392 31121022738 31121020387 31121022130 31121021607 31121022206 31121022091 31121021681 31121022189 31121021582 31121022857 31121022231 31121020491 31121022058 31121021026 31121022443 31121020348 31121022060 31121020341 31121020589 31121022069 31121021022 31121020275 31121021033 31121021176 31121020797 31121023014 31121023055 31121020339 31121020576 DH38QT005 DH38QT007 DH38QT007 DH38QT007 DH38TC001 DH38TC001 DH38TC001 DH38TC001 DH38TC001 DH38TC001 DH38TC001 DH38TC001 DH38TC001 DH38TC001 DH38TC001 DH38TC002 DH38TC002 DH38TC002 DH38TC002 DH38TC002 DH38TC002 DH38TC002 DH38TC003 DH38TC003 DH38TC003 DH38TC003 DH38TC003 DH38TC004 DH38TC004 DH38TC004 DH38TC004 DH38TC004 DH38TC004 DH38TC004 DH38TC004 DH38TC004 DH38TC004 DH38TC004 DH38TC004 DH38TC004 DH38TC005 DH38TC005 DH38TC005 DH38TC005 DH38TC005 190 K.38 191 K.38 192 K.38 193 K.38 194 K.38 195 K.38 196 K.38 197 K.38 198 K.38 199 K.38 200 K.38 201 K.38 202 K.38 203 K.38 204 K.38 205 K.38 206 K.38 207 K.38 208 K.38 209 K.38 210 K.38 211 K.38 212 K.38 213 K.38 214 K.38 215 K.38 216 K.38 217 K.38 218 K.38 219 K.38 220 K.38 221 K.38 222 K.38 223 K.38 224 K.38 225 K.38 226 K.38 227 K.38 228 K.38 229 K.38 230 K.38 231 K.38 232 K.38 233 K.38 234 K.38 31121020400 31121022753 31121023311 31121023376 31121020629 31121022570 31121022524 31121021901 31121020579 31121021896 31121020654 31121020586 31121020952 31121021184 31121021605 31121020505 31121020045 31121020591 31121023415 31121021203 31121020448 31121022765 31121021432 31121021666 31121021185 31121021362 31121023479 31121022597 31121020697 31121022036 31121022071 31121021286 31121020249 31121023264 31121021500 31121021703 31121023418 31121022870 31121021827 31121020989 31121020453 31121021301 31121021322 31121020835 31121022977 DH38TC006 DH38TC006 DH38TC006 DH38TC006 DH38TC006 DH38TC006 DH38TC006 DH38TC006 DH38TC006 DH38TC006 DH38TC006 DH38TC006 DH38TC007 DH38TC007 DH38TC007 DH38TC007 DH38TC007 DH38TC007 DH38TC007 DH38TC007 DH38TC008 DH38TC008 DH38TC008 DH38TC008 DH38TC008 DH38TC008 DH38TC008 DH38TC008 DH38TC009 DH38TC009 DH38TC009 DH38TC009 DH38TC009 DH38TC009 DH38TC009 DH38TC009 DH38TC009 DH38TC009 DH38TC009 DH38TC009 DH38TH001 DH38TM001 DH38TM001 DH38TM003 DH38TM003