--- Forwarded Message from Leslie Graul <[log in to unmask]> ---
>Date: Thu, 29 May 2003 14:17:23 -0400
>From: Leslie Graul <[log in to unmask]>
>Organization: Thiel College
>To: Language Learning and Technology International Information Forum <[log in to unmask]>
>Subject: Re: #7143.6 BYU Placement Tests (!)
>References: <[log in to unmask]>
------------------
Hi, everyone!
Maybe I've missed the answer to this question, but I haven't seen any discussion of importing these results
into a data base. Has anyone been able to import the CAPE test results into Access? We've set up a data
base so that we can make comparisons from group to group, year to year, by class each year, etc. Typing the
data in each time is extremely tedious.
Leslie Graul
LLTI-Editor wrote:
> --- Forwarded Message from Andrew Ross <[log in to unmask]> ---
>
> >User-Agent: Microsoft-Entourage/10.1.1.2418
> >Date: Tue, 27 May 2003 13:35:29 -0400
> >Subject: Re: #7143.5 BYU Placement Tests (!)
> >From: Andrew Ross <[log in to unmask]>
> >To: Language Learning and Technology International Information Forum <[log in to unmask]>
> >In-Reply-To: <[log in to unmask]>
>
> ------------------
> Hi, Georgia:
>
> You can import into Excel, too, and do the table sort. Open a simple text
> editor such as Notepad or Wordpad. Copy the contents of the admin window
> and paste into a text editor document. Save it. In Excel, choose "Open
> ..." and select the document. It should prompt you for a format. Choose
> "Delimited" and select a comma as the separator. This should place all
> items in columns and rows. The advantage to this way of doing things is
> that you can run calculations on the scores without exporting them to some
> other application first.
>
> Hope this helps (I'm kind of doing this from memory, since I don't yet have
> a PC here ...)
>
> Best,
>
> a.
>
> On 5/27/03 13:15, "LLTI-Editor" <[log in to unmask]> wrote:
>
> > --- Forwarded Message from Georgia Schlau <[log in to unmask]> ---
> >
> >> Date: Thu, 22 May 2003 12:10:02 -0400
> >> From: Georgia Schlau <[log in to unmask]>
> >> Subject: Re: #7143.4 BYU Placement Tests (!)
> >> To: Language Learning and Technology International Information Forum
> >> <[log in to unmask]>
> >> References: <[log in to unmask]>
> >
> > ------------------
> > Bill,
> >
> > I have gotten as far as copying and pasting the scores log into Word. How do
> > you sort the text separated by commas into columns? One by one is the only way
> > I know how to do it. Please advise.
> >
> > Thanks for your help,
> > Georgia
> >
> > LLTI-Editor wrote:
> >
> >> --- Forwarded Message from [log in to unmask] ---
> >>
> >>> Date: Tue, 6 May 2003 21:35:37 -0500
> >>> From: [log in to unmask]
> >>> To: [log in to unmask]
> >>> Subject: Re: #7143 BYU Placement Tests
> >>> User-Agent: Internet Messaging Program (IMP) 3.0
> >>
> >> Georgia,
> >>
> >> An alternative to using Excel (as explained in earlier postings) is to copy
> >> the comma-delimited text from the BYU test results log, paste it into a Word
> >> document, select all the text, and then from the menu bar choose table >
> >> insert > table. This will format the text as (you guessed it) a table, which
> >> can then be sorted by column.
> >>
> >> Bill
>
> --
>
> Andrew F. Ross, Ph.D.
> Director, Language Resource Center
> Brown University
> Box 1935
> Providence, RI 02912-1935
>
> (401)863-7010
> [log in to unmask]
>
> "Worrying about a large institution, especially when it has computers, is
> like worrying about a large gorilla, especially when it's on fire." -- Bruce
> Sterling
|
