[Year 12 IT Apps] Interim Reports

[Meadows, Roslyn M]

Hi all

 

Thank you to everyone for your offers of assistance - the person who was
giving me the exported excel files was not giving me the correct data.

 

Finally the AP gave me the correct file tonight, so we should sail
smoothly now.

 

AND A BIG BIG BIG BIG BIG THANK YOU TO IAN CLARE (Casterton SC) who gave
me some access files based on some of the excel data I had. Ian you have
been absolutely wonderful and so so helpful - we were emailing each
other until almost midnight last night and then again this morning and
actually got to chat on the edumail/MS Communicator (so cool!!!).
Honestly Ian, you unselfishly gave of your time and effort to help me,
and it is so much appreciated.

 

I think it is a credit to all of us that as IT professionals we are
always willing to give of our time and energy to help someone else. If
the world needs love then just look towards the IT community! This list
is a total embodiment of the sharing and giving that people are capable
of - without IOU's or feelings of guilt for taking something for
nothing. *violins in background*

 

It is obviously very hard to create reports when you don't have access
to CASES, but I love a problem, had some help, learnt a lot from Ian,
taught myself a few things, and somehow got to the light at the end of
the tunnel!!!

 

Now the admin are happy but the rest of the staff not so - some of them
were hoping we would not have to do the interim reports!!!!

 

Thank you once again everyone - but especially Ian *big smile* The staff
and students at Casterton are privileged to have you Ian!!

 

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 Mark Kelly
Sent: Tuesday, 20 March 2007 8:35 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Interim Reports

 

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.

 

_______________________________________________

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, dam=
age or consequence, whether caused by the negligence of the sender or not, r=
esulting directly or indirectly from the use of any attached files our liabi=
lity is limited to resupplying any affected attachments. Any representations=
 or opinions expressed are those of the individual sender, and not necessari=
ly those of the Department of Education.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20070320/a01fc386/attachment-0001.html