EtherPad document at: http://etherpad.com/qfGgtH3Fl4 Repository for Coding Data and comments about working up the data for analysis.

 
pdf
files with short topic names.  DickFurnas  16 Dec 2009
pbpaste  cat  tr '\t' '\n'  sort  sed e 's/..$/00/'  sort n  uniq c
proved handy for extracting the summary numbers after selecting the relevant portions of columns in the data spreadsheet.
FINAL*
:odf: odf
files as well as available as png
and pdf
of the graphs themselves.  DickFurnas  25 Nov 2009
FINALS_UCSMP.ods
Chapters 913 need to be added in from UCSMP_Algebra_Ch._113.zip
 DickFurnas  17 Nov 2009
FINALS_Glencoe.ods
attached. Has nearly everything parsed out into separate columns. Missing is file name and a column for the date of original source for data... and where does section number come from? the file name?  DickFurnas  03 Nov 2009
Before getting too carried away, I wanted to reconnoiter the first column of the FINALS.xlsx
spreadsheet since it seemed to have the most diverse assortment of information in it.
Here are some commandline operations I performed in Terminal.app on the Mac after selecting the first column of FINALS.xlsx
and copying to the clipboard:
I  Attachment  History  Action  Size  Date  Who  Comment 

zip  AdvAlgCh18.zip  r1  manage  148.8 K  20100104  14:32  MaryAnnHuntley  
CPMP_Topic_vs_CourseUnitBW.pdf  r2 r1  manage  819.3 K  20100107  18:50  DickFurnas  Resized and page number  
CPMP_Topic_vs_Time.pdf  r3 r2 r1  manage  511.2 K  20091216  18:09  DickFurnas  
png  CPMP_Topic_vs_Time.png  r1  manage  133.0 K  20091125  01:26  DickFurnas  
ods  CognitiveBehavior.ods  r1  manage  37.6 K  20091214  21:57  DickFurnas  Pie Charts of Cognitive Behaviors by book 
ods  FINALS_Glencoe.ods  r3 r2 r1  manage  852.1 K  20100106  06:00  DickFurnas  CPMP ods master data sheet with graph 
ods  FINALS_UCSMP.ods  r7 r6 r5 r4 r3  manage  1934.8 K  20100618  19:06  DickFurnas  version with full data, including Advanced Algebra ch 913 reconciled and revised algorithm to properly classify Item rows with blank first column field (QY etc.) 
zip  GlencoeAlg2.zip  r1  manage  289.3 K  20101128  18:51  MaryAnnHuntley  Glencoe Alg2 Ch 114 (Ch 1114 unreconciled) 
zip  Glencoe_Alg1_Reconciled_111510.zip  r1  manage  223.5 K  20101115  20:17  MaryAnnHuntley  Glencoe Algebra 1 Reconciled (Ch 112) 
ods  Topics.ods  r1  manage  61.4 K  20091214  21:56  DickFurnas  Pie Charts of Topic Frequency by book 
UCSMP2_Topic_vs_Time.pdf  r1  manage  77.9 K  20100105  16:49  DickFurnas  UCSMP2 uses custom graphics and includes book 2 data.  
png  UCSMP2_Topic_vs_Time.png  r1  manage  65.0 K  20100105  17:43  DickFurnas  UCSMP2 uses custom graphics and includes book 2 data 
zip  UCSMP_AdvAlgCh913.zip  r1  manage  116.9 K  20100603  18:32  MaryAnnHuntley  Reconciled codes for UCSMP Adv Alg Ch. 913 
xlsx  UCSMP_Adv_Alg_Ch13_Jmayer.xlsx  r1  manage  64.8 K  20100106  08:28  DickFurnas  Unreconciled (JM's) UCSMP Adv Alg codes for Ch. 13 
zip  UCSMP_Algebra_Ch._113.zip  r1  manage  214.8 K  20091117  20:04  MaryAnnHuntley  University of Chicago School Mathematics Project 
UCSMP_Topic_vs_ChaptersBW.pdf  r3 r2 r1  manage  951.0 K  20100107  18:51  DickFurnas  Resized and page number  
UCSMP_Topic_vs_Time.pdf  r2 r1  manage  425.4 K  20091216  18:09  DickFurnas  
png  UCSMP_Topic_vs_Time.png  r1  manage  138.1 K  20091124  18:00  DickFurnas  
zip  UnreconciledCh912JM.zip  r1  manage  118.9 K  20100105  19:19  MaryAnnHuntley  Unreconciled (JM's) UCSMP Adv Alg codes for Ch. 912 