Excelling with Excel

Instructions and template attached

Overview:

Microsoft Excel is a great tool for presenting, organizing, and
calculating data. It can be used to create budgets, track your weekly
spending, or create detailed plans. This assignment will give you an
opportunity to crunch the numbers on your most recent school supply
purchases.

Assignment Requirement:

To successfully complete this assignment, submit the Microsoft Excel
template that includes the required information and formatting.

Steps:

1. Review this Assignment 2 Sample to see a completed version of this assignment for reference. Note: You may not copy any information from this sample into your own assignment. Select the “Read-Only” option when the password window appears as you open this sample.
2. Download the Assignment 2 Directions and Template workbook here.
3. Follow the directions that are listed in the template.
4. Save your document with the following name: CIS105_Assignment2_FirstName_Last Name_Date.xlsx
   
5. Submit your assignment through the submission button.

Use the template to record and calculate the costs of the school materials you purchased for this quarter.

• First, in the Title Page worksheet, enter the following information:
  
  • Type your name in cell B1.
  • Type in the course section you are in cell B2. (For example: CIS105111)
  • Type your professor’s name in cell B3.Type the title of the assignment in cell B4.
  • Type the title (“Excelling with Excel“) of the assignment in cell B4.
  • Rename the worksheet to “Overview.“
  • Change the font type for this information to Century Gothic.
  • Change the font size for this information to 14 point.

• Search for the school supplies you purchased at Amazon, Office Depot, Staples, or some other store.
• Find ten supplies that you purchased. You can include textbooks, lab
  code fees, and paper supplies such as notepads, planners, pens,
  pencils, highlighters, etc.
• Go to Sheet 3. This will be where you add your list of school supplies.
• Type a title in cell A1. (For example: “School Supply Costs” or “My School Purchases.”)
  
  • Format cell A1, so the font type is Calibri Light (Headings), the
    font size is 20-point, and the font color is one of your choosing.

• Enter the following labels in the cells specified:
  
  • Cell A2: School Supplies
  • Cell B2: Quantity
  • CellC2: Price
  • Cell D2: Total Cost
  • Make the font size 16 point and bold these labels.

• Column A: School Supplies
  
  • In cells A3 through A12, enter the names of the ten (10) school
    supplies that you purchased. (If you didn’t buy 10 supplies, list what
    you would have purchased or will purchase next term.)
  • Auto fit the contents of column A so you can see the name of each supply item name.
  • Format cells A3 through A12 so the text is 16-point Calibri Light (Headings) and the font color is orange.

• Column B: Quantity
  
  • In column B enter the Quantity for each of the supplies. For example, will you need four (4) notebooks?
  • Set the width of column B to 11.5”.
  • Format cells B3 through B12 so the text is 16-point Calibri Light (Headings) and the font color is brown.

• Column C: Price
  
  • Enter the price for each school supply item. For example, a single notebook costs $5.
  • Expand column C so you can see all of your costs.
  • Format cells C3 through C12 so the font is Arial, the font size is 14-point, and the font color is dark blue.

• Column D: Total costs
  
  • Use the multiplication function to determine the total cost for each item.
  • Hint: In D3, the formula would be =(B3*C3).
  • Fill in cells D4 through D12 to calculate the total cost of the other supplies.
  • Format cells D3 through D12 so the font is Arial Bold, the font size is 14-point, and the font color is Dark Blue.

• Now, rename Sheet 3 to “School Supplies.”
• Create a pie chart:
  
  • In the School Supplies worksheet, select the range “School Supplies” and “Total Costs.”
  • Insert a pie chart that displays the school supply items and the total cost for each item.
  • Select the pie chart view that shows the dollar amounts for each item.
  • Add a title to your chart so the title is above the chart (can be found in “Chart Formatting”).
  • Add data labels to the pie chart that shows the total cost for each item.
  • Position the chart so it does not overlap with the data in column A, column B, and column C.
  • Review the assignment for accuracy.

• Note: Delete the WK8_A2_Overview and WK8_A2_Instructions sheet before you submit this assignment for grading. (Left click on each sheet to delete.)

Grading for this assignment will be based on answer quality, logic /
organization of the paper, and language and writing skills, using this rubric.

The Project Paper focuses on a suggested topic related to art, architecture, history, music, or literature. The project will reflect your views and interpretation of the topic. This project is designed to help you stretch your mind and your abilities to be the creative, innovative, and critical thinker you already are!

Choose one (1) of the topics from the list of topic choices below. Read the topic carefully. Write a three to four (3-4) page paper (750-1,000 words) that responds to each of the items described in the topic.

For the topic you choose:

1. Support your ideas with specific, illustrative examples. If there are questions or points associated with your chosen topic, be sure to answer all of the listed questions and address all of the items in that topic. If your topic asks you to do several things related to the topic, be sure to do each of the things listed.
2. The listed topics each have a certain writing genre with it (written speech, memo, poem with essay, scripted dialogue, etc). From this you can see that there is a fun, creative writing aspect to this assignment. In most cases students should stick with the genre as listed. However, your instructor might suggest some alternative genre on one of the topics. As a student, you also can propose to your instructor some alternative genre for the topic you choose—something different from what is listed. Since not all such proposals can work, be aware that your proposal will get consideration, but may or may not be approved. Also, if you make such a proposal, please do so before the end of Week 5.
3. Use at least three (3) good quality academic sources, with one (1) source being the class text.
   Note: Wikipedia and other similar Websites do not qualify as academic resources. You are highly encouraged to use the Resource Center tab at the top of your Blackboard page.

New Composition. Speech. Your uncle’s birthday is in two (2) months, and everyone knows that he loves almost all kinds of music. As a birthday gift for him, you want to have a special piece of music composed in his honor which will be played at a family birthday celebration. Write a speech that you will make to the composer’s agent. Include the following:

1. Narrow your choices down to three (3) composers you’ve studied in this course. Choose one (1) of the composers and explain why you want him to write the “birthday present” music.
2. Explain why the other two (2) composers were ultimately not selected.
3. Specifically identify the musical elements in the composer’s style that you would like to be included in the new music written for your uncle.
4. Describe what sort of emotion is generated by listening to the works of your selected composer; in other words, what do you want your uncle to “feel” as he hears the music, and why is this composer so perfect for this composition?

• Explain how the strategies of fission, budding, fragmenting, and forming runners are asexually

driven and advantageous to animals, plant, or fungi?

• Explain how the strategies of alternation of generation, parthenogenesis, hermaphrodism (simultaneous & sequential), polygyny vs. polygyny, or monoecious vs. dioecious are sexually driven and advantageous to plants, animals, or fungi

• Draw, label, and outline the events of a diagram that would show the steps or stages of the cell cycle

• Draw, label, and outline the events of a diagram that would show the steps of mitosis in animal cells

• Draw, label, and outline the events of a diagram that would show the steps of meiosis in animal cells

Discuss the problems that could arise from issues that occur during meiosis in animal cells?

“File Storage and Management” Please respond to the following:

Managing files and folders may seem like mundane work, but file storage and management is one of the most critical operations a technician can master. As we’ve discussed in previous discussions, people can get very upset when they can’t access their data. No matter how much a computer costs, the data is generally far more valuable. Files come in various formats, but ultimately they break down to 1’s and 0’s.

• • Describe a way that you would arrange data so files are easy to locate and back-up.
  • What would you tell users about securing their data after the lessons that you’ve learned this week?
  • How would you safeguard your own data?