SeriesIMP < MH

---+ Series IMP
%ABSTRACT%
Data from the IMP Series Textbooks:

   * IMP Yr 1a Patterns
   * IMP Yr 1b Overland Trail
   * IMP Yr 2a Cookies
   * IMP Yr 2b Fireworks
   * IMP Yr 2c All About Alice
   * IMP YR 3a Meadows or Malls
   * IMP Yr 3b Small World

%ENDABSTRACT%
---++ Timeline Graph
   * IMP Timeline Graph: <br />
     <img src="%ATTACHURLPATH%/IMP_Timeline_Graph.png" alt="IMP_Timeline_Graph.png" width='97%' />
   * [[%ATTACHURL%/IMP_Timeline_Graph.pdf][ :pdf: IMP_Timeline_Graph.pdf]]: Zoomable PDF of IMP Timeline Graph

---++ Comments
%COMMENT{ type="below"}% 
   * Pie Charts! -- Main.DickFurnas - 19 Apr 2012
   * Updated graphs to show both Year and individual volumes. -- Main.DickFurnas - 19 Apr 2012
   * Topic Codes of 0 no longer appear in the graphs. -- Main.DickFurnas - 19 Apr 2012
   * Summary Counts for Codes at the 100 level (Code00) and !CogBeh by Year and totals for the series. Also, the Timeline Graphs are now current, the data points are now done with an opacity of .33 so overlapping points are more readily distinguished. Zoom in on the pdf to appreciate the goodness. -- Main.DickFurnas - 18 Apr 2012
   * The latest IMP data  tweaks are now in IMP_Reconciled.ods no extraneous sheets remain in the spreadsheet. Further sanity checks found a missing !CogBeh row. -- Main.DickFurnas - 16 Apr 2012
   * Uploaded latest :ods: spreadsheet. The new sheet IMP_Data_noJ was made by pasting from the original excel spreadsheets again, this time deleting the portion of column I where a column J was present. A further spreadsheet checks that both IMP_Data and IMP_Data_noJ sheets have the same data throughout except for the mergers. All looks good. -- Main.DickFurnas - 09 Mar 2012
   * Added Sanity Checks below for all columns in the sheet IMP_Data_noJ of the :ods: spreadsheet. -- Main.DickFurnas - 09 Mar 2012
   * Comment 2 -- Main.DickFurnas - 09 Mar 2012
   * Comment 1 -- Main.DickFurnas - 09 Mar 2012

---++ Code00 Summary
     <img src="%ATTACHURLPATH%/IMP_Pie_Chart_Code00.png" alt="IMP_Pie_Chart_Code00.png" width='99%' />

   * [[%ATTACHURL%/IMP_Pie_Chart_Code00.pdf][ :pdf: IMP_Pie_Chart_Code00.pdf]]: Code00 Pie Charts pdf file. Zoom in for detail.
      * Color scheme uses Resistor Color Code for hundreds digit of Topic Code00:
      * 1 Brown
      * 2 Red
      * 3 Orange
      * 4 Yellow
      * 5 Green
      * 6 Blue
      * 7 Purple
      * 8 Gray
      * 9 White
      * 0 Black

| *Year1* | *Year2* | *Year3* | *Code00* | *Total* |
|  22 |  51 |   |  100 |  73 |
|  66 |  14 |  21 |  200 |  101 |
|  49 |  59 |  37 |  300 |  145 |
|  2 |   |  12 |  400 |  14 |
|  333 |  236 |  111 |  500 |  680 |
|  34 |  237 |  294 |  600 |  565 |
|  38 |  7 |  16 |  700 |  61 |
|   |  1 |  38 |  800 |  39 |
|  8 |   |  3 |  900 |  11 |
|  20 |   |  5 |  1000 |  25 |
|  1 |   |   |  1100 |  1 |
|   |   |  84 |  1200 |  84 |
|   |   |  5 |  1300 |  5 |
|  15 |  54 |  48 |  1400 |  117 |
|  187 |  247 |  159 |  1500 |  593 |
|  9 |  2 |   |  1600 |  11 |
| %CALC{"$SUM($ABOVE())"}% | %CALC{"$SUM($ABOVE())"}% | %CALC{"$SUM($ABOVE())"}% | _Totals_ | %CALC{"$SUM($ABOVE())"}% |

