# TOPS Collaborative

### Summer Work

## Your choice

## What does your data tell you?

## Ways to analyze your course data:

- Survey your students.
- Analyze Student Data
- Reflect on how the semester went.

## Course Surveys

## Course Survey

1. Open this link: https://docs.google.com/a/tennesseeonlinepublicschool.org/forms/d/1SHhngNbbIhYS77vVMeTJAQqT7xOmUGmHrPECNhVgc6Y/edit?usp=sharing

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.

## Assessment Average

## Canvas Gradebook

## What if I don't have categories set up like this?

## Exporting

- 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

*I apologize for assuming someone might not know how to do this*

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

## Advanced Statistics

## More ways than averages

## Using Canvas Analytics

## How to use these

## So what's the point?

## It's like archaeology

## Reflection

## 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?

**Professional Growth**

- 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?

**Feedback**

- 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?