Dan Is Manipulating Data in a Table Containing Records on Computer

question 93

Multiple Choice

Dan is manipulating data in a table containing records on computer equipment purchases for the past year. Each record in the table contains the date purchased, the type of computer equipment, the vendor’s name, the cost of the equipment, and the department in which the equipment is installed. The records were originally entered in order by month of purchase. Dan sends you an e-mail asking how he can rearrange the table’s records to see all the purchases from each vendor in date order within each department. He also wants to know a quick way to get the data back into its original order, whenever necessary.
-As a quick way to get all the records back into their original order,when necessary,you suggest that before he begins to rearrange the records,Dan should _____.

• A) sort first on the department field and then the date purchased field
• B) create a duplicate worksheet with the records in their original order as a backup before sorting them in a different order
• C) insert a column (field)and use the fill handle to add sequential record numbers in the column; then sort the record numbers in ascending sequence to rearrange the records in their original order whenever necessary
• D) sort first on the computer type field and then on the date purchased field

---

Definitions:

Content Validity

A measure of how well test items represent the domain they're intended to assess, ensuring the test is comprehensive and relevant.

Face Validity

Superficial observation that a test appears to cover the correct content or domain. This is not an actual form of validity since the appearance of test items may or may not accurately reflect the domain.

Pilot Study

A small-scale preliminary study conducted to evaluate feasibility, time, cost, risk, and adverse events, used to improve the design of a future full-scale research project.

Cross-Cultural Fairness

In assessment or testing, the principle of ensuring that tools and practices are equitable and do not favor one cultural group over others.