English

english 

Running head: COLLEGE EDUCATION 1

COLLEGE EDUCATION 4

College education

Student

Professor

Course

Date

Should college education be free?

The debate on whether college education needs to be free has elicited mixed reactions in the United States with the majority of people calling for free education in the United States. While this may seem to be the best alternative, it may also lead to other underlying challenges for the country. This paper aims at evaluating whether college education needs to be free or not and provides a position for the government to take.

The policy of implementing free primary education in colleges is crucial in promoting better access to education (Lederer et al., 2021). In the United States, the majority of students usually fail to continue with education due to a lack of finances. Therefore, promoting free education in colleges will help the needy students to access education and hence, will increase their chances of being employed in the future. However, Carnevale et al. (2020) have a different idea regarding this issue. According to him, a college education is an investment. Therefore, free education will cripple most colleges since they will not have adequate finances to operate. The majority of colleges are likely to shut down but the number of students will keep increasing. This will lead to a crisis in college institutions. Therefore, Carnevale et al. (2020) state that although free education in colleges is good, it will also cripple the financial structure of most colleges.

Secondly, promoting free education in colleges will also widen the workforce in the US. House and Dell (2020) state that enhancing free education in college means that more students will enroll in colleges. Therefore, the majority of students will acquire knowledge and skills in various fields of work. Consequently, they are likely to transfer their knowledge and skills to their workforce (Epstein, 2021). Organizations will have more skilled employees to choose the workforce from hence widening the workforce in the US. However, Conway, Wladis, and Hachey (2021) doubt if free education will widen the workforce in the US. According to him, free education will make the students lose value and the motivation of working hard for their studies. Carnevale et al. (2020) support this idea by noting that not all students are fit to have a college education. He states that quality education is acquired through hard work and hence, free education in colleges will lead to inflation in colleges. This will decrease the overall quality of college education in the United States. Therefore, though free education in colleges will widen the workforce, it is also clear that it will decrease the quality of studies in college education.

Thirdly, free education in colleges will boost the economy in the US. Epstein (2021) states that every year, the average student debt per person is $31,000. When students graduate with debts, they usually take a long period before they can clear these debts. However, if college education is made free, students will be debt-free and they easily plan for their future including the process of securing jobs and saving for the future (Lederer et al., 2021). However, Conway, Wladis, and Hachey (2021) state that this will reduce other programs in the country. He notes that free education means that the government will have to abandon some safe projects e.g. reducing health insurance to fund free education. This will also create problems for other states that are still straining to fund their education and health programs. Therefore, though free education will make students debt-free, other programs will have to be scrapped to pave way for free education funding.

To conclude, free education will be essential in the US. It will help the needy students to have access to education and hence, will improve access to education. It will also help to bridge the education gap between the poor and the rich. Although there will be some challenges, the benefits of free education in colleges surpass all the challenges that the government will encounter.

References

Carnevale, A. P., Sablan, J. R., Gulish, A., Quinn, M. C., & Cinquegrani, G. (2020).

The Dollars and Sense of Free College. Georgetown University Center on Education and the Workforce.

Conway, K. M., Wladis, C., & Hachey, A. C. (2021). Time Poverty and Parenthood:

Who Has Time for College?. AERA Open, 7, 23328584211011608.

Epstein, R. A. (2021). College Isn’t Free–Nor Should It Be: Wiping out student debt

would involve staggering costs and unfair taxation. Worse, loan forgiveness would violate the principle of making degrees pay for themselves. Hoover Digest, (2), 72-77.

House, E., & Dell, M. (2020). Keeping the promise: Early outcomes of Tennessee’s

tuition-free college initiative. Improving research-based knowledge of college promise programs, 151-172.

Lederer, A. M., Hoban, M. T., Lipson, S. K., Zhou, S., & Eisenberg, D. (2021).

More than inconvenienced: The unique needs of US college students during the COVID-19 pandemic. Health Education & Behavior, 48(1), 14-19.

Implementation of Strategy

Healthcare organizations require astute handling of strategy implementation. The processes must be followed with a contingency plan in place for failed strategic objectives leading to the goal.

  • Review the stages of implementation in Chapter 13 of your textbook.
  • Review “340B Drug Pricing Program Oversight” case in your textbook (Chapter 13).
  • Provide a written analysis of the implementation phases that were used/excluded in the “340B Drug Pricing Program Oversight” case.
  • Explain what the literature (external scholarly source) suggest(s) regarding health implementation strategy regarding drug pricing.
  • Conclude with a summary of your research.

Chapter 13
Implementation Strategy and Planning

Health care delivery, like politics, is mostly local. No matter how good the policy analysis
process, the policy selected as a result of that process will fail unless it elicits the support of its
local implementers. Health-related activities exhibit deeply contrasting tendencies: health care
processes are slow to change in some areas, yet the pace of change is rapid in other areas.
Some argue that the adoption of new technologies is driving up costs, whereas others argue
that failure to adopt new technology is partly responsible for escalating costs. Christensen,
Bohmer, and Kenagy (2000) used the health care industry as an example of the need for
disruptive technology to come in and overcome inertia. Their model applies very well in some
areas, such as health information technology, but not in others, such as noninvasive surgery.

Dopson and Fitzgerald (2005) edited a book about the “implementation gap” for evidence-based
health care in Britain’s National Health Service, where centralization of management and
financing would seem to create a more fertile environment for change. In a chapter contributed
by Dopson and his colleagues (Dopson et al., 2005), the authors pointed out that failure to
achieve goals that had been carefully planned has a long history in public policy analysis.
Implementation failures could be explained as political bargaining as usual at a micro level;
however, empirical studies suggest

that implementation is a separate stage of the change process (Torenvlied & Thomson, 2003).

The policy process must consider how to implement a policy decision and how to promote that
implementation. The Australian government considers implementation so important that it
established a Cabinet Implementation Unit in late 2003 within the Department of the Prime
Minister and Cabinet.

The White House might want to consider a similar unit after the Obama administration’s
experience with the 2013–2014 rollout of the Web-based insurance exchanges. One can make
a substantial list of the basic requirements of effective program implementation that were
violated in that process.

13.1 LEVELS OF IMPLEMENTATION FAILURE

There can be many reasons for a policy to be adopted but not implemented. Sometimes plans
are unrealistic. Sometimes there is a failure to execute critical elements of a plan, whereas other
plans are foiled by much more subtle (all too human) resistance. Still others are simply
overtaken by events—wars, budget crises, changes of government, competing technologies, or
differing ideologies. Many social programs started at the federal level with great effort and then
failed in the field over time. McLaughlin (1984), noting how often legislators develop and adopt
social programs that miss their intended objectives, observed:

It is sometimes tragicomic to read the laws of entitlement, such as the one guaranteeing
equality of education for the handicapped and exceptional children, and then see how they work
out in group homes, classrooms and clinics. Some have blamed public parsimony. Others would
cite professional narrowness, individual insensitivity, and bureaucratic myopia. But much of the
blame falls on the haste with which public policy is adopted, implemented, and then displaced
by new policy. (p. 83)

The “deinstitutionalization” effort of the 1970s is a good example of failure to execute. After early
antipsychotic drugs became available, the inpatient populations of psychiatric hospitals began to
decline. Community mental health centers created to serve people released from mental
institutions were up and running in many areas. Medicaid and Medicare provided some funding,
but despite promises to transfer budgetary resources that had previously gone into psychiatric
hospitals to these centers and other community organizations, the funding never arrived in
sufficient amounts to provide both direct care and supportive services such as housing and
employment training. An entire new population of homeless individuals appeared in our cities,
and the terms revolving door and bag lady entered the public vocabulary. Hospitals and
community centers did not provide coordinated care; they were often separate systems that
competed for the same resources. Furthermore, many community mental health centers drifted
away from the goal of supporting deinstitutionalization of the mentally ill and began serving a
much broader spectrum of patients. As Torrey (1997) noted, “Once trained, however, the vast
majority of these professionals decide to provide psychotherapy for people with mental health
problems rather than treat people who were mentally ill” (p. 185). It is not easy to keep
well-intentioned policies from going off the tracks. As the saying goes, “The devil is in the
details.”

13.2 IMPLEMENTATION PLANNING

Implementation planning arrives early and stays late. It is important to involve all stakeholders,
including the implementers. An Australian Cabinet Implementation Unit process guide referred
to two implementation processes: (1) implementation assessment, which contributes to the
documentation that accompanies the submission of a proposal to the cabinet, and (2)
implementation planning, which continues that process in much greater detail once the decision
is final. Figure 13-1 outlines the stages of the Australian cabinet’s implementation planning
process. Several topics discussed below—scope, funding, risk management, and schedule
(which is discussed as part of the work breakdown)—may also be inputs, alongside program
objectives, outcomes, and governance considerations connected to the strategic
decision-making process.

Scope

Policy making is an art, and the “who, what, where, when, and how” may be changed either
subtly or substantially. Implementers must be aware of what was actually approved. There is a
saying that the camel was intended to be a horse, but it was designed by a committee. Note the
result: the camel is highly adapted to its environment, but it is something quite different from a

horse. Consequently, it needs a very different management approach to operate it and evaluate
its ultimate performance.

In the latter stages of implementation, it is important to establish lines of authority and
accountability for implementation and to consider how the effort interacts with other initiatives
and programs already under way.

images

Figure 13-1 Stages of implementation planning.

It is also important to consider whether the new policy can be implemented effectively using
existing organizational structures, management systems, and funding approaches or whether
there is a need to establish a new structure designed to deliver the changed output.

Work Breakdown

This stage is a detailed analysis of the tasks generated by the implementation requirements of
the policy. Political decision makers are likely to establish important dates (milestones) for
implementation, dates that may or may not be achievable. Then the implementing organization
must get to work:

• Identifying the tasks to be performed, such as submitting a detailed budget, hiring personnel,
finding office space, issuing rules and regulations, establishing advisory committees, and
specifying reporting requirements

• Identifying the units and individuals responsible for each task and gaining their commitment to
complete the task within a specific time period

• Establishing reporting responsibilities for the status of each task

• Including coordination tasks as well as intradepartmental tasks

• Developing a master schedule and an estimated time of completion for the project along with
mechanisms for monitoring progress

Depending on the complexity and urgency of the project, the project implementation staff may
choose to use any one of a number of project management techniques and their associated
software to show what the resulting project duration will be and whether the original target is
likely to be met. If not, implementation planners may decide to undertake a number of efforts to
“crash” the project in order to remain on schedule.1 This process works best when the estimate
of how long an activity will take comes from the individual or team that will be responsible for
that activity. This encourages participants to make realistic estimates and then commit to
meeting their own estimates. For example, the Obama administration shortened the testing

period for the insurance exchanges and failed to have top-level oversight of the process to
determine whether this mission-critical system was up to its assigned tasks.

Funding

Few proposals get considered without a cost figure attached; however, additional steps related
to funding may need to be taken once that figure is approved. Congress authorizes many more
initiatives than it funds. For example, in 1998, Congress passed and President Clinton signed
the Ricky Ray Hemophilia Relief Act, which authorized a compassionate payment of $100,000
to each hemophiliac infected between 1982 and 1987 from contaminated blood products, or to
their families if they had died. This was to compensate for lax government control of the blood
supply. The authorization bill did not include the funding required, estimated to be $750 million.
Only after considerable effort by advocacy groups was $75 million appropriated in fiscal year
2000, $100 million in fiscal year 2002, and $475 million in other years. By the time the program
was terminated in 2005, $559 million had been dispersed.

Risk Management

The Australian Guide to Preparing Implementation Plans states the following:

By understanding the potential risks which may affect the implementation of a policy measure,
agencies can reduce the likelihood or consequence of “unpleasant surprises” that may
jeopardise the achievement of policy objectives.” (Cabinet Implementation Unit, 2006, p. 23)

It suggests that likely risks include

• Unclear objectives and deliverables

• Unrealistic schedules

• Shortages of key resources—funds, people, equipment

• Lack of infrastructure and supports

• Lack of agency internal capacity

Whatever the risk, the planning process needs to assess the likelihood that it will occur, its
severity and impact, how to mitigate it, and who is responsible for preventive measures. It also
needs to address monitoring and how to initiate any needed actions. In situations of high
uncertainty and high impact, such as national security intelligence, analysts are now required to
report their estimates of their certainty regarding their findings.

One way for implementers to ensure that they will be able to respond to changing conditions is
to keep the planning flexible. How does a plan stay flexible?

• By not getting too detailed too early

• By not planning to use the available resources up to their limit

• By checking in with all implementers from time to time to see if anything has changed

• By having the periodic reviews to allow other parts of the plan to adjust to the “as built”
changes that naturally occur

• By making sure the staff knows from the start that there will probably be changes

This does not mean that the planning is not complete. However, it does mean that there are
contingencies built in and that the people on the job are prepared to respond to unexpected
situations as they arise.

Stakeholder Engagement

Implementation must include a review of the stakeholders, including the following:

• Who needs to be kept informed?

• Who needs to participate in what detailed planning activities?

• Who can be an opinion leader or champion of the program?

• Who needs further training and motivation?

• Who can be an enabler?

• Who can be a blocker and needs to be co-opted?

Then, as Table 13-1 illustrates, implementation planners must identify the type of commitment
needed from the implementation stakeholder, how to secure it, key messages that need to be
delivered, and who is responsible for the relationship. Decisions about how to deliver the
message and maintain the relationship follow. Should it be delivered personally, by email,
through the media, through a representative, and so on? After those coordination and
communication tasks are identified, they can be scheduled and assigned to someone.

