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:

Limitations

Constraints or restrictions that affect the scope, validity, or generalizability of research findings.

Standard Deviation

A measure of the amount of variation or dispersion in a set of values, indicating how much the numbers in the dataset deviate from the mean average.

Variance

A measure of the dispersion, indicating how much the values in a dataset differ from the mean.

Measures of Variability

Statistical calculations that describe the distribution or spread of data points within a dataset, such as standard deviation, variance, and range.