Social Work / Family Therapy / Human Services

• Describes the purpose and application of each data analysis procedure presented, while the accompanying CD-ROM provides a step-by-step graphic and video demonstration, making the material appealing to both textual and visual learners.
• Teaches students how to do statistical analysis using programs (spreadsheets) that they will actually find in practice settings, making this a very practical and applied educational tool.
• Presents a variety of ways to select random samples with spreadsheets.
• Demonstrates how to produce descriptive statistics, frequency distributions, and bivariate analyses using spreadsheets.

Each chapter concludes with “Chapter Summary” and “References.”

1. An Introduction to Spreadsheets.

Spreadsheets — First Facts.

The Brief History of Spreadsheets.

Why Use Spreadsheets for Data Analysis in the Social Services?

Spreadsheet Basics.

Using Formulas and Functions.

Advanced Tools for Understanding Data.

A Comparison of Spreadsheets to Statistical Analysis Software.

The Paradox of Spreadsheets and Statistical Software in Social Service Practice.

2. Data Collections Ways and Means.

The Many Paths to Data Acquisition.

Levels of Measurement.

Data Coding.

Basic Data Entry.

Creating Data Entry Forms.

Downloading Data.

Web-Based Data Retrieval.

Relating to Database Software.

Web-based Data Collection.

Relating to Database Software.

Saving What You Have and Using What You Need.

3. Selecting Samples.

Samples: First Facts.

Simple Random Samples.

Systematic Sampling.

Stratified Sampling.

Random Assignment.

4. Data Cleaning

Types of Problem Data.

Detecting Data Errors.

Contingency Cleaning.

Missing Data: Its Detection and Handling.

Detecting Missing Data.

Handling Missing Data.

5. Frequency Distributions and Histograms.

Understanding the Distribution of Values.

Frequency Distributions.          

Producing Histograms Using the Chart Wizard.

6. Descriptive Statistics.

Measures of Central Tendency.

Formulas for Measures of Central Tendency.

Measures of Dispersion or Variability.

Data Analysis Tools: Descriptive Statistics.

Producing Frequency Polygrams.

7. Statistical Inference and Hypothesis Testing.

Normal Distributions.

Probability Distributions.

Skewness.

Understanding Hypothesis Testing.

Statistical Significance.

Effect Size and Sample Size Estimation.

8. Bivariate Statistics.  

Chi-square Test of Independence.

t-Test.

ANOVA.

Post hoc Tests of Means.

9. Cross-Tabulation Tables.

Using the Pivot Tables Wizard.

Graphing Cross-tabulation Tables.

10. Single System Design.

Basic Elements of Single System Design.

Advanced Designs.

Dynamic Chart Production.

Single System Group Designs.

11. Correlation and Regeression. 

Pearson's r and R2.

Bivariate Regressions.

Regression.

Two Variable Regression.

Creating Scatterplots.

Trendlines in Scatterplots.

Interpreting Scatterplots.

Ordinary Least Squares (OLS) Regression.

Interpreting Multivariate Regression (OLS) Output in Excel.

Creating a Control Variable for Regression Analysis in Excel.

12. Graphical Representation of Practice Information.

Thinking Visually.

Graphical Representation.

Tools for Graphical Representation of Information.

Matching Data to Type of Graph.

Enhancing Graphs.

Spreadsheets Drawing Tools.

Ecomaps.

Genograms.

Technology in Social Work and Social Welfare  (Social Work / Family Therapy / Human Services)
Research Methods in Social Work  [SUPPLEMENTAL PRODUCTS]   (Social Work / Family Therapy / Human Services)
Evaluation  [SUPPLEMENTAL PRODUCTS]   (Social Work / Family Therapy / Human Services)
Statistics for Social Workers  [SUPPLEMENTAL PRODUCTS]   (Social Work / Family Therapy / Human Services)

View a Sample Chapter PDF:/samplechapter/020540751X.pdf

Introduce your Social Work students to data collection, statistical analysis, and graphical representation of results using spreadsheets: an inexpensive and readily available data analytic software. This text and companion CD-ROM use videos, text, and graphics to provide students clearly articulated descriptions and demonstrations of data analysis procedures that are commonly referred to in research, statistics and practice evaluation texts.

“I have nothing but praise for this book. Hurry and publish it.”
Steve Marson, UNC Pembroke

“The CD-Rom is a valuable accompaniment to the text, especially for visual and auditory learners. The voices are audible and at a pace that listeners can easily follow along. The table layout where users can click on the chapter and topics they are interested in is easy to navigate. I would definitely consider adopting this text for my course.”
Margaret E. Adamek, Indiana University

