Health Care Finance: Assignment Week 4

Case Study: Chapters 9 to 12.

Objective: The students will complete a Case study assignments that give the opportunity to synthesize and apply the thoughts learned in this and previous coursework to examine a real-world scenario. This scenario will illustrate through example the practical importance and implications of various roles and functions of a Health Care Administrator. The investigative trainings will advance students’ understanding and ability to contemplate critically about the public relations process, and their problem-solving skills. As a result of this assignment, students will be better able to comprehend, scrutinize and assess respectable superiority and performance by all institutional employees.

ASSIGNMENT GUIDELINES (10%):

Students will critically measure the readings from Chapters 9 to 12 in your textbook. This assignment is planned to help you examination, evaluation, and apply the readings and strategies to your Health Care organization, and finance. You need to read the article (in the additional weekly reading resources localize in the Syllabus and also in the Lectures link) assigned for week 4 and develop a 3-4 page paper reproducing your understanding and capability to apply the readings to your Health Care organization and finance. Each paper must be typewritten with 12-point font and double-spaced with standard margins. Follow APA format when referring to the selected articles and include a reference page.

EACH   PAPER SHOULD INCLUDE THE FOLLOWING:

1. Introduction (25%) Provide a brief synopsis of the meaning (not a description) of each Chapter and articles you read, in your own words that will apply to the case study presented. 

2. Your Critique (50%):  Case Study

To say hospital and health system operating margins are different today than they were a decade ago may be an understatement. Medicare reimbursement reductions, cuts to state Medicaid programs and rising tides of uncompensated care have created an atmosphere where some hospitals, particularly smaller, community hospitals, are simply happy with a break-even balance sheet.

The environment is unlikely to change in the short term. The super committee was unable to reach a bipartisan agreement to cut $1.2 trillion over 10 years, and it will cause sequestration cuts of 2 percent to Medicare starting in 2016.

While 2012 may appear to be a grim time for hospitals to keep their finances positive, there are several things hospitals can do to go beyond just maintaining solvency. Hospitals and health systems essentially have two options: They can either cut costs or create new revenue streams. Here, several healthcare leaders share their thoughts on how this can be done and offer one recurring theme: Hospital and healthcare leadership needs to evaluate a multitude of planes rather than relying only on across-the-board savings cuts.

1. Focus on the continuum of care. One of the biggest changes occurring in healthcare is the full-scale shift away from fee-for-service and volume-based measures toward accountable care organizations and quality-based measures. Ann Pumpian, CFO of Sharp Healthcare in San Diego, says hospitals will need to look at the entire continuum of care, regardless if they join an ACO, if they plan to stay profitable in 2012 and beyond. She says the continuum of care hospitals need to focus on includes the initial admission, how services are provided within that admission to create the most efficient process for a quick yet appropriate discharge, a discharge to the appropriate post-acute setting and follow-ups with that discharge. 

Pearson Talbert, president of Aegis Health Group, says hospitals can take it one step further by fostering stronger, mutually beneficial relationships with physicians — especially primary care physicians. In addition to quality- and value-based principles, healthcare reform is also centered on preventive care, managing chronic illnesses and keeping people healthy before a hospital trip is required. To do that while staying profitable, Mr. Talbert says hospitals must focus on physician alignment and actively engage with the primary care physicians in their communities. “The primary care physician is the air traffic controller for the patient,” he says. 

Ms. Pumpian also emphasizes the hospital-physician relationship. Although some states prohibit hospitals from employing physicians, she says hospital efficiency and solvency hinges on a hospital’s affiliation and collaboration with physicians. Physicians facilitate patients through the continuum of care, and next year, it will be paramount for hospitals to keep and recruit high-quality physicians who increase a hospital’s referral base, have high ratings of patient satisfaction and have the highest commitment to quality patient care. “What is key is to make certain that these physicians and institutions are going in the same direction,” Ms. Pumpian says. “Both need to be incented to do the same thing, which is what’s best for patient care.”

2. Design models to reduce readmissions. Hospitals that realign their goals toward the entire continuum of care can then focus on one of the more pertinent aspects: reducing readmissions. Readmissions negatively impact a hospital’s bottom line in several ways, such as the high costs associated with them and scrutiny from private health insurers and patients. Now part of President Barack Obama’s healthcare reform, hospitals with high levels of preventable readmissions face the potential of losing a portion of their Medicare, Medicaid or other governmental reimbursements. “If [other hospitals] are not gearing up for that now, they are really behind the eight-ball,” Ms. Pumpian says. “They should’ve been doing this years ago.” 

She says there are several ways hospitals and their physicians can effectively reduce their readmissions, such as ensuring patients attend post-acute office visits routinely after discharge and overall providing resources to people to ensure they are taking the proper post-discharge steps. “This has proven to be a key indicator to keep readmissions from occurring,” Ms. Pumpian adds.

Scott Downing, executive vice president and chief sales and marketing officer at VHA, says a hospital’s preparation for the readmission risk is “absolutely critical,” and much of the responsibility will fall on a hospital’s case management and preventive care staff, who will need to be properly trained and managed to ensure overall readmission rates go down. “A hospital’s case management [staff] has to engage in conversations with the patients to help them be compliant with that care path,” Mr. Downing said. “There’s a wealth of effort and resources that hospitals apply, but they’re going to have to become even better at that.”

3. Have a good relationship with payors, and renegotiate managed care contracts. While hospitals cannot control the underpayments from Medicare, Medicaid and other governmental payors, they have a semblance of control over one major outlet: commercial and employer-based payors. Mr. Talbert says private insurance carriers comprise, on average, 35 percent of a hospital’s revenue.

According to Kyle Kobe, principal at healthcare consulting firm Equation, hospitals must take the time to understand existing contracts, benchmark managed care contracts against each other, conduct research to know what percentage of the insurer’s business comes from the hospital, routinely update stagnant and evergreen contracts and look for carve-out opportunities. Hospitals and their managed care departments must be prepared when renegotiating contracts, but at the same time, a level of respectful dialogue must exist — otherwise, fallouts will occur, leading to costly periods of no reimbursement and a public relations nightmare. “Often times, people don’t think about the fact there is a mutual respect that needs to occur with the payor and institution,” Ms. Pumpian says. “That is earned over time in a manner that allows you to help collaborate, design and develop the care delivery models and product designs that those payors will ultimately use.”

4. Manage new service lines to increase market share. When it comes to “creating new streams of revenue” for hospitals, this most commonly refers to adding new service lines. Larry Moore, CFO of Cumberland Medical Center in Crossville, Tenn., agrees increasing market share through new services is the most effective way to deal with any reduction in net payments.

Hospitals should not merely add any service line — for example, orthopedics — because it is historically profitable. Mr. Moore says hospitals need to conduct research and look at the demographics of their locale to determine which service lines are needed, what competitors in the area offer and what services stand to gain the most referrals. For example, roughly 10,000 baby boomers are becoming eligible for Medicare every day, and Mr. Moore says Cumberland, which has a high Medicare population, has been focusing on cardiovascular services. Additionally, he says the surrounding population tends to have a higher concentration of obese patients, and therefore Cumberland is also focusing on enhancing its orthopedic service line. 

Conversely, if hospitals want to become or remain profitable next year, they will have to monitor their service lines to see if any are hemorrhaging money. Jack Lahidjani, president of Mission Community Hospital in Panorama City, Calif., says this is especially important for community hospitals, as community hospitals can’t be the healthcare provider for all. “Most community hospitals don’t create a differentiation between themselves and a tertiary facility or a teaching facility,” Mr. Lahidjani says. “We can’t have the same number of programs as a Cedars-Sinai. They can afford to lose money on 10 to 15 programs because they are making money on the other 80. We need to evaluate every program on a quarterly basis and make adjustments accordingly. Hospitals need to be aware of community needs and cater to those needs.”

5. Control labor costs with meticulous data collecting. At most hospitals, more than 50 percent of expenses are related to labor costs or labor-related costs, and Mr. Lahidjani says “if you can’t control your labor costs, working on anything else almost becomes immaterial.”

