Module 4: Queries & SQL

Database Project Phase 3 Instructions

Following are instructions for Database Project Phase 3. Remember that each phase is built on the instructor-approved outcome of the previous phases and reflects all recommended changes and corrections.  Follow all submittal instructions at the bottom of this document.

Phase 3:  Build and Populate Tables, Perform Queries: In this phase of the project your work will be done in MS Access.  You will build the approved tables, populate the tables with data and perform a variety of queries as stated below:

• Create a new database named after your project title.
• Follow the examples in Chapter 3 of the MS Access textbook and create tables in Design View.  Be sure to use a variety of data types.  Explore data types other than text. Use numeric, date, etc.
• Make sure tables have the appropriate primary key matching the approved table structure from Phase 2.
• Populate tables with data with a minimum of 10 records.  There may be one or two tables with fewer records.  For example, in the case of the daycare example, there may be only two to three teachers.
• In a Word document, propose five different types of queries to be performed on your database tables.  Include a variety of queries as follows:
  • And query
  • Or query
  • Multi-table query
  • Parameter query
• Perform the proposed queries and save them in your database.  Assign a meaningful name to each for easy reference as you will be using them in future phases.
• Submit your MS Access database file and word document to the assignment submission folder in Module 4.

Your initial post should be based upon the assigned reading for the week, so the textbook must be the only source utilized and listed in your reference section (and properly cited within the body of the text). Other sources are not required and are a waste of time to search and utilize. Only use the textbook.

Do not provide a Reflection or Chapter Overview. Provide only a graduate-level response to each of the following questions:

1. The project manager and sponsor need to act in the best interest of which three constituencies?
2. Describe how to use project documents to help a team progress through the stages of development.
3. Describe each method of decision making a project team may use. Using examples, tell when each is most appropriate.

Your post must be substantive and demonstrate insight gained from the course material. Postings must be in the student’s own words – do not provide quotes!

Must be minimum 600 words in APA format.

Text

Title: Contemporary Project Management ISBN: 9781337406451 Authors: Timothy Kloppenborg, Vittal S. Anantatmula, Kathryn Wells Publisher: Cengage Learning Publication Date: 2018-02-08 Edition: 4th 

Exp19_PowerPoint_Ch04_CapAssessment_Brainstorm

Exp19 PowerPoint Ch04 CapAssessment Brainstorm

Project Description:

You are working on a presentation about creative problem solving with brainstorming. It will be shown by the Marketing Club at one of their monthly meetings. You decide to incorporate SmartArt to convey the brainstorming process along with inserting and modifying images. You also add animation, a Morph transition, and insert a Summary Zoom slide in the presentation.

Start PowerPoint. Download and open the file Exp19_PPT_Ch04_CapAssessment_Brainstorm.pptx. Grader has automatically added   your last name to the beginning of the filename.

Replace Student Name on Slide 1 with Thomas   Bentley.

Convert the SmartArt   graphic on Slide 2 using Convert to Shapes.

Select and ungroup   all three shapes. Click Align and then Align to Slide. Distribute vertically,   ensuring that the Lots of ideas   shape appears at the top and Wild ideas   welcome appears at the bottom of the slide. Regroup them back together.

Insert a new Slide 2   with the Title and Content layout. In the title placeholder, type Have   any great ideas lately?

Insert Brainstorm1.jpg in the right content   placeholder. Size the height to 6.23” and width to 4.72″. Position it at   horizontally at 6.18” from the Top Left Corner and   vertically at 0.64” from the Top Left Corner. Apply the Photocopy   artistic effect.

Apply the Fade   animation to the picture. Set it to Start After Previous with a duration of 01.25 and a Delay of 00.50.

Apply the Fade   animation to the grouped object (former SmartArt graphic) on Slide 3. Set it   to Start After Previous with a duration of 02.00 and a Delay of 00.50. 

Apply the Fade   animation to the chart on Slide 4. Set it to Start After Previous with a   duration of 01.50 and a Delay of 00.25.

Apply the Fade   animation to the right content placeholder on Slide 6. Set the effect option   to By letter. Set it to Start After Previous with a duration of 01.00 and no delay.

Align the bottom   table on Slide 7 to the bottom edge of the top table using Smart Guides.   Apply the Fly In animation to the top table. Set it to Start After Previous   with a duration of 01.00 and a Delay of 00.25. Apply the Fly In   animation to the bottom table. Set it to Start After Previous with a duration   of 01.50 and a Delay of 00.50. Turn off Smart   Guides.

Duplicate Slide 8.

Replace the picture   in the right content placeholder with Brainstorm2.jpg   on the new Slide 9. Size the picture height to 5.82” and the width to 8.72”. Position the   picture horizontally to 3.96” from the Top Left Corner and   vertically to 0.83”. Type Or with a group, always brainstorm! as the new title   text.

Apply the Morph   transition to this slide.

Set the transition to   advance automatically after 01.00 with a duration of 03.00.

