CIS515 Assignment 5 Solution

 

 The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.

A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six months and the agency requires an enhanced data management strategy to sustain their business operations. Their existing data repository for its reservation processing system is limited in business intelligence and reporting functionalities. The tour operator seeks a database management specialist to assist them in leveraging their data sources to enable them to forecast and project tour sales appropriately.

Imagine that you have been hired to fulfill their need of enhancing the data repository for their current reservation processing system. Upon reviewing the system, you find that the data structure holds redundant data and that this structure lacks normalization. The database has the following characteristics:

·         A table that stores all the salespersons. The table holds their employee id, first name, last name and “Tours sold” field. The “Tours sold” field is updated manually.

·         A table that stores tour customer data and tours sold. The table holds customer name, address, city, state, zip code, tour(s) selected, number of persons in tour, and total amount paid. The current structure will show the customer more than once, if the customer books multiple tours.

·         A tour table that is used as a tour rate sheet which holds the tours offered and the cost per person. Tour rates vary every three (3) months depending on the tourist season.

Write a three to four (3-4) page paper in which you propose an enhanced database management strategy. Your proposal should include the following:

1.       Design a data model that will conform to the following criteria:

 

1.       Propose an efficient data structure that may hold the tour operator’s data using a normalization process. Describe each step of the process that will enable you to have a 2nd Normal Form data structure.

2.       Create naming conventions for each entity and attributes.

3.       Conclude your data model design with an Entity Relationship Model (ERM) that will visually represent the relationships between the tables. You may make use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.

 

2.       Construct a query that can be used on a report for determining how many days the customer’s invoice will require payment if total amount due is within 45 days. Provide a copy of your working code as part of the paper.

 

3.       Using the salesperson table described in the summary above, complete the following;

 

1.       Construct a trigger that will increase the field that holds the total number of tours sold per salesperson by an increment of one (1).

2.       Create a query that can produce results that show the quantity of customers each salesperson has sold tours to. 

4.       Support the reasoning behind using stored procedures within the database as an optimization process for the database transactions.

Your assignment must follow these formatting requirements:

 

·         Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

·         Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

·         Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

The specific course learning outcomes associated with this assignment are:

·         Explain the fundamentals of how data is physically stored and accessed.

·         Compose conceptual data modeling techniques that capture information requirements.

·         Design a relational database so that it is at least in 3NF.

·         Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.

·         Use technology and information resources to research issues in the strategic implications and management of database systems.

·         Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.

 

 

Health Care Services

Read and critique or watch one (electronic) news article on health care delivery in the United States. For example, find an article or news videos that is about or relates to the major historical factors that affected the American healthcare system and describe their relationship to our current system. Or, find an article or about access issues within our current health care system, or the settings in which our health care service are available.

For this assignment, you may use an article that is in the mainstream media. You can do a google search or search some of the major news websites for articles or videos. Do not use Wikipedia.

Your initial post (response to the discussion) should include the following:

a) An overview of the article or video. Meaning, what is the basic point of the article or video?

b) Analyze and post your assessment of the article you choose. Example, what does the writer or reporter suggest are the main issues? Do you agree? Why or Why not?

c. Post a link to your article or video. References and or citations are required. You may reference/cite the course required textbook and or other sources you have used; following APA format.

Module Discussion Grading Criteria:

Thoroughly answered the question(s): 50 points are possible. A thorough answer will consist of complete sentences, and will address the question while drawing from the text or other credible source. A post that only has one-two sentences is not thorough and does not earn 50 points. Original post to the discussion question must be posted by Sunday 11:59pm(est) of each week.

Correct APA formatted references: 10 points are possible. Please use your text (when it applies to a discussion) or any other credible reference to support your answers, and be sure to cite your sources correctly, following APA guidelines. 

 

Education 3003 Wk1 Content Review

Directions:

  • Respond to each item. Each response should be concise and between 2 and 3 paragraphs in length.
  • Use MS Word to write your responses, and submit your answers to all three questions in one Word document.
  • Copy and paste each question within the document, so that your Instructor can see which question you are responding to.

 

  1. Consider what you have learned about why we assess young children. Based on pages 33-35 of Assessing and Guiding Young Children’s Development and Learning and the video segment “Overview of Assessment”,” briefly explain the importance of developmentally appropriate assessments.

  2. Policymakers, the early childhood profession, and other stakeholders in young children’s lives have many shared responsibilities regarding effective assessment (NAEYC & NAEC/SDE, 2003, p. 4). Using the information presented on pages 3–6 of Assessing and Guiding Young Children’s Development and Learning, explain the responsibilities of each of these groups in ensuring effective assessment.

  3. Each child approaches, interacts, and processes their world in unique ways. Effective assessment takes this uniqueness into account through sensitivity to individual abilities and linguistic, social, and cultural differences. Review pages 18–24 of Assessing and Guiding Young Children’s Development and Learning, and explain, using examples, why sensitivity to each of these factors is such an important component of effective assessment. Then, summarize the role fair and impartial assessment plays in achieving this sensitivity.

     

     

    • McAfee, O., Leong, D. J., & Bodrova, E.  (2016). Assessing and guiding young children’s development and learning (6th ed.). Boston: Pearson.
      • Chapter 3, “Why, What, and When to Assess” (pp. 32-35)
      • Chapter 1, “Assessment in Early Childhood: A Work in Progress”
      • Chapter 2, “Legal, Ethical, and Professional Responsibilities in Assessment”
    • Web Article: McCann, C., & Yarbrough, K. (2006). Snapshots: Incorporation comprehensive developmenta screening into programs and services for young children. Ounce of Prevention Fund.
      *Used with permission from the Ounce of Prevention Fund

 

 

 

Madam help

Must have in text cites and reference page.

 

 

As you learn about health care delivery in the United States, it is necessary to understand the various models of health insurance to develop important foundational knowledge as you progress through the course and for your role as a future health care worker. The following matrix is designed to help you develop that knowledge and assist you in understanding how health care is financed and how health insurance influences patients and providers. Fill in the following matrix. Each box must contain responses between 50 and 100 words and use complete sentences.

 

 

 

Model

 

 

Describe the model

How is the care paid or financed when this model is used?

What is the structure behind this model? Is it a gatekeeper, open-access, or combination of both?

What are the benefits for providers in using this model?

What are the challenges for providers in using this model?

Health Maintenance Organization (HMO)

 

 

 

 

 

Preferred Provider Model

 

 

 

 

 

Point-of-Service Model

 

 

 

 

 

Provider Sponsored Organization

 

 

 

 

 

High Deductible Health Plans and Savings Options

 

 

 

 

 

 

 

 

Cite your sources below. For additional information on how to properly cite your sources check out the Reference and Citation Generator resource in the Center for Writing Excellence.

 

 

 

References

 

·          

 

Annswers checked

A nurse practitioner student is familiarizing herself with the overnight admissions to an acute medical unit of a university hospital. Which of the following patients would the student recognize as being least likely to have a diagnosis of antiphospholipid syndrome in his or her medical history? (Points : 3)

      [removed] A 66-year-old obese male with left-sided hemiplegia secondary to a cerebrovascular accident
      [removed] 
A 90-year-old female resident of a long-term care facility who has been experiencing transient ischemic attacks
      [removed] 
A 30-year-old female with a diagnosis of left leg DVT and a pulmonary embolism
      [removed] 
A 21-year-old male with a diagnosis of cellulitis and suspected endocarditis secondary to intravenous drug use

 

Question 2.2. As part of his diagnostic workup, a 77-year-old man’s nurse practitioner has ordered blood work that includes ferritin levels. The man is very interested in the details of his health care and is unfamiliar with ferritin and its role. He asks his nurse practitioner to explain the significance of it and the rationale for testing it. Which of the following explanations by the nurse practitioner is most accurate? (Points : 3)

      [removed] “Ferritin is the activated and usable form of iron that your red blood cells can use to transport oxygen.”

      [removed] “Ferritin is a stored form of iron that indirectly shows me whether you would benefit from iron pills.”
      [removed] 
“Ferritin is a protein-iron complex that allows your red blood cells to make use of the iron that you consume in your diet.”
      [removed] 
“Ferritin is the form of iron that is transported in your blood plasma to the red blood cells that need it.”

 

Question 3.3. A 24-year-old woman presents with fever and painful, swollen cervical lymph nodes. Her blood work indicates neutrophilia with a shift to the left. She most likely has: (Points : 3)

      [removed] A mild parasitic infection
      [removed] 
A severe bacterial infection
      [removed] 
A mild viral infection
      [removed] 
