Microsoft Excel– Interactive Crossword Puzzle



Follow the instructions to make the sample interactive crossword puzzle in Microsoft Excel.-57150010922000TASK 11. Open a new blank Microsoft Excel workbook and save it as Crossword Puzzle Assignment.Type the letters in the corresponding cells on Worksheet 1, make sure you put them in the EXACT same locations or this initial crossword puzzle will NOT work.2. Click on the letter A in gray (column heading), leave your mouse button clicked and drag over to column heading F. 3. Put your cursor on the seam between any two column headings that are highlighted, click and drag until Excel informs you that you have a column width of 7.00 (54 pixels). Notice all column headings change to your selected size.4. Click on the number 1 in gray (row heading), leave your mouse button clicked and drag down to row 6. 5. Put your cursor on the seam between any two row headings that are highlighted, click and drag until Excel informs you that you have a column height of 37.50 (50 pixels). Notice all row headings change to your selected size.center483235006. Click on the letter ‘e’ in cell B2, leave your mouse button clicked and drag to the letter ‘a’ in cell E5. All letters should now be highlighted. 7. From the Format menu select Format Cells, then select the Alignment tab 8. Select Center alignment for both the Horizontal and Vertical drop down menus. 9. Click on the Font tab, and select 24 in the size box. 10. Click on the Border tab. Select Outline and then also select Inside. Click OK. 11. The next step will be to color all of the squares without letters in them.1143001143000012. Click in cell A1 (on your Excel worksheet, not on the picture above), hold down the CTRL key and click until you have clicked on all squares that do not have letters in them, immediately surrounding the letters. If you click and drag you must release the mouse button at the end of a line (but do not release the CTRl key). Now click and drag another line of cells, until all are highlighted. 494030042862500(Note: The last cell selected will be outlined in black, but not filled with the highlight color. It is selected) 13. Release the CTRL key (but do not click on the worksheet), and click on the Fill Color button on the Formatting toolbar. Select a shade of yellow.Adding Comments to your Spreadsheet14. Next you will add comments at the starting letter of each word, to serve as a clue to the word.45720001143000015. First, the letter e. This one will require a clue for across and a clue for down. Put them in the same comment with an empty line between the two clues. 16. Right-click on the letter e (in cell B2) and select Insert Comment. Highlight anything that is already in the comment box and press delete. Type the clues that are at the right of this set of instructions. 17. Continue until you have clues written for each word. You will have to make up the clues for YMCA and Sofa.Conditional Formatting18. This step is what makes the puzzle interactive. If someone types the wrong letter in a box, the letter will turn red when the student hits the Enter key. This process is called setting conditional formatting.19. Click on the letter e in cell B2. 20. From the Home menu select Conditional Formatting. 21. Set Condition 1 as Cell value is …equal to…e. Select the Format button, Fill tab and select a shade of blue for this condition. Click OK. 22. Set Condition 2 as Cell value is…not equal to…e.Select the Format button, Fill tab and select a shade of pink for this condition.Click OK.23. With the letter e still selected double click on the Format Painter and then select each of the other letters in your crossword puzzle one at a time, by clicking on each once. Each letter should turn pink.24. Use the Manage Rule option under Conditional Formatting to adjust the criteria for each cell to reflect the correct letter that is in the cell. Once you have managed your cells properly each should turn blue.25. Delete the letters. The Comment and formatting instructions will still be in each cell. Rename Worksheet 1 so that the tab now reads, Practice Puzzle.TASK 226. Now create your own interactive crossword puzzle on Worksheet 2. Name worksheet 2 so that the tab now reads, My Puzzle. Create your puzzle with 6 words that are related to Microsoft Excel.Insert a comment that will serve as your clue for each word in the cell with the first letter of the word. Conditionally format your cells so that they turn one colour if the correct letter is entered and another if the incorrect answer is entered. Format all of the cells around the puzzle so they are filled in black. Microsoft ExcelInteractive Crossword Puzzle Skill InventoryAnswer the following questions on this sheet.1. How can you change the height/width of a number of columns at the same time? 2. What can you do with conditional formatting?3. What is a template used for?4. What does the format painter brush do?5. What does the option insert comment do?Microsoft ExcelInteractive Crossword Puzzle RubricCategoryLevel 1Level 2Level 3Level 4Thinking/InquiryYour own crossword puzzle.Little detail or effort in clues.Adequate detail and effort in clues.Good detail and effort in clues.Crossword puzzle clues are detailed and well thought-out.ApplicationUse of Microsoft ExcelStudent demonstrates poor use of Microsoft Excel.Student demonstrates adequate use of Microsoft Excel.Student demonstrates good use of Microsoft Excel.Student demonstrates excellent use of Microsoft municationSpelling/GrammarTwo spelling mistakes in clues and skills inventory.One spelling mistake in clues and skills inventory.Minor grammar errors in clues and skills inventory.Excellent spelling and grammar in clues and skills inventory.Knowledge/UnderstandingComponents SubmittedSample crossword and skills inventory are not submitted.Sample crossword or skills inventory is not submitted.All components of project are submitted.All components of project are submitted, with excellent detail, shading, graphic included in crossword puzzle. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download