It often is best to approach this work with stakeholders as meaningful consultation and
collaboration. This can make initial implementation easier because stakeholders who feel that
their ideas have been considered and their concerns addressed are less likely to try to subvert
the process. Chances of success over time are greater if the people and organizations affected
by the project recognize its value and are invested in its success. There will be times, though,

when an implementing agency is given a mandate to implement a policy change on a specific
timeline over the objections of important stakeholders, and this may force the implementation
planners to develop a policy for “stakeholder management”—a term that is in disfavor but may
be apt in such circumstances.

You may recall from discussions of evaluating political feasibility that most techniques involve
collecting information from stakeholders. That is why the most popular framework for
determining political feasibility is called “stakeholder analysis.” Political feasibility inquiries can
yield a lot of information that can be very important during the implementation process. If Delphi
processes, key informant interviews, or other stakeholder outreach efforts were part of a
feasibility evaluation prior to policy adoption, then implementers should review that material.
Even if they feel they know the material, it could be helpful to turn to it with a fresh eye. A
stake-holder concern that was not enough to prevent a policy’s adoption, for example, could
frustrate or even derail that same policy’s implementation. Implementers might also consider
employing such processes after the fact as part of their stakeholder engagement practices.

Table 13-1 Communications Strategy Tool

images

Source: Reproduced from: Guide to Implementation Planning. Licensed from the
Commonwealth of Australia under Creative Commons Attribution 3.0 Australia License. ©
Commonwealth of Australia 2005.

Resources, Including Sourcing and Procurement

Key resource needs should have been identified by this point in time because the funding
requirements depend on the resources needed, especially personnel, equipment, and support
systems. There may also be other less tangible resources that are mission critical, such as
office space, computers and communication equipment, loaned personnel, and contractor
personnel with special skills. For example, it is a frequent practice for contractors to assign their
most competent personnel to preparing and marketing the proposal, but then substitute
underutilized, less experienced, less skilled, or less costly personnel when the work gets under
way. Implementation managers must stay alert to get the quality people and services that they
expected originally.

Quality Assurance

The policy proposal usually specifies the quality and quantity of outcomes anticipated, and it
may refer to the process and outcome measures to be used; however, implementation planners
may still have to develop, validate, and install measures and measurement systems to monitor
progress and suggest improvements as the implementation proceeds. When planning quality
assurance measures, analysts should keep in mind the kinds of data, information, and
documentation needed to conduct an evaluation after the policy has been implemented.

When it comes to sequencing these implementation activities, there is no magic order. After the
proposal stage, many activities may have to go forward on parallel tracks, with the
implementation team making adjustments as problems and opportunities are encountered. New
technology or results from ongoing studies may lead to program changes after the policy
makers have completed their work. If so, the implementation team should inform the policy
makers of the change so that there will be no big surprises when the effort is being reviewed
(e.g., during a site visit). The list of implementation activities is often quite detailed, and it is up
to the implementation team to decide how much planning time to invest in each activity. The
systems necessary to plan and monitor some of these stages may be in place already. The
budgeting and scheduling functions should be basic management activities everywhere.

13.3 SETTING UP TO SUCCEED

Ample evidence suggests that implementation is enhanced by involving implementers early.
This builds their commitment to the plan. Health care is going through a transition from a
professional model that emphasizes individual responsibility, autonomy, and accountability
toward an organizational one, hopefully one where organizational learning and transformation
are norms. To succeed at implementation in this contentious environment, a number of things
need to happen, including:

1. Shared responsibility is accepted. Team leaders and members at all professional levels must
come to share overall responsibility while still accepting individual responsibility for assigned
tasks. The industrialization of health care often means that treatment processes are carried out
by multiple actors whose actions must be coordinated.

2. Leadership takes place at multiple levels. The team involved in developing a policy must
have facts about how the system works at the operational level as well as the strategic level.
Many developing countries still suffer from the system developed by the British Colonial Office
for managing the Empire. This consisted of mostly locals organized into two cadres: one, the
civil service, developed policy, whereas the other, the health service, for example, implemented
it. A small group of British officials controlled the flow of information from one to the other. The
policy makers produced brilliant analyses that circulated in files held together with red ribbon
(called red tape by the English), but these analyses often proved unworkable for implementers
in the field. It was an efficient way to use a small expatriate staff, but it did not necessarily
produce effective delivery systems. All too many policies and plans have become “shelf art,”
sitting there unused because implementers do not see them as practical or relevant.

THE ORIGIN OF A POLICY

The labor, delivery, recovery, and postpartum nursing team at a community hospital was
reviewing its procedures and cost items in order to become more competitive in their city. One
policy that puzzled team members was sending 100% of the placentas to the pathology
laboratory after delivery. They kept asking around for the source of that rule and found that it

stemmed from an incident many years earlier. At the time, the daughter of the chief of obstetrics
was having a difficult delivery and encountered a problem that might have been handled more
effectively if the placenta from her delivery had been saved and analyzed. The angry chief
thoroughly chewed out the OB nursing staff for not saving it. To avoid such a confrontation in the
future, the nursing supervisor instituted the rule that all placentas would go to pathology. Both
the chief of obstetrics and the nursing supervisor had long since retired, but the rule lived on.
The three obstetricians currently practicing at the hospital developed a set of criteria for sending
placentas to the laboratory. This new rule decreased the number of pathology reviews of
placentas by 95%, resulting in substantial cost savings to the patients and the hospital.

3. People understand the core business and technical processes, values, and mission of the
organization. Participants must be knowledgeable and consistent in their decision making about
policies and implementation. Policies and processes rarely bolt out of control. More typically,
they silently drift away from the optimal as individuals and groups make incremental local
adjustments in response to local events, stimuli, and experiences. The example in the box on
pathology review of placentas illustrates how one process moved away from its appropriate
levels.

4. Expectations are managed. Some participants will be optimistic and expect too much,
whereas others will be pessimistic or cynical and expect too little. Wilson and McLaughlin (1984)
suggested that one needs to work out a psychological contract with the planning participants,
one that recognizes the scarcity of resources and directly addresses the WIIFM (what’s in it for
me?) question. Table 13-2 outlines some of the factors such a psychological contract might
consider. In essence, the contract would specify what each party gets from the exchange
beyond monetary considerations.

Table 13-2 The Psychological Contract

The Employee Gets
Performance standards that represent realistic trade-offs between funds, personnel, schedules,
and service levels
Personal courtesy and respect
A supportive environment
Meaningful and purposeful work
Reasonable conflict and tension levels, mediated by clear standards for priority setting and
evaluation of work
Opportunities for personal development
Profession and organizational recognition for good work
Security, as long as funds are available
Process for psychological contract change processes that reflect changing resource conditions
Scarce resources
The Organization Gets
An honest day’s work, at least
Loyalty to the organization

Initiative, especially in resource use
Job effectiveness and efficiency in meeting overall organizational goals
Flexibility and willingness to wear multiple hats under tight staffing
Acceptance of reasonable trade-offs among professional norms and organizational needs
Participation in psychological contract change processes that reflect changing resource
conditions
Source: Reproduced from: Wilson, M., & C. P. McLaughlin. (1984). Leadership and
Management in Academic Medicine, p. 310. Josey-Bass.

5. Planning is continuous. The health care environment is continuously changing. There are
many more opportunities and challenges than most organizations can take on at any one time.
Through functional and cross-functional teams, managers involve providers and others in
setting priorities, developing and evaluating alternatives, and meeting the many new challenges.

6. Orientations are prospective rather than retrospective. Dopson and Fitzgerald (2005) and
Senge and colleagues (1994) observed that behaviors and beliefs take time to change and
require both abstract reasoning and experiential reinforcement. It is often easier to do things the
way they have always been done. Looking to the past for precedent is usually a rational step in
assessing a situation, but there is little assurance that what an organization has been doing is
effective or will be so in the future. “Transformational leadership continually brings forward the
vision of the future organization and indicates how the organization can get from where it is in
the present to where it wants to be in the future” (Upshaw, Steffen, & McLaughlin, 2013, pp.
293–294).

7. Performance is assessed and rewarded. Effective policy change requires that the
organization be prepared to commit real resources and provide support mechanisms for
recognizing creativity and innovation. Personnel evaluation processes and procedures must be
in place to encourage implementers, as well as policy makers, to seek new ways to get things
done and to prepare for the changing future.

13.4 THAT ALL-IMPORTANT START

Starting right is critical. If a team is involved, especially a multidisciplinary one (which would be
the case for just about anything clinical), plan to offer leadership throughout the team formation
cycle, which usually progresses through the following four stages:

1. Forming

2. Storming

3. Norming

4. Performing

Forming

The team needs to understand fully the factors behind the policy change and how it links to the
institution’s strategies. The team’s initial efforts should be well supported and include tasks that
are carefully chosen to build a shared experience of success. At this stage, the team must also
consider whether it includes representation of all the important implementers.

Storming

Because health care settings are complex and have many built-in tensions, team members
often start out blaming, finding fault, or expressing distrust of others. The team members have
to be kept focused on their task until they begin to understand it and accept each other’s
viewpoints.

Norming

The group can then set up norms of operation, detailing, for example, how decisions are made
and how work is allocated. Do we vote? Do we have to have a consensus? What do we have to
clear with higher authority? Do some professional groups have veto power?

Performing

After the barriers at each of the preceding stages are dealt with, the team can get on with its
assigned tasks effectively or, having addressed them and failed to get over them, seek further
guidance or facilitation.

13.5 PROVIDING FOR PERIODIC REVIEWS

Major change projects often require that multiple teams go forward in parallel. Again, one or
more of these may veer off on its own path, so it is important to stage periodic review sessions
in which each team reports what it is doing, compares its progress against measures such as
budget and schedule, and shares what implementation barriers it is experiencing. This process
enables management to assess overall progress and make adjustments to the current plan
where necessary. It also allows individual team leaders to see where they need to interface with
other teams in order to meet their objectives and how to adjust their efforts to reflect what they
learn at the review. The larger and more complex the project, the more important these periodic
reviews become.

13.6 IMPLEMENTING POLICIES THAT AFFECT CLINICAL OPERATIONS

One of the more problematic areas for implementing policy involves getting professionals to
change the way they carry out professional tasks. This has been a topic of concern to those
who study quality of care, provide continuing professional education, or sell pharmaceuticals
and other supplies to the health industry. The move toward greater use of evidence-based

medicine is a case in point. For example, Dopson and Fitzgerald (2005) provided a
meta-analysis of a number of studies of implementing evidence-based practices in the U.K.
Health Service, in which the concluding summary by Ferlie (2005) emphasized the role of
leadership, organizational support, and the differences between knowledge (i.e., information)
and practice:

In the best case examples, there appeared to be a circular relationship between research
evidence and experience—they reinforced each other and were woven together. At other times,
there was a tension between craft knowledge and formal evidence. It should be remembered
that clinical practice contains an element of judgment and tacit knowledge more reminiscent of
craft skills than traditional conceptions of science. It may be unwise to force a stark choice
between the two modes (experience or science), but there may be a need to balance both.
(Ferlie, 2005, p. 188)

Paul Batalden at Dartmouth has suggested that professional training include a microsystem
approach to continuous improvement in health care, operating alongside issues- and
organization-centered efforts. Mohr and Batalden (2006) identified eight dimensions of an
effective, improvement-oriented microsystem (a teaching clinic or hospital service):

1. Constancy of purpose

2. Investment in improvement

3. Alignment of role and training for efficiency and staff satisfaction

4. Interdependence of the care team to meet patient needs

5. Integration of information and technology into work flows

6. Ongoing measurement of outcomes

7. Support from the larger organization

8. Connection to the community to enhance care delivery and extend influence.

13.7 THE POSTMORTEM

Assuming that the group doing the analysis and planning will do this kind of thing again, it is
critical to review the group’s own performance. This postproject analysis should be done by the
planning group if the project is small or medium-sized, or by an independent evaluator if it is
large or mission critical. Evaluation should study two aspects of the project: process and
outcome. Process analysis should take place relatively quickly after the final report is delivered
and should ask this question: “If we had to do this analysis again, what would we do differently?”
Because this can be threatening interpersonally, a little humor would not hurt. The list of phases

of a project in Table 13-3 can be used to lighten things up a little and may also point out
opportunities for improvement.

Clearly, one has to avoid using the postmortem merely to assign blame and to make sure that
the accolades and rewards go to all those who really contributed to the process.

Table 13-3 A Little Humor Might Help: Six Phases of a Project

1. Enthusiasm

2. Frustration

3. Panic

4. Assigning blame

5. Punishing the innocent

6. Rewarding the noncontributors

Source: Reproduced from: W. A. Fischer, personal communication. Used with permission.

Outcomes assessment has to wait until the outcomes are evident. It can only be justified for
major policy proposals that were actually implemented; otherwise, a second analysis might be
needed to focus on what might have been done differently to get that proposal implemented.
The failure to implement might be primarily due to outside factors. Either way, one should be
able to go back through the analysis and see how well the group defined the situation, assessed
the technology, outlined the economics, adjusted to the political system, planned the
implementation, and presented the product to the decision makers. Such a review is a key to
improved organizational learning about policy analysis.

13.8 CONCLUSION

There is no silver bullet to make implementation easy; however, the elements of successful
implementation are well known. They involve top management consideration and support. They
require an understanding of the social context in which change takes place. Would-be
implementers must focus on the players, their roles, their barriers to action, and the roles of
leadership and influencers in bringing about change. From an academic viewpoint, all of these
should be worked out so that strategic policies are not derailed by the implementation details;
however, decision makers are usually not comfortable with that level of detail as they deal
broadly with a wide range of issues. They are very uncomfortable with surprises after the fact,
but they also do not want to be bogged down reading the fine print. That is just a managerial
reality. Perhaps the best answer is to turn to the experienced presenters on the team who know

