Before the arrival of Europeans, Native Americans in the New World had no knowledge of Christianity, just as Europeans had no knowledge of Native American religions. To what extent did contrasting religious beliefs and assumptions influence relations among Europeans and Native Americans in the New World in the sixteenth century?
TA2: Preparation assignment for Decision Support
The goal of this assignment is to prepare you for completing the next tutorial assignment (#3) on pivot tables and decision support as assigned by your instructor.
This assignment itself is fairly easy. You are essentially going to do Exercise #3 (“Filtering SecureIT data”) on pages 14 & 15 of Plug-in module T3 (“Problem Solving
Using Excel 2013”) – HOWEVER you will complete this with some required enhancements to the assignment, as specified below.
You will complete this exercise with several adjustments:
As you do parts 1 through 5, you will label each worksheet as per the specifications listed below
Two additional parts on Pivot tables have been added as an additional challenge, also to be listed in labeled worksheets
Before submission, you will arrange the worksheets in a specific sequence that has been listed below.
In completing this problem, you will need to know to reorder and rename worksheets within your spreadsheet file and how to insert and delete new worksheets. If you
feel unskilled or rusty with these skills in MS Excel, we suggest that you review Plug-in T2 and/or your course materials for MIS 100 (or just look this up online or
in the University library resource of Lynda.com).
Obviously, you should read through this Plug-in T3 carefully PRIOR TO attempting this assignment and you should work through the examples provided. To assist you in
working through the examples in the Plug-in modules, here is a link to download T3_ProblemSolving_Data, the spreadsheet file that provides the examples used for
illustration on this module.
When you are done, you will submit the spreadsheet file (containing the appropriately labeled and ordered worksheets) by uploading it to the appropriate dropbox.
Open up the T3_Employee_Data spreadsheet file that I have posted here. Save this spreadsheet on your computer under the following name: firstname_lastname_TA2 (where
firstname is your first name & lastname is your last name).
Turn to problem #3 (“Filtering SecureIT data”) on pages 14 & 15 of plug-in module T3.
First do part 1. Do this by copying the data from the source worksheet (“employee data”) into a new worksheet that you will label “Sort”. Perform the required data
sorting operation on the list as specified in part 1 of this exercise (i.e. sorted by last name and hire date). After you have done this, rename the worksheet “Sort”.
Next do part 2. Do this by copying the data from the source worksheet (“employee data”) into a new worksheet that you will label “custom sort”. Perform the required
data sorting operation on the list as specified in part 2 of this exercise (i.e. using the custom list sorting parameter of Marketing, Human Resources, Management, and
Engineering). After you have done this, rename the worksheet “Custom Sort”.
Next do part 3. Do this by copying the data from the source worksheet (“employee data”) into a new worksheet that you will label “filter”. Perform the required
filtering operation on the list as specified in part 3 of this exercise (i.e. using a filter to display only those employees in the Engineering department with a
clearance of Top Secret). After you have done this, rename the worksheet “Filter”.
Next do part 4. Do this by copying the data from the source worksheet (“employee data”) into a new worksheet that you will label “custom filter”. Perform the required
filtering operation on the list as specified in part 3 of this exercise (i.e. using a custom display only those employees born between 1960 & 1969, inclusive [HINT:
Think of >= and <=], as well as when the dates when a year begins & ends] ). After you have done this, rename the worksheet “Custom Filter”.
Next do part 5. You will create a pivot table which totals salaries by department. When creating this Pivot table, choose the option to insert the pivot table into
into a new worksheet. After you have created an appropriate pivot table, name the worksheet “SumSalary”.
PART 6 (ASSIGNMENT ADDITION #1): Create a Pivot table that tabulates the number of employees by department & gender. Name the worksheet for this “Employees by
DeptGender”. HINT: What data element do you need to COUNT in order to generate this pivot table? It would obviously have to be a data element whose value was
different (unique, like a database table key) for every row in the table in order to insure an appropriate tabulation of employees by department). After you have
created this pivot table, name the worksheet “Employees by DeptGender”.
PART 7 (ASSIGNMENT ADDITION #2): Finally, go back to the worksheet named “Employees by DeptGender”. Find the cell that displays the number of female employees in the
management department. Click on this to reveal the audit trail of raw data (employee records) that was used in calculating this tally. Use conditional formatting to
display in red (or brown) the hire dates of those female employees in management who were hired after 1/1/1993. Rename the worksheet upon which this audit trail has
appeared “Data: Fs in Mgmt”.
Finally, you must re-order your worksheets in the following sequence and titles (and eliminate any extra work sheets that are not needed!):
Employee Data (i.e. the raw data you started with)
Employees by DeptGender
Data: Fs in Mgmt
Save your work (probably a good idea after completing each step)!
"Are you looking for this answer? We can Help click Order Now"
PSY150 Exam #4, Spring 2017 Your name:
This is an open book, open notes exam but you are honor bound to complete it without consulting with anyone nor using any internet sources apart from our course website. You may take as much time as you wish. There are 20 questions, each worth 5 points. Email the entire exam (not just your answers) to me email@example.com as a Word file (not PDF, not WordPad) when you’ve finished it, but no later than 5PM Wednesday June 14.
- The associated effect that emotions have on attraction can best be explained by _____. A) classical conditioning B) the direct effect C) nonconscious stereotyping D) observational learning
- The observation that repeated exposure to a new stimulus results in increasingly positive evaluations of the stimulus is known as _____. A) the proportion of familiarity B) the affect-centered model of attraction C) the attitude familiarity effect D) the mere exposure effect
- People who share similar attitudes and beliefs are _____ to like each other. A) less likely B) unlikely C) more likely D) neither more nor less likely
- Researchers have digitally combined multiple faces to create a composite image. This ÊºaveragedÊº face is typically rated as _____. A) average in terms of attractiveness B) less attractive than the faces used to create it C) unrecognizable D) more attractive than the faces used to create it
- The motive to increase another’s welfare without conscious regard for one’s self-interests defines
- the social responsibility norm b. egoism. c. social exchange theory. d. altruism.
- The negative state relief model holds that people are less likely to help those they view negatively. a. True b. False
- Darley and Latané describe a sequence of decisions a bystander must make before he or she will intervene in an emergency. Which of the following is NOT one of the specific steps?
- noticing the incident
- interpreting the incident as an emergency
- deciding the person is similar to the bystander
- assuming personal responsibility for intervening
- Bystanders who notice but fail to respond to someone in need in an emergency because they believe someone else will handle it are experiencing
- pluralistic ignorance
- diffusion of responsibility
- selective altruism
- Bystanders who notice an emergency and notice no one else is responding may rely on the judgment of those others about what is taking place. This is a manifestation of
- pluralistic ignorance
- diffusion of responsibility
- selective altruism
- A bystander may ultimately decide not to help in an emergency situation if
- the bystander believes the person who needs help is not responsible for the situation
- the person who needs help is similar to the bystander
- the bystander likes the person who needs help
- the bystander fears potential negative consequences of helping
- The notion that we help others in our family or clan more than we help strangers because we want to assure the continuation of our gene pool is called
- kinship altruism
- empathic altruism
- negative state relief
- A New York city cabdriver once intervened and stopped what he perceived to be a mugging in progress. It actually was a group of actors performing a scene for a television show. The taxi driver probably intervened due to
- desire for fame
- his being a New Yorker
- negative state relief
- the absence of the bystander effect
Match the descriptions with the terms below. There’s only one best match for each.
_____ 14. Intimacy, passion, commitment
_____ 15. After exposure to many beautiful faces, the face of our beloved may seem less attractive
_____ 16. We like and agree with someone
_____ 17. We like and disagree with someone
_____ 18. High self-esteem and high trust
_____ 19. Depression in either self-esteem or trust
_____ 20. Most people tend to form a couple with someone close to them in looks
- Insecure attachment
- Matching hypothesis
- Secure attachment
- Contrast effect
- Consummate love