ACTIVITIES 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 INSTRUCTION Task 1: STANDARDIZING THE DATASET Populate the FULLNAME consisting of the following fields ONLY, in the prescribed format: PREFIX FIRSTNAME LASTNAME. (Note: All the UPPERCASE) Generate EMAIL ADDRESS for those members, who speak English, in the prescribed format : lastname.firstname@cmcnow.org. (Note: All lowercase) Generate the USER NAME for only those members, who don't speak English, in the prescribed format : FIRSTNAME(Initial in Uppercase)LASTNAME(lowercase)COUNTRYCODE.INDEX CONVERT only the Columns 2, 10 and 11 to NUMERICAL values. (NO FORMULAS MUST BE VISIBLE.) THIS IS A GOOD TIME TO VERIFY YOU HAVE MET THE FOLLOWING OBJECTIVES : A. All members who speak English, have an email address? B. All members who don't speak English, have a user name? C. No members have both an email address and a user name? TASK 2: CONVERSIONS Col.13 has the members' height in CENTIMETERS. Jennifer needs it converted to INCHES in column 25, rounded to ONE significant digit. ( Note: 1 cm = 0.3937007874 inch. ) Col.14 has the members' weight in KILOGRAMS. Jennifer needs it converted to POUNDS in column 26, rounded to TWO significant digit. ( Note: 1 Kg = 2.2046226218 Lbs. ) Using data computed in Col.25 and Col.26, calculate CMC-SCORE in Col.27 using the formula : 703 x Weight [ LBS] / ( Height [ INCH]^2 ). Ensure that the is ROUNDED to from one significant digit after decimal. Using data computed in Col.27, usecalculated ...
Purchase document to see full attachment