the behavior patterns of key decision makers and ask for their assessment of the appropriate
level of detail to present at each stage.

Case 13 340B Drug Pricing Program Oversight
Section 602 of the Veterans Health Care Act of 1992 was titled “Limitations on Prices of Drugs
Purchased by Certain Clinics and Hospitals.” It amended the Public Health Services Act by
adding a new section, Section 340B, to that act. Section 602 of the Veterans Health Care Act
read in part:

Part D of title III of the Public Health Service Act is amended by adding the following subpart:
“SUBPART VII – DRUG PRICING AGREEMENTS” LIMITATION ON PRICES OF DRUGS
PURHASED BY COVERED ENTITIES “Sec. 340B (a) Requirements for Agreement with
Secretary – “(1) In general. The Secretary shall enter into an agreement with each manufacturer
of covered drugs under which the amount required to be paid … to the manufacturer for covered
drugs … does not exceed an amount equal to the average manufacturer price for the drug
under title XIX of the Social Security Act in the preceding quarter, reduced by the rebate
percentage described in paragraph (2). “Rebate percentage defined. – (A) In general. For a
covered outpatient drug … the ‘rebate percentage’ is the amount equal to – “(i) the average total
rebate required under Section 1927(c) of the Social Security Act … for a unit of the dosage form
and strength involved during the preceding quarter divided by “(ii) the average manufacturer
price for such a unit of the drug during such quarter….”

Section 340B applied Medicaid drug discounts to drugs purchased for clinics that served many
outpatients who were not eligible for Medicaid at qualified safety-net institutions. For the most
part, eligible clinics were associated with hospitals receiving disproportionate share payments
under Medicare, pediatric hospitals, and community health centers. Also included were
specialized clinics and projects for HIV/AIDS, hemophilia, black lung, tuberculosis, and family
planning, as well as those serving Native Americans and Native Hawaiians. Hospitals were
required to be governmental or nonprofit with a contractual commitment to provide services
supported by governments, have a disproportionate share percentage greater than 11.75, and
not obtain the covered drugs through a group purchasing agreement. The drugs had to be used
for patients of the covered entity and could not be resold.

A key provision of Section 340B read “(10) No prohibition on larger discount. Nothing in this
subsection shall prohibit a manufacturer from charging a price for a drug that is lower than the
maximum price that may be charged under paragraph (1).” The Patient Protection and
Affordable Care Act (ACA or PPACA) increased the 340B discount to 13% on generic drugs and
23.1% on branded drugs. Specific discounts have been reported to range from 15–60% on
prescription drugs. The law prohibits getting both a state Medicaid rebate and a 340B discount
on a drug.

BACKGROUND

In the 1980s, Congress established a discount drug purchasing program for the Veterans
Administration. In 1990, it extended this discount program to Medicaid purchases on behalf of
low-income and uninsured enrollees under the Medicaid Drug Rebate Program. Soon it became
clear that this law conflicted with another requirement that state Medicaid programs receive
discounts matching the lowest prices offered in non-Medicaid markets. Congress moved to
remedy this problem. Otherwise, the participating pharmaceutical and biotechnology companies
would choose to stop offering discounts across the board.

The 340B program is administered by the Office of Pharmacy Affairs within Health Resources
and Services Administration (HRSA) of the Department of Health and Human Service. This
office is tasked with auditing compliance with program requirements, especially the eligibility of
covered entities, and program integrity concerning diversions and duplicate discounts and
manufacturer pricing. However, this office has a very limited staff, and the number of institutions
taking advantage of the program has been growing rapidly. HRSA also supports a number of
other programs, such as the Ryan White HIV/AIDS program and community and rural health
centers that are covered entities for 340B drug discounts.

The HRSA website describes the intent of 340B in a listing of Frequently Asked Questions to be
“to permit covered entities to stretch scarce Federal resources as far as possible, reaching more
eligible patients and providing more comprehensive services” [HR Rep. No. 102-384 384(II) at
12 (1992)].

Although there are limitations on billings to Medicaid patients, there are no constraints on
billings to non-Medicaid patients.

The ACA freed up hospitals to choose among discount sources such as 340B and their group
purchasing organizations. The ACA also made a number of provisions to strengthen program
integrity.

Section 1703 of the ACA called for a Government Accounting Office (GAO) study of the
program:

… that examines whether those individuals served by the covered entities under the program
under section 340B of the Public Health Service Act (42 U.S.C. 256b) (referred to in this section
as the “340B program”) are receiving optimal health care services.

(b) RECOMMENDATIONS. – The report under subsection
(a) shall include recommendations on the following:
(1) Whether the 340B program should be expanded since it is anticipated that the 47,000,000
individuals who are uninsured as of the date of enactment of this Act will have health care
coverage once this Act is implemented.

(2) Whether mandatory sales of certain products by the 340B program could hinder patients
access to those therapies through any provider.

(3) Whether income from the 340B program is being used by the covered entities under the
program to further the program objectives.
THE 2011 GAO STUDY

That study was issued by the GAO in September 2011. In the conclusions it noted:

The 340B program allows certain providers within the U.S. health care safety net to stretch
federal resources to reach more eligible patients and provide more comprehensive services,
and we found that the covered entities we interviewed reported using it for these purposes.
However, HRSA’s current approach to oversight does not ensure 340B program integrity, and
raises concerns that may be exacerbated by changes within the program. According to HRSA,
the agency largely relies on participants’ self-policing to ensure compliance with program
requirements, and has never conducted an audit of covered entities or drug manufacturers. As a
result, HRSA may not know when participants are engaging in practices that are not in
compliance. Furthermore, we found that HRSA has not always provided covered entities and
drug manufacturers with guidance that includes the necessary specificity on how to comply with
program requirements. There also is evidence to suggest that participants may be interpreting
guidance in ways that are inconsistent with the agency’s intent. Finally, participants have little
incentive to comply with program requirements, because few have faced sanctions for
noncompliance …
PPACA [i.e., ACA] outlined a number of provisions that, if implemented, will help improve many
of the 340B program integrity issues we identified. For example, PPACA requires HRSA to
recertify eligibility for all covered entity types on an annual basis … Additionally, PPACA requires
HRSA to develop a formal dispute resolution process, including procedures for covered entities
to obtain information from manufacturers, and maintain a centralized list of 340B
prices—provisions that would help ensure covered entities and manufacturers are better able to
identify and resolve suspected violations. PPACA also requires HRSA to institute monetary
penalties for covered entities and manufacturers, which gives program participants more
incentive to comply with program requirements. Finally, PPACA requires HRSA to conduct more
direct oversight of manufacturers, including conducting selective audits to ensure that they are
charging covered entities the correct 340B price.
However, we identified other program integrity issues that HRSA should also address. For
example, the law does not require HRSA to audit covered entities or further specify the agency’s
definition of a 340B patient. While HRSA has developed new proposed guidance on this
definition, it is uncertain when, or if, the guidance will be finalized.
Because the discounts on 340B drugs can be substantial, it is important for HRSA to ensure
that covered entities only purchase them for eligible patients both by issuing more specific
guidance and by conducting audits of covered entities to prevent diversion. Additionally, while
PPACA included a provision prohibiting manufacturers from discriminating against covered
entities in the sale of 340B drugs, HRSA does not plan to make any changes to or further
specify its related nondiscrimination guidance.
Absent additional oversight by the agency, including more specific guidance, access challenges
covered entities have faced when manufacturers’ have restricted distribution of IVIG at 340B

prices may continue and similar challenges could arise for other drugs in the future. (GAO,
2011, pp. 33–34)
HOW IS THE PATIENT HELPED?

The ACA and the GAO report said little about getting the resulting savings to the patient’s bill.
As the law has been modified over the years, the direct link to the low-income, uninsured patient
has weakened. The discounted drugs can even be used for commercially insured patients. The
2011 GAO report found that “some covered entities passed 340B savings on to patients by
providing lower-cost drugs to uninsured patients. For example, many covered entities
determined the amount that a patient is required to pay based on the lower cost of 340B-priced
drugs” (p. 17). The report noted that some covered entities had indicated that without the
discounts they would have to close their pharmacy or curtail other services.

For a number of reasons, operating the 340B program in the hospital environment creates more
opportunities for drug diversion compared to other covered entity types. First, hospitals operate
340B pharmacies in settings where both inpatient and outpatient drugs are dispensed and must
ensure that inpatients do not get 340B drugs. Second, hospitals tend to have more complex
contracting arrangements and organizational structures than other entity types—340B drugs
can be dispensed in multiple locations, including emergency rooms, on-site clinics, and off-site
clinics. In light of this and given HRSA’s nonspecific guidance on the definition of a 340B patient,
broad interpretations of the guidance may be more likely in the hospital setting and diversion
harder to detect. Third, hospitals dispense a comparatively larger volume of drugs than other
entity types—while representing 27 percent of participating covered entities, according to
HRSA, DSH hospitals alone represent about 75 percent of all 340B drug purchases. (GAO,
2011, p. 29)

OTHER IMPACTS OF THE ACA

The ACA added a number of classes of institutions, including affordable care organizations,
freestanding cancer hospitals, clinical access hospitals, rural referral centers, and sole
community hospitals. Many millions of uninsured individuals are to receive insurance. This
would greatly increase the consumption of 340B drugs, even though one might argue that the
original need for the 340B program was partially mitigated.

MANUFACTURER PUSHBACK

In early 2013, the Biotechnology Industry Organization (BIO) issued a white paper subtitled “A
Review and Analysis of the 340B Program.” It was cosponsored by the Community Oncology
Alliance (COA), the National Community Pharmacists Association (NCPA), National Patient
Advocate Foundation (NPAF), the Pharmaceutical Care Management Association (PCMA), and
the Pharmaceutical Research and Manufacturers of America (PhRMA). The report’s executive
summary cited:

Areas of most concern included the following:

• Concerns that some uninsured, indigent patients may not be experiencing direct benefit from
the program’s existence.

• Anecdotal evidence that clinical decision-making may be skewed by efforts to take advantage
of the 340B discount.

• Growing evidence of displacement of non-340B providers who serve a key role in providing
patient access to important health care services. (BIO, 2013, p. 1)

The same executive summary cited the concerns expressed in the GAO report, as well as
insufficient resources at HRSA to carry out its responsibilities under 340B and the ACA, the
need for clearer guidance, and HRSA’s use of “subregulatory” procedures to clarify definitions
and establish interpretive guidelines.

The HRSA website contained the following observation:

PROGRAM GUIDELINES

HRSA chose to publish guidelines in the Federal Register rather than regulations to administer
the Section 340B program. Guidelines are the quickest and most flexible way to convey to all
concerned parties how HRSA interprets the Section 340B requirements. Guidelines are also
used to disseminate procedures that are acceptable under the statute. To ensure that the
guidelines were as appropriate and responsive as possible to the legitimate concerns of the
covered entities and manufacturers, comments were solicited on all of the guidelines before
HRSA published them in a final notice.

The BIO white paper cited the changed guidance that allowed covered entities to use contract
pharmacies as an example of HRSA expanding this program by administrative means.
Subsequently, the number of 340B contract pharmacy arrangements climbed from about 3,000
in 2010 to more than 9,000 in 2012, with more than 12,000 projected for 2012. The white paper
claimed these arrangements were forcing some community pharmacies out of business.

SENATOR GRASSLEY’S INQUIRIES

Senator Charles E. (Chuck) Grassley (R-Iowa) has often been critical of nonprofit hospitals, and
his concern about their implementation of the 340B program is just one example. His office often
follows up on public disclosures that provide an investigative opening and an opportunity to prod
HRSA about its oversight of the program.

The UAB Inquiry

For example, as ranking member of the Senate Judiciary Committee, he sent a letter on May
19, 2012, to Dr. Carol Garrison, president of the University of Alabama (UAB) Hospital, stating
that:

The original intent of the program was to extend the Medicaid drug discount to the most
vulnerable patients at PHS Clinics, those who are mostly, “medically uninsured, on marginal
incomes, and have no other source to turn to for preventive and primary care services.” …
On February 16, 2011, Donna Evans, R.Ph., Senior Pharmacist, with University of Alabama
(UAB) Hospital gave a presentation at the 340B Annual Conference in San Diego, California. In
this presentation, Ms. Evans stated that the purpose of the Purchasing Committee is, among
other things, to “maximize savings opportunities.” Ms. Evan’s presentation goes on to state that
UAB Hospital tracks the top drug expenses for “possible change in admission[s] process.” As an
example of this change in admission process, Ms. Evans lists the drugs Melphalan and
Busulfan and stated that the hospital “change[d] treatment protocol/location.” Furthermore, Ms.
Evans’ presentation discussed the “discharge [of an IVIG patient] from [the] hospital to [a]
Townhouse,” for the purpose of maximizing savings opportunities associated with the 340B drug
discount provided in an outpatient setting.
Ms. Evans’ presentation is deeply disconcerting (Grassley, 2012, pp.1-2).
Senator Grassley asked the hospital to document the frequency and economics of such
changes in admission status and 340B discounts in general, what the hospital did with the
savings, and whether HRSA had ever audited it.

The North Carolina Major Hospitals Inquiry

In 2012, McClatchy newspapers in Charlotte and Raleigh, North Carolina, ran articles about
major hospitals buying up oncology practices and substantially raising chemotherapy drug
prices in these outpatient settings (Alexander & Garloch, 2012). In September 2012, Senator
Grassley sent letters to three major hospitals cited in the articles, asking how much they earned
by participating in the 340B Program, the breakdown of the 340B payer mix, and how they had
reinvested those 340B dollars into serving the most vulnerable patients. Senator Grassley
summarized their replies in a March 27, 2013, letter to Dr. Mary K. Wakefield, HRSA
administrator:

