The formula is =HLOOKUP(E5,H_Rates,2)

How to work on a spreed sheet document using the information given

 

Independent Project 2-4

Windows   Mac

Central Sierra Insurance (CSI) sets bonus percentages based on commissions earned by each agent and calculates totals by branch office. This workbook also tracks fundraising efforts of employees for a community event.

[Student Learning Outcomes 2.1, 2.2, 2.3, 2.5, 2.6, 2.7]

File Needed: CentralSierra-02.xlsx (Available from the Start File link.)

Completed Project File Name: [your name]-CentralSierra-02.xlsx

Skills Covered in This Project

  • Create, copy, and edit formulas.
  • Name cell ranges.
  • Set mathematical order of operations.
  • Set cell references to be absolute.
  • Use the NOW function.
  • Use HLOOKUP and VLOOKUP
  • Use the SUMIF function.
  • Build an IF function.
  1. Open the start file CentralSierra-02.xlsx workbook. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
  2. Select the Tables sheet, select cells A6:B10, and create range names using the Create from Selection button [Formulas tab, Defined Names group].
  3. Select cells B1:F2 and click the Name box. Name the selection H_Rates. Note that the first row is arranged in ascending order.
  4. Create an HLOOKUP function to display the bonus rate.
    1. Click the Commissions sheet tab and select cell F5.
    2. Start the HLOOKUP function and use cell E5 as the lookup_value.
    3. For the table_array argument, use the H_Rates range.
    4. Use the second row for the row_index_num argument (Figure 2-100).The formula is =HLOOKUP(E5,H_Rates,2)Figure 2-100 HLOOKUP function to display bonus
  5. Format the results as Percent Style with two decimal places.
  6. Copy the formula in cell F5 to cells F6:F14.
  7. Set order of operations to calculate total earnings.
    1. Select cell G5.
    2. Build a formula to add the commissions amount (E5) to the commissions amount times the rate (F5*E5).
    3. Copy the formula in cell G5 to cells G6:G14.
  8. Create and copy a SUMIF function to calculate total earnings by branch office.
    1. Select cell E18.
    2. Start the SUMIF function with cells $D$5:$D$14 as the Range argument.
    3. Set the Criteria argument as a relative reference to cell C18.
    4. Select cells G5:G14 for the Sum_range argument and make the references absolute.
    5. Copy the formula in cell E18 to cells E19:E20 without formatting to preserve borders.
    6. Format cells E18:E21 as Currency.
  9. Total the earnings in cell E21.
  10. Create and format the current date.
    1. Select cell G23 and insert the NOW function.
    2. Select cell G23 and click the Number group launcher [Home tab]. On the Number tab, select the Date category.
    3. Scroll the Type list to find the date that displays the month spelled out, the date, a comma, and a four-digit year (Figure 2-101).The Date category in the Format Cells dialog boxFigure 2-101 Date format selected
    4. Click OK. Press Ctrl+Home.
  11. Create and copy a VLOOKUP function to display goals for each funding source.
    1. Click the Family Day sheet tab and select cell F6.
    2. Start the VLOOKUP function and use cell E6 as the lookup_value.
    3. Click the Tables sheet tab for the table_array argument and use cells $A$6:$B$10. The data is sorted by the first column in ascending order.
    4. Use the second column as the col_index_num The range_lookup argument is empty.
    5. Copy the formula in cell F6 to cells F7:F20 without formatting to preserve the fill color.
    6. Format cells F6:F20 as Currency with no decimal places.
  12. Create and copy an IF function.
    1. Select cell H6 and start an IF
    2. Type a logical_argument to determine if cell G6 is greater than or equal to (>=) cell F6.
    3. Type Yes as the Value_if_true argument and No as the Value_if_false argument.
    4. Copy the formula in cell H6 to cells H7:H20 without formatting to maintain the fill color.
    5. Center align cells H6:H20.
    6. Press Ctrl+Home.
  13. Insert a new sheet at the end of the tab names and paste the range names starting in cell A1. AutoFit columns A:B and name the worksheet as Range Names.
  14. Save and close the workbook (Figure 2-102).Excel 2-4 completedFigure 2-102 Excel 2-4 completed
  15. Upload and save your project file.
  16. Submit project for grading.

Physical Science -3

 

Question #1.

a) Describe how an electric current is generated and transported.

