I’ve had a strange thought and, given all the new features coming down the pipe these past weeks, I figured I’d let myself “dream in color” and describe a pie-in-the sky feature that I’m not sure is possible but that would address a genuine problem I encounter in how I use TBX. I’ve struggled to explain it but roughly what I’m thinking is this:
My principal TBX file at any given moment is the course file I’m using to organize my teaching during the current term. I use this file to organize my lecture materials and course work, but I also use it to keep track of what (and how) students are doing. Just like in the actual courses, it is the student part (not the lectures) that is more challenging to manage.
In my course file, the challenge I face is that I have info that comes to me in spreadsheets that have to be entered manually into TBX because I need the info to be added to blank attributes of existing student notes and not imported as new notes. For example: when grades for the first essay arrive, I don’t need new notes, I need the grades added to the “gEssayOne” attribute for each students’ existing note.
Crosstabs and Import: My Odd Thought/Request
But now we have cross tabs. And without having any sense of how things work behind the scenes engineering-wise, what I see is a tool for linking temporarily two attributes to show how they interact. So is it possible, if I have a spreadsheet that contains two columns that are named after attributes (call them sID and gEssayOne), to create a function in which I import those two columns and TBX uses the first attribute (sID) to identify a note which then has the value of the attribute matching the second column (gEssayOne) set by the info in the corresponding second column of the spreadsheet?
My Specific Task
I’m not sure if what I’ve described is clear but, at the beginning of the semester, I import a spreadsheet of basic student information to create student notes. I need to add values to a series of attributes for these student notes over the term. Ideally, I could do this by simply importing from a spreadsheet to update the existing notes by pairing this spreadsheet column of new values to a column of fixed values (i.e. a student ID number that ID’s a unique note in the TBX file).
I’m not sure if that’s clear. Also not sure if it’s even possible. But that’s my off the wall suggestion.