A severe fungal infection

 

Question 4.4. A patient has been admitted to an inpatient medical unit of a hospital with an acute viral infection. The health care team providing care for the patient would recognize which of the following statements as an accurate description of the role of viruses in human infections? (Points : 3)

      [removed] Viruses have limited or absent genetic material of their own.
      [removed] 
Some viruses are capable of transforming normal host cells into malignant cells.
      [removed] 
Viruses are often implicated in cases of transmissible neurodegenerative disease.
      [removed] 
Viruses require stimulation after a latent period before they are able to produce symptoms.

 

Question 5.5. Sputum samples from a patient with pneumonia contain an infective agent that has a peptidoglycan cell wall, expresses endotoxins, replicates readily in broth and on agar, grows in clusters, has pili, and does not stain when exposed to crystal violet. This pneumonia is most likely: (Points : 3)

      [removed] Chlamydial
      [removed] 
Viral
      [removed] 
Mycoplasmal
      [removed] 
Bacterial

 

Question 6.6. A 60-year-old woman is suspected of having non-Hodgkin lymphoma (NHL). Which of the following aspects of her condition would help to rule out Hodgkin lymphoma? (Points : 3)

      [removed] Her neoplasm originates in secondary lymphoid structures.
      [removed] 
The lymph nodes involved are located in a large number of locations in the lymphatic system.
      [removed] 
The presence of Reed-Sternberg cells has been confirmed.
      [removed] 
The woman complains of recent debilitating fatigue.

 

Question 7.7. A 30-year-old man has spent 5 hours on a cross-country flight seated next to a passenger who has been sneezing and coughing, and the man has been inhaling viral particles periodically. Which of the following situations would most likely result in the stimulation of the man’s T lymphocytes and adaptive immune system? (Points : 3)

      [removed] Presentation of a foreign antigen by a familiar immunoglobulin
      [removed] 
Recognition of a foreign MHC molecule
      [removed] 
Recognition of a foreign peptide bound to a self MHC molecule
      [removed] 
Cytokine stimulation of a T lymphocyte with macrophage or dendritic cell mediation

 

Question 8.8. A couple who are expecting their first child have been advised by friends to consider harvesting umbilical cord blood in order to have a future source of stem cells. The couple have approached their nurse practitioner with this request and are seeking clarification of exactly why stem cells are valuable and what they might expect to gain from harvesting them. How can the nurse practitioner best respond to the couple’s inquiry? (Points : 3)

      [removed] “Stem cells can help correct autoimmune diseases and some congenital defects.”
      [removed] 
“Stem cells can be used to regenerate damaged organs should the need ever arise.”
      [removed] 
“Stem cells can be used as a source of reserve cells for the entire blood production system.”
      [removed] 
“Stem cells can help treat some cancers and anemias, but they must come from your child himself or herself.”

 

Question 9.9A 40-year-old woman who experiences severe seasonal allergies has been referred by her family physician to an allergist for weekly allergy injections. The woman is confused as to why repeated exposure to substances that set off her allergies would ultimately benefit her. Which of the following phenomena best captures the rationale for allergy desensitization therapy? (Points : 3)

      [removed] Repeated exposure to offending allergens binds the basophils and mast cells that mediate the allergic response.
      [removed] 
Exposure to allergens in large, regular quantities overwhelms the IgE antibodies that mediate the allergic response.
      [removed] 
Repeated exposure stimulates adrenal production of epinephrine, mitigating the allergic response.
      [removed] 
Injections of allergens simulate production of IgG, which blocks antigens from combining with IgE.

 

Question 10.10. The blood work of a 44-year-old male patient with a diagnosis of liver disease secondary to alcohol abuse indicates low levels of albumin. Which of the following phenomena would a clinician be most justified in anticipating? (Points : 3)

      [removed] Impaired immune function
      [removed] 
Acid-base imbalances
      [removed] 
Impaired thermoregulation
      [removed] 
Fluid imbalances

 

Question 11.11. A tourist presented to a primary care health clinic complaining of malaise, fever, and headache. She has subsequently been diagnosed with Rocky Mountain spotted fever, a pathology caused by Rickettsiaceae. Which of the followed statements best captures a characteristic trait of Rickettsiaceae? (Points : 3)

      [removed] They are eukaryotic.
      [removed] 
They have both RNA and DNA.
      [removed] 
