For this module on Popular Culture, you are watching two films: bell hooks: Cultural Criticism and Transformation (WEEK 4)

Look at following text. Choose two literary elements and/or devices in the

Look at following text. Choose two literary elements and/or devices in the text and discuss how they are used to describe the society depicted in the text using clear references (quotes, passages) from the text. Be sure to include definitions of your chosen literary elements/devices and the concept of “society” in your answer. Please write a five-paragraph essay of not less than 300 words for each

1. “Civil Peace”

2. “My Country and My People”

3. “Phantom Palace”

4. “I’m Your Horse in the Night”

5. “Gateman’s Gift”

6. “A Hunger Artist”

Instructions select one learning outcome from your program of study. Then, select

For this module on Popular Culture, you are watching two films: bell hooks: Cultural Criticism and Transformation (WEEK 4) Writing Assignment Help Instructions select one learning outcome from your program of study. Then, select two graded artifacts (i.e., written assignments, projects, papers, discussion posts, or responses) that you feel best demonstrate your mastery of the selected program outcome.

When selecting a previous work sample, you can review and retrieve your Waypoint assignments from previous courses from within Waypoint itself.

Utilizing the feedback you received on these artifacts from your instructor as well as the things you have learned since submitting this work, revise and expand on these artifacts to create polished and corrected examples that you can add to your portfolio. 

Utilize track changes to make additions, corrections, and changes to your work in order for the instructor to review the changes that were made.

Add two additional professional and current resources to support and improve your artifacts. 

Submit

Combine the two updated artifacts (include track changes) into one document and submit via Waypoint. (I will do the submitting portion of the assignment)

Then remove the tracked changes from the artifacts and add the polished and corrected artifacts to your portfolio with the correct heading and description of the selected program learning outcome. Insert a link to your portfolio in a Word document and submit via Waypoint. If needed, review the Week 1 Folio resources. ( I will do the folio portion)

Please have two documents one document to reflect track change one document to reflect polished work

Learning outcome: Apply best practices in the field regarding professional values, ethics, attitudes, and behaviors;

Two graded artifacts

Graded artifact 1: “Identity a recent successful change initiative that has been made in your organization or in an organization with which you are familiar”

A recent successful change that has been made in an organization that I am familiar with involved switchingpermanently to remote work by embracing full digital transformation at all levels of the organization.

“Discuss the specific challenges that led to the need for change and evaluate how leaders faced these challenges and used the as an opportunity to make improvements in the organization”

The major challenge that led to this transformation is the COVID19 pandemic. In an effort to contain the spread of the disease governments across the world announced lock downs which forced business to shut down in order to comply with the regulations put in place. Upon opening up there were still restrictions placed on the number of workers allowed in addition to social distancing guidelines that ought to be met. Leaders at the organization took this upon themselves to embrace the new reality and make a shift to fully remote in order to avoid interruptions. By pursuing such leaders improved their organizations and enabled them to bounce back from the effects of the COVID 19 pandemic compared to competitors who were not willing to embrace the new reality. Improvements realized by the organization due to full working remote included reduction in costs, time saving and improved productivity. Employers and workers both benefit from the cost advantages that remote work delivers. Employers have significantly cut the cost of corporate travel, while employees have avoided the expense of travelling to and from work (Toikka, 2021). Individuals discover that they have significantly more time for their jobs and their family because they no longer have to commute vast distances to work or go to other towns or countries. Increased productivity, more time with family, exercise, and relaxation may all be achieved by taking advantage of this “found time.” Working from home has shown to be more productive for many people and their firms, which has shocked many people and their organizations alike (de Lucas Ancillo et al., 2020). Apart from the apparent benefit of saving time on commuting and flying, they also discovered that they were more productive when working away from the usual workplace distractions and noise levels were lower.

“Describe the specific change management leadership characteristics and behaviors you saw leaders display in leading the change effort and how these characteristics and behaviors led to the successful implementation of the change”

Specific change management leadership characteristics and behaviors witnessed involved adaptability, strategic thinking, decisiveness and communication. It through such characteristicsand behaviors that the organization was able to adapt to the new reality, formulate a strategy for fully shifting to working remote, openly communicate the changes and plan to shift to fully working remote before making the decision to make the shift.

References

de Lucas Ancillo, A., del Val Núñez, M. T., & Gavrila, S. G. (2020). Workplace change within the COVID-19 context: a grounded theory approach. Economic Research-Ekonomska Istraživanja, 34(1), 1–20. https://doi.org/10.1080/1331677x.2020.1862689

Toikka, L. (2021). People managers’ perceptions of changes during the shift to remote work. Aaltodoc.aalto.fi. https://aaltodoc.aalto.fi/handle/123456789/110508

FEEDBACK GIVEN FROM ARTIFACT 1: Great work with your initial post. Implementing a remote work policy at your organization appears to have a huge impact on the business.

Graded artifact number two : Mr. Chan’s organization is facing critical leadership challenges. These challenges make it difficult for workers to be done in the required manner. For Mr. Chan to provide a conducive work environment he has to implement the following changes. The organization should change the mode of communication and information transfer within the organization, improve technology in the organization for information storage and have team meetings that will foster bonding within the organization. Change the communication system in the organization. Changing communication and transfer of information will help the organization in making information on the processes that are going on in the organization to be available for the team to access for easy operations. This will foster teamwork and collaboration between the different departments that Mr. Chan has in his organization (Krajcsák, 2019). This means the organization has information stored in one cloud that will help each department get updates and responses on the way forward in their operations. Improving technology and having the same informational system will help the organization solve the issue of a filling system that the employees were complaining about. There will be no loss of documents and retrieval if employee information will be made easier within the organization. Technology improvement can help in the marketing of the products and transfer of information between organizations hence reducing the cost of traveling. This includes emailing and social media platforms that can be advantageous to the organizations marketing strategies (Matosas-López, 2021). The organization should hold meetings for all staff to be able to create a conducive working environment. this meeting should be mandatory for all staff members to create a bond between the staff members in the organization. Having a team, the work, and coordination facilitates creativity and hard work within the organization (Krajcsák, 2019). By doing this the organization will be impressing employee contribution and involvement within the organization. An organization where employees are involved in decision-making processes always encourages the employees to have loyalty to the organization since they feel recognized by their fellow workmates.

References

Krajcsák, Z. (2019). Leadership strategies for enhancing employee commitment in TQM. Journal of Management Development, 38(6), 455–463. https://doi.org/10.1108/jmd-02-2019-0056

Matosas-López, L. (2021). The Management of Digital Marketing Strategies in Social Network Services: A Comparison between American and European Organizations. Journal of Open Innovation: Technology, Market, and Complexity, 7(1), 65. https://doi.org/10.3390/joitmc7010065

FEEDBACK GIVEN FOR ARTIFACT NUMBER TWO: Do make sure you are supporting your peer responses with research and/or data, as well as meeting the length requirements. Use your research to support your thoughts and ideas being shared in the forum. As we have seen, leaders can take many different approaches to managing change. The fact is that change is inevitable, which means the right leaders are necessary to the success of an organization or in this case HCSC. I always find it interesting to see how many different viewpoints can exist on one topic. Keep up the hard work as we move forward.

INSTRUCTIONS Create an office memo addressed to CEO Mr. Rockfish explaining why

INSTRUCTIONS

Create an office memo addressed to CEO Mr. Rockfish explaining why it is imperative that the company create a new KM department at GDD.

Review

Chapter 1: Introduction to Knowledge Management in Theory and Practice

Chapter 2: The Knowledge Management Cycle

Glossary, p. 329-343

NOTE: This is the primary text for the next 8 weeks. Be sure to download it now.

GDD Corporate Profile

Be sure to include:

The multidisciplinary nature of KM

the value using KM processes to share information has to an organization;

Why the KM cycle with its dynamic nature fits the change and innovation needs in business today, and

choose one of the KM cycles discussed in the readings and why you believe it would be a good fit for GDD. 

The memo must be persuasive. Use words that show enthusiasm, are descriptive and present the strongest arguments you can make to support your need to bring a KM department on board.

Only use course content and material to support your responses and APA in-text citations with a reference list. 

Class Content

Knowledge Management – In 5 minutes or less

https://www.youtube.com/watch?v=k3jo7oWzUUc

Scott Leeb Rockefeller Foundation. (2014, November 07). https://www.youtube.com/watch?v=SvEcTEB9ajQ

Knowledge Management Primer

https://www.youtube.com/watch?v=ZnSS_PrLu1c

References:

Frost, A. (2012). Knowledge management definition.

https://www.knowledge-management-tools.net/knowledge-management-definition.html

Norton, D. (2000, October 30). Knowledge management process can increase productivity and profits. https://www.techrepublic.com/article/knowledge-management-process-can-increase-productivity-and-profits/

Knowledge management Book

Dalkir, K. (2011). Knowledge management in theory and practice, 2nd ed. MIT.

(Dalkir, 2011)

Instructions Follow the format below while creating your portfolio. You should write

Instructions

Follow the format below while creating your portfolio. You should write in a professional manner except in the reflective piece of the portfolio. Otherwise, all items should be parsed as if they were going to be reviewed by an executive at a financial institution.

Introduction: In 1-2 pages, describe what your original strategy was in choosing your stocks and the strengths that you saw when you did so. Also highlight any areas you avoided. Please keep in mind that you will be evaluating these decisions and their merits in the reflective section.

Stock portfolio: Create a professional presentation of all of the information you have gathered on your stocks throughout the term. Please keep in mind this is a professional presentation; therefore, matching fonts, styles, and readability will be considered in your grade.

Prospectus: In 2-3 pages, suggest what should be done with your stock portfolio going forward. Cite examples from the data you collected while making your suggestions. Please consider which stock you believe will perform in the future and which you believe should be sold. Make sure to consider how long a position you would recommend holding for various stocks.

Reflections: In one 2-3 page essay, speaking as a student and not as a hypothetical professional, answer the following questions.

Were you surprised by how your portfolio performed?

What factors impacted your initial stock selection, and how would the knowledge you have gained in this course have affected the selection if you had it to do all over again?

How did your perception of the state of the current economy affect your stock selection, and how would it have differed if the market were trending in the inverse direction?

What market indicators did you find to be the most informative and why?

Do you believe that deep research or intuition is a more important asset for an investor?

New Perspectives Access 2016 | Modules 1–4: SAM Capstone Project 1a New

New Perspectives Access 2016 | Modules 1–4: SAM Capstone Project 1a

New Perspectives Access 2016 | Modules 1–4: SAM Capstone Project 1a

Sandra Coates Skating Club

Creating Tables, Queries, Forms, and Reports in a Database

GETTING STARTED

Open the file NP_AC16_CS1-4a_FirstLastName_1.accdb, available for download from the SAM website.

Save the file as NP_AC16_CS1-4a_FirstLastName_2.accdb by changing the “1” to a “2”.

If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.

To complete this Project, you will also need to download and save the following support files from the SAM website:

Support_NP_AC16_CS1-4a_Athletes.xlsx

Support_NP_AC16_CS1-4a_SCSC.accdb

Support_NP_AC16_CS1-4a_Locations.txt

Support_NP_AC16_CS1-4a_Levels.txt

Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website.

PROJECT STEPS

Sandra Coates Skating Club (SCSC) is committed to the development of skaters of all ages. It manages athlete and coach data for skating athletes located at various skating clubs throughout Pennsylvania. Sandra Coates is the founder and general chairperson of SCSC, and she has just received approval from the board of directors to replace SCSC’s manual system of managing data about athletes, coaches, and locations with a database. She has asked you to help her create objects in the database that she and other staff members can use to manage data about athletes, coaches, and their locations.

Open the tblCoach table in Design View, and then make the following changes:

Move the LevelID field immediately after the CoachID field.

Delete the CertificationLevel field from the table. (Hint: If a warning message appears asking if you want to permanently delete the field and all the data it contains, click Yes.)

Save the table.

Switch to Datasheet View, enter the records shown in Table 1 below into the tblCoach table, and then close the table.

Table 1: New Records for the tblCoach Table

