Docstoc

Excel - University of Colorado Boulder

Document Sample
Excel - University of Colorado Boulder Powered By Docstoc
					Data Shell of NRC Column/Variable Names
Used in reading NRC's download of rankings and other stats, ResDocTableWin.xls, into SAS
Updated 5/2/2011

The "Apr2011_release" tab in this Excel has the variable names, etc. for the recent re-releases (v2 and v3)
of the NRC rankings and other stats. The "Sep2010_release" tab has the same information for the original
release (v1). There's also a "compare" tab that allows for viewing the differences between v1 and v2/v3.

April 2011 release

September 2010 release

Comparisons of columns/variables in the 4/2011 and 9/2010 releases

Instructions--To read NRC's download of rankings and other stats into SAS, follow these steps:

Step 1: Make a copy of NRC's download, ResDocTableWin.xls.
Step 2: Insert in the copy, below the first row of the "Master" tab, rows 2 and 3 from
  NRC_datashell.xlsx, tab "Apr2011_release." These are needed in order for SAS to read the variable names and to
  get variable attributes correct. Save the copy.
Step 3: Read the copy of the Excel from step 2 into SAS, using this code:

%macro readit(filein, fileout, sht);
 proc import out= work.&fileout
   datafile= "&filein"
      dbms=excel replace;
   sheet="&sht";
   getnames=yes;
   mixed=yes;
   scantext=yes;
   usedate=yes;
   scantime=yes;
 run;
%mend;
%readit(%str(L:\IR\NRC\FromNRC\ResDocTableWin20110421_revised.xlsx), nrc0, Master$A2:BT5007)


University of Colorado Boulder
Planning, Budget, and Analysis
L:\IR\NRC\Use\2010PostingMaterials\NRC_DataShell.xlsx
                                                                                    Regional
                                                                                   Code 1=NE
                                                                                     2=MW       Program
                                    Institution   Program   Program                3=SA 4=SC      Size
Program ID Broad Field     Field      Name         Name     Website      Control      5=W       Quartile


           broad_field             institution_ program_n program_ur               region_cod program_si
program_ID _name       field_name name          ame        l           control     e           ze_quartile
rowheadr               xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
                                   xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
                                                           xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
                                                                       xxxxxxxxxx x                   111
           xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
                                                                               Student    Student
                                                                               Support    Support
    R            R            S            S        Research     Research         &          &
Rankings:    Rankings:    Rankings:    Rankings:     Activity:    Activity:   Outcomes: Outcomes:     Diversity:
   5th         95th          5th         95th          5th         95th          5th       95th          5th
Percentile   Percentile   Percentile   Percentile   Percentile   Percentile   Percentile Percentile   Percentile


rank_overal rank_overal rank_overal rank_overal rank_dim_r rank_dim_r rank_dim_s rank_dim_s rank_dim_d
l_r_5       l_r_95      l_s_5       l_s_95      srch_5     srch_95     tusupp_5   tusupp_95 iv_5
       111         111         111         111         111         111        111        111       111
                                                                         Avg.
                                                                      Completion
                                                                      Percentage
              Average                                                      :
             Number of                                     Percent of 8 Years or   Median
             Publication                                   First Year  Less for    Time to
              s (2000-                          Awards per Students Humanities; Degree
             2006) per    Average    Percent of Allocated   with Full 6 Years or (Full- and   Percent
Diversity:    Allocated   Citations Faculty with Faculty   Financial   Less for   Part-Time     with
  95th        Faculty,       per      Grants,    Member,    Support,    Other    Graduates), Academic
Percentile      2006     Publication   2006       2006     Fall 2005    Fields      2006       Plans
           fac_pubs_p                          fac_awards stu_frstyr_f                       stu_grads_
rank_dim_d er_allocate fac_cites_p fac_grants_ _per_alloca ull_supp_p completion time_to_de acad_plans
iv_95      d           er_pub      pct         ted         ct          _rate      gree       _pct
       111         111         111         111         111         111        111        111         111
           Non-Asian
            Minority
  Collects Faculty as    Female    Non-Asian
Data About a Percent    Faculty as  Minority               Internationa
   Post-    of Total    a Percent Students as  Female       l Students
Graduation Core and      of Total  a Percent Students as       as a     Average   Percent of
Employmen    New        Core and    of Total  a Percent     Percent of Number of Interdiscipli Average
      t    Domestic       New      Domestic    of Total        Total     Ph.D.s      nary        GRE
 (1=Yes; -  Faculty,     Faculty,  Students, Students,      Students, Graduated, Faculty,       Scores,
   1=No)     2006         2006     Fall 2005  Fall 2005      Fall 2005 2002-2006     2006      2004-2006
collects_out
comes_indi fac_minorit fac_female stu_minorit stu_female stu_internat stu_graduat fac_interdis
c            y_ur_pct   _pct      y_ur_pct    _pct       _pct         ed_n        c_pct        gre_score
         111        111       111        111         111         111          111         111         111
 Percent of
 First Year                                                             Assistant
 Students Is Student                                                   Professors    Tenured
    with      Work       Is Health                                        as a      Faculty as   Number of
  External    Space     Insurance    Number of               Number of Percent of   a Percent    Core and
Fellowships Provided?   Provided?     Student      Total     Allocated    Total      of Total      New
      ,     (1=Yes; -    (1=Yes; -   Activities   Faculty,    Faculty,  Faculty,     Faculty,     Faculty,
    2005      1=No)        1=No)     (Max=18)      2006        2006       2006        2006         2006
stu_externa             stu_health_
l_support_p stu_worksp insure_indi stu_activity             fac_allocat fac_asst_pr fac_tenured fac_core_n
ct          ace_indic c             _cnt        fac_total_n ed_n        of_pct      _pct        ew_n
        111         111        111         111          111         111         111         111         111
                                                                Percent of
                                                                 First Year    Percent of
                                                                 Students      First Year Percent of
                      Percent of Percent of      Percent of        with a      Students    First Year
                       Students    Students      First Year     Combinatio     with Both   Students
            Average      with         with        Students          n of        Internal      with
Number of   Annual     Research    Teaching         with        Fellowships   Fellowships Multiple    Orientation
Students   First Year Assistantsh Assistantsh   Institutional       and       and Internal Internal    for New
Enrolled, Enrollment, ips, Fall     ips, Fall   Fellowships     Traineeship   Assistantsh Assistantsh Graduate
Fall 2005 2002-2006      2005         2005         Alone              s            ips         ips     Students


stu_enrolle                                                stu_fel_trai stu_fel_ass stu_mult_a stu_activity
d_n         stu_frstyr_n stu_ra_pct stu_ta_pct stu_fel_pct nee_pct      t_pct       sst_pct     _code_1
        111          111         111        111        111         111          111         111 xxx
             Language                                                       On-campus
             Screening /                            Prizes /   Assistance Graduate     Formal     Active
Internationa Support                               Awards for / Training in Research Training in Graduate
  l Student    Prior to  Instruction Instruction Teaching or Proposal Conference Academic        Student
 Orientation Teaching     in Writing in Statistics Research      Writing        s     Integrity Association


stu_activity stu_activity stu_activity stu_activity stu_activity stu_activity stu_activity stu_activity stu_activity
_code_2      _code_3      _code_4      _code_5      _code_6      _code_7      _code_8      _code_9      _code_10
xxx          xxx          xxx          xxx          xxx          xxx          xxx          xxx          xxx
                                                                           Organized
   Staff     Financial                              Regular                Training to
Assigned to Support for                            Graduate     Annual        Help       Travel
    the         the      Posted                    Programs Review of       Students Support to
 Graduate    Graduate Academic          Dispute   Directors / All Enrolled Improve       Attend          Count of
 Student     Student    Grievance      Resolution Coordinator Doctoral      Teaching Professiona         Student
Association Association Procedure      Procedure s Meetings Students          Skills   l Meetings        Activities


stu_activity stu_activity stu_activity stu_activity stu_activity stu_activity stu_activity stu_activity stu_activity
_code_11 _code_12 _code_13 _code_14 _code_15 _code_16 _code_17 _code_18 _cnt
xxx          xxx          xxx          xxx          xxx          xxx          xxx          xxx                  111
                                                                                     GENERAL                       GENERAL     GENERAL      GENERAL
                                                                                     INFORMATIO                    INFORMAT    INFORMATIO   INFORMATIO




                                                                                                                                Regional
                                                                                                                              Code 1=NE
                     Broad                              Institution   Program         Program                                 2=MW 3=SA   Program
Program ID           Field                      Field     Name         Name           Website                      Control     4=SC 5=W Size Quartile

             broad_field                   institution_ program_na                                                             program_size