First, all three North Carolina hospitals provided a summary of revenue generated by
participating in the 340B program from 2008. Below is a revenue summary …

Carolinas Medical Center

UNC

Duke

2008: $12,970,012

2009: $33,087,329

2009: $88,953,570

2009: $16,697,500

2010: $38,451,076

2010: $109,700,400

2010: $16,910,620

2011: $52,580,763

2011: $131,759,091

2011: $21,065,620

2012: $65,391,050

2012: $135,539,459

These are not small amounts.

These numbers paint a very stark picture of how hospitals are reaping sizeable 340B discounts
on drugs and then turning around and upselling them to fully insured patients covered by
Medicare, Medicaid, or private health insurance in order to maximize their spread. (Grassley,
2013, pp. 1–2)

All three hospitals were able to provide their 340B payer mix for the period 2008–2010. The
data for 2010 taken from Senator Grassley’s letter is presented in the table below:

images

The Raleigh News & Observer of April 3, 2013, reported on Senator Grassley’s inquiry and
stated that “Last year, Duke University Hospital purchased $65.8 million in drugs through the
program and received $135.5 million in revenue. Duke says it saved $48.3 million buying the
drugs through the 340B program. That means the hospital made a profit of $69.7 million,
instead of $21.4 million if it had not participated in the program”(Alexander, Neff, & Garloch,
2013, p. A1).

Sen. Grassley’s letter then goes on to ask a series of questions seemingly aimed at getting
HRSA to collect this type of data routinely.

Discussion Questions

1. What seems to be the true intent of the 340B drug discount program? How would you go
about clarifying the legislative intent?
2. What conclusions do you draw from the data provided to Senator Grassley?
3. What data would you like to make the covered entities provide to HRSA on a routine basis?
4. Discuss the merits of using the “subregulatory” process versus the normal rule-making
procedures.
5. As the ACA is implemented, what will be the impact of the 340B program on pharmaceutical
and biotechnology firms?
6. What are the merits of using disproportionate share as a screen for whether acute care
hospitals are covered entities? What about the average manufacturer’s selling price as a
denominator in calculating the discount? What alternatives would you recommend?
7. What are the merits of Senator Grassley’s investigative methods, given that he holds formal
hearings on health policy issues as well?
8. What events or policy shifts would support the contraction or expansion of the 340B
program?
1Many systems for project planning and scheduling are available, including the Critical Path
Method (CPM) and the Program Evaluation and Review Technique (PERT). These methods
enable staff to build a feasible schedule and to track performance, updating that schedule as the
effort moves along. Microsoft Project is one such program that is usually readily available.

Strayer discussion 8 hours needed

Apa format 

1-2 paragraphs 

references 

Suggest three ways a mentor and an employee orientation program can assist new employees with their career development.

  • Identify which of the three you value most and explain why.
  • Share your experience with mentorship and how it supported your career progression.

Facebook Dilemma

**Part One

With the rise and growing dependence on social media, there come consequences. The Facebook Dilemma explores how social media is reprogramming society, which could impact privacy, the way we think, act and live our lives. 

Instructions: Please watch the FRONTLINE “The Facebook Dilemma.” 

• Part One: https://www.youtube.com/watch?v=T48KFiHwexM&feature=youtu.be 

• Part Two: https://www.youtube.com/watch?v=EuA4qxPbpQE Draft a two-page paper which includes the following:

 • Relating the central themes of the movie to social media marketing. 

• The influence it has on buying decisions.

 • How marketers are benefiting from it. Requirements:

 • Submit a Word document in APA format. 

• Two pages in length, excluding the Title and Reference pages. 

• At least two unique high-quality references.

**Part Two

Analyzing social media trends and traffic has emerged as the surest route to capturing more leads and enjoying stronger sales. 

For example, Instagram’s referral traffic has sky-rocketed between Q1 2018 and Q1 2019 as the popular social media site becomes more important for website traffic

Business Scenario 

Austin is a freelance graphic designer hired by Hootsuite to create a PowerPoint slide deck designed to be used by Hootsuite’s sales team. The team will use the deck in upcoming sales presentations as they meet with prospective new customers. 

Austin will design the slides but he needs you to supply the rationale and justification to convince a prospective Hootsuite customer why it is imperative to track web traffic. Specifically, Austin will design the slide deck based on your information/research regarding:

Questions

  1. What are the various sources of web traffic including current trends?
  2. How can a brand analyze these sources of traffic to better align its strategies to fit the characteristics of its target segments?

ASSOCIATIONS MEMBERSHIP

· Examine the importance of professional associations in nursing. Choose a professional nursing organization that relates to your specialty area, or a specialty area in which you are interested (
American Association of Nurse Practitioners
)

. In a 750‐1,000 word paper, provide a detailed overview the organization and its advantages for members. Include the following:

1. Describe the organization and its significance to nurses in the specialty area. Include its purpose, mission, and vision. Describe the overall benefits, or “perks,” of being a member.

2. Explain why it is important for a nurse in this specialty field to network. Discuss how this organization creates networking opportunities for nurses.

3. Discuss how the organization keeps its members informed of health care changes and changes to practice that affect the specialty area.

4.  Discuss opportunities for continuing education and professional development.

speech

How can Social workers inform the school system and parents on child abuse patterns? 
Point 1: What is the prevalence of child abuse?
Point 2: What is the greatest risk factor for abuse?
Point 3: How parents can inform their children on a personal level in the home or incorporating this into school curriculum?

SPEECH OUTLINE GUIDE

Title of Your Speech

Your Name

General Purpose: To _______

Specific Purpose Statement: This statement should include what specifically you plan to inform the audience about. (communication word + target audience + content)

I. INTRODUCTION

A. Attention Getter: This represents the first words out of your mouth! So make sure it GRABS the audience. Make sure it is relevant/appropriate to your topic. Some devices you can use for the attention getter are:

· Joke/Humor (Make sure it is appropriate/in good taste!)

· Narrative/Story (Be brief)

· Shocking Statement

· Fact/Statistic

· Poem

· Quote

· Question

· Visual Aid/Activity

B. Central Idea (Thesis) Statement: This statement should clarify to the audience what you are going to inform them about and introduce your topic. Answer the questions, “Why am I here and what is my overall point?”

C. Significance: This statement should let the audience know why it is relevant and/or important to them.

D. Credibility: (optional, but will help create ethos with your audience) If you have a particular credibility with a topic (i.e. if you have diabetes and your speech is on diabetes) then reveal this in a credibility statement. This will help create trust between you and your audience and demonstrate that you know what you are discussing.

E. Preview Statement: This statement lays out in one simple sentence a clear picture of what is to come in your speech. Be sure to use parallel words/signposts (i.e. first, second, third) to be simple and concise and help your audience follow along.

MAJOR TRANSITION: This statement allows the audience to hear that you are moving from the introduction to the body and can be relatively brief. “Now that we know what we are going to discuss, let us first look at….”

II. BODY

A. Main Point 1: Provide a general opening sentence which previews information and evidence to come in the sub-points below.

1. Sub-point: Related to the main point, but provides more specific information and may include evidence to support.

2. Sub-point: Related to the main point, but provides more specific information and may include evidence to support.

i. Related to the first sub-point, but again, provides even more detailed information/evidence.

Minor Transition: This sentence shows movement from point A to point B.

B. Main Point 2: Provide a general opening sentence which previews information and evidence to come in the sub-points below.

1. Sub-point: Related to the main point, but provides more specific information and may include evidence to support.

2. Sub-point: Related to the main point, but provides more specific information and may include evidence to support.

i. Related to the first sub-point, but again, provides even more detailed information/evidence.

Minor Transition: This sentence shows movement from point B to point C.

C. Main Point 3: Provide a general opening sentence which previews information and evidence to come in the sub-points below.

1. Sub-point: Related to the main point, but provides more specific information and may include evidence to support.

2. Sub-point: Related to the main point, but provides more specific information and may include evidence to support.

i. Related to the first sub-point, but again, provides even more detailed information/evidence.

3. Sub-point: Related to the main point, but provides more specific information and may include evidence to support.

i. Related to the first sub-point, but again, provides even more detailed information/evidence.

MAJOR TRANSITION: This sentence should move the audience from your body into your conclusion.

III. CONCLUSION

A. Summary Statement: This statement should reiterate your points again to summarize what your audience learned about in your speech. Make sure to include all of your main points. This should be the mirror image of your preview statement but written/spoken in past tense, “Today we have learned about…”

B.
Call to Action (used in persuasive speaking):

This statement should ask the audience to complete a reasonable task that is related to your topic.

C. Final Thought: This sentence should leave your audience with a great last impression of you and your speech/information. Like the attention getter, you can use devices such as a quote, question, story, joke, etc. to create a lasting memory.


WORKS CITED

Your works cited should represent the information/evidence you use within your speech. You should have at least five sources. Make sure to put citations in APA format and list in alphabetical order according to last name of authors.

3

For this assignment, you will create an informative full-sentence speech outline on a topic of your choice within the Communication field. This outline should be a minimum of 700 words with at least 5 credible sources.

This is a Gordon Rule assignment so please consider getting assistance from our writing tutors in Learning Resources: 


https://www.mdc.edu/learning-resources/tutoring-labs-technology/make-an-appointment/

Informative Outline Requirements:

· Topic within or clearly connected to the Communication discipline

· Outline format, all parts of speech included and labeled correctly

· At least 700 words (not including speech labels or reference page)

· At least 5 credible sources correctly cited in APA format and incorporated as evidence

· Demonstrate effective thesis development and support for a specific topic

· Demonstrate effective organization of content

· Use effective language (grammar, mechanics, sentence structure)

· Adequately address the purpose and audience

Discussion 8

 PART A 

 Please respond to the following:

  • Analyze the importance of production planning and scheduling within an organization. Evaluate a bad experience you have had with an appointment from the perspectives of the customer (you) and the organization with regard to inefficient planning and scheduling.
  • Analyze the experience you provided from a process perspective. Suggest ways the schedules could have been designed to be more efficient and effective.
  • Be sure to respond to at least one of your classmates’ posts.

PART B

 A Mentor, Coach, Advisor COLLAPSE Overall Rating

Please complete the following:

Your team isn’t just people who work under you; you must surround yourself with people who can advise you, challenge you, and keep you honest—including mentors, coaches, and advisors. All members of a team must be aligned towards common goals. The team must have shared expectations and clearly identified priorities. Last week, you put together a fantasy team of four JGR employees to plan and run a daylong conference. Think about this team’s individual strengths and weaknesses. Then determine whether your team would most benefit from a coach, advisor, or mentor. What sort of person do you think would be a good advisor, mentor, or coach for this team based on the team need and why? How will their expertise make the team more cohesive?

Remember to keep your focus on what role would best serve the team and you as leader, rather than a specific person.

week 5 research

Based on Descriptive research design, mixed methods and meta-analysis & Epidemiology and Longitudinal Studies,  as well as your pending research problem, what type of study do you believe you are conducting, and please explain why?

6

How to Reduce Heparin Drips Administration Errors

Lianet Aroche

Florida National University

Nursing Research

05/28/2022

How to Reduce Heparin Drips Administration Errors

Introduction and problem statement

Heparin is an anticoagulant drug used for various uses, including thromboembolic prophylaxis and treatment and the management of central venous access. It comes in different concentrations (1000 units/mL or greater) for therapeutic and prophylactic usage and lower concentrations, that is 100 units/mL or less, used in heparin lock flushing solutions. Heparin administration is greatly associated with medical errors resulting in severe consequences on patients’ health (Warnock & Huang, 2019, p. 49). Three high-profile occurrences involving this medicine at three prominent US institutions brought safety concerns about heparin use to the forefront. The Joint Commission’s National Patient Safety Goal (NPSG) 03.05.01, “lower the chances of patient harm due to anticoagulant medication use,” emphasizes the safe anticoagulant therapy use and monitoring.

Despite a previous attempt in a large Midwestern hospital to develop standard heparin administration procedures using a computerized system, errors continued to occur at unacceptably high rates. Heparin Error Reduction Workgroup (HERW) was formed in 2002, by pharmacists, staff nurses, and cardiologists. The HERW hired consultants of human factors to conduct an analysis of the human factors process of heparin administration among the nursing staff (Treiber & Jones, 2018, p. 159). Between 1999 and 2003, heparin was the most commonly used medicine in 14,800 ED medication mistakes.

Heparin is a medication that, if used wrongly, can result in serious hemorrhagic complications. Over five years, heparin dosing in large metropolitan hospitals with evolution has become more difficult. Heparin was formerly prescribed and monitored unevenly by physicians (Lee & Riley, 2021, p. 515). Heparin dose regimens were established and applied to ensure standardized dosing, optimized therapy, and reduced hazards. The dosing methods grew in number as heparin administration became more sophisticated and patient-specific. The protocols were originally only available on written paper. The benefits of computerized access in drug administration were exploited to improve protocol delivery and boost upgrade efficiency. Interactive computer software was developed to make protocol usage easier.

Three premature newborns died due to drug errors in an Indiana hospital that drew national attention. The Heparin overdoses were accidentally given to newborns because the incorrect strength was utilized to prepare umbilical line flushing solutions. The mistake occurred when 1 mL vials were accidentally put in a unit-based automated dispensing cabinet (ADC) where heparin 10,000 units/ml, 1 ml vials were commonly kept (Lee & Riley, 2021, p. 519). Nothing can take away the families’ pain in the aftermath of this unfortunate tragedy, and this keeps reminding us of the necessity to take precautions and closer examination of heparin use in our institutions.

The use of heparin includes;