They have a distinct spiral-shaped morphology.

      [removed] They are neither gram-negative nor gram-positive.

 

Question 12.12. A nurse practitioner is providing prenatal care and education for a first-time expectant mother, 22 weeks’ gestation, who has a diagnosis of a sexually transmitted infection. Which of the following statements by the expectant mother demonstrates an adequate understanding of vertical disease transmission and congenital infections? (Points : 3)

      [removed] “Gonorrhea and chlamydia pose the greatest risks of transmission from mother to child.”
      [removed] 
“I know that my baby will need observation for HIV signs and symptoms in the weeks following my delivery.”
      [removed] 
“My baby could become infected either across the placenta or during the birth itself.”
      [removed] 
“Prophylactic immunization will reduce my baby’s chance of being born with an illness.”

 

Question 13.13. A 16-year-old female has been brought to her primary care nurse practitioner by her mother due to the girl’s persistent sore throat and malaise. Which of the following facts revealed in the girl’s history and examination would lead the nurse practitioner to rule out infectious mononucleosis? (Points : 3)

      [removed] The girl has a temperature of 38.1°C (100.6°F) and has enlarged lymph nodes.
      [removed] 
Her liver and spleen are both enlarged.
      [removed] 
Blood work reveals an increased white blood cell count.
      [removed] 
Chest auscultation reveals crackles in her lower lung fields bilaterally.

 

Question 14.14. A 44-year-old female patient presents to the emergency department with abnormal bleeding and abdominal pain that is later attributed to gallbladder disease. Which of the following diagnoses would the medical team be most justified in suspecting as a cause of the patient’s bleeding? (Points : 3)

      [removed] Calcium deficiency
      [removed] 
Vitamin K deficiency
      [removed] 
Hemophilia B
      [removed] 
Idiopathic ITP

 

Question 15.15. A nurse practitioner is teaching her colleagues about the role of cytokines in a variety of pathologies. Which of the following teaching points best captures an aspect of the functions and nature of cytokines? (Points : 3)

      [removed] “A particular cytokine can have varied effects on different systems, a fact that limits their therapeutic use.”
      [removed] 
“Cytokine production is constant over time, but effects are noted when serum levels cross a particular threshold.”
      [removed] 
“Most cytokines are produced by granular leukocytes, and different cells are capable of producing the same cytokine.”
      [removed] 
“Cytokine actions are self-limiting in that activation of one precludes activation of other cytokines with similar actions.”

 

Question 16.16. Which of the following statements most accurately conveys an aspect of lymphatic system activity? (Points : 3)

      [removed] B and T lymphocyte development begins in the bone marrow and ends in the peripheral lymphoid structures.
      [removed] 
B cells and macrophages are released from the bone marrow in their completed state.
      [removed] 
Stem cells in the lymph nodes initiate and regulate the process of white cell synthesis.
      [removed] 
Leukocytes bypass vascular circulation and are distributed instead by the lymphatic system.

 

Question 17.17Following a course of measles, a 5-year-old girl developed scattered bruising over numerous body surfaces and was diagnosed with immune thrombocytopenic purpura (ITP). As part of her diagnostic workup, blood work was performed. Which of the following results is most likely to be considered unexpected by the health care team? (Points : 3)

      [removed] Increased thrombopoietin levels
      [removed] 
Decreased platelet count
      [removed] 
Normal vitamin K levels
      [removed] 
Normal leukocyte levels

 

Question 18.18A 22-year-old female who adheres to a vegan diet has been diagnosed with iron-deficiency anemia. Which of the following components of her diagnostic blood work would be most likely to necessitate further investigation? (Points : 3)

      [removed] Decreased mean corpuscular volume (MCV)
      [removed] 
Decreased hemoglobin and hematocrit
      [removed] 
Microcytic, hypochromic red cells
      [removed] 
Decreased erythropoietin levels

 

Question 19.19. A 60-year-old male patient with an acute viral infection is receiving interferon therapy. The nurse practitioner is teaching the family of the patient about the diverse actions of the treatment and the ways that it differs from other anti-infective therapies. Which of the following teaching points should the nurse practitioner exclude? (Points : 3)

      [removed] “Interferon can help your father’s unaffected cells adjacent to his infected cells produce antiviral proteins that limit the spread of the infection.”
      [removed] 