---++ Cognitive Behavior Summary
     <img src="%ATTACHURLPATH%/IMP_Pie_Chart_CogBeh.png" alt="IMP_Pie_Chart_CogBeh.png" width='99%' />

   * [[%ATTACHURL%/IMP_Pie_Chart_CogBeh.pdf][ :pdf: IMP_Pie_Chart_CogBeh.pdf]]: Cognitive Behavior Pie Charts :pdf: pdf file.

| *Year1* | *Year2* | *Year3* | *CogBeh* | *Total* |
|  383 |  420 |  433 |  A |  1236 |
|  44 |  107 |  73 |  K |  224 |
|  96 |  95 |  84 |  R |  275 |
| %CALC{"$SUM($ABOVE())"}% | %CALC{"$SUM($ABOVE())"}% | %CALC{"$SUM($ABOVE())"}% | _Totals_ | %CALC{"$SUM($ABOVE())"}% |

%BEGINSIDEBYSIDE%
Sort of Codes:
%LEFTSIDE%
Sort by Code:
<pre>
2702 
1235 A
 224 K
   7 NMA
 275 R
   1 100
   1 101
   1 102
   3 103
   9 108
  25 110
  10 111
  13 112
   5 113
   5 116
  16 201
   9 202
   3 203
  39 204
   3 210
  18 217
  13 218
   1 300
   4 301
   5 303
   1 304
  17 305
  50 306
   3 307
   5 309
   2 310
   1 311
   2 312
   4 313
  50 314
   1 400
  12 402
   1 403
 107 502
  33 503
  10 504
  21 505
  58 506
  65 507
  47 508
  22 509
 171 510
  80 511
  58 512
   3 513
   5 514
  53 601
 165 602
  27 603
   4 604
  75 605
  33 607
  57 608
   5 612
  41 613
  14 614
  49 615
  42 616
   8 703
   1 705
   5 707
   7 708
  19 711
  15 714
   6 717
  11 804
  28 806
   3 901
   8 907
   5 1001
  20 1003
   1 1107
   2 1201
   3 1202
  23 1204
   1 1205
  55 1206
   3 1301
   2 1303
  23 1402
  76 1404
   3 1406
  14 1407
   1 1410
  97 1501
   2 1502
 118 1503
 189 1504
   1 1505
  11 1507
 115 1508
   2 1510
   8 1513
  23 1514
   6 1515
   7 1516
  13 1517
   1 1590
  10 1602
   1 1604
</pre>
%RIGHTSIDE%
Sort by Frequency:
<pre>
2702 
1235 A
 275 R
 224 K
 189 1504
 171 510
 165 602
 118 1503
 115 1508
 107 502
  97 1501
  80 511
  76 1404
  75 605
  65 507
  58 512
  58 506
  57 608
  55 1206
  53 601
  50 314
  50 306
  49 615
  47 508
  42 616
  41 613
  39 204
  33 607
  33 503
  28 806
  27 603
  25 110
  23 1514
  23 1402
  23 1204
  22 509
  21 505
  20 1003
  19 711
  18 217
  17 305
  16 201
  15 714
  14 614
  14 1407
  13 218
  13 1517
  13 112
  12 402
  11 804
  11 1507
  10 504
  10 1602
  10 111
   9 202
   9 108
   8 907
   8 703
   8 1513
   7 NMA
   7 708
   7 1516
   6 717
   6 1515
   5 707
   5 612
   5 514
   5 309
   5 303
   5 116
   5 113
   5 1001
   4 604
   4 313
   4 301
   3 901
   3 513
   3 307
   3 210
   3 203
   3 1406
   3 1301
   3 1202
   3 103
   2 312
   2 310
   2 1510
   2 1502
   2 1303
   2 1201
   1 705
   1 403
   1 400
   1 311
   1 304
   1 300
   1 1604
   1 1590
   1 1505
   1 1410
   1 1205
   1 1107
   1 102
   1 101
   1 100
