Case Based Critical Thinking Questions

question 8

Multiple Choice

Case Based Critical Thinking Questions
The Washington County Public School System has created a database that tracks student performance in all grade levels based on assessments administered every marking period. Administrators and teachers in the school system have access to a secure Intranet for quick access to the school system's policies, forms, curriculum standards, and other information.  Zack and Cayla are college interns for the school system, and they have been asked to use the Access database and information gathered from the individual schools to share the assessment data for the first three marking periods of the school year.  Answer the following questions using your knowledge of Access tools for sharing and integrating data.
-Zach has been given an Excel spreadsheet with each school's asssessment information and needs to integrate that data into the existing Access database. He would like to import each Excel worksheet as a separate table into the database.  What is the best option for Zach to use to create a file from the Excel data that can be imported into Access?

• A)save the Excel workbook as a PDF file
• B)export the Excel data for each school as a CSV file
• C)export the Excel data for each school to an XSL file
• D)save the Excel worksheet as an HTML document

---

Definitions:

Selective Reduction

A medical procedure used in multiple pregnancies to reduce the number of fetuses to a number safer for both the mother and the remaining fetuses.

Fertility Drugs

Medications that stimulate egg production and are used to treat infertility in women aiming to assist in conceiving.

Fetuses

A developing human from roughly eight weeks after conception until the time of birth.

Merchandise Inventory

Goods and products a company holds for the purpose of resale in the ordinary course of business.