A course which personalizes authentic math learning for each individual learner
From a course design perspective, it would be relatively easy to develop a generic spreadsheet resource with "activity tracks" for different spreadsheet software applications (Excel, the LibreOffice and OpenOffice suites.)
Similarly, I think it would be worth the effort to have a generic suite of tutorials with assessment and activity tracks for different subjects, eg Math, Statistics, Accounting etc. In this way we will be able to reuse the materials for multiple contexts.
There are a number of resources we could use as a starting point -- for example, Module 4 of COL's Computer Navigators Certificate Course. These materials are available under a CC-BY-SA license and would be relatively easy to convert into wiki format.
Great suggestions on developing the spreadsheet tutorials. These will be helpful for many learners. Can you talk more about teh activity tracks?
--BettyHD 14:52, 17 March 2012 (UTC)
The activity tracks sound more elaborate than what I'm suggesting ;-).
Imagine a wiki learning page, for example, teaching how to enter a function in a spreadsheet. The page may include a demo or screen cast. At this point we can provide three links to separate subpage - one for each of the different software packages.
Similarly, a task oriented activity embedded on the wiki page might include optional streams for each of the software packages, or subject specific examples.
Structuring the course in this way (i.e. separate wiki sub-pages for the different software packages) will make it easier to reuse the materials for different contexts.
So nothing too elaborate -- just thinking carefully about how best to structure the wiki pages to maximise reuse and to minimise upstream maintenance.
Great idea--do one tutorial, with branches or on-the-page selections (e.g., click the appropriate down-arrow) for different situations (different software as well as different learning tasks). It seems quite doable, and as you say would likely be easier to maintain.
I took a quick look at the current CNCC spreadsheet materials. Nicely done. Betty indicated that ESC has an Excel tutorial which needs updating. Shouldn't be too hard to take the best parts of each and put them together into one tutorial, which can be added to as the needs arise. I will likely have a need for a spreadsheet tutorial for an intro stats class to start in Sept, so we can try out the branching for differing learning tasks :)
I'm very willing to help with this.
The latest version of the CCNC materials are not too bad and wouldn't be too hard to wikify. If we configure these for multiple reuse scenarios, I think it can support a wide range of learning contexts.
Thinking out loud -- I would prefer a subpage solution rather than using a "down arrow" for a target on the same page. This would make it easier to transclude. For example -- there could be a Spreadsheets for Statistics course (basically a transcluded duplicate of the generic course pages, and then incorporates transcluded pages for the stats activities if you know what I mean.) Much easier to maintain.
Thanks for your offer to help here -- would be a great project for the WE and OERu family.
Yes, I see what you mean. Definitely the way to go for courses which support different contexts.
I'm wondering if we need a fully separate course...learning pathway....for people using different spreadsheet software, at least for the very basic stuff. As we get into it, we'll have to see if there are situations which would make sense for the learner to choose activity directions or screenshots specific to the software they are using, and then that bit gets transcluded into the page. This method would only make sense if it's more common than different.
I haven't used Excel in quite some time, so I'm not sure how different the learning content will need to be.