“The authors are correct in stating that computers with spreadsheets are widely available, and that they contain powerful functions. As such, it is helpful to have a text that can show future practitioners how to use these tools to improve their practice. The CD provides an excellent supplement to the text. Students can use the CD at their own speed, can repeat lessons as necessary and can use the CD in their agencies to analyze data.”
John Goad, Arizona State University

Related Titles:
Research Methods for Social Work, 1/e
James R. Dudley
Order No. 0-205-36529-9

Information Technology for Social Work (with Research Navigator Guide for the Helping Professions), 1/e
Phyllis Schiller
Order No. 0-205-45367-8

Statistics for Social Workers, 6/e
Robert W. Weinbach and Richard M. Grinnell Jr.
Order No. 0-205-37598-7

Planning and Conducting Agency-Based Research, 3/e
Alex J. Westerfelt and Tracy J. Dietz
Order No. 0-205-38687-3

Research Methods for Social Workers, 5/e
Bonnie L. Yegidis and Robert W. Weinbach
Order No. 0-205-40818-4

For Technology in Social Work and Social Welfare

Data Analysis with Spreadsheets (with CD-ROM)
Patterson & Basham
©2006 | Allyn & Bacon | Paper Bound w/CD-ROM; 208 pp | Instock
ISBN-10: 020540751X | ISBN-13: 9780205407514
Suggested retail price: $77.40  Buy from myPearsonStore
Net price: $58.05  (What's this?)

SPSS for Social Workers (with CD-ROM)
Blanksby & Barber
©2006 | Allyn & Bacon | Paper; 304 pp | Instock
ISBN-10: 020539566X | ISBN-13: 9780205395668
Suggested retail price: $42.23  Buy from myPearsonStore
Net price: $31.67  (What's this?)

Data Analysis with Spreadsheets (with CD-ROM)
Patterson & Basham
©2006 | Allyn & Bacon | Paper Bound w/CD-ROM; 208 pp | Instock
ISBN-10: 020540751X | ISBN-13: 9780205407514
Suggested retail price: $77.40  Buy from myPearsonStore
Net price: $58.05  (What's this?)

MySearchLab (access code required)
Pearson
©2010 | Allyn & Bacon | Website | Instock
ISBN-10: 0205699391 | ISBN-13: 9780205699391
Online purchase price: $10.00Students can purchase immediate access at http://www.mysearchlab.com.

SPSS for Social Workers (with CD-ROM)
Blanksby & Barber
©2006 | Allyn & Bacon | Paper; 304 pp | Instock
ISBN-10: 020539566X | ISBN-13: 9780205395668
Suggested retail price: $42.23  Buy from myPearsonStore
Net price: $31.67  (What's this?)

Data Analysis with Spreadsheets (with CD-ROM)
Patterson & Basham
©2006 | Allyn & Bacon | Paper Bound w/CD-ROM; 208 pp | Instock
ISBN-10: 020540751X | ISBN-13: 9780205407514
Suggested retail price: $77.40  Buy from myPearsonStore
Net price: $58.05  (What's this?)

SPSS for Social Workers (with CD-ROM)
Blanksby & Barber
©2006 | Allyn & Bacon | Paper; 304 pp | Instock
ISBN-10: 020539566X | ISBN-13: 9780205395668
Suggested retail price: $42.23  Buy from myPearsonStore
Net price: $31.67  (What's this?)

Data Analysis with Spreadsheets (with CD-ROM)
Patterson & Basham
©2006 | Allyn & Bacon | Paper Bound w/CD-ROM; 208 pp | Instock
ISBN-10: 020540751X | ISBN-13: 9780205407514
Suggested retail price: $77.40  Buy from myPearsonStore
Net price: $58.05  (What's this?)

MySearchLab (access code required)
Pearson
©2010 | Allyn & Bacon | Website | Instock
ISBN-10: 0205699391 | ISBN-13: 9780205699391
Online purchase price: $10.00Students can purchase immediate access at http://www.mysearchlab.com.

SPSS for Social Workers (with CD-ROM)
Blanksby & Barber
©2006 | Allyn & Bacon | Paper; 304 pp | Instock
ISBN-10: 020539566X | ISBN-13: 9780205395668
Suggested retail price: $42.23  Buy from myPearsonStore
Net price: $31.67  (What's this?)

Building Bridges: The Allyn & Bacon Student Guide to Service-Learning
Hamner
©2002 | Allyn & Bacon | Paper; 128 pp | Instock
ISBN-10: 0205319742 | ISBN-13: 9780205319749
Suggested retail price: $39.80  Buy from myPearsonStore
Net price: $29.85  (What's this?)

Helping Professions Journal: A Critical Thinking and Reflection Guide
Orton & Jacobs
©2003 | Allyn & Bacon | Paper | Instock
ISBN-10: 0205378269 | ISBN-13: 9780205378265
Suggested retail price: $34.00  Buy from myPearsonStore
Net price: $25.50  (What's this?)

iClicker Classroom Response System
iClicker & Allyn & Bacon/Longman
©2008 | Allyn & Bacon | Electronic Supplement | Instock
ISBN-10: 0205594506 | ISBN-13: 9780205594504
This online resource is available at no cost.

InterWrite PRS RF (Personal Response System)
InterWrite PRS & Allyn & Bacon/Longman
©2005 | Allyn & Bacon | Electronic Supplement | Instock
ISBN-10: 0205436951 | ISBN-13: 9780205436958
This online resource is available at no cost.

ResearchNavigator.com Guide: The Helping Professions (Valuepack item only)
Yaffe & Barr
©2007 | Allyn & Bacon | Paper; 224 pp | Instock
ISBN-10: 0205516998 | ISBN-13: 9780205516995
Suggested retail price: $0.00Net price: $0.00  (What's this?)

Thinking About a Social Work Career (Valuepack item only), 2/E
Ginsberg
©2005 | Allyn & Bacon | Paper; 112 pp | Instock
ISBN-10: 0205459528 | ISBN-13: 9780205459520
Suggested retail price: $0.00Net price: $0.00  (What's this?)

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.

Package ISBN-10: 0205615406 | ISBN-13: 9780205615407
©2006 | Instock (Additional assembly time required)
Suggested retail price: $77.40  Buy from myPearsonStore
Net price: $58.05  (What's this?)
This package contains:

Package ISBN-10: 0205615414 | ISBN-13: 9780205615414
©2006 | Instock (Additional assembly time required)
Suggested retail price: $77.40  Buy from myPearsonStore
Net price: $58.05  (What's this?)
This package contains:

Package ISBN-10: 0205524427 | ISBN-13: 9780205524426
©2006 | Instock (Additional assembly time required)
Suggested retail price: $123.27  Buy from myPearsonStore
Net price: $92.45  (What's this?)
This package contains:

Package ISBN-10: 0205492282 | ISBN-13: 9780205492282
©2006 | Out of Stock
Suggested retail price: $140.93  Buy from myPearsonStore
Net price: $105.70  (What's this?)
This package contains:

Package ISBN-10: 0205527035 | ISBN-13: 9780205527038
©2006 | Instock (Additional assembly time required)
Suggested retail price: $114.67  Buy from myPearsonStore
Net price: $86.00  (What's this?)
This package contains:

Package ISBN-10: 0205492304 | ISBN-13: 9780205492305
©2006 | Out of Stock
Suggested retail price: $104.33  Buy from myPearsonStore
Net price: $78.25  (What's this?)
This package contains:

Package ISBN-10: 0205526764 | ISBN-13: 9780205526765
©2006 | Instock (Additional assembly time required)
Suggested retail price: $129.27  Buy from myPearsonStore
Net price: $96.95  (What's this?)
This package contains:

Package ISBN-10: 0205527086 | ISBN-13: 9780205527083
©2006 | Instock (Additional assembly time required)
Suggested retail price: $101.27  Buy from myPearsonStore
Net price: $75.95  (What's this?)
This package contains:

Package ISBN-10: 0205496091 | ISBN-13: 9780205496099
©2006 | Instock (Additional assembly time required)
Suggested retail price: $152.47  Buy from myPearsonStore
Net price: $114.35  (What's this?)
This package contains:

Package ISBN-10: 0205526543 | ISBN-13: 9780205526543
©2006 | Instock (Additional assembly time required)
Suggested retail price: $131.27  Buy from myPearsonStore
Net price: $98.45  (What's this?)
This package contains:

Package ISBN-10: 0205493017 | ISBN-13: 9780205493012
©2009 | Instock (Additional assembly time required)
Suggested retail price: $141.32  Buy from myPearsonStore
Net price: $105.99  (What's this?)
This package contains:

Package ISBN-10: 0205529607 | ISBN-13: 9780205529605
©2007 | Instock (Additional assembly time required)
Suggested retail price: $126.47  Buy from myPearsonStore
Net price: $94.85  (What's this?)
This package contains:

Package ISBN-10: 0205572812 | ISBN-13: 9780205572816
©2008 | Instock (Additional assembly time required)
Suggested retail price: $128.27  Buy from myPearsonStore
Net price: $96.20  (What's this?)
This package contains:

Package ISBN-10: 0205491847 | ISBN-13: 9780205491841
©2006 | Instock (Additional assembly time required)
Suggested retail price: $123.27  Buy from myPearsonStore
Net price: $92.45  (What's this?)
This package contains: