CodingData < MH

---+ !!Coding Data
%ABSTRACT%

The !EtherPad document formerly at: http://etherpad.com/qfGgtH3Fl4 is no longer available. Google bought Etherpad and closed down the service. :-(

Repository for Coding Data and comments about working up the data for analysis.

   * [[%ATTACHURL%/FINALS_GlencoeAlg1.pdf][FINALS_GlencoeAlg1.pdf]]: :pdf: Timeline with Chapter Bars
   * [[%ATTACHURL%/CPMP_Topic_vs_CourseUnitBW.pdf][CPMP_Topic_vs_CourseUnitBW.pdf]]: CPMP Black and White Topic vs. Course and Unit Graph for NSF Proposal
   * [[%ATTACHURL%/UCSMP_Topic_vs_ChaptersBW.pdf][UCSMP_Topic_vs_ChaptersBW.pdf]]: UCSMP Black and White Topic vs. Chapters Graph for NSF Proposal


%ENDABSTRACT%
---++ Quick Look
---+++ Glencoe Algebra 1 Data
   * [[Glencoe Algebra 1 Data]]
   * [[%ATTACHURL%/FINALS_GlencoeAlg1.ods][FINALS_GlencoeAlg1.ods]]: :ods: Glencoe Algebra 1 Consolidated Data Spreadsheet with Timeline Graph
   * Timeline with Chapter Bars: <br />
     <img src="%ATTACHURLPATH%/FINALS_GlencoeAlg1.png" alt="FINALS_GlencoeAlg1.png" width='90%' />
Glencoe Algebra 1
   * Cognitive Codes
<pre>
2012 .
4059 a
3338 k
 146 r
</pre>
%BEGINSIDEBYSIDE%
*Topic Code Groups*
%LEFTSIDE%
By Number
<pre>
 19653 .
 266 100
 385 200
 533 300
  56 400
4379 500
1569 600
 266 700
  20 800
  62 900
 138 1000
 202 1100
   2 1200
 244 1400
 867 1500
  23 1600
</pre>
%RIGHTSIDE%
By Frequency
<pre>
19653 .
4379 500
1569 600
 867 1500
 533 300
 385 200
 266 700
 266 100
 244 1400
 202 1100
 138 1000
  62 900
  56 400
  23 1600
  20 800
   2 1200
</pre>
%ENDSIDEBYSIDE%
%BEGINSIDEBYSIDE%
*Topic Codes*
%LEFTSIDE%
By Number
<pre>
19653 .
   4 101
   1 102
   8 103
   1 104
  19 109
   3 110
  35 111
  13 112
  38 114
  49 115
   5 116
   1 117
   1 118
  88 119
   8 201
   1 202
   4 203
  46 204
  30 205
  12 206
  17 207
  12 208
   6 209
  70 210
  21 212
   8 213
   8 214
   4 215
  16 216
  57 217
  65 218
   7 301
  51 303
  72 305
 260 306
  19 307
   4 308
   3 309
  32 310
   2 312
  67 314
   1 315
   1 316
  14 317
   4 401
  15 402
  37 403
 134 501
 279 502
 194 503
 241 504
  40 505
  24 506
 574 507
 434 508
  22 509
 714 510
 557 511
 430 512
  54 513
 125 514
 440 515
 117 516
 467 601
 336 602
  69 603
 153 604
  38 607
 183 608
  80 612
 128 613
 115 614
   7 701
   2 702
  63 705
   1 706
  14 707
   1 709
   3 710
  12 711
   1 713
   4 714
 158 717
  20 804
  17 901
  10 902
   1 903
   1 905
  21 907
   4 910
   8 911
  17 1001
   1 1002
  38 1003
  26 1007
  56 1013
  40 1101
 111 1102
  31 1104
  15 1105
   5 1106
   2 1202
   3 1401
  90 1402
   2 1406
 127 1407
  20 1408
   2 1490
 141 1501
 108 1502
 113 1503
 201 1504
   3 1505
  19 1506
 112 1508
  36 1510
  26 1512
  22 1513
  58 1514
  19 1515
   7 1516
   2 1518
  22 1602
   1 1605
