Forum Discussion
Tracking student progress
JeffreyB593 Not sure I follow, but when I select/enter some new Competencies and refresh the pivot table, all seem to be included properly. With respect to adding new assignments, select the last block from the table (i.e. T1:W37). Copy and Paste to X1. The table is expanded with all the formats and data validation in place. Do NOT select entire columns T to W. Then it will not work.
Thanks to all that have pitched in with suggestions and even some changes. The semester has started and there hasn't been much time to come back to the forum but I have been tinkering and I have something that I think will work for me. I would like to have the Competency row to be a pull down menu but each time I try it the pivot tables don't seem to refresh along with it. I'm certain that it is due to the change from a number to text. I was trying to find a way to distinguish between the two sets of outcomes. Ideally, I would love to have the whole explanation to be a part of the pull down and only the code to be the value that is inserted. But I expect that is asking for the impossible. The other matter is the adding of new assignments. I would love to add it as a block. Right now I am just selecting the four blank columns and adding them to the left.
JeffreyB593 Not sure I follow, but when I select/enter some new Competencies and refresh the pivot table, all seem to be included properly. With respect to adding new assignments, select the last block from the table (i.e. T1:W37). Copy and Paste to X1. The table is expanded with all the formats and data validation in place. Do NOT select entire columns T to W. Then it will not work.
Here is the version where I change the Competency row to a pull down menu with the codes that I created on Sheet 4. I'm guessing I need a Concatenatex formula to add to the pivot table similar to the Assessment formula but I'm still learning that one.
- I figured it out. Thanks for all your help and getting me pointed in the right direction.
- I think I figured it out. Learned more about Concatenatex and it wouldn't be helpful. Went into the Query and was able to change the column from Whole Number to Text and it works!