[Lon-capa-users] Extracting Grades

[Felicia Berryman]

This is a multi-part message in MIME format.
--------------0392F9A021CA2A870C9D8059
Content-Type: text/plain; charset=iso-8859-15
Content-Transfer-Encoding: 7bit

Hi Mark,

Attatched to this message are my notes on the spreadsheet.  You can use
the spreadsheet to calculate grades.  I gave these notes to Ray
Batchelor and I think they helped him.

Hopefully, they will be in a manual soon...

Felicia

Mark Lucas wrote:
> 
> Hi-
> 
>         For us lucky folk running quarters, it's closing in on time to
> extract grades (3 more weeks and we're done). I just want to verify the
> procedure:
> 
> (1) Go to spread sheet
> 
> (2) select Comma-separated Variable display option
> 
> (3) select pertinent text
> 
> (4) paste into editor or spreadsheet of choice
> 
>         Is this basically the procedure?
> 
>                                                 Thanks,
>                                                     Mark
> 
> ----------------------------------------------------------------------------
> Mark Lucas                                      email: lucasm@ohiou.edu
> 252D Clippinger Lab                             phone: (740)597-2984
> Department of Physics and Astronomy             fax:   (740)593-0433
> Ohio University
> Athens, OH 45701
> 
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users@mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users

--
Felicia Berryman
LON-CAPA Coordinator
Michigan State University
  Email:  felicia@lon-capa.org
  Phone:  (517)432-9866  
http://www.lon-capa.org
--------------0392F9A021CA2A870C9D8059
Content-Type: application/octet-stream;
 name="spreadsheet"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="spreadsheet"

VGhlIHNwcmVhZHNoZWV0IGhhcyBpdHMgb3duIHNjcmlwdCAoYSAibWFjcm8iKS4KCi0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tCgpEdXJpbmcgdGhlIHNwcmVhZHNoZWV0IGNhbGN1bGF0aW9u
LCB0aGVyZSBhcmUgdHdvIHBhc3NlczoKCTEuKSAgbG9va3MgZm9yIHN5bWJvbGljIHJlZnMg
dG8gY2VsbHMgYW5kIHRyYW5zbGF0ZXMgdG8gY2VsbCBudW1iZXJzCglzdWNoIGFzIEExNiwg
QjIsIGV0Yy4KCXBhcmFtZXJ0ZXJfVkFSX3dlaWdodCAtLS0+IEIyCgkgICAgICAgIGEuKSBh
bHNvIGxvb2tzIGZvciBzdHVmZiBpbiBicmFja2V0cywgaS5lLjoKCQlbJkVYUEFORFNVTShW
YXJpYWJsZU5hbWU7IHN5bWJvbGljX3JlZildCgkJW3RpbWVzdGFtcF0gLS0tPiBBMTYKCTIu
KSAgY2FsY3VsYXRlcyBjZWxscwoKUmF3IHBvaW50cyBpbiBjZWxsIFYwOgoKWyZFWFBBTkRT
VU0oUEFSVDtwYXJhbWV0ZXJfUEFSVF93ZWlnaHQqc3RvcmVzX1BBUlRfYXdhcmRlZCldCgoK
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KCk1ha2luZyBuZXcgZm9ybXVsYSBmb3IgcHJvYmxl
bXM6CgpTdGVwMToKCS0gZ28gdG8gcHJvYmxlbSBsZXZlbCBzcHJlYWRzaGVldAoJLSBtYWtl
IGEgcmF3IHBvaW50cyBjZWxsICh3ZWlnaHQgaW4gbW9zdCBjYXNlcyksIGllIFYwCgktIGFz
c3VtZSB0cmllcyBpbiBDMCwgZm9yIGV4YW1wbGUKCglleGFtcGxlOiBpcyBvbmUgcG9pbnQg
b24gMXN0IHRyeSwgLjc1IHBvaW50cyBvbiBzZWNvbmQgdHJ5LCAuNSBvbiAKCXRoaXJkIHRy
eSBhbmQgYWxsIG90aGVyIHRyaWVzLgoJCgktIG1ha2UgY2VsbCwgWDAgc3VjaCB3aXRoIGZv
cm11bGE6IEMwPjI/MC41KlYwOihDMD4xPzAuNzUqVjA6VjApCgktIFRFU1RfRVhQUj9JRl9U
UlVFX0VYUFI6SUZfRkFMU0VfRVhQUiAoZnJvbSBQZXJsIGJvb2spCgpTdGVwMjogIE1ha2Ug
Zm9ybXVsYSB3b3JrIGZvciBhbGwgcHJvYmxlbXMuCgktIENsaWNrICJtYWtlIGRlZmF1bHQi
IGJveCB0aGVuIGNsaWNrICJTYXZlIGFzIgoKU3RlcDJiOiBUbyBtYWtlIGZvcm11bGEgd29y
ayBmb3IganVzdCBvbmUgcHJvYmxlbSAob3Igc2V0IG9mIHByb2JsZW1zKQoJLSBDaGFuZ2Ug
bmFtZSBmcm9tICJjb3Vyc2VfZGVmYXVsdCIgdG8gbmV3IG5hbWUsIGkuZS4gImZyZWQiIGFu
ZAogICAgICAgICAgY2xpY2sgIlNhdmUgYXMiCgktIGdvIHVwIHRvIHN0dWRlbnQgc3ByZWFk
c2hlZXQgd2hpY2ggd2lsbCBub3cgc2hvdyAiZnJlZCIgYXMgYW5kIAoJICBhbHRlcm5hdGl2
ZSB0byAiZGVmYXVsdCIuCiAJLSBTZWxlY3QgImZyZWQiIG9uIGRyb3AtZG93biBib3ggZm9y
IGV2ZXJ5IHByb2JsZW0geW91CgkgIHdhbnQgdG8gdXNlICJmcmVkIiBmb3IuCgktIEFwcGx5
IHRoaXMgdG8gYWxsIHN0dWRlbnRzOgoJCS0gY2hlY2sgYm94LCBzYXZlIGFzICJjb3Vyc2Vf
ZGVmYXVsdCIKCS0gcmVjYWxjdWxhdGUgc3ByZWFkc2hlZXQKClN0ZXAgMzoKCS0gb24gdG9w
LWxldmVsIGNvdXJzZSBzcHJlYWRzaGVldCwgeW91IHNob3VsZCBoYXZlIG5hbWUgb2YgdGhl
IGRlZmF1bHQKCSAgc3ByZWFkc2hlZXQuICAKCS0gUmVjYWxjdWxhdGUgc3ByZWFkc2hlZXQu
CgoqIE9ubHkgY2hhbmdlcyBpbiBDYXBpdGFsIGxldHRlciBjb2x1bW5zIHdpbGwgaW1wb3J0
IHVwLgoqIFRvIHNhdmUgc3ByZWFkc2hlZXQgYXMgLmNzdiBmaWxlLCBjbGljayAiW11PdXRw
dXQgdG8gQ1NWIiBhbmQgdGhlbiBzYXZlIGZpbGUuCgpTdW1tYXJ5IHRvIGNhcnJ5IGNoYW5n
ZXMgdXA6CgoJcHJvYmxlbTogIAoJCSAgMS4pIE1ha2UgZGVmYXVsdCBbeF0KCQkgIDIuKSBD
bGljayBbU2F2ZSBhc10KCQkgIDMuKSBHbyB1cCBsZXZlbCB0byBzdHVkZW50CglzdHVkZW50
OgoJCSAgMS4pIFtDb21wbGV0ZWx5IHJlY2FsY3VsYXRlXQoJCSAgMi4pIEdvIHVwIGxldmVs
IHRvIGNvdXJzZQoJY291cnNlOgoJCSAgMS4pIFtDb21wbGV0ZWx5IHJlY2FsY3VsYXRlXQoK
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0KCgoK
--------------0392F9A021CA2A870C9D8059--