All posts by : chebby

Now that you have made a proposal, we need to collect evidence! This week you will be researching and collecting data that shows why you believe it is important to pursue your proposal. Make sure to collect as much as information as possible so you can create meaningful charts next week. This week’s work will be the basis for next week’s assignment.

The following resources will be used to complete your assignment:

• Microsoft Excel

This week you will complete the first draft of your Excel spreadsheet. Follow the steps listed below to complete the first part of your data collection.

1. Create a new Excel file and call it “YourName_COMP150_W5_Assignment”.
2. Add two new sheets and name them as “Read Me” and “Main Data”.
3. The “Read Me” sheet is the place where you will add your name and date. You will also explain the purpose of the document and the type of information you are providing. See an example below.

1. Based on your research topic, you need to provide a large set of data that can be used for analysis during this week and next. Your data set must be at least of 10 rows and 3 columns and no more than 50 rows or 10 columns. You can make this up or do research to find a data set. The data set must have numbers to help with the calculations in the next steps, so it is recommended to review the entire assignment before you create the data set. 
2. The table with the dataset must have a header that is merged and center.
3. The data must be visible so make sure the columns and rows have enough spacing
4. You are expected to have all of the following calculations
   1. A formula using a relative reference
   2. A formula using absolute reference
   3. Use at least three different functions
5. Ensure the different types of data have the right formatting. Here are some guidelines
   1. Dates should have “date” formatting
   2. Any currency should have two decimals
   3. Any text should be setup as “text” or “general”
6. Feel free to be creative by adding images or other formatting, and complete the file. Make sure the file is named “YourName_COMP150_W5_Assignment” and submit the file.

1. Research How to install Plugin “Elementor” in WordPress. Explain step by step including pictures as a design pattern for successful and active plugin.  

2. Research How to install Plugin “GTranslate” in WordPress. Explain step by step including pictures as a design pattern for successful and active plugin.  

Please take a look in an attached file as an example so you have an idea how to do it.

 only pseudocode  

The Chocolate Delights Candy Company needs to add the following functionality to its cash register:
When a customer is checking out, the cash register needs to store the required data pertaining to each  item the customer is buying. This data includes the item name, the price per pound, and the number of  pounds of that item being purchased. This should be stored in three (3) arrays (one (1) for the item name,  one (1) for the price per pound, and one (1) for the number of pounds being purchased) with  corresponding index values. For example, index value 3, when applied to the “itemName” array, would  give as the name of the third item that the customer is buying. That same index value of 3, when applied  to the “pricePerPound” array, would give us the price per pound of that same third item that the customer  is buying.
When that last item in the purchase has been saved to the array, an itemized receipt is printed which
shows the relevant data (name, price, and amount purchased) of each item, the subtotal price for each  item (which is calculated as price per pound times the number of pounds), and the grand total purchase  amount of all items.
Use Visual Logic to create the data flow diagrams needed in order to develop the design documents for
an interactive event-driven program to solve the above scenario that includes at least:
1. Three (3) arrays
2. One (1) loop
3. One (1) and / or conditional statement that covers decision making to include true and false parts
of an if statement.
Include the code along with the Visual Logic output.
 

Refer to the attachment uploaded.

1. What are the common mistakes to avoid in your program when using loops?  Use examples to explain.

Discussion 1 (Chapter 9): Discuss the correspondences between the ER model constructs and the relational model constructs. Show how each ER model construct can be mapped to the relational model, and discuss any alternative mappings?

– apa with references

– 2 pages

 This week we focus on the concept of false discovery in data.  After reviewing the article by Naouma (2019), answer the following questions:

1. What is a false discovery rate?
2. Can a false discovery rate be completely avoided?  Explain.
3. What was the outcome of the results of the use case?

Read:

1. ch.10 in textbook: Avoiding False Discoveries
2. Naouma, P. (2019). A comparison of random-field-theory and false-discovery-rate inference results in the analysis of registered one-dimensional biomechanical datasets. PeerJ (San Francisco, CA), 7, e8189–e8189.

 Exp19_Word_Ch04_CapAssessment_Retirement 

Word Chapter 4 Capstone Assessment – Retirement

 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.

Need to build a Tableau dashboard with the given datasets. Attached are sample datasets, I’ll give the full data once its accepted.

TOPIC 4: Excel Proficiency Assignment

Assessment Description

The purpose of this assignment is to articulate how various industries use the Internet and cloud computing resources in business operations and to establish a competitive advantage.

Part 1

Conduct research about the use of the Internet and cloud computing in a business sector related to your field of study.

Create a PowerPoint presentation with a minimum of eight slides that summarizes your findings. The presentation should address the following:

1. Describe the business sector.
2. Provide specific examples of how the industry is utilizing the Internet and cloud computing resources in business operations.
3. Explain how the use of Internet and cloud computing resources has helped the company gain competitive advantage by providing a specific example.
4. Discuss specific technology disruptors the industry/business sector has seen in the last 1-3 years.
5. Discuss how the industry/business sector is changing as a result of the use of Internet and cloud computing resources.
6. Include a reference slide at the end of the presentation.

Part 2

Practice delivering your PowerPoint presentation. Using Loom, record your delivery of the PowerPoint presentation. Refer to the topic Resources for additional guidance on recording your presentation with Loom. Employ the following public speaking strategies:

1. Speak slowly and clearly.
2. Make eye contact.
3. Present yourself in a professional manner.
4. Make sure that you are visible in the Loom bubble on the same screen with the PowerPoint slides.

General Requirements

Refer to the resource, “Creating Effective PowerPoint Presentations,” located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style.

Submit the PowerPoint presentation file with the link to the Loom video presentation as the last reference in the references list slide. Do not try to upload the video file: It will be too big and will not upload. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit.

While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines.