Docstoc

student_achievement

Document Sample
student_achievement Powered By Docstoc
					Student Achievement Database
Data Dictionary



                                        Updated: 06.05.2009
Over the next two decades, fewer young adults will be entering the workforce, and more, well-
educated older adults will be leaving. These demographic changes along with increased skill
demands in Washington’s workforce require that community and technical colleges achieve even
greater success with their future students. The Washington State Board for Community and
Technical Colleges has set raising achievement as one of three paramount goals in its System
Direction

In 2006-07, a system group working with input from national experts designed and empirically
tested a dataset to measure students as they advance to certificates, degrees and apprenticeships.
This Student Achievement Database has been built specifically to help colleges track their students
for the incremental gains they make during the year in basic skills, pre-college (college ready),
earning their first 15 and 1st 30 college level credits, earning their 1st 5 credits in college level math
or reasoning and for certificate, degree and apprenticeship awards. These gains are termed
“momentum points” because they add momentum to a student’s longer term success.

The database is constructed so that a college can see the college level momentum students have
behind them to start and the momentum they build during the academic year and to analyze
students to develop achievement strategies. Student characteristics and demographics are provided.
Most will be familiar- age, race/ethnicity, family status etc. Others have been specially constructed to
help. For example AidTypeInd is a summary field that pulls from financial aid Pell, State Need and
Opportunity Grants recipients to let you identify these populations specifically. There is also a
summary field for targeted programs to identify WorkFirst, Worker Retraining, I-BEST and
Corrections students. There are fields that show if a student earned 1st time points in a prior year.

Gains are calculated from WABERS, and the transcript files.
Colleges will be awarded funds based upon the total points improved. All students (except
International) in your college that appear in SMS are in this database.

