Activity

Connect Five Coded Excel Game

Students answer questions in groups to take a turn at "Connect Five".

This is a coded Excel game! If you want to use it, you will have to have Excel and allow macros.

WHAT YOU'LL NEED

  • White boards, markers, and erasers for each group
  • Copies of a list of questions for each group

DIRECTIONS

  • Divide your class into groups
    • Each group gets one of the four colors. If there are more than four groups, let groups work together as teams under one color.
  • Groups answer questions on their white boards.
  • For each answer, have one student from that group bring their white board and questions list to you.
  • If they are correct, mark that question complete on the list and have them take a turn placing a colored square.
  • Get 5 of the same color in a row to get a point.

GAME PLAY

  • Click New Game to clear the board.
  • Click a color and then click anywhere on the board to place a piece.
    • Pieces will fall to the bottom of the board like in Connect 4.
  • Collect 5 of the same color in a row to earn a point.
    • The winning pieces will disappear and the leftover pieces will slide down to fill their places, like in Candy Crush.
    • Overlapping wins are not counted. (If red gets five across and 5 down at the same time with an overlapping piece, only one win is counted and cleared.)
  • To adjust the score, click Edit Points.

VARIATIONS

  • You can set a time limit or play until one team gets 5 in a row.

TECHNICAL TIPS

  • If you are using an electric blackboard, use the USB (in addition to the HTMI) to enable touch screen! Then the students can place the pieces themselves!
  • If an error message pops up, just click continue. It will still work fine!
Files:
Small files
  • Connect Five.xlsm (36.7 KB)
  • 5
    Submitted by 4sarah1212 December 20, 2022 Estimated time: 20 - 50 minutes

    Sign in or create an account to leave a comment.