“Interferon can help limit the replication of the virus that’s affecting your father.”
      [removed] 
“Interferon helps your father’s body recognize infected cells more effectively.”
      [removed] 
“Interferon can bolster your father’s immune system by stimulating natural killer cells that attack viruses.”

 

Question 20.20. A nurse practitioner is explaining to a 40-year-old male patient the damage that Mycobacterium tuberculosis could do to lung tissue. Which of the following phenomena would underlie the nurse practitioner’s explanation? (Points : 3)

      [removed] Tissue destruction results from neutrophil deactivation.
      [removed] 
Nonspecific macrophage activity leads to pulmonary tissue destruction and resulting hemoptysis.
      [removed] 
Macrophages are unable to digest the bacteria, resulting in immune granulomas.
      [removed] 
Neutrophils are ineffective against the Mycobacterium tuberculosis antigens.

 

Question 21.21. A patient presented to the emergency department of the hospital with a swollen, reddened, painful leg wound and has been diagnosed with methicillin-resistant Staphylococcus aureus cellulitis. The patient’s nurse practitioner has ordered a complete blood count and white cell differential. Which of the following blood components would the nurse practitioner most likely anticipate to be elevated?(Points : 3)

      [removed] Basophils
      [removed] 
Eosinophils
      [removed] 
Platelets
      [removed] 
Neutrophils

 

Question 22.22. A child has been diagnosed with thalassemia. Which of the following other health problems is the child at risk for? (Points : 3)

      [removed] Hypocoagulation
      [removed] 
Iron and ferritin deficiencies
      [removed] 
Splenomegaly and hepatomegaly
      [removed] 
Neutropenia

 

Question 23.23. A 14-year-old boy has been diagnosed with infectious mononucleosis. Which of the following pathophysiological phenomena is most responsible for his symptoms? (Points : 3)

      [removed] The Epstein-Barr virus (EBV) is lysing many of the boy’s neutrophils.
      [removed] 
Viruses are killing some of his B cells and becoming incorporated into the genomes of others.
      [removed] 
The EBV inhibits the maturation of white cells within his peripheral lymph nodes.
      [removed] 
The virus responsible for mononucleosis inhibits the maturation of myeloblasts into promyelocytes.

 

Question 24.24. A 66-year-old female patient has presented to the emergency department because of several months of intermittently bloody stools that has recently become worse. The woman has since been diagnosed with a gastrointestinal bleed secondary to overuse of nonsteroidal anti-inflammatory drugs that she takes for her arthritis. The health care team would realize that which of the following situations is most likely? (Points : 3)

      [removed] The woman has depleted blood volume due to her ongoing blood loss.
      [removed] 
She will have iron-deficiency anemia due to depletion of iron stores.
      [removed] 
The patient will be at risk for cardiovascular collapse or shock.
      [removed] 
She will have delayed reticulocyte release.

 

 

Question 25.25. Which of the following phenomena would be least likely to result in activation of the complement system? (Points : 3)

      [removed] Recognition of an antibody bound to the surface of a microbe
      [removed] 
The binding of mannose residues on microbial glycoproteins
      [removed] 
Activation of Toll-like receptors (TLRs) on complement proteins
      [removed] 
Direct recognition of microbial proteins

exercise 3

  

1). When do you feel or have you felt flow?  Write a paragraph or two (150 words) about a time when you were completely engaged in an activity, to the point that time fell away.  While this isn’t formal writing, be sure to review your work for grammar, spelling, and full sentences before you upload it to the assignment folder.

2). Flow Strategies:  Which of the strategies to achieve flow would you like to pursue?  Which do you think would be challenging and why?  Write a paragraph or two (150 words) about the strategy that most interests you and the strategy that seems most difficult.  While this isn’t formal writing, be sure to review your work for grammar, spelling, and full sentences before you upload it to the assignment folder.

Strategies (this is for examples to read)

So how do you achieve this mystical state of being? Do you need to meditate or chant anything? No, you don’t (although meditation can improve your ability to concentrate). And Flow is anything but mystical — it’s very practical, and achieving it isn’t mysterious.

