MIDTERM MIS 3371 SPRING 2020 PARKS

1,Bill Gates,United States,59,79.20,Microsoft; 2,Carlos Slim Helu,Mexico,75,77.10,Telecom; 3,Warren Buffett,United States,84,72.70,Berkshire Hathaway; 4,Amancio Ortega,Spain,78,64.50,Zara; 5,Larry Ellison,United States,70,54.30,Oracle; 6,Charles Koch,United States,79,42.90,Diversified; 6,David Koch,United States,74,42.90,Diversified; 8,Christy Walton,United States,60,41.70,Wal-Mart; 9,Jim Walton,United States,67,40.60,Wal-Mart; 10,Liliane Bettencourt,France,92,40.10,L'Oreal; 11,Alice Walton,United States,65,39.40,Wal-Mart; 12,S. Robson Walton,United States,71,39.10,Wal-Mart; 13,Bernard Arnault,France,66,37.20,LVMH; 14,Michael Bloomberg,United States,73,35.50,Bloomberg LP; 15,Jeff Bezos,United States,51,34.80,Amazon.com; 16,Mark Zuckerberg,United States,30,33.40,Facebook; 17,Li Ka-shing,Hong Kong,86,33.30,Diversified; 18,Sheldon Adelson,United States,81,31.40,Casinos; 19,Larry Page,United States,41,29.70,Google; 20,Sergey Brin,United States,41,29.20,Google; 21,Georg Schaeffler,Germany,50,26.90,Ball bearings; 22,Forrest Mars, United States,83,26.60,Candy; 22,Jacqueline Mars,United States,75,26.60,Candy; 22,John Mars,United States,78,26.60,Candy; 25,David Thomson,Canada,57,25.50,Media; 26,Jorge Paulo Lemann,Brazil,75,25.00,Beer; 27,Lee Shau Kee,Hong Kong,87,24.80,Real estate; 28,Stefan Persson,Sweden,67,24.50,H&M; 29,George Soros,United States,84,24.20,Hedge funds; 29,Wang Jianlin,China,60,24.20,Real Estate; 31,Carl Icahn,United States,79,23.50,Investments; 32,Maria Franca Fissolo,Italy,97,23.40,Nutella chocolates; 33,Jack Ma,China,50,22.70,E-commerce; 34,Prince Alwaleed Bin Talal Alsaud,Saudi Arabia,59,22.60,Investments; 35,Steve Ballmer,United States,58,21.50,Microsoft; 35,Phil Knight,United States,77,21.50,Nike; 37,Beate Heister & Karl Albrecht Jr.,Germany,n/a,21.30,Supermarkets; 38,Li Hejun,China,47,21.10,Solar power equipment; 39,Mukesh Ambani,India,57,21.00,Petrochemicals oil & gas; 40,Leonardo Del Vecchio,Italy,79,20.40,Eyeglasses; 41,Len Blavatnik,United States,57,20.20,Diversified; 41,Tadashi Yanai,Japan,66,20.20,Retail; 43,Charles Ergen,United States,62,20.10,Dish Network; 44,Dilip Shanghvi,India,59,20.00,Pharmaceuticals; 45,Laurene Powell Jobs,United States,51,19.50,Apple Disney; 46,Dieter Schwarz,Germany,75,19.40,Retail; 47,Michael Dell,United States,50,19.20,Dell; 48,Azim Premji,India,69,19.10,Software; 49,Theo Albrecht,Germany,64,19.00,Aldi Trader Joe's; 50,Michael Otto,Germany,71,18.10,Retail real estate; 51,Paul Allen,United States,62,17.50,Microsoft investments; 52,Joseph Safra,Brazil,76,17.30,Banking; 53,Anne Cox Chambers,United States,95,17.00,Media; 54,Susanne Klatten,Germany,52,16.80,BMW pharmaceuticals; 55,Pallonji Mistry,Ireland,85,16.30,Construction; 56,Ma Huateng,China,43,16.10,Internet media; 57,Patrick Drahi,France,51,16.00,Telecom; 58,Thomas & Raymond Kwok,Hong Kong,n/a,15.90,Real estate; 59,Stefan Quandt,Germany,48,15.60,BMW; 60,Ray Dalio,United States,65,15.40,Hedge funds; 60,Vladimir Potanin,Russia,54,15.40,Metals; 62,Serge Dassault,France,89,15.30,Aviation; 62,Robin Li,China,46,15.30,Internet search; 64,Donald Bren,United States,82,15.20,Real estate; 65,Francois Pinault,France,78,14.90,Retail; 66,Shiv Nadar,India,69,14.80,Information technology; 67,Aliko Dangote,Nigeria,57,14.70,Cement sugar flour; 68,Mikhail Fridman,Russia,50,14.60,Oil banking telecom; 69,Hinduja brothers,United Kingdom,n/a,14.50,Diversified; 69,Ronald Perelman,United States,72,14.50,Leveraged buyouts; 71,Cheng Yu-tung,Hong Kong,89,14.40,Diversified; 71,Alisher Usmanov,Russia,61,14.40,Steel mining telecom investments; 73,Henry Sy,Philippines,90,14.20,Diversified; 73,Viktor Vekselberg,Russia,57,14.20,Metals energy; 75,Masayoshi Son,Japan,57,14.10,Internet telecom; 76,James Simons,United States,76,14.00,Hedge funds; 77,German Larrea Mota Velasco,Mexico,61,13.90,Mining; 77,Rupert Murdoch,United States,83,13.90,Media; 77,Johanna Quandt,Germany,88,13.90,BMW; 80,David & Simon Reuben,United Kingdom,72,13.70,Investments real estate; 81,Dhanin Chearavanont,Thailand,75,13.60,Food; 82,Iris Fontbona,Chile,72,13.50,Mining; 82,Lui Che Woo,Hong Kong,85,13.50,Casinos; 82,Lakshmi Mittal,India,64,13.50,Steel; 85,Abigail Johnson,United States,53,13.40,Money management; 85,Luis Carlos Sarmiento,Colombia,82,13.40,Banking; 87,Lei Jun,China,45,13.20,Smartphones; 87,Charoen Sirivadhanabhakdi,Thailand,70,13.20,Beverages; 89,Alexey Mordashov,Russia,49,13.00,Steel investments; 89,Marcel Herrmann Telles,Brazil,65,13.00,Beer; 91,Gerald Cavendish Grosvenor,United Kingdom,63,12.60,Real estate; 92,Hans Rausing,Sweden,88,12.50,Packaging; 92,Jack Taylor,United States,92,12.50,Enterprise Rent-A-Car; 94,Charles Butt,United States,77,12.30,Supermarkets; 94,Gina Rinehart,Australia,61,12.30,Mining; 96,Vagit Alekperov,Russia,64,12.20,Lukoil; 96,Harold Hamm,United States,69,12.20,Oil & gas; 96,Patrick Soon-Shiong,United States,63,12.20,Pharmaceuticals; 99,Stefano Pessina,Italy,73,12.10,Drugstores; 100,Richard Kinder,United States,70,12.00,Pipelines; 100,Elon Musk,United States,43,12.00,Tesla Motors; 100,Stephen Schwarzman,United States,68,12.00,Investments

