Project No. One: Microsoft Word
Project No. Two: Microsoft Publisher
Project No. Three: Microsoft Excel Spreadsheet
World's Water Supply Survey
1. Open Microsoft
Excel
2. In cell A1, type World's Water Supply. Press Enter. 3. In cell A2 type: Kinds of Water. Press Enter. 4. Click in cell B2 and type: Percent. Press Enter. 5. In column A starting with cell A4 type in the kinds of water surveyed. Press Enter after each kind of water to move to the next cell. 6. Change the font colors of each kind of water listed. Do this by clicking on the word then the drop down arrow next to the font color icon. 7. In column B, enter the percentage number of each kind of water surveyed. 8. Skip 1 entire row and in column A under the last color, type Total. 9. In column B, next to Total, cell B , use the AUTOSUM button to total the percentage or water. Press Enter. 10. Spell Check you work. 11. Before you make your chart, save your work – File- Save As – Drop Down Menu – Student on EKELEM – Teacher’s Folder – Press Enter – Student’s Folder – Press Enter – File Name – Skittles Analysis – Initials – Grade and Letter – Click Save. |
12. Highlight the cells that contain only the water
names and the percentage number. DO
NOT highlight the Title or the Total.
13. On the Insert Menu, select Chart, then select bar graph, as a chart type. Press and hold to view sample. This is to ensure that every student has highlighted the correct information. Click Next. 14. Click Next again. 15. Click in the Titles tab, enter World's Water Supply in the Chart Title box. 16. Click on the Legend Tab, in the show legend option click where you want the legend to appear on your chart. 17. Click on the Data Labels tab and select the Category Value. Click Next. 18. Click on the As New Sheet Radio button so that the chart will appear on a page by itself and not on the spreadsheet. Click finish. 19. Zoom to 75%. 20. Notice that the colors are the same on your chart. 21. Click the fill color can drop down arrow and select the correct color. Repeat with each section so you have different colors for each kind of water. Background 22. Zoom to 50% 23. Click on the white area or background around the bar graph so handles appear on the background. 24. Click Fill Color Can drop down arrow. Click Fill Effect. Choose the Gradient Tab. Choose Preset Colors. Select a color combination you like. Click OK. Play around and try different effects. Name 25. Click on the Word Art on the Drawing Toolbar 26. Select a Word Art you would like. Click OK. 27. Type in your name. Click OK. 28. Reposition your name on an empty place on your chart and reduce the size. |
Project No. Four: Microsoft Power Point
Explorer's Powerpoint
|
|