What does your data tell you?
Ways to analyze your course data:
- Survey your students.
- Analyze Student Data
- Reflect on how the semester went.
2. Go to File > Make a copy
3. Rename your survey so you can find it easily.
4. Tailor the questions to get the data you want from students.
5. Share the survey with your students. I suggest adding a link in your last module.
What if I don't have categories set up like this?
- To make your life easier later, click the cog > assort assignments by assignment group
- Click export
- Select current
- It will automatically download a .CSV file that opens in Excel (or Google Sheets or Apple Numbers).
- From there you can use different Excel computations to look at your data.
Getting an average in Excel
Find your tests
At the bottom of the column you're going to have to put in a formula.
Let's say your test column is Z and you have 30 total rows. Your formula will look like =average(Z2:Z30)
This is telling Excel to get an average for everything in column Z from the 2nd row to the 30th.
You can copy and paste this cell to other rows to get more averages. (see below)
Once you get your data
More ways than averages
Using Canvas Analytics
How to use these
So what's the point?
It's like archaeology
How to reflect
As a nosy administrator, I am always happy to read or discuss your reflections. There is more value to me in seeing the changes as opposed to just talking about them. Words are wind, as they say.
Teaching and Learning
- Did students learn what I wanted them to learn?
- How do I know they learned it?
- What did I do when I could tell they hadn't learned it?
- What did I do when I could tell they already knew what I was teaching?
- What's one thing I can do now that I couldn't do at the beginning of the year?
- What's one thing I will add to my course next year that wasn't there this year?
- What's something I understand about my content that I didn't understand before?
- What's something I want learn next year?
- What's one tool I don't have that I'd like to add next year?
- What did my students tell me in my course surveys that I expected to hear?
- What did students say that I didn't expect to hear?
- What's something I will change based on student feedback?
- What's something I won't change based on student feedback?
- What's something I need to present better to students?