Question
I will be providing this survey data to a researcher at my institution, but first I have a few questions about the information itself.
1. Table 3 in the xls file entitled Tables 1-8 2009-2010 Prelim.xls contains the information about tuition fees for foreign students that I am looking for. However, I notice that the questionnaire itself asks respondents to indicate whether they are reporting tuition fees at their institution per academic year, semester, per credit or other. It appears as if the $ values reported in the spreadsheet represent tuition fees per academic year, but I would like to confirm whether this is correct.
2. Based on the title of this excel spreadsheet, I am assuming that this is preliminary data and that a final report will be available at some point? When will this be available? Also, when will the data for 2010-2011 be available?
3. This is just a comment: Being a new DLI rep, I have much to learn. I was not expecting to find the results of this survey in an excel spreadsheet. (I assumed that the survey data was usually made available for SPSS).
Answer
Thank you for your questions about TLAC. We couldn't locate a file titled Tables 1-8 2009-2010 Prelim.xls. but suspect that you were referring to the file Tables 1-7 2009-2010Prelim.xls.
I spoke with our contacts for TLAC and they confirmed that:
1) The reference period for the data in the TLAC tables is the academic year. (After speaking with our contact I noticed that additional explanatory notes which may be of interest are available in the Footnotes tab of the spreadsheet.)
2) The DLI should be receiving final 2009-2010 and preliminary 2010-2011 TLAC data at the beginning of October. I will be sending out an announcement as soon as they are available on our FTP and website. Some final 2009-2010 and preliminary 2010-2011 TLAC data are scheduled to be released on Sept. 16 (there will be an announcement in The Daily) but we won't be receiving our tables until a few weeks later as we receive a wider set of tables that won't all be ready until the beginning of October.
3) You are correct that many of the data files in the DLI collection need to be consulted with statistical analysis applications such as SPSS. This applies to the public use microdata files (PUMFs) in our collection. The DLI collection also includes a large number of aggregate data files, many of which are in the areas of justice and education. Most of these aggregate data products are available in Excel format or Beyond 20/20 format. For additional information on aggregate data and microdata, you may be interested in the following section of the DLI Survival Guide which discusses different types of data (http://www.statcan.gc.ca/dli-ild/guide-trousse/guide-trousse/toc-tdm/3000276-eng.htm#diffagg).
I hope that this information is helpful. Please don't hesitate to contact us if you have any other questions.
Thursday, October 28, 2010
Dairy Quotas
Question
Is there a public source indicating the value of dairy quotas - amount needed to purchase, value of current quotas, etc.?
The student is most interested in Ontario, if this information differs by province.
Thanks in advance.
Answer
Data on quotas are also available through the Canadian Farm Financial Database and E-Stat. Detailed instructions from our agriculture contacts on how to locate these follow:
1. Canadian Farm Financial Database at http://cansim2.statcan.gc.ca/cgi-win/cnsmcgi.pgm?Lang=E&CANSIMFile=CFFD-BDFEAC/ESAS_SESA-eng.htm
Click Taxation Data Program (left menu)
In the box Data Type, select Revenues and Expenses of Farms, select year(s), geographical area(s), farm type (Dairy cattle and milk production) and revenue class. On the resulting table, the variable 'R458 Quota sale income - dollars' gives total amount, averages, farms reporting etc.
2. E-Stat
The student can access E-Stat for free at http://www.statcan.gc.ca/estat/licence-eng.htm.
In 'Search CANSIM in E-Stat', enter 'quota' in the search field. In the 3 tables, you will find variables like 'Quota, long-term assets', 'Current asset - quota', 'Quota -investment' and 'Quota - sales', by year and province. However, it is not broken down by farm type and does not precise what type of quota it refers to.
Additional data can also be extracted on a cost-recovery basis.
I hope that that these suggestions are helpful.
Additional Advice
This document may help http://www.milk.org/corporate/pdf/AboutUs-MilkPricing.pdf it is the DFO MILK PRICING REGULATION 11/10 MILK ACT, R.S.O. 1990, CHAPTER M-12, AS AMENDED that went into force on Sept. 1, 2010.
It gets a bit more complicated when determining the cost of milk see http://www.milk.org/corporate/pdf/AboutUs-FeesRegs.pdf
There is more information pertaining to the Ontario Dairy Farmers at http://www.milk.org/corporate/view.aspx?content=AboutUs/Regulations
Is there a public source indicating the value of dairy quotas - amount needed to purchase, value of current quotas, etc.?
The student is most interested in Ontario, if this information differs by province.
Thanks in advance.
Answer
Data on quotas are also available through the Canadian Farm Financial Database and E-Stat. Detailed instructions from our agriculture contacts on how to locate these follow:
1. Canadian Farm Financial Database at http://cansim2.statcan.gc.ca/cgi-win/cnsmcgi.pgm?Lang=E&CANSIMFile=CFFD-BDFEAC/ESAS_SESA-eng.htm
Click Taxation Data Program (left menu)
In the box Data Type, select Revenues and Expenses of Farms, select year(s), geographical area(s), farm type (Dairy cattle and milk production) and revenue class. On the resulting table, the variable 'R458 Quota sale income - dollars' gives total amount, averages, farms reporting etc.
2. E-Stat
The student can access E-Stat for free at http://www.statcan.gc.ca/estat/licence-eng.htm.
In 'Search CANSIM in E-Stat', enter 'quota' in the search field. In the 3 tables, you will find variables like 'Quota, long-term assets', 'Current asset - quota', 'Quota -investment' and 'Quota - sales', by year and province. However, it is not broken down by farm type and does not precise what type of quota it refers to.
Additional data can also be extracted on a cost-recovery basis.
I hope that that these suggestions are helpful.
Additional Advice
This document may help http://www.milk.org/corporate/pdf/AboutUs-MilkPricing.pdf it is the DFO MILK PRICING REGULATION 11/10 MILK ACT, R.S.O. 1990, CHAPTER M-12, AS AMENDED that went into force on Sept. 1, 2010.
It gets a bit more complicated when determining the cost of milk see http://www.milk.org/corporate/pdf/AboutUs-FeesRegs.pdf
There is more information pertaining to the Ontario Dairy Farmers at http://www.milk.org/corporate/view.aspx?content=AboutUs/Regulations
Credit Counselling Information
Question
Hello all. Not sure if anyone here can help, but if there is an answer, I'm sure I won't find a more-knowledgeable group to ask. Cheers and thanks.
Here’s the situation: from the mid-1960s until March 31, 1992, the province subsidized the operating expenses of non-profit credit counselling agencies in Ontario. Ideally, I’d like to know how much each agency received from the province in each year over this period. The annual Report of the Minister of Community and Social Services usually had a paragraph saying how many credit counselling agencies received funding; our library has these reports for 1973-1975 and 1978-82. The publication called Expenditures by Municipality shows how much each municipality received for credit counselling and we have the volumes for the three fiscal years ending in March 1975- March 1977. However, it’s not clear that there was only one credit counselling agency in each municipality (though this seems likely).
So one question is whether the other volumes of these two publications are available elsewhere (I assume the answer is ...yes.). The more difficult question is whether there is a list somewhere of which agency got how much money as opposed to which municipality got how much money.
A further question is how much money each agency got from the United Way over this period since the United Way was another major source of funds.
Answer
The Annual Report of the Minister of Community and Social Services appears to be available at the University of Windsor and Wilfrid Laurier University libraries:
AMICUS No. 19637618 2 Location(s) Ontario. Ministry of Community and Social Services. ANNUAL REPORT OF THE MINISTRY OF COMMUNITY AND SOCIAL SERVICES.
OWA 1972/1973-1983/1984 CA2ON SM.... ..A56 ENG (University of Windsor, Leddy Library)
OWTL PAPER: 1982/1983-1983/1984 : MICROFICHE: 1972/1973 -1981/1982 CA2ON SM A56 (Wilfrid Laurier University, Library)
The University of Waterloo and Wilfrid Laurier University seem to have a number of volumes of Expenditures by municipalities in their collection:
AMICUS No. 30018419 1 Location(s) Expenditures by municipality, Ontario Ministry of Community and Social Services. -- 1990
OWTL PAPER: 1975/1976-1977/1978; 1979/1980; 1981/1982; 1983 /1984 : MICROFICHE: 1974/1975; 1978/1979; 1980/1981; 1982/1983 CA2ON SM E85 (Wilfrid Laurier University, Library)
AMICUS No. 30377920 1 Location(s) EXPENDITURES BY MUNICIPALITY, ONTARIO.
OWTU 1969/70-1983/84 CA2ONSF E85 (Waterloo)
Lists of groups/organizations that have received United Way funding and grants and in some case the amount they received are included in some current local United Way publications. The researcher may wish to contact the United Way of Canada (http://www2.unitedway.ca/uwcanada/content.aspx?id=102&langtype=1033) to see if they have a national historical database with funding information. If they don't, the researcher could consider contacting the local United Ways directly to confirm what historical information they could provide.
This may be a bit of a long shot but the Archives of Ontario (http://www.archives.gov.on.ca/english/index.aspx; reference@ontario.ca) may have sources that detail how much money each non-profit credit counselling agency received from the government of Ontario during the period that interests the researcher. One could contact them as well to see what sources they would recommend.
I hope that these suggestions are helpful.
Hello all. Not sure if anyone here can help, but if there is an answer, I'm sure I won't find a more-knowledgeable group to ask. Cheers and thanks.
Here’s the situation: from the mid-1960s until March 31, 1992, the province subsidized the operating expenses of non-profit credit counselling agencies in Ontario. Ideally, I’d like to know how much each agency received from the province in each year over this period. The annual Report of the Minister of Community and Social Services usually had a paragraph saying how many credit counselling agencies received funding; our library has these reports for 1973-1975 and 1978-82. The publication called Expenditures by Municipality shows how much each municipality received for credit counselling and we have the volumes for the three fiscal years ending in March 1975- March 1977. However, it’s not clear that there was only one credit counselling agency in each municipality (though this seems likely).
So one question is whether the other volumes of these two publications are available elsewhere (I assume the answer is ...yes.). The more difficult question is whether there is a list somewhere of which agency got how much money as opposed to which municipality got how much money.
A further question is how much money each agency got from the United Way over this period since the United Way was another major source of funds.
Answer
The Annual Report of the Minister of Community and Social Services appears to be available at the University of Windsor and Wilfrid Laurier University libraries:
AMICUS No. 19637618 2 Location(s) Ontario. Ministry of Community and Social Services. ANNUAL REPORT OF THE MINISTRY OF COMMUNITY AND SOCIAL SERVICES.
OWA 1972/1973-1983/1984 CA2ON SM.... ..A56 ENG (University of Windsor, Leddy Library)
OWTL PAPER: 1982/1983-1983/1984 : MICROFICHE: 1972/1973 -1981/1982 CA2ON SM A56 (Wilfrid Laurier University, Library)
The University of Waterloo and Wilfrid Laurier University seem to have a number of volumes of Expenditures by municipalities in their collection:
AMICUS No. 30018419 1 Location(s) Expenditures by municipality, Ontario Ministry of Community and Social Services. -- 1990
OWTL PAPER: 1975/1976-1977/1978; 1979/1980; 1981/1982; 1983 /1984 : MICROFICHE: 1974/1975; 1978/1979; 1980/1981; 1982/1983 CA2ON SM E85 (Wilfrid Laurier University, Library)
AMICUS No. 30377920 1 Location(s) EXPENDITURES BY MUNICIPALITY, ONTARIO.
OWTU 1969/70-1983/84 CA2ONSF E85 (Waterloo)
Lists of groups/organizations that have received United Way funding and grants and in some case the amount they received are included in some current local United Way publications. The researcher may wish to contact the United Way of Canada (http://www2.unitedway.ca/uwcanada/content.aspx?id=102&langtype=1033) to see if they have a national historical database with funding information. If they don't, the researcher could consider contacting the local United Ways directly to confirm what historical information they could provide.
This may be a bit of a long shot but the Archives of Ontario (http://www.archives.gov.on.ca/english/index.aspx; reference@ontario.ca) may have sources that detail how much money each non-profit credit counselling agency received from the government of Ontario during the period that interests the researcher. One could contact them as well to see what sources they would recommend.
I hope that these suggestions are helpful.
Annual Estimates for Census Families and Individuals (T1 Family File)
Question
I have a researcher asking for Annual Estimates for Census Families and Individuals (T1 Family File). Statistics Canada web site indicates that the file supposed to be released on June 17, 2010. If it has been released, would you please let us know where we can locate it?
Answer
Products based on the Annual Estimates for Census Families and Individuals (T1 Family File) are available through CANSIM (see the CANSIM tables listed under Links to related products at http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4105&lang=en&db=imdb&adm=8&dis=2), through the DLI collection (see http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/saad-dra-eng.htm; these tables are at the Canada and province-level) and as custom products. The division that publishes these products creates them using data from administrative files from the T1 tax form they receive from the Canada Customs and Revenue Agency (CCRA) once a year. They have indicated that a microdata file with these data unfortunately isn't available.
The division expects to release 2008 data for the Small Area and Administrative Data Families spreadsheet that is in the DLI collection in late September (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/saad-dra-eng.htm).
I hope that this information is helpful. If you have any other questions, please do not hesitate to let me know.
I have a researcher asking for Annual Estimates for Census Families and Individuals (T1 Family File). Statistics Canada web site indicates that the file supposed to be released on June 17, 2010. If it has been released, would you please let us know where we can locate it?
Answer
Products based on the Annual Estimates for Census Families and Individuals (T1 Family File) are available through CANSIM (see the CANSIM tables listed under Links to related products at http://www.statcan.gc.ca/cgi-bin/imdb/p2SV.pl?Function=getSurvey&SDDS=4105&lang=en&db=imdb&adm=8&dis=2), through the DLI collection (see http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/saad-dra-eng.htm; these tables are at the Canada and province-level) and as custom products. The division that publishes these products creates them using data from administrative files from the T1 tax form they receive from the Canada Customs and Revenue Agency (CCRA) once a year. They have indicated that a microdata file with these data unfortunately isn't available.
The division expects to release 2008 data for the Small Area and Administrative Data Families spreadsheet that is in the DLI collection in late September (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/saad-dra-eng.htm).
I hope that this information is helpful. If you have any other questions, please do not hesitate to let me know.
National Survey of Nonprofit and Voluntary Organizations
Question
A professor has asked about a raw data file for the National Survey of Nonprofit and Voluntary Organizations (2003).
This survey is not listed as being in the DLI collection. I mentioned that the surveys for which pumfs end up in the DLI collection tend to be household surveys and not surveys of institutions or businesses. I would appreciate a definitive answer to his request though.
Answer
A public use microdata file (PUMF) could not be produced for the National Survey of Nonprofit and Voluntary Organizations (2003) due to confidentiality related requirements. The DLI will therefore not be receiving a microdata file for this survey.
The following publication is based on this survey and may be of interest to the professor:
Cornerstones of Community: Highlights from the National Survey of Nonprofit and Voluntary Organizations (61-533-XWE)
"This publication provides the first national portrait of the many thousands of nonprofit and voluntary organizations found in every Canadian community. The data, from the National Survey of Nonprofit and Voluntary Organizations, reveal a set of organizations that are widely diverse in nature, touching virtually every aspect of Canadians' lives." (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=61-533-X&lang=eng)
A professor has asked about a raw data file for the National Survey of Nonprofit and Voluntary Organizations (2003).
This survey is not listed as being in the DLI collection. I mentioned that the surveys for which pumfs end up in the DLI collection tend to be household surveys and not surveys of institutions or businesses. I would appreciate a definitive answer to his request though.
Answer
A public use microdata file (PUMF) could not be produced for the National Survey of Nonprofit and Voluntary Organizations (2003) due to confidentiality related requirements. The DLI will therefore not be receiving a microdata file for this survey.
The following publication is based on this survey and may be of interest to the professor:
Cornerstones of Community: Highlights from the National Survey of Nonprofit and Voluntary Organizations (61-533-XWE)
"This publication provides the first national portrait of the many thousands of nonprofit and voluntary organizations found in every Canadian community. The data, from the National Survey of Nonprofit and Voluntary Organizations, reveal a set of organizations that are widely diverse in nature, touching virtually every aspect of Canadians' lives." (http://www.statcan.gc.ca/bsolc/olc-cel/olc-cel?catno=61-533-X&lang=eng)
Wednesday, October 27, 2010
Labour Market Activity Among Seniors
An article entitled Labour market activity among seniors is being released today. This article uses census data to study labour market activity among senior men and women. Trends in seniors’ employment rates and occupational and industrial profiles are outlined. In addition, 2006 data are used to study factors associated with employment and work intensity.
Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm
Enclosed is the link to the Spotlight on the Census web page http://www12.statcan.ca/census-recensement/index-eng.cfm
Thursday, October 21, 2010
Data on Aboriginal Graduates and Aboriginal Faculty
Question
I was wondering whether any one has suggestions on possible sources for the following:
1. Number of Aboriginal Graduates by year [2005 - 2010] across universities in Canada. At the minimum, looking for figures for Medical/ Doctoral universities.
2. Number of faculty who identified themselves as Aboriginal by university. Would like to have the most recent data. At the minimum, looking for figures for Medical/ Doctoral universities.
I have looked at the Pan-Canadian Education Indicators Program (PCEIP) tables but these do not contain the desired breakdowns. I suspect that nothing beyond the information recorded in the Aboriginal Peoples Survey (2006) is likely to be available.
Answer
Our education contacts have indicated that, as you suspected, their surveys unfortunately wouldn't answer these questions. They have suggested that we look into what data are available through the Census.
You may wish to have a look at the following 2006 Census topic based tabulations some of which include data on Aboriginal Identity and Highest Certificate, Diploma or Degree (but not annually, nor by institution or type of institution unfortunately).
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Lp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=738&Temporal=2006&THEME=73&VID=0&VNAMEE=&VNAMEF=
The 2006 Census Individuals File PUMF includes an Aboriginal identity variable and an Occupation variable based on the 2006 National Occupational Classification for Statistics [NOC-S 2006] but the occupation breakdown is quite general (ex. Teachers and professors (E1)).
More detailed occupation related Census data by Aboriginal identity may be available as custom tables. If your client wishes to look into what tables could be produced on a custom basis, I would be happy to refer you to an Account Executive who could confirm what tables could be produced and at what cost.
The Aboriginal Peoples Survey 2006 (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/aps-eapa/aps-eapa-2006-eng.htm) appears to have collected education related data including the year in which the most recent certificate, diploma or degree was obtained and year when post-secondary education was last taken but not by institution however.
I was wondering whether any one has suggestions on possible sources for the following:
1. Number of Aboriginal Graduates by year [2005 - 2010] across universities in Canada. At the minimum, looking for figures for Medical/ Doctoral universities.
2. Number of faculty who identified themselves as Aboriginal by university. Would like to have the most recent data. At the minimum, looking for figures for Medical/ Doctoral universities.
I have looked at the Pan-Canadian Education Indicators Program (PCEIP) tables but these do not contain the desired breakdowns. I suspect that nothing beyond the information recorded in the Aboriginal Peoples Survey (2006) is likely to be available.
Answer
Our education contacts have indicated that, as you suspected, their surveys unfortunately wouldn't answer these questions. They have suggested that we look into what data are available through the Census.
You may wish to have a look at the following 2006 Census topic based tabulations some of which include data on Aboriginal Identity and Highest Certificate, Diploma or Degree (but not annually, nor by institution or type of institution unfortunately).
http://www12.statcan.gc.ca/census-recensement/2006/dp-pd/tbt/Lp-eng.cfm?LANG=E&APATH=3&DETAIL=0&DIM=0&FL=A&FREE=0&GC=0&GID=0&GK=0&GRP=1&PID=0&PRID=0&PTYPE=88971,97154&S=0&SHOWALL=0&SUB=738&Temporal=2006&THEME=73&VID=0&VNAMEE=&VNAMEF=
The 2006 Census Individuals File PUMF includes an Aboriginal identity variable and an Occupation variable based on the 2006 National Occupational Classification for Statistics [NOC-S 2006] but the occupation breakdown is quite general (ex. Teachers and professors (E1)).
More detailed occupation related Census data by Aboriginal identity may be available as custom tables. If your client wishes to look into what tables could be produced on a custom basis, I would be happy to refer you to an Account Executive who could confirm what tables could be produced and at what cost.
The Aboriginal Peoples Survey 2006 (http://www.statcan.gc.ca/dli-ild/data-donnees/ftp/aps-eapa/aps-eapa-2006-eng.htm) appears to have collected education related data including the year in which the most recent certificate, diploma or degree was obtained and year when post-secondary education was last taken but not by institution however.
Subscribe to:
Posts (Atom)