Write an outline with references. it should be one or one and a report of atleast 10 pages and should be single space. 

Exp19_Excel_Ch11_CapAssessment_Deans | Exp19 Excel Ch 11 CapAssessment Deans

Project Description:

https://www.homeworkmarket.com/teacher/add-tutorial

You work for the vice president’s office at a major university. Human Resources provided a list of deans and associate deans, the colleges or schools they represent, and other details. You will use text functions to manipulate text, apply an advanced filter to display selected records, insert database summary statistics, use lookup functions, and display formulas as text.

2

First, you want to combine the   year and number to create a unique ID.
 

  In cell C8, enter 2006-435 and use Flash Fill to complete the IDs for all the deans and   associate deans.

3

Next, you want to create a   three-character abbreviation for the college names.
 

  In cell E8, use the text function to display the first three characters of   the college name stored in the previous column. Copy the function to the   range E9:E28.

4

The college names are hard to   read in all capital letters.
 

  In cell F8, insert the correct text function to display the college name in   upper- and lowercase letters. Copy the function to the range F9:F28.

5

You want to display the names in   this format Last, First.
 

  In cell J8, insert either the CONCAT or TEXTJOIN function to combine the last   name, comma and space, and the first name. Copy the function to the range   J9:J28.

6

Columns K and L combine the   office building number and room with the office phone extension. You want to   separate the office extension.
 

  Select the range K8:K28 and convert the text to columns, separating the data   at commas.

7

You decide to create a criteria   area to perform an advanced filter soon.
 

  Copy the range A7:M7 and paste it starting in cell A30. Enter the criterion Associate Dean in the appropriate cell on row   31.

8

Now you are ready to perform the   advanced filter.
 

  Perform an advanced filter using the range A7:M28 as the data source, the   criteria range you just created, and copying the records to the output area   A34:M34.

9

The top-right section of the   worksheet contains a summary area. You will insert database functions to   provide summary details about the Associate Deans.
 

  In cell L2, insert the database function to calculate the average salary for   Associate Deans.

10

In cell L3, insert the database   function to display the lowest salary for Associate Deans.

11

In cell L4, insert the database   function to display the highest salary for Associate Deans.

12

Finally, you want to calculate   the total salaries for Associate Deans.
 

  In cell L5, insert the database function to calculate the total salary for   Associate Deans. 

13

Format the range L2:L5 with   Accounting Number Format with zero decimal places.

14

The range G1:H5 is designed to   be able to enter an ID to look up that person’s last name and salary.
 

  In cell H3, insert the MATCH function to look up the ID stored in cell H2,   compare it to the IDs in the range C8:C28, and return the position number.

15

Now that you have identified the   location of the ID, you can identify the person’s last name and salary.
 

  In cell H4, insert the INDEX function. Use the position number stored in cell   H3, the range C8:M28 for the array, and the correct column number within the   range. Use mixed references to keep the row numbers from changing. Copy the   function to cell H5 but preserve formatting. In cell H5, edit the column   number to display the salary.

16

In cell D2, insert the function   to display the formula stored in cell F8.
  In cell D3, insert the function to display the formula stored in cell H3.
  In cell D4, insert the function to display the formula stored in cell H4.
  In cell D5, insert the function to display the formula stored in cell L3.

17

Create a footer with your name   on the left side, the sheet name code in the center, and the file name code   on the right side.

 hare a personal connection that identifies specific knowledge and theories from this course. Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. 

You should NOT provide an overview of the assignments assigned in the course. The assignment asks that you reflect on how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.  DO NOT REUSE A PREVIOUSLY SUBMITTED ASSIGNMENT, THIS WILL RESULT IN A ZERO. 

Guided Project: E-Commerce Business Plan (Part 1)

*********Startup Idea is “Local Dog Treats Delivery Service”******

• Access and use the following article How to Make a Winning Ecommerce Business Plan for your Startup by clicking the following embedded link or the link below.  

Link: https://www.ecommerceceo.com/ecommerce-business-plan/

• Select a startup (“Local Dog Treats Delivery Service”). You must decide if you are marketing/selling a product(s)/services(s).
• Develop and submit a 1-1.5 page draft  business plan document addressing the topic “Your Value Proposition” for your startup. 
• Your document should be written such that anyone reading your business plan is able to  understand how you considered/evaluated/addressed and accounted for and incorporated this weeks element. Your submission  must address the element identified above and only that element.  

Your word document should have the following;

• Title page, with your name, class, date, and assignment identifier
• Body of the paper, draft submission (1-1.5 pages) double spaced, 12 point font, New Times Roman, 1 inch margins all sides.
• References, if used,  should be identified/listed on a separate page (last page of submission). All references must follow APA format.

