EXAM 1 ANSWERS MIS 3371 Summer 2017 Parks

WORLD CHESS FEDERATION TOP 100 PLAYERS

1;Carlsen, Magnus;NOR;2822;1990*
2;Kramnik,Vladimir;RUS;2812;1975*
3;So, Wesley;USA;2810;1993*
4;Aronian,Levon;ARM;2809;1982*
5;Caruana,Fabiano;USA;2807;1992*
6;Mamedyarov, Shakhriyar;AZE;2800;1985*
7;Nakamura, Hikaru;USA;2792;1987*
8;Vachier-Lagrave, Maxime;FRA;2791;1990*
9;Anand, Viswanathan;IND;2783;1969*
10;Ding, Liren;CHN;2781;1992*
11;Giri, Anish;NED;2775;1994*
12;Karjakin, Sergey;RUS;2773;1990*
13;Grischuk, Alexander;RUS;2761;1983*
14;Yu, Yangyi;CHN;2753;1994*
15;Svidler, Peter;RUS;2749;1976*
16;Topalov, Veselin;BUL;2749;1975*
17;Nepomniachtchi, Ian;RUS;2742;1990*
18;Dominguez Perez, Leinier;CUB;2739;1983*
19;Eljanov, Pavel;UKR;2739;1983*
20;Wei, Yi;CHN;2738;1999*
21;Navara, David;CZE;2737;1985*
22;Harikrishna, P.;IND;2737;1986*
23;Wojtaszek, Radoslaw;POL;2736;1987*
24;Adams, Michael;ENG;2736;1971*
25;Li, Chao b;CHN;2735;1989*
26;Matlakov, Maxim;RUS;2730;1991*
27;Ivanchuk, Vassily;UKR;2729;1969*
28;Gelfand, Boris;ISR;2728;1968*
29;Fedoseev, Vladimir;RUS;2726;1995*
30;Le, Quang Liem;VIE;2726;1991*
31;Vitiugov, Nikita;RUS;2724;1987*
32;Radjabov, Teimour;AZE;2724;1987*
33;Malakhov, Vladimir;RUS;2722;1980*
34;Vallejo Pons, Francisco;ESP;2717;1982*
35;Bacrot, Etienne;FRA;2715;1983*
36;Jobava, Baadur;GEO;2714;1983*
37;Andreikin, Dmitry;RUS;2712;1990*
38;Naiditsch, Arkadij;AZE;2712;1985*
39;Bu, Xiangzhi;CHN;2711;1985*
40;Tomashevsky, Evgeny;RUS;2710;1987*
41;Duda, Jan-Krzysztof;POL;2707;1998*
42;Almasi, Zoltan;HUN;2707;1976*
43;Inarkiev, Ernesto;RUS;2707;1985*
44;Najer, Evgeniy;RUS;2706;1977*
45;Cheparinov, Ivan;BUL;2703;1986*
46;Jakovenko, Dmitry;RUS;2703;1983*
47;Howell, David W L;ENG;2702;1990*
48;Ponomariov, Ruslan;UKR;2699;1983*
49;Wang, Yue;CHN;2699;1987*
50;Wang, Hao;CHN;2698;1989*
51;Artemiev, Vladislav;RUS;2695;1998*
52;Rodshtein, Maxim;ISR;2695;1989*
53;Rapport, Richard;HUN;2694;1996*
54;Vidit, Santosh Gujrathi;IND;2693;1994*
55;Kryvoruchko, Yuriy;UKR;2690;1986*
56;Sasikiran, Krishnan;IND;2688;1981*
57;Short, Nigel D;ENG;2688;1965*
58;Sadler, Matthew D;ENG;2687;1974*
59;Sutovsky, Emil;ISR;2683;1977*
60;Nisipeanu, Liviu-Dieter;GER;2683;1976*
61;Rublevsky, Sergei;RUS;2683;1974*
62;Onischuk, Alexander;USA;2682;1975*
63;Mamedov, Rauf;AZE;2680;1988*
64;Motylev, Alexander;RUS;2680;1979*
65;Leko, Peter;HUN;2678;1979*
66;Kamsky, Gata;USA;2678;1974*
67;Movsesian, Sergei;ARM;2677;1978*
68;Adhiban, B.;IND;2677;1992*
69;Kasimdzhanov, Rustam;UZB;2676;1979*
70;Morozevich, Alexander;RUS;2675;1977*
71;Van Wely, Loek;NED;2675;1972*
72;Ni, Hua;CHN;2674;1983*
73;Amin, Bassem;EGY;2672;1988*
74;Markus, Robert;SRB;2672;1983*
75;Moiseenko, Alexander;UKR;2671;1980*
76;Shankland, Samuel L;USA;2671;1991*
77;Rakhmanov, Aleksandr;RUS;2670;1989*
78;Laznicka, Viktor;CZE;2669;1988*
79;Korobov, Anton;UKR;2668;1985*
80;Akopian, Vladimir;ARM;2667;1971*
81;Bareev, Evgeny;CAN;2666;1966*
82;Hou, Yifan;CHN;2666;1994*
83;Iturrizaga Bonelli, Eduardo;VEN;2664;1989*
84;Negi, Parimarjan;IND;2664;1993*
85;Bachmann, Axel;PAR;2662;1989*
86;Akobian, Varuzhan;USA;2662;1983*
87;Jones, Gawain C B;ENG;2660;1987*
88;Kovalenko, Igor;LAT;2659;1988*
89;Ipatov, Alexander;TUR;2659;1993*
90;Mareco, Sandro;ARG;2659;1987*
91;Berkes, Ferenc;HUN;2658;1985*
92;Dubov, Daniil;RUS;2658;1996*
93;Ganguly, Surya Shekhar;IND;2658;1983*
94;Kravtsiv, Martyn;UKR;2657;1990*
95;Ragger, Markus;AUT;2656;1988*
96;Granda Zuniga, Julio E;PER;2656;1967*
97;Shirov, Alexei;LAT;2656;1972*
98;Grachev, Boris;RUS;2655;1986*
99;Anton Guijarro, David;ESP;2654;1995*
100;Riazantsev, Alexander;RUS;2654;1985

