مشروع الورد
| Step | Instructions | Point Value |
|---|---|---|
| 1 | Open the Word document Student_Word_1G_Sports_Photography_AS.docx downloaded with this project. | 0 |
| 2 | Type Sports and Team Photography and then press ENTER. Type Light Magic Studios is a full service photography studio. Press SPACEBAR after the period. Insert the text from the file downloaded with this project, Word_1G_Teams_AS.docx. | 4 |
| 3 | Change the Line Spacing for the entire document to 1.5 and the spacing After to 6 pt. Apply a First Line indent of 0.5” to each of the four paragraphs that begin Light Magic Studios, Some of the sports, Team up with, and Videos are available. | 6 |
| 4 | Change the title font size to 50 and the title Line Spacing to 1.0. Center the title. From the Text Effects and Typography gallery, in the first row, apply the second effect to the title. | 10 |
| 5 | At the beginning of the paragraph below the title, insert the picture downloaded with your grader files—Word_1G_Swim_AS.jpg. Change the picture Height to 1.75, and the Layout Options to Square. Format the picture with a 10 Point Soft Edges effect. | 8 |
| 6 | Use the Position command to display the Layout dialog box. Change the picture position so that the Horizontal Alignment is Right relative to the Margin. Change the Vertical Alignment to Top relative to the Line. | 4 |
| 7 | Select the three paragraphs beginning with Photo CD and ending with Photo t-shirts, and then apply checkmark bullets. Mac users, apply any bullet style. | 5 |
| 8 | Locate the paragraph that begins Team up with Light Magic and then click after the colon. Press ENTER and remove the first line indent. Type a numbered list using the format 1.2.3. with the following three numbered items: Earn 5% off of every order Individual photos on CD Free team portrait included | 6 |
| 9 | With the insertion point located at the end of the numbered list, insert a Basic Chevron Process SmartArt. In the first shape, type Selection. In the second shape, type Service and in the third shape type Quality. Select the outside border of the SmartArt. Change the SmartArt color to Colorful Range – Accent Colors 5 to 6, and then apply the 3-D Cartoon style. | 9 |
| 10 | Change the Height of the SmartArt to 1.75 and the Width to 6.5. Change the layout options to Square, and then change the position of the SmartArt so that the Horizontal Alignment is Centered relative to the Page and the Vertical Alignment is set to Bottom relative to the Margin. | 8 |
| 11 | Select the days and times at the end of the document and then set a Right tab with dot leaders at 6”. | 4 |
| 12 | Below the days and times, insert a Rounded Rectangle shape. Change the Shape Height to 1.5 and the Shape Width to 6.5. Display the Shape Styles gallery and in the second row, apply the sixth style. | 10 |
| 13 | Use the Position command to display the Layout dialog box, and then change the position so that both the Horizontal and Vertical Alignment of the shape are Centered relative to the Margin. | 4 |
| 14 | In the rectangle, type Light Magic Studios and then press ENTER. Type Capturing Your Memories! and then change the font size of all the text in the shape to 24. | 3 |
| 15 | Move to the top of the document and insert a Text Box above the title. Change the Height of the text box to 0.5 and the width to 3.6. Type Light Magic Studios and then change the font size to 22. Center the text. | 7 |
| 16 | Use the Position command to display the Layout dialog box, and then position the text box so that the Horizontal Alignment is Centered relative to the Page and the Vertical Absolute position is 0.5 below the Page. | 2 |
| 17 | With the text box selected, display the Shape Fill color palette, and then in the ninth column, click the second color. Change the Shape Outline to the same color. | 4 |
| 18 | Apply a Box setting page border and choose the first style. Display the Color palette, and in the ninth column, apply the first color. Insert the File Name field in the footer. | 6 |
| 19 | Save and close the file, and then submit for grading. | 0 |
| Step | Instructions | Point Value |
|---|---|---|
| 1 | Start PowerPoint. Download and open the file named aio_ch18_grader_18g_hw.pptx . | 0 |
| 2 | Apply the Integral theme to the presentation. | 4 |
| 3 | Type Juneau Highlights as the title of this presentation and type Kodiak West Travel as the subtitle. | 6 |
| 4 | Insert a New Slide using the Content with Caption layout. Type The View from Above in the title placeholder. | 10 |
| 5 | In the content placeholder on the right side of the slide, from your downloaded Grader files, insert the picture p18G_Aerial_View.jpg. Format the picture with the Beveled Matte, White picture style. | 10 |
| 6 | In the text placeholder on the left, type the following paragraph, including the period at the end of the paragraph: View a glacial ice field from above by plane or helicopter. If you are more adventurous, try glacier trekking in Juneau where you can land on a glacier and climb an ice wall. After you type the text, review it carefully to be sure that you have not made any spelling or spacing errors. | 10 |
| 7 | Insert a New Slide using the Two Content layout. Type On Land and Sea in the title placeholder. | 10 |
| 8 | In the content placeholder on the left, type the following first- and second-level bullets, increasing and decreasing the list level as shown below. In this presentation theme, the first-level bullet points do not include a bullet symbol. On the water Whale watching Kayaking Mount Roberts tramway Spectacular views of Juneau Recreational hiking trails | 6 |
| 9 | In the content placeholder on the right, from your downloaded Grader files, insert p18G_Whale.jpg. Apply the Rotated, White picture style. | 8 |
| 10 | Insert a new slide with the Picture with Caption layout. In the title placeholder, type Mendenhall Glacier and then in the picture placeholder, from your downloaded Grader files, insert the picture p18G_Falls.jpg. | 10 |
| 11 | In the text placeholder, type the following sentence, including the period: Walk to Mendenhall Glacier from the Visitor Center to get a close-up view of Nugget Falls. | 6 |
| 12 | In the Notes pane on Slide 4, type the following sentence including the period: Mendenhall Glacier is the most famous glacier in Juneau and in some years is visited by over 400,000 people. | 10 |
| 13 | Insert a Header & Footer on all Notes and Handouts. Include the Date and time updated automatically, the Page number, and a Footer with the text Juneau Presentation. | 8 |
| 14 | Display the Document Properties. As the Tags type Juneau | 2 |
| 15 | Save and close the document. Exit PowerPoint. Submit the file as directed. | 0 |
| Step | Instructions | Point Value |
|---|---|---|
| 1 | Start Excel. Download and open the file named aio16_xl_ch15_grader_15e_hw.xlsx. | 0 |
| 2 | Change the worksheet theme to Wisp. | 4 |
| 3 | Use the fill handle to enter the months May and June in the range C3:D3. | 6 |
| 4 | Merge & Center the title across A1:F1, and then apply the Title cell style. Merge & Center the subtitle across A2:F2, and then apply the Heading 1 style. Center the column titles in the range B3:F3. | 10 |
| 5 | Widen column A to 180 pixels, and then widen columns B:F to 115 pixels. Note, Mac users will need to set column A to a width of 21.88 and columns B:F to a width of 13.83. In the range B7:D7, enter the following values: 137727.85, 121691.64, and 128964.64. | 10 |
| 6 | In cell B8, use the AutoSum button to sum the April sales. Fill the formula across to cells C8:D8. In cell E4, use the AutoSum button to sum the Basic Home Gym sales. Fill the formula down to cells E4:E8. | 10 |
| 7 | Apply the Heading 4 cell style to the row titles and column titles, and then apply the Total cell style to the totals in the range B8:E8. | 6 |
| 8 | Apply the Accounting Number Format to the first row of sales figures and to the total row. Apply the Comma Style to the remaining sales figures. | 6 |
| 9 | Select the range that represents the sales figures for the three months, including the month names and the product names—do not include any totals in the range. With this data selected, use the Recommended Charts command to insert a Clustered Column chart with the month names displayed on the category axis and the product names displayed in the legend. | 10 |
| 10 | Move the chart so that its upper left corner is positioned in the center of cell A10. Then drag the center right sizing handle to the right until the right edge of the chart aligns with the right edge of column E. | 6 |
| 11 | Apply Chart Style 6 and Color 2 under Colorful. Change the Chart Title to Second Quarter Home Gym Sales. | 10 |
| 12 | In the range F4:F7, insert Line sparklines that compare the monthly data. Do not include the totals. Show the sparkline Markers and apply Sparkline Style Accent 2, Darker 50%—in the first row, the second style. | 10 |
| 13 | Center the worksheet Horizontally on the page, and then insert a Footer with the File Name in the left section. | 6 |
| 14 | Change the Orientation to Landscape. | 6 |
| 15 | Save and close the document. Exit Excel. Submit the file as directed. | 0 |