Which of the following instruments is NOT used for suctionin…
Questions
Which оf the fоllоwing instruments is NOT used for suctioning?
Reseаrch Essаy Tоpicаl Outline (MEAL plan fоr bоdy paragraphs with Source Synthesis) Your resources for this assignment: Jasari Cortez All Articles.pdf Jasari Cortez All Note Cards.pdf Instructions: During this Honorlock session, write a formal topical outline for your research essay. Your outline should follow these requirements: Seven sources (four found in the San Jac Library Super Search and three through a Google search): Use information from all seven of your sources that you have annotated and created notes for in previous weeks. They are provided to you in a PDF file above this outline format. If you did not submit all the sources in previous weeks, you may not see the required number of sources here, which will lead to a grade deduction. Answer your Research Question in multiple paragraphs: Organize the essay outline around major ideas that help lead to an answer to your research question Source Synthesis: Each body paragraph must synthesize TWO sources to help answer your research question. Synthesizing sources means to combine them together by explaining the ways two sources agree with one another, disagree with one another, or extend/add to the ideas of one another. Sources should be connected through a shared idea, pattern, or meaningful contrast. Do NOT organize paragraphs source-by-source. Each paragraph must follow the MEAL plan structure of Main Idea Evidence synthesized from at least two sources Analysis of the Evidence, and How It Answers the Main Idea Last word and lead in – a conclusion or wrap up to the paragraph and a lead in to the next paragraph (in other words, a transition) Number of body paragraphs: Decide how many body paragraphs you think you will need to answer your research question effectively. I included six here, but you may have more or fewer. Use the outline format below. You do not need to retype the entire outline format. Instead, just use the Roman numerals, label the parts briefly, and personalize the outline for your research question and sources Thesis Statement Write your current thesis statement, or in other words, what do you think the main idea of your essay will be? You worked toward this main idea when you wrote your position statement a few weeks ago. I. Body Paragraph 1: M – Main Idea: Key idea or concept that will help answer your research question or a key section/part you believe your essay will need in order to answer your research question effectively (this can be addressed in a phrase or a complete sentence) E – Evidence from Source 1 Short Quotation, Paraphrase, or Summary of a Section of Source 1 with an in-text citation that includes the author’s last name and a page number. E – Evidence from Source 2 Short Quotation, Paraphrase, or Summary of a Section of Source 2 with an in-text citation that includes the author’s last name and a page number. A – Analysis – Synthesize the two sources together by explaining how the ideas quoted, paraphrased, or summed up from the sources connect to each other. This may be a way the two sources agree with one author, disagree in a useful manner, or how one source adds to/extends another. For example, one source may add an example not mentioned in the other source. Choose one of the following to synthesize the sources: Agreement between sources Useful disagreement Extension L – Last word and Lead Out– How does this paragraph work to answer your research question and support your thesis statement? How does this paragraph II. Body Paragraph 2: M – Main Idea: Key idea or concept that will help answer your research question or a key section/part you believe your essay will need in order to answer your research question effectively (this can be addressed in a phrase or a complete sentence) E – Evidence from Source 1 Short Quotation, Paraphrase, or Summary of a Section of Source 1 with an in-text citation that includes the author’s last name and a page number. E – Evidence from Source 2 Short Quotation, Paraphrase, or Summary of a Section of Source 2 with an in-text citation that includes the author’s last name and a page number. A – Analysis – Synthesize the two sources together by explaining how the ideas quoted, paraphrased, or summed up from the sources connect to each other. This may be a way the two sources agree with one author, disagree in a useful manner, or how one source adds to/extends another. For example, one source may add an example not mentioned in the other source. Choose one of the following to synthesize the sources: Agreement between sources Useful disagreement Extension L – Last word and Lead Out– How does this paragraph work to answer your research question and support your thesis statement? How does this paragraph lead into the next one? III. Body Paragraph 3: M – Main Idea: Key idea or concept that will help answer your research question or a key section/part you believe your essay will need in order to answer your research question effectively (this can be addressed in a phrase or a complete sentence) E – Evidence from Source 1 Short Quotation, Paraphrase, or Summary of a Section of Source 1 with an in-text citation that includes the author’s last name and a page number. E – Evidence from Source 2 Short Quotation, Paraphrase, or Summary of a Section of Source 2 with an in-text citation that includes the author’s last name and a page number. A – Analysis – Synthesize the two sources together by explaining how the ideas quoted, paraphrased, or summed up from the sources connect to each other. This may be a way the two sources agree with one author, disagree in a useful manner, or how one source adds to/extends another. For example, one source may add an example not mentioned in the other source. Choose one of the following to synthesize the sources: Agreement between sources Useful disagreement Extension L – Last word and Lead Out– How does this paragraph work to answer your research question and support your thesis statement? How does this paragraph lead into the next one? IV. Body Paragraph 4: M – Main Idea: Key idea or concept that will help answer your research question or a key section/part you believe your essay will need in order to answer your research question effectively (this can be addressed in a phrase or a complete sentence) E – Evidence from Source 1 Short Quotation, Paraphrase, or Summary of a Section of Source 1 with an in-text citation that includes the author’s last name and a page number. E – Evidence from Source 2 Short Quotation, Paraphrase, or Summary of a Section of Source 2 with an in-text citation that includes the author’s last name and a page number. A – Analysis – Synthesize the two sources together by explaining how the ideas quoted, paraphrased, or summed up from the sources connect to each other. This may be a way the two sources agree with one author, disagree in a useful manner, or how one source adds to/extends another. For example, one source may add an example not mentioned in the other source. Choose one of the following to synthesize the sources: . Agreement between sources Useful disagreement Extension L – Last word and Lead Out– How does this paragraph work to answer your research question and support your thesis statement? How does this paragraph lead into the next one? V. Body Paragraph 5: M – Main Idea: Key idea or concept that will help answer your research question or a key section/part you believe your essay will need in order to answer your research question effectively (this can be addressed in a phrase or a complete sentence) E – Evidence from Source 1 Short Quotation, Paraphrase, or Summary of a Section of Source 1 with an in-text citation that includes the author’s last name and a page number. E – Evidence from Source 2 Short Quotation, Paraphrase, or Summary of a Section of Source 2 with an in-text citation that includes the author’s last name and a page number. A – Analysis – Synthesize the two sources together by explaining how the ideas quoted, paraphrased, or summed up from the sources connect to each other. This may be a way the two sources agree with one author, disagree in a useful manner, or how one source adds to/extends another. For example, one source may add an example not mentioned in the other source. Choose one of the following to synthesize the sources: Agreement between sources Useful disagreement Extension L – Last word and Lead Out– How does this paragraph work to answer your research question and support your thesis statement? How does this paragraph lead into the next one? VI. Body Paragraph 6: M – Main Idea: Key idea or concept that will help answer your research question or a key section/part you believe your essay will need in order to answer your research question effectively (this can be addressed in a phrase or a complete sentence) E – Evidence from Source 1 Short Quotation, Paraphrase, or Summary of a Section of Source 1 with an in-text citation that includes the author’s last name and a page number. E – Evidence from Source 2 Short Quotation, Paraphrase, or Summary of a Section of Source 2 with an in-text citation that includes the author’s last name and a page number. A – Analysis – Synthesize the two sources together by explaining how the ideas quoted, paraphrased, or summed up from the sources connect to each other. This may be a way the two sources agree with one author, disagree in a useful manner, or how one source adds to/extends another. For example, one source may add an example not mentioned in the other source. Choose one of the following to synthesize the sources: Agreement between sources Useful disagreement Extension L – Last word and Lead Out– How does this paragraph work to answer your research question and support your thesis statement? How does this paragraph lead into the next one? VII. Conclusion Paragraph: X: Re-Explain your thesis statement but don’t just copy and paste it Y: Explain why your essay and answer to your research question matters Z: Zing the readers with a final memorable thought
Filenаme, Sоrt, Filter, Pivоt Tаble, Subtоtаls, Data & Statistical Functions, and Print Settings — 65 Points 1. Create a Folder on your Desktop named Exam. 2 . Download the following file(click on the 3 dots at the end of the line and click download), save it to your Exam folder. SU26_Excel_Template_Ex2.xlsx 3. Use the SP26_Excel_Template_Ex2.xlsx file that you downloaded from Blackboard for this exam. “Save As” or Rename this workbook as your last name + your first initial + _Ex2.xlsx. Below is an example of the filename you would use if you were Sam Smith: Filename Example: SmithS_Ex2.xlsx 4. You are continuing your work with Experience Alaska, Inc. and they have asked you for specific information about their planned late-May through mid-July 2025 trip packages. It is highly recommended that you save your work frequently. 5. With your newly renamed file open in Excel, make the Packages sheet active. 6. Using the appropriate command option, sort the list by Departure Date (oldest to newest), Trip Type (Z to A), and Package Price (smallest to largest) in order. 7. Copy the Packages sheet to a new sheet and name the new sheet Filter. 8. Make the Filter sheet active. Turn on Filters for all data columns. Using Number Filters for both, display the data for trips with a Trip Length of greater than 5 Nights, and a Package Price of $2,300 or more. Your Filters should account for the possibility of any future trips that may be added. 9. Return to the Packages sheet. Management would like to further analyze their current booking information. Create a Pivot Table on a New Worksheet showing the Average of Package Price by both Trip Type (in rows) and Destination (in columns). Format the Trip Cost data as Currency with Dollar Signs and Zero Decimals. Rename your new worksheet Pivot Analysis. 10. Management would like another booking information analysis. Copy the Packages sheet to another new sheet, and name the new sheet Subtotals. Create a Subtotal that displays the average amounts of only the Package Price at each change in Trip Type. You will first need to sort your information appropriately. 11. Management now needs to determine how their trip prices will be affected by a proposed tax. Copy the Packages sheet to another new sheet, and name the new sheet Trip Tax. Insert a new column between column D and column E and name the new Column E, PriceWithTax. Ensuring that the Range_lookup finds an Exact Match, use the VLOOKUP function to calculate the new PriceWithTax based upon the percentages in the Proposed Tax Table that gives the DeparturePoint for each PackageNum. Apply the same formatting used in Column D, Package Price. 12. Return to the Packages sheet once again, and in cell A30 enter the text Total price of trips going to Seward on the AK RR. In cell D30, use the appropriate conditional math function to determine that total. Format your result with Currency and zero decimals. 13. In cell A31 of the Packages sheet, enter the text Number of trips departing on July 5. In cell D31, use the appropriate conditional statistical function to determine that number. 14. With your Packages tab/worksheet active, set the print settings to the following: a) Landscape orientation b) Fit to one page c) Center both vertically and horizontally d) Create a Custom Header with Your Name in the center section e) Create a Custom Footer using the appropriate button to display the File (Workbook) name in the center section. Three Year Forecast Activities — 35 Points 1. Make your Three Year Forecast sheet active. Experience Alaska, Inc. would like you to continue to assist them with their forecast information. 2. Previously, we created this forecast worksheet and determined the Award Status. Now use Conditional Formatting in the range B23:D23 to emphasize when a “Cash Bonus” is to be awarded. Show the cell contents with a Bold & Italic Dark Blue, Text 2 font (first row, fourth column), and with an Outline Border of the same color when the condition is met. Do not use more than one rule. 3. While on the Three Year Forecast sheet, create a Scenario Summary report with the following information using cells B23:D23 as the result cells: Scenario Name Data Specifics Original Expense Variables Same Percentages that are currently given Increased Advertising Use 17.50% instead of 15.00% Decreased Salaries Per Year Use 50.00% instead of 55.00% Hide column D (the Current Values: column) on your newly created Scenario Summary worksheet. Make sure your Scenario Summary report is easily understood by any reader. The Changing Cells and Result Cell descriptions should not display cell references. 4. Next, make the Goal Seek sheet active. You previously used the PMT function to determine the cost of a new boat (showing a negative dollar amount), but Experience Alaska wants to pay less per month. With the Goal Seek sheet active, use the Goal Seek feature of Excel to determine the down payment that would be necessary to make the Monthly Payment equal to $500. 5. Using the same Goal Seek sheet, create a Two-Variable Data Table for the Monthly Payment Amounts using an Annual Interest Rate Range of 3.00% to 5.00% (in increments of .25%) and Term in Years options of 2, 3, and 4. Use cell D5 as the upper-left corner of your table, and format your Monthly Payment amounts with Currency and zero decimals. Ensure that all data is visible. Apply a custom number format to make the formula reference in cell D5 appears as Monthly Payment. Excel Chart—20 Points 1. With your Three Year Forecast sheet active and your Scenario Summary showing the Original Expense Variables, create a Pie in 3-D chart demonstrating the Net Profit After Taxes by Forecast Year. a) Place your chart on a New Chart Sheet (not Object in) and name the tab “Profit Chart”. b) Create a title above the chart as Forecasted Net Profit After Taxes by Your Name. c) Use Outside End Data Labels to display only Percentages with one decimal place, and Category Names. Remove the legend. d) Apply a Pattern Fill and Explode the piece that illustrates the year with the highest forecasted Net Profit After Taxes percentage. Make sure your spelling on the chart is correct Finally—5 Points 1. Make sure your worksheets are in the following order: Three Year Forecast, Goal Seek, Scenario Summary, Profit Chart, Pivot Analysis, Packages, Subtotals, Filter, and Trip Tax. 2. Ensure that there are no spelling errors on your Three Year Forecast and Goal Seek worksheets. 3. Save your workbook one last time and exit Excel. 4. In the answer box below , click on the attachment icon and attach your file to it. ** Make sure your file is saved and attached properly to this question, otherwise your instructor will not receive your exam to grade. 5. Once your file is submitted, delete all exams files and empty your recycle bin.