this is DIV with id=p1out

1. (50 points) The textarea to the left is named ta1 and is in a form named f1. It contains a list of the World Chess Federation's Top 100 Chess Players in the World in July 2017. Data for each player is:

Rank (followed by a ";")
Last Name, First Middle Name(s)(followed by a ";")
Country Code (followed by a ";")
Rating (followed by a ";")
Birth Year (followed by a "*")
except the last one

When the button below is clicked, a javascript for function named p1 is executed that:

retrieves the data from ta1
creates a 100 row x 5 column table and places the table in the DIV block with id="p1out".
Following the table:
1. accumulate list of grand masters' names with Country Code = "USA"
  Show only entire name of each grandmaster on a single line
2. show the total number number of grand masters with Country Code = "USA"

Show NO HTML. Show only the javascript for p1.

TOP 100 JOBS in HOUSTON 2017

1,Anesthesiologists,271280,187040,1210;
2,Chief Executives,241130,130940,1990;
3,Surgeons,221790,53470,470;
4,Family and General Practitioners,201340,71860,2130;
5,Architectural and Engineering Managers,188160,106830,4820;
6,Pediatricians General,185600,129180,740;
7,Physicians and Surgeons All Other,180600,60090,5560;
8,Petroleum Engineers,173290,97180,10810;
9,Podiatrists,165700,43960,90;
10,Marketing Managers,162390,81620,2670;
11,Lawyers,161590,63400,12650;
12,Nurse Anesthetists,158520,113460,1350;
13,Internists General,158320,55470,890;
14,Geoscientists Except Hydrologists and Geographers,157750,58820,6140;
15,Dentists General,157720,67060,1460;
16,Financial Managers,157660,78750,8590;
17,Purchasing Managers,154150,74870,1700;
18,Computer and Information Systems Managers,151490,94540,5930;
19,Psychiatrists,150230,52340,210;
20,Compensation and Benefits Managers,148230,82070,250;
21,Sales Managers,146430,72560,6760;
22,Air Traffic Controllers,146310,101510,590;
23,Natural Sciences Managers,146300,62200,670;
24,General and Operations Managers,145640,53670,48000;
25,Economists,145140,76250,410;
26,Human Resources Managers,142400,81800,2030;
27,Managers All Other,139800,75810,3820;
28,Public Relations and Fundraising Managers,137780,66870,840;
29,Training and Development Managers,134590,74230,470;
30,Chemical Engineers,126310,68950,4360;
31,Actuaries,124990,69560,200;
32,Engineers All Other,124270,54830,2740;
33,Industrial Production Managers,121970,62960,3490;
34,Education Administrators Postsecondary,120490,66100,1030;
35,Marine Engineers and Naval Architects,117870,69900,1360;
36,Commercial Pilots,117780,48670,1340;
37,Astronomers,117590,38200,40;
38,Pharmacists,116230,94370,5350;
39,Computer Network Architects,115100,68650,2190;
40,Nurse Practitioners,114270,84840,1760;
41,Administrative Services Managers,113990,52610,5530;
42,Aerospace Engineers,113470,71350,2360;
43,Health and Safety Engineers,112300,58320,1550;
44,Electronics Engineers Except Computer,110810,68190,3100;
45,Economics Teachers Postsecondary,110760,42360,290;
46,Civil Engineers,110160,56230,11030;
47,Industrial Engineers,109970,64940,5100;
48,Media and Communication Equipment Workers All Other,109550,61510,100;
49,Health Specialties Teachers Postsecondary,108740,42250,2600;
50,Mechanical Engineers,108720,64290,8760;
51,Management Analysts,107730,49890,10330;
52,Physicists,107710,53360,530;
53,Transportation Storage and Distribution Managers,107610,57610,2570;
54,Electrical Engineers,107410,65570,4450;
55,Real Estate Brokers,106890,27810,800;
56,Medical and Health Services Managers,106840,54040,4710;
57,Software Developers Systems Software,106270,68620,8770;
58,Atmospheric Earth Marine, and Space Sciences Teachers Postsecondary,106150,42470,300;
59,Biological Science Teachers Postsecondary,106140,43270,970;
60,Captains Mates and Pilots of Water Vessels,105620,53140,2050;
61,Physical Scientists All Other,104920,48820,190;
62,Materials Engineers,104900,48190,680;
63,Business Teachers Postsecondary,104450,27250,1160;
64,Judges Magistrate Judges and Magistrates,103770,17290,410;
65,First-Line Supervisors of Police and Detectives,103440,59850,430;
66,Personal Financial Advisors,103410,31110,3410;
67,Computer Systems Analysts,102730,57980,18310;
68,Software Developers Applications,102260,63450,12090;
69,Engineering Teachers Postsecondary,102160,27240,1010;
70,Sales Engineers,102160,57840,3430;
71,Financial Analysts,101980,51800,6680;
72,Construction Managers,101320,60500,8590;
73,Hydrologists,101180,54570,40;
74,Computer and Information Research Scientists,101090,50250,240;
75,Sales Representatives Wholesale and Manufacturing Technical and Scientific Products,98930,42020,7350;
76,Computer Science Teachers Postsecondary,98390,28400,530;
77,Optometrists,98070,23400,690;
78,Physician Assistants,97570,38710,1790;
79,Information Security Analysts,97150,60120,1680;
80,Advertising and Promotions Managers,96160,42240,250;
81,First-Line Supervisors of Non-Retail Sales Workers,95960,40520,6880;
82,Veterinarians,95850,49900,740;
83,Property Real Estate and Community Association Managers,95450,39770,3390;
84,Administrative Law Judges Adjudicators and Hearing Officers,95120,56660,360;
85,Computer Occupations All Other,94730,50000,2590;
86,Network and Computer Systems Administrators,94480,55170,8940;
87,Securities Commodities, and Financial Services Sales Agents,94290,32330,8630;
88,Nurse Midwives,93880,60780,80;
89,Physics Teachers Postsecondary,93440,39160,400;
90,Environmental Engineers,93230,50940,900;
91,Environmental Scientists and Specialists Including Health,93010,41880,2050;
92,Budget Analysts,91850,47300,1070;
93,Anthropology and Archeology Teachers Postsecondary,91730,42960,80;
94,Radiation Therapists,91240,66630,390;
95,Operations Research Analysts,90750,51540,1710;
96,Materials Scientists,90730,40330,90;
97,Business Operations Specialists All Other,90650,49250,16610;
98,Psychologists All Other,90620,32670,90;
99,Logisticians,89820,48050,4320;
100,Physical Therapists,89710,64890,2360

