Text for
Preface

 

 

Chapter 1

Objectives of
Anchoring
in the Literature

Schedule for
Week 1

Class 1

Video for
Doing a cited reference search
(page 3)

3.2 MB
 
 

Exercise 1.1
Anchor Point
Answer Key for
1.1
Exercise 1.2
Reverse Engineering

Video for
Searching a bibliographic database
(page 5)

3.7MB
Workbook for
Reverse Engineering
Project 1
Reverse Engineering Your Anchor

Chapter 2

Objectives of
Designing
the Analysis

Schedule for
Week 2

Class 2

Video for
Generating a random number list
(page 20)

1.9MB
 Formula for
Random number list

Exercise 2.1
Descriptive Framework
 Answer Key for
2.1

Video for
Adding a worksheet
(page 25)

272KB

    
Exercise 2.2
Sampling

Video for
Naming a worksheet
(page 26)

320KB
Workbook for
 Data
Project 2
Designing Your Analysis

Chapter 3

Objectives of
Segmenting
the Data

Schedule for
Week 3

Class 3

Video for
Inserting segmentation
(page 45)

364KB

  
Workbook for
 Segmentation
Exercise 3.1
Units of Analysis
  Answer Key for
3.1

Video for
Removing unwanted carriage returns
(page 45)

320KB

Video for
Making a macro
(page 46)

1.0MB

Video for
Creating a style in Word
(page 48)

860KB
Exercise 3.2
Segmentation

Video for
Modifying a style
(page 48)

304KB

Video for
Shaping conversational data
(page 49)

876KB

Video for
Moving text from Word to Excel
(page 51)

1MB
Project 3
Segmenting Your Data

Video for
Numbering segments
(page 52)

128KB

Video for
Labeling segments
(page 52)

824KB

Chapter 4

Objectives of
Coding
the Data

Schedule for
Week 4

Class 4

Video for
Viewing coding scheme and data together
(page 59)

1.6MB

 

Exercise 4.1
Coding
  Answer Key for
4.1

Video for
Using an Autofilter
(page 65)

728KB

Video for
Sorting data
(page 65)

2.6KB

Video for
Automatic coding
(page 68)

332KB

  Formula for
Automatic coding
Workbook for
Automated Coding
Exercise 4.2
Automated Coding
   
 Workbook for
Coding
Project 4
Coding Your Data

Chapter 5

Objectives of
Achieving
Reliability

Schedule for
Week 5

Class 5

Video for
Hiding a column
(page 76)

636KB

Workbook for
Simple Reliability

Exercise 5.1
Simple Agreement

 
 

Video for
Using the Format Painter
(page 76)

240KB

Video for
Freezing panes
(page 76)

932KB

Video for
Comparing first and second coding
(page 79)

180KB

 Formula for
Agreement checking		  
Exercise 5.2
Inspecting Disagreements
Answer Key for
5.2
 Formula for
Simple agreement
Formula for
Count

Video for
Using the Cohen's kappa web site
(page 84)

2.6MB
Roger's Workbook
Exercise 5.3
Improving Reliability
Schedule for
Week 6

Video for
Using Autofilter to inspect disagreements
(page 86)

260KB
Workbook for 
Reliability
Project 5
Achieving Reliability
Chapter 6

Objectives of
Calculating
Frequency

Schedule for
Week 7

Class 6

Video for
Naming data
(page 94)

1.9MB

Janet's Workbook

Exercise 6.1
Setting Criteria
 

Video for
Copying fixed values
(page 97)

300KB

Video for
Copying formulas
(p. 98)

248KB
 Database Workbook
Exercise 6.2
Relative Frequencies
Answer Key for
6.2

Video for
Calculating frequency
(page 100)

124KB

  Formula for
Frequency
Workbook for
Frequency Exercise
Exercise 6.3
Frequency Table

Video for
Filling a frequency table
(page 101)

164KB
Formula for
Marginal sum

Video for
Designating a data range
(page 102)

100KB

  

Video for
Calculating a relative frequency
(page 102)

164KB
Workbook for
Frequency
Project 6
Calculating Frequency
Chapter 7

Objectives of
Seeing Patterns
of Distribution

Schedule for
Week 8

Class 7

Video for
Making a frequency graph
(page 108)

1.3MB

Exercise 7.1
Distributions
  Answer Key for
