Prejudice and Stereotyping

Prejudice and stereotyping seem to be part of the human condition, and it is essential to examine how attitudes develop in order to change our behavior as individuals and as a society.

Search for research articles on theories and concepts related to prejudice, stereotypes, and groups. For your assessment, apply at least one theory or concept to each of the following:

Examine how attitudes and behaviors of a group can contribute to prejudice and stereotyping.

Analyze how the portrayal of ethnic, cultural, or social groups by the media can influence social perception of those groups and perpetuate stereotypes. Provide specific examples of how a group has been portrayed in the media.

Explain how membership in a group can influence social judgment.

Analyze how subtle stereotyping in everyday language and cognitive dissonance can affect the ability to bring about social change. Provide specific examples.

Describe the types of ethical considerations researchers should consider before conducting research on the hotly debated topics of prejudice and stereotyping.
What are the implications and likely consequences for society if prejudice and stereotyping are not reduced?

Additional Requirements

Written communication: Should be free of errors that detract from the overall message.
APA formatting: References and citations are formatted according to current APA style guidelines.
Resources: Minimum of 34 scholarly or professional resources.
Length: 45 double-spaced pages, in addition to the title page and reference page.
Font and font size: Times New Roman, 12 point.

References

Baston, R., & Vosgerau, G. (2016). Implicit attitudes and implicit prejudices. Philosophical Psychology, 29(6), 889903. https://doi-org.library.capella.edu/10.1080/09515089.2016.1181260

Sonnett, J., Johnson, K. A., & Dolan, M. K. (2015). Priming Implicit Racism in Television News: Visual and Verbal Limitations on Diversity. Sociological Forum, 30(2), 328347. https://doi-org.library.capella.edu/10.1111/socf.12165

Othman, Z., & Hamid, F. Z. A. (2018). Dealing with un(expected) ethical dilemma: Experience from the field. The Qualitative Report, 23(4), 733-741. Retrieved from http://library.capella.edu/login?qurl=https%3A%2F%2Fsearch.proquest.com%2Fdocview%2F2036387747%3Facc

Reference and citation practice

BRIEFLY SUMMARIZE THE MAIN POINTS OF THE ARTICLE, BEING SURE TO APPROPRIATELY PARAPHRASE ANY INFORMATION YOU RELAY FROM THE ARTICLE (see the “References and citing” module if you need more information on appropriate paraphrasing). YOUR SUMMARY SHOULD BE APPROXIMATELY 250 WORDS IN LENGTH.

Whenever you use information from an outside source, you must indicate to your reader that the information did not come from your own head. We do this using some sort of in-text citation immediately following the information taken from a source. There are various ways of doing in-text citations. For this class, we’ll use a common style known as APA style, which simply involves placing the author’s name in parentheses followed by the year of publication. So, if the idea behind this sentence came from a source written by John Jones in 2010, it would be followed by an in-text citation (Jones, 2010). (See the “References and citing” module for more information on in-text citations using APA style, such as how to properly create in-text citations when there are multiple authors.)

3) INCLUDE IN-TEXT CITATIONS FOR AT LEAST 2 SENTENCES IN THE SUMMARY YOU WRITE. IN OTHER WORDS, IN YOUR SUMMARY YOU WILL PARAPHRASE INFORMATION FROM THE ARTICLE IN AT LEAST 2 SENTENCES, AND EACH OF THOSE SENTENCES SHOULD BE FOLLOWED BY AN IN-TEXT CITATION. Finally, provide a full reference for the source at the bottom of the page.

4) AT THE BOTTOM OF THE ASSIGNMENT PUT A FULL REFERENCE TO THE SOURCE. See the “References and citing” module for examples of how to do this.

ONE LAST POINT: YOU SHOULD NOT USE ANY DIRECT QUOTES FROM YOUR SOURCE IN THIS ASSIGNMENT OR ANY ASSIGNMENTS IN THIS CLASS. All of the writing you do for this class should be in your own words. Your work will be submitted through Turnitin, a plagiarism-checking website, to ensure it is your own.

