Tech Rav
Discussions of Jewish EdTech

Thursday, May 29, 2008

Creating randomly sorted test questions using Excel 2007

Teachers often like to create different versions of the same test or final. The goal obviously is to prevent cheating. By creating many different versions of the same test, the student who looks over at his shoulders at his friend's test will see questions in a totally different order. This will obviously hamper his ability to "share" his answers with his friend. But how do you do this in a fast and efficient way? Most of us just cut and paste in Word to create different tests. However, if you write your questions in different cells of an Excel spreadsheet, you can quickly create many different orders for your questions using the Random formula and sorting from smallest to largest. Below are step-by=step instructions to use this feature.

  1. Open Excel and name column A in your spreadsheet "Questions". Type each test question in a separate row in Column A.

  2. Next to list, add a heading called Random

  3. Select all of the cells next to this column of Test Questions. Type =RAND()

  4. Hit Ctrl+Enter to enter the cells in all of the cells in the selection.

  5. Click "Sort and Filter" then "Sort Smallest to Largest" in order to sort by column B.

  6. Make sure to click "Expand the Selection" and then "Sort" to sort all of the rows.

  7. You now have a Random Sequence for your test questions. You can copy and paste these questions into MS Word.

  8. To create a second Random Sequence (different from the first) just press F9 on your keyboard which will automatically recalculate the formula as seen below.

  9. Now once again Sort<Smallest to Largest< Expand Selection< Sort. You will now have a new random list of questions which is different from the first.

Wednesday, May 07, 2008

Israel @60

Below please find resources you can use with your classes to commemorate this most important Yom Hazikaron and celebrate this most enjoyable Yom Haatzmaut as we rejoice on the occasion of Israel's 60th birthday.

Yom Hazikaron This website is devoted to Yom Hazikaron. You can view biographies in Hebrew of every fallen Israeli soldier and see where they are buried in an Israeli military cemetery.

Yom Haazmaut

Here are 3 links from the Jewish Agency:

Jacob Richman has gathered 106 cool Israel videos from YouTube.
Enjoy the videos at:

Yeshiva University has its Yom Haatzmaut to Go Package from Here is a direct link to download it:
You can also listen to shiurim on YU Click here for Yom Haatzmaut.

A magical slideshow for Israel's 60th anniversary: ISRAEL AS YOU'VE NEVER SEEN BEFORE! Click to see the miracles of the Promised Land:

Israel's accomplishments:

A one-minute "promo" PR for a movie/presentation that you can buy - or just enjoy as it is. Same guy who made the attached powerpoint: Israel Forever

60 years in 60 seconds:

In the Blink of an Eye - Dr. Rahamim Melamed-Cohen:

Here are links to audio and print shiurim on Yom Haatzmaut from TorahWeb:
Rabbi Hershel Schachter - The Significance of the State of Israel; Celebrating Yom Ha'atsmaut
Rabbi Mayer Twersky - Eretz Yisrael's Central Role in Halacha and Hashkafa
Rabbi Michael Rosensweig - Eretz Yisrael: The Corporate Headquarters of Klal Yisroel
Rav Mayer Twersky - The Current Situation in Israel As Seen Through the Prism of Chanukah

Divrei Torah:
Rabbi Herschel Schachter - The Boundaries of the Land
Rabbi Yaakov Haber - Mitzvot and Eretz Yisrael
Rabbi Yaakov Haber - The Desired Land
Rabbi Herschel Schachter - Moshiach, Moshiach, Moshiach!!
Rabbi Mordechai Willig - Kibud Av V'aim vs. Living in Israel
Rabbi Mordechai Willig - Shmitah for the Consumer
Rabbi Herschel Schachter - Are We Still the Am Hanivchar?
Rabbi Yaakov Neuburger - The Interdependence of Generations
Rabbi Michael Rosensweig - Reflections on Yom ha-Atzmaut: Eretz Yisrael as a Framework for Kedushah and Spiritual Opportunity
Rabbi Mordechai Willig - Cheit Hameraglim: Then and Now