Social science research methods books borrowed

Here are the books I just borrowed to help me learn social science research methods.

Miller, Robert L. and John D. Brewer. eds.The A-Z of social research : a dictionary of key social science research concepts (London; SAGE, 2003).

There are about a hundred entries on research topics in this book. I will study various entries here for my paper and started with reading the entry on social simulations.

Scarbrough, Elinor and Eric Tanenbaum. eds. Research strategies in the social sciences : a guide to new approaches (Oxford, England: Oxford University, 1998).

This is a quantitative research book based on the Essex summer school in data analysis that has been going since 1967. The summer school has apparently been quite influential within European social sciences. It also relates to the Michigan summer school on political studies. I think that's what the intro to this book said. I will not read this book to help with my paper.

Schratz, Michael and Rob Walker. Research as social change : new opportunities for qualitative research (London: Routledge, 1995).

This book seems inspiring but I will not read it for my paper.

Second Life as an anthropological study

I found this book on the new book shelves on the social science floor at the university of Ottawa library yesterday. I am almost through the first chapter. Here is the citation:

Boellstorff, Tom. Coming of age in second life : an anthropologist explores the virtually human (Princeton: Princeton University, 2008).

The virtual world as a culture for ethnographic study.

I read the first chapter of Petra Kelly's book.

Her first chapter is about feminism and is titled: Women and Power. Here is the full citation:

Kelly, Petra. Women and Power in Thinking Green! (Berkeley, Cal.: Parallax Press, 1994).

I am deep in patriarchal society. I can connect her to cyber feminists and third world feminism.

Reading about knowledge industries, wage differences by age and gender, the educational premium, and the educational fields premium.

My reading these days is full of statistical modeling of wages and other economics variables. I have been gaining an education in economics and micro economics. This evening I finally read a Statistics Canada document for my thesis. I have been so busy at work that I have not worked on my thesis. Another big time user the past month as been my board of directors work with a non-profit. Other volunteering has also kept me busy.

Here is the citation for the paper I read tonight.

Morissette, Rene, Yuri Ostrovsky and Garnett Picot. "Relative Wage Patterns Among the Highly Educated in a Knowledge-based Economy." Analytical Studies Branch Research Paper Series. Statistics Canada Catalogue no. 11F0019MIE2004232 (Ottawa, Statistics Canada, 2004)

This paper has a clear SIC code division of high knowledge, middle knowledge and low knowledge, industries they borrowed from elsewhere. I would like to use these studies from elsewhere or at least review these studies. The wages analysed and the other parts of the analysis in this analytical paper are not so important in my research. But I should note that these more demographic variables may effect knowledge management policies and effects of knowledge management in firms. My brief search of current Ph.D research on knowledge management showed this. But this search had been meant to find that combination of demographics and knowledge management. So whether there is strength in this or of what direction this effect has is still not clear. But catagorising knowledge management firms is something I should deal with in my paper so I am off to the library web site now or google scholar, and Statistics Canada's web site to find these elsewhere studies.

The two other studies are cited here.

Lee, F. and H. Has. “A Quantitative Assessment of High-knowledge Industries Versus Low-knowledge Industries” in P. Howitt (ed.), The Implications of Knowledge-Based Growth for Micro-Economic Policies Industry Canada Research Series, Volume 6
(Calgary: University of Calgary, 1996)

This article shuld explain a catagorisation of industries.

Baldwin, J. R. and J. Johnson. The Defining Characteristics of Entrants in Science-based Industries Catalogue no. 88-517-XIE (Ottawa: Statistics Canada, 1999).

This article should should show some adjustments to the catagories needed to define knowledge intensive industries.

Chart making in Excel

I have recently learned more about making charts in Excel.

Thanking Rob Salkowitz for his comment

I want to thank the author of Generation Blend, Rob Salkowitz for commenting here on my posts about this book. Rest assured Rob, I will be reading more of this book, as my research may depend on finding something I can apply to variables in my simulation of retiring workers. I also want to thank Mr. Salkowitz for engaging my blog that is very good scholarship and shows good use of web 2.0.