Mr. Lahidjani, who also used to be CEO of the physician-owned and Los Angeles-based Miracle Mile Medical Center and CFO of Los Angeles-based Alta Healthcare System, says his hospitals hold daily “labor control meetings” for 10 minutes. Every department shows up, goes over their respective staffing metrics and manages their labor on a dollar-per-patient-day level. “If we are overstaffed by one nurse in surgery and understaffed by one nurse in the emergency room, can we move the surgical nurse to the ER?” Mr. Lahidjani says. “This type of communication where every manager and operator in the hospital gets on the same page also creates awareness of what’s going on in the other parts of the hospital.”

If hospitals do not manage their labor costs or have staff meetings on their labor rolls every day, then he says hospitals should, at the very least, be data-driven on this front on a bi-weekly, monthly, quarterly and annual basis. 

6. Reduce supply costs by working with vendors and physicians. After labor costs, supply costs are the second-largest money eater of a hospital’s operating budget. Clark Lagemann, vice president of Health Options Worldwide, says hospital leaders can reduce supply costs through two main ways: working with vendors to improve contracts and encouraging physicians to make fiscally responsible supply decisions. “A hospital should not shy away from approaching vendors for discounts,” Mr. Lagemann says. “This may help alleviate costs on the purchase product, and in my experience, most vendors are willing to negotiate if the volume of product allows for it.” Additionally, approaching physicians and working together to create a more cost-conscious supply plan for every department can help foster a better working relationship with physicians in addition to supply savings.

7. Improve deficiencies in the emergency room and operating room. Many hospitals consider their ERs and ORs to be two of the most important areas of a hospital because they represent a traditional “money loser” and a traditional “money winner.”

ERs and trauma areas are vital to any community health system, but hospitals have been facing growing numbers of uninsured patients walking into their ERs. This is leading to high amounts of uncompensated care. However, there are ways hospitals can reduce the large costs and pressures associated with the ER and its high volume of uncompensated care. Phil Lebherz, executive director of the non-profit Foundation for Health Coverage Education, says hospitals must actively use the ER to their advantage, as roughly 80 percent of the uninsured patients who come into the ER are eligible for some type of publically funded program. He says hospitals should make it a priority to help ER patients complete applications for publicly funded health coverage like Medicaid. This could make patients more willing to seek preventive care instead of resorting to last-minute, much-needed and highly expensive ER treatment, and it will also directly reduce a hospital’s uncompensated care and bad debt.

A hospital’s OR is typically one of the most profitable areas of a hospital due to the type of surgeries performed, and Mr. Lagemann says improvements in the OR can help a hospital maintain its levels of profitability. For example, he says future profits lie in new equipment, such as smart ORs and hybrid ORs. Mr. Lagemann adds that new technology, although an investment at first, can eventually lead to higher market share and patient volume, and it can also lower reoperation rates, which could improve reimbursements. 

8. Create population health management programs to gather health data analytics on chronic illnesses. The ACO model, or at least its population-health emphasis, is shifting hospitals’ thinking of how to be profitable. Mr. Talbert says hospitals are asking themselves if they are in the “healthcare” business or the “sick-care” business, and more often than not, he says they find they are in the “sick-care” business as they wait for patients to become sick before addressing health issues.

To counter this, Mr. Talbert says hospitals will need to create formal population health management programs through which the hospital can reach out and gather health data analytics on its local patients as a way to address potential health problems before they become costly, chronic issues. “If we are going to control costs of healthcare and start bending the curve downward, we have to start looking at things from the perspective of population health management,” he adds. If hospitals are able to see data and cost figures associated with chronic diseases — such as diabetes, cardiovascular disease, asthma, hypertension and others — they can reach out to their communities to start chronic care programs to mitigate costly, long-term health problems.

9. Consider outsourcing some services. Outsourcing services at hospitals is nothing new, but Mr. Lahidjani says eliminating the administrative overheard and farming out functions that are better handled on an independent contractor basis will directly result in bottom line savings. Laundry services, housekeeping, food services, facility maintenance and some biomedical and clinical departments are commonly outsourced services. Mr. Lahidjani says his hospital has also experimented with outsourcing its nurse education. Mission Community Hospital did not want to end its nurse education program, but it also did not know if it could continue to incur the program’s operating costs. Currently, the outsourced company has individuals that show up two or three times a month to hold its nursing educational seminars. Mr. Lahidjani says their nurses are still getting quality “know-how,” but their expenses have since been lowered.

A hospital must be prudent when it decides to outsource a service, though, and it must have a contingency plan if the proposal does not work out. “Whenever you outsource a service, you need to be prepared to bring it back in case the relationship disintegrates or if the third party is not able to provide the level of service we expected or anticipated,” Ms. Pumpian says.

10. Revamp the energy cost strategy. “Going green” could be more than just a strategy that positively impacts the environment and reduces reliance on fossil fuels — it could also save on a hospital’s bottom line. 

Dennis Olson, vice president of facilities at Mayo Clinic Health System in Eau Claire, Wis., says the hospital system has been actively revamping its sustainability and energy cost strategies, and it’s led to significant results. One of the larger projects involves the use of geothermal energy at a one of the health system’s dialysis centers under construction. Various pieces of equipment run through the ground and can extract heat or cooling from the natural ground water, which is typically around 45 to 50 degrees Fahrenheit. This extracted heating or cooling can be diverted to warm up the building in the winter and cool the building in the summer. He says a geothermal energy project is fairly expensive up front, but the benefits are in the long-term. Hospitals can expect a payback on its investment within seven to eight years, all while the hospital provides its own, truly natural energy. “You’re not burning any fuel to get heating and cooling sources such as natural gas or oil, and instead, you’re letting the Earth’s resources handle that,” Mr. Olson said.

CASE STUDY CHALLENGE 

1. Do you believe a computerized program are better, if so why?

2. Does the concept of revenue less expense equaling an increase in equity or found balance make sense to you? If not, Why?

3. Can you think of good outside source that could be used to obtain ratios for comparative purposes? 

3. Conclusion (15%)

Briefly summarize your thoughts & conclusion to your critique of the case study and provide a possible outcome for the Health Care Center. How did these articles and Chapters influence your opinions about Health Care law and Finance?

Evaluation will be based on how clearly you respond to the above, in particular:

a) The clarity with which you critique the case study;

b) The depth, scope, and organization of your paper; and,

c) Your conclusions, including a description of the impact of these Case study on any Health Care Setting, and finance.

ASSIGNMENT DUE DATE:

The assignment is to be electronically posted in the Assignments Link on Blackboard no later than noon on Thursday, May 23, 2019. 

 
"Not answered?"
Get the Answer

