In this assignment, you will create a presentation for your organization to explain how successful collaboration can improve success and provide competitive advantages.

Scenario: Your organization has used a variety of collaboration systems developed by some project managers. Some of these systems were successful while others were not. Your organization has one unique challenge—many of your employees are staffed at other locations or work from home (telework). You would like to standardize the collaboration process to improve team communication for all company projects. In your presentation, you should include the elements listed below.

• Explain why collaboration information systems (IS) are important from the organization’s perspective.
• Discuss how collaboration tools can improve team communication.
• Identify three tools that will be used for synchronous communications and three tools that will be used for asynchronous communications. Be sure to explain why you made these choices.
• Describe how project files, such as Microsoft (MS) Word, MS Excel, MS Project, and MS Visio, will be shared with team members. Be sure to explain the rationale behind your choice.
• Explain how the task list for managing tasks will be shared with team members. Be sure to explain the rationale behind your choice.
• Discuss how this new collaboration IS could provide competitive advantages for your organization.

Your presentation should be a minimum of six slides in length (not counting the title and reference slides). Use of images, graphics, and diagrams is encouraged.

You can use an industry of your choosing or examples from your personal or professional experiences in developing this assignment. You can also use the resources in the Unit II Suggested Reading section to assist you with this assignment.

Be sure to follow the 7×7 rule (i.e., there should be no more than 7 words per line and no more than 7 lines per slide). You are required to use speaker notes to discuss the bullet points on your slides.

You must use at least two academic resources to support your presentation, and you must cite (in APA format) any information on your slides or in your speaker notes that came from these sources.

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

In this assignment, you will delve deeply into Structured Query Language (SQL) statements. You will review existing SQL statements and troubleshoot them. You would need to determine why the given statements are not functioning properly. At the conclusion of this assignment, you should be able to examine and troubleshoot basic SQL statements.

Scenario:

A good friend of yours is starting a fantasy football league and has created a small database to track the team owners, teams, players, and games. Your friend knows that you are taking a database fundamentals class and has asked you to help. Your friend is not able to figure out why the database is not getting modified in any way. Your friend has given you a copy of the following:

• A database schema diagram. Click here to access the database schema diagram.
• A Microsoft Access database. Click here to access the Microsoft Access database.
• http://vizedhtmlcontent.next.ecollege.com/pub/content/77d17d99-89f1-44c8-81e6-6291c94c294a/AU_IST351_Football_Team_Details.accdb
• The following list of what he or she is trying to do:     
  1. Add a new owner named Alice Wonderland with an owner ID of 1205 and a contact e-mail of
  2. INSERT INTO Owner VALUES (1205, ‘Wonderland’, ‘Alice’, ”) 
  3. Update player 323’s salary to $1,800,000
  4. UPDATE Player salary = 1800000 WHERE player_id = 323 
  5. Display all players whose salary is greater than $1,000,000
  6. SELECT FROM Player WHERE salary > 1000000 
  7. Delete owner Jerry Jones from the database
  8. DELETE FROM Owner last_name = “Jones” AND first_name = “Jerry” 
  9. Update game 0105 with the final score
  10. UPDATE Game SET home_score = 17,     visitors_score = 23 

Note: For this assignment, you will use Microsoft Access 2010 to open the database file provided. If you do not have Microsoft Access 2010, you may download a free trial version of Microsoft Office 2010, which includes Microsoft Access 2010, from the Microsoft website.

Tasks:

1. Open the Microsoft Access file “Football.accdb” by double-clicking on it. You will see the small database created for the fantasy football league.
2. Familiarize yourself with the database by opening and examining the data in each table.
3. There are two queries included with the database that will display some of the information contained in the tables. Double-click each of these to see the results of the query.

Once you are familiar with the database, proceed to the next section.

1. Examine and Correct the Faulty SQL Statements 
   1. For each SQL statement listed above, identify the SQL statement errors.
   2. Once you have identified the errors, rewrite the SQL statements so that they will work.

Note: Take special precautions with Statement 5 above. If you run the statement as it is written above, you will overwrite the scores of all of the existing games in the database.