Click Slide 1 and   insert a Summary Zoom using Slides 2, 3, and 6. Type Brainstorming   101   in the title placeholder of the new Slide 2.
 

  Note, in case this feature is unavailable, insert a new Slide 2 with the text   Brainstorming 101 as the title. 

Save and close Exp19_PPT_Ch04_CapAssessment_Brainstorm.pptx.   Exit PowerPoint. Submit the file as directed. 

The goal of this assessment is to give learners the opportunity to demonstrate their ability to produce a risk assessment for a Fintech company based on a given scenario.

Scenario 

Your client is a growing, Dublin-based, Fintech business with 60 staff, 40 of these employees have been recruited in 6 months. 90% of the staff are currently working from home using a mix of company and personal IT devices. The company handles sensitive databases and records as part of its typical business practice. The company is also involved with software development. The IT department handles the day-to-day data security. This will be the first formal risk assessment undertaken at the company. 

The CEO has a good understanding of cybersecurity and is eager to comply with regulations and protect the company from cyber-risks. 

As a reference point, the following website is a company similar to the one we are working with: https://www.aikido.finance/ 

Considerations
• What factors would need to be examined in a risk assessment process?
• Have we documented and assessed the assets which need to be protected?
• Which risk mitigation actions need to be considered?
• Are there data policy documents that need to be in place?
• What factors would benefit the overall cybersecurity posture of the company? 

Your Task: Provide a risk assessment report focused on identifying and mitigating risks within the organization. 

Its a Operating system assignment

threading

check the attachment

Overview

In each module, you will be learning about different statistical functions in R. You will apply these functions to specific data sets, creating models that can be used to understand and solve real-world problems. You will gain practice creating models, reporting and interpreting their statistics, evaluating their significance, and using the models to make predictions.

Note: Begin working on the readings and the problem set early each week. This will help make sure that you are prepared for the weekly discussion.

Prompt

In this activity, you will explore a second order regression model that contains quantitative and qualitative variables. Then you will be asked to create your own second order regression models and write a mini-report based on your findings.

1. Access the R scripts for this problem set by using the Jupyter Notebook link in Module Three. In your Jupyter Notebook, you have been given a set of steps that explains how to create second order models with quantitative and qualitative variables. Go through each step, examining the scripts and their output. If you are not sure how a specific script works or how to understand the output of a script, review the readings. Reach out to your instructor if you need additional help.
2. Review the Module Three Problem Set Report template to understand the questions that you will need to answer for this assignment. Then, write your own scripts to create the models specified in your problem set report. Refer to the scripts that you were given as examples to guide your work.
3. Use the outputs of your scripts to answer all of the questions in your problem set report. The report has been divided into several sections. Each section contains questions to guide your analysis. Be sure to fully answer all of the questions and complete the following sections:
   • Introduction: Communicate all ideas by presenting the context of your analyses.
   • Correlation Analysis: Discuss the relationships between the variables using correlation coefficients.
   • Reporting Results: Report the results of the model by listing and interpreting various model statistics.
   • Evaluating Model Significance: Evaluate the significance of the model by reporting parameter estimates and performing hypothesis testing for each estimate and the overall model.
   • Making Predictions Using the Model: Make predictions based on the model by reporting prediction values and constructing prediction intervals and confidence intervals.
   • Conclusion: Communicate all ideas by summarizing and interpreting the practical implications of the results.

Guidelines for Submission

You will submit your completed problem set report as a Word document. Use 11-point Calibri font and one-inch margins. You must use the equation editor where appropriate.

You will also submit the HTML file containing the outputs of your R scripts from the Jupyter Notebook. Review the Jupyter Notebook in Codio Tutorial to help you with this task.

In this case study, you have been tasked with generating a loan approval workbook that will determine if an applicant is eligible for a personal loan and if so, what the loan rate should be based on a set of pre-defined criteria. The bank manager has created the basic layout of the application she wants to use but has asked you to provide the formulas that will drive the initial quote

Assignment 4: Machine Learning Model Evaluation 

• Three multi-part, multiple-choice questions.

•  AI in Healthcare with Phase 2 data set (HTML file)

• Details of the Q1 & Q2 m/c questions are shown in the attached question files.

• Lecture notes on Machine Learning in Healthcare for your reference

In DictVectorizer I have x-test, x-dev, x-test; what is x-dev? And how can I deal with it?

The key to this paper is to demonstrate your understanding of the topics, not to re-word the text or reference material. Paper must be 100% original and not plagiarized.

A) DISCUSS POSSIBLE RISK MITIGATION STRATEGIES BASED ON YOUR FINDINGS AND DISCUSSIONS IN CASE STUDY 1 & 2 (attached)
 

B) ENSURE YOUR REFERENCES PAGE CONTAINS AT LEAST 6 SOURCES.

GUIDELINES:

Running Size of your deliverable should include the 2 Pages of content for this phase, a title page, the references page

This submission should be created following APA 6th edition guidelines.

The paper is to follow the APA style guide, Sixth Edition