Question: What is artificial intelligence and can humans co-exist with it?Review the Podcast instruction Guide in the General above to create your Podcast discussion or review these instructions using Audacity:

Audacity is a free, open-source, cross-platform software for recording and editing sounds. It is available for both Windows, Mac, GNU/Linux, and other operating systems.

Initial Discussion: 300 words

Responses 4 : Each 300 Words 

You are the web master for the Republican Party National Committee. Prepare a risk assessment analysis for your website. Some questions to consider:

• Who is likely to attack your site?
• When are attacks likely to occur?
• What sort of attacks might take place?
• How can you best minimize attacks and protect the integrity of your site?

Write between 200-300 words. 

PERFORMANCE ASSESSMENT FORM

Employee: Tim Cox Department: Online Auctions Specialist

Introduction: This assessment instrument is intended to provide the employee with feedback concerning both general and specific professional skills and competencies. You are asked to be objective and candid in your assessment and to discuss it with the intern. Assessment ratings range from 1 to 5 as follows:

1 Unsatisfactory (Never demonstrates this ability/does not meet expectations)

2 Uncomplimentary (Seldom demonstrates this ability/rarely meets expectations)

3 Fair (Sometimes demonstrates this ability/meets expectations)

4 Commendable (Usually demonstrates this ability/sometimes exceeds expectations)

5 Exceptional (Always demonstrates this ability/consistently exceeds expectations)

If any criteria are not applicable to this performance evaluation, please leave the response blank.

Please do not feel compelled to write comments in each section.

A. Ability to Learn

1. Observes and/or pays attention to others 1 2 3 X 5

2. Asks pertinent and purposeful questions 1 2 3 X 5

3. Seeks out and utilizes appropriate resources 1 2 X 4 5

4. Accepts responsibility for mistakes and learns from experiences 1 2 3 X 5

5. Open to new experiences; takes appropriate risks 1 2 3 X 5

Comments:

You could improve by asking for assistance a little more quickly. It is OK to admit you do not know how to do something

B. Reading/Writing/Computation Skills

1. Reads/comprehends/follows written materials 1 2 3 X 5

2. Communicates ideas and concepts clearly in writing 1 2 3 4 X

3. Works with mathematical procedures appropriate to the job 1 2 3 X 5

Comments:

Please keep up the good work!

C. Listening & Oral Communication Skills

1. Listens to others in an active and attentive manner 1 2 3 X 5

2. Comprehends and follows verbal instructions 1 2 3 X 5

3. Effectively participates in meetings or group settings 1 2 3 4 X

4. Demonstrates effective verbal communication skills 1 2 3 4 X

Comments:

Great!

D. Creative Thinking & Problem Solving Skills

1. Seeks to comprehend and understand the “big picture” 1 2 3 4 5

2. Breaks down complex tasks/problems into manageable pieces 1 2 3 4 5

3. Brainstorms/develops options and ideas 1 2 3 4 5

4. Respects input and ideas from other sources and people 1 2 3 4 5

5. Demonstrates an analytical capacity 1 2 3 4 5

Comments:

NA

In the document

Possible topics to use:

     Bits,   binary numbers, hexadecimals, basic Python arithmetic   File types and   running Python scripts, variables, Input function, Strings, Ints,   Floats, Type and type conversion   List and   tuples   Booleans and   conditionals   The   if/elif/else block   The range   function, for loops, while loops, nested loops   Loops and   conditionals, break and continue, list comprehension   List   comprehension continued, Functions, return, global variables   Math module,   random module   Dictionaries   String methods   and print formatting   Reading text   files   Writing and   appending to text files     More on text   files   Command line   arguments   The time   module, datetime module, timing functions   Recursive   functions   Modules in   Python   The re module   The tkinter   module   More on the   tkinter module   The numpy   module   The os module   The csv module   The json   module  The matplotlib   module   More on the   matplotlib module   HTML   More on HTML      Introduction   to object-oriented programming   Classes,   objects, and method   Encapsulation,   inheritance, overloading/polymorphism   More examples   of OOP, built-in classes and methods   Exception   handling with try/except blocks   Raise and   assert   Iterables and   map/reduce/filter/zip, lambda   Javascript,   jQuery, CSS, and PHP   Review    

Now that you have successfully completed the database design for NCAA the challenge is to implement this database. The chosen DBMS is Oracle 11G. 

1. Use the enclosed recommended relational table design. Complete logical and physical design of the Database consisting of following. 

o For each of the table determine the appropriate integrity constraints consisting of following. 

o Appropriate Data Types and size for each attributes 

o Attributes requiring values (not null) and possible default values 

o Attributes requiring constraint (do not define too many constraint) 

o Define Referential Integrity using foreign keys 

§ Whether Null values are allowed in foreign keys 

o Based on the above complete design of base tables 

o Submit this design as a word document justying your design. 