Week 3: Procedures and Functions – iLabPrint This PageConnect to the iLab here.Lab 3: Procedures and Functions (50 Points)See Syllabus “Due Dates for Assignments & Exams” for due date information. Submit your assignment to the Dropbox located on the silver tab at the top of this page.L A B O V E R V I E WScenario/SummaryThis week, we will expand the concepts used in Lab 2 and write a couple of procedures and a function that can be stored in the database. For all three of these program units, you will need to define parameters that will allow data to be passed back and forth. You will also be embedding SQL commands in the application code so that the program can communicate with the database.For the lab, you will need to create a script file containing the PL/SQL code that will address the lab steps below. Run the script file in your SQL*Plus session using the SET ECHO ON session command at the beginning to capture both the PL/SQL block code and output from Oracle after the block of code has executed. To successfully test your procedures and functions, you will need to execute several test cases so that all of the functionality can be evaluated. It is conceivable that you will have more files in the end than you did for Lab 2 so consider placing all the files when finished into a single ZIP file to submit to the Dropbox. Remember to spool your output to a file named with your last name plus lab 3 and give the file a text (.txt) extension. For example, if your last name was Johnson then the file would be named johnson_lab3.txt. Submit all the spooled output files AND the script file for grading of the lab.IMPORTANT: Be sure that you keep a copy of the script that you use to create your program units as you will be using it in the next lab.L A B S T E PStep 1: Creating the First ProcedureYour first procedure is to be named MOVIE_RENTAL_SP and is going to provide functionality to process movie rentals. Based on data that will represent the movie ID, member ID, and payment method your procedure will need to generate a rental ID and then insert a new row of data into the mm_rental table. The process will also need to update the quantity column in the mm_movie table to reflect that there is one less copy of the rented movie in stock. Along with the processing, you will also need to define some user-defined exception handlers that will be used in validating the input data. Since you may need to recreate your procedure several times during the debugging process, it is suggested that you use the CREATE OR REPLACE syntax at the beginning of the CREATE statement.The following steps will help you in setting up your code.You will need to define three parameters, one each for movie ID, member ID, and payment method. Make sure that each one matches the data type of the associated column in the database tables.You will have several other variables that will need to be identified and defined. It might be easier to read through the rest of the specs before you start trying to define these (look for hints in the specifications).You will need to define four user-defined exceptions; one for unknown movies, one for unknown member, one for unknown payment method, and one for if a movie is unavailable.You will need to validate each of the three pieces of data passed to the procedure. One easy way to do this might be to use a SELECT statement with the COUNT function to return a value into a variable based on a match in the database table against the piece of data that you are validating. If the query returns a zero then there is no match and the data is invalid; any value greater than zero means a match was found and thus the data is valid. You will need the following validations.Validate the movie ID to make sure it is valid. If not then raise the unknown movie exception.Validate the member ID to make sure one exists for that ID. If not then raise the unknown member exception.Validate the payment method to make sure it exists. If not then raise the unknown payment method exception.Check the movie quantity to make sure that there is a movie to be rented for the movie ID. If not then raise the unavailable movie exception.If all the data passes validation then you will need to create a new rental ID. This process should be in a nested block with its own EXCEPTION section to catch a NO_DATA_FOUND exception if one should happen. You can generate a new rental ID by finding the largest rental ID value in the mm_rental table (Hint: MAX function) and then increasing that value by one. The NO_DATA_FOUND exception would only be raised if there were no rental IDs in the table.Now you are ready to insert a new row of data into the mm_rental table. Use the SYSDATE function for the checkout date and NULL for the check-in date.Now, update the mm_movie table to reflect one less movie for the associated movie ID.Finally, you will need to set up an EXCEPTION section for all of your exception handling. For each exception output, you want to state what the problem is, the invalid data value, and a note that the rental cannot proceed. For example, for an invalid movie ID number, you might say, “There is no movie with id: 13 – Cannot proceed with rental”. You also want to include a WHEN OTHERS exception handler.Compile and check your code. If you get a PROCEDURE CREATED WITH COMPILATION ERRORS message then type in SHOW ERRORS and look in your code for the line noted in the error messages (be sure to compile your code with the session command SET ECHO ON). Once you have a clean compile then your are ready to test.Step 2: Testing the First ProcedureYou will need to test for scenarios that will allow both a clean movie rental and test each exception. This means that you will need to run at least five test cases. One each for the following:No movie for the ID supplied (use 13, 10, and 2 for the parameters).No member for the ID supplied (use 10, 20, and 2 for the parameters).No payment method for the ID supplied (use 10, 10, and 7 for the parameters).A successful rental (use 5, 10, and 2 for the parameters).No movie available for the ID supplied (use 5, 11, and 2 for the parameters). Since there is only one movie available for ID 5, you will get this exception.Your output from the testing should look similar to (this would be the output for the first test above):exec movie_rent_sp(13, 10, 2);Output:There is no movie with id: 13 Cannot proceed with rental PL/SQL procedure successfully completed.Be sure that when you have verified that everything works, you run your testing in a spools session and save the file to be turned in.Step 3: Creating the Second ProcedureYour second procedure should be named MOVIE_RETURN_SP and should facilitate the process of checking a movie rental back in. For this procedure, you will only need to pass one piece of data to the procedure; the rental ID. You will need two user-defined exceptions; one for no rental record and one for already returned. You will be able to use several of the same techniques you used in the first procedure for your validation.The following steps will help in setting up your code.You will need to define only one parameter for the rental ID number. Make sure that it matches the data type of the associated column in the database table.You will have several other variables that will need to be identified and defined. It might be easier to read through the rest of the specs before you start trying to define these (look for hints in the specifications).You will need to define the two user-defined exceptions mentioned above.You will need to validate the rental ID that is passed to the procedure. If it is not a valid one then raise the associated exception.If it is valid then get the movie ID and check-in date from the mm_rental table.Now, check the check-in date to make sure that it is NULL. If it is not then raise the associated exception.If everything checks out then update the mm_rental table for the rental ID you have and use the SYSDATE function for the check-in date.Now, you can update the quantity in the mm_movie table for the associated movie ID to reflect that the movie is back in stock.Last, set up your exception section using appropriate error message text and data.Compile and check your code. If you get a PROCEDURE CREATED WITH COMPILATION ERRORS message then type in SHOW ERRORS and look in your code for the line noted in the error messages (be sure to compile your code with the session command SET ECHO ON). Once you have a clean compile then your are ready to test.Step 4: Testing the Second ProcedureYou will need to test for scenarios that will allow both a clean rental return and test each exception. This means that you will need to run at least three test cases. One each for the following:No rental for the ID supplied (use 20 for the parameter).A successful rental return (use 1 for the parameter).Try to return the same rental in Step 2.You output from the testing should look similar to (this would be the output for the first test above):exec movie_return_sp(20);Output:There is no rental record with id: 20 Cannot proceed with return PL/SQL procedure successfully completed.Be sure that when you have verified that everything works, you run your testing in a spools session and save the file to be turned in.Step 5: Creating the FunctionYour function should be named MOVIE_STOCK_SF and will be used to return a message telling the user whether a movie title is available or not based on the movie ID passed to the function. The exception handling that will be needed is for NO_DATA_FOUND but we are going to set it up as a RAISE_APPLICATION_ERROR.The following steps will help in setting up your code.You will need to define only one parameter for the movie ID number. Make sure that it matches the data type of the associated column in the database table. Also, since you will be returning a notification message, you will want to make sure your RETURN statement references a data type that can handle that (Hint: variable length data type).You will have several other variables that will need to be identified and defined. It might be easier to read through the rest of the specs before you start trying to define these (look for hints in the specifications).You will not be doing any validation so the first thing you need to do is retrieve the movie title and quantity available from the mm_movie table based on the ID passed to the function.Now, you need to determine if any are available. IF the value in the quantity column is greater than zero then you will be returning a message saying something like “Star Wars is available: 0 on the shelf”, ELSE if the value is zero then you should return a message saying something like “Star Wars is currently not available”. Hint: A good way to return a test string is to assign it to a variable and then simply use the variable name in the RETURN clause.Finally, set up your exception section to use a RAISE_APPLICATION_ERROR for the NO_DATA_FOUND exception handler. Assign an error number of -20001 to it and an error message that states there is no movie available for the ID (be sure to include the id in the message).Compile and check your code. If you get a FUNCTION CREATED WITH COMPILATION ERRORS message then type in SHOW ERRORS and look in your code for the line noted in the error messages (be sure to compile your code with the session command SET ECHO ON). Once you have a clean compile then your are ready to test.Step 6: Testing the FunctionYou will need to test for all three possible scenarios.Test for a movie in stock using movie ID 11.Test for a movie not in stock using movie ID 5 (from your tests of the second procedure above, the quantity should be 0).Test for an invalid movie ID using movie ID 20.For test number 2, you may need to manipulate the quantity amount in the database, which will be fine.Test your function by using a select statement against the DUAL table like in the example below:select movie_stock_sf(20) from dual;Be sure that when you have verified that everything works, you run your testing in a spools session and save the file to be turned in.This concludes the Lab for Week 3.DeliverablesYour deliverable submission should consist of your Lab 3 script file and the spooled output files described at the beginning of the lab. DROP TABLE MM_MOVIE_TYPE CASCADE CONSTRAINTS PURGE;DROP TABLE mm_pay_type CASCADE CONSTRAINTS PURGE;DROP TABLE mm_member CASCADE CONSTRAINTS PURGE;DROP TABLE mm_movie CASCADE CONSTRAINTS PURGE;DROP TABLE mm_rental CASCADE CONSTRAINTS PURGE;DROP SEQUENCE mm_rental_seq;CREATE TABLE mm_movie_typeNUMBER(2),movie_category VARCHAR(12),CONSTRAINT movie_cat_id_pk PRIMARY KEY (movie_cat_id));CREATE TABLE mm_pay_type(payment_methods_id NUMBER(2),VARCHAR(14),CONSTRAINT payment_methods_id_pk PRIMARY KEY (payment_methods_id));CREATE TABLE mm_member(member_id NUMBER(4),VARCHAR(12),VARCHAR(8),VARCHAR(9),VARCHAR(2),credit_card VARCHAR(12),VARCHAR(1) DEFAULT ‘N’,mailing_list VARCHAR(1),CONSTRAINT cust_custid_pk PRIMARY KEY (member_id),CONSTRAINT cust_credcard_ck CHECK (LENGTH(credit_card) = 12));CREATE TABLE mm_movieNUMBER(4),movie_title VARCHAR(40),NUMBER(2) NOT NULL,movie_value DECIMAL(5,2),movie_qty NUMBER(2),CONSTRAINT movies_id_pk PRIMARY KEY (movie_id),CONSTRAINT movie_type_fk FOREIGN KEY (movie_cat_id)REFERENCES mm_movie_type(movie_cat_id),CONSTRAINT movies_value_ck CHECK (movie_value BETWEEN 5 and 100));CREATE TABLE mm_rental(rental_id NUMBER(4),NUMBER(4),NUMBER(4),checkout_date DATE DEFAULT SYSDATE,checkin_date DATE,payment_methods_id NUMBER(2),CONSTRAINT rentals_pk PRIMARY KEY (rental_id),CONSTRAINT member_id_fk FOREIGN KEY (member_id)REFERENCES mm_member(member_id),CONSTRAINT movie_id_fk FOREIGN KEY (movie_id)REFERENCES mm_movie(movie_id),CONSTRAINT pay_id_fk FOREIGN KEY (payment_methods_id)REFERENCES mm_pay_type(payment_methods_id));Create sequence mm_rental_seq start with 13;INSERT INTO mm_member (member_id, last, first, license_no, license_st, credit_card)VALUES (10, ‘Tangier’, ‘Tim’, ‘111111111’, ‘VA’, ‘123456789111’);INSERT INTO mm_member (member_id, last, first, license_no, license_st, credit_card, mailing_list)VALUES (11, ‘Ruth’, ‘Babe’, ‘222222222’, ‘VA’, ‘222222222222’, ‘Y’);INSERT INTO mm_member (member_id, last, first, license_no, license_st, credit_card, mailing_list)VALUES (12, ‘Maulder’, ‘Fox’, ‘333333333’, ‘FL’, ‘333333333333’, ‘Y’);INSERT INTO mm_member (member_id, last, first, license_no, license_st, credit_card)VALUES (13, ‘Wild’, ‘Coyote’, ‘444444444’, ‘VA’, ‘444444444444’);INSERT INTO mm_member (member_id, last, first, license_no, license_st, credit_card, mailing_list)VALUES (14, ‘Casteel’, ‘Joan’, ‘555555555’, ‘VA’, ‘555555555555’, ‘Y’);INSERT INTO mm_movie_type (movie_cat_id, movie_category) VALUES ( ‘1’, ‘SciFi’);INSERT INTO mm_movie_type (movie_cat_id, movie_category) VALUES ( ‘2’, ‘Horror’);INSERT INTO mm_movie_type (movie_cat_id, movie_category) VALUES ( ‘3’, ‘Western’);INSERT INTO mm_movie_type (movie_cat_id, movie_category) VALUES ( ‘4’, ‘Comedy’);INSERT INTO mm_movie_type (movie_cat_id, movie_category) VALUES ( ‘5’, ‘Drama’);INSERT INTO mm_movie (movie_id, movie_title, movie_cat_id, movie_value, movie_qty) VALUES (1, ‘Alien’, ‘1’, 10.00, 5);INSERT INTO mm_movie (movie_id, movie_title, movie_cat_id, movie_value, movie_qty) VALUES (2, ‘Bladerunner’, ‘1’, 8.00, 3);INSERT INTO mm_movie (movie_id, movie_title, movie_cat_id, movie_value, movie_qty) VALUES (3, ‘Star Wars’, ‘1’, 15.00, 11);INSERT INTO mm_movie (movie_id, movie_title, movie_cat_id, movie_value, movie_qty) VALUES (4,’Texas Chainsaw Masacre’, ‘2’, 7.00, 2);INSERT INTO mm_movie (movie_id, movie_title, movie_cat_id, movie_value, movie_qty) VALUES (5, ‘Jaws’, ‘2’, 7.00,1);INSERT INTO mm_movie (movie_id, movie_title, movie_cat_id, movie_value, movie_qty) VALUES (6, ‘The good, the bad and the ugly’, ‘3’, 7.00,2);INSERT INTO mm_movie (movie_id, movie_title, movie_cat_id, movie_value, movie_qty) VALUES (7, ‘Silverado’, ‘3’, 7.00,1);INSERT INTO mm_movie (movie_id, movie_title, movie_cat_id, movie_value, movie_qty) VALUES (8, ‘Duck Soup’, ‘4’, 5.00,1);INSERT INTO mm_movie (movie_id, movie_title, movie_cat_id, movie_value, movie_qty) VALUES (9, ‘Planes, trains and automobiles’, ‘4’, 5.00,3);INSERT INTO mm_movie (movie_id, movie_title, movie_cat_id, movie_value, movie_qty) VALUES (10, ‘Waking Ned Devine’, ‘4’, 12.00,4);INSERT INTO mm_movie (movie_id, movie_title, movie_cat_id, movie_value, movie_qty) VALUES (11, ‘Deep Blue Sea’, ‘5’, 14.00,3);INSERT INTO mm_movie (movie_id, movie_title, movie_cat_id, movie_value, movie_qty) VALUES (12, ‘The Fifth Element’, ‘5’, 15.00,5);INSERT INTO mm_pay_type (payment_methods_id, payment_methods) VALUES (‘1’, ‘Account’);INSERT INTO mm_pay_type (payment_methods_id, payment_methods) VALUES (‘2’, ‘Credit Card’);INSERT INTO mm_pay_type (payment_methods_id, payment_methods) VALUES (‘3’, ‘Check’);INSERT INTO mm_pay_type (payment_methods_id, payment_methods) VALUES (‘4’, ‘Cash’);INSERT INTO mm_pay_type (payment_methods_id, payment_methods) VALUES (‘5’, ‘Debit Card’);INSERT INTO mm_rental (rental_id, member_id, movie_id, payment_methods_id) VALUES (1,’10’, ’11’, ‘2’);INSERT INTO mm_rental (rental_id, member_id, movie_id, payment_methods_id) VALUES (2,’10’, ‘8’, ‘2’);INSERT INTO mm_rental (rental_id, member_id, movie_id, payment_methods_id) VALUES (3,’12’, ‘6’, ‘2’);INSERT INTO mm_rental (rental_id, member_id, movie_id, payment_methods_id) VALUES (4,’13’, ‘3’, ‘5’);INSERT INTO mm_rental (rental_id, member_id, movie_id, payment_methods_id) VALUES (5,’13’, ‘5’, ‘5’);INSERT INTO mm_rental (rental_id, member_id, movie_id, payment_methods_id) VALUES (6,’13’, ’11’, ‘5’);INSERT INTO mm_rental (rental_id, member_id, movie_id, payment_methods_id) VALUES (7,’14’, ’10’, ‘2’);INSERT INTO mm_rental (rental_id, member_id, movie_id, payment_methods_id) VALUES (8,’14’, ‘7’, ‘2’);INSERT INTO mm_rental (rental_id, member_id, movie_id, payment_methods_id) VALUES (9,’12’, ‘4’, ‘4’);INSERT INTO mm_rental (rental_id, member_id, movie_id, payment_methods_id) VALUES (10,’12’, ’12’, ‘4’);INSERT INTO mm_rental (rental_id, member_id, movie_id, payment_methods_id) VALUES (11,’12’, ‘3’, ‘4’);INSERT INTO mm_rental (rental_id, member_id, movie_id, payment_methods_id) VALUES (12,’13’, ‘4’, ‘5’);UPDATE mm_rental SET checkout_date = ’04-JUN-03′;COMMIT;

 
"Not answered?"
Get the Answer