It can take practice, but you’ll get better at it. Here are the key steps to achieving and benefiting from Flow:

  1. Choose work you love. If you dread a task, you’ll have a hard time losing yourself in it. If your job is made up of stuff you hate, you might want to consider finding another job. Or consider seeking projects you love to do within your current job. At any rate, be sure that whatever task you choose is something you can be passionate about.
  2. Choose an important task. There’s work you love that’s easy and unimportant, and then there’s work you love that will make a long-term impact on your career and life. Choose the latter, as it will be a much better use of your time, and of Flow.
  3. Make sure it’s challenging, but not too hard. If a task is too easy, you will be able to complete it without much thought or effort. A task should be challenging enough to require your full concentration. However, if it is too hard, you will find it difficult to lose yourself in it, as you will spend most of your concentration just trying to figure out how to do it — either that, or you’ll end up discouraged. It may take some trial and error to find tasks of the appropriate level of difficulty.
  4. Find your quiet, peak time. This is actually two steps grouped into one. First, you’ll want to find a time that’s quiet, or you’ll never be able to focus. For me, that’s mornings, before the hustle of everyday life builds to a dull roar. That might be early morning, when you just wake, or early in the work day, when most people haven’t arrived yet or are still getting their coffee and settling down. Or you might try the lunch hour, when people are usually out of the office. Evenings work well too for many people. Or, if you’re lucky, you can do it at any time of the day if you can find a quiet spot to work in. Whatever time you choose, it should also be a peak energy time for you. Some people get tired after lunch — that’s not a good time to go for Flow. Find a time when you have lots of energy and can concentrate.
  5. Clear away distractions. Aside from finding a quiet time and place to work, you’ll want to clear away all other distractions. That means turning off distracting music (unless you find music that helps you focus), turning off phones, email and IM notifications, Twitter and Growl, and anything else that might pop up or make noise to interrupt your thoughts. I also find it helpful to clear my desk, even if that means sweeping miscellaneous papers into a folder to be sorted through later. Of course, these days there isn’t anything on my desk, but I didn’t always work like this. A clear desk helps immensely.
  6. Learn to focus on that task for as long as possible. This takes practice. You need to start on your chosen task and keep your focus on it for as long as you can. At first, many people will have difficulty, if they’re used to constantly switching between tasks. But keep trying, and keep bringing your focus back to your task. You’ll get better. And if you can keep your focus on that task, with no distractions, and if your task has been chosen well (something you love, something important, and something challenging), you should lose yourself in Flow.
  7. Enjoy yourself. Losing yourself in Flow is an amazing thing, in my experience. It feels great to be able to really pour yourself into something worthwhile, to make great progress on a project or important task, to do something you’re passionate about. Take the time to appreciate this feeling (perhaps after the fact — it’s hard to appreciate it while you’re in Flow).
  8. Keep practicing. Again, this takes practice. Each step will take some practice, from finding a quiet, peak time for yourself, to clearing distractions, to choosing the right task. And especially keeping your focus on a task for a long time. But each time you fail, try to learn from it. Each time you succeed, you should also learn from it — what did you do right? And the more you practice, the better you’ll get.
  9. Reap the rewards. Aside from the pleasure of getting into Flow, you’ll also be happier with your work overall. You’ll get important stuff done. You’ll complete stuff more often, rather than starting and stopping frequently. All of this is hugely satisfying and rewarding. Take the time to appreciate this, and to continue to practice it every day.

M3D2

Click to Launch

Module 3

Wind farm and nuclear power plant Even if our current energy needs can be met by nonrenewable sources, our ever-increasing demands for energy will require new energy sources. Research into some these sources may currently be in the very early stages. Many such emerging technologies will not have a substantial impact on our energy needs without additional research and development.

First:

  1. Review
  2. Read
  3. Watch the TED talks about emerging energy technologies:

Next, post to the discussion board:

  • Answers to the following questions:
    1. In his TED talk, Steven Cowley calls fusion “the perfect energy source.” Using What You Need To Know About Energy and the Time Magazine article by Brian Walsh as your source for background information, what do you think is limiting the adoption of nuclear fusion as a source of energy?
    2. Craig Kohn advocates for using cellulose as an alternative source of energy. Using What You Need To Know About Energy as your source for background information, what do you think is limiting the adoption of cellulose-based biofuels as a source of energy?

Once you have posted your own discussion response, you are required to comment on the posts of at least two of your classmates. You can agree or disagree with their posts, but you must explain why you have chosen to do so. Remember, if you provide a quotation from a source (i.e., your textbook or the Internet), you must include the correct citation and reference. Also, be sure to read the feedback on your own major postings and reply to it throughout the module.