</pre>
%ENDSIDEBYSIDE%

---++ Sanity Checks
Sanity checks of the data were performed on the columns of data in the master spreadsheet, summarizing the number of occurrances of various entries. These  provided clues to data entry errors such as entries in the wrong column or the like. These were similar to the summaries for Topic and !CogBeh codes but were arranged explicitly by column in the master spreadsheet. They were presented as tables which could be sorted by clicking on the column header of the table.

   * Created by copying the column from the spreadsheet to the clipboard and invoking the following command in Terminal on the Mac before pasting in here:
<pre>
pbpaste | sort -n | uniq -c | sed -e 's/^ */|/' -e 's/ /|/' -e 's/$/|/' | pbcopy
</pre>

---+++ Column A
|*Count*|*Entry*|
|0|Errors Remain|
| %CALC{"$SUM($ABOVE())"}% | Totals |

---+++ Column B
|*Count*|*Entry*|
|0|Errors Remain|
| %CALC{"$SUM($ABOVE())"}% | Totals |

---+++ Column C
|*Count*|*Entry*|
|0|Errors Remain|
| %CALC{"$SUM($ABOVE())"}% | Totals |

---+++ Column D
|*Count*|*Entry*|
|0|Errors Remain|
| %CALC{"$SUM($ABOVE())"}% | Totals |

---+++ Column E
|*Count*|*Entry*|
|0|Errors Remain|
| %CALC{"$SUM($ABOVE())"}% | Totals |

---+++ Column F
|*Count*|*Entry*|
|0|Errors Remain|
| %CALC{"$SUM($ABOVE())"}% | Totals |

---+++ Column G
|*Count*|*Entry*|
|0|Errors Remain|
| %CALC{"$SUM($ABOVE())"}% | Totals |

---+++ Column H
|*Count*|*Entry*|
|0|Errors Remain|
| %CALC{"$SUM($ABOVE())"}% | Totals |

---+++ Column I
|*Count*|*Entry*|
|0|Errors Remain|
| %CALC{"$SUM($ABOVE())"}% | Totals |

---
-- Main.DickFurnas - 2012-03-05

   * [[%ATTACHURL%/IMP_Reconciled.txt][IMP_Reconciled.txt]]: Text copied from IMP_Reconciled.ods -- tab separated values

Attachments

Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
pdf	IMP_Pie_Chart_Code00.pdf	r1	manage	34.2 K	2012-04-19 - 08:16	DickFurnas	Code00 Pie Charts $PDF$ pdf file.
png	IMP_Pie_Chart_Code00.png	r1	manage	48.2 K	2012-04-19 - 08:11	DickFurnas	Code00 Breakdown:
pdf	IMP_Pie_Chart_CogBeh.pdf	r1	manage	30.7 K	2012-04-19 - 08:17	DickFurnas	Cognitive Behavior Pie Charts $PDF$ pdf file.
png	IMP_Pie_Chart_CogBeh.png	r1	manage	23.5 K	2012-04-19 - 08:10	DickFurnas	Cognitive Behavior Breakdown
ods	IMP_Reconciled.ods	r8 r7 r6 r5 r4	manage	83.6 K	2012-04-19 - 00:04	DickFurnas	Colored Column J by Year
txt	IMP_Reconciled.txt	r2 r1	manage	86.6 K	2012-04-19 - 00:08	DickFurnas
pdf	IMP_Timeline_Graph.pdf	r8 r7 r6 r5 r4	manage	683.8 K	2012-04-19 - 05:45	DickFurnas
png	IMP_Timeline_Graph.png	r10 r9 r8 r7 r6	manage	42.2 K	2012-04-19 - 05:45	DickFurnas

This topic: MH > WebHome > TextbookCoding > SeriesIMP
Topic revision: r11 - 2012-04-19 - DickFurnas