datatel ipeds report setup populating the federal cohort group field l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
DATATEL IPEDS Report Setup – Populating the Federal Cohort Group Field PowerPoint Presentation
Download Presentation
DATATEL IPEDS Report Setup – Populating the Federal Cohort Group Field

Loading in 2 Seconds...

play fullscreen
1 / 26

DATATEL IPEDS Report Setup – Populating the Federal Cohort Group Field - PowerPoint PPT Presentation


  • 435 Views
  • Updated on

DATATEL IPEDS Report Setup – Populating the Federal Cohort Group Field. Paul G. Earls Research Analyst Central Piedmont Community College. IPEDS Cohort Assignment Queries.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

DATATEL IPEDS Report Setup – Populating the Federal Cohort Group Field


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
    Presentation Transcript
    1. DATATEL IPEDS Report Setup – Populating the Federal Cohort Group Field Paul G. Earls Research Analyst Central Piedmont Community College

    2. IPEDS Cohort Assignment Queries In order for the IPEDS Federal Reports in Datatel to operate properly, the field STA.FED.COHORT.GROUP in the STUDENT.ACAD.LEVELS file must be properly populated. The queries presented here were written to accomplish this.

    3. IPEDS Cohort Assignment Queries These queries came about through the collaborative efforts of: Vicki Strayer and her staff at NCCCS along with: Charles Cox and IT staff at Central Piedmont Community College.

    4. IPEDS Cohort Assignment Queries Overview • Create needed Virtual Field • Test Virtual Field • Run Query IPEDS_Full_Time.wis • Run Query IPEDS_Part_Time.wis • Update student cohorts

    5. 1) Create Virtual Field The following virtual field will need to be created to pull the students’ educational goal into the STUDENT.TERMS file. 1) TOOL ->ST -> DCC Demand Columns: STTR.STUDENT PST.EDUC.GOALS Comp Column Code: string[] xlResult1; key xKeyPersonSt for file PersonSt; xKeyPersonSt = vSttrStudent; xlResult1 = vlPstEducGoals; return xlResult1;

    6. 1) Create Virtual Field (cont.) Logical File Name: STUDENT.TERMS Bundle: USER Display Size: 2 Justification: L Left Report Header: EDU Goal Single/Multivalue: M Multi Once all of the above information is entered generate the computed column by entering Yes in the Generate field. Click Save. If computed column generates without error you will be returned to a dialog box.

    7. 2) Test Virtual Field To test X.STTR.PST.EDUC.GOALS run the following Query:

    8. 2) Test Virtual Field (cont.) If Virtual Field worked correctly the output from the query will contain data within the EDU Goal column.

    9. 3) Run IPEDS Full Time Query Run the IPEDS_Full_Time.wis query.  When IPEDS_Full_Time.wis is executed a prompt will appear asking you for the Fall Term, Fall Start Term, and Summer Start Term. Enter the terms needed (ex: 2007FA). Then click Ok. The results are created in the Saved List FED.COHORT.FT.

    10. 4) Run IPEDS Part Time Query Run the IPEDS_Full_Time.wis query.  When IPEDS_part_Time.wis is executed a prompt will appear asking you for the Fall Term, Fall Start Term, and Summer Start Term. Enter the terms needed (ex: 2007FA). Then click Ok. The results are created in the Saved List FED.COHORT.PT.

    11. 5) Update Student Cohorts Go to CHGA – Cohort Group Assignment. Student records will be updated on STAL – Student Academic Level once this process is executed. This process will need to be executed twice. The first time will be for the full time students and will use the FED.COHORT.FT saved list. The second time will be for the part time students and will use the FED.COHORT.PT saved list. Federal Cohort Group: Enter the Cohort Group to be assigned. (Ex: 2007FT or 2007PT) Saved List Name: Enter the saved list name created that corresponds to the Cohort Group (FT or PT) Save and update.

    12. 5) Update Student Cohorts (cont.)

    13. Now You Can Setup For Your Federal IPEDS Reports

    14. Steps To Setup For IPEDS Reports 1) Enter parameters into IPEDS Inst Char Params (ICHP) screen 2) Enter parameters into IPEDS Fall Enrollment Params (IFEP) screen 3) Enter parameters into IPEDS GRS Report Parameters (IPRM) screen

    15. 1) Enter parameters into IPEDS Inst Char Params (ICHP) screen

    16. 2) Enter parameters into IPEDS Fall Enrollment Params (IFEP) screen

    17. 3) Enter parameters into IPEDS GRS Report Parameters (IPRM) screen

    18. IPEDS Fall Enrollment Survey (IFES) Screen First run the (W)ork File Build – Save & Update

    19. Enter H for Output Device – Save and Update

    20. Enter N for Execute in Background Mode – Save and Update

    21. And Now We Wait!

    22. And Wait!

    23. ….And Wait! For CPCC this process takes about 6 hours – it will vary depending on the size of your institution

    24. IPEDS Fall Enrollment Survey (IFES) Screen And Finally (R)un the Report – Save & Update

    25. Q & A

    26. Paul G. EarlsResearch AnalystCentral Piedmont Community CollegePhone: 704-330-6399FAX: 704-330-6013Email: paul.earls@cpcc.edu