Prior to beginning this tutorial, it is assumed that students have researched their chosen object and saved any relevant information and images to file.
View the sample worksheet in the box to the right before you get started.
Creating a heading
1.
Open Excel.
2.
On the Insert menu, click Picture, and then do one of the following:
•
To use an image that you have previously saved, click From File.
•
To use an image from the provided pieces of clip art, click Clip Art.
3.
If you select Clip Art you may either enter in the name of a specific piece of Clip Art in the Search for area, or leave it blank. Leaving it blank and pressing Go will pull up all the Clip Art in all of the Albums. You may refine this search using the drop down menus in the Clip Art task pane.
4.
Click to select the image that you would like to use, and then click Insert if you chose From File, otherwise, just click on the image you want and it will appear in the spreadsheet.
5.
Adjust the size of your image to suit by dragging the resize handles accordingly.
6.
Drag your image so that the top horizontal edge aligns with row 14, and then center its position.
7.
To create a space for a heading, highlight to select cells B3 to G6. This will create a rectangle four cells high and six cells wide.
8.
On the Format menu, click Cells.
9.
Click the Alignment tab, and then select the Wrap text and Merge cells check boxes.
10.
Click OK. The selected cells will now be merged, and any text typed in this field will automatically wrap around to fit in the defined space.
11.
Double-click the merged cells, type the heading Can you label the parts of a flower? for your worksheet, and adjust the font and font size to suit your preferences.
A student's peers will label the diagram that the student has created by using nouns located in a word bank.
1.
To create a word bank of nouns, highlight to select cells B8 to G9, which will create a rectangle two cells high and six cells wide.
2.
On the Format menu, click Cells.
3.
Click the Alignment tab, and then select the Merge cells check box.
4.
Click OK.
5.
Double-click the merged cells, type the instructions to your worksheet, Match the nouns in the word bank to the labels on the picture and adjust the font and font size to suit your preferences.
6.
On row 11, format the cells directly below the instructions in the same manner as above, type the nouns that will be needed to label your object: stem, petal, stamen, leaves, and pistil.
7.
To create a box around the instructions and word bank, highlight to select the cells containing the instructions and the word bank.
8.
On the Format menu, click Cells, and then click the Border tab.
9.
In the Style list, click to select a line style, and then click Outline.
10.
Click OK.
11.
On the File menu, click Save, and then save your document to the appropriate folder on the school server.
Your document may look similar to the following example:
You are going to draw arrows to specific parts of your image and create label fields where the nouns from the word bank can be inserted.
1.
To activate the drawing toolbar, on the View menu, click Toolbars, and then click the Drawing toolbar. The Drawing toolbar now appears on the screen.
2.
On the Drawing toolbar, click Arrow.
3.
To draw an arrow on your page to point out a specific feature of your image, point to the cell that will contain the label, and then drag the pointer to the feature on the image.
4.
To create a blank label in which peers can type the appropriate noun that accompanies each arrow, highlight to select the individual cell that correlates to an arrow.
5.
On Format menu, click Cells, and then click the Border tab.
6.
In the Style list, click to select a line style, click Outline, and then click OK.
You are going to add a formula to your worksheet that will automatically indicate if the typed noun is correct or incorrect.
1.
Double-click the cell below the blank label that you have created.
2.
On the Standard toolbar, click Function.
3.
In the Select a function list, click IF, and then click OK.
4.
In the Logical_test box, type the reference of the cell where the answer is to be written, an equal sign, and, in quotation marks, the noun that belongs in this cell.
In the following example, B15="Leaf" means that a user needs to type the word Leaf in cell H20 for the answer to be correct, and any other answer will be marked incorrect.
5.
In the Value_if_true box, type the answer, in quotation marks, that you would like displayed if the correct answer is given.
The example uses the word Correct.
6.
In the Value_if_false box, type the answer, in quotation marks, that you would like displayed if an incorrect answer is given.
The example uses the word Incorrect.
7.
Click OK.
The formula has now been inserted.
8.
Insert IF formulas for all other labels by repeating steps 1-7.
Note You will notice that if there is nothing typed in the cell, incorrect will be displayed. You can change the formula so that the cell will be blank. The formula that you need to enter is an IF statement within an IF statement.
9.
Click to select the cell for which you want to change the formula.
10.
On the Standard toolbar, in the Insert Function box, type IF(B15="Leaf","Correct",IF(H20="","","Incorrect")) and then press ENTER.
The empty quotation marks stand for a blank cell. Thus, the formula states that:
•
If Leaf is typed in cell B15, Correct will be displayed.
•
If anything other than Leaf is typed in cell B15, Incorrect is displayed.
Because your worksheet is designed to be interactive, you need to protect the formula cells so that they cannot be accidentally removed and so that students can not see the answers in the formulas.
1.
While pressing CTRL, highlight to select all cells in your worksheet except the blank labeling cells because you want a user to be able to add text to these cells. Note Remember, while you are pressing CTRL, you can click and individually choose the cells that you would to select.
2.
On the Format menu, click Cells.
3.
Click the Protection tab, and then select the Locked and Hidden check boxes. This will protect the selected cells by not allowing anyone to type in them and by hiding the formula so that the user can not see the answer.
4.
On the Tools menu, click Protection, and then click Protect Sheet
5.
Select the Protect worksheet and contents of locked cells check box, and then click OK. In the Allow all users of this worksheet to list, the default setting will automatically select the necessary check boxes.
6.
On the File menu, click Save, and then save your document to the appropriate folder on the school server.
This tutorial is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY.
Companies, names, and/or data used in screens and sample output are fictitious, unless otherwise noted.
Microsoft and Encarta are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.
