Each week you are to enter content into an online journal provided in Blackboard that briefly summarizes (1) the tasks you performed during your internship that week and (2) total hours worked with days/times. The content can be brief and in outline form and use bullet or another list styling, but keep in mind that this content will form the basis of the two major papers that you will write for this course. Therefore, the more detailed you are in your weekly journal, the easier it will be to finish the two papers. Specifically, your weekly journal should contain: 

• The days and times you worked that week, as well as the total hours, worked. (Provide this information at the top of each weekly section so this will act as a de facto heading to separate each weekly entry that you make.) 

• The skills or skillsets used/required to complete each task 

• Each task you performed along with a brief description of what you did.

 • A brief explanation of why the task needed to be done.

 • Was there an outcome? If so, what was that outcome?

 • What new terminology did you learn this week? Provide the term and its definition.

QUESTION 1

1. The ways that HLOOKUP formula works is searching down instead of across data. True
   False

0.9 points   

QUESTION 2

1. The AND formula takes a list of Booleans and returns TRUE if all of them are true, and FALSE otherwise. True
   False

0.9 points   

QUESTION 3

1. How would Excel evaluate the following formula? =OR(7<5, A2=6,NOT("zebra"<="tree"))? Assume that the formula is in cell D4, the workbook contains no circular references, and outside of cell D4 the workbook contains no errors.TRUEFALSEIt would return an errorThere is insufficient information to answer this question

1.4 points   

QUESTION 4

1. One of the benefits of using the Table feature is that you’ll be able to see the column titles at every moment. True
   False

0.9 points   

QUESTION 5

1. Use the brewery.xlsx file to answer the following question: How many total transactions took place at Beerland Amherst?3527425844258542194315939

0.9 points   

QUESTION 6

1. Use the file Code_Enforcement_-_Building_and_Property_Violations.xlsx for this question.
   What is the total dollar amount of penalties for closed cases in Charlestown due to residents’ improper storage of trash (improper storage trash:res)?

1.4 points   

QUESTION 7

1. Use the Brewery.xlsx file to answer the following question: What s the name of the beer with the highest Alcohol by Volume (ABV)?Half LordGear ShiftSheep MojoRed Salty HoserGnu Breath

0.9 points   

QUESTION 8

1. The PivotTable functionality is located in the Data tab. True
   False

0.9 points   

QUESTION 9

1. Use the Brewery.xlsx file to answer the following question: How many beers product names have order quantities between 3000 and 12000?75689

1.4 points   

QUESTION 10

1. Which of the following functions returns a range of cells?OFFSETCOUNTAMATCHREDEFINENone of the given choices

0.9 points   

QUESTION 11

1. A named range can be usedwhen creating chartsin formulasin functionsnone of the given choicesall of the given choices

0.9 points   

QUESTION 12

1. Which of the following statements is correct if new data will be attached as a new row to the existing table?OFFSET( base cell, 0, 0, 1, COUNTA (larger range in row where potential data may appear) )OFFSET( base cell, 0, 0, COUNTA (larger range in row where potential data may appear),1)OFFSET( base cell, COUNTA (larger range in row where potential data may appear), 0, 0,1)OFFSET( base cell, 0, COUNTA (larger range in row where potential data may appear), 0,1)None of the given choices

1.4 points   

QUESTION 13

1. One of the primarily characteristics of Solver is the mathematical relationship between the objective, the constraints, and the decision variables. True
   False

0.9 points   

QUESTION 14

1. The Solver and Analysis Toolpak Add-ins are not built in to Excel. True
   False

0.9 points   

QUESTION 15

1. Use solver to answer the following question: A manufacturing concern wishes to minimize its shipping costs between its 4 factories and 3 warehouses. Factory 1 supplies 1000 units per week and costs $5, $3, and $4 to ship each unit to Warehouses 1, 2, and 3 respectively. Factory 2 supplies 1200 units each week and costs $4, $3, and $3 to ship to Warehouses 1, 2, and 3. Factory 3 supplies 1500 units and costs $6, $2, and $5 to ship to the three warehouses. Factory 4 supplies 1800 units and costs $6, $2, and $4.
   If Warehouse 1 requires 3000 units per week, Warehouse 2 demands 1000, and Warehouse 3 demands 1500, what is the minimum it would cost them in shipping to fulfill each warehouse’s demand?

