CIS 1020
Steven Lefevor
Microsoft Word
Stp / Instructions / Max. Points / Obtained Points1 / Start Word. Download and open the file named Exploring_w01_Grader_IR.docx. / 0 / 0
2 / Move the insertion point to the beginning of the heading The Income Statement and insert a page break. / 10 / 10
3 / Insert a page number at the bottom of the page using the Plain Number 3 style. / 10.0 / 10.0
4 / Add a cover page to the document that uses the Pinstripes style. Enter What Are Financial Statements? as the document title, and remove the subtitle content control. Select 4/24/2012 as the date. Enter BUS 100 as the company name. Enter Jay Hosey as the author name. / 10.0 / 7.0
5 / Format the page numbers in the document to begin numbering at 2. / 5 / 5
6 / Change the top and bottom margins to 1 inch. / 10.0 / 10.0
7 / Move the insertion point to the beginning of the heading Examples and insert a Next Page section break. / 10 / 0
8 / Change the orientation of the section containing the examples (Section 2) to Landscape. / 10 / 0
9 / Move the insertion point to the beginning of the heading The Income Statement. Create a header that displays BUS 100 for Section 1. / 10 / 10
10 / Create a custom watermark that displays First Draft and uses all other default settings for a text watermark. / 10.0 / 5.0
11 / Move the insertion point to the beginning of the document. Using the Spelling and Grammar checker, accept the suggested correction for the contextual spelling error of there. Correct the spelling errors for the words proft and negtive by selecting the first suggested correction. Ignore all other spelling and grammar suggestions. / 10.0 / 7.0
12 / Modify the document properties to include BUS 100 in the Comments field. Close the Document Properties panel. / 5 / 5
13 / Save the document. Run the Document Inspector. Review the inspector results and close the Document Inspector dialog box. Run the Compatibility Checker. Click OK after you view the incompatible listings. / 0 / 0
14 / Save the document. Close the document and then exit Word. Submit the document as directed. / 0 / 0
Total Score / 100.0 / 69.0
EXCELL
Step / Instructions / Max. Points / Obtained Points1 / Start Excel. Open the downloaded Excel workbook named Exploring_e03_Grader_IR.xlsx. / 0 / 0
2 / Select cells A4:E10. Insert a 2-D Clustered Colum chart based on the selected data. / 10.00 / 10.00
3 / Move the chart so that its top left corner is in the upper left corner of cell A13. Change the width of the chart to 6" and the height to 4". / 7.0 / 7.0
4 / Select the nonadjacent ranges A4:A10 and F4:F10. Insert a 2-D Pie chart based on the selected data. / 10.0 / 10.0
5 / Move the pie chart to a new worksheet named Pie Chart. Apply the Chart Style 26 and the Chart Layout 6 to the pie chart. / 10.0 / 10.0
6 / Edit the data in the pie chart so that it includes the ranges A4:A10 and D4:D10 (ticket sales for November only). Change the chart type to Pie in 3-D. / 10.0 / 6.0
7 / Set the Homecoming Dinner-Dance data point explosion to 50%. Format the data labels to show values (in addition to the existing percentages) but not leader lines. / 9.00 / 0.0
8 / Modify the chart title of the pie chart to be November Ticket Sales. / 3 / 3
9 / On Sheet 1, add the title Event Tickets by Month above the chart. Insert data labels at the outside end of the November data points. / 9.0 / 4.0
10 / In the 2-D Column chart, add a rotated primary vertical axis title as Tickets Sold. Change the fill color of the November data series to Light Blue (under Standard Colors). / 10.0 / 10.0
11 / Add a linear trendline to the November data series. / 6 / 6
12 / Insert column sparklines in cells G5:G11. Include the data range B5:E11 (September through December data) in the charts. Show the high point in each of the sparklines. Set the marker color of each high point to Green (under Standard Colors). / 10.00 / 9.50
13 / Enter Trends in cell G4. / 3 / 3
14 / Prepare Sheet1 for printing by changing the orientation to Landscape. Ensure that the worksheets are correctly named and placed in the following order in the workbook: Pie Chart; Sheet1. / 3 / 3
15 / Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. / 0 / 0
Total Score / 100.00 / 81.50
Power Point
Step / Instructions / Max. Points / Obtained Points1 / Start PowerPoint. Download and open the presentation named Exploring_p03_Grader_IR.pptx. / 0 / 0
2 / On the first slide, between the two pictures, insert a right-facing Block Arrow (default style) that is 0.5 inches high and 2.5 inches wide. Position it so that the left border aligns at the 1.5-inch mark to the left of 0 on the horizontal ruler and the top border aligns at the 1-inch mark under 0 on the vertical ruler. / 10.0 / 0.0
3 / Apply the Preset Style 4 Shape Effect to the arrow on Slide 1. / 4 / 0
4 / On Slide 2, insert an Elbow Arrow Connector starting at the bottom-center connection point of the Build Elements shape and ending at the top-center connection point of the Develop Strategies shape. / 4.0 / 4.0
5 / On the same slide, align the top three shapes by the top. Align the lower three shapes by the bottom. Distribute the lower three shapes horizontally. / 9.0 / 9.0
6 / On the same slide, format all of the connector arrows with the Moderate Line - Accent 5 shape style. Format all of the rounded rectangles with the Moderate Effect - Brown, Accent 4 shape style. / 6.0 / 4.8
7 / On Slide 2, group all of the shapes, including the connector arrows, except for the Title Shape. / 4 / 0
8 / On Slide 3, insert a Gradient Fill - Brown, Accent 4, Reflection WordArt containing the text DID YOU KNOW? using the default size. Position the WordArt so that the top-left corner aligns with the -3.25-inch mark (to the left of 0) on the horizontal ruler and the 1.5-inch mark (above 0) on the vertical ruler. Apply the Colored Fill - Tan, Accent 5 shape style to the shape containing the WordArt. / 10.0 / 6.0
9 / On Slide 4, insert a text box beginning at the 2.25-inch mark to the left of 0 on the horizontal ruler and the 2-inch mark above 0 on the vertical ruler. Add the text Which Are Measurable? to the text box and change the font size to 30 pt. / 8.0 / 2.0
10 / Change the color tone of the X graphic on Slide 4 to Temperature: 4700 K and change the color tone of the check mark graphic to Temperature 11200 K. / 6.0 / 6.0
11 / On Slide 4, adjust the order of the elements on the slide so that the two graphical objects appear behind all of the other objects on the slide. / 6.0 / 6.0
12 / On Slide 5, insert a Titled Matrix SmartArt diagram in the content placeholder. Add the word Motivate to the center shape, the word Engage to the top-left shape, the word Involve to the top-right shape, the word Stimulate to the bottom-left shape, and the word Compel to the bottom-right shape. / 14.0 / 14.0
13 / Change the SmartArt color theme to Colorful Range - Accent Colors 3 to 4 (third theme under colorful) and change the style of the SmartArt to Subtle Effect. / 8.0 / 8.0
14 / On Slide 8, convert the text to a Grouped List SmartArt diagram and apply the Subtle Effect style to the diagram. / 11.0 / 0.0
15 / Save the presentation. Close the presentation and then exit PowerPoint. Submit the presentation as directed. / 0 / 0
Total Score / 100.0 / 59.8