QUESTION 1

  1. From Boilercast lecture 2-1: Back in 1974 real GDP decreased by 0.5% and the inflation rate increased to 11%. Which aggregate demand or aggregate supply shift could explain this change?
  2. Increase in aggregate demand.
  3. Decrease in aggregate demand.
  4. Increase in aggregate supply.
  5. Decrease in aggregate supply.

3 points  

QUESTION 2

Boilercast Lecture 2-2: Here is a table showing the macro measurements for the U.S. economy from 2007 to 2009.

Which of the following best describes what happened in the Goods Market of the U.S. economy in 2009?

a.Aggregate demand increased, output and the price level increased, and output was above potential.

b.Aggregate demand decreased, output and the price level decreased, and output was above potential.

c.Aggregate demand decreased, output and the price level decreased, and output was below potential.

d.Aggregate supply increased, output and the price level decreased, and output was above potential.

e.Aggregate supply decreased, output and the price level decreased, and output was below potential.

3 points  

QUESTION 3

  1. Boilercast Lecture 2-3: What policy could the Federal Reserve have used to speed the recovery from the recession of 1907-08?

a.Increase the discount rate to increase the money supply.

b.Decrease the discount rate to increase the money supply.

c.Increase the discount rate to decrease the money supply.

d.Decrease the discount rate to decrease the money supply.

