Forum Discussion
Solved
Tracking student progress
I'm looking to create my own grade book to track student progress over time. My school district refuses to provide an adequate grade book solution for the competency-based assessment model which we n...
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.
Mathetes,
Thanks for your reply. Assessing students with points and percentages is out of fashion now. Assessment is based on proficiency. There are skills that student are to demonstrate their proficiency. For Grade 10 Composition for example, some of the competencies look like this:
*Respectfully exchange ideas and viewpoints from diverse perspectives to build shared understanding and extend thinking
*Respond to text in personal, creative, and critical ways
*Assess and refine texts to improve clarity and impact
*Demonstrate speaking and listening skills in a variety of formal and informal contexts for a range of purposes
*Use writing and design processes to plan, develop, and create engaging and meaningful texts for a variety of purposes and audiences
*Express and support an opinion with evidence
*Use the conventions of Canadian spelling, grammar, and punctuation proficiently and as appropriate to the context
*Use acknowledgements and citations to recognize intellectual property rights
*Transform ideas and information to create original texts
There are four levels of proficiency: Approaching, Developing, Proficient, and Extending. Any tasks assigned provide students with opportunities to display their proficiency in the above core competencies. As a teacher, you are trying to get kids to proficient.
So I'm trying to work out how to create a spread sheet that will students down the first column and then assignments and the 2-4 core competencies that are being assessed through that assignment. What ends up is a spreadsheet with some nested column headings. Now, I have been watching some videos and playing with pivot tables to see see what I can come up with. So far I have created a spreadsheet that looks like what I want, and then used unpivot to gather that all into a proper table and then creating a pivot table from that. So far, so good. The tables that results looks good but seems limited to counting, averaging or adding the data, which, of course, isn't in the form of a number. Ideally, I would have each of the levels coded to a colour. I wish I could show you what I have created so far.
Things do not need to get too granular. I can just store this as a excel file. The results need to show me, the student, their parents the student's growth. As a whole class, I be able to see what is working and what is not. I'll be able to see how often each of the core competencies are being assessed.
Thanks for your reply. Assessing students with points and percentages is out of fashion now. Assessment is based on proficiency. There are skills that student are to demonstrate their proficiency. For Grade 10 Composition for example, some of the competencies look like this:
*Respectfully exchange ideas and viewpoints from diverse perspectives to build shared understanding and extend thinking
*Respond to text in personal, creative, and critical ways
*Assess and refine texts to improve clarity and impact
*Demonstrate speaking and listening skills in a variety of formal and informal contexts for a range of purposes
*Use writing and design processes to plan, develop, and create engaging and meaningful texts for a variety of purposes and audiences
*Express and support an opinion with evidence
*Use the conventions of Canadian spelling, grammar, and punctuation proficiently and as appropriate to the context
*Use acknowledgements and citations to recognize intellectual property rights
*Transform ideas and information to create original texts
There are four levels of proficiency: Approaching, Developing, Proficient, and Extending. Any tasks assigned provide students with opportunities to display their proficiency in the above core competencies. As a teacher, you are trying to get kids to proficient.
So I'm trying to work out how to create a spread sheet that will students down the first column and then assignments and the 2-4 core competencies that are being assessed through that assignment. What ends up is a spreadsheet with some nested column headings. Now, I have been watching some videos and playing with pivot tables to see see what I can come up with. So far I have created a spreadsheet that looks like what I want, and then used unpivot to gather that all into a proper table and then creating a pivot table from that. So far, so good. The tables that results looks good but seems limited to counting, averaging or adding the data, which, of course, isn't in the form of a number. Ideally, I would have each of the levels coded to a colour. I wish I could show you what I have created so far.
Things do not need to get too granular. I can just store this as a excel file. The results need to show me, the student, their parents the student's growth. As a whole class, I be able to see what is working and what is not. I'll be able to see how often each of the core competencies are being assessed.
You can show me what you've created so far. Use the ability to send me a personal message here in this forum. Click on my user name and you'll be taken to a page where in the top right corner you'll see a way to Message me. There, to that message, you will be able to attach a copy of the spreadsheet you've created. Or post it in OneDrive or GoogleDrive or one of the other cloud services and post a link here.