Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Presenting data in a desired form
From
David Radwin <[email protected]>
To
[email protected]
Subject
Re: st: Presenting data in a desired form
Date
Wed, 23 Jun 2010 21:41:03 -0700 (PDT)
I did this some years ago, when I was a lowly teaching assistant, using Microsoft Word's mail merge feature. It has the added advantage of enabling you to automatically email the grades, although you should first check applicable government and campus regulations regarding sending student grades and other personal information by email. You could probably accomplish the same thing using the open source alternatives to Word/Excel, OpenOffice or NeoOffice.
See http://davidradwin.com/teaching/ for instructions.
You'll need to -reshape wide- and -outsheet- your grades in Stata first, so Martin's solution may be preferable.
David
--
David Radwin
Research Associate
MPR Associates, Inc.
2150 Shattuck Ave., Suite 800
Berkeley, CA 94704
Phone: 510-849-4942
Fax: 510-849-0794
www.mprinc.com
----- Original Message -----
From: "keeler james" <[email protected]>
To: [email protected]
Sent: Wednesday, June 23, 2010 3:25:03 PM
Subject: st: Presenting data in a desired form
Dear Statalist,
Good evening!
If I have a data set in the Stata editor as follows:
Name CandidateNo Subject Grade Mark
1. xxx 1234 English A 80
2. xxx 1234 Maths B 65
3. xxx 1234 Chemistry C 55
4. yyy 0165 English D 40
5. yyy 0165 Maths E 30
6. zzz 3656 English C 50
7. zzz 3656 Maths B 67
Q1. How can I separate each candidate in an individual txt file with all
their subjects in it?
Q2. How can I arrange the data in the following form?
_________________________________
Name CandidateNo
xxx 1234
Subject Grade Mark
English A 80
Maths B 65
Chemistry C 55
_________________________________
Any help will be highly appreciated - also any book/webpage I can read
relating to this?
Calchas
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/