program_ID _name         field_name name                    me                program_url control                 region_code _quartile
rowheadr                 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
                                           xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
                                                                              xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
                                                                                                       xxxxxxxxxx x
             xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx        111
    20014050             Psychology ALPHA UNIVERSITY Clinical Psychology http:\clinpsych\xxxxxx.edu private
               Social and Behavioral Sciences                                                                                1            3
    20060059             Anthropology BETA UNIVERSITY Anthropology http:\anthro\xxxxxLLDLD.edu private
               Social and Behavioral Sciences                                                                                1            4
    20060062             Economics LAMBDA UNIVERSITY Economics
               Social and Behavioral Sciences                                                          private
                                                                                http:\econ\xxxxxxxxxxDDDRRRR.edu             1            2
    20060075 Humanities History            GAMMA UNIVERSITY History           http:\hist\xxxxxx.edu private                  1            2
    20060091             Political Science DELTA UNIVERSITY Political Science http:\polysci\xxxxxx.edu private
               Social and Behavioral Sciences                                                                                1            2
    R RANKINGS       R RANKINGS      S RANKINGS      S RANKINGS      DIMENSIONAL   DIMENSIONAL   DIMENSIONAL
                                                                       RANKINGS      RANKINGS      RANKINGS




                                                                                              Student
                                                                  Research     Research       Support
 R Rankings:     R Rankings:      S Rankings:     S Rankings:      Activity:    Activity:   & Outcomes:
     5th            95th              5th            95th            5th         95th           5th
  Percentile      Percentile       Percentile      Percentile     Percentile   Percentile    Percentile

                 rank_overall_r_ rank_overall_s rank_overall_s rank_dim_rsrc rank_dim_rsr rank_dim_stusup
rank_overall_r_5 95              _5              _95            h_5          ch_95         p_5
             111            111             111            111           111          111             111
              25              29               1              4            6           13              27
              25              31               3              8            1             4             28
              25              28               5            10             3             8             27
              26              31               4              9           27           31              29
               3               7               3              6           26           31              13
DIMENSIONAL      DIMENSIONAL      DIMENSIONAL    DIMENSIONAL     DATA: RESEARCH DATA: RESEARCH    DATA: RESEARCHDATA: RESEARCH
  RANKINGS         RANKINGS         RANKINGS       RANKINGS          ACTIVITY       ACTIVITY          ACTIVITY      ACTIVITY




                                                                  Average
                Student                                          Number of
                Support                                        Publications                     Percent of   Awards per
              & Outcomes:      Diversity:       Diversity:      (2000-2006)      Average       Faculty with  Allocated
                  95th            5th             95th         per Allocated   Citations per     Grants,      Faculty
               Percentile      Percentile       Percentile     Faculty, 2006   Publication        2006      Member, 2006

          rank_dim_stusu rank_dim_div_                 fac_pubs_per_ fac_cites_per_p fac_grants_pc fac_awards_pe
          pp_95          5             rank_dim_div_95 allocated     ub              t             r_allocated
                     111          111              111           111             111           111             111
                      31             5              10             5               2            45               4
                      31             4               9             4               2            33               2
                      31             3               6             3               4            46               3
                      31             8              14             2               3            60               2
                      25            10              13             2               4            21               3
DATA: RESEARCH   DATA: STUDENT   DATA: STUDENT   DATA: STUDENT    DATA: STUDENT DATA: STUDENT DATA: DIVERSITY DATA: DIVERSITY
    ACTIVITY      SUPPORT &       SUPPORT &       SUPPORT &        SUPPORT &     SUPPORT &
                  OUTCOMES        OUTCOMES        OUTCOMES         OUTCOMES      OUTCOMES



                                                                                          Non-Asian
          Percent of First                                                                 Minority       Female
          Year Students                    Median Time to                 Collects Data  Faculty as a  Faculty as a
             with Full        Average       Degree (Full-                  About Post-    Percent of    Percent of
             Financial       Completion    and Part-Time    Percent with   Graduation   Total Core and  Total Core
             Support,          Ratio,       Graduates),      Academic     Employment     New Faculty,    and New
             Fall 2005     6 Years or Less     2006            Plans     (1=Yes; -1=No)      2006      Faculty, 2006

          stu_frstyr_full_s                                  stu_grads_aca collects_outcom fac_minority_ur
          upp_pct            completion_rate time_to_degree d_plans_pct     es_indic        _pct            fac_female_pct
                        111              111             111            111            111              111            111
                          56              72               8             50               1               3             56
                          78              34               6             43              -1               7             66
                          34              87               7             66               1              15             45
                          22              62               7             42              -1               4             49
                          23              54               5             34               1               6             21
                                             DATA: DIVERSITY DATA: OTHER
