BIS 221 MENTOR T Wonderful Education--bis221mentor.com

1. BIS 221T Week 2 Apply Wandering Travel Report FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 2 Apply Wandering Travel Report Complete the “8.10 Week 2 Apply: Wandering Travel Report” activity in MyEducator®. Note: You have only one attempt available to complete this assignment. Grades must be transferred manually to eCampus by your instructor. Don’t worry, this might happen after your due date This assignment has a total of 100 points. Test Your Skills exercises are designed to test and solidify what you have learned in the lesson. Make only those changes that are specified in these directions. The Atlas Grader depends on existing text to identify portions of the document for grading. Creating a brochure report for Wandering Travel Paul Wilson is working with you on a report for Wandering Travel on biking tours and biking tips the company plans to send to clients that have requested more information about biking tours. This report will use features you learned in the first two Word lessons but will focus on what you learned in lesson 3. Task # Points Task Description 1 2 Replace the “Student Name” placeholder on the cover page with your name.

2. 2 4 Modify the Heading 1 style color to “Blue, Accent 1, darker 50%”, and font size 18. Modify the Heading 2 style color to “Green, Accent 6, darker 25%” and font size 14. ============================================== BIS 221T Week 2 Practice Creating Professional Letters FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 2 Practice Creating Professional Letters This assignment has a total of 100 points. Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need the most practice. Make only those changes that are specified in these directions. The Atlas Grader depends on existing text to identify portions of the document for grading. Writing a Business Letter Working with a template can facilitate the creation of letters and forms.? However, in many instances, the template does not exactly fit the need, so that you will often have to make adjustments to the template as you will see during this exercise. You will also notice that the fields in the template are designed such that “field” characteristic disappears after it is edited and the text becomes normal text.? In other words, the fields are added to facilitate the initial entry of data, but then drop out of the picture so as not to be a distraction for later editing. The date field, is left as a field, however, so that it can be automatically updated.

3. ============================================== BIS 221T Week 2 Practice Editing a Report FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 2 Practice Editing a Report This assignment has a total of 100 points. Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need the most practice. Make only those changes that are specified in these directions. The Atlas Grader depends on existing text to identify portions of the document for grading. Add references and citations to the Preparedness Report In this assignment you will practice adding footnotes, citations and captions to your report. Task # Points Task Description 1 6 Edit the title page to include your name in place of the Document subtitle placeholder and insert the current date at the bottom of the page in the date placeholder. Make sure when you set the date that it uses a date format of MMMM DD, YYYY with the month spelled out. 2 2 To give the reader an easy way to reference the source material add a footnote to the opening line of Flood prepare section. To do this place your insertion point at the end of the “To prepare for a flood, you should:” statement. Use the Insert Footnote option on the

4. References ribbon to open a footnote. Type: “http://www.ready.gov/floods” without the quotes in the footnote. ============================================== BIS 221T Week 2 Practice Working with Tables FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 2 Practice Working with Tables Working With Tables This assignment has a total of 100 points. Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need the most practice. Make only those changes that are specified in these directions. The Atlas Grader depends on existing text to identify portions of the document for grading. Manipulating Tables This taskset is to provide practice working with tables. The document that you start with has a single table already defined without boundary lines. To facilitate viewing the cells in the table, you should make sure that gridlines are visible. If gridlines are not visible turn them on by first clicking on any cell in the table. This makes the table menu tabs visible. Click on the Layout tab to show the Layout ribbon. Click on the View Gridlines menu icon. Task # Points Task Description

5. 1 5 Add a new row to the top of the table, merge the new row so that it only has one cell. Cut the title above the table and paste the text into the new table row. ============================================== BIS 221T Week 3 Apply Excel Exam FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 3 Apply Excel Exam Howard, the manager of QuickStove, would like to maintain a list of customers from the United Kingdom in an Excel worksheet. He needs help to format the worksheet so that it will be easier to use. Complete the follow tasks to appropriately format, sort, and filter the worksheets in this workbook. Insert a new column between columns C and D. Label the new column (cell D3) “Customer ID” 0 / 2 (0.0%) Feedback: [-2] Did not insert and label “Customer ID” column Use the “Fill” feature of Excel to insert the numbers 1 to 73 in cells D4:D76. 2 / 2.0 (100.0%) Make the table headers (range B3:K3) bold 1 / 1.0 (100.0%) =============================================

