topic Re: Export Historical Grades with Student Name, State Student Number and Entry Date in Community Forum

Export Historical Grades with Student Name, State Student Number and Entry Date

schavezNM — Tue, 04 Feb 2025 23:05:03 GMT

I am needing to Export Historical Grades (Specifically the current school years Term Grades) with Student Name, State Student number and Entry date but they are on two different tables in the Data Export Manager. Does anyone know how to do this in one table?

Re: Export Historical Grades with Student Name, State Student Number and Entry Date

reyna789 — Wed, 05 Feb 2025 06:56:20 GMT

@schavezNM wrote:
I am needing to Export Historical Grades (Specifically the current school years Term Grades) with Student Name, State Student number and Entry date but they are on two different tables in the Data Export Manager. Does anyone know how to do this in one table?

To combine historical grades from two separate tables into one, you'll need to integrate the data. This can often be done within your data management software using a join operation, or manually using spreadsheet software like Excel. Identify the common field (likely Student ID) to link the tables. Export the combined data in your preferred format (CSV, Excel, etc.). Remember to prioritize data privacy and consult your software's documentation for specific instructions.

Re: Export Historical Grades with Student Name, State Student Number and Entry Date

JeffG9 — Wed, 05 Feb 2025 13:04:32 GMT

It would likely be easier to do this via DDE than DEM. We advise our districts NOT to store State SN in PS, but when exporting from the StoredGrades table in DDE you can also export from the Students table. For example:

[01]lastfirst

[01]entrydate

StoreCode

Grade

etc etc

Re: Export Historical Grades with Student Name, State Student Number and Entry Date

mthompsonstfrancis — Thu, 20 Feb 2025 18:09:13 GMT

Hi Jeff,

If I wanted to export from the students table first, but also grab some data elements from StoredGrades, what would I prefix the StoredGrades field names with? I tried [31] thinking that was the table number, but I'm not getting any data in those fields.

The Science Dept Chair wants all seniors who have complete 4+ Science classes (credittype=science). I could start with StoredGrades, but I'd rather start with the students table as it's a smaller dataset.

example:

Student_Number
Last_Name
First_Name
[31]StudentID
[31]Course_Name
[31]CreditType

Re: Export Historical Grades with Student Name, State Student Number and Entry Date

jsonsiadek — Thu, 20 Feb 2025 19:27:31 GMT

I would select my students from the start page then go to DDE. From there go to the stored grades table and match the selection to the students table. Then you can use the stored grades fields that are available and use the fields below for the students.

[1]Student_Number
[1]Last_Name
[1]First_Name

Re: Export Historical Grades with Student Name, State Student Number and Entry Date

JeffG9 — Fri, 21 Feb 2025 13:05:28 GMT

What Jackie said, 🙂 I would select the students I want to work with and then do a Match Selection. That way you have just the stored grades of the smaller set of students you want to work with.

Re: Export Historical Grades with Student Name, State Student Number and Entry Date

mthompsonstfrancis — Fri, 21 Feb 2025 16:48:26 GMT

Thank you both!

Re: Export Historical Grades with Student Name, State Student Number and Entry Date

jsonsiadek — Fri, 21 Feb 2025 17:40:11 GMT

You're welcome 🙂