Grading List/Export by Marking Periods

Peter Cox

I am looking for a way to build a list to export marking period (MP) grades for a group of students to do some offline analysis. I have tried several list types and contacted support but haven't succeeded. I now export several lists and would potentially need eight because of limited export options.

I want to export each marking period as a field by selecting “Enrollment Grade. Grade" multiple times, then filtering each with a join clause on “Grade Plan Grade. Grade Description” to specify the output; (MP, Pass/Fail, or standard), (MP, Effort).

I ultimately want to see for each record; UID, FName, LName, Grad Year, Course, Term, Q1 Grade, Q1 Effort, Q2 Grade, Q2 Effort, Q3 Grade, Q3 Effort, Q4 Grade, Q4 Effort.

Joshua Blice

I have run into the same issue so if anyone finds a solution, I would love to know. I have created advanced lists over and over with no luck. We are having to cut and paste to create the proper report. ?

Susan Ott

@Peter Cox My experience with this has been that the advanced list will time out or error. I'm guessing because there are too many results or too many filters. I often forget about the basic lists and have pulled grade detail that way in the past. Unfortunately those results won't be flattened though.

John Ronan

If I understand you correctly [, even with advanced lists, ] you're only able to get results like the following:

Last First Marking Pd. Grade
Smith John MP1 85
Smith John MP2 90
….

And what you want is all the info for “Smith, John” on one line, e.g.:
Last First Marking Pd. [1] Grade [1] Marking Pd. [2] Grade [2] …
Smith John MP1 85 MP2 90 …

Do I understand correctly?

For those of us who came from Education Edge, this is the diff. between what a query used to give us and what an export would yield.

I have been using some Perl scripts that I wrote years ago that I'm happy to sell you. The regular price is $.00001 per license, but I'm reducing the price by $.00001 for Black Friday.

It works like this:

• Sort the .csv [or tab-delimited] file by the “fixed columns” In this example, you'd sort by Last, then First.
• Optionally, you might wanna sort further by Marking Pd, etc.
• Run the script, giving it:
  • The file name of the .csv
  • The number of “fixed columns" [2 in this case]
  • The number of columns in the “repeating group” [also 2 in this case]
  • The maximum number of repeating groups. [in an example like this, if you'd expect to see a max of four marking periods, you'd enter “4”].

It'll then create another .csv file with all the “Smith, John” info combined into one record.

If this sounds useful, I can post.

BTW, FWIW, I also have a script that does the opposite…
Lemme know.

Scott Chrysler

@john ronan - I would love to have both of those scripts. I have spent years cutting and pasting columns to reformat the data into “acceptable” import format.

Joshua Blice

@john ronan
I would love to have the script too, that would be super helpful for our registrar.

John Ronan

Well not sure of the best way to get these scripts out to y'all.

When I try an “insert file” in this post, I get the following mysterious error popup: “Blackbaud.community.com says 'an error has occurred' ". [even though it seems to work for other .txt files]

Anyone have any ideas? [pretty novice when it comes to social media, etc.]

Susan Ott

@john ronan if you figure out a way to share, I would love to be included!

Elizabeth Perron

@john ronan I am working on it!

Elizabeth

Community Management Team

Elizabeth Perron

@john ronan Can you please email one of the text files you are trying to upload to me at community@blackbaud.com so I can provide it to the platform vendor to figure out why it won't upload?

Katherine Nolte

@Peter Cox I have attached some screenshots of Advanced lists that have worked for me. Sometimes I will receive requests to compare grades between Sem 1 & Sem 2 or pull a list of grades given for Sem 1 (I'm happy to hear they are adding the feature of teachers being able to view the previous grade when assigning the next term's grade!).

At our school, we use both Assessment Grades and Standard Grades. Both list settings are included on the attachment.

@Susan Ott is right about the lists timing out. You may have to fiddle around with the filters to limit the results.

Grade Advanced Lists.pdf