Exp19_Word_Ch04_CapAssessment_Retirement

Project Description:

You are enrolled in a personal finance course at your local university. One of the assignments is to write a group paper with another student about the different types of retirement plans. You and your partner conducted research on the topic and wrote a final draft of the report. In this project, you will format the paper to enhance readability. You will use track changes, accepting and rejecting them as necessary, credit sources used in the preparation of the report, address your partner’s comments, include a table of contents and an index.

Start   Word. Download and open the file named Exp19_Word_Ch04_CapAssessment_Retirement.docx. Grader has automatically added   your last name to the beginning of the filename. 

Ensure that the markup view is   All Markup. Review the comments. On the second page, reject the replacement   of the two words NOW to lowercase.

Accept all other tracked changes   in the document and stop tracking. Keep all comments.

Change all headings to the   correct heading styles as per the comments left by your partner.

Reply to the first comment by typing I have made the style replacement. (include the period.)

Select the table on page 2, and   insert the caption text to read Table 1: The Future Value of Money (no period). Make sure the   caption displays above the selected item. Center the caption.

Assign the caption Table 2: Comparisons   between a Traditional and a Roth IRA for the next table, as instructed in the comments.   Center the caption.

Select the APA Sixth Edition   style. Click before the period at the end of the first sentence of the 403(b) Plans section. The sentence   ends in (TSA) plan. Insert the   following Web site citation:
 

  Name of Web Page: Choosing a Retirement Plan: 403(b) Tax-Sheltered   Annuity Plan
  Name of Web Site: IRS
  Year: 2018
  Month: October
  Day: 08
  URL: http://www.irs.gov/Retirement-Plans/Choosing-a-Retirement-Plan:-403(b)-Tax-Sheltered-Annuity-Plan

Click before the period ending the first sentence of the 401(K) section. The sentence ends with   at their workplace. Insert the   following Web site citation:
 

  Name of Web Page: 401(k) Plan
  Name of Web Site: IRS
  Year: 2018
  Month: October
  Day: 14
  URL: http://www.irs.gov/Retirement-Plans/401(k)-Plans

For the first table, replace the   Source URL with the following website citation:
 

  Name of Web Page: The Future Value of Money
  Name of Web Site: IRS
  Year: 2018
  Month: October
  Day: 14
  URL: https://www.irs.gov/retirement-plans/plan-participant-employee/retirement-topics-benefits-of-saving-now

Insert a footnote on page 2 at   the end of the table heading in the Introduction   section (the first line of the table), which ends with 6% annual return. Type the following for the footnote: The   calculation did not take into consideration the cost of living adjustment   (COLA). (Do not   include the period.) Change the number format for footnotes to a, b, c in the   Footnotes dialog box. (Click Apply, not Insert.)

Insert a blank page at the end   of the report and insert a bibliography with the title References. The bibliography should be double-spaced with no   paragraph spacing before or after.

Format the bibliography with a   font of Times New Roman and a font size of 12 pt. Center the References title. All text in the   bibliography should be Black, Text 1 font color. Ensure that no text is bold.

Create a table of contents, with   an Automatic Table 1 style, on a new page positioned between the cover page   and the current page 2. Note: Mac users, create a Classic style table of   contents.

Mark the following words as   index entries, selecting Mark All for each: contribution, Roth IRA, traditional   IRA, 403(b), and 401(k). Select the first   occurrence of deduction and set a   cross-reference as See contribution.
  Note, please be sure to search your document to ensure that all occurrences   are marked as specified; press CTRL+F and use the Navigation Pane to locate   each one.

Add an index on a blank page at   the end of the document. Use Classic format and accept all other default   settings.

Insert a footer with a centered   page number, using the Plain Number 2 format. Note: Mac users, insert the   default page number. Do not display the page number footer on the first page.   Numbering begins with page 1 on the Table of Contents page.