3 points  

QUESTION 4

  1. Consider the goods market in our macroeconomic model. Which two changes could both cause a decrease in unemployment and an increase in real GDP?

a.A fall in oil prices and a decrease in government purchases.

b.An increase in investment spending and perfect weather for agriculture.

c.An increase in import spending and a decrease in export spending.

d.A rise in oil prices and an increase in consumer spending.

1 points  

QUESTION 5

  1. Consider second shift #1, where changes in aggregate demand can cause shifts in aggregate supply in the goods market. Suppose the unemployment rate was higher than 5%, meaning it was more than the unemployment rate at potential output.  Think carefully about whether equilibrium output is higher or lower than potential output! According to second shift #1, what could happen as a result?

a.Aggregate demand will increase.

b.Aggregate demand will decrease.

c.Aggregate supply will increase.

d.Aggregate supply will decrease.

1 points  

QUESTION 6

  1. Consider second shift #2, where changes in the money market affect the goods market. Which changes in the money market could cause a decrease in real GDP in the goods market?

a.An increase in the bank reserve ratio leading to an increase in the money supply.

b.An increase in the bank reserve ratio leading to a decrease in the money supply.

c.A decrease in the bank reserve ratio leading to a decrease in the money supply .

d.A decrease in the bank reserve ratio leading to an increase in the money supply.

1 points  

QUESTION 7

  1. Consider second shift #3, where changes in the goods market affect the money market. Suppose real GDP and inflation increased. What changes would occur in the money market?

a.An increase in money supply.

b.A decrease in money supply.

c.An increase in money demand.

d.A decrease in money demand.

1 points  

QUESTION 8

  1. Consult the worksheet for this question. Here’s a link: Online Project Quiz Worksheet, Module 2

d.Output increases above potential, prices increase, interest rate increases.

2 points  

QUESTION 9

  1. Consult the worksheet data table for this question. What happened in the goods market in 1920?  

a.Input costs increased, aggregate supply decreased, and output fell to potential.

b.Input costs decreased, aggregate supply increased, and output rose further above potential.

c.The interest rate spread increased, aggregate demand decreased, and output fell to potential.

d.The interest rate spread decreased, aggregate demand increased, and output rose further above potential.

2 points  

QUESTION 10

  1. What policy could the Federal Reserve have used to bring down inflation after World War I?

a.Increase the discount rate to increase the money supply.

b.Decrease the discount rate to increase the money supply.

c.Increase the discount rate to decrease the money supply.

d.Decrease the discount rate to decrease the money supply.

2 points  

QUESTION 11

  1. Consult the data table in the worksheet. What happened in the money market in 1921?
  2. a.Money demand increased, money supply was unchanged.
  3. b.Money demand was unchanged, money supply decreased.
  4. c.Money demand decreased, money supply decreased more.
  5. d.Money demand was unchanged, money supply increased.

2 points  

QUESTION 12

  1. Consider the worksheet table showing the four economic indicators for the 1960’s. Choose the paragraph that best describes the data for your whole decade.
  2. a.The decade saw an unstable economy. In several years output grew rapidly, but there was a recession at the decade’s beginning and a severe recession in the middle. Unemployment dropped early in the decade, then soared to high rates during the recession. Lenders became very pessimistic during the mid-decade recession, so riskier corporations had trouble borrowing. And, to top it all off, the decade saw the highest inflation of the past fifty years. There were some years when inflation and unemployment were both above average, the worst of all possible worlds.
  3. b.The decade saw one of the longest expansions in U.S. history. After a mild recession at the start, output grew steadily, at above average rates towards the end of the decade. Unemployment peaked early, then declined to low levels by the end of the decade. In the money market lenders were confident through most of the decade, after a bit of trouble early. Inflation was troublesome early in the decade. Remarkably, though, despite steady growth and falling unemployment, inflation declined and remained below average during most of the decade.
  4. c.The decade saw one of the longest expansions in U.S. history. After a mild recession at the beginning of the decade, output grew steadily, often rapidly. Unemployment rates declined to very low levels by the end of the decade. The money market was settled, as lenders remained confident throughout the decade. All was not as well as it seemed, though. Inflation was under control at the beginning of the decade. After a steady rise, by the end of the decade it had become a problem.
  5. d.The decade began with the worst recession since the Great Depression. Output fell substantially and unemployment rose to the highest levels in decades. Inflation was high as well, the worst of all possible worlds. Money markets became severely pessimistic with the downturn, and lenders remained gloomy throughout most of the decade.  The recovery saw rapid growth at first, but the unemployment rate fell to acceptable levels only by decade’s end. The recession helped bring down inflation, though, to very low levels by mid-decade. Inflation crept up again by the decade’s end, however. 

2 points  

QUESTION 13

  1. Now use the 1960’s data table and apply our macroeconomic model to analyze the data for 1964 to 1968.  
  2. •         Assume that Q on the horizontal axis of the goods market represents real GDP.
  3. •         Assume that changes in P on the vertical axis of the goods market represent changes in the inflation rate (so a fall in P represents a decrease of the inflation rate).  
  4. •         Assume that unemployment is represented by the difference between equilibrium output and potential output, and that the unemployment rate at potential is 5%.
  5. •         Assume that changes in r on the vertical axis of the money market represent changes in the interest rate spread (so a rise in r means a bigger spread). Changes of less than 0.1% are not important.
  6. •         When in doubt, compare the first year to the last year, and ignore the years between. That identifies the trend of the whole period.
  7. Which shift best describes this time period in the goods market during 1964 to 1968?
  8. a.Aggregate supply was increasing.
  9. b.Aggregate supply was decreasing.
  10. c.Aggregate demand was increasing.
  11. d.Aggregate demand was decreasing.

2 points  

QUESTION 14

  1. Which shift best describes this time period in the money market during 1964 to 1968? Use the 1960’s data table.
  2. a.Money demand was increasing.
  3. b.Money demand was decreasing.
  4. c.Money demand was increasing but money supply was increasing more.
  5. d.Money demand was decreasing but money supply was decreasing more.

2 points  

QUESTION 15

  1. What counter-cyclical monetary policy should the Federal Reserve have followed during this period, in order to stabilize the economy at potential output during 1964 to 1968?
  2. a.There was no clear counter-cyclical monetary policy, because output rose above potential but the inflation rate was falling.
  3. b.Increase the money supply to decrease the real interest rate, and so increase aggregate demand.
  4. c.There was no clear counter-cyclical monetary policy, because output fell below potential but the inflation rate was rising.
  5. d.Decrease the money supply to increase the real interest rate, and so decrease aggregate demand.