Datasets start with AY’s 05-06 and 06-07 (the baseline year. Data are refreshed and added to
quarterly.

For further background and reports on the Student Achievement Initiative go to:
        http://www.sbctc.ctc.edu/college/e_studentachievement.aspx




                       If you have question regarding the Student Achievement Database,
                                         please contact David Prince at:
                                               dprince@sbctc.edu
                                                  360.704.4347
Student Achievement Database
Data Dictionary




                                            tblStuAchieve_Demographics:
   This table contains one record per student (SID) for each COHORTYEAR and COLLEGE. The table contains
                  student demographic information such as gender, race/ethnic origin, and age.

                           Note: the majority of the demographic elements are from the STUDENT table.
 CohortYear (PK)          Data Type: Text
                          Size: 3
                          Definition: Year being reported in the initiative
 SID (PK)                 Data Type: Text
                          Size: 9
                          Definition: A nine-character field used to uniquely identify a student. This identifier is assigned by
                          the college SM system.
 College (PK)             Data Type: Text
                          Size: 3
                          Definition: A three-digit code used to identify each community or technical college in the state of
                          Washington. College codes begin with the two-digit district code.
                          Valid Values:
                               280 Bates                    090 Highline                    065 Seattle Voc Institute
                              080   Bellevue                 260 Lake Washington               070 Shoreline
                              250   Bellingham               130 Lower Columbia                040 Skagit Valley
                              180   Big Bend                 030 Olympic                       240 South Puget Sound
                              300   Cascadia                 010 Peninsula                     171 Spokane
                              120   Centralia                110 Pierce District               170 Spokane District
                              140   Clark                    111 Pierce Fort Steilacoom        172 Spokane Falls
                              290   Clover Park              112 Pierce Puyallup               220 Tacoma
                              190   Columbia Basin           270 Renton                        200 Walla Walla
                              230   Edmonds                  062 Seattle Central               150 Wenatchee Valley
                              050   Everett                  060 Seattle District              210 Whatcom
                              020   Grays Harbor             063 Seattle North                 160 Yakima Valley
                              100 Green River                  064 Seattle South
 DW_KEY                   Data Type: Text
                          Size: 10
                          Definition: Used to uniquely identify a student. This identifier is assigned by the SBCTC.
 FirstYRQ                 Data Type: Text
                          Size: 4
                          Definition This is the first qtr in the academic year that the student is enrolled at the college.
                          Pulled: Last qtr enrolled in academic year
 LastYRQ                  Data Type: Text
                          Size: 4
                          Definition: This is the last qtr in the academic year that the student is enrolled at the college.
                          Pulled: Last quarter enrolled in academic Year




Last Revised: 9.29.2008                                                                                                        2 of 15
Student Achievement Database
Data Dictionary



 Acad_Disad_Ind           Data Type: Text
                          Size: 1
                          Definition A one-character code indicating a student’s enrollment in a course designated for students
                          who are academically disadvantaged, i.e., courses in the 32.XXXX or 33.XXXX (basic skills or
                          developmental) CIP code series.
                          Pulled: FirstYRQ enrolled in CohortYear
 AGE                      Data Type: Number
                          Size: Long Integer
                          Definition: The age of the student as of the first day of the year and quarter being reported.
                          Pulled: FirstYRQ enrolled in CohortYear
 Age_Grp_                 Data Type: Text
 Primary                  Size: 1
                          Definition: A one-character summary of age data grouped into four categories using the INT function
                          described in AGE. For example, everyone age 20.0 to 29.9 is in Age Group Primary 2.
                          Valid Values:
                                  1    Under 20                              4 40 or above
                                  2    20-29                             Null Age is blank
                                  3    30-39
 Age_Grp_                 Data Type: Text
 Secondary                Size: 1
                          Definition: A one-character summary of age data grouped into 11 categories using the INT function
                          described above. For example, everyone age 20.0 to 24.9 is in Age Group Secondary B.
                          Valid Values:
                                  A Under 20             D 30-34               H 50-54
                                  B 20-24                 E 35-39              I 55-59
                                  C 25-29                 F 40-44              J 60-64
                                                         G 45-49               K 65 or above
 Aid_Type_Ind             Data Type: Text
                          Size: 3
                          Definition: A 3 digit indicator to identify specific aid types a student may have received (1=
                          recipient,0=not a recipient)
                                   Byte 1= Pell Grant Recipient
                                   Byte 2= State Need Grant Recipient
                                   Byte 3 = Opportunity Grant Recipient
                          Pulled: from financial aid if student by award code, award status and a dollar value in award amount
                          in any aid quarter during the year.
 Disability               Data Type: Text
                          Size: 1
                          Definition: A one character code to indicate if a student is reported as disabled. This is a required
                          data element for State or Contract funding.
                          Pulled: FirstYRQ enrolled in CohortYear
                          Valid Values:
                          Y         Yes – reported a disability
                          N         No – did not report a disability




Last Revised: 9.29.2008                                                                                                  3 of 15
Student Achievement Database
Data Dictionary



 Econ_Disad_Ind           Data Type: Text
                          Size: 1
                          Definition: A one-character code that indicates whether a student received need based financial aid
                          in the year of enrollment. This is a required data element for State, Contract or Short Contract
                          funding.
                          For more specific information on Pell, State Need or Opportunity Grants see AIDTYPE IND
                          Pulled: FirstYRQ enrolled in CohortYear
 Fam_Stat                 Data Type: Text
                          Size: 2
                          Definition: A two-character field representing the student’s family status.
                          Pulled: FirstYRQ enrolled in CohortYear
                          Valid Values:
                                 11        Single parent with children or other dependents
                                 12        Couple with children or other dependents
                                 13        Without children or other dependents
                                 90        Other
                                 Null      Blank, No Response (99), and Not Required (XX)
 FT_PT_Indicator          Data Type: Text
                          Size: 10
                          Definition: Based on TotalCredits; 12+ = FT
                          Pulled: Last quarter in the academic year;
 Funding_Source           Data Type: Text
                          Size: 1
                          Definition: Prioritized,
                                  1    State support if student was full or partial state support at least 1 quarter in the
                                       academic year
                                  2    Contract, if not state in any quarter, and contract in at least 1 quarter;
                                  3    Student, if not state nor contract in any quarter and student in at least 1 quarter
                          Pulled: MIN of FUND_SOURCE_PRIORITY_CAT (See STUDENT table) in the academic year.
 Gender                   Data Type: Text
                          Size: 1
                          Definition: m= male; f= female
                          Pulled: Student table in last quarter enrolled in academic year
 Intent_First             Data Type: Text
                          Size: 1
                          Definition: Student’s Intent first YRQ enrolled in the Academic Year
 Intent_Last              Data Type: Text
                          Size: 1
                          Definition: Student’s Intent last YRQ enrolled in the Academic Year
 Kind_Of_                 Data Type: Text
 Basic_Skills             Size: 10
                          Definition: Starting (minimum) entry level in WABERS by program in ESL, ABE and GED
                          Pulled: WABERS. Student is assigned a minimum entry based upon the subject area and lowest pre-
                          test score when they enter in the academic year.




Last Revised: 9.29.2008                                                                                                  4 of 15
Student Achievement Database
Data Dictionary



 Kind_Of_                 Data Type: Text
 Student_First            Size: 1
                          Definition: A one-character field used to describe students by their purpose for attending during the
                          first YRQ enrolled during the academic year. W=Workforce; T= Transfer; B=Basic Skills as final goal;
                          z= other personal goal or reason
                          Pulled: Student table in first quarter of the academic year
 Kind_Of_                 Data Type: Text
 Student_Last             Size: 1
                          Definition: A one-character field used to describe students by their purpose for attending.
                          W=Workforce; T= Transfer; B=Basic Skills as final goal; z= other personal goal or reason
                          Pulled: Student table in last quarter of the academic year
 Prior_Educ               Data Type: Text
                          Size: 2
                          Definition: Collected from the student at time of Admission and Registration. Codes 99 (no response)
                          and XX (not required) are converted to null during Data Warehouse re-engineering.
                          Valid Values:
                                  10        Less than 9th Grade
                                  11        Less than high school graduation
                                  12        GED
                                  13        High school graduate
                                  14        Some post high school, no degree or certificate
                                  15        Certificate (less than two years)
                                  16        Associate Degree
                                  17        Bachelor's degree or above
                                  83**      Tech Prep
                                  90        Other
                                  Null      Blank
                          Pulled: Student table in the 1st quarter of the academic year. Note however, this data is coded when
                          the student started in the college. Use with caution for analysis to determine student’s starting
                          attainment at minimum taking into account students prior college level credits.
 ProgramCIP_              Data Type: Text
 First                    Size: 6
                          Definition: PROGRAM_CIP from the student table based on the first yrq enrolled in the cohort year.
 ProgramCIP_              Data Type: Text
 Last                     Size: 6
                          Definition: PROGRAM_CIP from the student table based on the last yrq enrolled in the cohort year.
 ProgramCode_             Data Type: Text
 First                    Size: 4
                          Definition: PROGRAM_CODE from the student table based on the first yrq enrolled in the cohort
                          year.
 ProgramCode_             Data Type: Text
 Last                     Size: 4
                          Definition: PROGRAM_CODE from the student table based on the last yrq enrolled in the cohort
                          year.




Last Revised: 9.29.2008                                                                                                   5 of 15
Student Achievement Database
Data Dictionary



 Race_Ethnic_         Data Type: Text
 Code                 Size: 1
                      Definition: Representing a single prioritized race and ethnic origin code per student.
                      Source: Derived during the quarterly Data Warehouse re-engineering process based on the
                      RACE_ETHNIC_IND and INTERNATIONAL_STUDENT data elements.
                      History: This data element was added in Summer Quarter, 2006 and retroactively populated back to
                      Summer Quarter 2000.
                      Valid Values:
                            Code      Race_Ethnic_Ind
                            1         100000 - Asian/Pacific Islander (including Hawaiian) only, non - Hispanic
                            2         010000 - African American only, non- Hispanic
                            3         001000 - Native American (American Indian or Alaskan Native) only, non-
                                      Hispanic
                            4         000100 - Latino
                            5         000010 - Multiracial or Other Race
                            6         000001 - White only, non-Hispanic
                            7         International_Student = Y
                            Blank International_Student = N or no Census_Race_Cd provided
                      Pulled: Student table in last quarter enrolled in academic year
 Race_Ethnic_         Data Type: Text
 Ind                  Size: 6
                      Definition: A six-digit indicator that represents each of the possible race/ethnic categories (exclusive of
                      international students). Each of the six digits is an “on/off” switch.
                      Source: This data element replaced ETH_ORIG in A341 given that students could identify themselves
                      in two categories from that time on. Derived during the quarterly Data Warehouse re-engineering
                      process    based      on   the    CENSUS_RACE_CD,            CENSUS_RACE_CD2,         HISPANIC       AND
                      INTERNATIONAL_STUDENT data elements.
                      The structure is as follows:
                            Byte    Description                               Census-Race-Cd
                                                                              or Census-Race-CD2
                            1       Asian/Pacific Islander                    600-699 or 976-985 and Hispanic = N
                                    (including Hawaiian)
                            2       African American                          870-934 and Hispanic = N
                            3       Native American (American Indian 000-599, 935-970 and Hispanic = N
                                    or Alaskan Native)
                            4       Latino                                    Hispanic = Y
                            5       Other, Multiracial                        750-799 and Hispanic = N
                            6       White                                     800-869 and Hispanic = N
                      History: This data element was added in Summer Quarter, 2006 and retroactively populated back to
                      Summer Quarter 2000.
                      Examples of Use: Used for summary analysis of race/ethnic background of students counting students
                      in two categories if they choose two or more race categories. Note that students with Hispanic = Y are
                      reported in only one race/ethnic category.
                      Some of the common multiple patterns include:
                      001001 - Native American (American Indian or Alaskan Native) and White, non- Hispanic
                      100001 - Asian/Pacific Islander (including Hawaiian) and White, non - Hispanic
                      Pulled: Student table in last quarter enrolled in academic year



Last Revised: 9.29.2008                                                                                                    6 of 15
Student Achievement Database
Data Dictionary


 RS_Status            Data Type: Number
                      Size: Byte
                      Definition: A summary field showing if a student is current or Former Running Start.
                      Valid Values:
                          1    Current RS in any quarter during the year
                          2- Former RS from a prior year


 SES                  Data Type: Number
                      Size: Byte
                      Definition: Socioeconomic quintile for the student based upon SES quintile for the student’s census
                      block group as a whole.
                      Valid Values:
                          1    Highest quintile
                          2- 2nd quintile
                          3- 3 rd quintile
                          4- 4th quintile
                          5- Lowest quintile

                      For further information on measuring student SES using Census proxies go to:
                      http://www.sbctc.ctc.edu/docs/data/research_reports/resh_06-4_socioeconstudy.doc
                      NOTE:       This    data     element      is    only     updated    for    the   final     year    end     data
                      The SES indicator should be use with caution. It is based upon the 2000 Census and therefore may be sensitive to
                      changes in the geographic areas in years further out from 2000.

 Targeted_            Data Type: Text
 Program_Ind          Size: 5
                      Definition: A 5 digit summary if the student was in a targeted program in any quarter during the year.
                      A “1” represents yes and a “0” represents no.
                              Byte 1: I-BEST (fee pay 42)
                              Byte 2: WorkFirst (Work Attend 74-79)
                              Byte 3: Worker Retraining (Work Attend in 80 series)
                              Byte 4: Corrections (Kind of Enrollment 38)
                              Byte 5: TechPrep (Transcripts SECT = “T#P”)




Last Revised: 9.29.2008                                                                                                        7 of 15
Student Achievement Database
Data Dictionary




                                                tblStuAchieve_Points:
   This table contains one record per student (SID) for each COHORTYEAR and COLLEGE. The table contains
                                                student point data.
 CohortYear (PK)          Data Type: Text
                          Size: 3
                          Definition: Year being reported in the initiative
 SID (PK)                 Data Type: Text
                          Size: 9
                          Definition: A nine-character field used to uniquely identify a student. This identifier is assigned by
                          the college SM system.
 College (PK)             Data Type: Text
                          Size: 3
                          Definition: A three-digit code used to identify each community or technical college in the state of
                          Washington. College codes begin with the two-digit district code.
                          Valid Values: see tblStuAchieve_Demographics
 DW_KEY                   Data Type: Text
                          Size: 10
                          Definition: Used to uniquely identify a student. This identifier is assigned by the SBCTC.
 BasicSkillsGain_         Data Type: Number
 Points                   Size: Byte
                          Definition: Multiple points can be garnered based upon the total number of CASAS gains made
                          during the year for all subjects pre and post-tested during the year or Federally Reportable and
                          received a GED. A High School Completion during the academic year is also counted as a gain. Only
                          tests where posttest > pretest are counted. Based on the highest post test score. Corrections students
                          (SID* in WABERS) are assigned back to the college where they are enrolled in the SMS.
                          Valid Values:
                                   Any number = The number of points earned
                                   Blank = No points earned
 CollegeReady             Data Type: Number
 PreEnglish_Point         Size: Byte
                          Definition: Multiple points can be garnered for the number of level advances made pre-college
                          English - Based on a listing of DeptDiv CourseNum data provided by the colleges. One level advance
                          is counted the first time a student earns any pre-college credit at the college's qualifying grade point
                          for moving to the next level in 1 or more courses assigned to a pre-college college level. This field is
                          included for analysis purposes.
                          Valid Values:
                                   Any number = The number of points earned for pre-college English
                                   Blank = No points earned




Last Revised: 9.29.2008                                                                                                     8 of 15
Student Achievement Database
Data Dictionary



 CollegeReady             Data Type: Number
 PreMath_Points           Size: Byte
                          Definition: Multiple points can be garnered for the number of level advances made pre-college Math
                          - Based on a listing of DeptDiv CourseNum data provided by the colleges. One level advance is
                          counted the first time a student earns any pre-college credit at the college's qualifying grade point for
                          moving to the next level in 1 or more courses assigned to a pre-college college level.This field is
                          included for analysis purposes.
                          Valid Values:
                                   Any number = The number of points earned for pre-college math
                                   Blank = No points earned
 CollegeReady             Data Type: Number
 Total_Points             Size: Byte
                          Definition: Multiple points can be garnered for the number of level advances made pre-college math
                          and English - Based on a listing of DeptDiv CourseNum data provided by the colleges. One level
                          advance is counted the first time a student earns any pre-college credit at the college's qualifying
                          grade point for moving to the next level in 1 or more courses assigned to a pre-college college level.
                          Valid Values:
                                   Any number = The number of points earned
                                   Blank = No points earned
 15ClvlCr_Point           Data Type: Number
                          Size: Byte
                          Definition: This point can be garnered one time in the student’s cumulative transcript history. It
                          includes all prior community and technical college level credits earned in the system. To garner the
                          point, the student must have earned less than 15 college level credits in the system coming into the
                          year and then reach 15 or more college level credits cumulatively in the system during the year. All
                          colleges where the student attends during the academic year and earns at least 5 college level credits
                          are awarded with the point.
                          Valid Values:
                                   1 = Earned one point
                                   Blank = No point earned
 30ClvlCr_Point           Data Type: Number
                          Size: Byte
                          Definition: This point can be garnered one time in the student’s cumulative transcript history. It
                          includes all prior community and technical college level credits earned in the system. To garner the
                          point, the student must have earned less than 30 college level credits in the system coming into the
                          year and then reach 30 or more college level credits cumulatively in the system during the year. All
                          colleges where the student attends during the academic year and earns at least 5 college level credits
                          are awarded with the point.
                          Valid Values:
                                   1 = Earned one point
                                   Blank = No point earned




Last Revised: 9.29.2008                                                                                                      9 of 15
Student Achievement Database
Data Dictionary



 QuantCourse_             Data Type: Number
 Point                    Size: Byte
                          Definition: A single point is garnered at the college, the first time a student earns at least 5 college
                          credits in college level computation (technical programs) or quantitative reasoning (math/logic)
                          classes in the system. Based on a listing of DeptDiv CourseNum data provided by the colleges or
                          college level courses with CIP Code 27 series.
                          Valid Values:
                                   1 = Earned one point
                                   Blank = No point earned
 TippingPoint             Data Type: Number
                          Size: Byte
                          Definition: This point can be garnered when the student receives an Exit_Cds 1 -5 certificate, degrees
                          or apprenticeship award. It includes all Alpha awards. Exit_Cd 4 certificates also count if the student
                          has earned at least 45 college level credits cumulatively in the system by end of year. Awards earned
                          during the academic year are counted. Students who earned at least 45 college level credits
                          cumulatively in the system by the end of the year but who received an Exit_Cd 4 in a previous year
                          are also given 1 point.
                          Valid Values:
                                   1 = Earned one point
                                   Blank = No point earned
 TotalPoints              Data Type: Number
                          Size: Byte
                          Definition: Total number of points garnered in the achievement points. In the achievement system,
                          points garnered are compared to the previous highest total points garnered by the college.
                          Valid Values:
                                   0 = No points earned
                                   Any number = The total number of points earned
 CollegeReady             Data Type: Text
 Eng_Attempted            Size: 1
                          Definition: A Y/N flag that indicates if the student enrolled and attempted any pre-college English
                          course. The pre-college English courses include those that are defined in the
                          tblStuAch_PreEngLevels table.
                          Valid Values:
                                   Y = Yes, the student was enrolled in at least one pre-college English course
                                   N = No, the student did not attempt any pre-college English courses
 CollegeReady             Data Type: Text
 Math_Attempted           Size: 1
                          Definition: A Y/N flag that indicates if the student enrolled and attempted any pre-college math
                          course. The pre-college math courses include those that are defined in the tblStuAch_PreMathLevels
                          table.
                          Valid Values:
                                   Y = Yes, the student was enrolled in at least one pre-college English course
                                   N = No, the student did not attempt any pre-college English courses




Last Revised: 9.29.2008                                                                                                    10 of 15
Student Achievement Database
Data Dictionary



 CLVLAttempted            Data Type: Number
                          Size: Decimal
                          Definition: Total college level credits attempted at the college during the academic year. This data
                          element in combination with the next element for prior college level credits earned may be useful
                          in data analysis to determine potential students. For example students who attempt at least 5
                          college credits in the year, but earned less than 15 or 30 college credits entering the year are
                          students who could have potentially garnered these points.
                          Pulled: from transcript file
 CLVLEarnedPrior          Data Type: Number
                          Size: Decimal
                          Definition: Total college level credits earned in system prior to start of academic year.
 Highest Attainment       Data Type: Text
 This Year _    Exit      Size: 1
 Code                     Definition: Prioritized Exit_Cd for the highest award attained at the college during the academic
                          year. This field allows a student to be counted once even if they earned more than one award
                          during the year.
                          Prioritization is based on the following:
                                 Priority       Award
                                 1              Bachelor Degree (exit code “U”)
                                 2              2 year degree (exit code 1 or alpha)
                                 3              Apprenticeship (exit code 5)
                                 4              Certificate >= 90 credits or 1800 hrs (exit code 2)
                                 5              Certificate, 45-89 credits or 900-1799 hours (exit code 3 or 4)
 Highest Attainment       Data Type: Text
 This Year _              Size: 1
 Award Type               Definition: The Award_Type associated to the Highest Attainment This Year Exit Code. This field
                          allows for grouping by type of award earned.

                                Award Type Award
                                0              Workforce Completion (exit_cd 9)
                                2              General Studies (exit_cd 1 and program_cip 240101)
                                3              Workforce Award (exit_cd 1,2,3,4,5, or T and program_cip <>240101)
                                4              Academic Award (alpha exit_cds except T, U and Z)
                                5              Bachelor Degree
 Highest                  Data Type: Text
 Attainment ThisYear      Size: 6
 _Program CIP             Definition: The Program CIP Code associated to the Highest Attainment This Year Exit Code.




Last Revised: 9.29.2008                                                                                                11 of 15
Student Achievement Database
Data Dictionary


 Highest                  Data Type: Text
 Attainment               Size: 15
 ThisYear_                Definition: Associated to the Highest Attainment This Year Exit Code that allows for another
 Grouping                 method of grouping types of awards.

                           Grouping                 Includes Awards
                           Bachelor                 Bachelor Degrees
                           Transfer                 DTA, AS-T, MRP and Non-DTA awards
                           Workforce                AAS-T awards
                           Certificate              Short and Long-term certificates
                           Apprenticeship           Apprenticeship awards
 Highest                  Data Type: Text
 AttainmentPrior          Size: 1
                          Definition: Prioritized Exit_Cd for highest award attained in the system prior to the academic
                          year. Prioritization is based on the following:
                           Priority             Award
                           1                    Bachelor Degree (exit code “U”)
                           2                    2 year degree (exit code 1 or alpha)
                           3                    Apprenticeship (exit code 5)
                           4                    certificate >= 90 credits or 1800 hrs (exit code 2)
                           5                    Certificate, 45-89 credits or 900-1799 hours (exit code 3 or 4)
 Momentum                 Data Type: Text
 SummaryInd               Size: 7
                          Definition: A six digit bit field indicating the student’s momentum gains.
                          Structure:
                                  Byte 1 = TippingPoint = 1
                                  Byte 2 = TippingPoint is null and QuantCourse_Point = 1
                                  Byte 3 = TippingPoint is null and QuantCourse_Point is null and 30CLVLCR_Point = 1
                                  Byte 4 = TippingPoint is null and QuantCourse_Point is null and 30CLVLCR_Point = is
                                   null and 15CLVLCr_Point = 1
                                  Byte 5 = TippingPoint is null and QuantCourse_Point is null and 30CLVLCR_Point = is
                                   null and 15CLVLCr_Point is null and CollegeReady_Total_Points > 0
                                  Byte 6 = TippingPoint is null and QuantCourse_Point is null and 30CLVLCR_Point = is
                                   null and 15CLVLCr_Point is null and BasicSkillsGain_Points > 0
                                  Byte 7 = No momentum
 PriorClvl                Data Type: Text
 PointsCat                Size: 1
                          Definition: A summary of the CLVLEarnedPriorCat data element.
                          Valid Values:
                                  1 = No prior college credits earned
                                      CLVLEarnedPriorCat = “000”
                                  2 = Some prior college credits earned but no math credits
                                       CLVLEarnedPriorCat = “??0”
                                  3 = Has prior college level quant credits –
                                       CLVLEarnedPriorCat = “??1”




Last Revised: 9.29.2008                                                                                             12 of 15
Student Achievement Database
Data Dictionary



 PriorClvl                Data Type: Text
 PointsInd                Size: 3
                          Definition: A 3 digit summary if a student earned her first 15, 1 st 30 or college Quant prior to the
                          year.
                          Definition:
                                   Byte 1= earned 15 or more clvl credits prior to year
                                   Byte 2= earned 30 or more clvl credits prior to year
                                   Byte 3 = earned 5 quant credits prior to year
                          This data element can be useful for analyzing and sorting potential points from points already
                          earned. I t may be helpful in identifying students who are potentially close to the “tipping point”
                          during the year.
 QuantCourses             Data Type: Number
 EarnedPrior              Size: Decimal
                          Definition: Set to 1 if student earned 5 quant credits prior to academic year in system. Useful for
                          analysis to determine students who could have potentially garnered the quantitative/computation
                          point. Students who garnered it in a prior year would not have been eligible.




In addition to the main Student Achievement Database, 3 smaller tables are included for the specific
courses being counted for pre-college English and math and college math and reasoning.
     tblLU_StuAch_QuantCourses
     tblLU_StuAch_PreEngLevels
     tblLU_StuAch_PreMathLevels

SBCTC engineering utilizes these lookup tables to determine if a record should be included in the
StudentAchievement database. Records are only included where the college has declared and had approved
a particular course.




                                         tblLU_StuAch_QuantCourses
        These tables contain one record per course (COURSE_NUM) for each DEPT_DIV per COLLEGE.
COLLEGE (PK)          Data Type: Text
                      Size: 3
                      Definition: college
DEPT_DIV (PK)         Data Type: Text
                      Size: 5
                      Definition: department division course is under
COURSE_NUM            Data Type: Text
(PK)                  Size: 4
                      Definition: course number



Last Revised: 9.29.2008                                                                                                     13 of 15
Student Achievement Database
Data Dictionary




            tblLU_StuAch_PreEngLevels & tblLU_StuAch_PreMathLevels
    These tables contain one record per course (COURSE_NUM) for each DEPT_DIV. These tables are listed
  together in the documentation as the first five elements have the same definition. Please note the distinction
                           between the table definitions for the data element LEVEL.
COLLEGE (PK)          Data Type: Text
                      Size: 3
                      Definition: the college code
DEPT_DIV (PK)         Data Type: Text
                      Size: 5
                      Definition: department division the course is under
COURSE_NUM            Data Type: Text
(PK)                  Size: 4
                      Definition: the course number
COURSE_TITLE          Data Type: Text
                      Size: 24
                      Definition: the course title
GPA                   Data Type: Decimal
                      Precision: 3 Scale: 2
                      Definition: This element is obtained from the college for students who earn any pre-college credits
                      with the college’s minimum grade necessary to advance to the next level course.
LEVEL                 Level: Pre-college English and math courses identified by course number and department division are
                      given a 1-4 ranking. The course list has been vetted by the colleges (not all colleges have all levels).
                      These course numbers will remain in place for the proposed 5 year measurement period. In addition
                      colleges provided qualifying grades for satisfactory completion and advancement. Most colleges have
                      a C- (1.75) or C (2.0) minimum standard. In cases where the grade qualifier is null, no qualifier will be
                      applied. S or P will be counted the same as a C or higher for purposes of grade qualifier.
                      When there is more than one course at a given level - completion or enrollment in any one of the
                      courses meets the requirement of being in or completing the level.
                      The levels were assigned as follows:

                      PreEngLevels
                       4 Highest level of pre college English -right before the college level, maybe more than 1
                           option - either meets requirement
                       3 Right below level 4, may be more than one option - any one meets requirement
                          2   (if used) Right below level 3 - again if more than one option any meets requirement
                          1   (if used) - Lowest level


                      PreMathLevels
                       4 Highest level of pre college Math - Intermediate Algebra more than 1 option - either
                          meets requirement
                       3 Right below level 4, may be more than one option - any one meets requirement
                          2   (if used) Right below level 3 - again if more than one option any meets requirement
                          1   (if used) - Lowest level if Pre-algebra (there are lower Arithmetic classes - but did not
                              include - generally)



Last Revised: 9.29.2008                                                                                                   14 of 15
Student Achievement Database
Data Dictionary




                                                     Queries
qryBasicSkillsInCollegeLevelCourse   Returns count of basic skills students enrolled in college level courses
qryIBESTPoints                       Returns sum of points earned by students enrolled in IBEST courses
qryTotalPoints                       Returns sum of points earned by students enrolled for each type of point available
qryTotalPointsByKOS                  Returns sum of points earned by students enrolled for each type of point available
                                     by KindOfStudent
qryUnduplicatedMomentumByKOS         Returns the count of students by the highest momentum category reached during
                                     the year
                                     See: tblStuAchieve_Points-MomentumSummaryInd for structure
qryWorkerRetrainingPoints            Returns sum of points earned by Worker Retraining students for each type of point
                                     available
qryWorkfirstPoints                   Returns sum of points earned by Workfirst students for each type of point available
qryTotalPoints                       Returns sum of points earned by students enrolled for each type of point available
qryTotalPointsByKOS                  Returns sum of points earned by students enrolled for each type of point available
                                     by KindOfStudent
qryUnduplicatedMomentumByKOS         Returns the count of students by the highest momentum category reached during
                                     the year
                                     See: tblStuAchieve_Points-MomentumSummaryInd for structure
qryWorkerRetrainingPoints            Returns sum of points earned by Worker Retraining students for each type of point
                                     available
qryWorkfirstPoints                   Returns sum of points earned by Workfirst students for each type of point available
qryOppGrantsWithAidIndicator         Returns the SID for students who received an Opportunity Grant in at least one
                                     quarter of the year.
                                     Students with “1?1” are Opportunity with Pell;
                                     Students with “0?1” are Opportunity Only
qryOppGrantsYearQtrFirst             Returns SID for Opportunity students with first quarter enrollment in fall. In
                                     Opportunity Study this query was used to create cohorts to measure for retention in
                                     spring and to analyze achievement.
qryOppGrantsYearQtrFirst             Returns SID for Opportunity students that started fall quarter by their prior college
byPriorClvlCAt                       level category- (1)= little to no prior college (2)=some college no prior college math
                                     (3)=completed college math.
                                     This query tells you students’ achievement at start of year.
qryOppGrantsYearQtrFirst             Returns SID for Opportunity students that started fall quarter by their prior college
byPriorClvlIndicator                 level indicator- (000)= little to no prior college (100 and 110)=These two indicators
                                     both count as cat 2, but 100 means student has at least 15 college credits to start; 110
                                     means student has at least 30 college credits to start; (??1)= student completed math-
                                     cat 3. But also shows the credit thresholds. Most students in category 3 are usually
                                     111.
qryOppGrantsMomenutmSummary          Returns a crosstab for opportunity students who started in fall quarter. Counts
byPriorCLVLCAT                       students in each priorclvlcat and the highest achievement they earned during the
                                     year.




Last Revised: 9.29.2008                                                                                              15 of 15

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:9/29/2011
language:English
pages:15