From mboxrd@z Thu Jan 1 00:00:00 1970 From: Matt Price Subject: Showing Property in headline; generating table from properties; exporting table to CSV Date: Thu, 6 Aug 2015 07:24:29 -0400 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=001a113df88e45f67a051ca2c361 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:50329) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZNJHl-0006oX-6o for emacs-orgmode@gnu.org; Thu, 06 Aug 2015 07:24:34 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ZNJHj-000202-B5 for emacs-orgmode@gnu.org; Thu, 06 Aug 2015 07:24:33 -0400 Received: from mail-io0-x22c.google.com ([2607:f8b0:4001:c06::22c]:36042) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZNJHj-0001zl-41 for emacs-orgmode@gnu.org; Thu, 06 Aug 2015 07:24:31 -0400 Received: by ioeg141 with SMTP id g141so77622397ioe.3 for ; Thu, 06 Aug 2015 04:24:30 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Org Mode --001a113df88e45f67a051ca2c361 Content-Type: text/plain; charset=UTF-8 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 --001a113df88e45f67a051ca2c361 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello eveyrone!
I know the big guns are all working on last-minute 8.3 bugs (tha= nk you!).

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

- export a csv file containing st= udent names.
- generate grading templates for each student, for ea= ch assignment
- email comments back to students
- enter m= arks in an official spreadsheet which can be used for final grade submissio= n

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

So, here are my quest= ions:

- I currently store my grades as properties of leve= l-2 headlines. However, I would really like to be able to see the grades wh= en the headline is folded, so I can have a quick visual sense of how many p= apers I've marked, how well the students are doing, and so forth.=C2=A0= 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 va= lue, that would be cool too.

- It seems silly to record t= he grades once in org, and then again in a libreoffice spreadsheet.=C2=A0 B= etter would be to generate a table and/or csv spreadsheet directly from the= headlines and property values.=C2=A0 So, the example below would give the = table:
| Student=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | Definition | Darw= in |
| Student One=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0 |
| Student Two=C2= =A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0 |=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 0 |
| Student Three |=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0 | 0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |
and from there I guess I could generate a CSV just with org-tab= le-export.

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

Thanks as always,
Matt

-----------------------------= -------------
* Definition
** TODO Student One
:PROPERTIES:
:GR= ADE:=C2=A0=C2=A0=C2=A0 0
:MAIL_TO:=C2=A0 student.one@utoronto.edu
:MAIL_CC:=C2=A0 matt.price@utoronto.ca
:MAIL_REPLY: matt.price@utoronto.ca
:MAIL_S= UBJECT: Comments on Definition Assignment (Student One)
:END:
- Organ= ization ::
- Clarity of Thesis ::
- Presentation of Evidence ::
- = Grammar and Spelling ::
- Style ::
- Citations ::
- Further Commen= ts ::
- Grade ::
** TODO Student Two
:PROPERTIES:
:GRADE:=C2=A0= =C2=A0=C2=A0 0
:MAIL_TO:=C2=A0 student.two@utoronto.edu
:MAIL_CC:=C2=A0 matt.price@utoronto.ca
:MAIL_REPLY: matt.price@utoronto.ca
:MAIL_SUBJECT: Co= mments on Definition Assignment (Student Two)
:END:
- Organization ::=
- Clarity of Thesis ::
- Presentation of Evidence ::
- Grammar an= d Spelling ::
- Style ::
- Citations ::
- Further Comments ::
-= Grade ::
** TODO Student Three
:PROPERTIES:
:GRADE:=C2=A0=C2=A0= =C2=A0 0
:MAIL_TO:=C2=A0 s= tudent.three@utoronto.edu
:MAIL_CC:=C2=A0 matt.price@utoronto.ca
:MAIL_REPLY: matt.price@utoronto.ca
:MAIL_SUBJECT: Comm= ents on Definition Assignment (Student Three)
:END:
- Organization ::=
- Clarity of Thesis ::
- Presentation of Evidence ::
- Grammar an= d Spelling ::
- Style ::
- Citations ::
- Further Comments ::
-= Grade ::


* Darwin
** TODO Student One
:PROPERTIES:
:GR= ADE:=C2=A0=C2=A0=C2=A0 0
:MAIL_TO:=C2=A0 student.one@utoronto.edu
:MAIL_CC:=C2=A0 matt.price@utoronto.ca
:MAIL_REPLY: matt.price@utoronto.ca
:MAIL_S= UBJECT: Comments on Darwin Assignment (Student One)
:END:
- Organizat= ion ::
- Clarity of Thesis ::
- Presentation of Evidence ::
- Gram= mar and Spelling ::
- Style ::
- Citations ::
- Further Comments := :
- Grade ::
** TODO Student Two
:PROPERTIES:
:GRADE:=C2=A0=C2= =A0=C2=A0 0
:MAIL_TO:=C2=A0 = student.two@utoronto.edu
:MAIL_CC:=C2=A0 matt.price@utoronto.ca
:MAIL_REPLY: matt.price@utoronto.ca
:MAIL_SUBJECT: Comme= nts on Darwin Assignment (Student Two)
:END:
- Organization ::
- C= larity of Thesis ::
- Presentation of Evidence ::
- Grammar and Spell= ing ::
- Style ::
- Citations ::
- Further Comments ::
- Grade = ::
** TODO Student Three
:PROPERTIES:
:GRADE:=C2=A0=C2=A0=C2=A0 0<= br>:MAIL_TO:=C2=A0 student.th= ree@utoronto.edu
:MAIL_CC:=C2=A0 matt.price@utoronto.ca
:MAIL_REPLY: matt.price@utoronto.ca
:MAIL_SUBJECT: Comments on D= arwin Assignment (Student Three)
:END:
- Organization ::
- Clarity= of Thesis ::
- Presentation of Evidence ::
- Grammar and Spelling ::=
- Style ::
- Citations ::
- Further Comments ::
- Grade ::
= ---------------------------------------------

I have three rem= aining issues
--001a113df88e45f67a051ca2c361--