emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* Showing Property in headline; generating table from properties; exporting table to CSV
@ 2015-08-06 11:24 Matt Price
  2015-08-06 11:28 ` Eric S Fraga
  2015-08-06 13:52 ` John Kitchin
  0 siblings, 2 replies; 19+ messages in thread
From: Matt Price @ 2015-08-06 11:24 UTC (permalink / raw)
  To: Org Mode

[-- Attachment #1: Type: text/plain, Size: 4021 bytes --]

Hello eveyrone!

I know the big guns are all working on last-minute 8.3 bugs (thank you!).

I am hoping to get some guidance before heading off on vacation.  I have
switched over to doing all grading for my courses in org.  My workflow:

- export a csv file containing student names.
- generate grading templates for each student, for each assignment
- email comments back to students
- enter marks in an official spreadsheet which can be used for final grade
submission

A sample  "Comments.org" is at the bottom of this email (it was a little
long).

So, here are my questions:

- I currently store my grades as properties of level-2 headlines. However,
I would really like to be able to see the grades when the headline is
folded, so I can have a quick visual sense of how many papers I've marked,
how well the students are doing, and so forth.  THe best would be to be
able to see the actual marks in the headlines; but if I could, say, adjust
the color of the healdine based on the property value, that would be cool
too.

- It seems silly to record the grades once in org, and then again in a
libreoffice spreadsheet.  Better would be to generate a table and/or csv
spreadsheet directly from the headlines and property values.  So, the
example below would give the table:
| Student       | Definition | Darwin |
| Student One   |          0 |      0 |
| Student Two   |          0 |      0 |
| Student Three |          0 | 0      |

and from there I guess I could generate a CSV just with org-table-export.

Had anyone done either of these tasks before? Any guidance on how to do
it?

Thanks as always,
Matt

------------------------------------------
* Definition
** TODO Student One
:PROPERTIES:
:GRADE:    0
:MAIL_TO:  student.one@utoronto.edu
:MAIL_CC:  matt.price@utoronto.ca
:MAIL_REPLY: matt.price@utoronto.ca
:MAIL_SUBJECT: Comments on Definition Assignment (Student One)
:END:
- Organization ::
- Clarity of Thesis ::
- Presentation of Evidence ::
- Grammar and Spelling ::
- Style ::
- Citations ::
- Further Comments ::
- Grade ::
** TODO Student Two
:PROPERTIES:
:GRADE:    0
:MAIL_TO:  student.two@utoronto.edu
:MAIL_CC:  matt.price@utoronto.ca
:MAIL_REPLY: matt.price@utoronto.ca
:MAIL_SUBJECT: Comments on Definition Assignment (Student Two)
:END:
- Organization ::
- Clarity of Thesis ::
- Presentation of Evidence ::
- Grammar and Spelling ::
- Style ::
- Citations ::
- Further Comments ::
- Grade ::
** TODO Student Three
:PROPERTIES:
:GRADE:    0
:MAIL_TO:  student.three@utoronto.edu
:MAIL_CC:  matt.price@utoronto.ca
:MAIL_REPLY: matt.price@utoronto.ca
:MAIL_SUBJECT: Comments on Definition Assignment (Student Three)
:END:
- Organization ::
- Clarity of Thesis ::
- Presentation of Evidence ::
- Grammar and Spelling ::
- Style ::
- Citations ::
- Further Comments ::
- Grade ::


* Darwin
** TODO Student One
:PROPERTIES:
:GRADE:    0
:MAIL_TO:  student.one@utoronto.edu
:MAIL_CC:  matt.price@utoronto.ca
:MAIL_REPLY: matt.price@utoronto.ca
:MAIL_SUBJECT: Comments on Darwin Assignment (Student One)
:END:
- Organization ::
- Clarity of Thesis ::
- Presentation of Evidence ::
- Grammar and Spelling ::
- Style ::
- Citations ::
- Further Comments ::
- Grade ::
** TODO Student Two
:PROPERTIES:
:GRADE:    0
:MAIL_TO:  student.two@utoronto.edu
:MAIL_CC:  matt.price@utoronto.ca
:MAIL_REPLY: matt.price@utoronto.ca
:MAIL_SUBJECT: Comments on Darwin Assignment (Student Two)
:END:
- Organization ::
- Clarity of Thesis ::
- Presentation of Evidence ::
- Grammar and Spelling ::
- Style ::
- Citations ::
- Further Comments ::
- Grade ::
** TODO Student Three
:PROPERTIES:
:GRADE:    0
:MAIL_TO:  student.three@utoronto.edu
:MAIL_CC:  matt.price@utoronto.ca
:MAIL_REPLY: matt.price@utoronto.ca
:MAIL_SUBJECT: Comments on Darwin Assignment (Student Three)
:END:
- Organization ::
- Clarity of Thesis ::
- Presentation of Evidence ::
- Grammar and Spelling ::
- Style ::
- Citations ::
- Further Comments ::
- Grade ::
---------------------------------------------

I have three remaining issues

[-- Attachment #2: Type: text/html, Size: 5548 bytes --]

^ permalink raw reply	[flat|nested] 19+ messages in thread

end of thread, other threads:[~2015-08-10 14:41 UTC | newest]

Thread overview: 19+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2015-08-06 11:24 Showing Property in headline; generating table from properties; exporting table to CSV Matt Price
2015-08-06 11:28 ` Eric S Fraga
2015-08-06 11:34   ` Nicolas Goaziou
2015-08-06 12:17     ` Eric S Fraga
2015-08-06 12:24     ` Matt Price
2015-08-06 13:44       ` Nicolas Goaziou
2015-08-06 13:13   ` John Kitchin
2015-08-06 13:29     ` Matt Price
2015-08-06 14:19       ` John Kitchin
2015-08-06 16:39         ` Matt Price
2015-08-06 16:47           ` John Kitchin
2015-08-07 16:41         ` Pip Cet
2015-08-10 14:41           ` Eric S Fraga
2015-08-07  1:43       ` Richard Lawrence
2015-08-06 14:06   ` John Kitchin
2015-08-06 16:26     ` Matt Price
2015-08-06 13:52 ` John Kitchin
2015-08-06 17:27   ` Matt Price
2015-08-06 18:14     ` John Kitchin

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).