Name:______
CSCI 100 Summer 2006 Word & Excel Exam
Directions: Complete the following Word and Excel projects. You are to do all the work yourself without asking your neighbor any questions. You may use the Office help system if you need to. Read through the entire test first in order to plan how much time to spend on each part of it to maximize your score..
1. Create the document on the following page. Use the WordArt style in the first row, third column, and use 36 point bolded Garamond font. The WordArt should span the page and be approximately one inch tall. Add a 6 point box border to the document using the third from the bottom border style. Add a 24 point star to the bottom right with the words Seal of Approval inside, in 11 point Bauhaus 93. Add the text shown in 24 point Brush Script MT font, and include your name (instead of mine) in 36 point Old English MT font. At the bottom left, add clip art for the term human. In 16 point Bradley Hand ITC, add the signature and a line in a text box in the middle of the bottom of the page. Print your certificate.
This certificate bears witness and attests to the fact that the individual named herein,
Donald L. Allison, Jr.
has been tested and determined to be an actual human being, with all the foibles, eccentricities, and other mannerisms thereunto appertaining. In verification of this fact, this document has been signed and sealed by the appropriate authorities.
Name:______
2. From the site http://www.eia.doe.gov/cneaf/electricity/epm/tablees1a.html, copy the Net Generation part of the Total Electric Power Industry Summary Statistics Table ES1.a. and paste it into a spreadsheet. Compute the totals (all sectors) generated by 1) coal, 2) oil (petroleum and gas), 3) nuclear, and 4) all other sources. Generate a 3D pie chart with these four values. Title the chart Energy Sources, and show the legend at the bottom of the chart. Label each slice with it’s percentage of the whole, and use leader lines. Save the chart as a separate sheet named Energy Generation. Change the chart title to be Britannic Bold font, 24 point. Rotate the pie so that the coal slice is at the top of the chart, and pull it out from the rest of the pie. Add your name in a header on the upper left of the page, and print the chart.
3. From the site http://www.srh.noaa.gov/tsa/climate/clisummer.html, collect the record high and low temperatures for Tulsa, Fort Smith, McAlester, and Fayetteville for the months of June, July, and August, and enter the data in a new spreadsheet. Your table should have a title, SUMMER TEMPERATURE RECORDS, CENTRAL US in 20 point Copperplate Gothic Light, centered in cells A1:F1. The label MONTH should be bolded 14 point Arial and should be centered in D2:F2, while the label CITY, also in bolded 14 point Arial, should be rotated 90 degrees and span cells A4:A11. Your table should look like this, only it should include the data:
SUMMER TEMPERATURE RECORDS, CENTRAL USMONTH
June / July / August
CITY / Tulsa / Record High
Record Low
Fort Smith / Record High
Record Low
McAlester / Record High
Record Low
Fayetteville / Record High
Record Low
Using the data, create a clustered column chart, showing temperature along the vertical axis, and city along the horizontal axis, grouping the record highs and lows for each of the three months. Title the chart, Summer Temperature Records, Central US. Label the vertical axis Degrees Farenheit and the horizontal axis City. Show the legend at the top of the chart. Embed the chart in the spreadsheet, spanning cells A13:L40. Format each of the chart bars using a two color gradient fill effect from center, going from a white center to a dark outer edge. The first bar should be dark blue and white, the second dark red and white, and the third dark green and white. Print the worksheet in landscape mode, adjusting it to fit on a single page, with your name as a header in the upper right corner.
4. Staple your word document and two worksheet pages to the back of this test and turn the entire package in to me.