———————————————————————–

Guided Project: E-Commerce Business Plan (Part 2)

*********Startup Idea is “Local Dog Treats Delivery Service”******

• Access and use the following article…
•  Link: https://www.ecommerceceo.com/ecommerce-business-plan/
• Develop and submit a 1-1.5 page draft business plan document addressing the topic “Planning Your Business Model” for your startup that you identified in Week 1. 
• Your document should be written such that anyone reading your business plan is able to  understand how you considered/evaluated/addressed and accounted for and incorporated this weeks element. Your submission  must address the element identified above and only that element.  

Your word document should have the following;

• Title page, with your name, class, date, and assignment identifier
• Body of the paper, draft submission (1-1.5 pages) double spaced, 12 point font, New Times Roman, 1 inch margins all sides.
• References, if used,  should be identified/listed on a separate page (last page of submission). All references must follow APA format.

—————————————————————————–

Final Project Requirement Overview

• Develop and submit a 8 -12 page business plan for your startup (Local Dog Treats Delivery Service). Page count does not include title page, table of contents and References page. Your final submission will also include your input for addressing the final topic of “Financial Management” for your business plan.
• The final business plan submission must account for each of the elements listed below
  • Week 1: Your Value Proposition
  • Week 2: Planning Your Business Model
  • Week 3: Market Analysis
  • Week 4: Marketing and Sales
  • Week 5: Choosing the Right Technology
  • Week 6: Products and Services
  • Week 7: Financial Management 

Instructions

• Review, Edit and Proof read your draft submissions for each element in building your business plan and finalize them
• Put your previous business submissions in order
• Generate a References page “as required,” and place at the end of your document 
• Generate a title page ensuring you include all the elements identified below.
• Generate a table of contents for your document
• Proof read your paper ensuring it meets the formatting guidelines listed below and is free from spelling and grammatical errors. Ensure all references used in your paper are properly cited per APA guidelines.
• To verify you have addressed all elements and have them in the proper order access and use the following article How to Make a Winning Ecommerce Business Plan for your Startup (Links to an external site.)   by clicking the embedded link or the link below.

Link: https://www.ecommerceceo.com/ecommerce-business-plan/

Read and use this article to help you develop your business plan by considering the following elements:

• Your Value Proposition
• Planning Your Business Model 
• Market Analysis 
• Marketing and Sales 
• Choosing the Right Technology 
• Products and Services 
• Financial Management 

Your Business Plan (in final form) will be a word document and should meet the following criteria;

• Double spaced, 12 point font, New Times Roman, 1 inch margins all sides
• Title page, with your name, class, date, and assignment identifier
• A table of contents
• Body of the paper  ( 8-12 pages) 
• References  should be identified/listed on a separate page (last page of submission). All references must follow APA format.

 For this assignment, you are expected to have a formal outline of the project handed in for this assignment. The outline should show how all the elements of your Semester Project are sequenced, and what points you’ll make in each section. In the interests of giving you the greatest amount of flexibility, there is no formal structure that you have to follow, unless clearly specified by your instructor. Even so, you might have guessed by now that there are certain expected elements in any security policy, so don’t be too creative. 

Assignment 1:

Research a scholarly paper or professional video on “Change Management” and reflect on only one (1) of the following topics:

• “Impact”: How is the impact of change management on projects? 
• “CCB”: Who are the member of a change control board?
• “Management vs Control”: What is the difference between change management and change control?

NOTE: 
This paper must be between 250-300 words on what caught your eye and reflect on what you read. 
Do not add extraneous text that does not address the question – do not add an introduction or conclusion.
Do not copy and paste text from the referenced resource.You must provide at least one APA reference for your resource and corresponding in-text citations..
You must provide the referenced resource URL/DOI in the APA reference.
Do not use the Textbook as a referenced resource. 

Assignment 2:

 Research a scholarly paper or professional video on “Data Flow Diagrams and Data Dictionaries” and reflect on only one (1) of the following topics:

• “Useful DFD”: When would a Data Flow Diagram be the most useful? 
• “DFD Processes”: What processes are most likely to use DFDs? 
• “Dictionaries”: Who is the audience for Data Dictionaries and how important is it for end-users to understand their data?

NOTE: 
This paper must be between 250-300 words on what caught your eye and reflect on what you read. 
Do not add extraneous text that does not address the question – do not add an introduction or conclusion.
Do not copy and paste text from the referenced resource.You must provide at least one APA reference for your resource and corresponding in-text citations..
You must provide the referenced resource URL/DOI in the APA reference.
Do not use the Textbook as a referenced resource. 