</pre>
%RIGHTSIDE%
By Frequency
<pre>
19653 .
 714 510
 574 507
 557 511
 467 601
 440 515
 434 508
 430 512
 336 602
 279 502
 260 306
 241 504
 201 1504
 194 503
 183 608
 158 717
 153 604
 141 1501
 134 501
 128 613
 127 1407
 125 514
 117 516
 115 614
 113 1503
 112 1508
 111 1102
 108 1502
  90 1402
  88 119
  80 612
  72 305
  70 210
  69 603
  67 314
  65 218
  63 705
  58 1514
  57 217
  56 1013
  54 513
  51 303
  49 115
  46 204
  40 505
  40 1101
  38 607
  38 114
  38 1003
  37 403
  36 1510
  35 111
  32 310
  31 1104
  30 205
  26 1512
  26 1007
  24 506
  22 509
  22 1602
  22 1513
  21 907
  21 212
  20 804
  20 1408
  19 307
  19 1515
  19 1506
  19 109
  17 901
  17 207
  17 1001
  16 216
  15 402
  15 1105
  14 707
  14 317
  13 112
  12 711
  12 208
  12 206
  10 902
   8 911
   8 214
   8 213
   8 201
   8 103
   7 701
   7 301
   7 1516
   6 209
   5 116
   5 1106
   4 910
   4 714
   4 401
   4 308
   4 215
   4 203
   4 101
   3 710
   3 309
   3 1505
   3 1401
   3 110
   2 702
   2 312
   2 1518
   2 1490
   2 1406
   2 1202
   1 905
   1 903
   1 713
   1 709
   1 706
   1 316
   1 315
   1 202
   1 1605
   1 118
   1 117
   1 104
   1 102
   1 1002
</pre>
%ENDSIDEBYSIDE%
 -- Main.DickFurnas - 29 Nov 2010
---+++ University Chicago School Mathematics Project
   * [[University Chicago School Mathematics Project Data][UCSMP]] [[University Chicago School Mathematics Project Data]]
      * UCSMP_Topic_vs_Time:
     <img src="%ATTACHURLPATH%/UCSMP_Topic_vs_Time.png" alt="UCSMP_Topic_vs_Time.png" width='25%'  />
      * [[%ATTACHURL%/UCSMP_Topic_vs_Time.pdf][ :pdf: UCSMP_Topic_vs_Time.pdf]]: Above as pdf file. Open in a pdf reader and zoom in and out to see details.
      * UCSMP2 uses custom graphics and includes book 2 data: <br />
     <img src="%ATTACHURLPATH%/UCSMP2_Topic_vs_Time.png" alt="UCSMP2_Topic_vs_Time.png" width='25%' />
      * [[%ATTACHURL%/UCSMP2_Topic_vs_Time.pdf][ :pdf: UCSMP2_Topic_vs_Time.pdf]]: UCSMP2 uses custom graphics and includes book 2 data.
---+++ Core Plus Data
   * [[Core Plus Data][CPMP]]  [[Core Plus Data]]
      * CPMP_Topic_vs_Time: <br />
     <img src="%ATTACHURLPATH%/CPMP_Topic_vs_Time.png" alt="CPMP_Topic_vs_Time.png" width='25%' />
      * [[%ATTACHURL%/CPMP_Topic_vs_Time.pdf][ :pdf: CPMP_Topic_vs_Time.pdf]]: Above as pdf file. Open in a pdf reader and zoom in and out to see details.