6. BIS 221T Week 3 Practice Charting FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 3 Practice Charting The Education table contains information about the median annual income and 2010 unemployment rate for Americans with various levels of education. Use charts to analyze the relationship between education and income as well as education and unemployment. Construct a column chart to examine the median annual earnings for each level of education. Format the chart with a title “Education and Income” at the top, each education level on the horizontal axis, and no legend. Show data labels on the top of each of the “bars” of the graph. 10 / 10 (100.0%) Feedback: Construct a column chart to examine the unemployment rate for each level of education. Format the chart with a title “Education and Unemployment” at the top, each education level on the horizontal axis, and no legend. Show data labels on the top of each of the “bars” of the graph. 4 / 10 (40.0%) [-3] Incorrect series data for “Unemployment Chart” [-3] Incorrect horizontal axis for “Unemployment Chart” ============================================== BIS 221T Week 3 Practice Excel Basics

7. FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 3 Practice Excel Basics Insert a new column between columns B and C. Label the new column (cell C3) “Record ID” World Records!C3: Record ID 1 / 1 (100.0%) Feedback: Use the “Fill” feature of Excel to insert the numbers 1 to 47 in cells C4:C50. 4 / 4 (100.0%) Feedback: Make the table headers (range B3:J3) bold 2 / 2 (100.0%) Feedback: Center the table headers (range B3:J3) horizontally 2 / 2 (100.0%) Feedback: Make cell B2 bold World Records!B2: font.Bold=True 1 / 1 (100.0%) ==============================================

8. BIS 221T Week 3 Practice Formulas and Functions FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 3 Practice Formulas and Functions You are responsible for tracking daily sales. The table below lists a few of transactions for your company. Notice that the sales tax amount and transaction totals are not filled in. Complete the tasks to the right to complete the table. Construct a formula in cell D11 to calculate the sales tax amount for transaction 578. Be sure to appropriately reference the transaction amount in cell C11 and the sales tax rate in cell C8 so that your formula can be reused for the remaining transations. Formulas!D11: =C11*0.0675 4 / 7 (57.1%) Feedback: [-2] The formula in cell D11 does not reference the sales tax rate [-1] The tax rate reference is not absolute Copy the formula you used in cell D11 down to calculate the sales tax amount for the remaining transactions. 1 / 1 (100.0%) Feedback: Construct a formula in cell E11 to calculate the total amount for transaction 578. Be sure to appropriately reference the transaction

9. amount in cell C11 and the sales tax amount in cell D11 so that you can reuse your formula to calculate the total for the remaining transactions. ============================================== BIS 221T Week 4 Apply Travel Spotlight FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 4 Apply Travel Spotlight Karen works at the West Coast Travel Agency. She has asked you to help her complete the travel spotlight on Peru. On the “Title and Content” Custom Layout of the Slide Master make the following three additions: Add the “westcoastlogosmall” image to the bottom right corner, Change bullets to “Hollow Square Bullets” for all five levels. Add the text “Explore the World with West Coast Travel: A Premier Travel Agency” to the footer Note: There are two ways to get changes to the Slide Master to apply to existing slides. First, if you click on “Apply to all” in the header/footer dialog box the text is applied to all Slide Master layouts and to all the slides. Second if you only want your changes to propagate to a specific Slide Master Layout, you must reapply the Layout (Home ribbon) to each slide and you must Insert Header and Footer (Insert ribbon) for each slide. 15 / 15 (100.0%) Add the “Split” Animation to the bullets on slide 4 (entitled “Places to Visit”). Build each bullet one at a time when the mouse is clicked. Open the Animation Panel and ensure that the only animations on the slide are the ones for each bullet. Other animations on the slide will

