Techie Learning Tech

This week we created Interactive Spreadsheets using MS Excel. The one I created was for an AP Calculus class, over derivatives. Students are given a list of 10 simple functions, and have to calculate the derivative and choose the correct answer from a drop-down list of choices. The spreadsheet then tells the student if they were correct, adds up the points, and calculates the percentage of power rule, product rule, and quotient rule problems they got correct.

I thought this was a really cool method to use for assessment. I think it'd mainly be useful as a practice quiz, since students can immediately see if they were right or wrong and then change their answer. To modify it to be an actual assessment, you wouldn't want to give them immediate feedback about whether they were right or wrong.