Question:
A researcher is looking to know how many people with Law degrees there are in the Ottawa-Gatineau CMAs and where these might fall in the hierarchy of Highest certificate, diploma or degree achieved (specifically, Bachelor’s / Master’s / Doctorate) for the 2016 census.
I think I have found the right Classification of Instructional Programs (CIP) to get the required breakdown (under “22. Legal professions and studies”), but I am currently unsure how to cross-tabulate these for the specified region.
Might this require a custom tabulation? Any help is appreciated!
Answer:
“You can use this table (98-400-X2016241): Highest Certificate, Diploma or Degree (15), Major Field of Study - Classification of Instructional Programs (CIP) 2016 (82), Age (9) and Sex (3) for the Population Aged 15 Years and Over in Private Households of Canada, Provinces and Territories, Census Metropolitan Areas and Census Agglomerations, 2016 Census - 25% Sample Data
Highest Certificate, Diploma or Degree (15), Major Field of Study - Classification of Instructional Programs (CIP) 2016 (82), Age (9) and Sex (3) for the Population Aged 15 Years and Over in Private Households of Canada, Provinces and Territories, Census Metropolitan Areas and Census Agglomerations, 2016 Census - 25% Sample Data
From the dropdown menu for ‘Major field of study - Classification of Instructional Programs’, select 22. Legal professions and studies and change ‘Geography’ to ‘Ottawa-Gatineau’ to view the data on the web.
You can also download the whole table in .csv and use filter or download the beyond 20/20 format and change the dimensions of the variables you want to display.”
Wednesday, May 30, 2018
Economic Performance of Ontario Graduates
Question:I have a Masters student who is interested in looking at how Ontario graduates perform economically pre 2003 and post 2003. She seems pretty wedded to using the Census and DoB to differentiate between pre/post graduates-- in addition to including place of origin, language, income and marital status.
Does Ontario have a suitably anonymized dataset that might meet her needs? Another option would be to apply to the RDC but I don't think her timeline would accommodate that.
Answer:“The National Graduates Survey (NGS) has data regarding students who graduated in 2000 and in 2005.
The following link provides a list of CANSIM tables that provide data from the survey:
http://www5.statcan.gc.ca/COR-COR/COR-COR/objList?lang=eng&srcObjType=SDDS&srcObjId=5012&tgtObjType=ARRAY
Please see the attached CANSIM table user guide. In each table, click the ‘Add/Remove data’ tab to uncheck ‘Canada’ and check ‘Ontario’. Scroll down and click ‘Apply’.”
The DLI has the NGS PUMFS from 1982-2013 available through Nesstar Webview. The following are direct links to the cycles that Subject Matter has referenced: National Graduate Survey, 2000 - Follow-up and National Graduate Survey, 2005.
If the student wanted to explore the variables available on the master file, they are also available through Nesstar. The following are direct links to the zero frequency master files: National Graduate Survey, 2002 - Follow-up and National Graduate Survey, 2005.
The NGS is also available on the EFT at: /MAD_PUMF_FMGD_DAM/Root/5012_NGS_END/
Does Ontario have a suitably anonymized dataset that might meet her needs? Another option would be to apply to the RDC but I don't think her timeline would accommodate that.
Answer:“The National Graduates Survey (NGS) has data regarding students who graduated in 2000 and in 2005.
The following link provides a list of CANSIM tables that provide data from the survey:
http://www5.statcan.gc.ca/COR-COR/COR-COR/objList?lang=eng&srcObjType=SDDS&srcObjId=5012&tgtObjType=ARRAY
Please see the attached CANSIM table user guide. In each table, click the ‘Add/Remove data’ tab to uncheck ‘Canada’ and check ‘Ontario’. Scroll down and click ‘Apply’.”
The DLI has the NGS PUMFS from 1982-2013 available through Nesstar Webview. The following are direct links to the cycles that Subject Matter has referenced: National Graduate Survey, 2000 - Follow-up and National Graduate Survey, 2005.
If the student wanted to explore the variables available on the master file, they are also available through Nesstar. The following are direct links to the zero frequency master files: National Graduate Survey, 2002 - Follow-up and National Graduate Survey, 2005.
The NGS is also available on the EFT at: /MAD_PUMF_FMGD_DAM/Root/5012_NGS_END/
Tuesday, May 29, 2018
LFS pre and post 1975
Question:
I have a student looking at provincial unemployment rates from the 1960s to present. She’s using the LFS. More specifically, she’s using the Seasonally adjusted labour force statistics for 1966-1972 and the Historical labour force statistics for 1973 to 1989 and CANSIM 282-0002 for 1990 to present, although I think 282-0002 goes back to 1976.
282-0002 doesn’t state if those annual provincial unemployment rates are seasonally adjusted or unadjusted anywhere I can see. In the Historical labour force statistics (1973-1989), the annual unemployment rate can be found in the unadjusted seasonally table. Are the provincial unemployment rates in 282-0002 unadjusted seasonally? Would those figures be comparable with the provincial unemployment rates in the Historical labour force statistics (which are unadjusted seasonally)? Are pre and post 1975 LFS annual unemployment rates comparable?
Answer:
“If the client is referring to annual average data, they are all calculated using monthly unadjusted data. Thus, CANSIM table 282-002 are annual average data based on the average of 12 months of unadjusted data. If the client wants to use monthly seasonally adjusted, I would advise him to use CANSIM table 282-0087. It goes all the way to January 1976.”
I have a student looking at provincial unemployment rates from the 1960s to present. She’s using the LFS. More specifically, she’s using the Seasonally adjusted labour force statistics for 1966-1972 and the Historical labour force statistics for 1973 to 1989 and CANSIM 282-0002 for 1990 to present, although I think 282-0002 goes back to 1976.
282-0002 doesn’t state if those annual provincial unemployment rates are seasonally adjusted or unadjusted anywhere I can see. In the Historical labour force statistics (1973-1989), the annual unemployment rate can be found in the unadjusted seasonally table. Are the provincial unemployment rates in 282-0002 unadjusted seasonally? Would those figures be comparable with the provincial unemployment rates in the Historical labour force statistics (which are unadjusted seasonally)? Are pre and post 1975 LFS annual unemployment rates comparable?
Answer:
“If the client is referring to annual average data, they are all calculated using monthly unadjusted data. Thus, CANSIM table 282-002 are annual average data based on the average of 12 months of unadjusted data. If the client wants to use monthly seasonally adjusted, I would advise him to use CANSIM table 282-0087. It goes all the way to January 1976.”
Friday, May 25, 2018
Higher Education in R & D
Question:
I have a researcher here who’s looking for stats or data on higher ed and R&D (classification of programs, educational attainment, etc. ). I know there are several surveys that address the subject specifically (HERD, RDHES to name a couple) but they appear not to be accessible to us.
Are there other resources he might access to find similar content? Failing that, are these surveys available through custom tabs?
Follow-up Question:
I have done some further research into HERD, and have gained access to the CAUBO databases, which has provided me with university financial information regarding various groups of research expenses. I have, however, come across an issue. The data collection citations of all HERD estimates state .
"HERD uses two main sources of data found in the public domain: the Canadian Association of University Business Officers (CAUBO) and the University and College Academic Staff System (UCASS). CAUBO provides data on sponsored research and operating expenditures of all relevant universities. UCASS is the source of academic professor counts at the postsecondary level by subject taught. The extracted data are used to derive and produce aggregated HERD estimates by funder, province and science type, in the higher education sector."
Looking at 2015, Statscan notes that HERD is estimated at 12892.4 (in millions of dollars) making the Expenditure on Higher Education R&D almost 13 billion dollars. However, CAUBO accounts for only, at most, roughly 7 billion dollars of this expense, from what I can see.
Essentially, my question is, where is the remaining 6 billion dollars? Certainly, some of it must go into research hospitals, poly-techs and independent colleges, but CAUBO does not seem to have this information. If that is the case, then I am also confused as to where Statscan is drawing this data from.
Answer:
“HERD & HE R&D personnel currently belongs to ISTD.
Higher Education (HE) RD expenditure and HE personnel data are modelled.
For HERD expenditures CAUBO data provides the non-sponsored research and development amount. The model estimates non-sponsored research expenditure based on time-use coefficients applied to UCASS data. Additional indirect costs of research are also added. The higher education sector universe encompasses postsecondary institutions (universities, colleges) as well as research centres and affiliate teaching hospitals. Estimates for medical research from hospitals are also derived from the model. So the additional $6 billion covers these expenses. Details on the model can be found here:
o Estimation of research and development expenditures in the higher education sector - PDF, 109.82[PDF, 109.82 kb]
The initial question seems to have been regarding Higher education personnel and table 358-0159. HE R&D personnel are also modelled. It should be noted up front that all R&D Personnel is meant to represent R&D full-time equivalents only. So 1 FTE can represent 10 employees working only 10% of their time on R&D or 2 employees working 50% of their time on R&D. The HERD model includes time-use coefficients to determine the amount of time university academics (professors) spend on R&D. The administrative source for information on the counts of full-time university professors comes from the Higher Education in Research and Development (HERD) model which uses data from the University and College Academic Staff System (UCASS). Information on doctoral student counts is obtained from the Post-Secondary Student Information System (PSIS). Post-doctoral researcher information is obtained from external granting councils that keep track of the information on postsecondary R&D applicants. Postdoctoral fellowship information is a key variable that is obtained from the three granting councils: Natural Sciences and Engineering Research Council (NSERC) is used to allocate natural science R&D, Social Sciences and Humanities Research Council (SSHRC) is used for social science R&D and the Canadian Institutes for Health Research (CIHR) health science R&D.
We were hoping to start a HE sector survey this fiscal to benchmark this sectors expenditures and personnel, but unfortunately funding has been delayed.”
I have a researcher here who’s looking for stats or data on higher ed and R&D (classification of programs, educational attainment, etc. ). I know there are several surveys that address the subject specifically (HERD, RDHES to name a couple) but they appear not to be accessible to us.
Are there other resources he might access to find similar content? Failing that, are these surveys available through custom tabs?
Follow-up Question:
I have done some further research into HERD, and have gained access to the CAUBO databases, which has provided me with university financial information regarding various groups of research expenses. I have, however, come across an issue. The data collection citations of all HERD estimates state .
"HERD uses two main sources of data found in the public domain: the Canadian Association of University Business Officers (CAUBO) and the University and College Academic Staff System (UCASS). CAUBO provides data on sponsored research and operating expenditures of all relevant universities. UCASS is the source of academic professor counts at the postsecondary level by subject taught. The extracted data are used to derive and produce aggregated HERD estimates by funder, province and science type, in the higher education sector."
Looking at 2015, Statscan notes that HERD is estimated at 12892.4 (in millions of dollars) making the Expenditure on Higher Education R&D almost 13 billion dollars. However, CAUBO accounts for only, at most, roughly 7 billion dollars of this expense, from what I can see.
Essentially, my question is, where is the remaining 6 billion dollars? Certainly, some of it must go into research hospitals, poly-techs and independent colleges, but CAUBO does not seem to have this information. If that is the case, then I am also confused as to where Statscan is drawing this data from.
Answer:
“HERD & HE R&D personnel currently belongs to ISTD.
Higher Education (HE) RD expenditure and HE personnel data are modelled.
For HERD expenditures CAUBO data provides the non-sponsored research and development amount. The model estimates non-sponsored research expenditure based on time-use coefficients applied to UCASS data. Additional indirect costs of research are also added. The higher education sector universe encompasses postsecondary institutions (universities, colleges) as well as research centres and affiliate teaching hospitals. Estimates for medical research from hospitals are also derived from the model. So the additional $6 billion covers these expenses. Details on the model can be found here:
o Estimation of research and development expenditures in the higher education sector - PDF, 109.82[PDF, 109.82 kb]
The initial question seems to have been regarding Higher education personnel and table 358-0159. HE R&D personnel are also modelled. It should be noted up front that all R&D Personnel is meant to represent R&D full-time equivalents only. So 1 FTE can represent 10 employees working only 10% of their time on R&D or 2 employees working 50% of their time on R&D. The HERD model includes time-use coefficients to determine the amount of time university academics (professors) spend on R&D. The administrative source for information on the counts of full-time university professors comes from the Higher Education in Research and Development (HERD) model which uses data from the University and College Academic Staff System (UCASS). Information on doctoral student counts is obtained from the Post-Secondary Student Information System (PSIS). Post-doctoral researcher information is obtained from external granting councils that keep track of the information on postsecondary R&D applicants. Postdoctoral fellowship information is a key variable that is obtained from the three granting councils: Natural Sciences and Engineering Research Council (NSERC) is used to allocate natural science R&D, Social Sciences and Humanities Research Council (SSHRC) is used for social science R&D and the Canadian Institutes for Health Research (CIHR) health science R&D.
We were hoping to start a HE sector survey this fiscal to benchmark this sectors expenditures and personnel, but unfortunately funding has been delayed.”
Questions about use of PUMFs
Question:
The requesting user is an adjunct faculty member at the University (“in good standing”), but wishes to use the data for a non-University related consulting job with outside nonprofits.
My reading is that she is an authorized user, but the language around authorized use is a little ambiguous, despite my having read the case studies. Access is granted for licensed users to use the data for “research and statistical purposes”.
I don’t see anything that specifically says that the research and statistical analysis needs to be academic in nature, but is that implied? Or is it fine for her to conduct research for pay on behalf of an outside client as long as she only shares with her client the results of her analysis and not the underlying data?
Answer:
Your interpretation is correct, it is implied that the research and statistical analysis needs to be academic in nature. Even if the adjunct faculty member were to only be sharing the results of her analysis and not the underlying data, her use of the data for a non-University related consulting job with outside nonprofits would fall outside of the licence agreement.
The requesting user is an adjunct faculty member at the University (“in good standing”), but wishes to use the data for a non-University related consulting job with outside nonprofits.
My reading is that she is an authorized user, but the language around authorized use is a little ambiguous, despite my having read the case studies. Access is granted for licensed users to use the data for “research and statistical purposes”.
I don’t see anything that specifically says that the research and statistical analysis needs to be academic in nature, but is that implied? Or is it fine for her to conduct research for pay on behalf of an outside client as long as she only shares with her client the results of her analysis and not the underlying data?
Answer:
Your interpretation is correct, it is implied that the research and statistical analysis needs to be academic in nature. Even if the adjunct faculty member were to only be sharing the results of her analysis and not the underlying data, her use of the data for a non-University related consulting job with outside nonprofits would fall outside of the licence agreement.
Question about GAF 2001
Question:
We have a student who is looking for the Geographic Attribution File for 2001, we’re having a difficult time locating it so I’m wondering if it exists, we can find other years.
Answer:
Subject Matter has informed us that the 2001 GAF was not disseminated. It was available through GeoSuite as blocks (renamed Dissemination Block in 2006). An Excel file (CB2001.xlsx) of the GeoSuite extraction that was made using GeoSuite 2001 is available on the Statistics Canada website: http://www12.statcan.gc.ca/census-recensement/2011/geo/ref/geosuite-eng.cfm. You can download GeoSuite 2001 from the link above, do a name search for Canada, select CB (Census Block) and export the fields needed.
We have a student who is looking for the Geographic Attribution File for 2001, we’re having a difficult time locating it so I’m wondering if it exists, we can find other years.
Answer:
Subject Matter has informed us that the 2001 GAF was not disseminated. It was available through GeoSuite as blocks (renamed Dissemination Block in 2006). An Excel file (CB2001.xlsx) of the GeoSuite extraction that was made using GeoSuite 2001 is available on the Statistics Canada website: http://www12.statcan.gc.ca/census-recensement/2011/geo/ref/geosuite-eng.cfm. You can download GeoSuite 2001 from the link above, do a name search for Canada, select CB (Census Block) and export the fields needed.
Thursday, May 24, 2018
CCHS Nutrition Slides / ECCS Nutrition presentation
Question:
I’m wondering when these slides will be posted in the DLI Training Repository? I’d like to point some faculty members to the presentation.
Answer:
The CCHS/ESCC Nutrition slides have now been uploaded to the DLI Training Repository.
Please see the links below:
2015 Canadian Community Health Survey (CCHS) – Nutrition
Enquête sur la santé dans les collectivités canadiennes (ESCC) – Nutrition de 2015
I’m wondering when these slides will be posted in the DLI Training Repository? I’d like to point some faculty members to the presentation.
Answer:
The CCHS/ESCC Nutrition slides have now been uploaded to the DLI Training Repository.
Please see the links below:
2015 Canadian Community Health Survey (CCHS) – Nutrition
Enquête sur la santé dans les collectivités canadiennes (ESCC) – Nutrition de 2015
Subscribe to:
Posts (Atom)