Insert a page break so that the   second table and its caption is on one page. Also, update the Table of   Contents to reflect the change in page number.

Save and close Exp19_Word_Ch04_CapAssessment_Retirement.docx.   Exit Word. Submit the file as directed.

What key elements should be involved in a remediation plan and why are they important? Locate a source (other than the links and content of this course) that would assist in developing a remediation plan. Provide a short summary on why this source is beneficial and aspects that you like. If it is a website, post the link to the source in the Webliography. 

Topic : Blockchain overcoming security issues in the Supply chain. 

Pages : 4-5 pages.

Details on all the below points.

• Blockchain Usage and Benefits. 
• Blockchain disadvantages 
• Blockchain Security features 
• Blockchain Types 

Government’s Role with the internet

Cakes By Monica Excel Assignment

For this assignment you will perform calculations in an Excel file. You can find the file in Week 2. Please note, it is your responsibility to have the correct software!

Instructions:

Cakes by Monica (a bakery under the umbrella of the Café Brulé restaurant) in Vermillion, SD makes cupcakes for customers to purchase both in the store and in bulk orders for birthday parties and weddings.

Suppose in the short-run, a bakery like Cakes by Monica has a fixed amount of capital but can hire college students from a local college easily to increase production as needed.  A production schedule is provided for you where Q is dozens of cupcakes.

a) Using the schedule provided, calculate the marginal product of labor when K = 3. 

b) Using your calculations, for which workers are there increasing, decreasing, and negative marginal returns to labor? 

c) Suppose this bakery decides to add another unit of capital in the long-run.  Find the marginal product of the 4th unit of capital and the marginal product of labor when K = 4.

d) Create a graph of the marginal product of labor for K=3 and K=4.

e) Using your graph and the data, how does the addition of another unit of capital affect the productivity of labor? 

Please provide all answers (calculations and written explanations) in the provided Excel File. Save your file with your Firstname_Lastname and submit it in the designated area.

 This paper must contain all of the following elements;

• a title page.
• an introduction of the content of the paper.
• a brief review of the recent literature related to your topic.
• a brief analysis of the application of big data analytics toward your assigned technology.
• a conclusion that summarizes the content of your paper and discusses future research opportunities related to your topic.
• a reference page(s).

To complete this assignment, upload a Microsoft Word document (.doc or .docx) that contains your complete paper. Remember that your paper, including your list of sources, must be in APA format, and you MUST cite your references in the body of the paper using APA in-text citation format. A source is any paper or article that you will reference in your paper. If you need more information on APA format (for references list AND in-text citations), visit this reference:  https://owl.english.purdue.edu/owl/resource/560/01/This assignment must be YOUR OWN WORK!  Plagiarism detected in your work will be addressed as discussed in the plagiarism section of the syllabus. Here are a few details about the overall research paper Please look at the attached rubric for details on how the paper will be graded. 

• Your paper must include both a Title page and a Reference page.
• Your paper should NOT include an abstract.
• Your paper must include a minimum of 7 peer-reviewed resources (articles or papers)
  • Cited sources must directly support your paper (i.e. not incidental references)
• Your paper must be at least 1200 words in length (but NOT longer than 1500 words; Scholarly writing should be efficient and precise. Be clear in the information that you are conveying and with the evidence used to support it. Here is a good resource to help with writing concisely : https://academicguides.waldenu.edu/writingcenter/scholarlyvoice/writingconcisely)
  • Title and reference pages are NOT included in calculating the paper length.

If you are not sure how to identify peer-reviewed papers or articles, please visit the following resources:http://diy.library.oregonstate.edu/using-google-scholar-find-peer-reviewed-articles
http://libguides.gwu.edu/education/peer-reviewed-articles 

Event management systems

 After reviewing the case study this week by Krizanic (2020), answer the following questions in essay format.

1. What is the definition of data mining that the author mentions?  How is this different from our current understanding of data mining?
2. What is the premise of the use case and findings?
3. What type of tools are used in the data mining aspect of the use case and how are they used?
4. Were the tools used appropriate for the use case?  Why or why not?

Minimum 500 words. APA format.