Get documents about "Excel - University of Colorado Boulder
Document Sample
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
