SAM Projects 2010 - Weebly



Computer Technology2010 Capstone Projects (Final Project)This will count for 20% of your grade for this quarter, so be sure to do your best work.You will have five chances on each projectYour 20% final grade will be worth 400 points, broken down as follows:Word: 100 pointsExcel: 200 pointsPowerPoint: 100 pointsPart 1: Word 2010 (100 points)InstructionsLog on to SAM2010. Click on SAM AssignmentsClick on the WORD 2010 CAPSTONE PROJECT assignment hyperlinkIn the Starting Documents Area, click on the hyperlink with the file name (your name is part of this)Click on the File Tab, then choose Save As. Browse to your Word Assignments folder.Save the file as CS_Word2010_1a_FirstLastName_2Click in the blank line above the paragraph that begins “How do people pay back the loans?” and insert the following question:What role does SWM play?Press the Enter key and then insert the following answer paragraph (not bolded):SWM helps entrepreneurs in developing countries form microloan groups. Then it links them to sources of funding, who are usually donors from more prosperous countries.Select the first question on the page (“What is a microloan?”) and then bold the text.Bold the other six questions in the document.Change the paragraph line spacing of the first paragraph (which begins “Small World Microloans (SWM) is taking on global poverty one small step at a time…”) to single spacing. (Hint: To change spacing, click on the Spacing command in the Paragraph group of the Home Tab)Apply the Heading 1 style to the title of the document (“Small World Microloans”).Convert the hyperlink swm. in the address line to regular text. (Hint: right mouse click and remove the hyperlink)Italicize the address line (“SWM ? 2130 18th Street N.W. ? Washington, DC 20005 ? swm.”)Apply a bottom border to the address line paragraph. In the blank paragraph above the document title, insert a Clip Art of your choice, such as an image of money or a globe.Resize this graphic so it is 2 inches high.Insert a header using the Blank style Insert Frequently Asked Questions as the header text. On the right side of the header, insert a page number using the Accent Bar 2 style. (Hint: Press the Tab key twice after entering the header text, and then insert a page number using Current Position.)Move the “What role does SWM play?” question and its answer paragraph “SWM helps entrepreneurs in developing countries…” so they become the second question and answer in the document.Below the “What types of businesses are funded?” question, change the “Market stands selling home-grown food. Clothing shops or booths. …” answer paragraph to a bulleted list of seven items. (Hint: Each item in the bulleted list ends with a period.) In the blank line before the quotation paragraph at the end of the document (which begins “If you give a person a fish…”), insert a table with two columns and five rows.Enter the following text in the table:TABLE 1-1 RegionAmountEastern Europe$424,050.50Southeast Asia$390,270.00Latin America$309,750.75Middle East$285,025.00Format the table with the Medium Shading 1 – Accent 3 table style (fourth column, fourth row). Center the quotation in the last line of the document (which begins “If you give a person a fish…”). Press the Enter key after the first sentence so this quotation appears on two lines. Change the font of the entire quotation to 12-point, italic, Bookman Old Style. Find all instances of the words “partner” and replace them with “donor”. Find all instances of the word “partners” and change them to “donors”.Check the spelling and grammar in the document, making corrections as appropriate. Your final FAQ document should look similar to Figures 1-1 and 1-2. (Note: The Clip Art in your FAQ document may look different than the one shown in Figure 1-1.)Save your changes, close the document and exit Word. Follow the directions on the SAM Web site to submit your completed project.FIGURE 1-1 FIGURE 1-2 Part 2: EXCEL 2010 (200 points)InstructionsLog on to SAM2010. Click on SAM AssignmentsClick on the EXCEL 2010 CAPSTONE PROJECT assignment hyperlinkIn the Starting Documents Area, click on the hyperlink with the file name (your name is part of this)Click on the File Tab, then choose Save As. Browse to your Excel Assignments folder.Save the file as CS_Excel2010_1a_FirstLastName_2Switch to Sheet1. In cell K1, enter 0.96 as the repayment rate. In cell K2, enter 0.68 as the percentage of women entrepreneurs.Make the following formatting changes to make the worksheet attractive and easy to read.TABLE 1-1 Formatting Changes on Sheet1CellsFormatting ChangesA1:A2Title cell styleCalibri font16-point font sizeC203/14/01 date formatH1:J1H2:J2Merge cellsItalicsRight alignmentK1:K2Percent Style formatNo decimal placesB3:D3E3:G3H3:J3K3:M3Merge and centerA3:M3Accent1 cell styleA4:M460% - Accent1 cell styleCenter alignmentIn cell B7, enter a formula that calculates the number of loans made in Ghana per donor. (Hint: =B5/ B6.) Copy the formula in cell B7 to the range C7:M7 to calculate the number of loans per donor in the other countries.In cell B13, enter a formula using the SUM function to add the range B8:B12Copy the formula in cell B13 to the range C13:M13.In cell B14, enter a formula that calculates the average amount of a loan to a Ghanaian entrepreneur. (Hint: =B13/B5.) Copy the formula in cell B14 to the range C14:M14.In cell B15, enter a formula using the AVERAGE function to find the average of B8:B12Copy the formula in cell B15 to the range C15:M15.In cell B16, enter a formula using the MAX function to find the max of B8:B12Copy the formula in cell B16 to the range C16:M16.In cell B17, enter a formula using the MIN function to find the min of B8:B12Copy the formula in cell B17 to the range C17:M17.In cell B18, enter a formula =B12*$K$1. Copy the formula in cell B18 to the range C18:M18.Apply the Number Format Accounting to the ranges B8:M8 and B13:M18. Apply the Style Format Comma to the range B9:M12.Change the font color of the values in the range B13:M13 to Blue, Accent 1. Bold the values.Add a Top and Thick Bottom Border to the range B13:M13.Add a Right Border to the ranges A3:A18, B3:D18, E3:G18, H3:J18, and K3:M18. Select the range B14:M14, Click on Conditional Formatting Data Bars. Select Gradient Fill Blue Data Bars to show the variation in average loan amount. Select the range B15:M15, Click on Conditional Formatting Data Bars using the Gradient Fill Green Data Bars to show the variation in the average amount loaned per year.Make these formatting changes to the following ranges:CellsFormatting ChangesRow 20Height set to 30.00 pointsB20:E20H20:K20Merge and centerFill color set to Blue, Accent1, Lighter 80%Heading 2 cell styleB21:B25H21:H25Accent1 cell styleBoldMerge and centerRotated up 90 degreesC21:C25D21:E21I21:I25J21:K2160% - Accent1 cell styleE22:E25K22:K25Currency format, dollar symbol, no decimal placesIn cell D22, enter a formula to calculate the total number of loans made in Africa. (=SUM(B5:D5)) In cell D23, enter the formula =SUM(E5:G5)In cell D24, enter the formula =SUM(H5:J5)In cell D25, enter the formula =SUM(K5:M5)In cell E22, enter the formula =SUM(B13:D13) In cell E23, enter the formula =SUM(E13:G13)In cell E24, enter the formula =SUM(H13:J13)In cell E25, enter the formula =SUM(K13:M13)In cell J22 enter the formula =D22*$K$2Copy the formula in cell J22 through the range J23:J25.In cell K22 enter the formula =E22*$K$2Copy the formula in cell K22 through the range K23:K25.Apply an Outside Border to the ranges B20:E25 and H20:K25.Increase the width of columns C and I to 12.00 characters.Insert a new row 27 (Hint: Right-click on the “27” at the left of the row and select Insert). Enter the following text in cell A27: *Based on current repayment rate. Format the text as italic.Select the ranges A4:M4 and A13:M13 Insert a 3-D Clustered Column chart. (Hint: click on the Insert tab to access the Charts group)Move the chart to a new sheet named Loan Totals. (Hint: Use the Move Chart button at the far right of the Ribbon, and be sure to choose the “New sheet” option rather than the “Object in” option. You can add the name also on this screen.)Apply Style 34 to the chartClick on the Layout tab and remove the legend. Edit the chart title to be Total amount loaned 2009-2013.Rename Sheet1 to Statistics.Move the Loan Totals chart sheet so that it becomes the last sheet in the workbook.5025390210820Insert a header to the Statistics worksheet that displays the current time in the center of each page. (Hint: Click on the Page Layout button in the bottom right-hand corner of your screen, then you can click in the Header area. Go back to Normal View or click back in the worksheet when you are finished.)Change the orientation of the Statistics worksheet to Landscape. (Hint: Page Layout Tab)Change the margins of the Statistics worksheet to Wide. Check the spelling and grammar in the Statistics worksheet, making corrections as appropriate. Your final worksheets should look similar to Figures 1-1, 1-2, and 1-3. (Note: The time listed in your workbook’s header may be different than the one in the figures.)Save your changes, close the document and exit Excel. Follow the directions on the SAM Web site to submit your completed project.FIGURE 1-1 FIGURE 1-2331470130810Part 3: PowerPoint 2010 (100 points)InstructionsLog on to SAM2010. Click on SAM AssignmentsClick on the POWERPOINT 2010 CAPSTONE PROJECT assignment hyperlinkIn the Starting Documents Area, click on the hyperlink with the file name (your name is part of this)Click on the File Tab, then choose Save As. Browse to your PowerPoint Assignments folder.Save the file as CS_PPT2010_1a_FirstLastName_2In the title placeholder on Slide 1, insert the following title:Small World MicroloansIn the subtitle placeholder, insert the following text:Creating Global Wealth One Step at a TimeApply the Median design theme to the presentation.On Slide 2 (“About Small World Microloans”), insert the following text into the text placeholder as a multi-level bulleted list. (Note: Your bullet styles may be different.)Who we areNonprofit organizationFounded in 2001 Committed to defeating povertyWhat we doReplace donations with microloansConnect donors with entrepreneurs in developing countries Change the layout of Slide 3 (“SWM Principles”) to Title and Content.On Slide 3, add the following text so it becomes the last bulleted item in the list:Balance loans and savings On the same slide, insert a Clip Art image of your choice. Resize the Clip Art image so that it is 3 inches high, and then move the image to the lower-right corner of the slide.On Slide 4 (“SWM Cycle of Success”), insert a Bent Arrow shape into the upper-left part of the diagram. Resize the shape to match the size and scale of existing shapes. (Hint: be sure both the height and width are 1.5”)Format the “Cycle of Success” text below the diagram so that it is 20-point italic. Change the text color to Orange, Accent 2.Insert a new slide at the end of the presentation that uses the Title and Content layout. (Hint: Click on the Layout Option on the Home Tab.)Add the text shown in Figure 1-1 to the new slide. To match Figure 1-1, make the following formatting changes:Center the slide title Change the title’s text color to Orange, Accent 2, Darker 25%Remove the bullets from the address lineChange the font to CalibriCenter all the lines. 247650346075Check the spelling and grammar and correct any errors. Figure 1-2 shows the completed presentation. (Note: In your presentation, the clip art on slide 3 and bullet style on slide 2 may be different than those shown in Figure 1-2.)Save your changes, close the presentation, and exit PowerPoint. Follow the directions on the SAM Web site to submit your completed project.FIGURE 1-2 ................
................

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

Google Online Preview   Download