---++ Comments
%COMMENT{ type="below"}%
   * CPMP Data summarized to EtherPad also re-graphed for black and white printing and dressed up with more text along the axes. -- Main.DickFurnas - 06 Jan 2010
   * New implementation of UCSMP graph using custom graphics and incorporating the new Advanced Algebra data. -- Main.DickFurnas - 05 Jan 2010
   * I have uploaded reconciled codes for UCSMP Advanced Algebra Ch. 1-8. -- Main.MaryAnnHuntley - 04 Jan 2010
   *  -- Main.MaryAnnHuntley - 04 Jan 2010
   * Updated Topics vs Time =pdf= files with short topic names. -- Main.DickFurnas - 16 Dec 2009
   * Have created pie charts by book for both topic frequency and cognitive behaviors. -- Main.DickFurnas - 14 Dec 2009
      * [[%ATTACHURL%/Topics.ods][Topics.ods]]: Pie Charts of Topic Frequency by book
      * [[%ATTACHURL%/CognitiveBehavior.ods][CognitiveBehavior.ods]]: Pie Charts of Cognitive Behaviors by book *N.B.* A few instances of __c__ where only *k a r* were expected.
      * =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.
   * Topics vs &#34;Time&#34; graphs are now implemented in the =FINAL*= :odf: =odf= files as well as available as :png: =png= and :pdf: =pdf= of the graphs themselves. -- Main.DickFurnas - 25 Nov 2009
   * Dick - I just uploaded the updated UCSMP file. I&#39;ll be in touch soon. -- Main.GabrielDobbs - 18 Nov 2009
   * UCSMP coding errors ch 1-8 have been corrected in =FINALS_UCSMP.ods= Chapters 9-13 need to be added in from =UCSMP_Algebra_Ch._1-13.zip=  -- Main.DickFurnas - 17 Nov 2009
   * I have uploaded coding for the entire UCSMP Algebra book (Chapters 1-13).  Looking forward to seeing the analysis! -- Main.MaryAnnHuntley - 17 Nov 2009
   * The reference [[University Chicago School Mathematics Project Data]] which Gabe compiled into a master spreadsheet. The TWiki page is not pretty, but functional in the sense that it can be easily searched and the revision control allows for finding changes going forward. -- Main.DickFurnas - 06 Nov 2009
   * The reference [[Core Plus Data]] which Gabe compiled into a master spreadsheet. The TWiki page is not pretty, but functional in the sense that it can be easily searched and the revision control allows for finding changes going forward. -- Main.DickFurnas - 06 Nov 2009
   * The Core plus data looks great! I just posted the combined UCSMP spreadsheet. It looks to be in the same format as the Core plus data, so hopefully we can apply the formulas you were working on yesterday. -- Main.GabrielDobbs - 03 Nov 2009
   * I separated out Book as referenced in the files from ISBN since in doing some searching and reading about ISBN numbers, they can be messier than I had hoped. I *thought* it true that an ISBN number uniquely identifies a book, edition, and likely pagination, but I&#39;m no longer so sure. It turns out to be discouraged as an identifier for a bibliographic reference. -- Main.DickFurnas - 03 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? -- Main.DickFurnas - 03 Nov 2009
   * UCSMP Data Chapters 1-8 attached. -- Main.DickFurnas - 02 Nov 2009
   * Dick- here is an initial attempt of the spreadsheet (including all Core Plus data). I&#39;ll talk to you about filling in the missing parameters soon. -- Main.GabrielDobbs - 02 Nov 2009
   * Thanks Dick, I just had to reregister. I just uploaded some sample files as well. -- Main.GabrielDobbs - 13 Oct 2009
   * Hi Gabriel. Here are the data sets I&#39;ve gotten so far. -- Main.DickFurnas - 18 Sep 2009
   * First Post :-)  -- Main.DickFurnas - 18 Sep 2009

---++ Reconnaissance.

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.

[[CodingDataReconnaissance][Here]] are some command-line operations I performed in Terminal.app on the Mac after selecting the first column of =FINALS.xlsx= and copying to the clipboard:

---
-- Main.DickFurnas - 2009-09-18
---++ Attachments

   * [[%ATTACHURL%/GlencoeAlg2.zip][GlencoeAlg2.zip]]: Glencoe Alg2 Ch 1-14 (Ch 11-14 unreconciled)

   * Timeline with Chapter Bars: <br />
     <img src="%ATTACHURLPATH%/FINALS_GlencoeAlg1.png" alt="FINALS_GlencoeAlg1.png" width='1430' height='1006' />

   * [[%ATTACHURL%/FINALS_GlencoeAlg1.pdf][FINALS_GlencoeAlg1.pdf]]: :pdf: Timeline with Chapter Bars

   * [[%ATTACHURL%/FINALS_GlencoeAlg1.ods][FINALS_GlencoeAlg1.ods]]: :ods: Glencoe Algebra 1 Consolidated Data Spreadsheet with Timeline Graph