Coach ID

Level ID

Coach First Name

Coach Last Name

BGC Expiration

Certification Expiration

901900

BEG2

Angela

Pearson

12/31/2020

12/31/2020

901901

BEG1

Nora

Keller

12/31/2020

12/31/2020

Create a new table in Datasheet View. Save the table as tblAthlete, and then make the following changes in Datasheet View:

Change the data type of the ID field to Short Text, and then change the field name to AthleteID.

Add the following fields to the table in the order listed, and choose the Short Text data type for each field: LocationID, FirstName, LastName, Address, City, State, Zip, LevelID, and Gender.

Save the table.

Switch to Design View for the tblAthlete table, and then set the field properties shown in Table 2 below.

Table 2: Field Properties for the tblAthlete Table

Field Name

Data Type

Description

Field Size

Other

AthleteID

Short Text

Primary key

5

Caption: Athlete ID

LocationID

Short Text

Foreign key

4

Caption: Location ID

FirstName

Short Text

20

Caption: First Name

LastName

Short Text

30

Caption: Last Name

Address

Short Text

35

City

Short Text

35

State

Short Text

2

Default Value: PA

Zip

Short Text

10

LevelID

Short Text

Foreign key

4

Caption: Level ID

Gender

Short Text

M, F

1

Add a new field to the tblAthlete table, immediately after the Zip field. Use the field name BirthDate, the Date/Time data type, the Short Date format, and the caption Birth Date.

Move the LevelID field so that it is located immediately after the AthleteID field. Save and close the table.

Much of the data that Sandra needs in the database is currently stored in other formats and locations, so you need to import it into the database. Use the Import Spreadsheet Wizard to add data to the tblAthlete table from an Excel spreadsheet as follows:

Specify the file Support_NP_AC16_CS1-4a_Athletes.xlsx, available for download from the SAM website, as the source of the data.

Select the option to append a copy of the records to the tblAthlete table.

In the Import Spreadsheet Wizard dialog boxes, choose the Athlete worksheet, and then import to the tblAthlete table. Do not save the import steps.

Import the structure of the tblLocation table in the database Support_NP_AC16_CS1-4a_SCSC.accdb, available for download from the SAM website, into the current database. Do not save the import steps.

Open the tblLocation table in Design View, and then update the field properties shown in Table 3 below. Set the LocationID field as the Primary Key, then save and close the tblLocation table.

Table 3: Field Properties for the tblLocation Table

Field Name

Data Type

Description

Field Size

Other

LocationID

Short Text

Primary key

4

Caption: Location ID

LocationName

Short Text

50

Caption: Location Name

Sandra exported her existing location data to a text file, and she asks you to add this data to the tblLocation table. Import the data as instructed below:

Specify the file Support_NP_AC16_CS1-4a_Locations.txt, available for download from the SAM website, as the source of the data.

Select the option to append a copy of the records to the tblLocation table.

In the Import Text Wizard dialog boxes, choose the options to import delimited data, to use a comma delimiter, and to import the data into the tblLocation table. Do not save the import steps.

Open the tblLocation table in Datasheet View, and then resize the columns to best fit the data they contain.

Save and close the tblLocation table.

Create a new table in Design View, and then set the field properties shown in Table 4 on the following page. The LevelID field should be the primary key for the table. Save the table with the name tblLevel, and then close the table.

Table 4: Field Properties for the tblLevel Table

Field Name

Data Type

Description

Field Size

Other

LevelID

Short Text

Primary key

4

Caption: Level ID

LevelName

Short Text

30

Caption: Level Name

MonthlyFee

Currency

Caption: Monthly Fee

Decimal Places: 0

RegistrationFee

Currency

Caption: Registration Fee

Decimal Places: 0

Sandra exported her levels data to a text file, and she asks you to add this data to the tblLevel table. Import the data as instructed below:

Specify the file Support_NP_AC16_CS1-4a_Levels.txt, available for download from the SAM website, as the source of the data.

Select the option to append a copy of the records to the tblLevel table.

In the Import Text Wizard dialog boxes, choose the options to import delimited data, to use a comma delimiter, and to import the data into the tblLevel table. Do not save the import steps.

