Connected Learning

Learning Is About Connections Of All Kinds…

MTI2006 : CohortMax

CohortMax: Using Excel to Facilitate School-Based Test Score Analysis

Intent is to have data be more rapidly usable in the school.

Number of total tests taken in student life cycle is increasing dramatically.

BV uses 7 demographic variables, 25 MAP variables, and numerous KSA varialbes to cull when exporting data from SPSS to Excel.

To handle overflow of variables in Excel BV Data Team: after MAP in grade 6 they keep one worksheet with key data (last 4 iterations of MAP and last 2 iterations of KSA in order to see back at least a couple years in time with the student data).

See PPT for flowchart of tasks in constructing and continuing CohortMax files.

Always make sure you make a backup file and then make a copy to have as the “for use” file.

Use Excel sort features to analyze highest and lowest scoring students on a particular variable, for example. If you make a “for use” copy, you can also strip out the unused variable columns to show only the pertinent data. Great for getting specific data for an individual teacher or department. By using a mix of ascending and descending sorts, you can get a sensitivity analysis to see students with major discrepancies that are enlightening. Use average on columns to see which area that the group as a whole has the most difficulty. Using count features, you can generate graphs based on “segments” in the group, such as low, mid, hi.

Presenter: Bernard Schuster of the Blue Valley Schools


July 28, 2006 Posted by | Conference Blogging | Leave a comment

MTI2006 : The Interactive Web

RSS: Real Simply Syndication

Setting up a whole bunch of new accounts is fun! I now have a Bloglines account in addition to my existing account. Lets get it started!

Bloglines is pretty handy for aggregating pretty much anything with RSS even though its called “Blog”lines.

Bloglines has a place to search for feeds. I searched for “mti2006” and it picked up the pbwiki right away. is great for storing and sharing bookmarks. Lots of extra tools available. Check into lazybase for data work!

Presenter: Rod Tolle from ESSDACK

July 28, 2006 Posted by | Conference Blogging | Leave a comment

MTI 2006 : Future City Competition & Wikis In The Classroom (Mini Sessions)

Future City Competition

Brad presented a quick summary of the Future City Competition. This is a great activity for students to not only have the fun of building a city using SimCity 3000, but also learn about dedication and teamwork by also having to create written materials, a 3D model of an aspect of their city, and present the entire project to a team of judges. There are various deadlines throughout the fall, with the actual state competition event taking place in January at Kansas State University.

Presenter: Brad Shores of Parsons Brinkerhoff Engineering in Wichita, Kansas

Using Wikis For Collaboration

Challenges of Collaboration

  • takes time
  • tracking details
  • competitive parties in the group
  • unintentional duplication
  • conflicts
  • momentum/participation

Wikis run from a globally accessible web based server with tracking history.

WSU COE put together a CTRE workshop on wikis, blogs, etc. to help launch into using these tools.

Wikis can be set up on your own server or you can use already available sites like wikispaces or edublog.

The immediacy of publishing what you write makes you think differently about your writing and what can happen to it.

Session presentation at

Presenters: Julie Bath and Karen Reynolds of the Wichita State University College of Education

July 28, 2006 Posted by | Conference Blogging | 1 Comment

MTI2006 : Standardized Test Cohort Analysis

Cohort: a relatively fixed year-group of students that moved through the grades together (Survivors, Newcomers, Attrition, Phantom)

Z Score: a reference point that is a benchmark calculated from national data – allows for better comparison of how group is doing compared to national norm

See PPT for the Cohort Rule of Thumb on Diffences/Effect Size

Keep in mind implication of releasing specific school data district-wide – perhaps go w/school vs. district average

Cohort analysis allows for interesting comparisons of data between groups incl. comparing groups separated by several years

Cohort works best w/SPSS

Presenter: Bernard Schuster of the Blue Valley Schools

July 28, 2006 Posted by | Conference Blogging | Leave a comment