Random+Test+Generator

= Random Test Generator =

I began by taking a test found on the [|Glencoe/McGraw Hill website]. [|This test] is for Algebra I students, covering the topic "Solving Linear Equations". My goal for this project was to create 5 versions of the test using excel by having it randomize the order of the questions. This project saves the teacher the time of writing separate versions of a test (assuming they have this template to work with!) and reduces the ability/likelihood of students cheating on tests.

This project clearly exploits excel as it uses functions, multiple pages, the fill-in capability and more. I then used the mail-merge function to get the test versions from excel into word. While I had used basic excel functions prior to this project, I learned a lot more about their uses in this project. I also learned how to use the mail merge function (completely new territory for me) through this project and how picky it is with the format of the data being merged. I believe this project takes the test questions from the Glencoe website to a new level by randomizing the order of the questions and producing multiple versions. I think that this project is an effective use of technology because it uses multiple aspects of Microsoft Office in order to make the teacher's life easier while also cutting down on potential cheating. Overall, I enjoyed this project (once it worked the way it should) because it presented me with a use for excel that I have never thought about before but imagine I will use in my classroom!

**__Final Project:__**
- Excel document - Word document before mail merge - the final results!!!!

__**Resources**__ [|Glencoe Mathematics Algebra I, ch. 3 test]. [|Help with randomizer formula]

Personal Home Page ~*~ Class Reflections ~*~ Investing Project ~*~ Random Test Generator ~*~ Photoshop Elements Worksheets ~*~ Bacteria Growth