1. Execute the Statements 
   1. On the Create tab, in the Queries group, click Query Design.
   2. When prompted to add tables, click the Close button.
   3. On the Query Tools Design tab, in the Results group, click on the down arrow below the word View and select SQL View. This is where you will compose your SQL statements. Feel free to type the statements above into the SQL View window and run them (see Step 4) to view the errors. (Note: Take special precautions with Statement 5 above. If you run the statement as it is written above, you will overwrite the scores of all of the existing games in the database.)
   4. To run your SQL statements against the database, click the Runbutton in the Results group. You will be prompted to confirm that you want to modify data in your database. Click Yes. Close the query and save it as “Statement n”, where n is the statement number listed above. For example, you will save the first statement as “Statement 1”.
   5. Repeat this process for each SQL statement provided above.
   6. Once you have completed correcting the SQL statements, save and exit the database.
   7. Save your database as M4_A2_Lastname_Firstname.accdb. 
2. Explain the SQL Statement Errors 
   1. Create a Microsoft Word document explaining what was wrong with each of the five originally written SQL statements. Include any additional comments that you might have about the statements. Save your document as M4_A2_Lastname_Firstname.doc.

Submission Details:

• Save your deliverables as M4_A2_Lastname_Firstname.zip.
• By Week 4, Day 7, submit both the files to the M4 Assignment 2 Dropbox.

Assignment 2 Grading CriteriaMaximum PointsCorrected the faulty SQL statements.40Explained the SQL statement errors.40Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources (i.e., APA); and displayed accurate spelling, grammar, and punctuation.20Total:100 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

In this assignment, you will discuss the important activities of leaders, and how they can be used to create and maintain high-performance organizations.Throughout this course, you are expected to bring the knowledge and skills you have gained from other courses in the MBA program into the Forum discussions.1.Identify four research sources that provide context for at least three activities of strategic leaders. At least two of these must be from your own research.2.Using the resources you have identified, describe specific characteristics of leaders and activities necessary to maintain a high-performance organization.3.Post your findings to the Forum by Tuesday of this week. Include citations and references (in proper APA style) for your sources.

Assignment GradingCourse: NameActivities of LeadersYour nameProfessor’s Name [optional]University Activities of leaders to create and maintain high performance organizationEntrepreneur: To…

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

In this assignment, you will evaluate the strengths and weaknesses of your communication based on your personal perceptions and the perceptions others have of you. Personal effectiveness begins with you and also includes views others may have of you as an individual. You will go beyond your personal viewpoint and seek feedback from others in order to achieve a more accurate understanding of self.

To prepare for this discussion, research effective communication using your textbook readings and the Argosy University online library resources. Reflect on your personal effectiveness as a communicator, and then interview two to four people to find out how others perceive your communication. Be ready for a discussion based on the following questions.

• Define what you consider to be your strengths as a communicator. Consider talking, listening, empathy, and so on.
• Discuss what you consider to be some important areas for improvement in your communication.
• Explain how different your personal perceptions of your strengths and weaknesses are compared to the perceptions others have of you.
• Distinguish what changes, if any, you would like to make in your communication style.
• How effective do you think you are when communicating with those of a different gender? Different culture?
• Formulate a plan as to how to improve your communication abilities and effectiveness with people different than yourself.

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

In this assignment, you will explore how interrogation is different from interviewing.

Scenario:

You work as a psychology professional for a metropolitan police department. Your primary job is to screen police officers for employment and emotional stability. You make recommendations about their suitability for employment, conduct interviews with police officers to determine whether they should be referred for counseling, and monitor their performance by dialogues with their superiors. You are recognized for your skills as a clinician, and you are asked to participate with a team of interrogators so they may become more proficient in obtaining confessions from suspects.

Compare the relationship of a psychology professional working with a suspect as a client with the relationship of a psychology professional working as a consultant to an interrogator.

Tasks:

In a minimum of 300 words, respond to the following:

• Part 1: Differentiate between interviewing and interrogation. What are the goals of interviewing and interrogation? In what instances would a psychology professional be involved in an interrogation?
• Part 2: Identify a context and setting for a forensic psychology professional to be involved in an interrogation. What would be your concerns in taking on the role of or assisting that forensic psychology professional?
• Part 3: Review the current version of the APA ethics code and the APA resolution on interrogations and identify an ethical principle that potentially conflicts with psychology professionals participating in interrogation. Discuss your choice in relation to the context and setting you identified in Part 2.

Use the current version of the APA ethics code; choose elements of the ethical principles to explore issues, such as “do not harm,” “informed consent,” “use of assessment techniques by unqualified persons,” and “resolving ethics code conflicts in an organization.” Explore the following issues in the context of the scenario above:

• Who is a psychology professional’s client?
• With whom does a psychology professional have a professional relationship?
• Do psychology professionals have any professional (as opposed to “moral”) obligations to suspects?

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"