2 points  

QUESTION 16

  1. Choose a “story” that best matches the data and the analysis from the model for the years 1964 to 1968. (The names of wars and policymakers have been removed so as not to give away the answer to those who know U.S. history.)
  2. a.The effects of a severe recession early in the decade were still being felt at the beginning of this period. Output was less than potential, and financial markets remained pessimistic. As financial markets gained confidence, however, borrowing costs fell for more-risky businesses, which increased investment spending. Tax cuts for households added to consumer spending, and the government increased spending on military purchases.
  3. b.At the beginning of this period the economy was expanding and output approached potential. Then a war helped cause large increases in oil prices, which increased business costs. Businesses cut back on production and passed higher costs to consumers in higher prices, as much as they could. High inflation increased money demand, and financial markets became pessimistic, which further contributed to the economy’s problems.
  4. c.The effects of recession early in the decade had faded by the beginning of this period. Rapid technological advance helped cause steady growth in output. These new technologies along with falling oil prices caused inflation to decrease, even though output rose above potential. Financial markets were optimistic throughout this period. They increased lending enough to hold interest rates stable despite rising incomes.
  5. d.At the beginning of this period the U.S. President decided to expand Federal social spending and fight a war against U.S. enemies at the same time. A large tax reduction that had been proposed by a previous President took effect. After that, consumer and government spending increased rapidly. Financial markets were generally optimistic, but increasing demand for money raised borrowing costs, especially for more-risky businesses.

4 points  

QUESTION 17

  1. Consider the worksheet table showing the four economic indicators for the 1990’s. Choose the paragraph that best describes the data for your whole decade.
  2. a.The decade saw an unstable economy. In several years output grew rapidly, but there was a recession at the decade’s beginning and a severe recession in the middle. Unemployment dropped early in the decade, then soared to high rates during the recession. Lenders became very pessimistic during the mid-decade recession, so riskier corporations had trouble borrowing. And, to top it all off, the decade saw the highest inflation of the past fifty years. There were some years when inflation and unemployment were both above average, the worst of all possible worlds.
  3. b.The decade saw one of the longest expansions in U.S. history. After a mild recession at the start, output grew steadily, at above average rates towards the end of the decade. Unemployment peaked early, then declined to low levels by the end of the decade. In the money market lenders were confident through most of the decade, after a bit of trouble early. Inflation was troublesome early in the decade. Remarkably, though, despite steady growth and falling unemployment, inflation declined and remained below average during most of the decade.
  4. c.The decade saw one of the longest expansions in U.S. history. After a mild recession at the beginning of the decade, output grew steadily, often rapidly. Unemployment rates declined to very low levels by the end of the decade. The money market was settled, as lenders remained confident throughout the decade. All was not as well as it seemed, though. Inflation was under control at the beginning of the decade. After a steady rise, by the end of the decade it had become a problem.
  5. d.The decade began with the worst recession since the Great Depression. Output fell substantially and unemployment rose to the highest levels in decades. Inflation was high as well, the worst of all possible worlds. Money markets became severely pessimistic with the downturn, and lenders remained gloomy throughout most of the decade.  The recovery saw rapid growth at first, but the unemployment rate fell to acceptable levels only by decade’s end. The recession helped bring down inflation, though, to very low levels by mid-decade. Inflation crept up again by the decade’s end, however. 

2 points  

QUESTION 18

  1. Now let’s apply our macroeconomic model to analyze the data in the above table for 1994 to 1998.
  2. •         Assume that Q on the horizontal axis of the goods market represents real GDP.
  3. •         Assume that changes in P on the vertical axis of the goods market represent changes in the inflation rate (so a fall in P represents a decrease of the inflation rate).  
  4. •         Assume that unemployment is represented by the difference between equilibrium output and potential output, and that the unemployment rate at potential is 5%.
  5. •         Assume that changes in r on the vertical axis of the money market represent change in the interest rate spread (so a rise in r means a bigger spread). Changes of less than 0.1% are not important.
  6. •         When in doubt, compare the first year to the last year, and ignore the years between. That identifies the trend of the whole period.
  7. Which of the above goods market graphs best describes the 1994-1998 period?
  8. a.A
  9. b.B
  10. c.C
  11. d.D

2 points  

QUESTION 19

  1. Which of the above money market graphs best describes the 1994-1998 period?
  2. a.E
  3. b.F
  4. c.G
  5. d.H

2 points  

QUESTION 20

  1. What counter-cyclical monetary policy should the Federal Reserve have followed during this period, in order to stabilize the economy at potential output during 1994 to 1998?
  2. a.There was no clear counter-cyclical monetary policy, because output rose above potential but the inflation rate was falling.
  3. b.Increase the money supply to decrease the real interest rate, and so increase aggregate demand.
  4. c.There was no clear counter-cyclical monetary policy, because output fell below potential but the inflation rate was rising.
  5. d.Decrease the money supply to increase the real interest rate, and so decrease aggregate demand.

2 points  

QUESTION 21

  1. Choose a “story” that best matches the data and the analysis from the model for the years 1994 to 1998. (The names of wars and policymakers have been removed so as not to give away the answer to those who know U.S. history.)
  2. a.The effects of a severe recession early in the decade were still being felt at the beginning of this period. Output was less than potential, and financial markets remained pessimistic. As financial markets gained confidence, however, borrowing costs fell for more-risky businesses, which increased investment spending. Tax cuts for households added to consumer spending, and the government increased spending on military purchases.
  3. b.At the beginning of this period the economy was expanding and output approached potential. Then a war helped cause large increases in oil prices, which increased business costs. Businesses cut back on production and passed higher costs to consumers in higher prices, as much as they could. High inflation increased money demand, and financial markets became pessimistic, which further contributed to the economy’s problems.
  4. c.The effects of recession early in the decade had faded by the beginning of this period. Rapid technological advance helped cause steady growth in output. These new technologies along with falling oil prices caused inflation to decrease, even though output rose above potential. Financial markets were optimistic throughout this period. They increased lending enough to hold interest rates stable despite rising incomes.
  5. d.At the beginning of this period the U.S. President decided to expand Federal social spending and fight a war against U.S. enemies at the same time. A large tax reduction that had been proposed by a previous President took effect. After that, consumer and government spending increased rapidly. Financial markets were generally optimistic, but increasing demand for money raised borrowing costs, especially for more-risky businesses.
 
"Not answered?"
Get the Answer

Question 1 (Multiple Choice Worth 1.6666 points) Archaea differ from bacteria except for the following characteristic: a) They have a different type of ribosomal RNA b) They have chemically different cell walls c) They are prokaryotes d) They do not cause common diseases e) none of the above

Question 2 (Multiple Choice Worth 1.6666 points) Jason is a farmer developing new varieties of vegetables and she wishes totest the efficiency of water uptake by some vegetable varieties. What tissue should she monitor? a) Vascular tissue. b) Dermal tissue. c) Ground issue. d) Meristematic tissue. e) None of the above.

Question 3 (Multiple Choice Worth 1.6666 points) Janice is rehabilitating an ecosystem and wants to encourage moss reproduction (not quite likely, as ecosystem recovery is a HUGE project). What would be the consequence if she plucked moss sporophytes and planted them in the ground? a) They would produce spores that would form new sporophytes. b) They would produce gametes that would develop into gametophytes. c) They would fail to thrive as they depend on gametophytes for nourishment. d) They would produce spores that would develop into gametophytes. e) They would fail to reproduce because mosses require water for sperm transit.

Question 4 (Multiple Choice Worth 1.6666 points) Dana was studying viral DNA. Which of the following would she NOT detect? a) Adenine. b) Guanine. c) Ribose. d) Cytosine. e) Thymine.

Question 5 (Multiple Choice Worth 1.6666 points) Ethan is studying viral and bacterial diseases. Which of the following is NOT an accurate comparison of bacteria and viruses? a) Most viruses enter cells whereas most bacteria do not. b) Bacterial genes are made of DNA whereas viral genes may be made of DNA or RNA. c) Bacterial infections are more susceptible to drugs. d) Bacteria may secrete toxins whereas viruses do not. e) Bacterial genes are made of DNA whereas viruses lack genes and use host cell genes.