DATA: DIVERSITY DATA: DIVERSITYDATA: DIVERSITY                                 DATA: OTHER   DATA: OTHER   DATA: OTHER
                                                           OVERALL RANKING                 OVERALL RANKING
                                                                             OVERALL RANKING             OVERALL RANKING
                                                              MEASURES          MEASURES      MEASURES      MEASURES



          Non-Asian
            Minority      Female    International
         Students as a Students as Students as a
          Percent of   a Percent of  Percent of   Average Number     Percent of                Percent of Students
             Total         Total        Total        of Ph.D.s     Interdisciplina Average GRE    with External
           Students,    Students,     Students,   Graduated, 2002-   ry Faculty,     Scores,      Fellowships,
           Fall 2005     Fall 2005    Fall 2005        2006             2006        2004-2006         2005

         stu_minority_u stu_female_p stu_internat_p                    fac_interdisc_p               stu_external_support
         r_pct          ct            ct             stu_graduated_n   ct              gre_score     _pct
                    111           111           111                111             111           111                 111
                     20            50              2                 3              20           500                  25
                     13            50              7                 2               0           550                  21
                     15            67             15                 5               0           632                   6
                      4            44              3                 8               0           476                  34
                      5            31              1                 3              13           455                   2
ATA: OTHER           DATA: OTHER     DATA: OTHER   DATA: OTHER DATA: NOT USED DATA: NOT USED        DATA: NOT USED DATA: NOT USED
RALL RANKING                                     OVERALL RANKING INRANKING
                   OVERALL RANKING OVERALL RANKING                               INRANKING             INRANKING      INRANKING
MEASURES              MEASURES        MEASURES      MEASURES




                                   Is Health                                                      Assistant         Tenured
               Is Student Work    Insurance      Number of                                      Professors as     Faculty as a
                    Space         Provided?       Student                        Number of       a Percent of      Percent of
                  Provided?        (1=Yes; -     Activities    Total Faculty,    Allocated      Total Faculty,   Total Faculty,
                (1=Yes; -1=No)       1=No)       (Max=18)          2006         Faculty, 2006       2006             2006

               stu_workspace_i stu_health_ins                                                     fac_asst_prof_p fac_tenured_pc
               ndic            ure_indic       stu_activity_cnt fac_total_n     fac_allocated_n ct                t
                           111            111               111             111               111             111            111
                             1              -1                4              12                10              20             50
                            -1              -1                3               6                 4              35             64
                            -1               1                0               8                 8              21             74
                             1               1                5              34                32               4             64
                             1               1                7              15                14               7             33
DATA: NOT USED DATA: NOT USED    DATA: NOT USED     DATA: NOT USED       DATA: NOT USED DATA: NOT USED          STUDENT
   INRANKING      INRANKING         INRANKING          INRANKING            INRANKING      INRANKING           ACTIVITIES




                                                                       Percent of
                                 Number of        Average Annual     Students with Percent of Students
            Number of Core       Students            First Year        Research      with Teaching      Orientation for
           and New Faculty,      Enrolled,          Enrollment,      Assistantship Assistantships, Fall New Graduate
                2006             Fall 2005           2002-2006        s, Fall 2005        2005             Students

                                                                                                           stu_activity_code
           fac_core_new_n   stu_enrolled_n     stu_frstyr_n          stu_ra_pct         stu_ta_pct         _1
                        111                111                 111                111                111   xxx
                          9                  6                   7                 59                 43                   4
                          5                 13                  15                 80                 23                   3
                          3                  4                   6                 64                  5                   2
                         24                  9                  12                 24                 67                   1
                         11                 10                  13                  6                  4   N/D
     STUDENT             STUDENT          STUDENT           STUDENT            STUDENT          STUDENT
    ACTIVITIES          ACTIVITIES       ACTIVITIES        ACTIVITIES         ACTIVITIES       ACTIVITIES




                     Language                                                Prizes /
  International      Screening /                                           Awards for        Assistance /
     Student       Support Prior to   Instruction in    Instruction in     Teaching or        Training in
   Orientation        Teaching           Writing          Statistics        Research       Proposal Writing

stu_activity_code_ stu_activity_cod stu_activity_code stu_activity_code_ stu_activity_cod stu_activity_code
2                   e_3              _4               5                  e_6              _7
xxx                 xxx              xxx              xxx                xxx              xxx
N/D                                4                1                  4                1                  4
                  2                3                2                  3                2                  3
                  2                2                3                  2                3                  2
                  2                1                4                  1                4                  1
                  2                4                3                  4                3                  4
      STUDENT          STUDENT          STUDENT           STUDENT              STUDENT              STUDENT
     ACTIVITIES       ACTIVITIES       ACTIVITIES        ACTIVITIES           ACTIVITIES           ACTIVITIES




On-campus             Formal                         Staff Assigned to Financial Support          Posted
 Graduate           Training in    Active Graduate     the Graduate     for the Graduate         Academic
 Research           Academic           Student            Student            Student             Grievance
