Microsoft EXCEL Computer Science Assignment Help. Microsoft EXCEL Computer Science Assignment Help.
I’m working on a computer science project and need support to help me understand better.
(/0x4*br />
Project Description:
In the following project, you will assist Lindsay Johnson, the Director of Pools and Recreation, in creating and modifying a PivotTable report and a PivotChart report to analyze revenue and expenses from the Aquatics Program.
Steps to Perform:
Step |
Instructions |
Points Possible |
1 |
Open the downloaded file go16_xl_ch07_grader_7g_hw.xlsx. Save the file as Lastname_Firstname_7G_Aquatics in your Excel Chapter 7 folder. |
0 |
2 |
Click cell A2, and then insert a Recommended PivotTable by choosing the Blank PivotTable option in the lower left corner of the dialog box. Filter by the Month field. Use the Pool field as the row labels and the Item field as the column labels. Place the Amount field in the Values area. Close the PivotTable Fields list. Note, Mac users insert a PivotTable and then arrange the fields as indicated. |
10 |
3 |
Format the values in the PivotTable using the Number category to display zero decimal places and the 1000 Separator. |
5 |
4 |
Insert a slicer for the Pool field and for the Item field. Apply Slicer Style Light 4 and Slicer Style Light 6 to the slicers, respectively. Note: The style names may be Light Yellow, Slicer Style Light 4 and Light Green, Slicer Style Light 6, respectively, depending on the version of Office used. |
10 |
5 |
By using the two slicers, filter the data to show, for the Tropics Pool, the total revenue for Spa Fees and Swim Lessons. Recall that you can use CTRL to select multiple filters in a slicer. Move the two slicers to the right of the filtered PivotTable, and then make a copy of this worksheet. Name the copied worksheet Tropics Pool. Note, Mac users, after creating and naming the sheet, on the PivotTable Analyze tab, click Filter Connections. Remove all check marks. |
6 |
6 |
Display Sheet1 and clear the filters from the slicers and remove the slicers from the worksheet. Rename the sheet 2Q Revenue |
5 |
7 |
Insert a PivotChart using the Stacked Column chart type. Move the chart to a new worksheet named 2Q Revenue Chart Note, Mac users select the range A4:G10 in the PivotTable. On the Insert tab, click Recommended Charts, and then click Stacked Column to make the chart. Move the chart to a new worksheet named 2Q Revenue Chart |
5 |
8 |
Apply the Layout 3 chart layout and Chart Style 9. Add centered data labels, and then hide all of the field buttons on the chart. As the Chart Title, type 2nd Quarter Aquatics Program Revenue and then insert a custom footer with the file name in the left section. |
7 |
9 |
Add a new worksheet to the workbook, and then import the Access database e07G_Pool_Supplies.accdb into the Data Model as a PivotTable Report using both tables in the database. Rename the sheet Supplies PivotTable Note, Mac users, import the data from the downloaded, comma-delimited text file Pool_Supplies.csv and then convert the data to a table with headers. Insert a PivotTable using the imported data. Rename the PivotTable sheet Supplies PivotTable |
5 |
10 |
To create the PivotTable, place the Supplier field in the Columns area. Place the Item field in the Rows area, and the Quantity field in the Values area. Apply the Number format to the values in the PivotTable with zero decimals and the 1000 separator. |
5 |
11 |
Insert a row above the PivotTable, if necessary, so that the PivotTable begins in cell A2. In cell A1, type Aquatics Program Purchases and then apply the Title cell style. |
5 |
12 |
Click in the PivotTable, and then insert a 3-D Pie PivotChart. Move the chart to a new sheet with the name Aquatic Supplies Chart Note, Mac users continue to next step. |
9 |
13 |
Modify the chart so that only the Supplier field displays in the Axis (Category) area. Remove any fields that display in the Legend (Series) area. Note, Mac users display the Field pane and remove Item field from the Row area. Move the Suppliers field to the Rows area. Select the range A3:B7 in the PivotTable. On the Insert tab, click Pie, and then click 3-D Pie to create a traditional chart. Move the chart to a new sheet with the name Aquatic Supplies Chart |
4 |
14 |
Apply Style 7, remove the legend from the chart, and display only the Category Name and Percentage data labels positioned in the Center. Format the data labels by changing the font size to 12, the Font color to Black, Text 1, and then apply Bold. |
6 |
15 |
Change the chart title to Aquatic Supply Purchases and then change the font size to 24. Hide all of the field buttons on the chart, and then insert a footer with the file name in the left section. |
10 |
16 |
Hide the Aquatics Revenue sheet. Select all the sheets and insert a footer in the left section that includes the file name, and then center the worksheet Horizontally on the page. Change the Orientation to Landscape and scale the Width to fit to 1 page. |
6 |
17 |
Display the properties. As the Tags/Keywords, type aquatic revenue, supplies and as the Subject, type your course name and section #. Under Related People, be sure that your name displays as Author. Save your workbook. |
2 |
18 |
Save and close the file, and then submit for grading. |
0 |
Total Points |
100 |
Microsoft EXCEL Computer Science Assignment Help[supanova_question]
Question and Answer Mathematics Assignment Help
I’m working on a calculus test / quiz prep and need an explanation to help me learn.
1.Suppose during the first die roll event A is getting a 4. Which of the following eventsare independent of event A? Explain why or why not. a)Rolling a second die and getting a fourb)Rolling the first die and getting a sixc)Rolling the first die and getting an even number
2.The probability of a computer having a virus within a company is equal to 0.02. What is the probability that 5 randomly chosen computers will all be free of viruses (none of the 5 computers have viruses)? You may assume independence.
3.The top three foul shooters on the women’s basketball UConn 2013-2014 season were Kiah Stokes and Moriah Jefferson and Stefanie Dolson with foul shooting percentages of 0.600, 0.575 and 0.564, respectively. If in a particular game each of these players get an “and one” and goes to the line one time, what is the probability that all three players make their foul shots?4.70% of disk drives made from Comdrive function properly. If we have a collection of5 disk drives what is the probability that: a)At least one disk drive doesn’t function?b)At least one disk drive is functioning5.A coin is tossed five times in succession. Event A is getting a heads outcome three times. While of the following are compatible events to event A? Explain why or whynot? a)Getting a heads on the first coin toss.
b)Getting a tails on the first coin toss.c)Getting an even number of heads.6.In a snack size package of M&Ms there are 20 pieces. The pieces come in 6 different colors: red, blue, green, yellow, orange and brown. Assuming that the M&M colors occur with equal probability, what is the probability of getting 5 green M&Ms in a package.Solve this problem by using a)The approximation mentioned in Theorem 6 b)The Binomial Distributionand compare answers for a) and b) after you have solved the problem7.Among Americans aged 65 or older, the prevalence of diabetes is 27%. In Springfield, MI there are 2,000 residents aged 65 and older. What is the probability that there will be between 500 and 600 residents aged 65 and older have diabetes inSpringfield, MI? Please choose the appropriate method to approximate this quantity.
[supanova_question]
Mathematics Question Mathematics Assignment Help
Maths Test Year 1
Test: Today 08:30 am (New York Time)
Test Duration: Around 2.5 hours
Attachment is a past exam and a mark scheme which you do not have to finish, it is just for your reference, thank you!
ONLY FOUR B questions have to be completed in section B.
I will send you the test as soon as I receive the document,
PLEASE work on section B first, thank you!
PLEASE write clearly I have troubles reading tutor’s handwriting sometimes? So sorry
I will send my own answer in section A for you to check as soon as I am done, therefore we can work faster together.
[supanova_question]
History Question Humanities Assignment Help
Primary Source Selections and Topics (the readings are available in the links below) Pick 1 of the 3 options below and write a 900 to 1100 page paper that answers the questions listed. Please include explanations and not just facts.
1. READ:
Hearings before the Committee on Immigration, United States Senate, 1921. Pages 223-231, “Statement of Hon. John C. Box, Representative in Congress from the Second District of Texas.” Background on this hearing: Background(2).pdf
http://archive.org/stream/emergencyimmigra00unitrich#page/222/mode/2up
AND ALSO READ: Immigration Act of 1924.pdf
AND ALSO VIEW THIS PHOTO: Shipment to Beet Fields in Colorado.jpg
AND ALSO READ on repatriation: Mae M. Ngai, Impossible Subjects: Illegal Aliens and the Making of Modern America (Princeton University Press, 2004), pp. 71-75: Mae Ngai.pdf
Using the sources above as well as readings from your textbook, compose an essay in which you consider the following questions:
- Why did Congressman Box oppose Mexican workers being allowed into the United States? How do the Congressman’s statements regarding Mexican immigration reflect the nativist ideas of the early 1920s?
- In general, how does the Congressman characterize people from Mexico? On what basis does he make these assertions? Analysis: why do you think that he holds these views?
- How does the Immigration Act of 1924 relate to Congressman Box’s views? What is the significance of the manner in which the provisions and quotas are structured?
- See the photo above. What is the “shipment?” How does this photograph relate to the testimony by Congressman Box?
- How does the repatriation of people of Mexican heritage (including U.S. citizens) during the Great Depression also pertain to the views expressed by Congressman Box?
2. OR READ
Booker T. Washington, “The Road to African American Progress,” at:
Booker T. Washington.pdf
AND ALSO READ:
W. E. B. Du Bois, “The Souls of Black Folk,” Chapters 1 and 3 only, accessible online at the University library at:
https://ebookcentral.proquest.com/lib/elmhurst/reader.action?docID=4217985
Kimberly Fain “The Devastation of Black Wall Street,” in JSTOR Daily: Kimberly Fain.pdf
Using the sources above as well as readings from your textbook, compose an essay in which you consider the following questions:
- What were some of the methods Southern States used to evade the provisions of the 14th amendment? What both legal and “extra-legal” methods were used?
- Over the course of time, how did African Americans seek to assert their rights within the court of public opinion as well as the courts of law? What different strategies and rationales were proposed by Washington and Du Bois?
- By the turn of the century had conditions for African Americans changed significantly? Why did Washington promote accomodationism? Why did activists such as Du Bois reject his leadership and form the NAACP in 1911?
- What happened at Tulsa in 1921 and what does this indicate regarding the movement during that time frame?
- How does the material presented in these sources continue to resonate within the United States today?
3. OR READ:
Ronald Schaffer, The Home Front, OAH Magazine of History, Vol. 17, No. 1 World War I (Oct., 2002), pp. 20-24: Ronald Schaffer.pdf
AND ALSO READ:
Carol L. Byerly, Introduction, Fever of War: The Influenza Epidemic in the U.S. Army during World War I (New York: NYU Press, 2005) pp. 4-13:
Carol L. Byerly.pdf
AND ALSO BROWSE:
The Influenza Archive
https://www.influenzaarchive.org/
Using the sources above as well as readings from your textbook, compose an essay in which you consider the following questions:
- What were some of the drastic actions taken by the Woodrow Wilson administration regarding the World War I home front? Why did Wilson take these extreme measures?
- How did influenza affect the U.S. war effort? How did the pandemic impact cultural aspects of the United States?
- Review some of the personal stories within the Influenza Archive. How do these stories support (or not) the two secondary readings?
- What political and social issues in the United States resulted due to U.S. actions taken on the home front, participation in World War I, as well as from the influenza epidemic?
- How did the U.S. response to the Influenza Epidemic compare to recent events surrounding COVID-19?
[supanova_question]
University of the Rockies The Story of An Hour Summary Writing Assignment Help
Search for “The Story of an Hour”, Click on any article of your choosing. POST a brief summary of the article you chose above in this forum. A summary does not contain any quotations from the article. It is simply a few sentences describing the contents of the article (What does the article say? What are its main points/ideas?). Then, provide a brief analysis (What is the message? How does the author go about proving his or her argument? Was the article convincing to you- why or why not?) This summary/analysis should be written entirely in your own words. Be sure that the summary names the title and author of the article you’re discussing.
[supanova_question]
[supanova_question]
Assessment Title: Information Security Final Assessment 1000000 Computer Science Assignment Help
Write a report about a recent information security attack/breach (which took place recently, January 2019 onwards). The description should contain a brief description of the attack, loss to the organization, details of the vulnerability exposed by the attack (e.g.; CVE), how the attack was manifested (e.g. illustration), the tools used by the attackers and prevention mechanisms which could have stopped the threat or the vulnerability. Data protection by design/default: Compile a report explaining how you would implement Data protection by design and default for a chosen company. The company can be any size which holds personal data of customers, clients, suppliers and employees.Task 2.1 (1000 words):
- The implementation of Data Protection by Design and Default for the chosen company
- The use of below mechanisms for the chosen company to implement data protection by design and default: Data discovery, Data classification, Data Processing Impact Assessment (DPIA), Data Loss Prevention (DLP) mechanisms andPrivacy Enhancing Technologies (PETs)
Task 2.2 (1000 words):
- The use of below mechanisms for the chosen company to implement data protection by design and default: Data discovery, Data classification, Data Processing Impact Assessment (DPIA), Data Loss Prevention (DLP) mechanisms andPrivacy Enhancing Technologies (PETs)
Assessment Title: Information Security Final Assessment 1000000 Computer Science Assignment Help[supanova_question]
I need the methods and results section of my paper written Humanities Assignment Help
ASSIGNMENT:
Complete the following assignment. Please remember to use APA formatting.
- Using the topic of your research project, fully and clearly develop your Methods and Results sections. You will need to explain how the secondary data was collected (ICPSR and other sites will provide you with a description, but you must put what they said in your own words; copying and pasting is plagiarism). Make sure to explain how they assessed the variables (i.e., the survey items used for your variables). You will also need to analyze the relevant data in that particular dataset. Make sure to explain any setup you did for the dataset (this includes Cronbach alphas for any operational definitions that used more than one survey item). Be sure to identify the statistical analysis you used, as well as provide information about descriptive statistics. Eventually, you will want a table or figure that provides this information; it may be a good idea to make one now so you get feedback on it before submitting your final paper.
Attached will be my introduction, conceptual model, and references
The title of my study is The effects of African Americans attending an HBCU.
I will need data sets interpreted from both an HBCU and a PWI
[supanova_question]
Humanities-122-Contemporary Culture &Arts No plagarizm Writing Assignment Help
You must read the collected volumes of this series. These volumes include: please i need this to be good my grade depends on it
Black Panther by Christopher Priest vol 1
Black Panther by Christopher Priest vol 2
Black Panther by Christopher Priest vol 3
Black Panther by Christopher Priest vol 4
All of these volumes can be found in hard copy on Amazon or digitally in the Kindle Store or ComiXology. It is likely that you can also find these volumes in a public library or digitally on Hoopla.
Please write a research paper discussing this work. Please consider:
I NEED a brief history of the Doom Patrol prior to their appearance in this series
Explain how Grant Morrison and Richard Case re imagined the characters, and this version’s impact on comics culture and pop culture
Please watch the 2018 film Black Panther to compare and contrast with the comics
Please support your claims with source material, as well as quotes from creators of and critical materials about the character and the works they appeared in.
This paper should be at least three pages long, single spaced, with 12-point font. I expect your work to be written at a college level, and reserve the right to ask you to rewrite should there be excessive spelling and grammar errors. You must include a bibliography, properly formatted (I will accept MLA or APA), with at least six sources.
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! NO PLAGARIZM!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
[supanova_question]
explain musical genres Writing Assignment Help
Genre Projects– Projects will cover a variety of popular music trends post-1960s including: Synth-Pop, Industrial, Disco, Hip-Hop, Jamaican Dub, Krautrock, House and Techno.
Choose two genres from the given list. Write 3 short paragraphs about each genre. The document should contain relevant historical, cultural, technological, and/or biographical information about the genre and the artists involved. Include youtube links to musical examples, interviews, etc. and any sources, you find pertinent to your topics. I have included key terms and artists associated with each genre that may help guide your research.
GENRE LIST
Krautrock – related terms, tech, and artists: Motorik, 808, Kraftwerk, Tangerine Dream, Autobahn, Stockhausen/WDR, West Germany
Disco – related terms: tech, and artists: Abba, four on the floor, Bee Gees, Saturday Night Fever, Discotheque, The Day Disco Died, Studio 54, NYC
Jamaican Dub – related terms, tech, and artists: riddim, toasting, dub, King Tubby, Augustus Pablo, Sleng Teng, dub, block parties, Kingston
Synth Pop –related terms, tech, and artists: Gary Numan, MTV, Music Video, A-Ha, Depeche Mode, Devo, UK
House – related terms, tech, and artists: The Warehouse, Frankie “Knuckles,” bpm, Trax Records, layering, Chicago, bpm
Techno – related terms, tech, and artists: The Bellville Three, Detroit, Experimentation, four on the floor, bpm
Hip Hop – related terms, tech, and artists: Four elements of Hip Hop, 808, Sylvia Robinson, sound systems, Kool Herc, Grandmaster Flash, SugarHill Gang, Kingston, The Bronx
Industrial – related terms, tech, and artists: Throbbing Gristle, Nine Inch Nails, Ministry, Skinny Puppy, antiestablishment, nihilism, goth culture, drama, noise, feedback/white noise, UK, Chicago, NYC
[supanova_question]
Investment Portfolio Analysis Business Finance Assignment Help
For the final project, you will submit an investment analysis report for a hypothetical company, based on provided constraints and research of market and industry trends. You will need to utilize the topics covered throughout the course in order to demonstrate mastery of the knowledge and skill required of a corporate investment manager. Through research and calculations, you will be analyzing the company’s place in the financial market, constructing a portfolio, and compiling your findings in an executive summary to justify your investment strategies and decisions, along with evaluating the investment performances.
As a corporate investment manager, it is your responsibility to construct an investment portfolio that will generate the maximum rate of return within a given risk class. In order to be successful in this, you need to synthesize your knowledge of your company’s industry and its place in the wider financial markets and of the modern portfolio theory, along with utilizing both qualitative and quantitative skills.
Prompt
You are a new investment manager of XYZ Tech Company. The CEO has asked you to produce an investment analysis report. Using the provided information and investment parameters for the company along with your own financial database research, prepare an investment analysis report for the company. Your analysis report should include compiled data spreadsheets, a complete portfolio, and a justification of your investment strategies in an executive summary.
Specifically, the following critical elements must be addressed:
I. Company and Market Analysis: In this section, you will analyze the company and its position in the financial markets.
A. Financial Markets
i. Analyze the five-year performance of the domestic economy relative to the financial markets.
ii. Explain specific market performance data based on compiled asset valuation model inputs supported by database research of five-year sector and industry performance and current trends.
iii. Evaluate the impact of the five-year and current macroeconomic data on asset prices.
B. Company Valuation
i. Analyze the company’s financial items and key ratios in order to demonstrate a comparison to peers and industry.
ii. Determine the intrinsic value of assets by inputting data into the various asset valuation models, and explain how each model was applied.
C. Industry Trends
i. Compile historic industry microeconomic data from database research for relative comparisons and inputs into asset valuation models.
ii. Analyze quantitative data across sectors and industries to measure absolute and relative performance.
D. Stakeholders
i. Identify five key stakeholders and their needs in relation to the company’s portfolio.
ii. Identify the common stockholders’ primary objective and their required return on equity.
II. Portfolio: With your company and market analysis in mind, construct a complete portfolio that includes the following:
A. Assets
i. Explain the inclusion of specific asset classes for the portfolio, considering the portfolio’s risk/return trade-offs and the company’s investment objectives.
ii. Apply the asset allocation weightings across asset classes, sectors, and industries.
B. Securities
i. Analyze the company’s historical revenue and earnings growth in order to demonstrate a comparison to that of peers in the industry.
ii. Determine the intrinsic value of assets utilizing the asset valuation models.
C. Rates of Return
i. Analyze the assets’ historical risk and rates of return, utilizing a comparison of the assets’ rates of return to similar securities or benchmarks for support.
ii. Calculate required rates of return, utilizing various asset valuation models (e.g. stock valuation models, bond valuation models, real estate valuation models, etc.).
D. Compare the risk/return trade-off on the investments.
III. Executive Summary: Justify your investment strategies in a summary, utilizing your company and market analysis and portfolio for support. Include the following in your justification:
A. Describe how making these investments will position the company within its industry in the market. Support with examples.
B. Explain the benefits of the investments to stakeholders.
C. Assess investment performance utilizing specific performance measurements.
D. Assess investment performance based on risk/return metrics, citing specific examples.
E. Explain how the strategies implemented in the portfolio meet the company’s investment objectives.
APA Format
7- 11 Pages
[supanova_question]
https://anyessayhelp.com/, compose an essay in which you consider the following questions:
- What were some of the drastic actions taken by the Woodrow Wilson administration regarding the World War I home front? Why did Wilson take these extreme measures?
- How did influenza affect the U.S. war effort? How did the pandemic impact cultural aspects of the United States?
- Review some of the personal stories within the Influenza Archive. How do these stories support (or not) the two secondary readings?
- What political and social issues in the United States resulted due to U.S. actions taken on the home front, participation in World War I, as well as from the influenza epidemic?
- How did the U.S. response to the Influenza Epidemic compare to recent events surrounding COVID-19?