Welcome to Do It Yourself Learning Analytics
In this section we will be taking you on a journey to explore how one can run a simple analysis on ones own classrooms grades. We will be using Google Forms/Spreadsheets to help us gather data and a combination of a script called Flubaroo and excel to do our analysis.
Below is a tutorial showing you how to setup a quiz and answer sheet. In addition, the finished products, both the quiz and results are available to you.
Results (there are 2 tabs on the bottom of the chart, click on the one entitled Grades to see Flubaroo’s results)
Running Your Own Data Analysis
Below are a series of steps you can follow to complete a data analysis on a post-assessment quiz that you would give your class before starting a unit.
Laying the groundwork:
- Examine curricular target expectations
- Create a post-assessment
- Administer the post-assessment BEFORE teaching
- Pick a proficiency level
Collect and chart data:
- Use the excel sheet below, input your data and examine student results. Please note there are 3 tabs in the excel sheet that allow you to input data for different situations
- Individual Teacher
- Multiple Teachers teaching the same class
- Multiple Teachers with multiple items
- proficiency tabulators
Analyze strengths and obstacles:
Now that you have your data, you can use the questions below to help you reflect on what your data is telling you.
- On what areas of the assessment did the students perform well? (most frequently correct?)
- On what areas of the assessment did the students perform poorly? (most frequently missed?)
- To what do you attribute their lack of success in these areas? (type of instruction, time spent, feedback, previous formative assessment?)
- In what areas does your partner or other periods have similar results?
- In what areas does your partner or periods have different results?
- Are there any implications or changes that immediately come to the forefront with regards to future instruction? What will you do differently based on the results obtained?
- Have you done your own data analysis? If yes, please share your experience