· Prevention of enlargement of existing clots.

· Treatment and prevention of pulmonary emboli and deep venous thrombosis (Warnock & Huang, 2019, p. 49).

· Decreasing the risk of the development of blood clots.

· Maintaining patency of indwelling venous catheters.

The significance of Heparin administration errors administration to nursing.

Medicine errors can happen during any stage of the process of medication administration, including prescribing, transcription, dispense, and administration. However, previous researches have shown that pharmaceutical errors are more frequent during the phase of drug administration. This is because nurses administer the majority of the drugs. Heparin, for instance, is commonly administered and monitored by nurses (Warnock & Huang, 2019, p. 49). The nurses receive the clients’ medication upon prescription and dispatch and administer. Nurses can ensure improved patient safety through interruption of medication errors before reaching the client through adhering with six drug delivery rights and reporting of the problem.

Nurses confront problems in many facets of their work, particularly when safely providing and monitoring medications. General drug information and knowledge, formal nursing education, continuous education needs, clinical area experience, and nursing shortage nationwide are all recognized to impact client drug administration (Santomauro et al., 2021, p. 449). Other causes include technological advancements and quality-improvement programs. Patient safety is becoming more important, especially regarding medication therapies and high-alert drugs like unfractionated heparin (UFH). Specific UFH administration treatments can improve patient care management. Nurses are generally in a good position to spot pharmaceutical errors because they are on the front lines of patient care. On the other hand, nurses must work closely with other healthcare providers to achieve their goals.

The nurses should countercheck the medication dosage and administer them in the correct dosage. The nurses may prepare the heparin with different strengths wrongly, thus resulting in various errors. In addition, the preparation and administration of heparin differ in different types of heparin strengths. The errors also occur due to storage of heparin with different strengths in one place, poor documentation of the prescribed heparin in the ED, lack of individual/ independent double-checking of the heparin administration dosage, and incorrect programming of the infusion pumps (Gray, 2018, p. 369). These errors often occur among the nursing staff. Therefore, nurses should consistently check and document the heparin before administering it to the client. They should also independently double-check the heparin to prevent medication dose calculation errors. They should also ensure that the infusion pumps are correctly programmed to prevent over coagulation of the client’s blood.

Research purpose

The purpose of this research is to evaluate the causes of heparin drip administration errors and the ways through which these errors can be reduced. The heparin drips administration errors are very common and result in serious complications, at times, death of the clients. Despite the improvement in the majority of the errors that occur with heparin administration, such as the wrong client, several other errors have occurred with the administration of the heparin medication. 2.01 errors occur in 1000 heparin doses charged. The errors occur due to the incorrect handling of the heparin medication by different hospital personnel, such as pharmacists and physicians; however, most of the errors often occur from the nursing staff (Litman, 2018, p. 439). Therefore, the research paper aims to determine the causes of these errors and how to prevent them from occurring.

Research Questions

The research purposes to answer the following research questions;

1. What is the prevalence of heparin drips administration errors?

2. What are the factors associated with heparin drip administration errors?

3. How can heparin drip administration errors be prevented?

Conclusion

Intravenous heparin is used in the prevention of thrombosis in various clinical settings. It is considered a high-risk medication used in inpatient settings, commonly critical care units. The variation in the heparin administration protocols contributes to the majority of the drug errors associated with serious complications and mortalities. Some of these causes include drug dose calculation and preparation errors. Some of the prevention of heparin drip infusion errors include independent double-checking of the medication dose and preparation, correct programming of the infusion pumps, and clear documentation of the administered heparin dosage. However, there is a need to find out more about errors associated with heparin administration, their causes, and prevention to reduce the complications that occur with the errors.


References

Gray, G. (2018). Commentary: Improving Care through Innovations in Infusion Systems. Biomedical Instrumentation & Technology52(5), 366-371.

https://pdf.manuscriptpro.com/search/Abstract~30260667/1/cda77bb7/Commentary:-Improving-Care-through-Innovations-in-Infusion-Systems.

Lee, M. H., & Riley, W. (2021). Factors associated with errors in the heparin dose-response test: recommendations to improve individualized heparin management in cardiopulmonary bypass. Perfusion36(5), 513-523.https://pubmed.ncbi.nlm.nih.gov/32909506/

Litman, R. S. (2018). How do we prevent medication errors in the operating room? Take away the human factor. British Journal of Anaesthesia120(3), 438-440. https://pubmed.ncbi.nlm.nih.gov/29452799/

Santomauro, C., Powell, M., Davis, C., Liu, D., Aitken, L. M., & Sanderson, P. (2021). Interruptions to intensive care nurses and clinical errors and procedural failures: A controlled study of causal connection. Journal of Patient Safety17(8), e1433-e1440. 441-461. https://pubmed.ncbi.nlm.nih.gov/30113425/

Treiber, L. A., & Jones, J. H. (2018). Making an infusion error. Journal of Infusion Nursing41(3), 156-163.
https://pubmed.ncbi.nlm.nih.gov/29659462/

Warnock, L. B., & Huang, D. (2019). Heparin. https://pubmed.ncbi.nlm.nih.gov/30855835/

smoking

 

  • Discuss at least two health implicative effects of environment and smoking on an unborn fetus or children. Your initial response should be between 350 words. Use 2 scholarly articles.

sql query

there is no login the work does not save 