Conferences          Integrity       Association        Association       Association            Procedure

stu_activity_co   stu_activity_cod stu_activity_code stu_activity_code_   stu_activity_code_1 stu_activity_cod
de_8              e_9              _10               11                   2                   e_13
xxx               xxx              xxx               xxx                  xxx                 xxx
              4                  3                 4                  3                     4                 4
              2                  2                 3 N/D                                    2                 3
              1   N/D                              2 N/D                                    3                 2
N/D                              3                 1 N/D                  N/D                                 1
              1                  3                 4                  3                     2                 4
 STUDENT          STUDENT           STUDENT             STUDENT          STUDENT           STUDENT            STUDENT
ACTIVITIES       ACTIVITIES        ACTIVITIES          ACTIVITIES       ACTIVITIES        ACTIVITIES         ACTIVITIES




                               Regular Graduate                   Organized
                                  Programs      Annual Review Training to Help Travel Support to
                Dispute           Directors /   of All Enrolled    Students         Attend                  Count of
               Resolution        Coordinators      Doctoral        Improve       Professional                Student
               Procedure          Meetings         Students     Teaching Skills    Meetings                 Activities

             stu_activity_cod stu_activity_code_1 stu_activity_co stu_activity_code stu_activity_code_
             e_14              5                  de_16            _17               18                 stu_activity_cnt
             xxx               xxx                xxx              xxx               xxx                              111
                             2                  4                3                 4                  4                14
                             2                  3                3                 3                  4                10
                             1                  2 N/D                              2 N/D                                 7
                             1                  1                1                 1                  2                  8
                             1                  4                1                 4                  2                  9
               Sep 2010 (v1)                                           Apr 21, 2011 (v2)               Changes v1 to v2   4/28/11 re- re-release (v3)
     Program ID          program_ID                        Program ID        program_ID                                         Program ID
     Broad Field         broad_field_name                  Broad Field       broad_field_name                                   Broad Field
         Field           field_name                            Field         field_name                                             Field
  Institution Name       institution_name               Institution Name     institution_name                                Institution Name
   Program Name          program_name                    Program Name        program_name                                     Program Name
  Program Website        program_url                    Program Website      program_url                                     Program Website
       Control           control                             Control         control                                              Control

 Regional Code 1=NE                                Regional Code 1=NE                                                      Regional Code 1=NE
2=MW 3=SA 4=SC 5=W region_code                    2=MW 3=SA 4=SC 5=W region_code                                          2=MW 3=SA 4=SC 5=W

Program Size Quartile program_size_quartile        Program Size Quartile program_size_quartile                            Program Size Quartile

R Rankings:       5th                              R Rankings:          5th                                               R Rankings:          5th
     Percentile          rank_overall_r_5               Percentile            rank_overall_r_5                                 Percentile

R Rankings:       95th                             R Rankings:       95th                                                 R Rankings:       95th
     Percentile          rank_overall_r_95              Percentile            rank_overall_r_95                                Percentile
S Rankings:       5th                              S Rankings:       5th                                                  S Rankings:       5th
     Percentile          rank_overall_s_5               Percentile            rank_overall_s_5                                 Percentile
S Rankings:      95th                              S Rankings:      95th                                                  S Rankings:      95th
     Percentile          rank_overall_s_95              Percentile            rank_overall_s_95                                Percentile
 Research Activity:                                 Research Activity:                                                     Research Activity:
          5th                                                5th                                                                    5th
     Percentile          rank_dim_rsrch_5               Percentile            rank_dim_rsrch_5                                 Percentile
 Research Activity:                                 Research Activity:                                                     Research Activity:
         95th                                               95th                                                                   95th
     Percentile          rank_dim_rsrch_95              Percentile            rank_dim_rsrch_95                                Percentile
  Student Support                                    Student Support                                                        Student Support
    & Outcomes:                                        & Outcomes:                                                            & Outcomes:
          5th                                                5th                                                                    5th
     Percentile          rank_dim_stusupp_5             Percentile            rank_dim_stusupp_5                               Percentile
  Student Support                                    Student Support                                                        Student Support
    & Outcomes:                                        & Outcomes:                                                            & Outcomes:
         95th                                               95th                                                                   95th
     Percentile          rank_dim_stusupp_95            Percentile            rank_dim_stusupp_95                              Percentile
Diversity:        5th                              Diversity:        5th                                                  Diversity:        5th
     Percentile          rank_dim_div_5                 Percentile            rank_dim_div_5                                   Percentile
