1 / 15

AERO Workshop: Constructing and Using OUAC and OCAS Datasets

AERO Workshop: Constructing and Using OUAC and OCAS Datasets. Dr. Robert S. Brown Organizational Development/ Research and Information Services Toronto District School Board. Presentation to HEQCO - June 19, 2009. Part 1: OUAC Datasets. Open the OUAC e-mail you will receive from AERO

winter-walton
Download Presentation

AERO Workshop: Constructing and Using OUAC and OCAS Datasets

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. AERO Workshop:Constructing and Using OUAC and OCAS Datasets Dr. Robert S. Brown Organizational Development/ Research and Information Services Toronto District School Board Presentation to HEQCO - June 19, 2009

  2. Part 1: OUAC Datasets

  3. Open the OUAC e-mail you will receive from AERO • Create folder ‘postsec08’ in your ‘C’ hard drive. • Save the files in the OUAC e-mail to the folder ‘postsec08’. • Open SPSS. Then open all the SPSS syntax files in the ‘postsec08’ folder.

  4. Run the file ‘read ouac file.sps’ • This will read the text file BEXT_66052_2008.txt • Which has a selection of OUAC application and confirmation records Note: Your file for 2008 should be the same, except that ‘66052’ would be replaced with your Board ID number.

  5. GET DATA • /TYPE=TXT • /FILE='C:\postsec08\BEXT_66052_2008.txt' • /FIXCASE=1 • /ARRANGEMENT=FIXED • /FIRSTCASE=1 • /IMPORTCASE=ALL • /VARIABLES= • /1 REFYR 0-3 F4.0 • REFNO 4-9 F6.0 • SCHOOL 10-15 F6.0 • SSSN 16-27 F12.0 • OEN 28-36 F9.0 • SURNAM 37-66 A30 • GIVENM 67-96 A30 • SEX 97-97 F1.0 • BIRTHD 98-105 F8.0 • CNFCHS 106-107 F2.0 • CNFPGM 108-110 A3 • CNFUNI 111-112 F2.0 • CNFPGG 113-114 F2.0 • FILLER 115-126 F12.0 • ACTCHS 127-128 F2.0 • PGM1 129-131 A3 • UNIVD1 132-133 F2.0 • PGMCD1 134-135 F2.0 • YR1 136-136 F1.0 • ENR1 137-137 A1 • PFT1 138-138 F1.0 • FILLER2 139-140 F2.0

  6. You should now have an SPSS dataset

  7. Advantage of this dataset: can provide limited analysis based on school, gender, age of student. • Disadvantage: student did not necessarily attend the board and school in the 2007-8 school year.

  8. CROSSTABS • /TABLES= CNFCHS CNFPGG BY sex • /FORMAT= AVALUE TABLES • /CELLS= COUNT ROW . • execute. • FREQUENCIES VARIABLES=CNFUNI • /FORMAT=DFREQ • /ORDER=ANALYSIS. • execute.

  9. AERO Workshop:Constructing and Using OUAC and OCAS Datasets Dr. Robert S. Brown Organizational Development/ Research and Information Services Toronto District School Board Thank you Presentation to HEQCO - June 19, 2009 R08(Post-SecReport\Post-Secondary PPTs\PPT OUAC Dataset19June09) ig.3457)

More Related