Thank you for taking the time to reply and advise.
I would like to take up your offer of viewing your Excel and Access files.
On Wed, 23 Feb 2000 09:12:00 -0000 Roger Clark <[log in to unmask]> 
wrote:

> Alison
> 
> I think the answer to your spreadsheet suggestion is to export the data,
> manipulate it in a spreadsheet and possibly a database, then import it back.
> This is what I have done.  You can add extra data such as faculty codes,
> term patterns etc if that helps. I can send you my Excel and Access files as
> a guide if you think they would be helpful.
> 
> The reason why the SLC does not want you to delete all the data and start
> again is that the unique key is the SLC course code (not the UCAS code), and
> many (most?) LEAs will have embedded these codes in their student records.
> But you can change more or less everything else. I think the errors are
> actually more easily dealt with in a spreadsheet, in which you can sort
> courses into an appropriate order to compare with your own lists.
> 
> Roger Clark
> Academic Registrar
> University of Reading
> 
> > -----Original Message-----
> > From: [log in to unmask]
> > [mailto:[log in to unmask]]On Behalf Of Brown, Alison
> > Sent: 23 February 2000 13:54
> > To: [log in to unmask]
> > Cc: [log in to unmask]
> > Subject: REPLY: Re: SLC courses and terms database
> >
> >
> > I have not actually tried to use the software yet, but I have read the
> > manual and it does appear to be an improvement on last year.  However, I
> > maintain that by far the easiest way to deal with this would be for the
> > SLC to accept a simple spreadsheet from everyone, (fields etc designed to
> > meet their prescribed criteria).  I find that the prescribed software is
> > clumsy and surplus to requirements.
> > Also, I was disapointed to find that the pre-loaded course data which the
> > SLC has carried forwarded from last year cannot be deleted.  It
> > would have
> > been much easier to have started from scratch, especially as I know that
> > this data is full of errors.
> >
> > On Tue, 22 Feb 2000 13:35:28 +0000 (GMT) Joe Taylor
> > <[log in to unmask]> wrote:
> >
> > > Date sent:      	Tue, 22 Feb 2000 12:17:45 -0000
> > > Subject:        	SLC courses and terms database
> > > From:           	"Roger Clark" <[log in to unmask]>
> > > To:             	"Admin-Student" <[log in to unmask]>
> > > Send reply to:  	[log in to unmask]
> > >
> > > > I would be interested to hear from colleagues who are
> > completing the SLC
> > > > courses and terms data collection exercise any constructive
> > suggestions for
> > > > further improvements.  The impression I have, having
> > completed our return
> > > > using the import/export method plus some minor corrections
> > using the data
> > > > screens, is that the software and other details make it much
> > easier than
> > > > last year (once I had got to grips with the change of data
> > structure to one
> > > > record for each term of each year), although there are still
> > some wrinkles
> > > > to be sorted out.
> > > >
> > > > In case it is slow getting to you, the SLC issued an update to the
> > > > instructions on 18 February, giving an important
> > clarification in respect of
> > > > franchised and validated courses.  It also clarifies what to
> > do with courses
> > > > having the same UCAS code.  If this has not yet reached those
> > actually doing
> > > > the return, I suggest you phone the HEI helpline on 0345 023316.
> > > >
> > > >
> > > > Roger Clark
> > > > Academic Registrar
> > > > University of Reading
> > > >
> > > Roger et al
> > >
> > > I thought I'd let you know that so far we've had an unhappy
> > > experience with the SLC courses and terms database.
> > >
> > > A CDROM finally arrived in the post yesterday (the only feature
> > > actually suggesting it was from the SLC being the Glasgow
> > > postmark for 18.2.00.)
> > >
> > > It proved unreadable (our IT services staff tried it). I contacted the
> > > SLC helpline, confirmed it was from them and was told that they
> > > had had reports of some "blind" CDs and would send another (still
> > > awaited).
> > >
> > > Joe Taylor
> > > Academic Office
> > > University of Warwick
> >
> > ----------------------------------------
> > Alison Brown (Student & Resources Information)
> > Email: [log in to unmask]
> > "University of the West of England"
> > Telephone: 01179 656261 ext:2615
> >
> >
> 

----------------------------------------
Alison Brown (Student & Resources Information)
Email: [log in to unmask]
"University of the West of England"
Telephone: 01179 656261 ext:2615



%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%