2. Using SQL on Oracle creates all the above tables. Implement the constraints (decided above) if supported by ORACLE. Use the same table name and column name as given in enclosed design. (You must submit a text file of create table statements). 

3. Enter enough (at least 10 rows) sample data in each tables either through insert commands or through SQL Developer. Remember to enter valid data in terms of constraints and referential integrity. 

Hints: 

Avoid using on delete cascade. Use the default of set to null. 

Remember to create tables with no foreign keys first. Also enter data into them first. 

A Recommended Design: 

CONFERENCE (CONFERENCE_ID, CONFERENCE_NAME) 

CONF-STATISTICS (CONFERENCE_ID, YEAR, WINNING_PCT, AVG_ATTENDANCE, RECRUITING_INCIDENT_COUNT) 

SCHOOL (SCHOOL_ID, SCHOOL_NAME, S_ADDRESS, S_CITY, S_STATE, S_ZIP, CONFERENCE_ID) 

SCHOOL_DATA (SCHOOL_ID, YEAR, INSTATE_PLAYERS, OUTSTATE_PLAYERS, TOTAL_SCHOLARSHIP, TOTAL_GRADUATES, PERCENTAGE_GRADUATED) 

STADIUM (STADIUM_ID, STADIUM_LOCATION, STADIUM_SIZE, STADIUM_NAME, AVG_TICKET_PRICE, SCHOOL_ID) 

TEAM (TEAM_ID, TEAM_NAME, NO_GAMES_WON, NO_GAMES_LOST, RANK, SCHOOL_ID) 

HIGH-SCHOOL (HIGH_SCHOOL_ID, HIGH_SCHOOL_NAME, NO_ACTIVE_ATHLETES) 

PLAYER (PLAYER_ID, PLAYER_NAME, YEAR_ENTERED, SCHOLARSHIP_COUNT, RATING, STATUS, GPA, YEAR_ENTERED, TEAM_ID, SCHOOL_ID, POSITION, HIGH-SCHOOL_ID) 

INJURY (INJURY_CODE, INJURY_DESC) 

PLAYER_INJURY (PLAYER_ID, INJURY_CODE, GAME_ID, INJURY_DATE) 

COACH (COACH_ID, COACH_NAME, CURRENT_TITLE, SALARY, BEGIN_DATE, TEAM_ID) 

COACH_EMP_HISTORY (COACH_ID, TEAM_ID, FROM_DATE, TO_DATE, JOB_TITLE, SALARY) 

RECRUITMENT_ INCIDENT (INCIDENT_ID, TEAM_ID, PLAYER_ID, INCIDENT_DATE, INCIDENT_CODE) 

INCIDENT (INCIDENT_ID, INCIDENT-DESC) 

COURSE (COURSE_ID, SCHOOL_ID, COURSE-NAME) 

PLAYER-COURSE (PLAYER_ID, COURSE_ID, SCHOOL_ID, GRADE) 

GAME (GAME_ID, SCORE-DIFF, GAME-DATE, ATTENDANCE, START-TIME, TEAM1_SCORE, TEAM2-SCORE, TEAM1-INJURY-COUNT, TEAM2-INJURY-COUNT, TEAM1-ID, TEAM2-ID, STADIUM-ID)

Now that you have successfully completed the implementation of the NCAA database, created tables in ORACLE and loaded sample data the challenge is to write queries, reports and make the database easier to use by creating views, functions and stored procedures. 

1. Create following views: 

a. List of players as shown in figure 6-4 of the case study. 

b. A view providing Team name, percentage of games won, percentage of games lost. 

c. A view providing school-id, school name, year, ratio of out of state player to instate playes, number of players that did not graduate. 

d. Run query select * from view_name for each of the above views to display data. 

2. Write SQL to support following reports given in the case study. You can use views created above. 

Fig. 6-1, Fig. 6-7, Fig. 6-10, Fig. 6-11, Fig. 6-12, Fig. 6-14, Fig. 6-15 

3. Create following stored procedures 

a. Find game played at a particular stadium that had maximum total number of enjuries (using stadium_id as input), display id’s of two teams, date, attendence, score differencial, and total number of injuries. 

4. Create functions for following 

a. Function to compute average attendace for home games (assume team 1 is the home team) played by a school (school id as input). 

Students will choose a topic relevant to CyberSecurity and submit it for approval then write a 2-3 page research paper. Your paper must be typed using MLA Documentation Style. Your paper must be in 12 size Font and double space. Your paper should have at least 2-3 references including at least one reference from the textbook, newspaper, or some other source other than the Internet. If you are using Internet resources make sure your Internet resources are reliable. Any information or opinion in your written work that is derived from, or quoted directly or indirectly from a primary or secondary source (including the Internet), must be correctly cited in a footnote, or endnote. Failure to cite your source of information is called plagiarism and carries the consequence not only of a failing grade on the Term Paper but also the possibility of failing the course and of expulsion from the university. Send a Course Message or Email to your Professor with the chosen topic. 

