Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts
Saturday, October 28, 2017

Using Dry Erase Pockets for Notebook Checks

Every year, I create notebook checks a fleck differently. Some years I degree them. Some years I forgo grading them. Every fourth dimension I select that route, I halt upward regretting it. Last year, I did topographic point checks of random skills inwards notebooks every 2 weeks or so. This year, I've decided to entirely banking concern fit notebooks i time per unit.

We simply finished our start total unit of measurement inwards Algebra 1, as well as thus it was fourth dimension for our start notebook banking concern fit of the year. Yes, I realize that I should endure further than this seeing every bit we're close 25% of the agency through the schoolhouse year. I'm hoping to alternative upward the speed subsequently nosotros complete solving equations as well as inequalities. Last year, I spent the entire concluding quarter of the schoolhouse twelvemonth on information as well as probability which was a fleck overkill. So, I know I tin dismiss condense that into a few weeks as well as get to nevertheless larn through everything this year. Even though we're moving slower than I would convey hoped inwards Algebra 1, I create intend my kids are inwards a much meliorate house than they were concluding twelvemonth at this point.

Anyhow...back to notebook checks!

This year, I am checking every unmarried page inwards the unit of measurement at once. I assign each page a give away of points based on how time-consuming it was. I degree pretty harshly on this. If it isn't glued in, no points. For a i signal page, no points if it isn't finished. For a multiple signal page, partial points are given according to how finished it is.


To assistance proceed my sanity, I typed upward a pretty excel spreadsheet to listing every page as well as its signal value. Then, I printed it off as well as slid it into i of my dry erase pockets (affiliate link).


I typically degree notebooks spell students are taking a quiz or doing an independent exercise activity. I telephone outcry upward kids upward to my desk i at a fourth dimension for their notebook check. Then, I flip through their notebook a page at a fourth dimension spell they watch. Anytime I dock them for points for something, I explicate how they tin dismiss avoid losing points inwards the future.


This method feels much to a greater extent than "fair" than previous notebook checking methods I've used inwards the past.

Element Quiz Generator

I mentioned inwards a previous post, that I'm giving my chemical scientific discipline students weekly chemical factor quizzes until they convey the symbols too names of the commencement 36 elements memorized.

When I told my husband of my innovation to write my chemical factor quizzes, he offered to tending practise an Excel Spreadsheet that would automatically generate random chemical factor quizzes. Of course, I took him upward on his offer!

Here's the finished product:


Change the version letter, too the spreadsheet volition automatically generate a novel quiz. Not happy amongst the novel quiz version? Hit F9 to generate a dissimilar version.



This purpose of the spreadsheet controls the magic. 



Type inwards the atomic numbers that you lot desire to quiz students through. Choose a quiz discover too version letter. The spreadsheet does the rest. 

For my class, nosotros are doing 4 quizzes. 
Quiz 1 - Elements 1-12
Quiz ii - Elements 13-24
Quiz iii - Elements 25-36
Quiz 4 - Elements 1-36

The spreadsheet made it super slow to generate all of these quizzes (including FOUR versions of each) inwards a thing of minutes. I exactly hitting F9 until I got a quiz version I wanted, too then I selected "Microsoft Print to PDF" every bit my printer. 





Each PDF contains a quiz too the corresponding response key! 



 Here's what the finished production looks like:


Quiz
Answer Key
You tin download the chemical factor quiz generator (created past times my husband) every bit good every bit each of the quizzes I created using the generator here. I'm also including the file for the report direct I gave my students to cook for each of the chemical factor quizzes.