What email address or phone number would you like to use to sign in to Docs.com?
If you already have an account that you use with Office or other Microsoft services, enter it here.
Or sign in with:
Signing in allows you to download and like content, and it provides the authors analytical data about your interactions with their content.
Embed code for: Gathering Student Data to Drive Instruction
Select a size
The slide deck from my SimpleK12 webinar, which can be found on demand here: http://community.simplek12.com/scripts/student/webinars/view.asp?id=2184
Gathering Student Data
to Drive Instruction
ELLs, Low SES
Need to Learn the 4 Domains
“We are all ELA teachers now”
Reading & Writing?
Meaningful to my
Relevant to my
The Chair Test
Peer feedback - Getting my students involved
Evidence from the data
Evidence from the music
Draw evidence from literary or informational texts to support analysis, reflection, and research.
Write informative/explanatory texts to examine and convey complex ideas and information clearly and accurately through the effective selection, organization, and analysis of content.
Two Sets of Data!
Standards Based Learning
Rubrics, not 100 point scales
Students achieving mastery in a standard
Paul Black, Christine Harrison, Clare Lee, Bethan Marshall, and Dylan Wiliam, “Working Inside the Black Box: Assessment for Learning in the Classroom,” Phi Delta Kappan, Vol. 86, No. 1, September 2004, pp. 9-21.
"Peer assessment is uniquely valuable because students may accept criticisms of their work from one another that they would not take seriously if the remarks were offered by a teacher"
"Peer work is also valuable because the interchange will be in language that students themselves naturally use and because students learn by taking the roles of teachers and examiners of others"
Collaborative Conversations discussing feedback
"Written tasks, alongside oral questioning, should encourage students to develop and show understanding of the key features of what they have learned.”
“Comments should identify what has been done well and what still needs improvement and give guidance on how to make that improvement.”
“Opportunities for students to respond to comments should be planned as part of the overall learning process."
"We now believe that the effort that many teachers devote to grading homework may be misdirected. A numerical score or a grade does not tell students how to improve their work, so an opportunity to enhance their learning is lost"
Great! I see their score!
They all provide a downloadable spreadsheet
What is the interval?
My Answers in Disguise
Multiple Choice – 4 Answers
Right Interval, but wrong quality
Wrong Interval (x2)
Didn’t count correct # of half steps
Didn’t count lines and spaces correctly
Recoded for Analysis
Not just wrong answers anymore
Why did they get it wrong?
Break it down into sections, years in music, type of question, etc.
Excel is your friend
My Brass students can’t count lines and spaces!
What do I use?
Kahoot & GoFormative for Formative Assessments
Online Excel surveys for student performance feedback
New Office 365 tool coming soon ----- Forms!
Excel Pivot Tables
Import charts into MS Word docs or OneNote Class Notebook for my students
Microsoft Power BI
Analysis in the cloud
Easier than pivot tables
Plan ahead of time
Categorize your questions or rubric based activities into as many details that are relevant to you
Design multiple choice answers so you can get back feedback on their knowledge and understanding
Practice makes perfect
Keep an original copy of your data
Make as many copies of your data as you want
Use COUNTIF function to find the frequency
Use math to find your scores and averages
Put your data into Table format, and give them a name
Don’t be shy, start using Pivot Tables
Keep the colors in your charts consistent across categories
Practice makes perfect
organization, and analysis of content.