Open the tblLevel table in Datasheet View, and then resize the columns to best fit the data they contain.

Save and close the tblLevel table.

Add the tblCoach, tblLevel, tblAthlete, and tblLocation tables, in that order, to the Relationships window. Resize the field list for the tblAthlete table so all fields are visible. Create the relationships in the database as instructed below:

Define a one-to-many relationship between the primary tblLevel table and the related tblCoach table using the LevelID field. Choose the options to enforce referential integrity and to cascade update related fields.

Define a one-to-many relationship between the primary tblLevel table and the related tblAthlete table using the LevelID field. Choose the options to enforce referential integrity and to cascade update related fields.

Define a one-to-many relationship between the primary tblLocation table and the related tblAthlete table using the LocationID field. Choose the options to enforce referential integrity and to cascade update related fields. Figure 1 below shows the completed Relationships window. Save and close the Relationships window.

Figure 1: Relationships Window

Sandra needs to be able to find information on athletes that qualify for the children’s classes, so you decide to create a query to allow her to quickly locate athletes born during or after 2011. Use the Simple Query Wizard to create a query based on the tblAthlete table. Include all fields in the query, and use qryAthletesBorn2011AndYounger as the title. Make the following changes to the query:

Add criteria to the BirthDate field to select records for athletes who were born on or after 1/1/2011.

Sort the records in ascending order by LastName.

Hide the State field so that it does not appear in the query results. (Hint: Make sure to hide this field in Design View, not in Datasheet View.)

Save and run the query, and then close it.

Create a new query in Design View that is based on the tblLevel and tblAthlete tables. Add the LevelName field from the tblLevel table to the query design. Add the FirstName, LastName, BirthDate, and Gender fields, in that order, from the tblAthlete table to the query design. Save the query with the name qryLevelsAndAthletes, run the query, and then complete the following tasks in Datasheet View:

Sort the records by BirthDate, so the oldest athletes are listed first.

Use Filter By Selection to select only those athletes who skate for the Collegiate level (Hint: Use the Equals “Collegiate” option.) Save and close the query.

Create a new query in Design View that is based on the tblCoach and tblLevel tables. Add the LevelName field from the tblLevel table to the query design. Add the CoachFirst, CoachLast, BGCExp, and CertificationExp fields, in that order, from the tblCoach table. Use qryCoachBGCExpirations to save query. Add criteria to the BGCExp field to select records with BGCExp dates that occur on or before 12/31/2019. Save and run the query, and then close it.

In the Navigation Pane, copy the qryCoachBGCExpirations query, rename the copied query qryCoach2019CertificationExpirations, and then add criteria to only select records with a BGCExp date that occurs on or before 12/31/2019 and that contains a CertificationExp date that occurs on or before 12/31/2019. (Hint: This query should only return records that meet both of the query conditions. The criteria for the BGCExp date should already be present in the copied query.) Save and run the query, and then close it.

In the Navigation Pane, copy the qryCoach2019CertificationExpirations query, rename the copied query qryCoach2019BGCOrCertificationExpirations, and then edit the criteria to only select records with a BGCExp date that occurs on or before 12/31/2019 or a record that contains a CertificationExp date that occurs on or before 12/31/2019. (Hint: This query should return records that meet one or more of the query conditions.) Save and run the query, and then close it.

Create a new query in Design View that is based on the tblAthlete and tblLevel tables. Add the LevelName field from the tblLevel table to the query design. Add the FirstName and LastName fields from the tblAthlete table. Add the MonthlyFee field from the tblLevel table. Save the query with the name qryAnnualDuesByAthlete, run the query, and then complete the following tasks:

In Design View, add a calculated field named AnnualDues to the query design in the fifth column of the design grid that determines the total annual cost of skating dues for each athlete. The expression should multiply the monthly fee amount by 12 months. Set the Caption property Annual Dues for the calculated field.

Save and run the query. Resize the Annual Dues column to best fit the data it contains.

Add the Total row to the query datasheet, and then use a function to calculate the average monthly fee and the total annual dues.

Save and close the query.

