[Year 12 IT Apps] Interim Reports

[Damien A-B]

Hi Ros,
	I'm no Cases expert, but if it's in excel, could you record yourself
cutting and pasting one of the students in a macro, then loop it 800 times? 
Cheers
Damien Atkinson-Buck
IT Department
Keilor Downs College

 

-----Original Message-----
From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of Meadows, Roslyn M
Sent: Monday, 19 March 2007 10:04 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: RE: [Year 12 IT Apps] Interim Reports

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


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.