Ideally I would create a report card layout that would include fields gathered from my deployed report sheets and summary attendance information from the journals... then if the export created an excel spreadsheet with one student per row with the data collected for the report card per column. Essentially creating a flat structure that I could then use in a variety of ways.
I'm happy to put together a sample if helpful.
Thanks,
Rena Willis
Lakeside International School
-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Tom Hoffman
Sent: Monday, April 09, 2012 8:42 AM
To: <email address hidden>
Subject: [Bug 976757] Re: Report Card Data should be Exportable
Yes, good idea. Would you like to see a spreadsheet with one row per student and then all the section scores for a report sheet on the columns. One report sheet = a worksheet in the spreadsheet. Plus a worksheet for the aggregated journal info?
Bug description:
Suggestion: Our school has a very intricately designed report card
layout. If report card data is available for export a school could
use the data in customized reports (then schooltool would not need a
fully developed reporting interface right off.) As it sits, it
appears that in order to obtain the same data that is displayed in the
report card .PDF, I must download the individual gradebooks for each
individual teacher and then merge the data. Schooltool is already
running the query that produces the summarized report card data. It
would be very helpful to have access to that in any usable format
(even .CSV)
Tom,
Ideally I would create a report card layout that would include fields gathered from my deployed report sheets and summary attendance information from the journals... then if the export created an excel spreadsheet with one student per row with the data collected for the report card per column. Essentially creating a flat structure that I could then use in a variety of ways.
I'm happy to put together a sample if helpful.
Thanks,
Rena Willis
Lakeside International School
-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Tom Hoffman
Sent: Monday, April 09, 2012 8:42 AM
To: <email address hidden>
Subject: [Bug 976757] Re: Report Card Data should be Exportable
Yes, good idea. Would you like to see a spreadsheet with one row per student and then all the section scores for a report sheet on the columns. One report sheet = a worksheet in the spreadsheet. Plus a worksheet for the aggregated journal info?
Or do you have a different idea for the format?
** Changed in: schooltool
Status: New => Triaged
** Changed in: schooltool
Importance: Undecided => Critical
** Changed in: schooltool
Milestone: None => 2.1.0
** Changed in: schooltool
Assignee: (unassigned) => Alan Elkner (aelkner)
-- /bugs.launchpad .net/bugs/ 976757
You received this bug notification because you are subscribed to the bug report.
https:/
Title:
Report Card Data should be Exportable
Status in SchoolTool:
Triaged
Bug description:
Suggestion: Our school has a very intricately designed report card
layout. If report card data is available for export a school could
use the data in customized reports (then schooltool would not need a
fully developed reporting interface right off.) As it sits, it
appears that in order to obtain the same data that is displayed in the
report card .PDF, I must download the individual gradebooks for each
individual teacher and then merge the data. Schooltool is already
running the query that produces the summarized report card data. It
would be very helpful to have access to that in any usable format
(even .CSV)
To manage notifications about this bug go to: /bugs.launchpad .net/schooltool /+bug/976757/ +subscriptions
https:/