1. (50 points) The textarea named ta1 shown to the left is in a form named f1. It contains contains the 2015 Top 100 billionaires (from here). For each person, the following data is shown:     Rank followed by a comma     Name followed by a comma     Citizenship followed by a comma     Age followed by a comma     Net Worth USD billion followed by a comma     Source(s) of wealth followed by a semicolon (except for the last one) Write the javascript function named p1() that:     1. Retrieves the data from the textarea ta1     2.Creates a 100 row by 6 column table containing the data.         [ Use NO column headings for the table ].     3. Calculates the average age     4. Calculates the average net worth     5. Counts the number of billionaires from the US     6. Places the table and items 3→5 above in the DIV block with id="p1_out". CAUTION: some values of Age are shown as "n/a". Skip these ages in your calculations. this is the DIV block with id="p1_out" Show NO HTML. Show only the javascript for p1.

My Core GPA Calculator  Hrs   Course  Grade   Course  Grade   Communication  6  Mathematics 3    Sciences 6  Philosophy 3    Arts 3    History 6  Politics 6  Psychology 3    Writing 3   My CORE GPA is SPAN with id="s1" based on SPAN with id="s2" hours SPAN with id="s3"

2. (50 points) The application shown to the left is used to calculate the student's grade point average (GPA). There are thirteen core courses shown. For each course there are two text boxes where the user can enter information about each course. There are thirteen text boxes in the two 'Course' columns for entering the 8 character course number (HTML elements 0,2,4,6,...). There are thirteen text boxes (HTML elements 1,3,5,7,...) for recording the 'Grade' values to the right of each 'Course'. All the textboxes are in a form named f2. The GPA is calculated by accumulating grade points for each of the thirteen grades: A grade of "A" is worth 4 grade points A grade of "B" is worth 3 grade points A grade of "C" is worth 2 grade points A grade of "D" is worth 1 grade points A grade of "F" is worth 0 grade points The student's gpa is the sum of all the grade points earned divided by the number of courses with grades assigned. Empty 'Grade' textboxes are not used in the gpa calculation. For example, if there are only 11 textboxes that have grades, then the calculated gpa is the sum of the eleven grade point values divided by 11.

When the user enters the data, and clicks on the "Calculate My CORE GPA" button, the function named p2() should:     (a) Calculate the students GPA by:         1. Assigning 4 grade points for each "A", 3 grade points for each "B", 2 grade points a for each "C" etc.         2. Dividing the total grade points by the number of grades, yielding the calculated gpa value.     (b) In the SPAN block with id="s1", place the calculated gpa using the .toFixed(2) method.     (c) In the SPAN block with id="s2", place the total number of hours taken (NOT NUMBER OF COURSES TAKEN).     (d) In the SPAN block with id="s3", place the five grades and the number of times each grade occurred The textbox values are referenced using: document.f2.elements[ i ].value where i is 0 → 25 Use this array:   var gc = [0,0,0,0,0]; for the counts of each grade Use this array:   var letters = ["A","B","C","D","F"]; inside your loops for grade values All classes are 3 hours. Show NO HTML. Show only the javascript for p2.