Attachments

Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
ods	FINALS_GlencoeAlg1.ods	r1	manage	960.9 K	2010-11-29 - 07:14	DickFurnas	:ods: Glencoe Algebra 1 Consolidated Data Spreadsheet with Timeline Graph
pdf	FINALS_GlencoeAlg1.pdf	r1	manage	685.6 K	2010-11-29 - 07:12	DickFurnas	:pdf: Timeline with Chapter Bars
ods	FINALS_Glencoe.ods	r3 r2 r1	manage	852.1 K	2010-01-06 - 06:00	DickFurnas	CPMP `ods` master data sheet with graph
zip	GlencoeAlg2.zip	r1	manage	289.3 K	2010-11-28 - 18:51	MaryAnnHuntley	Glencoe Alg2 Ch 1-14 (Ch 11-14 unreconciled)
zip	Glencoe_Alg1_Reconciled_11-15-10.zip	r1	manage	223.5 K	2010-11-15 - 20:17	MaryAnnHuntley	Glencoe Algebra 1 Reconciled (Ch 1-12)
zip	AdvAlgCh1-8.zip	r1	manage	148.8 K	2010-01-04 - 14:32	MaryAnnHuntley
pdf	CPMP_Topic_vs_Time.pdf	r3 r2 r1	manage	511.2 K	2009-12-16 - 18:09	DickFurnas
png	CPMP_Topic_vs_Time.png	r1	manage	133.0 K	2009-11-25 - 01:26	DickFurnas
pdf	UCSMP_Topic_vs_Time.pdf	r2 r1	manage	425.4 K	2009-12-16 - 18:09	DickFurnas
png	UCSMP_Topic_vs_Time.png	r1	manage	138.1 K	2009-11-24 - 18:00	DickFurnas
ods	CognitiveBehavior.ods	r1	manage	37.6 K	2009-12-14 - 21:57	DickFurnas	Pie Charts of Cognitive Behaviors by book
ods	Topics.ods	r1	manage	61.4 K	2009-12-14 - 21:56	DickFurnas	Pie Charts of Topic Frequency by book
zip	UCSMP_AdvAlgCh9-13.zip	r1	manage	116.9 K	2010-06-03 - 18:32	MaryAnnHuntley	Reconciled codes for UCSMP Adv Alg Ch. 9-13
pdf	CPMP_Topic_vs_CourseUnitBW.pdf	r2 r1	manage	819.3 K	2010-01-07 - 18:50	DickFurnas	Resized and page number
pdf	UCSMP_Topic_vs_ChaptersBW.pdf	r3 r2 r1	manage	951.0 K	2010-01-07 - 18:51	DickFurnas	Resized and page number
png	FINALS_GlencoeAlg1.png	r1	manage	97.4 K	2010-11-29 - 07:12	DickFurnas	Timeline with Chapter Bars
png	UCSMP2_Topic_vs_Time.png	r1	manage	65.0 K	2010-01-05 - 17:43	DickFurnas	UCSMP2 uses custom graphics and includes book 2 data
pdf	UCSMP2_Topic_vs_Time.pdf	r1	manage	77.9 K	2010-01-05 - 16:49	DickFurnas	UCSMP2 uses custom graphics and includes book 2 data.
zip	UCSMP_Algebra_Ch._1-13.zip	r1	manage	214.8 K	2009-11-17 - 20:04	MaryAnnHuntley	University of Chicago School Mathematics Project
xlsx	UCSMP_Adv_Alg_Ch13_Jmayer.xlsx	r1	manage	64.8 K	2010-01-06 - 08:28	DickFurnas	Unreconciled (JM's) UCSMP Adv Alg codes for Ch. 13
zip	UnreconciledCh9-12JM.zip	r1	manage	118.9 K	2010-01-05 - 19:19	MaryAnnHuntley	Unreconciled (JM's) UCSMP Adv Alg codes for Ch. 9-12
ods	FINALS_UCSMP.ods	r7 r6 r5 r4 r3	manage	1934.8 K	2010-06-18 - 19:06	DickFurnas	version with full data, including Advanced Algebra ch 9-13 reconciled and revised algorithm to properly classify Item rows with blank first column field (QY etc.)

This topic: MH > WebHome > TextbookCoding > CodingData
Topic revision: r36 - 2010-11-29 - DickFurnas