Question 6 (Multiple Choice Worth 1.6666 points) The body of most fungi is composed of a mass of hyphae called a: a) Mushroom b) Soma c) Mycelium d) Fungoid e) none of the above

Question 7 (Multiple Choice Worth 1.6666 points) If a gorilla has somatic cells containing 48 chromosomes, how many chromosomes will be found in its gametes? a) 23 b) 24 c) 48 d) 96 e) none of the above

Question 8 (Multiple Choice Worth 1.6666 points) What is a unique feature of ferns in comparison with angiosperms? a) One type of spore is produced. b) Gametophytes are part of the life cycle. c) Embryos are contained in seeds. d) Flowers are very tiny. e) Sporophytes are not dependent for nourishment on gametophytes.

Question 9 (Multiple Choice Worth 1.6666 points) Biologists estimate that perhaps up to 30 million different species exist on Earth. These numbers of organisms illustrate: a) diversity of life b) unity of life c) theory of evolution d) natural selection e) none of the above

Question 10 (Multiple Choice Worth 1.6666 points) Two parents pass on their genes to offspring in: a) asexual reproduction b) sexual reproduction c) mitosis d) meiosis e) both c and d are correct

Question 11 (Multiple Choice Worth 1.6666 points) Grace over-watered her plants, causing an extreme hypotonic environment for the plant cells. What protects the plant cells from bursting? a) Plasma membrane. b) Vacuole. c) Vesicle. d) Cytoskeleton. e) Cell wall.

Question 12 (Multiple Choice Worth 1.6666 points) Ava had a pap smear of the cells of her uterine cervix and a pathologist examining the cells was of the opinion that they were dysplastic. What does this mean? a) The cells are normal. b) The cells are malignant. c) The cells are metastatic. d) The cells are precancerous. e) The cells have undergone progression.

Question 13 (Multiple Choice Worth 1.6666 points) Shannon is a botanist who observed stomatal closing of plants under daytime drought conditions. Why would the stomata close? a) Loss of potassium from companion cells. b) Loss of gasses from guard cells. c) Influx of potassium into guard cells. d) Influx of water into guard cells. e) To prevent loss of water from guard cells.

Question 14 (Multiple Choice Worth 1.6666 points) Which of the following is a scientific hypothesis? a) The biologist measured 300 fish. b) The ecologist objected to damming of the river. c) The doctor ordered 20 blood tests. d) The results of the lab tests showed that the lake was polluted. e) The geneticist proposed that some forms of heart disease are inherited.

Question 15 (Multiple Choice Worth 1.6666 points) Robert is an ecologist studying the pathway that a pollutant, mercury, takes as it moves through the environment, including its consumption by fish, birds, and people. What unit of nature is he studying? a) Community. b) Species. c) Population. d) Ecosystem. e) Colonial organisms.

Question 16 (Multiple Choice Worth 1.6666 points) Transport proteins that facilitate the movement of water molecules across the cell membrane are: a) carrier proteins b) enzymes c) aquaporins d) receptor proteins e) none of the above

Question 17 (Multiple Choice Worth 1.6666 points) If you examined a microscopic preparation of a cell that showed pairs of chromatids with constrictions in the center, what term would you apply to the constrictions? a) Centromeres. b) Centrioles. c) Metaphase plates. d) Microtubule organizing centers. e) Centrosomes.

Question 18 (Multiple Choice Worth 1.6666 points) Charleen noticed that some plants in her nursery were falling over. What cell type may be defective? a) Sieve tube. b) Companion cells. c) Collenchyma cells. d) Meristematic cells. e) Parenchyma cells.

Question 19 (Multiple Choice Worth 1.6666 points) If you observed some ciliates such as paramecia under the microscope you might notice the process of conjugation. What is the outcome of conjugation? a) Transverse fission of the cell. b) Fusion of two cells into one. c) Sexual reproduction of an offspring cell.. d) Promotion of genetic variability. e) Binary fission.

Question 20 (Multiple Choice Worth 1.6666 points) Scientists have estimated that in a teaspoon of contaminated water there may be five billion viruses. How do viruses compare in size to other units? Arrange the following in order of size from greatest to least: (1) Virus, (2) bacterium, (3) human blood cell, (4) prion. a) 1>2>3>4. b) 4>1>2>3. c) 3>2>1>4. d) 2>3>1>4.

Question 21 (Multiple Choice Worth 1.6666 points) Abe is a technician instructed to photograph some chromatids. How would he distinguish a chromatid from a chromosome? a) A chromatid is the portion of a chromosome on each side of its centromere. b) A chromatid is the portion of a chromosome on each side of its kinetochore. c) A chromatid is a twin of another chromatid resulting from chromosomal copying, both being joined at the centromere region. d) A chromatid is a chromosome that has condensed into a DNA super coil prior to cell division, whereas a chromosome is uncondensed. e) A chromatid is the structure at each end of a dividing cell that provides microtubules for moving chromosomes during cell division.

Question 22 (Multiple Choice Worth 1.6666 points) If you encountered a large leafy-looking fern plant, you might notice tiny dots on the undersides of the leaves. If you removed these dots what might be the consequence? a) Failure of photosynthesis. b) Destruction of the tiny fern embryos. c) Destruction of the tiny fern zygotes. d) Destruction of the tiny fern gametophytes. e) Destruction of the tiny fern sporangia.

Question 23 (Multiple Choice Worth 1.6666 points) Grace spent long hours in the sun and damaged the DNA of her skin cells so that the damaged cells could no longer effectively make new skin cells. How would you classify the damaged DNA segment? a) Intron. b) Exon. c) Telomere. d) Transposon. e) Mutation.

Question 24 (Multiple Choice Worth 1.6666 points) Which statement is not true about a karyotype? a) Chromosomes are arranged in matched pairs. b) All eukaryotic karyotypes contain 46 chromosomes. c) Chromosomes are linear in appearance. d) Karyotypes can be used to screen for chromosome abnormalities. e) none of the above

Question 25 (Multiple Choice Worth 1.6666 points) What do the processes of active transport and facilitated process have in common? a) need for energy called ATP b) use of transport proteins c) movement of solutes from a greater to a lesser concentration of solutes d) movement of solutes from a lesser to a greater concentration of solutes e) two of the above

Question 26 (Multiple Choice Worth 1.6666 points) Ethan found a large old stump in the forest and was able to determine the age of the tree. What ma) Vascular cambium. b) Cork cambium. c) Secondary xylem. d) Secondary phloem. e) Pith.

Question 27 (Multiple Choice Worth 1.6666 points) Which of these cells contains the full complement of hereditary material for its species? a) egg b) sperm c) somatic cell d) muscle cell e) two of the above

Question 28 (Multiple Choice Worth 1.6666 points) Which of the following statements is not true of lichens? a) They are considered an example of mutualism b) They are able to invade the harshest habitats c) It is a symbiotic relationship between an algae and a fungus d) They exclusively reproduce by sexual reproduction e) two of the above

Question 29 (Multiple Choice Worth 1.6666 points) Which of the following is not a role of normal microbiota? a) They thwart pathogenic bacteria b) They secrete substances that destroy cells c) They prevent overgrowth of yeast d) They produce nutrients such as vitamin K

Question 30 (Multiple Choice Worth 1.6666 points) All the genetic information in one complete set of hereditary material is the: a) chromatin b) chromatids c) genome d) genotype e) phenotype

Question 31 (Multiple Choice Worth 1.6666 points) Which of these is not a difference between plant and animal cells? a) Plant cells have a rigid cell wall outside the plasma membrane. b) Plant cells lack vacuoles. c) Animal cells have no chloroplasts. d) Animal cells have only a plasma membrane surrounding the cell. e) none of the above

Question 32 (Multiple Choice Worth 1.6666 points) Abigail is a technician extracting DNA for analysis. In which of the following would she expect to find only a haploid number of chromosomes? a) Zygote. b) Spore. c) Sporophyte. d) Kidney cell. e) Skin cell.

