4ºESOen – TICs – Excel spreadsheet activities – Creating an interactive game

In the activity you will create an interactive game. There will be 9 questions and if the answers are correct, it will reveal a picture underneath. The picture we will use for this activity is the shown bellow. Save it to your folder.

For this activity you will be creating an interactive game, challenging the gamers to answer multiplication facts. If they type in the correct answer a tile will reveal part of a picture. If they type in the incorrect answer the part of the picture will not be revealed.

Open Microsoft Excel and select New.

Insert a Background Picture: With your workbook open on the Page Layout tab, in the Page Setup group, click Background to open the Sheet Background dialog box. Navigate to the folder that contains the picture you saved above. Click Insert on the Sheet Background dialog box to place the picture on the page (spanish Diseño de página>Fondo).

Your picture will appear tiled, repeating itself in the background like the one shown below. Don’t worry about it right now because when you are done only one picture will show.

Tiled Picture

Change Column Width and Height: Next you want to set up the worksheet so that the picture (only one picture) is divided into a 4 X 4 grid. You want the four squares to be the same size:

Next you will need to set up the cells that will contain the instructions. That is, make column E wider.

Add Borders to Worksheet:

First you will place a thick black border around the 4 X 4 Grids that contain the cells A1:D4, as well as an all borders border around the cells.

You will also format both E1 and E1 cells with a thick black border.

Add Fill to the Worksheet: Select entire worksheet by clicking in the top left hand corner of the worksheet.

This will turn the entire worksheet blue indicating that it is selected. Next you will fill the worksheet with a fill color. Click on the format font button on the Home tab to open the Format Cells dialog box. Select fill, then select a color you want to fill your worksheet with.

Now you will add an all border around the section that will contain your clues. The cells you will add are shown below. These include cells A5-A13 through D5 through D13.

Adding Text to Your Worksheet: Click in cell E1 and type in “Test your knowledge of multiplication tables 8 & 9. Type in your answers to”

Select the Enter Key and type “the corresponding cells to reveal a secret picture.”

Cells

Format your cells left aligned and vertically centered.

Left and Center Aligned

Add Conditional Formatting to the Picture Squares: now you will apply conditional formatting to the picture squares. Click in Cell A1 and with the Home tab selected click Conditional Formatting > Highlight Cell Rules > Equal To: (spanish: Formato condicional > Resaltar reglas de celdas > Es igual a)

At the Equal to dialog box type in the correct answer for cell A1 then Click Custom Format:

At the Format Cells dialog box select the Fill tab and select No Color. Then click OK to apply the conditional formatting to the cell A1.

Continue adding conditional formatting to the remainder of the picture cells.

Lock the Worksheet and Unlock Cells: by default all cells are locked so you need to select the cells that contain your picture and unlock them by clicking the Locked box to unlock it. Select the picture cells and with the Home tab selected select the arrow at the bottom corner of the font section. Then click on the Protection tab on the Format Cells dialog box. Click in the Locked section to remove the check. Click OK to apply this formatting.

Protecting Your Worksheet: once you have unlocked the picture cells you will need to protect the worksheet so no one can edit any of the data you have entered / Go to review tab.

At the protect sheet dialog box you only want Select unlock cells box to be checked.

Check your worksheet by playing the game. You should only be able to click in the picture cells.

Let,s play!

Anuncios

Un comentario

  1. […] 4ºESOen – TICs – Excel spreadsheet activities (I) 4ºESOen – TICs – Excel spreadsheet activities (II) 4ºESOen – TICs – Excel spreadsheet activities (III) 4ºESOen – TICs – Excel spreadsheet activities (IV) 4ºESOen – TICs – Excel spreadsheet activities (V) 4ºESOen – TICs – Excel spreadsheet activities (VI) 4ºESOen – TICs – Excel spreadsheet activities (VII) 4ºESOen – TICs – Excel spreadsheet activities – Creating an interactive game […]

    Me gusta

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s