V III lii III Til AutoSave 62.... Excel Exam Home be sa Insert Draw Page Layout Formulas Data Review View Developer Tell me X Calibri (Body) 12 - A A 29 General Paste BIU a A- $ % ) 488 Conditional Format es, 10 Formatting as Table Al XfDBN LIS: A D F G 1 DIN school Name Number of Test Takers Critical Reading Mean Mathematics Mean Writing Mean Total Score Rating 2 OIM292 Henry Street School for International Studies 31 391 425 385 301M448 University Neighborhood High School 60 394 419 387 4 01M450 East Side Community High School 69 418 431 402 5 OLM458 SATELLITE ACADEMY FORSYTH ST 26 385 370 378 6 DIMS15 Lower East Side Preparatory High School 154 314 532 314 7 CIMS9 New Explorations into Sd, Tech and Math HS 47 568 583 568 & OLM650 CASCADES HIGH SCHOOL 35 411 401 401 9. OIM696 SARD HGH SCHOOL EARLY COLLEGE 138 630 608 630 10 O2M047 AMERICAN SIGN LANG ENG DUAL estio 11 405 415 385 11 O2M286 FOOD AND FNANCE HIGH SCHOOL 50 422 412 407 12 O2M294 HIGH SCHOOL FOR HIST AND COMM 51 382 364 366 13 02M296 High School of Hospitality Management 43 397 415 391 14 02M298 PACE HIGH SCHOOL 71 424 448 423 sheet 15 02M300 Urban Assembly School of Design and Construction 49 446 16 02M303 The Facing History School 59 381 373 377 the se 17 02M305 Urban Assembly Academy of Government and law 4.8 411 405 411 11 O2M30B LOWER MANHATTAN ARTS ACADEMY Ich sc 9 02M313 The James Baldwin School 35 409 381 412 45 421 419 394 20 02M316 Urban Assembly School of Business for Young Women 52 401 409 391 21 OM374 GRAMERCY ARTS HIGH SCHOOL 49 395 376 386 22 OMOO HIGH SCHOOL ENVRNMNTL STUDIES 216 465 480 443 23 02M407 Institute for Collaborative Iducation 42 484 478 472 24 CMOS Professional Performng Arts School 69 495 465 499 25 02M411 Baruch College Campus High School 96 523 583 528 26 02M412 New York City Laboratory School Collab Studies 108 561 597 567 bestiol 27 02M413 SCHOOL OF THE FUTURE 79 475 488 466 28 O2M414 NEW YORK CITY MUSEUM SCHOOL 90 454 448 435 29 02M416 ELEANOR ROOSEVELT HIGH SCHOOL 122 555 596 567 30 02M41 Millennium High School 140 512 554 523 31 02419 LANDMARK SCHOOL 47 369 370 359 32 02M420 HIGH SCHOOL HLTH PROF HUMAN 250 446 458 440 33 02M425 HIGH SCHOOL LEADERSHIP PUB SVC 74 419 429 406 34 DUM LEGACY SCHUINTEGRATED STUDIOS 154 PARTA PARTB PART PART D 4 40s 415 . Al > fx DAN D E A B 39 UZMU WASHINGTON IRVING HIGH SCHOOL 40 02M475 STUYVESANT HIGH SCHOOL 41 02M489 HS of Economics And Finance 42 02MSOO UNITY HIGH SCHOOL 43 02MS19 TALENT UNUMITED HIGH SCHOOL 44 02M520 MURRY BERGTRAUM HIGH SCHOOL 45 OZM529 Jacqueline Kennedy Onassis High School 46 02M531 NEW YORK CITY PUB SCH REP COMP 47 02M542 MANHATTAN BRIDGE HIGH SCHOOL 48 02M543 NEW DESIGN HIGH SCHOOL 149 02M544 INDEPENDENCE HIGH SCHOOL 50 02M545 Dual Language and Asian Studies High School 51 02M550 Liberty High School Academy for Newcomers 52 O2M551 New York Harbor High School 53 O2M560 City as School 54 02M565 URBAN ACADEMY 55 02M570 Satellite Academy High School e 56 02M575 Manhattan Comprehensive Night Day High School 57 02M580 Richard R Green High School of Teaching 58 02M586 HARVEY MILK SCHOOL 59 02M600 HIGH SCHOOL FASHION INDUSTRIES 60 02M605 HUMANITIES PREPARATORY ACADEMY 61 02M615 Chelsea Career and Technical Education High School 62 02M620 NORMAN THOMAS HIGH SCHOOL 63 02M625 HS of Graphic Commnctn And Art 64 02M630 HIGH SCHOOL OF ART AND DESIGN 65 02M655 LIFE SCIENCES SECONDARY SCHOOL of 66 02M690 SCHOOL FOR THE PHYSICAL CITY 67 03M283 MANHATTAN THEATRE LAB HIGH SCHOOL 68 03M299 High School For Arts, Imagination And Inquiry 69 03M307 Urban Assembly School For Media Studies 70 03M415 WADLEIGH SECONDARY SCHOOL 71 03M470 LOUIS D BRANDEIS HIGH SCHOOL 72 03M479 BEACON SCHOOL 73. NASLAGUARDIA HIGHSCHIMUSICIART PARTA PARTB PARTC PART D 163 804 147 31 124 287 88 32 31 74 16 47 32 54 57 34 16 141 79 11 301 37 61 152 125 212 71 14 23 57 53 68 170 237 594 381 674 451 371 465 411 420 415 345 390 404 416 343 372 468 513 400 355 425 429 419 433 393 378 370 427 399 382 406 364 374 376 357 573 558 385 735 503 369 454 439 424 405 380 385 419 612 465 369 441 460 336 475 429 382 420 405 412 387 378 423 389 404 378 378 363 373 357 563 SSS 368 678 453 368 461 396 398 397 325 387 395 419 362 368 434 502 376 339 419 416 413 417 376 370 360 418 383 359 391 357 377 371 345 575 567 + tv A 3 be sa Home Insert Draw Excel Exam Developer Tell me Page Layout Formulas Data Review View X Calibri (Body) 12 ' ' 29 General Paste ili II B 1 U V a A = == = = 23 $ % 9 25, 41 al Condition Formatting C D E G 373 370 357 573 558 407 410 481 414 390 485 Al f DBN IS: A 8 TUOTSWALCETON SUNDARY SCHOOL 71 63M470 LOUIS D BRANDES HIGH SCHOOL 723M479 BEACON SCHOOL 73 53M48S LAGUARDIA HIGH SCH MUSIC ART 74 3494 Martin Luther King Jr HS Arts and Technology 75 IMSOS Edward A Reynolds West Side High School 76 53M541 MANHATTAN/HUNTER COLL HS SO 77 53M860 FREDERICK DOUGLAS ACADEMY 11 78 DAM409 COALITION SCH SOCIAL CHANGE 79 D4M435 Manhattan Center for Science and Math estiot 80 b4M495 PARK EAST HIGH SCHOOL 31 D4M555 CENTRAL PARK SECONDARY SCHOOL 82 D4M610 YOUNG WOMEN LEADERSHIP SCHOOL 83 D4M635 Academy of Environment Science Secondary School 84 D4M680 HERITAGE SCHOOL heet 854M695 URBAN PEACE ACADEMY 36 DSM285 HARLEM RENAISSANCE HIGH SCHOOL he se 87 OSM304 MOTT HALL HIGH SCHOOL 88 DSM369 URBAN ASSEMBLY SCHOOL FOR THE PERFORMIN h sch 89 DSM469 CHOIR ACADEMY OF HARLEM 90 DSM499 FREDERICK DOUGLASS ACADEMY 91 DSM670 THURGOOD MARSHALL ACADEMY 925M685 Bread & Rose Intergrated Arts High School 93 95M692 High School For Math Science Engineering Cty Coll 946M462 HIGH SCHOOL FOR INTL BUS/FIN 95 56M463 HS for Media and Communications George Washingto 96 6M467 High School for law and Public Service stiot 97 56M468 HIGH SCHOOL FOR HLTH CARER/SER 98 06M540 A Philip Randolph Campus High School 99 06M552 GREGORIO LUPERON PREP SCHOOL 10057X221 SOUTH BRONX PREPARATORY 10157X334 INTERNATIONAL COMMUNITY HIGH SCHOOL 102 103 104 PARTA PARTS PARTC PART D 00 170 237 594 60 18 80 33 39 312 46 35 48 39 47 23 19 63 34 16 216 52 54 106 56 75 106 28 193 60 50 33 357 563 555 425 407 525 410 372 531 374 378 445 385 385 382 394 421 370 369 481 360 362 451 380 369 366 402 424 349 420 465 423 364 592 383 366 388 385 436 342 399 322 F 3 345 575 567 397 388 469 406 383 475 362 356 470 354 361 362 367 410 363 401 466 404 359 575 379 353 378 373 421 333 382 327 434 378 627 384 376 388 412 451 384 393 335 8 AutoSave Page Layout Formulas Data Review ert Draw Calibri (Body) 12 A A B IU a A- x fx DBN M M K Ratings Score Range Below Average Less than or equal to 1100 Average 1101 to 1400 Above Average 1401 to 1600 Exceptional 1601 to 2100 Ratings No. Of Schools Below Average Average Above Average Exceptional PARTA PARTB PART PART D + 7 tv . Moving to another question will save this response Question Question 6 9 points Use the data provided in sheet PARTE the Excel Excam file, The excel sheet provides the section wide SAT performance data for 100 schools in New York City Find the total score for each school in the table. Total score is the sum of three sectional scores combined. What was the highest total score? & Moving to another question will save this response Questions Oeu stv A Question completion Statut OW Quron 10 Moving to the question will save the response Question 7 sed on the total scores takuuta, categorize the schools according to the certain the Rating Score kanpe table. What is the rating for the New York Cry Mean Strooi stolta A Moving to otherwise this response Care Wind av Moving to another question will save this response. Question 8 Count the number of schools in each rating category. How many schools were categorized as Exceptional? Moving to another question will save this response HY G A V III lii III Til AutoSave 62.... Excel Exam Home be sa Insert Draw Page Layout Formulas Data Review View Developer Tell me X Calibri (Body) 12 - A A 29 General Paste BIU a A- $ % ) 488 Conditional Format es, 10 Formatting as Table Al XfDBN LIS: A D F G 1 DIN school Name Number of Test Takers Critical Reading Mean Mathematics Mean Writing Mean Total Score Rating 2 OIM292 Henry Street School for International Studies 31 391 425 385 301M448 University Neighborhood High School 60 394 419 387 4 01M450 East Side Community High School 69 418 431 402 5 OLM458 SATELLITE ACADEMY FORSYTH ST 26 385 370 378 6 DIMS15 Lower East Side Preparatory High School 154 314 532 314 7 CIMS9 New Explorations into Sd, Tech and Math HS 47 568 583 568 & OLM650 CASCADES HIGH SCHOOL 35 411 401 401 9. OIM696 SARD HGH SCHOOL EARLY COLLEGE 138 630 608 630 10 O2M047 AMERICAN SIGN LANG ENG DUAL estio 11 405 415 385 11 O2M286 FOOD AND FNANCE HIGH SCHOOL 50 422 412 407 12 O2M294 HIGH SCHOOL FOR HIST AND COMM 51 382 364 366 13 02M296 High School of Hospitality Management 43 397 415 391 14 02M298 PACE HIGH SCHOOL 71 424 448 423 sheet 15 02M300 Urban Assembly School of Design and Construction 49 446 16 02M303 The Facing History School 59 381 373 377 the se 17 02M305 Urban Assembly Academy of Government and law 4.8 411 405 411 11 O2M30B LOWER MANHATTAN ARTS ACADEMY Ich sc 9 02M313 The James Baldwin School 35 409 381 412 45 421 419 394 20 02M316 Urban Assembly School of Business for Young Women 52 401 409 391 21 OM374 GRAMERCY ARTS HIGH SCHOOL 49 395 376 386 22 OMOO HIGH SCHOOL ENVRNMNTL STUDIES 216 465 480 443 23 02M407 Institute for Collaborative Iducation 42 484 478 472 24 CMOS Professional Performng Arts School 69 495 465 499 25 02M411 Baruch College Campus High School 96 523 583 528 26 02M412 New York City Laboratory School Collab Studies 108 561 597 567 bestiol 27 02M413 SCHOOL OF THE FUTURE 79 475 488 466 28 O2M414 NEW YORK CITY MUSEUM SCHOOL 90 454 448 435 29 02M416 ELEANOR ROOSEVELT HIGH SCHOOL 122 555 596 567 30 02M41 Millennium High School 140 512 554 523 31 02419 LANDMARK SCHOOL 47 369 370 359 32 02M420 HIGH SCHOOL HLTH PROF HUMAN 250 446 458 440 33 02M425 HIGH SCHOOL LEADERSHIP PUB SVC 74 419 429 406 34 DUM LEGACY SCHUINTEGRATED STUDIOS 154 PARTA PARTB PART PART D 4 40s 415 . Al > fx DAN D E A B 39 UZMU WASHINGTON IRVING HIGH SCHOOL 40 02M475 STUYVESANT HIGH SCHOOL 41 02M489 HS of Economics And Finance 42 02MSOO UNITY HIGH SCHOOL 43 02MS19 TALENT UNUMITED HIGH SCHOOL 44 02M520 MURRY BERGTRAUM HIGH SCHOOL 45 OZM529 Jacqueline Kennedy Onassis High School 46 02M531 NEW YORK CITY PUB SCH REP COMP 47 02M542 MANHATTAN BRIDGE HIGH SCHOOL 48 02M543 NEW DESIGN HIGH SCHOOL 149 02M544 INDEPENDENCE HIGH SCHOOL 50 02M545 Dual Language and Asian Studies High School 51 02M550 Liberty High School Academy for Newcomers 52 O2M551 New York Harbor High School 53 O2M560 City as School 54 02M565 URBAN ACADEMY 55 02M570 Satellite Academy High School e 56 02M575 Manhattan Comprehensive Night Day High School 57 02M580 Richard R Green High School of Teaching 58 02M586 HARVEY MILK SCHOOL 59 02M600 HIGH SCHOOL FASHION INDUSTRIES 60 02M605 HUMANITIES PREPARATORY ACADEMY 61 02M615 Chelsea Career and Technical Education High School 62 02M620 NORMAN THOMAS HIGH SCHOOL 63 02M625 HS of Graphic Commnctn And Art 64 02M630 HIGH SCHOOL OF ART AND DESIGN 65 02M655 LIFE SCIENCES SECONDARY SCHOOL of 66 02M690 SCHOOL FOR THE PHYSICAL CITY 67 03M283 MANHATTAN THEATRE LAB HIGH SCHOOL 68 03M299 High School For Arts, Imagination And Inquiry 69 03M307 Urban Assembly School For Media Studies 70 03M415 WADLEIGH SECONDARY SCHOOL 71 03M470 LOUIS D BRANDEIS HIGH SCHOOL 72 03M479 BEACON SCHOOL 73. NASLAGUARDIA HIGHSCHIMUSICIART PARTA PARTB PARTC PART D 163 804 147 31 124 287 88 32 31 74 16 47 32 54 57 34 16 141 79 11 301 37 61 152 125 212 71 14 23 57 53 68 170 237 594 381 674 451 371 465 411 420 415 345 390 404 416 343 372 468 513 400 355 425 429 419 433 393 378 370 427 399 382 406 364 374 376 357 573 558 385 735 503 369 454 439 424 405 380 385 419 612 465 369 441 460 336 475 429 382 420 405 412 387 378 423 389 404 378 378 363 373 357 563 SSS 368 678 453 368 461 396 398 397 325 387 395 419 362 368 434 502 376 339 419 416 413 417 376 370 360 418 383 359 391 357 377 371 345 575 567 + tv A 3 be sa Home Insert Draw Excel Exam Developer Tell me Page Layout Formulas Data Review View X Calibri (Body) 12 ' ' 29 General Paste ili II B 1 U V a A = == = = 23 $ % 9 25, 41 al Condition Formatting C D E G 373 370 357 573 558 407 410 481 414 390 485 Al f DBN IS: A 8 TUOTSWALCETON SUNDARY SCHOOL 71 63M470 LOUIS D BRANDES HIGH SCHOOL 723M479 BEACON SCHOOL 73 53M48S LAGUARDIA HIGH SCH MUSIC ART 74 3494 Martin Luther King Jr HS Arts and Technology 75 IMSOS Edward A Reynolds West Side High School 76 53M541 MANHATTAN/HUNTER COLL HS SO 77 53M860 FREDERICK DOUGLAS ACADEMY 11 78 DAM409 COALITION SCH SOCIAL CHANGE 79 D4M435 Manhattan Center for Science and Math estiot 80 b4M495 PARK EAST HIGH SCHOOL 31 D4M555 CENTRAL PARK SECONDARY SCHOOL 82 D4M610 YOUNG WOMEN LEADERSHIP SCHOOL 83 D4M635 Academy of Environment Science Secondary School 84 D4M680 HERITAGE SCHOOL heet 854M695 URBAN PEACE ACADEMY 36 DSM285 HARLEM RENAISSANCE HIGH SCHOOL he se 87 OSM304 MOTT HALL HIGH SCHOOL 88 DSM369 URBAN ASSEMBLY SCHOOL FOR THE PERFORMIN h sch 89 DSM469 CHOIR ACADEMY OF HARLEM 90 DSM499 FREDERICK DOUGLASS ACADEMY 91 DSM670 THURGOOD MARSHALL ACADEMY 925M685 Bread & Rose Intergrated Arts High School 93 95M692 High School For Math Science Engineering Cty Coll 946M462 HIGH SCHOOL FOR INTL BUS/FIN 95 56M463 HS for Media and Communications George Washingto 96 6M467 High School for law and Public Service stiot 97 56M468 HIGH SCHOOL FOR HLTH CARER/SER 98 06M540 A Philip Randolph Campus High School 99 06M552 GREGORIO LUPERON PREP SCHOOL 10057X221 SOUTH BRONX PREPARATORY 10157X334 INTERNATIONAL COMMUNITY HIGH SCHOOL 102 103 104 PARTA PARTS PARTC PART D 00 170 237 594 60 18 80 33 39 312 46 35 48 39 47 23 19 63 34 16 216 52 54 106 56 75 106 28 193 60 50 33 357 563 555 425 407 525 410 372 531 374 378 445 385 385 382 394 421 370 369 481 360 362 451 380 369 366 402 424 349 420 465 423 364 592 383 366 388 385 436 342 399 322 F 3 345 575 567 397 388 469 406 383 475 362 356 470 354 361 362 367 410 363 401 466 404 359 575 379 353 378 373 421 333 382 327 434 378 627 384 376 388 412 451 384 393 335 8 AutoSave Page Layout Formulas Data Review ert Draw Calibri (Body) 12 A A B IU a A- x fx DBN M M K Ratings Score Range Below Average Less than or equal to 1100 Average 1101 to 1400 Above Average 1401 to 1600 Exceptional 1601 to 2100 Ratings No. Of Schools Below Average Average Above Average Exceptional PARTA PARTB PART PART D + 7 tv . Moving to another question will save this response Question Question 6 9 points Use the data provided in sheet PARTE the Excel Excam file, The excel sheet provides the section wide SAT performance data for 100 schools in New York City Find the total score for each school in the table. Total score is the sum of three sectional scores combined. What was the highest total score? & Moving to another question will save this response Questions Oeu stv A Question completion Statut OW Quron 10 Moving to the question will save the response Question 7 sed on the total scores takuuta, categorize the schools according to the certain the Rating Score kanpe table. What is the rating for the New York Cry Mean Strooi stolta A Moving to otherwise this response Care Wind av Moving to another question will save this response. Question 8 Count the number of schools in each rating category. How many schools were categorized as Exceptional? Moving to another question will save this response HY G A