Diversity:       95th                              Diversity:       95th                                                  Diversity:       95th
     Percentile          rank_dim_div_95                Percentile            rank_dim_div_95                                  Percentile
 Average Number of                                  Average Number of                                                      Average Number of
 Publications (2000-                                Publications (2000-                                                    Publications (2000-
 2006) per Allocated                                2006) per Allocated                                                    2006) per Allocated
    Faculty, 2006        fac_pubs_per_allocated        Faculty, 2006          fac_pubs_per_allocated                          Faculty, 2006
Average Citations per                              Average Citations per                                                  Average Citations per
     Publication         fac_cites_per_pub              Publication           fac_cites_per_pub                                Publication
  Percent of Faculty                                 Percent of Faculty                                                     Percent of Faculty
    with Grants,                                       with Grants,                                                           with Grants,
         2006            fac_grants_pct                     2006              fac_grants_pct                                       2006

Awards per Allocated fac_awards_per_allocat        Awards per Allocated                                                   Awards per Allocated
Faculty Member, 2006 ed                            Faculty Member, 2006 fac_awards_per_allocated                          Faculty Member, 2006


L:\IR\NRC\Use\2010PostingMaterials\NRC_DataShell.xlsx
                Sep 2010 (v1)                                         Apr 21, 2011 (v2)                  Changes v1 to v2        4/28/11 re- re-release (v3)
 Percent of First Year                               Percent of First Year                                                        Percent of First Year
  Students with Full                                  Students with Full                                                            Students with Full
  Financial Support,                                  Financial Support,                                                            Financial Support,
      Fall 2005          stu_frstyr_full_supp_pct         Fall 2005         stu_frstyr_full_supp_pct                                    Fall 2005

                                                       Avg. Completion                                                              Avg. Completion
                                                         Percentage:                                                                  Percentage:
 Average Completion                                   8 Years or Less for                                                          8 Years or Less for
       Ratio,                                       Humanities; 6 Years or                                                       Humanities; 6 Years or
   6 Years or Less       completion_rate             Less for Other Fields completion_rate               column heading change    Less for Other Fields

Median Time to Degree                               Median Time to Degree                                                        Median Time to Degree
 (Full- and Part-Time                                (Full- and Part-Time                                                         (Full- and Part-Time
     Graduates),                                          Graduates),                                                                  Graduates),
         2006            time_to_degree                      2006             time_to_degree                                              2006
Percent with Academic    stu_grads_acad_plans_      Percent with Academic                                                        Percent with Academic
         Plans           pct                                 Plans            stu_grads_acad_plans_pct                                    Plans
 Collects Data About                                 Collects Data About                                                          Collects Data About
   Post-Graduation                                     Post-Graduation                                                              Post-Graduation
Employment (1=Yes; -     collects_outcomes_indi          Employment                                                                   Employment
         1=No)           c                              (1=Yes; -1=No)        collects_outcomes_indic                                (1=Yes; -1=No)
                                                      Non-Asian Minority                                                           Non-Asian Minority
  Non-Asian Minority                                Faculty as a Percent of                                                      Faculty as a Percent of
Faculty as a Percent of                              Total Core and New                                                           Total Core and New
 Total Core and New                                   Domestic Faculty,                                                            Domestic Faculty,
    Faculty, 2006       fac_minority_ur_pct                  2006             fac_minority_ur_pct                                         2006

  Female Faculty as a                                 Female Faculty as a                                                          Female Faculty as a
 Percent of Total Core                               Percent of Total Core                                                        Percent of Total Core
and New Faculty, 2006 fac_female_pct                and New Faculty, 2006 fac_female_pct                                         and New Faculty, 2006

 Non-Asian Minority                                  Non-Asian Minority                                                           Non-Asian Minority
Students as a Percent                               Students as a Percent                                                        Students as a Percent
  of Total Students,                                  of Total Domestic                                                            of Total Domestic
      Fall 2005       stu_minority_ur_pct            Students, Fall 2005 stu_minority_ur_pct                                      Students, Fall 2005
Female Students as a                                Female Students as a                                                         Female Students as a
   Percent of Total                                    Percent of Total                                                             Percent of Total
      Students,                                           Students,                                                                    Students,
      Fall 2005       stu_female_pct                      Fall 2005       stu_female_pct                                               Fall 2005

International Students                              International Students                                                       International Students
 as a Percent of Total                               as a Percent of Total                                                        as a Percent of Total
       Students,                                           Students,                                                                    Students,
       Fall 2005       stu_internat_pct                    Fall 2005       stu_internat_pct                                             Fall 2005
  Average Number of                                   Average Number of                                                            Average Number of
  Ph.D.s Graduated,                                   Ph.D.s Graduated,                                                            Ph.D.s Graduated,
      2002-2006        stu_graduated_n                    2002-2006        stu_graduated_n                                             2002-2006
      Percent of                                          Percent of                                                                   Percent of
   Interdisciplinary                                   Interdisciplinary                                                            Interdisciplinary
     Faculty, 2006     fac_interdisc_pct                 Faculty, 2006     fac_interdisc_pct                                          Faculty, 2006

