[Year 12 IT Apps] Interim Reports

[Mark Kelly]

Hi Ros.  Are you pulling the subject/teacher names from CASES?

Do you have a small sample of the CASES data to look at?

What do you use for timetabling?  Perhaps you might have more luck 
pulling the data from your timetabling database.



Meadows, Roslyn M wrote:
> Thanks Michael
> 
> I can get the data into an excel spreadsheet, but each student is listed
> on 10 lines - one line per subject.
> C & P would be ok if we had time but there are 800 kids!! :( :(
> 
> I just know that there has to be a way to do it, just gotta figure it
> out, and I am not au fait with CASES, the first time I ever got to see a
> screen with CASES on it was at 2.30pm today! And this needs to be ready
> by Wed so staff can start ticking the boxes!!!
> 
> Cheers
> Ros
> 
> Roslyn Meadows | Information Technology | Bentleigh Secondary College |
> meadows.roslyn.m at edumail.vic.gov.au | ph 03 9579 1044 | mobile 0412 614
> 062
> 
> -----Original Message-----
> From: itapps-bounces at edulists.com.au
> [mailto:itapps-bounces at edulists.com.au] On Behalf Of Michael Warden
> Sent: Monday, 19 March 2007 8:19 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] Interim Reports
> 
> Hi Roslyn,
> 
> Without the CASES data to use - have you tried opening the data in Excel
> first so it does appear on one page and then Copying 'n' Pasting it into
> a
> Word table!
> 
> Cheers,
> 
> Michael
> 
>>
>>
>>
>>  Roslyn Meadows | Information Technology
>> meadows.roslyn.m at edumail.vic.gov.au
>> <mailto:meadows.roslyn.m at edumail.vic.gov.au>
>> ph 03 9579 1044 | mobile 0412 614 062
>>
>> ________________________________
>>
>> From: Meadows, Roslyn M
>> Sent: Monday, 19 March 2007 7:33 PM
>> To: Offtopic at edulists.com.au; 'Year 12 IT Applications Teachers'
> Mailing
>> List'
>> Subject: Interim Reports
>>
>>
>>
>> Hello all
>>
>>
>>
>> Another request for help..
>>
>>
>>
>> Does anyone know how to extract the information from CASES to be
> merged
>> into the accompanying Word Document?
>>
>> It wants to put one subject per page, so each student would end up
> with
>> 10 pages of reports, rather than all subjects on one report.
>>
>> I can get the info from CASES to an Excel spreadsheet, but once again
>> each student's details are listed on 10 or so rows, one row per
> subject,
>> and then I can't get it to merge properly
>>
>>
>>
>> I have tried everything, my head is spinning and I am now at the point
>> where I am going around in circles.
>>
>>
>>
>> Any help would be greatly appreciated
>>
>>
>>
>> Thanks and Cheers
>>
>> Ros
>>
>>
>>
>> Roslyn Meadows | Information Technology
>> meadows.roslyn.m at edumail.vic.gov.au
>> <mailto:meadows.roslyn.m at edumail.vic.gov.au>
>> ph 03 9579 1044 | mobile 0412 614 062
>>
>>
>>
>>
>> Important - This email and any attachments may be confidential. If
> received in
>> error, please contact us and delete all copies. Before opening or
> using
>> attachments check them for viruses and defects. Regardless of any
> loss, damage
>> or consequence, whether caused by the negligence of the sender or not,
>> resulting directly or indirectly from the use of any attached files
> our
>> liability is limited to resupplying any affected attachments. Any
>> representations or opinions expressed are those of the individual
> sender, and
>> not necessarily those of the Department of Education.
> 
> 
> 
> Important - This email and any attachments may be confidential. If
> received in error, please contact us and delete all copies. Before
> opening or using attachments check them for viruses and defects.
> Regardless of any loss, damage or consequence, whether caused by the
> negligence of the sender or not, resulting directly or indirectly from
> the use of any attached files our liability is limited to resupplying
> any affected attachments. Any representations or opinions expressed are
> those of the individual sender, and not necessarily those of the
> Department of Education.
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
> Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology
> Teachers Association Inc
> 
> Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education.
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and
> http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc
> 
> 

-- 
Mark Kelly
Manager - Information Systems
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000
School Fax +613 95789253

Webmaster - http://www.mckinnonsc.vic.edu.au
IT Lecture notes: http://vceit.com
Moderator: IT Applications Mailing List

There are 10 kinds of people in the world: those who understand binary
and those who don't.