https://pdf.sciencedirectassets.com/271821/1-s2.0-S0277953615X00165/1-s2.0-S0277953615300782/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjECMaCXVzLWVhc3QtMSJHMEUCID01Qpr7fGHplrpwttTj64iHjOtmJsjyuUf7fAZGmbkJAiEA9KVqjTxA%2F5CJYFiqylgFcTcH8u9s%2FiuT4c6RORkiV2sqtAMIfBADGgwwNTkwMDM1NDY4NjUiDOuY%2FUBWNXavk2c7tSqRAxMIFyoV9zjTQIdOANiZRnruwUR4VQ%2BFUgRXlYDyAjEYDcIkLO9M%2BVN%2BpYkb1TQkFj14w8AZqpFS3ns4llLbOqVMnloa5kFb%2FwIC1E90TZlw6tQ1%2F82W6vqp%2FUDHpYF7FOqFTc%2F1SWtQ4oXcK0Tr2EMq6a%2Bq4dpijQSFoMErih4eyMrpscEhr7tEULePV7dL3cCHGqKxrEsuNIJJkaDt6JzJR3cnUtixovCKYN3f0W6QFm6AaJ8Mx4pBBUl7aUq9NBUP5l5kdkFB6JJK9ekxpFRfze9lWw8a1OSoCgNBZZjQRw21EnQyhwakU8%2BphYsAcy44%2BuKbmw3Tlg%2BDj1XI3ew0GJ9rkqpHrtxfZgMM3vHUsUWgUNmzQsrzEnziBnaSKh%2FAEBrN2bikFBHBir86t%2B9UPgK1IbZm0paKtZztt59ztNP8lBDZhbUqa6yHubl4JUJIwzGTo9ft%2BMnPTuyGi7bsUvdRrDe73Wb09CXkfLOgLW7DsGpo1os4LLg%2B6emGUtbn5ZMtyRqaPo3z0lCAN1cRMKz4qvYFOusBporUi6G0%2FvQ26hML5FleT92lxpcgGqVFa5XKoVUFEYtWsaNC9SrHUsntkm%2ByZG5N1OU1f4c59gU6W%2Bdl9j71Z5G%2BViFl7EFunU5W0TKy%2BDew9mDvB%2BMdC8WTcqQwIKL45Fh0eVDXhHplMT%2FkIjvGNlbF3u8Q4jY0vxfdUsufdtN0ng4T8Cm9dngohfJt%2BSA9h3IpfMBEjKsIoX62%2BVCoYY3TGPVjgKWRweDDp2mKHdraFjpzZMhsusEcHy6srkwJMLxgTN4Sw5F0UZg93jCp8f%2BAWr8oKmVr4kU5yv9uSBDv9B8diQ96v6RuwQ%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20200524T193920Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTYQW27AD44%2F20200524%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=3220307f9f1252f481d2cfbde13774f638a7fb3b888204b099f01b0689ec1df9&hash=f7927e3b50554a495d6e6244ec3766073ba9fbbfc6d5507df96d63786d473f40&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=S0277953615300782&tid=spdf-7f1ab767-be7a-4e90-ad03-9650fbb7d7e2&sid=a9dc829082464545f14acf549e7ccf7d7a24gxrqa&type=client

The Sheltered Instruction Observation Protocol

You will write a paper explaining your understanding of the model following the outline provided.  This will be a 3-5 page paper not including the cover page or references.

You may use any resources you want but be sure to cite them in the reference section.  I have listed some for your convenience.

Here are some resources you  can use:

http://www.cal.org/siop/use/

https://prezi.com/gzwbjs3qf6ax/soip-model/

http://ngl.cengage.com/assets/downloads/ave_pro0000000320/am_short_siop_model_ells.pdf

http://hopemiddle.weebly.com/-8-components-of-siop.html

You can also use chapter 3 of the textbook Sheltered Content Instruction Teaching English Language Learners with Diverse Abilities 5th Edition

GIS Database Management Assignment 1

I only need questions 6 & 9 finished. As part of question 4, I used FME workbench to import the tables needed for question 6 & 9 (tblcity & tblstate) into Oracle SQL Developer. I’m supposed to do questions 6 & 9 in Oracle SQL Developer. So as long as I can copy & paste the code into Oracle SQL Developer later I will be fine!

Question 6: Write a PL/SQL stored procedure that receives the keyword ALL or the name of a city as a parameter.  When the keyword ALL is received, the procedure should display, with descriptive words, the proportion of the state population that lives in each city.  When the name of a city is received, the procedure should display, a) the proportion of the state population that lives in the city, and b) the states population density.  Use a single SELECT statement which joins the tables together either using a table join or a WHERE clause.  Include an exception section for when no records are returned, too many records are returned or when the state population is zero (division by zero).
Include a driving procedure (anonymous program block) that obtains the name of a city or the keyword ALL from the user and runs your stored procedure using the value obtained.

Question 9: Create a table DBMonitor to audit insertion, update and deletion operations on the tblCity table. DBMonitor has the following columns: transaction date, user performing the transaction, transaction type, old value, new value, table name, transaction type number. 
Write a PL/SQL stored function that receives the transaction type (insert, update or delete) as a parameter and returns the number of transactions in the DBMonitor table of the transaction type received.
When a record is inserted or updated or deleted, insert a record into the DBMonitor table.  The record must record information for all of the columns in the DBMonitor table: transaction date, user performing the transaction, transaction type, old value, new value, table name and transaction type number. The transaction type number is the number of transactions in the DBMonitor table of the type that caused the trigger to run.  For example, if the transaction that caused the trigger to run is the fourth insert transaction, then the transaction type number should be 4.  Use the stored function to obtain the number of transactions in the DBMonitor table of the type that caused the trigger to run. 
For the two old and new value columns in DBMonitor, make sure that you record all the column names with their old or new values.  Dont create a separate old and new value column in DBMonitor for each column. 
Only one row is inserted into DBMonitor for each affected row when the trigger fires, no matter how many columns are modified. 
Hint:  A useful keyword for this question is:  USER 
Include a driving procedure (anonymous program block) that tests insertion, update and a deletion operations on the tblCity table.