This project provides you with the opportunity to increase and demonstrate your understanding of cyberlaw theory and practice. You will need to choose a law(s) that you are interested in researching. The paper must be 4-6 pages in length detailing the below questions. Before completing the below steps, please make sure that the topic is approved.

1. Thesis: What law are you researching (You are to choose a specific law. Please do not choose a topic)? What position do you want to take in regard to your chosen law? You will need to decide if you agree or disagree with the current way the law is written. You can choose to like certain aspects of the law and not others.

2. Background: What is the existing point you want to challenge or support, and how did the law get to be that way (This is where you would need to find cases, background information, etc.)?

3. Inadequacies: What are the deficiencies in the present way of doing things, or what are the weaknesses in the argument you are attacking?

4. Adequacies: Discuss the positive aspects of the law?

5. Proposed Changes: How will we have a better situation, mode of understanding or clarity with what you are advocating? In short, how can the law be improved (or not diminished)? (This is where you have the chance to change the law with your own ideas of how it should be written).

6). Conclusion: Why should and how can your proposal be adopted?

A detailed implementation plan is NOT expected, but you should provide enough specifics for practical follow-up. In making recommendations, you are expected to draw on theories, concepts and reading.

The Term Paper is due at the end of Week 8. In addition to the 4-6 pages of the paper itself, you must include a title page and a reference page. You are to follow APA Guidelines for citing and referencing sources. Your paper must be in your own words, representing original work. Paraphrases of others’ work must include attributions to the authors. Limit quotations to an average of no more than 3-5 lines, and use quotations sparingly. It is always better to write the information in your own words than to directly quote.

When writing the term paper you must have a minimum of 3-5 outside sources cited and referenced in the paper following APA guidelines.

1. When submitting the paper, it will automatically run through Turnitin for review. PAPERS WITH AN ORIGINALITY REPORT FROM TURNITIN OVER 15% OR OVER 2% FROM A SINGLE SOURCE WILL RESULT IN A ZERO GRADE.
2. PER THE STUDENT HANDBOOK, YOU CANNOT SUBMIT A PAPER THAT HAS BEEN SUBMITTED IN ANOTHER COURSE.

1. DBM380

   Individual Assignment: ERD      Creation Project

The following assignment refers to material found in the Virtual Organizations.

Create a detailed ERD using the Entities and Attributes for Driver’s Log document found on the Huffman Trucking Intranet site.

Use Microsoft® Access® to create the preliminary (no keys and no relationships) database tables for the Huffman Trucking Driver Log.

Skills

S1 Select and apply key analytical techniques (e.g. traditional and intelligent analytics) in order to be able to conduct a big data analysis across the whole data science lifecycle on modern data science platforms and with data science programming languages

S2 Conduct pre-processing, data fusion and data analysis on a wide variety of data sets and to report the results.

S3 Visualise, present and organise data in a variety of formats.

Part 1: Report 

You are required to produce up to 2,000 word report (max) on the subject of anomaly detection. Choose an anomaly detection algorithm that you find interesting and how this particular approach has been successfully deployed in data mining. You are free to choose any application area such as finance, health, fraud, stock market, military, engineering, social media, prediction, telecoms, planning etc. etc.  The report should discuss your data analysis, use R outputs, R code snippets and diagrams to assist your explanations.

Part 2: Practical Implementation 

Based on the machine learning method selected, implement a data mining analysis using this method on your selected data set.

Place the word count on 1st page –

State where you obtained or simulated your data, the R packages you have used, any source code you have used from others. Also, place a full R source listing at back of report, these should be screenshots of the code from the RStudio script editor – it will not add to word count.

You can refer to any of your course handouts, any other books, journals, online resources etc. 

Fintech company that collaborates with law firms and financial institutions to offer investigative solutions. Currently, the company has solutions and applications installed on servers that are located on-premises. Delays occur when new clients or customers need to be onboarded because of on-premises infrastructure. The ability to discover the employees needed to support infrastructure setup is necessary, including software licensing and hardware configuration, which both require several permissions from the information security team. We have opted to migrate to the cloud to cut down on turnaround times for projects and increase productivity. We have found that using cloud solutions enhances the effectiveness of resource deployment and use. Also, the cloud infrastructure makes it simple to integrate analytical solutions on databases.

How does migration to On-Cloud will impact the Fintech firm? Address the potential business or system operations that will be improved following the implementation. Address how this will help operational excellence. Also include a conclusion. I need 2 full pages of content without any extra spacing.