Use the Form Wizard to create a form based on the tblLevel table. Include all fields in the form, use the Columnar layout, and name the form frmLevels. Make the following changes to the form:

In Layout view, change the form title to Levels, and then change the font color of the form title to Dark Blue (4th column, 1st row of the Standard Colors palette).

Switch to Form view, and use the frmLevels form to enter a new record in the tblLevel table with the Level ID TODD, the Level Name Toddler, a Monthly Fee of $95, and a Registration Fee of $50. Save and close the form.

Use the Form Wizard to create a form containing a main form and a subform by following the instructions below:

Select all fields from the tblLevel table for the main form.

Select the AthleteID, FirstName, and LastName fields from the tblAthlete table.

Choose the option to view the data by tblLevel.

Select the Datasheet layout for the subform.

Specify the titles frmLevelsWithAthletes for the main form and frmAthleteSubform for the subform.

Switch the form to Layout view and change the title in the main form to Levels with Athletes, and then change the font color of the title to Dark Blue (4th column, 1st row of the Standard Colors palette).

Resize the Athlete ID, First Name, and Last Name columns in the subform to best fit the data they contain, or a width of at least 0.5” for each column. Resize the width of the subform to approximately 3.5” as shown in Figure 2 on the following page.

Use the navigation buttons to view each record in the main form, checking to make sure that all data is displayed in the columns in the datasheet’s subform. (Hint: The order of records in your subform may be different than shown in Figure 2.) If necessary, resize the datasheet columns and the subform to display the data so it is fully visible. When you are finished, save and close the form.

Figure 2: frmLevelsWithAthletes Form

You decide that a report showing a list of all the athletes would be useful. Use the Report Wizard to create a report based on the primary tblLevel table and the related tblAthlete table, as instructed below:

Select the LevelName, MonthlyFee, and RegistrationFee fields from the tblLevel table.

Select the LocationID, FirstName, LastName, BirthDate, and Gender fields from the tblAthlete table.

View the data by tblLevel, and do not select any additional grouping levels for the report.

Sort the records in ascending order by LocationID.

Select the Outline layout and Portrait orientation for the report.

Use rptAthleteListing as the report title.

Switch the report to Layout View, and change the report title for the rptAthleteListing report to Athlete Listing (two words).

You decide to modify the layout of the rptAthleteListing report to make it easier to read. With the report still open in Layout View, complete the following steps:

Resize the Level Name, Monthly Fee, and Registration Fee field labels by using the mouse to drag their right edges, decreasing their widths so the boxes are as wide as necessary to display their contents (approximately 1.25”).

Resize the LevelName, MonthlyFee and RegistrationFee field value controls by using the mouse to drag their right edges, decreasing their widths so the boxes are as wide as their contents (approximately 1.2”).

Right-align the contents of the LevelName, MonthlyFee, and RegistrationFee field value controls.

With the rptAthleteListing report still open in Layout View, complete the following steps:

Resize the LocationID field label and field value controls by dragging their left edges with the mouse to make all the contents visible (they should be approximately 0.8” wide).

Resize the Last Name field label and field value controls to approximately 1.5” wide by dragging their right edge with the mouse.

Move the Birth Date and Gender field labels and field value controls to the left to decrease the amount of space between the columns. The left edge of the Birth Date label and controls should be located at approximately 4.5”, and the left edge of the Gender label and controls should be located at approximately 5.6”. (Hint: The location of a control’s left edge can be viewed in the Property Sheet.)

Resize the control that contains the page number to approximately 1” wide. Use an arrow key to move the page number control so its right edge aligns with the right edge of the Gender control in the report.

Switch to Report View, and scroll through the report to confirm that all values are visible. Save the report.

Switch the rptAthleteListing report to Layout view, and use conditional formatting to format birth dates that are greater than or equal to 1/1/2008 in a bold, Green font color (6th column, 7th row of the Standard Colors palette). Display the report in Print Preview and confirm that it matches Figure 3 on the next page, and then save and close the report. (Hint: The records may appear in a different order in your report.)

Figure 3: rptAthleteListing Report

Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the SAM website to submit your completed project.