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

[schavezNM]

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? 

[reyna789]

---

@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.

[JeffG9]

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

[mthompsonstfrancis]

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

[jsonsiadek]

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

[JeffG9]

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.

[mthompsonstfrancis]

Thank you both!

[jsonsiadek]

You're welcome 🙂