CREATE TABLE IF NOT EXISTS LitCharacters (
idLitCharacters INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
Name TEXT
Realm TEXT
CreatureType TEXT
CreatureSubType TEXT
Gender TEXT
Height INTEGER
Weight INTEGER
Appearances INTEGER);
INSERT INTO LitCharacters (Name Realm CreatureType CreatureSubType Gender Height Weight Appearances) VALUES
(‘Kaerio’ ‘Magical’ ‘Human’ ‘Merman’ ‘Male’ ’67’ ‘194’ ’10’)
(‘Lituck’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Male’ ’42’ ‘258’ ‘9’)
(‘Hissing Hornet’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Male’ ’61’ ‘205’ ‘5’)
(‘Rugby Defiant Eldon’ ‘Real’ ‘Human’ ‘Pirate’ ‘Male’ ’67’ ‘168’ ‘0’)
(‘Belet the Hero’ ‘Real’ ‘Human’ ‘Knight’ ‘Female’ ’70’ ‘270’ ‘4’)
(‘Mistress Shaggy Wraith’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Female’ ’66’ ‘175’ ‘0’)
(‘Swift Shadow’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Female’ ’83’ ‘179’ ‘1’)
(‘Doctor Heavenly Daggers’ ‘Real’ ‘Human’ ‘Superhero’ ‘Female’ ’89’ ‘183’ ‘0’)
(‘Carpus Jesterrose’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Male’ ’11’ ‘5’ ‘7’)
(‘Wilhelmine Slayer England’ ‘Real’ ‘Human’ ‘Pirate’ ‘Female’ ’70’ ‘136’ ‘0’)
(‘Saffron Copperspeck’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Female’ ’12’ ‘6’ ‘0’)
(‘Leonore The Wall Clive’ ‘Real’ ‘Human’ ‘Pirate’ ‘Female’ ’66’ ‘133’ ‘9’)
(‘Oceane’ ‘Magical’ ‘Human’ ‘Mermaid’ ‘Female’ ’60’ ‘112’ ‘0’)
(‘Scarlet Almonddove’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Female’ ’14’ ‘5’ ‘5’)
(‘Courage’ ‘Magical’ ‘Animal’ ‘Wolpertinger’ ‘Male’ ’11’ ‘8’ ‘0’)
(‘Doria’ ‘Magical’ ‘Human’ ‘Mermaid’ ‘Female’ ’67’ ‘124’ ‘5’)
(‘Delmara’ ‘Magical’ ‘Human’ ‘Mermaid’ ‘Female’ ’60’ ‘126’ ‘0’)
(‘Cosmos’ ‘Magical’ ‘Animal’ ‘Jackalope’ ‘Female’ ’10’ ‘9’ ‘2’)
(‘Dr. Deficit’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Female’ ’72’ ‘139’ ‘0’)
(‘Truffle’ ‘Magical’ ‘Animal’ ‘Jackalope’ ‘Male’ ’13’ ‘8’ ‘0’)
(‘Lula Stormrider Williams’ ‘Real’ ‘Human’ ‘Cowgirl’ ‘Female’ ’64’ ‘126’ ‘0’)
(‘Superchelosaurus (Super Claw Lizard)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Female’ ‘202’ ‘26974’ ‘0’)
(‘Prof. Queasy’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Male’ ’72’ ‘142’ ‘0’)
(‘The Voiceless Arsonist’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Female’ ’58’ ‘184’ ‘9’)
(‘Moonbean Mistyweather’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Male’ ’11’ ‘4’ ‘0’)
(‘Solstice’ ‘Magical’ ‘Animal’ ‘Wolpertinger’ ‘Female’ ’11’ ‘7’ ‘0’)
(‘Cool Mongoose’ ‘Real’ ‘Human’ ‘Superhero’ ‘Female’ ’81’ ‘148’ ‘3’)
(‘Water Raven’ ‘Real’ ‘Human’ ‘Superhero’ ‘Male’ ’83’ ‘140’ ‘4’)
(‘James the Friendly Brooks’ ‘Real’ ‘Human’ ‘Cowboy’ ‘Male’ ’69’ ‘133’ ‘4’)
(‘Alectrochelodraco (Eagle Claw Dragon)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Male’ ‘207’ ‘7409’ ‘9’)
(‘Sechec’ ‘Magical’ ‘Animal’ ‘Basilisk’ ‘Male’ ‘419’ ‘283’ ‘0’)
(‘Pelorospondylus (Monstrous Vertebrae)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Female’ ‘228’ ‘17477’ ‘0’)
(‘Fern Auger Flowers’ ‘Real’ ‘Human’ ‘Cowgirl’ ‘Female’ ’64’ ‘130’ ‘5’)
(‘Lord Eager Shield’ ‘Real’ ‘Human’ ‘Superhero’ ‘Male’ ’71’ ‘187’ ‘0’)
(‘Sojisnux’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Female’ ’39’ ‘103’ ‘0’)
(‘Nugget’ ‘Magical’ ‘Animal’ ‘Jackalope’ ‘Female’ ’12’ ‘9’ ‘0’)
(‘Dr. Thunder’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Female’ ’71’ ‘138’ ‘5’)
(‘Prof. Stitch’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Male’ ’69’ ‘146’ ‘9’)
(‘Lela Dynamite Lowery’ ‘Real’ ‘Human’ ‘Cowgirl’ ‘Female’ ’62’ ‘131’ ‘2’)
(‘Vanessa Birdfog’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Female’ ’11’ ‘6’ ‘0’)
(‘Barbara Foxpool’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Female’ ’12’ ‘6’ ‘0’)
(‘Prof. Outcome’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Female’ ’68’ ‘157’ ‘0’)
(‘Eldoris’ ‘Magical’ ‘Human’ ‘Mermaid’ ‘Female’ ’64’ ‘124’ ‘0’)
(‘Uzconom’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Male’ ’31’ ‘249’ ‘9’)
(‘Kawai’ ‘Magical’ ‘Human’ ‘Merman’ ‘Male’ ’72’ ‘206’ ‘0’)
(‘Gnevumo’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Female’ ’38’ ‘164’ ‘0’)
(‘Doctor Spectacular Whiz’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Male’ ’65’ ‘164’ ‘1’)
(‘Jade’ ‘Magical’ ‘Animal’ ‘Jackalope’ ‘Male’ ’12’ ‘5’ ‘0’)
(‘Vuejezli’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Female’ ’32’ ‘185’ ‘0’)
(‘Osharus’ ‘Magical’ ‘Human’ ‘Merman’ ‘Male’ ’65’ ‘206’ ‘5’)
(‘Amara’ ‘Magical’ ‘Human’ ‘Mermaid’ ‘Female’ ’61’ ‘135’ ’10’)
(‘Prof. Fluke’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Male’ ’70’ ‘145’ ‘5’)
(‘Bionic First Aid Prototype’ ‘Real’ ‘Other’ ‘Robot’ ‘Unknown’ ’48’ ‘139’ ‘0’)
(‘Lethal Lynx’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Female’ ’68’ ‘190’ ‘0’)
(‘Manuela No-Tongue Layre’ ‘Real’ ‘Human’ ‘Pirate’ ‘Female’ ’69’ ‘146’ ‘3’)
(‘Magnum’ ‘Magical’ ‘Animal’ ‘Wolpertinger’ ‘Female’ ’13’ ‘9’ ‘4’)
(‘Odolina the Bold’ ‘Real’ ‘Human’ ‘Knight’ ‘Female’ ’75’ ‘265’ ‘0’)
(‘Rational Space Navigation Machine’ ‘Real’ ‘Other’ ‘Robot’ ‘Unknown’ ’54’ ‘112’ ‘0’)
(‘Dr. Pungent’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Female’ ’69’ ‘160’ ‘0’)
(‘Cloud Limelily’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Female’ ’10’ ‘6’ ‘0’)
(‘Aldis’ ‘Magical’ ‘Human’ ‘Dryad’ ‘Female’ ’64’ ‘119’ ‘0’)
(‘Violent Spider’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Female’ ’80’ ‘203’ ‘0’)
(‘Forbes Reaper Spaulding’ ‘Real’ ‘Human’ ‘Pirate’ ‘Male’ ’67’ ‘156’ ‘0’)
(‘Arnold Smokes Stevenson’ ‘Real’ ‘Human’ ‘Cowboy’ ‘Male’ ’68’ ‘151’ ‘6’)
(‘Richemanus the Shepherd’ ‘Real’ ‘Human’ ‘Knight’ ‘Male’ ’62’ ‘310’ ‘0’)
(‘Dr. Boulder’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Female’ ’71’ ‘155’ ‘6’)
(‘Serissa’ ‘Magical’ ‘Human’ ‘Dryad’ ‘Female’ ’62’ ‘123’ ‘0’)
(‘Zaatruarad’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Male’ ’38’ ‘217’ ‘0’)
(‘Jarrett Reaper Clayden’ ‘Real’ ‘Human’ ‘Pirate’ ‘Male’ ’71’ ‘150’ ‘9’)
(‘The Bronze Swan’ ‘Real’ ‘Human’ ‘Superhero’ ‘Male’ ’73’ ‘230’ ‘0’)
(‘Strategic Human Protection Golem’ ‘Real’ ‘Other’ ‘Robot’ ‘Unknown’ ’33’ ‘156’ ‘0’)
(‘Solace’ ‘Magical’ ‘Animal’ ‘Wolpertinger’ ‘Male’ ’12’ ‘5’ ‘0’)
(‘Nireta’ ‘Magical’ ‘Human’ ‘Mermaid’ ‘Female’ ’66’ ‘111’ ‘4’)
(‘Wallace the Blind Rich’ ‘Real’ ‘Human’ ‘Cowboy’ ‘Male’ ’71’ ‘138’ ‘0’)
(‘Tangy Tigermist’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Male’ ’13’ ‘5’ ‘0’)
(‘Shothi’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Female’ ’36’ ‘252’ ’10’)
(‘White Oxman’ ‘Real’ ‘Human’ ‘Superhero’ ‘Male’ ’61’ ‘173’ ‘0’)
(‘Violet Bear’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Female’ ’59’ ‘236’ ‘2’)
(‘The Copper Amazon’ ‘Real’ ‘Human’ ‘Superhero’ ‘Female’ ’83’ ‘182’ ‘0’)
(‘Jone the Bane’ ‘Real’ ‘Human’ ‘Knight’ ‘Female’ ’71’ ‘207’ ‘0’)
(‘Dr. Goose’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Male’ ’67’ ‘134’ ‘0’)
(‘The Wacky Wraith’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Female’ ’57’ ‘202’ ‘0’)
(‘Raamar’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Male’ ’33’ ‘286’ ‘0’)
(‘The Fantastic Phoenix’ ‘Real’ ‘Human’ ‘Superhero’ ‘Female’ ’70’ ‘174’ ‘3’)
(‘Mister White Sage’ ‘Real’ ‘Human’ ‘Superhero’ ‘Male’ ’78’ ‘200’ ‘0’)
(‘Self-Reliant Sabotage Entity’ ‘Real’ ‘Other’ ‘Robot’ ‘Unknown’ ’61’ ‘122’ ‘0’)
(‘Cari’ ‘Magical’ ‘Human’ ‘Merman’ ‘Male’ ’61’ ‘182’ ‘0’)
(‘Willoa’ ‘Magical’ ‘Human’ ‘Dryad’ ‘Female’ ’62’ ‘129’ ‘0’)
(‘Alma Big Bazoo Pierce’ ‘Real’ ‘Human’ ‘Cowgirl’ ‘Female’ ’66’ ‘117’ ‘0’)
(‘Myrtle Jeopardy Sherman’ ‘Real’ ‘Human’ ‘Cowgirl’ ‘Female’ ’62’ ‘149’ ‘0’)
(‘Kendall’ ‘Magical’ ‘Human’ ‘Merman’ ‘Male’ ’67’ ‘117’ ‘0’)
(‘Winifred the Silence’ ‘Real’ ‘Human’ ‘Knight’ ‘Female’ ’68’ ‘292’ ‘4’)
(‘Yinzu’ ‘Magical’ ‘Animal’ ‘Basilisk’ ‘Male’ ‘519’ ‘685’ ’10’)
(‘The Gray Gorilla’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Male’ ’81’ ‘220’ ‘0’)
(‘Deinocephaloceratops (Terrible Horned Face)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Male’ ‘210’ ‘23760’ ‘9’)
(‘Prof. Maniac’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Male’ ’68’ ‘149’ ‘4’)
(‘Sobejul’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Female’ ’44’ ‘229’ ‘4’)
(‘Ollie Friendly Face Jenkins’ ‘Real’ ‘Human’ ‘Cowgirl’ ‘Female’ ’63’ ‘115’ ‘1’)
(‘Newt Redfur’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Male’ ’14’ ‘6’ ‘0’)
(‘Homochelobator (Same Claw Hero)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Male’ ‘203’ ‘23456’ ‘0’)
(‘Faramond the Eager’ ‘Real’ ‘Human’ ‘Knight’ ‘Male’ ’68’ ‘165’ ‘0’)
(‘Mistress Frozen Cheat’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Female’ ’86’ ‘145’ ‘0’)
(‘Rational Life Simulation Device’ ‘Real’ ‘Other’ ‘Robot’ ‘Unknown’ ’47’ ‘100’ ‘0’)
(‘Brutus’ ‘Magical’ ‘Animal’ ‘Wolpertinger’ ‘Male’ ’12’ ’11’ ‘0’)
(‘Stareye’ ‘Real’ ‘Human’ ‘Superhero’ ‘Female’ ’70’ ‘147’ ‘8’)
(‘Dr. Whistle’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Female’ ’67’ ‘142’ ‘9’)
(‘Agent Bronze Starling’ ‘Real’ ‘Human’ ‘Superhero’ ‘Female’ ’61’ ‘257’ ‘0’)
(‘Barbarea’ ‘Magical’ ‘Human’ ‘Dryad’ ‘Female’ ’63’ ‘102’ ‘0’)
(‘Elizabeth Jeopardy Ortiz’ ‘Real’ ‘Human’ ‘Cowgirl’ ‘Female’ ’66’ ‘125’ ‘0’)
(‘Hugyica’ ‘Magical’ ‘Animal’ ‘Basilisk’ ‘Female’ ‘487’ ‘616’ ‘2’)
(‘Doctor Broken Sentinel’ ‘Real’ ‘Human’ ‘Superhero’ ‘Female’ ’71’ ‘134’ ‘0’)
(‘Silvivenator (Forest Hunter)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Male’ ‘215’ ‘17692’ ’10’)
(‘Sabadvux’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Male’ ’40’ ‘245’ ‘0’)
(‘The Crimson General’ ‘Real’ ‘Human’ ‘Superhero’ ‘Female’ ’55’ ‘137’ ‘5’)
(‘Sensory Recording Technology’ ‘Real’ ‘Other’ ‘Robot’ ‘Unknown’ ’55’ ‘167’ ‘0’)
(‘Gaura’ ‘Magical’ ‘Human’ ‘Dryad’ ‘Female’ ’68’ ‘137’ ‘5’)
(‘Dr. Misery’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Male’ ’69’ ‘146’ ‘7’)
(‘Callan’ ‘Magical’ ‘Human’ ‘Mermaid’ ‘Female’ ’63’ ‘115’ ‘3’)
(‘Torvorhynchomimus (Savage Beak Mimic)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Male’ ‘209’ ‘18827’ ‘0’)
(‘Shegeinzu’ ‘Magical’ ‘Animal’ ‘Basilisk’ ‘Female’ ‘399’ ‘579’ ‘2’)
(‘Alien Banshee’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Male’ ’67’ ‘145’ ’10’)
(‘Universal Base Protection Android’ ‘Real’ ‘Other’ ‘Robot’ ‘Unknown’ ’48’ ‘152’ ‘9’)
(‘The Broken Sage’ ‘Real’ ‘Human’ ‘Superhero’ ‘Male’ ’83’ ‘157’ ’10’)
(‘Magna Citrusstream’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Female’ ’11’ ‘5’ ‘3’)
(‘Prof. Bottom’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Female’ ’68’ ‘153’ ‘0’)
(‘Barracudon’ ‘Magical’ ‘Human’ ‘Merman’ ‘Male’ ’72’ ‘141’ ‘5’)
(‘Winston One Eye Tack’ ‘Real’ ‘Human’ ‘Pirate’ ‘Male’ ’71’ ‘163’ ‘0’)
(‘Rosia Golden-Eye Rave’ ‘Real’ ‘Human’ ‘Pirate’ ‘Female’ ’72’ ‘154’ ‘3’)
(‘The Outrageous General’ ‘Real’ ‘Human’ ‘Superhero’ ‘Male’ ’82’ ‘168’ ‘4’)
(‘Massodonceratops (Massive Tooth Horned Face)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Female’ ‘233’ ‘22647’ ‘0’)
(‘Prof. Fingers’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Male’ ’73’ ‘157’ ‘0’)
(‘Golden Bird Eye Carlton’ ‘Real’ ‘Human’ ‘Pirate’ ‘Female’ ’72’ ‘133’ ‘9’)
(‘Monroe’ ‘Magical’ ‘Human’ ‘Merman’ ‘Male’ ’68’ ‘197’ ‘4’)
(‘Doran of the Light’ ‘Real’ ‘Human’ ‘Knight’ ‘Male’ ’65’ ‘227’ ‘0’)
(‘Yejazeq’ ‘Magical’ ‘Animal’ ‘Basilisk’ ‘Female’ ‘537’ ‘498’ ‘4’)
(‘Widget’ ‘Magical’ ‘Animal’ ‘Wolpertinger’ ‘Female’ ’12’ ’10’ ‘8’)
(‘Soleil Mistyspice’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Female’ ’11’ ‘4’ ‘8’)
(‘The Old Horror’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Female’ ’75’ ‘196’ ‘0’)
(‘Ukrih’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Female’ ’35’ ‘177’ ‘7’)
(‘Ed Phantom ONeill’ ‘Real’ ‘Human’ ‘Cowboy’ ‘Male’ ’70’ ‘127’ ‘3’)
(‘Eluned the Grand’ ‘Real’ ‘Human’ ‘Knight’ ‘Female’ ’70’ ‘297’ ‘0’)
(‘Quavolqaz’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Male’ ’37’ ‘218’ ‘8’)
(‘Self-Aware Algorithm Device’ ‘Real’ ‘Other’ ‘Robot’ ‘Unknown’ ’47’ ‘152’ ‘5’)
(‘Milet the Illuminator’ ‘Real’ ‘Human’ ‘Knight’ ‘Male’ ’73’ ‘281’ ‘0’)
(‘The Filthy Smasher’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Female’ ’61’ ‘157’ ‘0’)
(‘Prof. Craven’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Female’ ’69’ ‘138’ ‘5’)
(‘Leomaris’ ‘Magical’ ‘Human’ ‘Merman’ ‘Male’ ’68’ ‘177’ ‘0’)
(‘Jubal’ ‘Magical’ ‘Human’ ‘Merman’ ‘Male’ ’72’ ‘184’ ‘0’)
(‘Arvilla Mumbling Heinrik’ ‘Real’ ‘Human’ ‘Pirate’ ‘Female’ ’67’ ‘144’ ‘0’)
(‘Pandora Cloudsplash’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Male’ ’12’ ‘4’ ‘0’)
(‘Dicraeotholus (Forked Dome)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Female’ ‘173’ ‘20907’ ‘0’)
(‘Julianne Giggleclove’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Female’ ’14’ ‘4’ ‘0’)
(‘Tammie the Romantic’ ‘Real’ ‘Human’ ‘Knight’ ‘Male’ ’67’ ‘227’ ‘0’)
(‘Elva Butcher Barrie’ ‘Real’ ‘Human’ ‘Pirate’ ‘Female’ ’65’ ‘148’ ‘0’)
(‘Selene Cottonbottom’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Female’ ’13’ ‘5’ ‘1’)
(‘Harbor Frozenshadow’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Male’ ’11’ ‘2’ ‘1’)
(‘Timber’ ‘Magical’ ‘Animal’ ‘Jackalope’ ‘Male’ ’11’ ’10’ ‘3’)
(‘Nero’ ‘Magical’ ‘Animal’ ‘Jackalope’ ‘Male’ ’11’ ‘7’ ‘0’)
(‘Dr. Moon’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Female’ ’67’ ‘153’ ‘0’)
(‘Munchkin’ ‘Magical’ ‘Animal’ ‘Wolpertinger’ ‘Female’ ’12’ ‘6’ ‘6’)
(‘Shaden’ ‘Real’ ‘Human’ ‘Superhero’ ‘Male’ ’77’ ‘176’ ‘0’)
(‘Reef Jumpyjewel’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Male’ ’10’ ‘3’ ‘0’)
(‘The Fire Brute’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Male’ ’56’ ‘190’ ‘4’)
(‘Hadrodraco (Big Dragon)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Male’ ‘229’ ‘21459’ ‘3’)
(‘Sybbyl the Keen’ ‘Real’ ‘Human’ ‘Knight’ ‘Female’ ’69’ ‘188’ ’10’)
(‘Panochelogryphus (Fully Claw Griffin)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Female’ ‘197’ ‘15445’ ’10’)
(‘The Wanderer’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Male’ ’57’ ‘235’ ‘0’)
(‘Vivien’ ‘Magical’ ‘Human’ ‘Mermaid’ ‘Female’ ’62’ ‘117’ ‘1’)
(‘Laraine’ ‘Magical’ ‘Human’ ‘Mermaid’ ‘Female’ ’65’ ‘120’ ‘0’)
(‘Suffield Deranged Hackney’ ‘Real’ ‘Human’ ‘Pirate’ ‘Male’ ’67’ ‘160’ ‘0’)
(‘Dr. Effort’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Male’ ’68’ ‘137’ ‘1’)
(‘Intelligent Bodyguard Technician’ ‘Real’ ‘Other’ ‘Robot’ ‘Unknown’ ’45’ ‘144’ ‘0’)
(‘Griritt’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Male’ ’37’ ‘244’ ‘9’)
(‘Carl Killer McPherson’ ‘Real’ ‘Human’ ‘Cowboy’ ‘Male’ ’69’ ‘134’ ‘3’)
(‘Wallflower Whitewhirl’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Female’ ’10’ ‘4’ ‘0’)
(‘Zaqac’ ‘Magical’ ‘Animal’ ‘Basilisk’ ‘Male’ ‘408’ ‘428’ ‘8’)
(‘Jericho’ ‘Magical’ ‘Animal’ ‘Jackalope’ ‘Male’ ’11’ ‘7’ ‘0’)
(‘Asbam’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Male’ ’41’ ‘148’ ‘0’)
(‘Guiscard the Gentle’ ‘Real’ ‘Human’ ‘Knight’ ‘Male’ ’66’ ‘207’ ‘7’)
(‘Pelorotrachelotitan (Monstrous Necked Giant)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Female’ ‘131’ ‘16885’ ‘1’)
(‘Carrie the Mortal Sherman’ ‘Real’ ‘Human’ ‘Cowgirl’ ‘Female’ ’61’ ‘119’ ‘2’)
(‘The Ice Doctor’ ‘Real’ ‘Human’ ‘Superhero’ ‘Female’ ’75’ ‘178’ ‘0’)
(‘Grumpy Savage’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Male’ ’72’ ‘182’ ‘3’)
(‘Juggernaut’ ‘Magical’ ‘Animal’ ‘Wolpertinger’ ‘Male’ ’11’ ‘7’ ‘2’)
(‘Dan Have Mercy Knowles’ ‘Real’ ‘Human’ ‘Cowboy’ ‘Male’ ’66’ ‘175’ ‘0’)
(‘Eisesux’ ‘Magical’ ‘Animal’ ‘Basilisk’ ‘Female’ ‘473’ ‘576’ ‘0’)
(‘Newton The Honest Puck’ ‘Real’ ‘Human’ ‘Pirate’ ‘Male’ ’67’ ‘148’ ‘0’)
(‘Jehen the Weak’ ‘Real’ ‘Human’ ‘Knight’ ‘Male’ ’72’ ‘202’ ‘0’)
(‘Kunzu’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Female’ ’37’ ‘209’ ‘9’)
(‘Shusanna the Lion’ ‘Real’ ‘Human’ ‘Knight’ ‘Female’ ’77’ ‘278’ ‘0’)
(‘Roesia the Reckless’ ‘Real’ ‘Human’ ‘Knight’ ‘Female’ ’65’ ‘236’ ‘0’)
(‘Germath’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Male’ ’39’ ‘164’ ‘0’)
(‘The Broad Sentinel’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Male’ ’65’ ‘204’ ‘2’)
(‘Parsons Twitching Brady’ ‘Real’ ‘Human’ ‘Pirate’ ‘Male’ ’67’ ‘137’ ‘8’)
(‘Brachiovenator (Arm Hunter)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Male’ ‘215’ ‘22255’ ‘0’)
(‘Ubo’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Female’ ’36’ ‘188’ ‘3’)
(‘Petiare’ ‘Magical’ ‘Human’ ‘Dryad’ ‘Female’ ’65’ ‘122’ ‘0’)
(‘Cyrtodocus (Curved Neck)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Male’ ‘180’ ‘21672’ ‘7’)
(‘Dr. Fascination’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Male’ ’69’ ‘156’ ‘7’)
(‘Edwin Sureshot Alford’ ‘Real’ ‘Human’ ‘Cowboy’ ‘Male’ ’69’ ‘141’ ‘5’)
(‘The Dark Detective’ ‘Real’ ‘Human’ ‘Superhero’ ‘Male’ ’41’ ‘147’ ‘6’)
(‘Gomer Pirate Swail’ ‘Real’ ‘Human’ ‘Pirate’ ‘Male’ ’72’ ‘148’ ‘8’)
(‘Mitah Copperclover’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Male’ ’13’ ‘4’ ‘4’)
(‘Camptochelolestes (Bent Claw Stealer)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Female’ ‘190’ ‘27055’ ‘0’)
(‘Dark Warrior’ ‘Real’ ‘Human’ ‘Superhero’ ‘Female’ ’60’ ‘172’ ‘0’)
(‘Christiania the Mild’ ‘Real’ ‘Human’ ‘Knight’ ‘Female’ ’72’ ‘208’ ‘0’)
(‘Calvin Sureshot Conner’ ‘Real’ ‘Human’ ‘Cowboy’ ‘Male’ ’60’ ‘159’ ‘0’)
(‘Amethelia’ ‘Magical’ ‘Human’ ‘Dryad’ ‘Female’ ’61’ ‘116’ ‘0’)
(‘Scarlet King’ ‘Real’ ‘Human’ ‘Superhero’ ‘Male’ ’81’ ‘169’ ‘0’)
(‘Burford Grim Zul’ ‘Real’ ‘Human’ ‘Pirate’ ‘Male’ ’72’ ‘141’ ‘2’)
(‘Diana Phantasm Vance’ ‘Real’ ‘Human’ ‘Pirate’ ‘Female’ ’66’ ‘152’ ‘3’)
(‘Aunsellus the Lion’ ‘Real’ ‘Human’ ‘Knight’ ‘Male’ ’68’ ‘313’ ‘2’)
(‘Abel the Magnificent’ ‘Real’ ‘Human’ ‘Knight’ ‘Male’ ’68’ ‘240’ ‘0’)
(‘Thunder’ ‘Magical’ ‘Animal’ ‘Jackalope’ ‘Female’ ’13’ ‘9’ ‘1’)
(‘Zokragrit’ ‘Magical’ ‘Animal’ ‘Basilisk’ ‘Female’ ‘498’ ‘398’ ‘3’)
(‘Georgia the Brains Wall’ ‘Real’ ‘Human’ ‘Cowgirl’ ‘Female’ ’66’ ‘125’ ‘1’)
(‘Vesta Dishonest Norman’ ‘Real’ ‘Human’ ‘Pirate’ ‘Female’ ’67’ ‘166’ ‘0’)
(‘Rage’ ‘Magical’ ‘Animal’ ‘Jackalope’ ‘Female’ ’12’ ’10’ ‘1’)
(‘Orocephalus (Mountain Head)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Male’ ‘231’ ‘24982’ ‘0’)
(‘Advanced Animal Handling Robot’ ‘Real’ ‘Other’ ‘Robot’ ‘Unknown’ ’50’ ‘168’ ‘9’)
(‘Rascal’ ‘Magical’ ‘Animal’ ‘Wolpertinger’ ‘Female’ ’11’ ‘6’ ‘0’)
(‘Professor Bloody Waspman’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Male’ ’71’ ‘159’ ‘0’)
(‘Microsuchus (Tiny Crocodile)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Female’ ‘175’ ‘27241’ ‘0’)
(‘Paralipus (Tidal Foot)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Female’ ‘185’ ‘18206’ ‘0’)
(‘Bonkers’ ‘Magical’ ‘Animal’ ‘Wolpertinger’ ‘Male’ ’12’ ‘7’ ‘1’)
(‘Okraq’ ‘Magical’ ‘Animal’ ‘Basilisk’ ‘Male’ ‘509’ ‘469’ ’10’)
(‘Avo Spidermint’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Male’ ’14’ ‘6’ ‘4’)
(‘Watkins Slick n Sly Cotton’ ‘Real’ ‘Human’ ‘Pirate’ ‘Male’ ’65’ ‘148’ ‘0’)
(‘Odele Liar Driscoll’ ‘Real’ ‘Human’ ‘Pirate’ ‘Female’ ’68’ ‘142’ ‘0’)
(‘Happy Mountainloop’ ‘Magical’ ‘Human’ ‘Fairy’ ‘Male’ ’13’ ‘5’ ‘0’)
(‘Shuazish’ ‘Magical’ ‘Animal’ ‘Basilisk’ ‘Male’ ‘573’ ‘475’ ‘0’)
(‘Muava’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Female’ ’38’ ‘174’ ‘2’)
(‘The Lonely Jackal’ ‘Real’ ‘Human’ ‘Supervillain’ ‘Male’ ’79’ ‘214’ ‘0’)
(‘Dr. Terror’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Male’ ’65’ ‘146’ ‘4’)
(‘Ammosaura (Sand Lizard)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Female’ ‘202’ ‘20547’ ‘2’)
(‘Dr. Fascination’ ‘Real’ ‘Human’ ‘Mad Scientist’ ‘Female’ ’66’ ‘133’ ‘1’)
(‘Oscar the Snake Dale’ ‘Real’ ‘Human’ ‘Cowboy’ ‘Male’ ’66’ ‘129’ ‘4’)
(‘Amblyantha’ ‘Magical’ ‘Human’ ‘Dryad’ ‘Female’ ’65’ ‘103’ ‘0’)
(‘Jubal’ ‘Magical’ ‘Human’ ‘Merman’ ‘Male’ ’69’ ‘196’ ‘0’)
(‘Balgatt’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Male’ ’45’ ‘131’ ‘0’)
(‘Katie the Infamous Snyder’ ‘Real’ ‘Human’ ‘Cowgirl’ ‘Female’ ’62’ ‘105’ ‘7’)
(‘Gallop’ ‘Magical’ ‘Animal’ ‘Jackalope’ ‘Female’ ’14’ ‘8’ ‘8’)
(‘Boaba’ ‘Magical’ ‘Human’ ‘Dryad’ ‘Female’ ’60’ ‘107’ ‘0’)
(‘Looys the Adamant’ ‘Real’ ‘Human’ ‘Knight’ ‘Male’ ’67’ ‘239’ ‘2’)
(‘Marisabel’ ‘Magical’ ‘Human’ ‘Mermaid’ ‘Female’ ’66’ ‘136’ ‘3’)
(‘Datura’ ‘Magical’ ‘Human’ ‘Dryad’ ‘Female’ ’64’ ‘128’ ‘9’)
(‘Malkyn the Honorable’ ‘Real’ ‘Human’ ‘Knight’ ‘Female’ ’69’ ‘272’ ‘0’)
(‘Leon Noose Wright’ ‘Real’ ‘Human’ ‘Cowboy’ ‘Male’ ’66’ ‘170’ ‘0’)
(‘Jero’ ‘Magical’ ‘Other’ ‘Gargoyle’ ‘Female’ ’35’ ‘189’ ‘6’)
(‘Acanthocantotitan (Spiny Spined Giant)’ ‘Real’ ‘Animal’ ‘Dinosaur’ ‘Male’ ‘171’ ‘26659’ ’10’);

