Description
Define the roles of city
managers and mayors.
Your response should be at least 75 words in length. APA Format
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Attached.
Running Head: ROLES OF CITY MANAGERS AND MAYORS
Roles of City Managers and Mayors
Name
Instructor
Course
Date
1
ROLES OF CITY MANAGERS AND MAYORS
The City Managers and Mayors
A city manager is responsible for complete administration of municipal affairs. He/she
supervises all the da...
Completion Status:
100%
Review
Review
Anonymous
I was struggling with this subject, and this helped me a ton!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
Music 101 Joliet Junior College Live Concert Report
Listening to live performances is an essential part of learning to ...
Music 101 Joliet Junior College Live Concert Report
Listening to live performances is an essential part of learning to appreciate and understand music. As you know seeing a live concert at this time is not an option. I have listed several links below to concerts that you can watch online that will count for your report if you have not already completed it.
Write a two-page report describing your experience and the music you heard.
https://www.youtube.com/watch?v=syLm-9JyhuY&t=64s (Links to an external site.)
https://www.youtube.com/watch?v=w_E4t13N3Yk (Links to an external site.)
https://www.youtube.com/watch?v=YUj_GAKWziE (Links to an external site.)
https://www.youtube.com/watch?v=w2JBT0HC98I (Links to an external site.)
philosophy 211 GRATIFICATION ACCOUNTS
Blackburn is so interested in suggesting that gratification accounts of
happiness are mistaken that its easy to forget w ...
philosophy 211 GRATIFICATION ACCOUNTS
Blackburn is so interested in suggesting that gratification accounts of
happiness are mistaken that its easy to forget what stands in their
favor. What is appealing about thinking about happiness in terms of
pleasure or gratification?
Program or Policy Initiation Plan Paper
Program or Policy Initiation PlanThe seventh stage of planned change—Initiating the Program or Policy Plan—focuses on ...
Program or Policy Initiation Plan Paper
Program or Policy Initiation PlanThe seventh stage of planned change—Initiating the Program or Policy Plan—focuses on weaknesses of the first six stages of planned change. It is critical for the planner to review the first six stages in order to ensure a greater chance of success.This week you will prepare a report in Microsoft Word reviewing the implementation of your program or policy. You will then evaluate outcomes. This report is to be presented to an audience that includes members of the Center for Justice, the Mayor of Fictionland, and the Chief of Police. The report should include the following elements:Part I: Compilation of previous steps, with additional detail:A summary of the problem-solving technique employed.A list of two potential sources contributing to the problem. Also argue why you believe these factors are responsible for the community-police problem(s) in Fictionland.A summary of the newly created goal(s) and objective(s).A detailed explanation of the program or policy adapted.An action plan.Tools used to conduct a process evaluation.Tools used to conduct an outcome evaluation.Conclusion to the program or policy implementation and outcome.Part II: Create measures for evaluation of the design and objectives of your program or policy for the Fictionland Police Department. Include the following points in your report:Considering the objectives that you created in a previous assignment, create two measures to evaluate the effectiveness of your program or policy for every objective.Include a statement as to why these measures are valid measures.
use the Word file in the zip file for Instructions and do the work in the Access file
use the zip files to do the work Project Description:In this project, you will apply skills you practiced from the Obj ...
use the Word file in the zip file for Instructions and do the work in the Access file
use the zip files to do the work Project Description:In this project, you will apply skills you practiced from the Objectives in Access Chapters 1 through 3. You will create a database for Gina Gomez, Sales Manager, that contains inventory and supplier information. In addition, you will create queries that answer specific questions relating to the inventory items and suppliers, forms for entering and updating information, and reports. Steps to Perform: Step Instructions Points Possible 1 Start Access. Download, open, and save the database named go_acc_grader_capstone2_Supplier_Data.accdb. 0 2 Open the Cap2 Inventory table in Design View. Rename the ID field to Item ID and change the Data Type to Short Text. Continue adding the following fields as Short Text except for Cost, which should have a Currency Data Type, and Quantity, which should have a Number Data Type: Item Name Department Cost Quantity Supplier ID 7 3 Switch to Datasheet view. Enter the following two records into Cap2 Inventory: Item ID: H102 Item Name: Hair Brush Set Department: Hair Care Cost: 9.99 Quantity: 92 Supplier ID: S-186 Item ID: M089 Item Name: Pedicure Kit Department: Hands & Feet Cost: 22.59 Quantity: 71 Supplier ID: S-133 5 4 Close the table. Append a copy of the records from the downloaded aCap2_Inventory.xlsx workbook to the Cap2 Inventory table. Accept all defaults in the wizard and do not save the Import steps. Open the table, verify there are 24 records, and apply Best Fit to all fields. Save and close the table. 4 5 Import the source data from the downloaded aCap2_Suppliers.xlsx workbook into a new table in the current database. In the wizard, click the First Row Contains Column Headings option and set the primary key to Supplier ID. Name the table Cap2 Suppliers. 6 6 Open the Cap2 Suppliers table in Design view. Delete the Office Manager field and save the table. Switch to Datasheet view and apply Best Fit to all of the fields. Save and close the table. 4 7 On the Navigation Pane, group the objects by Tables and Related Views. 2 8 Create a relationship between the two tables in the database using Supplier ID as the common field. Enforce Referential Integrity and select both Cascade options. One supplier can supply many inventory items. 6 9 Create a relationship report. Save the report with Relationships as the name. Close the Relationships window. 4 10 Create a query in Design view, using your Cap2 Inventory table to answer the question, What is the item name (in alphabetical order), Cost, and Quantity for the department of Hair Care? Do not display the Department field in the query results.Run the query, save it as Cap2 Hair Care Query, then close the query. Three records match the criteria. 6 11 Create a copy of Cap2 Hair Care Query named Cap2 Hair Care or Easy Wear Query. Redesign the query design to answer the question, What is the department, item name, cost, and supplier ID where the department is hair care or easy wear? Arrange the fields in the order in which they're mentioned in the question. Sort the records first in ascending order by Department and then in ascending order by Item Name. Run and then close the query. Seven records match the criteria. 6 12 Create a query in Design view, using both tables to answer the question, What is the department, supplier name, item name, and phone, for a supplier name that begins with the letter B for the department of bath? Add the fields in that order. Sort the records first in ascending order by the Supplier Name field and then in ascending order by the Item Name field. Run the query, save it as Cap2 Wildcard Department Query, and then close it. Seven records match the criteria. 6 13 Create a query in Query Design view, using your Cap2 Suppliers table and your Cap2 Inventory table to answer the question, What is the supplier name, item name, department, and cost (in that order) for items that have a cost of $25 or greater? sorted first in ascending order by department and then in descending order by Cost? Six records match the criteria. Save the query as Cap2 Cost $25 or More Query and close it. 6 14 Create a query in Design view, using the Cap2 Inventory table to answer the question: For Supplier ID S-186, for each Item Name, if the Markup is calculated as 62% of Cost, then what is the Selling Price if Cost and Markup are added together? Add the Supplier ID, Item Name, and Cost fields (in that order), then create the calculated fields. Name the first calculated field Markup and name the second calculated field Selling Price. Run the query and apply Best Fit to all of the fields. All numeric fields should be formatted as Currency, 2 Decimal Places. Save the query as Cap2 Markup Query and close it. 6 15 Use the Query Wizard to create a crosstab query using the Cap2 Inventory table. Set the Supplier ID field as the row headings, and set the Department field as the column headings. Sum the Quantity field, and do not include row sums. Name the query Cap2 Crosstab Query and then finish the query. Run the query and apply Best Fit to all of the fields. Save and close the query. 7 16 Create a query in Design view using the Cap2 Inventory table that prompts you to enter the Department, and then answers the question, What is the department, item name, and Cost for inventory items, sorted first in ascending order by Department and then in ascending order by the item name? Add the fields in that order. The query should prompt an individual to Enter the Department. Run the query, and type Face & Neck when prompted for the criteria. Five records match the criteria. Save the query as Cap2 Parameter Query and close it. 7 17 Based on the Cap2 Suppliers table, use the Form tool to create a form. Switch to Form view, and then using the form, add a new record as follows: Supplier ID: S-152 Supplier Name: Springfield Supply Co. Address: 146 Lincoln Drive City: Springfield State: IL Postal Code: 62707 Phone: (217) 555-2543 Use the Filter By Form tool to create a filter that displays records with a State of IL or TX. After verifying that three records match this criteria, toggle the filter to display all 6 records. Save the form as Cap2 Supplier Form and close it. 7 18 Based on your Cap2 Suppliers table, use the Report tool to create a new report. Delete the following fields from the report: Supplier ID, Address, City, State, and Postal Code. Delete the Page Number control. Apply the Gallery theme to this object only. Sort the Supplier Name field in ascending order. For the Phone field, change the Width property to 1.25. For the Supplier Name field, change the Left property to 1 and then close the Property Sheet. Save the report as Cap2 Suppliers Report and then close the report. 5 19 Use the Report Wizard to create a report based on the Cap2 Inventory table. Add the following fields to the report: Department, Item Name, and Quantity, in that order. Group by the Department field. Sort in ascending order by the Item Name field. Find the Sum of the Quantity field. Be sure that the Layout is Stepped and that the Orientation is Portrait. For the report title, type Cap2 Inventory by Department Report and then switch to Layout view. Delete the controls that begin with Summary for 'Department'. Under Item Name, click any text box control, and then set the Width property to 2.5. For the Quantity label control, set the Left property to 6.5. Save and close the report. 6 20 Close all database objects. Open the Navigation Pane. Close the database and then exit Access. Submit the database as directed. 0 Total Points 100
Walden Week 3 Social Issues that Become Social Movements Paper
Week 3: Implementing and Sustaining Social ResponsibilityConsider the personal stories Loeb (2010) has shared about Virgin ...
Walden Week 3 Social Issues that Become Social Movements Paper
Week 3: Implementing and Sustaining Social ResponsibilityConsider the personal stories Loeb (2010) has shared about Virginia Ramirez, Julius Davis, and Alison Smith. Ramirez was enraged when an elderly woman died because her home did not have heat; Davis was awakened from discouragement after accidental exposure to a Malcolm X speech; and Smith witnessed unethical environmental practices in her neighborhood. Each event sparked something in these individuals to move them from emotion to action.As you reflect on these stories and on your own experiences, pay attention to what sets apart the people who talk about things they care about and the people who act on them. Moreover, while it is one thing to take action one time, what goes into making sure that such socially responsible actions continue?This week, you explore social issues that become social movements, and examine the factors that contribute to a social movement’s sustainability. You also conduct further research on your social issue topic, and write a literature review focused on potential solutions to this issue.Learning ObjectivesStudents will:
Analyze commonalities in implementing social movements
Analyze the sustainability of social movements
Analyze multiple perspectives on a topic
Write a literature reviewLearning Resources
Note: To access this week’s required library resources, please click on the link to the Course Readings List, found in the Course Materials section of your Syllabus.
Required Readings
Loeb, P. R. (2010). Soul of a citizen: Living with conviction in challenging times (rev. ed.). New York, NY: St. Martin's Griffin.
Chapter 5, “Unforeseen Fruits” (pp. 105–124)
Chapter 6, “The Call of Stories” (pp. 125–160)
Chapter 7, “Values, Work, and Family” (pp. 161–194)
Black, K. (2007). Considerations in writing a literature review. New Social Worker, 14(2), 12-13.
Retrieved from the Walden Library databases.
Walden University Writing Center. (2015). Common course assignments: Literature reviews. Retrieved from http://academicguides.waldenu.edu/writingcenter/as...
Document: Sample Literature Review (Word document)
Document: Course Project Overview and Guidelines (Word document)
Required Media
Laureate Education (Producer). (2015c). Exploring social issues that become social movements [Video file]. Baltimore, MD: Author.
Note: The approximate length of this media piece is 4 minutes.HOMEWORK:1.Discussion: Implementing and Sustaining Social Movements
In large part, the impetus of a social movement is often a personal, emotional connection to a social issue. However, emotional connection alone is not enough to sustain the perseverance necessary to achieve social change. In this week’s Discussion, you analyze examples of social movements to identify common factors that can contribute to their success and sustainability.
By Day 1
To prepare for this Discussion:
Review this week’s assigned reading from the Loeb text.
Select three movements of social responsibility from the reading on which to focus. What common factors do they share in terms of impetus to becoming a movement? How sustainable has each movement been and what has contributed to that sustainability?
Read the Discussion Spark topic, question, or comment posted by your Instructor in the Discussion thread.
By Day 2
Post a response to the Discussion Spark post. Your response should contain at least two significant paragraphs. Read the Discussion Rubric, as it will inform your writing. Important Note: The Discussion Spark and the weekly Discussion topic below will be graded together. You will see one score in your My Grades area.
By Day 4
Post a response of 2 or 3 paragraphs that includes brief descriptions of the three movements you selected. Explain the common factors or conditions that contributed to the start of each movement. Select one movement and explain why it was successful in making a social change impact. Include contributing factors for the movement’s sustainability.
Support your assertions by making at least two references, in proper APA format, to your course readings.
2.Project: Course Project: Literature Review
A literature review is a written approach to examining published information on a particular topic or field. An author uses this review of literature to create a foundation and justification for his or her research or to demonstrate knowledge on the current state of a field.
—Walden University Writing Center (2015)
In your Topic Exploration and Analysis Assignment in Week 2, you selected a social issue, analyzed its background information, developed a problem statement, and provided an explanation about why the social issue is important to investigate. This week, you examine multiple perspectives regarding potential solutions to that social issue.
Note: Even though you may have selected an issue about which you have strong feelings, it is important to work from as neutral a perspective as possible and try not to let your personal values and perceptions cloud your objectivity. In writing a literature review, your goal is to present information about a topic that already exists in the scholarly literature – not to share personal opinions. You will be expected to use evidence to support your statements by citing resources from the Walden Library.
To prepare for this Project:
Read the Black (2007) and Walden University Writing Center (2011) articles and review the Sample Literature Review in this week’s Learning Resources.
Use the Walden Library to research multiple perspectives regarding potential solutions to the social issue you selected in Week 2.
From this research, identify a minimum of two potential solutions to the social issue.
Select a minimum of two scholarly resources from the Walden Library to support each of the potential solutions you identified.
By Day 7
Write a 2- to 3-page synopsis (not including the cover page or references) of your resource findings. Address the following in your review of the scholarly literature and be sure to use evidence to support your statements for each component:
Describe at least two potential solutions to the social issue. What are the key steps involved with each potential solution?
Are the potential solutions feasible? Explain.
Are there any conflicts among the various perspectives regarding potential solutions to the social issue? What are the conflicts that exist? If you do not believe there are any conflicts, explain how you arrived at this conclusion.
What are the interests, rights, and values of all parties (stakeholders) involved with the potential solutions to the social issue?
Are there ethical dilemmas involved with the potential solutions the social issue? Explain. If you do not believe there are any ethical dilemmas, explain how you arrived at this conclusion.
Be sure to include an introduction, body, conclusion, and reference page, using APA format to cite each of your sources in the body of your paper.
In order to receive full credit, all Assignments are due on time. Should you encounter an unanticipated and uncontrollable life event that may prevent you from meeting an assignment deadline, contact the Instructor immediately to request an extension. Your Instructor’s contact information is in the Contact the Instructor area in the left navigation bar. For a full description of the late policy, please refer to the “Policies on Late Assignments” area of your Syllabus.
DeVry University Reducing Carbon Footprint Proposal Paper
This week you will submit a rough draft of your formal report or proposal. If you are writing a formal report, your rough ...
DeVry University Reducing Carbon Footprint Proposal Paper
This week you will submit a rough draft of your formal report or proposal. If you are writing a formal report, your rough draft will include the following elements.Title PageTable of ContentsExecutive SummaryIntroductionIf you are writing a proposal, your rough draft will include the following elements.Title PageTable of ContentsExecutive SummaryBusiness DescriptionBusiness ObjectivesThere is no specific length requirement for this rough draft, but it must include all of the required elements.For more information on the proper formatting of reports and proposals, see Chapter 13: Completing Business Proposals and Reports for helpful examples.Your Rough Draft for your Formal Report or Proposal is due this week. For more information on how to complete this assignment, consult the Formal Report or Proposal Overview page in the Introduction and Resources Module.Don't forget to submit your assignment.Grading RubricRough DraftPoints possibleDocument Design: The document follows the format appropriate to the chosen assignment type. In other words, whether the student has chosen to write a formal report or a proposal, the assignment is formatted correctly.20Audience Awareness: The document exhibits a clear sense of its intended readership. The document demonstrates courtesy and professionalism throughout.20Content: The document includes all of the required elements for the rough draft. The document is organized for readability and is clear, concise, and complete.50Writing Mechanics: Rules of grammar, usage, spelling, and punctuation are followed.10Total100PreviousNext
Similar Content
World religion weekly discussion, philosophy homework help
Among the religions we discussed this week, identify one religion that you find the most interesting. Explain your respons...
Philosophy Imagination Injury and Moral Vulnerability Article Comment
I want you to read the Article, and choose 3 sentences then write 3 comments and highlight the sentences that you wrote th...
ANTH 1010 Saint Xavier University Introduction to Anthropology Paper
Running head: THEORIST OF CHOICE: EMILE DURKHEIM
The theorist of Choice: Emile Durkheim
Student’s name: Philomena Omon...
Human Resource Management, business and finance homework help
WHAT MAKES A GREAT PLACE TO WORK:Select two (2) corporations listed in Fortunemagazine in the past five years as “one of...
Discussion Responses
Please respond to 2 people for Discussion 1 and 2 people for Discussion 2. Please included at least one citation....
conflict the odyssey
...
Sharqiya Chamber
Sharqiya Chamber was established several decades ago to care for the interests of its customers, and it has contributed si...
Islam
What stood out to me as an ethical viewpoint, based on the reading Islam as a Moral and Political Ideal, is when the autho...
Manage The Heart .edited
Hello. What an outstanding post you have! I concur that is recommendable for Americans to ‘’manage the heart’’. Fo...
Related Tags
Book Guides
Silas Marner
by George Eliot
Where'd You Go Bernadette
by Maria Semple
The Jade Peony
by Wayson Choy
The Metamorphosis
by Franz Kafka
50 Shades of Grey
by E. L. James
Enders Game
by E. M. Forster
Normal People
by Sally Rooney
Gone with the Wind
by Margaret Mitchell
Ezperanza Rising
by Pam Muñoz Ryan
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
Music 101 Joliet Junior College Live Concert Report
Listening to live performances is an essential part of learning to ...
Music 101 Joliet Junior College Live Concert Report
Listening to live performances is an essential part of learning to appreciate and understand music. As you know seeing a live concert at this time is not an option. I have listed several links below to concerts that you can watch online that will count for your report if you have not already completed it.
Write a two-page report describing your experience and the music you heard.
https://www.youtube.com/watch?v=syLm-9JyhuY&t=64s (Links to an external site.)
https://www.youtube.com/watch?v=w_E4t13N3Yk (Links to an external site.)
https://www.youtube.com/watch?v=YUj_GAKWziE (Links to an external site.)
https://www.youtube.com/watch?v=w2JBT0HC98I (Links to an external site.)
philosophy 211 GRATIFICATION ACCOUNTS
Blackburn is so interested in suggesting that gratification accounts of
happiness are mistaken that its easy to forget w ...
philosophy 211 GRATIFICATION ACCOUNTS
Blackburn is so interested in suggesting that gratification accounts of
happiness are mistaken that its easy to forget what stands in their
favor. What is appealing about thinking about happiness in terms of
pleasure or gratification?
Program or Policy Initiation Plan Paper
Program or Policy Initiation PlanThe seventh stage of planned change—Initiating the Program or Policy Plan—focuses on ...
Program or Policy Initiation Plan Paper
Program or Policy Initiation PlanThe seventh stage of planned change—Initiating the Program or Policy Plan—focuses on weaknesses of the first six stages of planned change. It is critical for the planner to review the first six stages in order to ensure a greater chance of success.This week you will prepare a report in Microsoft Word reviewing the implementation of your program or policy. You will then evaluate outcomes. This report is to be presented to an audience that includes members of the Center for Justice, the Mayor of Fictionland, and the Chief of Police. The report should include the following elements:Part I: Compilation of previous steps, with additional detail:A summary of the problem-solving technique employed.A list of two potential sources contributing to the problem. Also argue why you believe these factors are responsible for the community-police problem(s) in Fictionland.A summary of the newly created goal(s) and objective(s).A detailed explanation of the program or policy adapted.An action plan.Tools used to conduct a process evaluation.Tools used to conduct an outcome evaluation.Conclusion to the program or policy implementation and outcome.Part II: Create measures for evaluation of the design and objectives of your program or policy for the Fictionland Police Department. Include the following points in your report:Considering the objectives that you created in a previous assignment, create two measures to evaluate the effectiveness of your program or policy for every objective.Include a statement as to why these measures are valid measures.
use the Word file in the zip file for Instructions and do the work in the Access file
use the zip files to do the work Project Description:In this project, you will apply skills you practiced from the Obj ...
use the Word file in the zip file for Instructions and do the work in the Access file
use the zip files to do the work Project Description:In this project, you will apply skills you practiced from the Objectives in Access Chapters 1 through 3. You will create a database for Gina Gomez, Sales Manager, that contains inventory and supplier information. In addition, you will create queries that answer specific questions relating to the inventory items and suppliers, forms for entering and updating information, and reports. Steps to Perform: Step Instructions Points Possible 1 Start Access. Download, open, and save the database named go_acc_grader_capstone2_Supplier_Data.accdb. 0 2 Open the Cap2 Inventory table in Design View. Rename the ID field to Item ID and change the Data Type to Short Text. Continue adding the following fields as Short Text except for Cost, which should have a Currency Data Type, and Quantity, which should have a Number Data Type: Item Name Department Cost Quantity Supplier ID 7 3 Switch to Datasheet view. Enter the following two records into Cap2 Inventory: Item ID: H102 Item Name: Hair Brush Set Department: Hair Care Cost: 9.99 Quantity: 92 Supplier ID: S-186 Item ID: M089 Item Name: Pedicure Kit Department: Hands & Feet Cost: 22.59 Quantity: 71 Supplier ID: S-133 5 4 Close the table. Append a copy of the records from the downloaded aCap2_Inventory.xlsx workbook to the Cap2 Inventory table. Accept all defaults in the wizard and do not save the Import steps. Open the table, verify there are 24 records, and apply Best Fit to all fields. Save and close the table. 4 5 Import the source data from the downloaded aCap2_Suppliers.xlsx workbook into a new table in the current database. In the wizard, click the First Row Contains Column Headings option and set the primary key to Supplier ID. Name the table Cap2 Suppliers. 6 6 Open the Cap2 Suppliers table in Design view. Delete the Office Manager field and save the table. Switch to Datasheet view and apply Best Fit to all of the fields. Save and close the table. 4 7 On the Navigation Pane, group the objects by Tables and Related Views. 2 8 Create a relationship between the two tables in the database using Supplier ID as the common field. Enforce Referential Integrity and select both Cascade options. One supplier can supply many inventory items. 6 9 Create a relationship report. Save the report with Relationships as the name. Close the Relationships window. 4 10 Create a query in Design view, using your Cap2 Inventory table to answer the question, What is the item name (in alphabetical order), Cost, and Quantity for the department of Hair Care? Do not display the Department field in the query results.Run the query, save it as Cap2 Hair Care Query, then close the query. Three records match the criteria. 6 11 Create a copy of Cap2 Hair Care Query named Cap2 Hair Care or Easy Wear Query. Redesign the query design to answer the question, What is the department, item name, cost, and supplier ID where the department is hair care or easy wear? Arrange the fields in the order in which they're mentioned in the question. Sort the records first in ascending order by Department and then in ascending order by Item Name. Run and then close the query. Seven records match the criteria. 6 12 Create a query in Design view, using both tables to answer the question, What is the department, supplier name, item name, and phone, for a supplier name that begins with the letter B for the department of bath? Add the fields in that order. Sort the records first in ascending order by the Supplier Name field and then in ascending order by the Item Name field. Run the query, save it as Cap2 Wildcard Department Query, and then close it. Seven records match the criteria. 6 13 Create a query in Query Design view, using your Cap2 Suppliers table and your Cap2 Inventory table to answer the question, What is the supplier name, item name, department, and cost (in that order) for items that have a cost of $25 or greater? sorted first in ascending order by department and then in descending order by Cost? Six records match the criteria. Save the query as Cap2 Cost $25 or More Query and close it. 6 14 Create a query in Design view, using the Cap2 Inventory table to answer the question: For Supplier ID S-186, for each Item Name, if the Markup is calculated as 62% of Cost, then what is the Selling Price if Cost and Markup are added together? Add the Supplier ID, Item Name, and Cost fields (in that order), then create the calculated fields. Name the first calculated field Markup and name the second calculated field Selling Price. Run the query and apply Best Fit to all of the fields. All numeric fields should be formatted as Currency, 2 Decimal Places. Save the query as Cap2 Markup Query and close it. 6 15 Use the Query Wizard to create a crosstab query using the Cap2 Inventory table. Set the Supplier ID field as the row headings, and set the Department field as the column headings. Sum the Quantity field, and do not include row sums. Name the query Cap2 Crosstab Query and then finish the query. Run the query and apply Best Fit to all of the fields. Save and close the query. 7 16 Create a query in Design view using the Cap2 Inventory table that prompts you to enter the Department, and then answers the question, What is the department, item name, and Cost for inventory items, sorted first in ascending order by Department and then in ascending order by the item name? Add the fields in that order. The query should prompt an individual to Enter the Department. Run the query, and type Face & Neck when prompted for the criteria. Five records match the criteria. Save the query as Cap2 Parameter Query and close it. 7 17 Based on the Cap2 Suppliers table, use the Form tool to create a form. Switch to Form view, and then using the form, add a new record as follows: Supplier ID: S-152 Supplier Name: Springfield Supply Co. Address: 146 Lincoln Drive City: Springfield State: IL Postal Code: 62707 Phone: (217) 555-2543 Use the Filter By Form tool to create a filter that displays records with a State of IL or TX. After verifying that three records match this criteria, toggle the filter to display all 6 records. Save the form as Cap2 Supplier Form and close it. 7 18 Based on your Cap2 Suppliers table, use the Report tool to create a new report. Delete the following fields from the report: Supplier ID, Address, City, State, and Postal Code. Delete the Page Number control. Apply the Gallery theme to this object only. Sort the Supplier Name field in ascending order. For the Phone field, change the Width property to 1.25. For the Supplier Name field, change the Left property to 1 and then close the Property Sheet. Save the report as Cap2 Suppliers Report and then close the report. 5 19 Use the Report Wizard to create a report based on the Cap2 Inventory table. Add the following fields to the report: Department, Item Name, and Quantity, in that order. Group by the Department field. Sort in ascending order by the Item Name field. Find the Sum of the Quantity field. Be sure that the Layout is Stepped and that the Orientation is Portrait. For the report title, type Cap2 Inventory by Department Report and then switch to Layout view. Delete the controls that begin with Summary for 'Department'. Under Item Name, click any text box control, and then set the Width property to 2.5. For the Quantity label control, set the Left property to 6.5. Save and close the report. 6 20 Close all database objects. Open the Navigation Pane. Close the database and then exit Access. Submit the database as directed. 0 Total Points 100
Walden Week 3 Social Issues that Become Social Movements Paper
Week 3: Implementing and Sustaining Social ResponsibilityConsider the personal stories Loeb (2010) has shared about Virgin ...
Walden Week 3 Social Issues that Become Social Movements Paper
Week 3: Implementing and Sustaining Social ResponsibilityConsider the personal stories Loeb (2010) has shared about Virginia Ramirez, Julius Davis, and Alison Smith. Ramirez was enraged when an elderly woman died because her home did not have heat; Davis was awakened from discouragement after accidental exposure to a Malcolm X speech; and Smith witnessed unethical environmental practices in her neighborhood. Each event sparked something in these individuals to move them from emotion to action.As you reflect on these stories and on your own experiences, pay attention to what sets apart the people who talk about things they care about and the people who act on them. Moreover, while it is one thing to take action one time, what goes into making sure that such socially responsible actions continue?This week, you explore social issues that become social movements, and examine the factors that contribute to a social movement’s sustainability. You also conduct further research on your social issue topic, and write a literature review focused on potential solutions to this issue.Learning ObjectivesStudents will:
Analyze commonalities in implementing social movements
Analyze the sustainability of social movements
Analyze multiple perspectives on a topic
Write a literature reviewLearning Resources
Note: To access this week’s required library resources, please click on the link to the Course Readings List, found in the Course Materials section of your Syllabus.
Required Readings
Loeb, P. R. (2010). Soul of a citizen: Living with conviction in challenging times (rev. ed.). New York, NY: St. Martin's Griffin.
Chapter 5, “Unforeseen Fruits” (pp. 105–124)
Chapter 6, “The Call of Stories” (pp. 125–160)
Chapter 7, “Values, Work, and Family” (pp. 161–194)
Black, K. (2007). Considerations in writing a literature review. New Social Worker, 14(2), 12-13.
Retrieved from the Walden Library databases.
Walden University Writing Center. (2015). Common course assignments: Literature reviews. Retrieved from http://academicguides.waldenu.edu/writingcenter/as...
Document: Sample Literature Review (Word document)
Document: Course Project Overview and Guidelines (Word document)
Required Media
Laureate Education (Producer). (2015c). Exploring social issues that become social movements [Video file]. Baltimore, MD: Author.
Note: The approximate length of this media piece is 4 minutes.HOMEWORK:1.Discussion: Implementing and Sustaining Social Movements
In large part, the impetus of a social movement is often a personal, emotional connection to a social issue. However, emotional connection alone is not enough to sustain the perseverance necessary to achieve social change. In this week’s Discussion, you analyze examples of social movements to identify common factors that can contribute to their success and sustainability.
By Day 1
To prepare for this Discussion:
Review this week’s assigned reading from the Loeb text.
Select three movements of social responsibility from the reading on which to focus. What common factors do they share in terms of impetus to becoming a movement? How sustainable has each movement been and what has contributed to that sustainability?
Read the Discussion Spark topic, question, or comment posted by your Instructor in the Discussion thread.
By Day 2
Post a response to the Discussion Spark post. Your response should contain at least two significant paragraphs. Read the Discussion Rubric, as it will inform your writing. Important Note: The Discussion Spark and the weekly Discussion topic below will be graded together. You will see one score in your My Grades area.
By Day 4
Post a response of 2 or 3 paragraphs that includes brief descriptions of the three movements you selected. Explain the common factors or conditions that contributed to the start of each movement. Select one movement and explain why it was successful in making a social change impact. Include contributing factors for the movement’s sustainability.
Support your assertions by making at least two references, in proper APA format, to your course readings.
2.Project: Course Project: Literature Review
A literature review is a written approach to examining published information on a particular topic or field. An author uses this review of literature to create a foundation and justification for his or her research or to demonstrate knowledge on the current state of a field.
—Walden University Writing Center (2015)
In your Topic Exploration and Analysis Assignment in Week 2, you selected a social issue, analyzed its background information, developed a problem statement, and provided an explanation about why the social issue is important to investigate. This week, you examine multiple perspectives regarding potential solutions to that social issue.
Note: Even though you may have selected an issue about which you have strong feelings, it is important to work from as neutral a perspective as possible and try not to let your personal values and perceptions cloud your objectivity. In writing a literature review, your goal is to present information about a topic that already exists in the scholarly literature – not to share personal opinions. You will be expected to use evidence to support your statements by citing resources from the Walden Library.
To prepare for this Project:
Read the Black (2007) and Walden University Writing Center (2011) articles and review the Sample Literature Review in this week’s Learning Resources.
Use the Walden Library to research multiple perspectives regarding potential solutions to the social issue you selected in Week 2.
From this research, identify a minimum of two potential solutions to the social issue.
Select a minimum of two scholarly resources from the Walden Library to support each of the potential solutions you identified.
By Day 7
Write a 2- to 3-page synopsis (not including the cover page or references) of your resource findings. Address the following in your review of the scholarly literature and be sure to use evidence to support your statements for each component:
Describe at least two potential solutions to the social issue. What are the key steps involved with each potential solution?
Are the potential solutions feasible? Explain.
Are there any conflicts among the various perspectives regarding potential solutions to the social issue? What are the conflicts that exist? If you do not believe there are any conflicts, explain how you arrived at this conclusion.
What are the interests, rights, and values of all parties (stakeholders) involved with the potential solutions to the social issue?
Are there ethical dilemmas involved with the potential solutions the social issue? Explain. If you do not believe there are any ethical dilemmas, explain how you arrived at this conclusion.
Be sure to include an introduction, body, conclusion, and reference page, using APA format to cite each of your sources in the body of your paper.
In order to receive full credit, all Assignments are due on time. Should you encounter an unanticipated and uncontrollable life event that may prevent you from meeting an assignment deadline, contact the Instructor immediately to request an extension. Your Instructor’s contact information is in the Contact the Instructor area in the left navigation bar. For a full description of the late policy, please refer to the “Policies on Late Assignments” area of your Syllabus.
DeVry University Reducing Carbon Footprint Proposal Paper
This week you will submit a rough draft of your formal report or proposal. If you are writing a formal report, your rough ...
DeVry University Reducing Carbon Footprint Proposal Paper
This week you will submit a rough draft of your formal report or proposal. If you are writing a formal report, your rough draft will include the following elements.Title PageTable of ContentsExecutive SummaryIntroductionIf you are writing a proposal, your rough draft will include the following elements.Title PageTable of ContentsExecutive SummaryBusiness DescriptionBusiness ObjectivesThere is no specific length requirement for this rough draft, but it must include all of the required elements.For more information on the proper formatting of reports and proposals, see Chapter 13: Completing Business Proposals and Reports for helpful examples.Your Rough Draft for your Formal Report or Proposal is due this week. For more information on how to complete this assignment, consult the Formal Report or Proposal Overview page in the Introduction and Resources Module.Don't forget to submit your assignment.Grading RubricRough DraftPoints possibleDocument Design: The document follows the format appropriate to the chosen assignment type. In other words, whether the student has chosen to write a formal report or a proposal, the assignment is formatted correctly.20Audience Awareness: The document exhibits a clear sense of its intended readership. The document demonstrates courtesy and professionalism throughout.20Content: The document includes all of the required elements for the rough draft. The document is organized for readability and is clear, concise, and complete.50Writing Mechanics: Rules of grammar, usage, spelling, and punctuation are followed.10Total100PreviousNext
Earn money selling
your Study Documents