Question 33 (Multiple Choice Worth 1.6666 points) When the heights of ten plants are added together and this total is divided by the number of plants (10), the result is the: a) percentage b) mean c) mode d) standard deviation e) a bell curve

Question 34 (Multiple Choice Worth 1.6666 points) Angel is a biologist studying a lake ecosystem in which leaf-eating insects are consumed by fish, which are consumed by snakes, which are consumed by hawks. In this example, how would you classify a fish? a) Producer. b) Decomposer. c) Primary consumer. d) Secondary consumer. e) Tertiary consumer.

Question 35 (Multiple Choice Worth 1.6666 points) June is developing new strains of horticultural plants, and she wants to check the chromosome numbers of her specimens. What would be the chromosome composition of the petal, pollen, and megaspore? a) Diploid, haploid, haploid. b) Diploid, haploid, diploid. c) Haploid, diploid, haploid. d) Haploid, haploid, diploid. e) Diploid, diploid, triploid.

Question 36 (Multiple Choice Worth 1.6666 points) Which statement best explains why it is possible to spread cancer the same as an infectious disease? a) Cancer cells reproduce like a virus b) Cancer cells are highly infectious c) Certain viruses cause cancer d) Viruses make cancer infectious e) hint: “e” is NOT the answer

Question 37 (Multiple Choice Worth 1.6666 points) Noah is a technician assigned to photograph chromosomes. At what stage of the cell cycle are the chromosomes sufficiently condensed that they FIRST become visible under the light microscope? a) Anaphase. b) Telophase. c) Interphase. d) Prophase. e) Metaphase.

Question 38 (Multiple Choice Worth 1.6666 points) The common mushroom found in foods produces sexual spores in structures with the following name: a) Basidia b) Zygotes c) Conidia d) Asci e) Portobello

Question 39 (Multiple Choice Worth 1.6666 points) If a scientist finds that her experimental data do not support her hypothesis or a particular scientific theory, she should: a) modify the hypothesis and perform another experiment b) give up on that hypothesis and find another area of science to research c) work to show that the scientific theory is incorrect d) both a and b e) both b and c

Question 40 (Multiple Choice Worth 1.6666 points) Fredrica examined a specimen of a new plant species and noticed that it had very few guard cells. What might this suggest? a) The plant was adapted to living under very wet conditions. b) The plant was not prone to insect attack. c) The plant would be lacking in companion cells. d) The plant would not require companion cells but may have them. e) The plant was adapted to drought conditions.

Question 41 (Multiple Choice Worth 1.6666 points) DNA is in the form of a ladder with rungs of equal length, although the rungs may vary in composition. What accounts for the equality of length? a) All rungs are attached to a phosphate. b) All rungs contain either pyrimidines or purines, which are equal in size. c) All rungs contain a small ribose and a large deoxyribose. d) All rungs contain a small pyrimidine and a large purine. e) All rungs are twisted into a helix.

Question 42 (Multiple Choice Worth 1.6666 points) Which statement is true of viruses? a) They all lack DNA b) They are obligate parasites c) They have a complex cytoplasm d) They have a cell wall like prokaryotes e) none of the above

Question 43 (Multiple Choice Worth 1.6666 points) If you examined a sample of sea water under a microscope you might observe tiny “shelled” organisms often used to add luster to fingernail polish or paint. What group would you be observing? a) Red Algae. b) Foraminifera. c) Dinoflagellates. d) Diatoms. e) Sporozoans.

Question 44 (Multiple Choice Worth 1.6666 points) If a DNA strand with the base sequence CAGCAT were to unzip and be replicated, what would be the base sequence of its OLD complementary strand and its NEW complementary strand? a) Old = CAGCAT, new = GTCGTA b) Old = GTCGTA, new = GTCGTA c) Old = TAGCAT, new = TAGCAT d) Old = ATGCTG, new = ATGCTG e) Old = CAGCAT, new = ATGCTG

Question 45 (Multiple Choice Worth 1.6666 points) Maryanne was studying an ecosystem containing fungi, grass, and deer. How would she classify fungi, grass, and deer? a) Producers, consumers, decomposers. b) Consumers, decomposers, producers. c) Decomposers, producers, consumers. d) Consumers, producers, decomposers. e) Producers, decomposers, consumers.

Question 46 (Multiple Choice Worth 1.6666 points) In the classification of living things, which list shows categories sequenced from least inclusive to most inclusive? a) Genus, species, phylum, kingdom, domain. b) Genus, species, phylum, domain kingdom. c) Species, genus, phylum, kingdom, domain. d) Species, genus. domain, kingdom, phylum. e) Species, genus, kingdom, domain, phylum.

Question 47 (Multiple Choice Worth 1.6666 points) Lori was studying the effects of magnesium of the growth rate of carrot crops. She measured the growth rate of a group of carrots given magnesium in comparison to the growth rate of a group of carrots not given magnesium, but otherwise grown under the same conditions. In this experiment, which is the control? a) The carrots given the magnesium. b) The same conditions of growing for both groups. c) The growth rate. d) The group not given magnesium. e) The magnesium.

Question 48 (Multiple Choice Worth 1.6666 points) Angelo was studying drinking water pollution. Which of the following would be an example of a category of quantitative data? a) Color. b) Smell. c) Taste. d) Presence or absence of bacteria. e) Temperature. Question 49 (Multiple Choice Worth 1.6666 points) In which of the following cases would you expect to find the narrowest base on an ecological pyramid of numbers? a) Grass>deer>mountain lions b) Algae>tadpoles>snakes. c) Elephants> ticks>bacteria. d) Whales>sharks>squid. e) Shrubs>moose>wolves.

Question 50 (Multiple Choice Worth 1.6666 points) In which section of a scientific paper would the data be shown? a) Introduction. b) Abstract. c) Discussion. d) Results. e) Methods.

Question 51 (Multiple Choice Worth 1.6666 points) In Lab 1 (Dependent and Independent Variables), which of the following is considered the dependent variable? a. The amount of corn produced in a field b. The level of ECB infestation c. The amount of nutrients obtained by each corn plant d. The type of corn planted

Question 52 (Multiple Choice Worth 1.6666 points) Which of the following is a bacterium that produces crystalline proteins which act as stomach poisons to select insects? a. European corn borer b. Bacillus thuringiensis c. Super Harvest seed variety d. BT123

Question 53 (Multiple Choice Worth 1.6666 points) Which type of tissue would have a higher mitotic index? a. cancerous ovarian tissue b. normal ovarian tissue c. both a and b d. neither a or b, the mitotic index cannot be calculated for ovarian tissue.

Question 54 (Multiple Choice Worth 1.6666 points) The mitotic index is defined as: a. the ratio between the number of cells at

Question 55 (Multiple Choice Worth 1.6666 points) The fan represents wind in the environment. How does it increase waterloss by all the plants in the study? a. Decrease in evaporation b. Increase in evaporation c. The Stomata are forced closed. d. Increased humidity

Question 56 (Multiple Choice Worth 1.6666 points) In your study which plant was most likely taken from a tropical rainforest? a. The zebra plant b. The coleus c. The rubber plant d. The arrowhead

Question 57 (Multiple Choice Worth 1.6666 points) Which of the following illustrates the correct ordering of trophic levels? a. Decomposers -> carnivores -> autotrophs -> herbivores b. Herbivores -> autotrophs -> carnivores -> decomposers c. Autotrophs -> herbivores -> carnivores -> decomposers d. Primary producers -> Primary Consumers -> Secondary Consumers

Question 58 (Multiple Choice Worth 1.6666 points) The ultimate source of energy for most ecosystems is: a. Carbon b. Oxygen c. Sunlight d. Water

Question 59 (Multiple Choice Worth 1.6666 points) Chemosynthesis is the process by which the organisms manufacture food using hydrogen sulfide, heavy metals and hot water (600 deg C). a. True b. False

Question 60 (Multiple Choice Worth 1.6666 points) Photosynthesis is a biochemical reaction which converts oxygen and carbohydrates to carbon dioxide and water. a. true b. false Bottom of Form 1

 
"Not answered?"
Get the Answer