Your initial post is due by Thursday at 11:59 PM EST. Your responses are due by Sunday at 11:59 PM EST.

Compose your work using a word processor and save it, as a Plain Text or an .rtf, to your computer. When you’re ready to make your initial posting, please click on the “Create Thread” button and copy/paste the text from your document into the message field. Be sure to check your work and correct any spelling or grammatical errors before you post it.

Graded discussions are worth 30% of your total course grade and will be evaluated using the SLA Discussion Rubric [39.1 KB PDF file].

 

Image credit:

Sanitizer Marketing Plan (attached)

Week 3 Build Your Own Marketing Plan Target market analysis identifies exactly who your company will target. Target markets are typically identified by demographic, psychographic, geographic or behavioral dimensions. Some companies will focus on several target markets which can be identified at TM1, TM2, etc. Market product grid is visually constructed (graph or chart) correlating the target market identified in week 3 and the product attributes described in week 2. BUSN319 Week 4 Marketing Plan Rubric Product Strategy Possible Points Earned Points Product: Described features of the product/service. 3 Product competitive advantage: Differentiated product/service from the competition and discussed new product ideas. 6 Life Cycle: Analyzed stage in product life cycle 2 Brand: Identified marketing mix and branding opportunities 2 Packaging: Described optimal packaging techniques 2 Grammar, solid academic writing style, spelling and minimum length of 2 pages 2 Reference page included 3 TOTAL 20 Pricing strategy should look identify below-the-market, at-the-market or above-the-market strategies. Effective pricing will discuss how this company can be financially solvent based upon their proposed pricing strategies. Distribution channel describes how the product/service will travel from the manufacturer to the consumer. Include distributors, wholesalers, retailers, etc. A visual chart can be helpful. Facilities: Describe the facilities used by your company. This can be a retail setting, distributor, wholesalers, etc. Promotional strategy discusses a theme or overall promotional campaign that you might include. For instance, Coca Cola uses “happiness”. Promotional mix should include a thorough description of all elements of the promotional mix that the company will use. Explain why it is included. BUSN319 Week 6 Marketing Plan Rubric Place and Promotion Strategy Possible Points Earned Points Distribution channel: Thoroughly described the complete channel of distribution from “manufacturer” to consumer 7 Facilities: Described facilities or other unique components of the distribution plan (retail, wholesale, distributor) 3 Promotional Strategy: Developed promotional strategy and objectives 5 Promotional Mix: Explained the complete promotional mix include advertising, publicity, sales promotion, personal selling and online marketing 10 Produce an organization chart 3 Produce Gantt Chart 3 Critical success factors: Identify and explain critical success factors for the marketing plan 4 Grammar, solid academic writing style, spelling and minimum length of 2 pages 2 Reference page is included 3 TOTAL 40 Week 7 Build Your Own Marketing Plan This is the final submission of your marketing plan. Use feedback provided by the professor in previous submissions and correct elements as necessary using this rubric as a checklist. BUSN319 Week 7 Marketing Plan Rubric Possible Points Earned Points Table of Contents 10 Executive Summary explaining reason for analysis 5 Company and product description ove/rview included 5 Company mission, goals, competitive advantage, SWOT analysis described thoroughly 10 Environmental factors and trends examined. 10 Industry assessment and estimated market size explained. 10 Target Market Analysis 10 Research data, market product grid and forecasted sales provided with explanations. 10 Product: Product strategy, points of difference, brand, life cycle stage examined. 15 Pricing: Pricing strategy and break even analysis estimated and explained in detail. 15 Distribution (place): Included discussion of distribution channels and intermediaries. 15 Promotion: Developed promotional mix and strategies with rationale. 15 Organizational data-Included organization chart, project plan/Gantt chart and critical success factors. 10 Conclusion 5 Report accumulation-Includes all report elements in submission (see Table of Contents sample provided) 8 Organization and cohesiveness: Used 3rd person and objective voice. Content subdivided into sections using subheadings with overall coherent flow. 9 Documentation and formatting: Appropriate use of APA. Submission included a Title page. Length is a minimum of 4,000-6,000 words. 9 Editing: Submission is free from errors in grammar and spelling. Clear, concise, factual paragraphs 9

DUE IN 2 HOURS