b) Assess the current state of national grid in the United States, as well as any challenges in updating this grid. 

Question #2.

Read the article titled “Lost in Migration: Earth’s Magnetic Field Overdue a Flip” located at http://www.reuters.com/article/2012/10/03/us-science-earth-magneticfield-idUSBRE8920X620121003 (Links to an external site.).

Read the article titled “Earth’s Inconstant Magnetic Field” located at http://www.nasa.gov/vision/earth/lookingatearth/29dec_magneticfield.html (Links to an external site.).

a) Describe how the Earth’s magnetic field is generated, and how it has changed throughout Earth’s history.

b) Analyze how a magnetic reversal might impact human activities on Earth.

Notes on Movie

Assignment Content

  1. Your homework (HW) is to watch a movie and take some notes! 

    Movie Title: Invictus 
    Rated: PG-13, so you may be able to make it a family experience 6 step problem solving model

    As you watch, take notes on points in the movie that show: 

    1. What important problem did Mandela face, and who was impacted by it?
    2. What might have been the causes of that problem?
    3. What did he try in order to solve it or mitigate it (make it better)
    4. What was the ultimate solution he came to?
    5. How did he implement it?
    6. What are the ways you know it worked?
    7. DO NOT write AFTER the movie! You can pause to take notes
      (If English is not your first language, you can take all or part of your notes in your first language!)
      3.    Submit these notes without editing. If you took notes by hand, take a photo or scan them in. 
      4.    Be prepared to discuss this in class!

Research Paper on Vulnerabilities (cyber Security 225)

 

For this assignment learners will use the Ivy Tech library resources and the Internet to do research on vulnerabilities associated with  a specific OS (e,g. Windows, Linux, etc), network device (Switches, Routers, IDS, etc), or other non-computer technology device (Raspberry PI, RFID, USB).

You must choose one specific subject area to write your paper.  For example, ‘USB’ is not specific. ‘RFID’ is not specific. 3com USB vulnerabilities IS specific. RFID vulnerabilities in Credit Cards IS specific.

Once you have made your selection, using a minimum of 3 current sources (the textbooks cannot be a source) write a double spaced 3-5 page research APA format paper (a paper, not just a bullet list of response answers).  Note, your cover page, and your reference page, are not included in the 3-5 page requirement. You should have 3-5 pages of written text in addition to your cover page and reference pages. Use in-text citations when paraphrasing and quoting sources to avoid plagiarism. 

Goal

In your paper:

1. At minimum, discuss three different vulnerabilities you found in your specific subject area research.2. Discuss how those vulnerabilities can be exploited3. Discuss available countermeasures for each vulnerability you mentioned.Your paper should start with an introduction or problem statement that clearly defines your specific subject and end with a conclusion regarding what your research found.
 

All sources used must be cited on the last page in a bibliography.  Proper grammar and sentence structure must be used for this formal paper. The cover page for your paper must contain your name, date, course, and instructor. The paper must be double-spaced, left-aligned.  Font should be a 10 or 12 point common font.  Do not misuse white space as a filler; points will be deducted for not meeting the minimum requirements. Remember – APA format is required! 

Once you have your paper written and saved in either .doc, .docx, or .rtf format, submit via the link above. 

Question

 Describe how you can convert a FASTQ file to a FASTA file. Provide an example algorithm in pseudocode or in bash, python, or R. Show an example of the input as well as the output 

Journal Article: Collaboration.

Journal Article: COLLABORATION

Your submission must include the following information in the following format: 

DEFINITION: a brief definition of the key term – (the definition should come from the article) 

SUMMARY: Summarize the article in your own words- this should be in the 200-word range. Be sure to note the article’s author, note their credentials and why we should put any weight behind his/her opinions, research, or findings regarding the key term. 

REFERENCE: The source for the analysis must be listed at the bottom of the submission – APA format required. Use only peer-reviewed journal articles for these assignments. Refrain from using blogs, .com’s, or other unreliable internet sources. Be sure to use the headers (Definition, Summary, Discussion, Reference) in your submission to ensure that all aspects of the assignment are completed as required. Any form of plagiarism, including cutting and pasting, will result in zero points for the entire assignment. Further, any flagged documents will result in zero points for the assignment. Flagged documents mean that an attempt at plagiarism exists, or manipulation of the Turnitin process has been attempted. This is unacceptable conduct and will not be tolerated.