Examples of Topics to choose from (not limited to this list):

1. Cybersecurity of biometric authentication

  Download and read the document and answer all questions in the document. Please see attached document H6 & APA Criteria doc.    

It is so important to have good communication with a project’s stakeholders.

• What happens if the project manager and team maintain clear      current communication with the key stakeholders?
• What can happen if the project manager and team have poor and      sparse communication with the key stakeholders?

Project Time and Cost Management: Running Case

Complete the two tasks associated with project time management and the three tasks associated with project cost management. (…total of five tasks) Put all your work on one word document. Separate your tasks by headings and/or page inserts. Remember… turn your work in on a word document as ONE attachment for grading.

***Note: This is a continuation of the running case started in week three and continues through the rest of the course. Tasks based on this case are explained following the case study. These tasks will build on work done in previous weeks.

Project Time Management: Case Study

Tony Prince is the project manager for the Recreation and Wellness Intranet Project. Team members include you, a programmer/analyst and aspiring project manager; Patrick, a network specialist; Nancy, a business analyst; and Bonnie, another programmer/analyst. Other people are supporting the project from other departments, including Yusaff from human resources and Cassandra from finance. Assume that these are the only people who can be assigned and charged to work on project activities. Recall that your schedule and cost goals are to complete the project in six months for under $200,000.

Project Time Management: Assignment (2 Tasks)

Review the WBS and Gantt chart you created previously. Propose three to five additional activities that would help you estimate resources and durations. Now, identify at least eight milestones for the Recreation and Wellness Intranet Project. Remember that milestones normally have no duration, so you must have tasks that will lead to completing the milestone. Add your activities and milestones to your Gantt chart, creating a new Gantt chart. Estimate the task durations and enter dependencies as appropriate. Remember that your schedule goal for the project is six months. Copy the Gantt chart and network diagram to a word document.

After your Gantt chart and network diagram, summarize how you would assign people to each activity. Include a table or matrix listing how many hours each person would work on each task. These resource assignments should make sense given the duration estimates you made. Remember that duration estimates are not the same as effort estimates because they include elapsed time.

Project Cost Management: Case Study

Tony Prince and his team are working on the Recreation and Wellness Intranet Project. They have been asked to refine the existing cost estimate for the project so they can evaluate supplier bids and have a solid cost baseline for evaluating project performance. Recall that your schedule and cost goals are to complete the project in six months for under $200,000.

Project Cost Management: Assignment (3 Tasks)

Prepare a one-page cost model for the project described in the Running Case, similar to the model below:

Types of Cost Estimates

Type of Estimate

When Done

Why Done

How Accurate

Rought order of magnitude (ROM)

Very early in the projec tlife cycle, often 3–5 years before project completion

Provides estimate of cost for selection decisions

−50% to +100%

Budgetary

Early, 1–2 years out

Puts dollars in the budget plans

−10% to +25%

Definitive

Later in the project, less than 1 year out

Provides details for purchases, estimates actual costs

−5% to +10%

Source: TABLE 7-2 Types of cost estimates © Cengage Learning 2014

Use the following WBS, and be sure to document your assumptions in preparing the cost model. Assume a labor rate of $100/hour for the project manager and $60/hour for other project team members. Assume that none of the work is outsourced, labor costs for users are not included, and there are no additional hardware costs. The total estimate should be $200,000.

a.  Project management

b.  Requirements definition

c.  Web site design

o  Registration for recreational programs

o  Registration for classes and programs

o  Tracking system

o  Incentive system

d.  Web site development

o  Registration for recreational programs

o  Registration for classes and programs

o  Tracking system

o  Incentive system

e.  Testing

f.  Training, rollout, and support

Using this cost model you created, prepare a cost baseline by allocating the costs by WBS for each month of the project.

Assume that you have completed three months of the project. The BAC was $200,000 for this six-month project. You can also make the following assumptions:

PV = $120,000
EV = $100,000
AC = $90,000

a.  What is the cost variance, schedule variance, cost performance index (CPI), and schedule performance index (SPI) for the project?

b.  How is the project doing? Is it ahead of schedule or behind schedule? Is it under budget or over budget?

For this assignment, you will learn to create, sort and filter an Excel table.

Melanie Castillo, Product Manager for Rosedale Landscape and Garden, has requested a worksheet that summarizes the current palm tree inventory data. Melanie would like the worksheet to include the total Quantity in Stock and Total amount of Sales by Type, and she would like the items to be sorted from lowest to highest retail price using custom sort. She would also like the Total amount of all Sales, with a Funnel Chart created.

You will do the following:

· Edit the file e02L_Palms file (see Project 3B files) to provide Melanie with the information requested, and use the Table feature to find the data requested.

· Format the worksheet titles and data and include an appropriately formatted table so that the worksheet is professional and easy to read and understand.

Insert a footer with the file name, and add appropriate document properties.