7.1

Video for
Modifying the scale
(page 109)

208KB

Video for
Changing plot color
(page 109)

560KB
Workbook for
 Distribution Exercise
Exercise 7.2
Distribution Graphs

Video for
Making a chart style
(page 110)

708KB

Video for
Applying a custom chart style
(page 110)

1.4MB

  
Exercise 7.3
Interpreting Distributions

Video for
Collapsing cases
(page 120)

128KB

Video for
Calculating averages
(page 122)

100KB

  Formula for
Average
Workbook for
 Distribution
Project 7
Seeing Patterns of Distribution
 
Schedule for
Week 9
          
Chapter 8

Objectives of
Exploring Patterns
Across Dimensions

Schedule for
Week 10

Class 8

Video for
Adding a second dimension
(page 127)

96KB
 

 

 

 

Exercise 8.1
Questions
Answer Key for
 8.1

Video for
Creating a block chart
(page 131)

2.6MB

Video for
Rotating a chart
(page 133)

136KB

Video for
Setting rotational angle
(page 133)

760KB
Exercise 8.2
Criteria Tables

Video for
Creating a clustered display
(page 135)

2.9MB
Workbook for
Clustering
Exercise 8.3
Clustering

Video for
Changing the color of a column
(page 136)

1 MB

  
Exercise 8.4
Overall Frequency

Video for
Calculating overalll frequency
(page 140)

692KB
Comments Workbook
Exercise 8.5
Contingency Tables

Video for
Changing axis
(page 141)

488KB

  
Exercise 8.6
Putting It Together
Answer Key for
8.6
Schedule for
Week 11

Video for
Selecting nonadjacent data
(page 142)

52KB
Workbook for Dimensional Analysis
Project 8
Exploring Patterns across Dimension
Chapter 9

Objectives of
Following Patterns
over Time

Schedule for
Week 12

Class 9

Paternalism Workbook 

 

 

 
Exercise 9.1
Temporal Index
 Answer Key for
9.1

Video for
Assigning numeric values to codes
(page 158)

324KB

  Formula for
Assigning numeric values to codes		  
Exercise 9.2
Assigning Numeric Values

Video for
Making a temporal index
(page 159)

7.2MB

      

Video for
Relabeling the categorical dimension
(page 161)

1.5MB

Video for
Demarcating an aggregate
(page 162)

420KB

  
Workbook for Aggregating
Exercise 9.3
Demarcating Boundaries

Video for
Numbering aggregates
(page 163)

496KB

Video for
Separating data by code
(page 165)

196KB
Formula for
Separating data by code

Video for
Doing a cumulative count
(page 166)

436KB
Formula for
Cumulative count
     
Exercise 9.4
Interpreting Aggregate
Workbook for
Temporal Analysis
Project 9
Following Patterns over Time
Chapter 10

Objectives of
Evaluating
Significance

Schedule for
Week 13

Class 10

 
 Exercise 10.1
Significance
  Answer Key for
10.1
Formula for
Expected frequency
Expected Workbook
Exercise 10.2
Expected Distribution

Video for
Computing a chi-square test
(page 177)

1.4MB

Formula for
Chi-square
Workbook for
Significance
Project 10
Evaluating Significance

Video for
Looking up a chi-square value
(page 179)

332KB

 Chi-square Table

Video for
Pinpointing greatest differences
(page 179)

484KB

 

 

Video for
Calculating expected marginals
(page 184)

276KB
Chapter 11

Objectives of
Detailing
Results

Schedule for
Week 14

Class 11

Video for
Seeing details in context
(page 199)

1MB
 
 
Exercise 11.1
Details
 Answer Key for
11.1
Exercise 11.2
Locating Details
Project 11
Detailing Results
Chapter 12

Objectives of
Presenting
Results 

Schedule for
Week 15

Class 12

Exercise 12.1
Functions
 Answer Key for
12.1
Exercise 12.2
Components
Exercise 12.3
Placement

Video for
Inserting a frozen graph
(page 213)

1MB
Exercise 12.4
Journals
Exercise 12.5
Universals
Answer Key for
12.5

Video for
Turning off autoscaling
(page 215)

908KB
Sample for
Accounting
Project 12 Presenting Your Results
 
         
 

Schedule for
Week 16

Class 13

         
Schedule for
Week 17