6.5 Chapter Assessment

The following are sample questions to test whether you know, understand, and are able to apply concepts from this chapter.

complete work with both the chapter walkthrough and the chapter practice excel data files to answer the questions below.

 

1. Use the College Scorecard Data Dictionary to answer the following question. What does “CIP” mean?
a) Custom Institution Profile
b) Classification of Instructional Programs
c) Categorical Information Program
d) COUNT of Institutional Program
2. Based on Chapter 6 College Scorecard data file, how many colleges offer ONLY Distance Education programs in California?
a) 2
b) 3
c) 4
d) 5
3. Based on Chapter 6 College Scorecard data file, how many academic institutions are in the East South Central Sub-Region?
a) 451
b) 518
c) 1038
d) 1139
4. Based on Chapter 6 College Scorecard data file, how many academic institutions offer 4 different types of degrees in California (“Highest degree awarded” category in your data dictionary).
a) 15
b) 25
c) 29
d) 190
5. Based on Chapter 6 College Scorecard data file, how many academic institutions are in Midsize Cities in the Northeast region?
a) 90
b) 157
c) 235
d) 346
6. The object towards the lower left corner of screenshot below shows a/an:
a) Filter
b) Developer
c) Slicer
d) Sorter
7. The PivotChart has been filtered for specific:
a) States
b) LOCALEs
c) Both
d) Neither
8. Answer the following based on your work with Chapter 6 Practice, Step 8. Which of the following states has the fifth highest number of processing facilities?
a) CALIFORNIA
b) INDIANA
c) LOUISIANA
d) WASHINGTON
9. Answer the following based on your work with Chapter 6 Practice, Step 9. How many processing facilities in Texas process products from Canada?
a) 898
b) 1006
c) 1440
d) 1378
10. Answer the following based on your work with Chapter 6 Practice, Step 16.  Which of the following processing companies is NOT in the top five regarding the number of processing facilities in Processing Company PADD 3?
a) EXXONMOBIL REFINING & SPLY CO
b) HOUSTON REFINING LP
c) MARATHON PETROLEUM CO LP
d) VALERO REFINING – TEXAS LP

 

Solutions: 1b, 2d, 3a, 4d, 5a, 6c, 7c, 8a, 9a, 10d

Attribution

Practice problems by Robert McCarn, Emese Felvégi, Bauer Tutoring Services based on chapter content and chapter practice files.  CC BY-NC-SA 3.0.

Media Attributions

  • 6-3-11_PivotChart_Locale_Filter_B

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Excel For Decision Making Copyright © by Emese Felvegi; Noreen Brown; Barbara Lave; Julie Romey; Mary Schatz; Diane Shingledecker; and Robert McCarn is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.