CDA Prt 2

State Princeton University NJ 2 708 647 13218 2042 4540 Drew University NJ 2 603 564 2153 1580 1192 Stevens Institute of Technology NJ 2 652 521 1768 1249 1263 Rider University NJ 2 501 439 3586 2424 2748 Upsala College NJ 2 410 400 1540 1363 950 Monmouth College NJ 2 494 440 2707 1881 1893 Seton Hall University NJ 2 496 443 4576 3565 4384 Centenary College NJ 2 500 470 369 312 396 Fairleigh Dickinson University NJ 2 495 430 3148 1616 3553 College of Saint Elizabeth NJ 2 486 464 444 359 493 Saint Peter's College NJ 2 428 379 1606 1413 1921 Georgian Court College NJ 2 474 441 348 281 1095 Caldwell College NJ 2 478 441 1011 604 693 New Jersey Institute of Technology NJ 1 600 466 1879 1216 3311 Rutgers State University at Camden NJ 1 545 489 3366 1752 2585 Rutgers at New Brunswick NJ 1 594 513 48094 26330 21401 Rutgers State University at Newark NJ 1 529 459 5785 2690 4005 Trenton State College NJ 1 592 519 5042 2312 5167 Ramapo College of New Jersey NJ 1 510 460 2088 957 2745 Rowan College of New Jersey NJ 1 520 468 3820 1431 5303 Jersey City State College NJ 1 440 400 2957 1423 3817 Montclair State University NJ 1 487 431 5220 2128 6411 William Paterson College of New JerseyNJ 1 485 428 5485 2662 5938 Stockton College of New Jersey NJ 1 552 489 4019 1579 4365 Kean College of New Jersey NJ 1 463 417 3344 2322 6804 Hamilton College NY 2 591 531 3140 1783 1646 Colgate University NY 2 623 563 4856 2492 2649 Sarah Lawrence College NY 2 560 590 1380 768 1000 Vassar College NY 2 625 603 3550 1877 2164 St. Lawrence University NY 2 573 510 2753 1820 1801 Skidmore College NY 2 570 520 4293 2728 2322 Columbia University NY 2 680 620 6756 1930 3376 Barnard College NY 2 620 600 2496 1402 2121 New York University NY 2 604 542 13594 7244 12408 Hartwick College NY 2 524 478 2083 1725 1464 Polytechnic University NY 2 630 480 1132 847 1379 Clarkson University NY 2 612 518 2174 1953 2332 Elmira College NY 2 496 463 1457 1045 1109 Wells College NY 2 590 490 318 240 416 New School for Social Research NY 2 537 552 1914 1190 2609 Manhattanville College NY 2 524 500 962 750 830 Fordham University NY 2 535 506 4200 2874 4740 Wagner College NY 2 510 480 1416 1015 1324 Utica College of Syracuse University NY 2 496 437 1278 978 1525 Yeshiva University NY 2 621 553 1002 857 1948 Manhattan College NY 2 539 467 2432 1730 2578 Adelphi University NY 2 500 457 2186 1924 2683 College of Mount St. Vincent NY 2 474 454 946 648 707 Hofstra University NY 2 540 470 7428 5860 6534 Sample of American Colleges and Universities Public (1) Private (2) Mean Math SAT Mean Verbal SAT # Appli. Rec'd # Appl. Accepted # Full Time Undergrad s

Marymount College Tarrytown NY 2 456 460 478 327 731 Pace University NY 2 517 441 8256 3750 5809 Nazareth College of Rochester NY 2 540 494 947 798 1274 Siena College NY 2 560 491 2961 1932 2669 Marist College NY 2 515 475 4731 3171 3557 Iona College NY 2 457 410 4892 3530 3906 St. John Fisher College NY 2 525 465 1368 1064 1687 St. Bonaventure University NY 2 535 478 1489 1313 1688 Long Island University at Brooklyn NY 2 420 410 3292 1317 3520 Roberts Wesleyan College NY 2 473 442 459 422 932 Marymount Manhattan College NY 2 500 460 695 535 988 Houghton College NY 2 535 508 949 786 1210 Keuka College NY 2 495 451 461 381 738 St. John's University NY 2 506 426 7775 2836 11785 Cazenovia College NY 2 392 375 3847 3433 1010 Concordia College NY 2 467 435 303 198 443 Dowling College NY 2 440 400 1011 829 1059 D'Youville College NY 2 497 435 866 619 1074 Molloy College NY 2 468 435 481 401 1402 St. Thomas Aquinas College NY 2 425 400 861 609 1117 Nyack College NY 2 472 433 460 283 508 Mount Saint Mary College NY 2 450 450 1170 695 1170 St. Joseph's College NY 2 483 442 707 512 1671 SUNY College at Potsdam NY 1 540 500 3150 2289 3598 SUNY at Albany NY 1 580 506 13528 9198 10168 SUNY at Stony Brook NY 1 542 464 12512 6969 9744 SUNY at Buffalo NY 1 572 480 15039 9649 13963 SUNY College at New Paltz NY 1 537 479 8399 3609 4658 SUNY at Binghamton NY 1 615 533 14463 6166 8544 SUNY College at Cortland NY 1 524 460 7888 3519 5011 SUNY College at Fredonia NY 1 525 472 4877 2798 4123 SUNY College at Plattsburgh NY 1 520 460 5549 3583 5004 SUNY College at Purchase NY 1 486 466 2119 1264 2478 SUNY College at Geneseo NY 1 608 541 8598 4562 5060 SUNY College at Brockport NY 1 506 446 7294 3564 5758 SUNY College at Buffalo NY 1 455 409 5318 3515 7626 SUNY College at Oneonta NY 1 509 463 7500 4350 4627 SUNY College at Oswego NY 1 550 480 8000 4556 6943 CUNY - Queens College NY 1 486 421 4681 3627 8837 CUNY-Brooklyn College NY 1 490 426 3589 2992 7767 CUNY-Lehman College NY 1 407 371 1897 1384 4890 CUNY - City College NY 1 488 405 3788 2747 8071 CUNY-York College NY 1 395 356 1432 1432 3932 CUNY-College of Staten Island NY 1 447 398 2170 2170 5949 CUNY-Hunter College NY 1 446 399 6189 3212 8140 CUNY- Medgar Evers College NY 1 340 320 1289 1289 2343 Oberlin College OH 2 623 596 4778 2767 2587 Kenyon College OH 2 593 570 2212 1538 1445 Ohio Wesleyan University OH 2 575 528 2190 1700 1780 College of Wooster OH 2 570 530 2100 1883 1704 Ohio Northern University OH 2 541 465 2936 2342 2502

$ 19,900 $ 19,900 91 8.4 99 $ 18,432 $ 18,432 93 10.2 83 $ 16,900 $ 16,900 89 19.0 79 $ 13,250 $ 13,250 84 12.3 70 $ 12,500 $ 12,500 72 14.0 43 $ 12,480 $ 12,480 70 14.2 54 $ 12,000 $ 12,000 81 14.4 64 $ 11,400 $ 11,400 41 9.5 24 $ 11,010 $ 11,010 77 16.7 60 $ 10,900 $ 10,900 68 11.4 78 $ 9,408 $ 9,408 78 12.1 53 $ 9,150 $ 9,150 56 12.2 76 $ 8,900 $ 8,900 87 13.9 55 $ 4,188 $ 8,832 92 13.5 72 $ 3,641 $ 7,411 90 18.6 57 $ 3,640 $ 7,410 90 19.5 77 $ 3,640 $ 7,410 90 17.4 58 $ 3,116 $ 5,391 81 14.4 81 $ 3,227 $ 4,449 74 17.8 47 $ 2,342 $ 4,356 76 22.1 51 $ 2,798 $ 3,946 63 14.9 26 $ 2,400 $ 3,648 82 21.5 58 $ 2,385 $ 3,135 77 23.5 38 $ 2,288 $ 3,040 78 19.5 64 $ 1,965 $ 2,875 76 17.2 40 $ 19,700 $ 19,700 91 9.6 91 $ 19,510 $ 19,510 95 10.5 93 $ 19,300 $ 19,300 89 6.1 83 $ 18,920 $ 18,920 90 9.7 90 $ 18,720 $ 18,720 90 11.5 85 $ 18,710 $ 18,710 87 12.7 81 $ 18,624 $ 18,624 97 5.9 99 $ 17,926 $ 17,926 83 10.3 91 $ 17,748 $ 17,748 87 7.8 71 $ 17,480 $ 17,480 75 12.3 73 $ 16,200 $ 16,200 90 10.4 62 $ 15,960 $ 15,960 95 15.8 77 $ 14,990 $ 14,990 77 21.5 64 $ 14,900 $ 14,900 93 8.3 69 $ 14,710 $ 14,710 69 10.2 59 $ 14,700 $ 14,700 97 11.3 70 $ 14,235 $ 14,235 86 14.4 80 $ 13,500 $ 13,500 67 13.2 75 $ 12,680 $ 12,680 64 12.3 65 $ 12,584 $ 12,584 86 5.2 63 $ 12,370 $ 12,370 92 13.6 79 $ 12,280 $ 12,280 29 12.2 56 $ 11,790 $ 11,790 75 11.9 83 $ 11,600 $ 11,600 81 13.9 60 In-state Tuition Out-of- state Tuition % Fac. w/Ph.D . Stud./Fac. Ratio Graduatio n Rate

$ 11,510 $ 11,510 71 10.3 77 $ 11,100 $ 11,000 90 13.8 62 $ 10,850 $ 10,850 77 13.6 61 $ 10,800 $ 10,800 71 14.1 100 $ 10,700 $ 10,700 74 17.6 69 $ 10,690 $ 10,690 66 16.0 66 $ 10,570 $ 10,570 86 14.5 66 $ 10,456 $ 10,456 91 17.7 78 $ 10,258 $ 10,258 75 21.6 61 $ 10,220 $ 10,220 45 13.4 46 $ 10,200 $ 10,200 63 11.7 68 $ 9,990 $ 9,990 85 15.0 67 $ 9,600 $ 9,600 55 13.3 51 $ 9,400 $ 9,400 72 29.3 65 $ 9,384 $ 9,384 22 14.3 118 $ 9,370 $ 9,370 50 9.5 53 $ 9,000 $ 9,000 77 12.4 42 $ 8,920 $ 8,920 68 14.6 46 $ 8,800 $ 8,800 38 9.7 80 $ 8,650 $ 8,650 69 16.1 67 $ 7,950 $ 7,950 35 11.6 55 $ 7,470 $ 7,470 74 15.3 88 $ 7,350 $ 7,350 52 13.6 74 $ 2,650 $ 6,840 71 15.1 59 $ 2,650 $ 6,550 93 17.4 74 $ 2,650 $ 6,550 91 10.5 57 $ 2,650 $ 6,550 90 13.6 56 $ 2,650 $ 6,550 85 15.3 53 $ 2,650 $ 6,550 83 18.0 80 $ 2,650 $ 6,550 82 17.8 53 $ 2,650 $ 6,550 82 16.3 66 $ 2,650 $ 6,550 80 17.9 65 $ 2,650 $ 6,550 80 14.9 46 $ 2,650 $ 6,550 79 19.1 76 $ 2,650 $ 6,550 79 19.0 49 $ 2,650 $ 6,550 71 18.7 42 $ 2,650 $ 6,550 70 17.1 60 $ 2,650 $ 6,550 69 22.0 63 $ 2,650 $ 5,250 100 12.5 46 $ 2,450 $ 5,050 83 15.6 43 $ 2,450 $ 5,050 80 15.3 30 $ 2,450 $ 5,050 78 12.8 34 $ 2,450 $ 5,050 75 18.9 26 $ 2,450 $ 5,050 71 17.6 48 $ 2,450 $ 5,050 62 14.1 39 $ 2,100 $ 2,600 64 16.5 36 $ 19,670 $ 19,670 77 10.1 83 $ 19,240 $ 19,240 95 11.1 88 $ 16,732 $ 16,732 93 12.1 75 $ 16,240 $ 16,240 84 11.1 69 $ 15,990 $ 15,990 73 14.5 83