Studying PHP and MySQL and ESRI GIS.

I am studying PHP and MySQL together in an O'Reilly book. I am also three chapters into a book on GIS and databases. I may be writing a test in GIS at work for a promotion.

Details for my conference trip

I am just working out the housing and travel arrangements so that I can go to Boston this summer and present my paper. I need to start working on a keynote presentation and start to finish up my paper. I am off to the library today at school if it is open. I am having to return a reference for the paper and also I am taking back about 8 books I am not reading. I borrowed about five books from my workplace library and and all these books are about software in particular SAS and GIS software. But I did borrow one book on PHP and MySQL for fun.

Documenting some chart making in Open Office and Excel.

This post may be hard to follow but it is for myself to document my techniques and not loose them. If you learn from it you may find it useful for your spreadsheet work. It is also a way for me to practice for work and to push my spreadsheet abilities for data handeling.

I downloaded some data that was free. There were only 5 years covered. I have been using years as my X axis for the past two weeks. The data was divided by age groups and I only downloaded 5 year age bands from 45 to 89 and then 90 and over. It was for cause of death data and is published annually. These vital statistics are free for download. I have around 27 causes picked out. I had the data for both sexes and for men and for women. So for each year I had a column and for each age band and each of the 3 gender categories I had the 27 causes in rows. All in all about 750 rows of data.

I downloaded that data into a spreadsheet. I then created a new sheet in that workbook. Editorial Note: When one downloads data it seems the workbook has only the one sheet unlike when one creates a new workbook with three sheets. In the new sheet I copied totals for cause of death for the same age bands and the same gender categories but from all causes of death in Canada. This was copied from a separate download. These two sheets were then not changed and after this step; data were only copied out from these two download sheets. Then in a third sheet I made my own row labels for the genders and age bands matching the second sheet's row ordering. The labels from the database were lengthy and unreadable in the width of my spreadsheet window and the differences between the labels could not be viewed easily. Editorial note: the labels were so long not even a 30 inch monitor would display them completely I am guessing. These new labels were shorter and after much copy and pasting I had made all some 31 rows labels by age bands and gender categories. They were in the same row ordering as the downloaded deaths by all causes. I then made five year columns after these row labels in the first column and copied the totals deaths by all causes by years data to this sheet.

Then I went back to a copy of the death by specific causes download in separate workbook and saved a copy of that download as a text file or comma separated file. I then closed it and imported it. I imported the data as a text file. This is one of my data handling tricks that could also be done with regular expressions if one was using a programming or scripting language. The picking of the appropriate delimiters is the trick. I chose delimiters during the import that would cut the long row labels in this file so that the specific causes' names, age band's names and gender names, were all brought in to this new spreadsheet in separate columns. Actually I used three columns and then copied these labels into a new fourth sheet in my main workbook. The row order for the 750 rows was preserved.

I then went back to the first sheet in the main workbook with all the cause specific data and copied all the data but not the labels into the new fourth sheet. So sheet four was the same as sheet one, but I now had three columns for labels and the labels were short and readable on the screen. I then made new rows in sheet four at the top of the beginning of each specific gender category (both sexes, males, females) and the beginning of each age band (5 year age bands 45-89 and the age band 90 and over). So when for example, the data for both sexes, 45 to 49,and 27 rows of specific causes of death started in the sheet, a new row started the 27 rows for both sexes, 45 to 49 years old. Then going back to sheet three with the total causes of death by genders and age bands, I added two more columns between the labels and the yearly totals columns to make a proper column alignment with the three column labels in sheet four. Then one at a time, the new rows I had created in sheet four were pasted with the rows from the 31 age and gender specific death by all causes data and short labels for gender and age bands from the third sheet.