this is DIV with id=p2out

2. (50 points) In the textarea to the left (named ta2 in a form named f2) is the federal 'Bureau of Labor Statistics' top 100 highest paid jobs in Houston in 2017. Each of the 100 job categories listed contains:
    1. rank (followed by a ",")
    2. job description (followed by a ",")
    3. average salary (followed by a ",")
    4. average entry level salary (followed by a ",")
    5. number of jobs in houston (followed by a ";" except the last one)
When the user enters a search value in the textbox (named sb in the f2 form) and clicks on the button labelled "search", the function named p2:

retrieves the data from ta2
splits the data on the ";"
finds and stores each of the 100 'job description' values (item 2 above) in upper case in a 100 element array named jobs Use .toUpperCase() to convert the 'job description' values to upper case
retrieves the value in the search box named sb
converts this textbox value to upper case
starts an output string like this: os="Search found:"
examines all the 100 array elements in jobs, if an array element of jobs contains the search term, add: a break tag and the 'job description' value to os
counts the number of search matches and adds the count to os
places os in the DIV block with id="p2out"

The data in bold (shown to the left) is the contents of the DIV with id="p2out" resulting from searching for the term "computer" and finding 8 occurrences (i.e., executing the function named p2)
Show no HTML. Show only the javascript for p2.