Charting Name: Elizabeth Gondek Please backup your files! Course #: Version 5 Save at 120% per the slide in the lower right-hand corner. Section: 1 Note: The compiled data below should be charted. State Charting Points Pie Chart Other Chart NJ 13218 2042 1. Display only the relevant column(s) of data, with column headings. 10 State Identifier: NJ 2153 1580 20 State 1: NJ 65,491 State 1: NJ 127,573 State 1: NJ 51% NJ 1768 1249 3. Produce one pie chart on the number of applications accepted by state, including the title. 10 State 2: NY 163,865 State 2: NY 271,474 State 2: NY 60% NJ 3586 2424 4. Calculate 4 state acceptance rates (%). 20 State 3: OH 66,366 State 3: OH 87,633 State 3: OH 76% NJ 1540 1363 20 State 4: RI 21,025 State 4: RI 36,176 State 4: RI 58% NJ 2707 1881 6. Formulae in Excel need to be visible on-line for the calculation of the acceptance rates (%) and autosums. 20 NJ 4576 3565 100 NJ 369 312 NJ 3148 1616 NJ 444 359 NJ 1606 1413 NJ 348 281 NJ 1011 604 NJ 1879 1216 NJ 3366 1752 NJ 48094 26330 NJ 5785 2690 NJ 5042 2312 NJ 2088 957 NJ 3820 1431 NJ 2957 1423 NJ 5220 2128 NJ 5485 2662 NJ 4019 1579 NJ 3344 2322 NY 3140 1783 NY 4856 2492 NY 1380 768 NY 3550 1877 NY 2753 1820 NY 4293 2728 NY 6756 1930 NY 2496 1402 NY 13594 7244 NY 2083 1725 NY 1132 847 NY 2174 1953 NY 1457 1045 NY 318 240 NY 1914 1190 NY 962 750 NY 4200 2874 NY 1416 1015 NY 1278 978 NY 1002 857 NY 2432 1730 NY 2186 1924 NY 946 648 NY 7428 5860 NY 478 327 NY 8256 3750 NY 947 798 NY 2961 1932 NY 4731 3171 NY 4892 3530 NY 1368 1064 NY 1489 1313 NY 3292 1317 NY 459 422 NY 695 535 NY 949 786 NY 461 381 NY 7775 2836 NY 3847 3433 NY 303 198 NY 1011 829 NY 866 619 NY 481 401 NY 861 609 NY 460 283 NY 1170 695 NY 707 512 NY 3150 2289 NY 13528 9198 NY 12512 6969 NY 15039 9649 NY 8399 3609 NY 14463 6166 NY 7888 3519 NY 4877 2798 NY 5549 3583 NY 2119 1264 NY 8598 4562 NY 7294 3564 NY 5318 3515 NY 7500 4350 NY 8000 4556 NY 4681 3627 NY 3589 2992 NY 1897 1384 NY 3788 2747 NY 1432 1432 NY 2170 2170 NY 6189 3212 NY 1289 1289 OH 4778 2767 OH 2212 1538 OH 2190 1700 OH 2100 1883 OH 2936 2342 OH 1979 1739 OH 713 661 OH 922 729 OH 738 687 OH 1109 922 OH 2421 2109 OH 1959 1805 OH 1454 1267 OH 6361 5293 OH 1690 1366 OH 571 461 OH 692 514 OH 874 758 OH 798 620 OH 553 452 OH 325 260 OH 6855 5553 OH 9210 3040 OH 6305 5190 OH 11023 8298 OH 845 734 OH 9251 7333 OH 3055 2959 OH 1307 1090 OH 2407 2296 RI 12586 3239 RI 1831 842 RI 5139 3346 RI 1475 1257 RI 2198 1786 RI 3304 2804 RI 9643 7751 # Appli. Rec'd # Appl. Accepte d Charting - Identify each state # with its 2-digit abbreviation. Use the summary data (in yellow) for each of the charts. Label appropriate axes. Points Lost Horizontal or Vertical Column Chart # Appl. Accepted State Identifier: # Appli. Rec'd State Identifier: Acceptance Rate (%) 2. Produce one horizontal or vertical column chart on the number of application received by state, including title and axes' labels. 5. Produce a chart (different from #2 or #3) on the calculated acceptance rate (%) by state, including title and axes' labels. State 1: NJ State 2: NY State 3: OH State 4: RI - 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000 180,000 65,491 163,865 66,366 21,025 # Of Applications Accepted State # # Of Applications Received State 1: NJ State 2: NY State 3: OH State 4: RI State 1: NJ State 2: NY State 3: OH State 4: RI 0% 10% 20% 30% 40% 50% 60% 70% 80% 51% 60% 76% 58% Acceptance Rate (%) State %