I was now ready to calculate some results. I created formulas for counts for specific causes over total causes and then made this number a percent. I used the real number for the total but for the specific cause count I used a cell reference. I then filled down the columns into the 27 specific causes effecting the calculation for all five years and all 27 causes for the first set of data which was 45 to 49 both sexes. This was the only data I worked through today. I still had these 27 cause specific rows by 5 years columns of data highlighted after the fill so I then used format cells to change all the numbers to percents with 6 decimal places.

I then charted all non-zero rows basically following the charting techniques in Excel I have learned at work but I did it in Open Office. Somethings are done differently in Open Office charts. I then also did a counts chart that matched the percents charts but makes no reference to total deaths. After a long break, I spent some time formating the charts for printing and printed the two charts out.

I then saved and closed all the workbooks. I thought it would be a good idea and relaxing and good for my intellectual health to document all my work so I have posted this notes.

Apologies for ageism made may be his book will work out.

I am still reading Generation Blend and am half way through this 245 page book now. I have not been reading the University of Google much lately. Some other scholars brought up on an email list the book about feminism in North Lights which I discussed a bit on that list.

My paper is starting to take form but I am unsure if it is the form I want.

At work I have been producing some statistics on my own from non-confidential published data and making some charts for our research. I am learning the art of writing with data statements. No, I do not mean SAS code I mean writing sentences with numbers and then finding the numbers and sourcing them and displaying as charts or updated accurate numbers. So some good lessons at work for writing with data.

Interesting but not very complex reading and could be considered ageist in its failings.

I am reading this book right now amongst others.

Salkowitz, Rob. Generation Blend: Managing Across the Technology Age Gap (Hoboken, N.J.: John Wiley & Sons, 2008)

While this book is interesting and covers a vast array technological areas it falls short of having any details. The reason it fails is that it only assumes youth are better and more comfortable with technology and such things as web 2.0 and does not hold back from this view. Again and again the old are considered technological deficient and the youth technologically gifted. So no matter what technology or workplace practice the author examines he does not change from this perspective. This could have been a much more interesting book with much more results. I would suggest the author embark on empirical studies to back up his points. This book is signed off on by Microsoft which is mud on their fenders in my opinion.

Bibliographies all week now researching a book chapter at work.

I work as a research assistant these days. My workplace is making a book right now. I have the task of proof reading chapters. I did this this past week at work. I also was tasked with creating bibliographies which I also worked on last week. My last major task is to research a whole chapter. I will do some of this research tomorrow and print the results for Monday. I need to research all the provinces on this topic and can do that on provincial government web sites. In particular I am researching education or lack of on a specific topic. I have done some work on Ontario now.

I have not worked on the workplace analysis since last week.

I did receive some excel files to work with last week but have not started to work with these yet at home. I did some hiring committee work for a non-profit on Monday and will help interview the candidates. I can not say more about this volunteering. I have been reading a little more of Generation Blender a book about technological attitudes of different Western post war generations.

I am studying disabled workers and statistics related to that at my workplace.

I have volunteered to study the statistics of a workplace survey. I have been getting the data into R and have produced some graphs with R so far in this work.

Other work studies include learning to use FORMAT procedures in SAS

An old family friend has a blog

I used to live down the street from Janet Ajzenstat and she partially inspired me to study law. She now has a blog. I bumped into her in Hamilton today. She told me she was writing a blog and one google search found it. Here it is here http://janetajzenstat.wordpress.com/

Writing a conference paper

I spent some time on the train quoting Thomas Davenport on measuring knowledge workers work. I worked this into my paper.

Generally the authors of these theses found demography had an effect on knowledge management.

Although these authors did not deal directly with the baby-boom they found the demographic variables they did study did have an effect on knowledge management. I will report this to my boss for his work.

Three of these theses are not on topic.

I searched through the tables of contents of three of the eight theses so far and the term demographics has meant so far only that the researchers covered the demographics of their samples. They have not dealt with the baby boom. So these theses although they cover knowledge management do not cover my topic. I will search through the other five today.