UMGC IFSM 330 Assignment Mythical Creatures II

This assumes you have worked through the SQL commands referenced in the weekly tutorial(s) and you have prepared the SQLiteonline.com environment (see the Setting_Up_SQLiteonline_com.docx for instructions).

Your basic study trajectory here will be:

· Work through this document and write SQL to answer all the questions listed below. As part of your SQL, you will capture screenshots and paste them where indicated below.

· Refer to this document as you complete the SQL Check online quiz which verifies your assignment.

· You can take the quiz twice. Your highest score will post to the Grades area. Note the questions may change from one attempt to the next.

· When you have completed the online quiz, submit the Word document.

· You must complete the quiz AND submit a complete Word document with SQL queries and screenshots to receive credit for this assignment.

· Remember, you can always reach out for help to your instructor if your SQL is not behaving for you.

For reference, the commands we may use in this assignment include:

· SQL Select

· SQL Select Distinct

· SQL Where

· SQL And, Or, Not

· SQL ORDER BY

· SQL INSERT INTO

· SQL Null Values (optional)

· SQL UPDATE

· SQL DELETE

· SQL SELECT TOP / LIMIT

· SQL MIN and MAX

· SQL COUNT, AVG, SUM

· SQL LIKE

· SQL WILDCARDS

· SQL IN

· SQL BETWEEN

· SQL ALIASES (Column syntax only)

Name: _________________________________

Single Table Queries

This is where you start to turn things in. Make sure to put your name up top.

Construct SQL to answer each of the following questions. For each query, paste your SQL code below, and also paste a screenshot of the first 10 or so rows the query gives you.

Give an answer to the question based only on what you see in your SQLite database. (Do not use Excel or other tools to answer these questions; since we are trying to learn SQLite here, you should do these exercises in SQLite.)

You will eventually submit this document as part of your week’s assignment.

After you have completed your first draft of this document, you will use the SQL Check online quiz to verify your answers. The SQL Check online quiz uses the same numbering system given here, so you can quickly find the question you need.

You are welcome to update your assignment document with results from the SQL Check, and submit the assignment document after you’ve checked your assignment online.


NOTE: The question numbering below is in sequential order, from smallest to largest, but some numbers are skipped. Be aware of this when you work through the SQL Check online quiz.