Average GRE Scores,                                 Average GRE Scores,                                                          Average GRE Scores,
     2004-2006      gre_score                            2004-2006      gre_score                                                     2004-2006

L:\IR\NRC\Use\2010PostingMaterials\NRC_DataShell.xlsx
                Sep 2010 (v1)                                         Apr 21, 2011 (v2)                Changes v1 to v2        4/28/11 re- re-release (v3)
                                                          Percent of                                                                  Percent of
  Percent of Students                                First Year Students                                                         First Year Students
      with External                                      with External                                                               with External
      Fellowships,       stu_external_support_p          Fellowships,                                                                Fellowships,
           2005          ct                                   2005          stu_external_support_pct   column heading change              2005
Is Student Work Space                              Is Student Work Space                                                       Is Student Work Space
  Provided? (1=Yes; -                                Provided? (1=Yes; -                                                         Provided? (1=Yes; -
          1=No)          stu_workspace_indic                 1=No)          stu_workspace_indic                                          1=No)
  Is Health Insurance                                Is Health Insurance                                                         Is Health Insurance
       Provided?                                          Provided?                                                                   Provided?
     (1=Yes; -1=No)      stu_health_insure_indic        (1=Yes; -1=No)      stu_health_insure_indic                                 (1=Yes; -1=No)
   Number of Student                                  Number of Student                                                           Number of Student
        Activities                                         Activities                                                                  Activities
        (Max=18)         stu_activity_cnt                  (Max=18)         stu_activity_cnt                                           (Max=18)
   Total Faculty, 2006   fac_total_n                  Total Faculty, 2006 fac_total_n                                             Total Faculty, 2006
  Number of Allocated                                Number of Allocated                                                         Number of Allocated
      Faculty, 2006      fac_allocated_n                 Faculty, 2006      fac_allocated_n                                          Faculty, 2006

 Assistant Professors                              Assistant Professors                                                         Assistant Professors
 as a Percent of Total                             as a Percent of Total                                                        as a Percent of Total
     Faculty, 2006       fac_asst_prof_pct             Faculty, 2006       fac_asst_prof_pct                                        Faculty, 2006
 Tenured Faculty as a                              Tenured Faculty as a                                                         Tenured Faculty as a
   Percent of Total                                   Percent of Total                                                             Percent of Total
     Faculty, 2006       fac_tenured_pct               Faculty, 2006       fac_tenured_pct                                          Faculty, 2006
 Number of Core and                                Number of Core and                                                           Number of Core and
  New Faculty, 2006      fac_core_new_n              New Faculty, 2006     fac_core_new_n                                         New Faculty, 2006
  Number of Students                                Number of Students                                                           Number of Students
       Enrolled,                                          Enrolled,                                                                    Enrolled,
       Fall 2005         stu_enrolled_n                   Fall 2005        stu_enrolled_n                                              Fall 2005
 Average Annual First                              Average Annual First                                                         Average Annual First
   Year Enrollment,                                  Year Enrollment,                                                             Year Enrollment,
      2002-2006          stu_frstyr_n                    2002-2006         stu_frstyr_n                                               2002-2006
 Percent of Students                               Percent of Students                                                          Percent of Students
    with Research                                      with Research                                                                with Research
 Assistantships, Fall                               Assistantships, Fall                                                         Assistantships, Fall
         2005            stu_ra_pct                         2005           stu_ra_pct                                                    2005
 Percent of Students                               Percent of Students                                                          Percent of Students
    with Teaching                                      with Teaching                                                                with Teaching
 Assistantships, Fall                               Assistantships, Fall                                                         Assistantships, Fall
         2005            stu_ta_pct                         2005           stu_ta_pct                                                    2005
                                                   Percent of First Year                                                        Percent of First Year
                                                       Students with                                                                Students with
 Orientation for New                                    Institutional                                                                Institutional
 Graduate Students       stu_activity_code_1        Fellowships Alone      stu_fel_pct                 new column                Fellowships Alone
                                                   Percent of First Year                                                        Percent of First Year
                                                      Students with a                                                              Students with a
                                                      Combination of                                                               Combination of
 International Student                                Fellowships and                                                              Fellowships and
      Orientation      stu_activity_code_2             Traineeships        stu_fel_trainee_pct         new column                   Traineeships




L:\IR\NRC\Use\2010PostingMaterials\NRC_DataShell.xlsx
                Sep 2010 (v1)                                        Apr 21, 2011 (v2)           Changes v1 to v2   4/28/11 re- re-release (v3)
                                                   Percent of First Year                                             Percent of First Year
                                                    Students with Both                                                Students with Both
Language Screening /                               Internal Fellowships                                              Internal Fellowships
  Support Prior to                                      and Internal                                                      and Internal
     Teaching        stu_activity_code_3              Assistantships       stu_fel_asst_pct      new column             Assistantships

                                                    Percent of First Year                                             Percent of First Year
                                                   Students with Multiple                                            Students with Multiple
 Instruction in Writing stu_activity_code_4       Internal Assistantships stu_mult_asst_pct      new column         Internal Assistantships
     Instruction in                                 Orientation for New                                               Orientation for New
       Statistics       stu_activity_code_5          Graduate Students stu_activity_code_1                             Graduate Students

 Prizes / Awards for                               International Student                                            International Student
Teaching or Research stu_activity_code_6                Orientation      stu_activity_code_2                             Orientation
                                                   Language Screening /                                             Language Screening /
 Assistance / Training                                Support Prior to                                                 Support Prior to
  in Proposal Writing stu_activity_code_7                Teaching        stu_activity_code_3                              Teaching

On-campus Graduate
Research Conferences stu_activity_code_8           Instruction in Writing stu_activity_code_4                        Instruction in Writing
  Formal Training in                                   Instruction in                                                    Instruction in
 Academic Integrity stu_activity_code_9                  Statistics       stu_activity_code_5                              Statistics

    Active Graduate                                 Prizes / Awards for                                              Prizes / Awards for
  Student Association stu_activity_code_10         Teaching or Research stu_activity_code_6                         Teaching or Research
 Staff Assigned to the
   Graduate Student                                Assistance / Training                                             Assistance / Training
      Association      stu_activity_code_11         in Proposal Writing stu_activity_code_7                           in Proposal Writing
 Financial Support for
 the Graduate Student                             On-campus Graduate                                                On-campus Graduate
      Association      stu_activity_code_12       Research Conferences stu_activity_code_8                          Research Conferences

   Posted Academic                                  Formal Training in                                                Formal Training in
 Grievance Procedure stu_activity_code_13           Academic Integrity    stu_activity_code_9                         Academic Integrity
  Dispute Resolution                                 Active Graduate                                                   Active Graduate
      Procedure      stu_activity_code_14          Student Association    stu_activity_code_10                       Student Association

  Regular Graduate                                 Staff Assigned to the                                            Staff Assigned to the
 Programs Directors /                                Graduate Student                                                 Graduate Student
Coordinators Meetings stu_activity_code_15              Association      stu_activity_code_11                            Association
 Annual Review of All                              Financial Support for                                            Financial Support for
  Enrolled Doctoral                                the Graduate Student                                             the Graduate Student
      Students        stu_activity_code_16              Association      stu_activity_code_12                            Association

Organized Training to
Help Students Improve                               Posted Academic                                                   Posted Academic
   Teaching Skills    stu_activity_code_17         Grievance Procedure stu_activity_code_13                          Grievance Procedure
  Travel Support to
 Attend Professional                                Dispute Resolution                                                Dispute Resolution
      Meetings        stu_activity_code_18              Procedure         stu_activity_code_14                            Procedure




L:\IR\NRC\Use\2010PostingMaterials\NRC_DataShell.xlsx
              Sep 2010 (v1)                                        Apr 21, 2011 (v2)           Changes v1 to v2   4/28/11 re- re-release (v3)

                                                    Regular Graduate                                                Regular Graduate
  Count of Student                                 Programs Directors /                                            Programs Directors /
     Activities      stu_activity_cnt             Coordinators Meetings stu_activity_code_15                      Coordinators Meetings
                                                   Annual Review of All                                            Annual Review of All
                                                    Enrolled Doctoral                                               Enrolled Doctoral
                                                        Students        stu_activity_code_16                            Students

                                                  Organized Training to                                           Organized Training to
                                                  Help Students Improve                                           Help Students Improve
                                                     Teaching Skills    stu_activity_code_17                         Teaching Skills
                                                    Travel Support to                                               Travel Support to
                                                   Attend Professional                                             Attend Professional
                                                        Meetings        stu_activity_code_18                            Meetings
                                                    Count of Student                                                Count of Student
                                                        Activities      stu_activity_cnt                                Activities




L:\IR\NRC\Use\2010PostingMaterials\NRC_DataShell.xlsx

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:5/12/2011
language:English
pages:24