Current Epidemiological Studies: Critical Review

For your dropbox assignment, using the Online Library or the Internet, research and select three current epidemiological studies regarding risk factors that are associated with any health problem. You can also use the following websites to search for studies as they are often used as the major sources of information for health research and often report on the most current health problems affecting the United States and global populations:

Based on your research, create a report in a 3- page Microsoft Word document addressing the following questions:

  • What were the criteria that you used to select these papers? (For example, only English language, peer reviewed articles, only a specific age group, only United States studies, etc.)
  • What were the types of risk factors studied in your chosen articles? (For example, environmental, socio-economic, behavioral, etc.)
  • Which study design was used for this study? Why do you think the researchers chose this specific study design? Provide examples from your research.
  • What are the proximate or underlying determinants of risk factors that are associated with any health problem for each study?

Answer the questions posted below in the Template for Assessment of Causality for Reviewing Epidemiological Studies, for each study. You should number each study, list the title, and state each question in the format it appears in the template.

Click here to download the template.

Support your responses with examples.

Cite any sources in APA format.

 

 

 

 

Template for Assessment of Causality for Reviewing Epidemiological Studies

Causality Criteria

Criteria to Evaluate Studies

 

Description

Exposure, Intervention

Outcome

Study design

Study population

Main result

A.     Description of the evidence

What was the exposure or intervention?

What was the outcome?

What was the study design?

What was the study population?

What was the main result?

 
 
 
 
 
 

Internal Validity

Observation bias

Recall bias

Confounding

Chance

B.      Internal Validity (non-causal factors)

Are the results likely to be affected by observation bias?

Are results likely to be affected by recall bias?

Are the results likely be affected by confounding (list which ones)?

Are the results likely to be affected by chance?

 

Generalizability

Eligible population

Source population

Other population

C.      External validity–Generalization of results

Can the study results be applied to the eligible population?

Can the study results be applied to the source population?

Can the study results be applied to other relevant populations?

 

 

 

M4D2

Transportation system providers have many new demands and many critical issues to address, as shown in the previous activity.  For example, transportation system providers must balance operations against expansion and balance local and national interests. The shift in authority and funding responsibility to the local and state levels raises fundamental questions about what the federal role should be.

In this activity, we will explore how one community – San Francisco – addresses transportation needs in the form of the transportation budget. You will be the decision maker, using a simulation to address the issues of operations and maintenance, programs, and projects.

First:

  1. Review
    • From the booklet Critical Issues in Transportation, the sections
      • Finance (pp. 5-6),
      • Equity (pp. 6-7),
      • Institutions (pp. 9-10), and
      • Human and Intellectual Capital (pp. 10-11)
  2. Read
    • Use the budget simulation San Francisco Budget Czar.  Follow the instructions at the top of the webpage and complete your budget for San Francisco’s transportation infrastructure.

Next, post to the discussion board:

  • A summary of your budget and a budget justification.  You should use the reference material from this module to justify your budget:
    • Operations and Maintenance
    • Programs
    • Projects
    • Revenue
  • Answers the following question:
    • If you maintain current revenue (no change to revenue, use only the gray circles),  try to create a budget that will support all top-tier projects, moderately increase the operations budget and moderately increase the programs budget. What operations or program item(s) would you eliminate to balance the budget?  Your answer should explain why you made this choice.
    • If you maintain current revenue, can you increase aggressively the budgets for the six public transportation programs?  San Francisco attracts many tourists who will require public transportation to visit the city.  What new projects can be added while keeping a balanced budget?

Once you have posted your own discussion response, you are required to comment on the posts of at least two of your classmates. You can agree or disagree with their posts, but you must explain why you have chosen to do so. Remember, if you provide a quotation from a source (i.e., your textbook or the Internet), you must include the correct citation and reference. Also, be sure to read the feedback on your own major postings and reply to it throughout the module.

Your initial post is due by Thursday at 11:59 PM EST. Your responses are due by Sunday at 11:59 PM EST.

Compose your work using a word processor and save it, as a Plain Text or an .rtf, to your computer. When you’re ready to make your initial posting, please click on the “Create Thread” button and copy/paste the text from your document into the message field. Be sure to check your work and correct any spelling or grammatical errors before you post it.

Graded discussions are worth 30% of your total course grade and will be evaluated using the SLA Discussion Rubric [39.1 KB PDF file].