[Yr11 Information Technology] My U1O1 - R-U MAD psychiatric data

[Esther Andrews]

It also drive me crazy. "Yes" is MY answer to R-U-MAD!!

I love your story telling in the scenario. You are posing many questions for the students - my students only managed two graphs in the time. I ran my SAC over a similar time period. My dataset was much longer and I required students to remove invalid data, but I only provided them with one set of data. Having done that, most students were only able to produce about two graphs in the time frame in addition to writing their report.



The skills we had been focussing on included autofilter, sorting and use of COUNTIF and SUM, so that is the basis of the SAC.
Attached is my SAC, criteria sheet and data and a partial solution (just tests the feasibilty of the graphs).
The criteria sheet is adapted from one used by a colleague last year. I'm not sure where it came from so I apologise if it looks familiar. The scenario is based on some contract work I did.
Only the better students were able to figure out how to total up the data for state or "How They Heard" for EACH year. Most of the students just graphed the totals by state or "How They Heard" for the entire timeframe. In retrospect it might have been better to just ask them to compare the years 2000 to 2009.
Feedback welcome :)

Esther Andrews | Admin Systems Developer, IT and Maths Teacher
Bendigo Senior Secondary College
Box 545 | BENDIGO | Victoria 3552 Australia
B +61 3 5443 1222 | F +61 3 5441 4548
andrews.esther at bssc.edu.au<mailto:andrews.esther at bssc.edu.au>
www.bssc.edu.au<http://www.bssc.edu.au/>
Our ROLE is to empower learners for individual, community and global leadership. We value Respect, Optimism, Learning and Environment.
________________________________
From: yr11it-bounces at edulists.com.au [yr11it-bounces at edulists.com.au] On Behalf Of Mark KELLY [kel at mckinnonsc.vic.edu.au]
Sent: Friday, 9 March 2012 3:11 PM
To: Year 11 Information Technology Teachers' Mailing List
Subject: [Yr11 Information Technology] My U1O1 - R-U MAD psychiatric data


I've been putting off writing this outcome for a while because finding suitable data and a reasonable case study have been driving me crazy.

Hence the topic of the data - Australian psychiatric figures. Having no idea of what format to use to frame the task, I made it a fictional scene with real data. Your approach may differ.

The data comes from http://mhsa.aihw.gov.au/home but I've already lost the exact location of the link. I did make significant chops to the data to get its size under control while leaving enough data for the kids to generate their info (and a little irrelevant data for them to sift out.)

If you are making your own outcome, be sure to read p.19 of the study design about what is required - particularly the need to provide the data and info about what the analysis has turned up (e.g. constraints, what info the students need to produce.)

Also check the key knowledge and key skills (p.20) so you include things like design, testing, and explaining why the solution is suitable for its needs. I didn't include validation because no new data entry is required for the solution.

P.19 also says that information is to be "displayed onscreen" which might make assessment harder (or easier?) for you.
If you need kids to print their work, they'd need access to a colour printer to get the full informational juiciness from their output.

I decided to get kids to create their report in Word and embed (link) their charts from Excel into the Word document. It's just a neater way to package their output, I think. I'll assess it onscreen, in colour.

I have yet to decide exactly how long I'll give the kids - maybe 90-120 minutes will do. I'll go with the flow, since this is the first time I've run this. I've also yet to craft a marking scheme. Maybe next week.

Attached is the case study, the data and a tute on embedding Excel charts in Word (2007).

Suggestions and creative criticism are welcome, as usual.

Cheers, and happy long weekend all.

Now to click SEND and immediately find the glaring omissions and errors in the outcome... <click>

--

Mark Kelly
Manager of ICT, Reporting, IT Learning Area
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: +613 8520 9085, Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au<mailto:kel at mckinnonsc.vic.edu.au>
VCE IT Lecture Notes: http://vceit.com
Moderator: IT Applications Edulist<http://www.edulists.com.au/>

--
Grammar for the 21st century...
Infinitive: I sync my phone.
Past tense: I sanc my phone.
Past participle: I have sunc my phone.


-------------- next part --------------
A non-text attachment was scrubbed...
Name: WhatsIts-4-U.zip
Type: application/x-zip-compressed
Size: 574302 bytes
Desc: WhatsIts-4-U.zip
Url : http://www.edulists.com.au/pipermail/yr11it/attachments/20120309/b5a251fa/WhatsIts-4-U-0001.zip