10. cause erroneous grading. Delete any other extraneous animations that may exist. 6 / 6 (100.0%) ============================================== BIS 221T Week 4 Practice Developing a Presentation FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 4 Practice Developing a Presentation This assignment has a total of 100 points. Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need the most practice. Make only those changes that are specified in these directions. The Atlas Grader depends on existing text to identify portions of the document for grading. Creating a Presentation Quickstove would like to produce a flyer advertising their products. Your assignment is to build the presentation according to the following specifications. Task # Points Task Description 1 10 Go to the third slide, which has the title “Products” and enter the following lines as three separate bullet points. Cube Stove Fire Starters/Fuel Disk

11. Solar Key Chain Flashlight 2 5 Go to slide 4, which has the title “Cube Stove”, and remove the word “two” that appears in the last bullet to remove the redundancy of “2 two” ============================================== BIS 221T Week 4 Practice Developing PPT Designs FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 4 Practice Developing PPT Designs This assignment has a total of 100 points. Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need the most practice. Make only those changes that are specified in these directions. The Atlas Grader depends on existing text to identify portions of the document for grading. Enhancing a presentation Quickstove would like to produce a presentation advertising their products. Your assignment is to build the presentation according to the following specifications. Task # Points Task Description 1 10 Add the “Largefireboxlogo” to the Title Layout of the Slide Master so that it appears on both slide 1 and 8. Position the

12. image so that it is below the subheading but still inside the white rectangle on each slide. ============================================== BIS 221T Week 4 Practice Editing a Presentation FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 4 Practice Editing a Presentation This assignment has a total of 100 points. Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need the most practice. Make only those changes that are specified in these directions. The Atlas Grader depends on existing text to identify portions of the document for grading. Editing a presentation Quickstove would like to produce a presentation advertising their products. Your assignment is to build the presentation according to the following specifications. Task # Points Task Description 1 6 Use the find and replace option to change every occurrence of Quick Stove with the correct spelling QuickStove. 2 5 Put the “Up Right Stove” and “Upside Down Stove” slides in the same order the positions appear in other advertising with “Upright Stove” before the “Upside down Stove”. To do this, select slide 5 (“Upright Stove”) thumbnail and drag and drop it before slide 4 (“Upside down Stove”).

13. ============================================== BIS 221T Week 4 Practice Editing PPT Designs FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 4 Practice Editing PPT Designs This assignment has a total of 100 points. Practice problems are designed to help you apply what you have learned. It may be a good idea to complete the assignment on your own without help to see where you might need the most practice. Make only those changes that are specified in these directions. The Atlas Grader depends on existing text to identify portions of the document for grading. Enhancing a presentation Quickstove would like to produce a presentation advertising their products. Your assignment is to build the presentation according to the following specifications. Task # Points Task Description 1 4 Insert the ProgramIntro.m4m sound media on the first slide, i.e. the Title slide. Place it so that the speaker icon is to the left of the QuickStove title and easily seen. ============================================== BIS 221T Week 5 Apply LinkedIn Profile FOR MORE CLASSES VISIT www.bis221mentor.com

14. BIS 221T Week 5 Apply LinkedIn Profile Apply: Week 5 LinkedIn Profile Purpose of Assignment Social media is becoming increasingly used to conduct business transactions, and for many businesses it has become a primary tool for marketing communications, sales, and customer support. In this assignment, you will create a professional business profile using LinkedIn that can be used to network with other business professionals, follow current industry news, search for employment opportunities, and link with other social networking apps. Resources: Learn: Learning LinkedIn Video https://www.linkedin.com Assignment Steps Refer to the assignment rubric for an overview of the required content and grading expectations for this assignment, and read the instructions below thoroughly prior to working on this assignment. ============================================== BIS 221T Week 5 Practice Knowledge Check FOR MORE CLASSES VISIT www.bis221mentor.com BIS 221T Week 5 Practice Knowledge Check The term “App” is derived from shortening what word? Application

15. Appease Appropriate Applicative What is a graphical interface that characterizes specific data analysis through visualization? Dashboard Boundary What kind of testing is done to check the performance and behavior of the mobile app under specific conditions like low battery, bad network coverage, or low available memory? Memory Leakage Testing What is a set of illustrations displayed in a specific sequence to pre- visualize what your mobile app looks like and how it works? Illustration Types Transform Transmission ==============================================