· [SQL Week 2 Question 100-007] Get a listing of the id number (idLitCharacters), Name, Creature SubType for all the pirates, mermaids, and fairies. Only include these three Subtypes. Order by ascending idLitCharacters.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-008] You need a big scary one. Get a listing of all the names of Basilisks which have a weight greater than 475. Make sure you print the ID, the name, the Creature SubType, and the weight. Order by ascending idLitCharacters.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-009] You want to get some name ideas for somebody who is either a mad scientist or supervillain. What are those names? Print out the Lit Character ID as well as the name and Sub Type. Order by ascending idLitCharacters.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-010] You need a list of non-male creatures. Select the idLitCharacter, Name, Creature SubType, and Gender for everybody whose gender is not designated as Male. Order by ascending idLitCharacters. Take a screenshot of the top of your output. Then scroll down until you see ID 51, Amara the Mermaid. Take a screenshot of Amara and the rows immediately beneath her as well.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-011] Select the idLitCharacters, name, Gender, Creature SubType. Your newest author wants a specific list of names which meet one of two criteria. The first criteria to meet would be a female pirate. The second criteria to meet would be any cute tiny male creature of weight 10 or below. Your output should contain some female pirates and some cute tiny male creatures. Sort the results first alphabetically on Gender and then within that field by idLitCharacters ascending.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-012] Display the idLitCharacters, name, Gender, Creature SubType, weight, and height for everybody whose height is greater than or equal to 200. Sort it so the heaviest ones are on the top, and within the weight then ascending by idLitCharacters.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-013] You want the big ones. Make a list of all the ID, the name, the Creature SubType, and weight and height. You only want those whose weight is greater than or equal to 150 or those whose height is greater than or equal to 65. Sort your results alphabetically by Name and then ascending by idLitCharacter.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-018] Your newest novel has a scene in which all the miscreants are on a bridge, but collectively they are too heavy for it so the bridge fails. It’s very exciting for your audience. What is the sum of the weight of all the miscreants here? We define miscreants here as Pirates, Supervillains, Mad Scientists, and Cowboys of any gender.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-019] You are going to have a scene in which all the basilisks are on one side of a balance scale, and the single smallest dinosaur is on the other side of the scale. The dinosaur is bigger, of course. By how many pounds? (It’s OK if you need to run two separate queries and then manually subtract them.)

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-020] Use the LIKE command to select the idLitCharacters, name, and creature subtype of all the creatures which start with MER (i.e. mermen, mermaids, etc.). Sort it alphabetically by name.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-021] What is the average weight of all creatures for which the name contains the string ‘us’ ? The phrase can be anywhere in the name – so “Usman” would count, as would “Beusaleth” and “McManus.” (Your database may vary; these names may or may not be in your version of the database.) Note your answer to four decimal places.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-022] Select all the fields for all the creatures that contain the word “the” in their names, such as “Roderick the Brave.” Do not include entries for which “The” is the first word, such as “The Fire Breather.” Order alphabetically by Name, then ascending by idLitCharacters.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-023] List all creatures which have two consecutive L’s anywhere in their name (such as “Elling” or “Llewers” or “Dingell”) and which are not Knights. Sort by number of appearances (fewest appearances on top) and then ascending by idLitCharacters.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-024] Use the SQL IN command to select all fields from all creatures which are Knights, Pirates, Fairies, or Jackalopes and who have had 1 or more appearances to date. Sort it by idLitCharacters, this time in DESCENDING order, so the highest ID is on the top. Use the SQL LIMIT command to display only 10 results.

· How many of each type were in your top 10 results?

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-025] You want something small and cute. How many creatures have a height between 10 and 15 inches and a weight between 5 and 10 pounds? (Hint: you should use the BETWEEN command)

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-026] Your publisher has decided to reclassify all Knights from Real to Magical with regard to their Realm. Make this update in your database. Before you do this update, you should be able to verify you have 100 creatures with Realm of Magical. After this update, how many creatures have a Magical Realm?

· If you get an error code 1175 that grumbles that you are using safe update mode, run the following code before your update:

· SET SQL_SAFE_UPDATES = 0;

· Note – this command has you modify the database. If you are then going to go back and answer some other questions after you do this command, be sure you refresh your database (i.e. re-load and re-run the script which made the database in the first place) before answering those questions.

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-027] DELETE. It’s time to delete stuff.

· Note – this command has you modify the database. If you are going to go back and answer some other questions after you do this command, be sure you refresh your database (i.e. re-load and re-run the script which made the database in the first place) before answering those questions.

· First, let’s verify your database is fully refreshed. Run the following checksum code. (There’s a lot of code here; it’s best to copy/paste into SQL.)

· SELECT ((COUNT(*) * AVG(Weight)) % 99) as checksum from litcharacters;

· You should get a checksum answer of 47.

· Delete all the dinosaurs who have already made an appearance. In other words, delete anything with a Creature SubType of Dinosaur and more than 0 appearances.

· Run the checksum code again. What is your checksum now?

<Paste/Enter SQL Code here>

<Paste Screenshot here>

· [SQL Week 2 Question 100-028] Note – this command has you modify the database. If you are going to go back and answer some other questions after you do this command, be sure you refresh your database (i.e. re-load and re-run the script which made the database in the first place) before answering those questions.

· First, check your database is fully refreshed. Run the following checksum code. (There’s a lot of code here; it’s best to copy/paste into SQL.)

· SELECT ((COUNT(*) * AVG(Weight)) % 99) as checksum from litcharacters;

· You should get a checksum answer of 47.

· You have some more characters to include. Insert the below characters in to the database:

· (‘Mogwai’, ‘Magical’, ‘Other’, ‘Fairy’, ‘Female’, ’25’, ‘158’,’2′),

· (‘Menehune’, ‘Real’, ‘Human’, ‘Superhero’, ‘Male’, ’56’, ‘195’,’5′)

· Now what is your checksum?

<Paste/Enter SQL Code here>

<Paste Screenshot here>

Assignment Mythical Creatures I for students.2215

Page 1

UMGC IFSM 330 Setting up SQLiteonline.com

In this class, we’ll be using SQLiteonline.com to install databases, run scripts and view output. SQLiteonline runs from a browser; there is no software to install.

Now, we are going to fire up SQLiteonline.com, run a script to install a database with a single table, and run some queries on this database.

Part 1 – Prepare the database and query environment, Open a browser and go to

www.sqliteonline.com

1. When you first access SQLiteonline.com, you should see something like the following screenshot:

A: Shows we’re using the SQLite database and there is a database preloaded called ‘demo’.

B: Is the area where we will enter our SQL install commands and SQL database queries

C: Shows output of queries.

D: Is the ‘Run’ button. We click there to run a command or query.

2. We’re going to start by deleting (dropping) the ‘demo’ database. Right click next to demo and choose drop. Then click OK to confirm.

Now we have an empty database. Click in the Query Area, and select/highlight the query SELECT * FROM demo; (use your mouse or CTRL-A on the keyboard) and DELETE that query (DELETE KEY or BACKSPACE).

We now have an empty data base and a blank query environment where we can begin work.

3. NOTE: SQLiteonline.com saves NOTHING for you. You will need to keep a copy of your queries and screenshots of output in Word (Part 4 of this document). Furthermore, It’s always smart to back your work up, so make a note to periodically save a copy somewhere else (i.e. email yourself a copy, or save it to your Google Drive as well.) Backing up only takes a minute and can save hours of rework.

4. The process that we just completed in SQLiteonline.com, removing/dropping the demo database and clearing the SQL Query area is a process you will do EVERY TIME you begin work again in SQLiteonline.com. Part 2, beginning on the next page, describes how to run an SQL INSTALL script to install a database in SQLiteonline.com. This is also a process that you will do EVERY TIME you begin work in SQLiteonline.com.


Part 2 – Download the Script and get your MythicalCreatures Set Up

The names in Mythical Creatures table are thanks to our friends at https://www.fantasynamegenerators.com/. Got a dragon and don’t know what to name it? They will have fantastic suggestions.

1. Please download the MythicalCreatures.sql file from the Assignments Folder in LEO (the same folder you downloaded these instructions from) and save the file to your hard drive.

2. If you double click the file it should open automatically in NotePad (Windows) or a text editor on a Mac.

As we did before, with your cursor/mouse in Notepad, select the entire sql text (CTRL-A) and copy (CTRL-C) and paste (CTRL-V) the text into the Query area of SQLiteonline.com.

Text is selected:

SQLiteonline.com, after pasting (CTRL-V) the text into the SQL Query area. Note the DB (database) is still empty.

Click Run to Run/Execute the Database install. After Run, we now have the database LitCharacters showing at the left.


Be careful not to click Run Twice, otherwise you will have all of the data—twice.

Click the ARROW to the right of LitCharacters, to show the Column Headings:

Note our install command is still in the SQL query area. We should remove that text, so we can run other queries from a blank screen. The database stays at the left, unless we actually DELETE/DROP the database (as we did before). Within the SQL query area, click CTRL-A to select the text and DELETE or BACKSPACE on the keyboard to delete the query.

Part 3 – Verify your MythicalCreatures Database

1. You are a literary agent working for Super Random House, Inc. Your publishing company maintains a database of characters which have appeared or may appear in the future in its novels. The novels run the gamut from fiction to nonfiction, biography to fantasy, and of course there must always be a basilisk or a robot available. Super Random House pseudo-randomly selects characters and assigns them to an author when it commissions a book. For example, it could select one pirate, one knight, and one supervillain, and commission an author to write a short story using those characters. Super Random House keeps track of previous uses of its characters to avoid over- or under-use of any specific one.

2. Your database has one table in it, and the table is called ‘litcharacters.’

3. Here’s a sample of the first few rows of a litcharacters table. Note your first few rows may or may not contain the exact same information, but they should be of the same general idea. The data fields are:

a. idLitCharacters – a unique identifier (the primary key, if you’ve heard of those)

b. Name – a text field with the name of the character

c. Realm – a text field telling us what realm the character belongs to

d. CreatureType – designates creature as Human, Animal, or a few additional types

e. CreatureSubType – gives more specifics about the exact sort of creature

f. Gender – gender

g. Height – height in inches

h. Weight – weight in pounds

i. For example, in the table below, our first literary character is a male Merman (human on top, fish tail on the bottom) named Kaerio, clearly a magical character, but with a human type, and he is 65 inches tall and weighs 181 pounds.

j. Rounding out the scales is entry number 8, our Super Claw Lizard, at over 26,000 pounds.

idLitCharacters

Name

Realm

CreatureType

CreatureSubType

Gender

Height

Weight

1

Kaerio

Magical

Human

Merman

Male

65

181

2

Hissing Hornet

Real

Human

Supervillain

Male

61

205

3

Rugby Defiant Eldon

Real

Human

Pirate

Male

67

168

4

Belet the Hero

Real

Human

Knight

Female

70

270

5

Mistress Shaggy Wraith

Real

Human

Supervillain

Female

66

175

6

Swift Shadow

Real

Human

Supervillain

Female

83

179

7

Doctor Heavenly Daggers

Real

Human

Superhero

Female

89

183

8

Superchelosaurus (Super Claw Lizard)

Real

Animal

Dinosaur

Female

202

26974

9

The Voiceless Arsonist

Real

Human

Supervillain

Female

58

184

10

Alectrochelodraco (Eagle Claw Dragon)

Real

Animal

Dinosaur

Male

207

7409

k. Let’s verify your MythicalCreatures database is working correctly.

4. Run the following query to list all the data in the table LitCharacters. A screenshot of the first few rows is below. Forgot how to run a query? Do this:

a. Make sure your SQLiteonline.com SQL query area is empty. We want to work from a ‘blank slate’.

b. Type the SQL into the SQL Query area (so you literally type SELECT * from LitCharacters;)

c. Leave your cursor blinking away after the semicolon

d. Mouse up to the RUN button and press it to execute the code

SELECT * FROM LitCharacters;

2. Remove/DELETE your SELECT * FROM LitCharacters; SQL query and from a blank SQL query area, run the following query and verify that you have 250 records in the table:

SELECT count(*) FROM LitCharacters;


Part 4.1: Using Snipping Tool (Windows) or the Screenshot App (Mac) to Capture Output

All of the screenshots/images in these instructions were captured and copied and pasted into Word using the Snipping Tool in Windows.

Note you should typically NOT take a picture of the entire screen, but select the pertinent output that you want to capture. If the output in submitted screenshots is too small to easily read or if the submitted screenshots do not show enough of the output, the assignment will be returned for resubmission.

Instructions for using the Snipping Tool can be found here:

https://support.microsoft.com/en-us/windows/use-snipping-tool-to-capture-screenshots-00246869-1843-655f-f220-97299b865f6b

If you have Windows 10, you may receive a message that the Snipping Tool is being replaced by a new App called ‘Snip & Sketch’.

Snip & Sketch instructions can be found here:

https://support.microsoft.com/en-us/windows/how-to-take-and-annotate-screenshots-on-windows-10-ca08e124-cc30-2579-3e55-6db63e36fbb9

The Snipping Tool equivalent in Mac is the Screenshot App. Instructions for using the Screenshot App can be found here:

https://support.apple.com/en-us/HT201361

Pay particular attention to the second section How to capture a portion of the screen, which will allow you to select specific output to capture.

Part 4.2: Using a Browser to Capture Output

Most major browsers can also take and save screenshots. Since our output is based within a browser this might be a simple option for some.

Firefox: https://support.mozilla.org/en-US/kb/firefox-screenshots

Firefox and Microsoft Edge keyboard shortcut for Screenshots: CTRL-Shift-S

Chrome: in Chrome-based browsers, look for a small camera icon:

Part 4.2: Using Word to type SQL code for SQLiteonline



Quotes are often a part of SQL code, but Word creates quotes for written text not programming or SQL code. Quotes in Word can sometimes be curved, sometimes not. But SQLiteonline.com can give errors on “curved/angled” quotes. SQLiteonline prefers “straight up and down” quotes the type that are created by Notepad.

However, Notepad within Windows is very basic and not always easy to use. A more advanced, but free, open source alternative to Notepad for MS Windows is Notepad++, available here:

https://notepad-plus-plus.org/

Some students seem to use Microsoft Word for SQL code without a problem, others encounter problems and it’s not even clear the quotes are causing the errors.

Examples:

Arial: “curved/angled”

Arial Unicode MS: “curved/angled”

Courier New: “curved/angled”

Times New Roman: “curved/angled”

From notepad: “straight up and down”

Setting Up SQLonline.com

Page 10