6.3.3 Test Using Spreadsheets And Databases ((link)) Jun 2026

Testing a database (such as Microsoft Access or SQL) involves verifying that the Relational Database Management System (RDBMS) enforces the rules set by the developer.

To move beyond a passing grade to a mastery level, here are advanced skills that frequently appear in the higher bands of the rubric.

"Calculate the total sales for each salesperson in Q1 2024, but only include orders above $500."

A challenging section of the test may provide a flat spreadsheet and ask: "Normalize this data to 3rd Normal Form (3NF) in a database." 6.3.3 test using spreadsheets and databases

This article explores the nuances of the 6.3.3 test, detailing the methodologies used in spreadsheets and databases, the differences between the two approaches, and why mastering this skill is essential for modern data integrity.

Combine order data and customer data without VLOOKUP: =FILTER(Orders, COUNTIF(CustomerList[ID], Orders[CustomerID]))

When copying formulas, ensure that absolute references ($) point to the correct static cells and do not shift. Using Test Data Testing a database (such as Microsoft Access or

It started as a whisper in the raw data stream. A single sensor buoy in the mid-Atlantic reported a salinity drop that defied all physical models. Not a slow decline, but a sudden, 0.4% cliff dive over six hours. Then another buoy. Then a satellite altimeter showing impossible sea-level rise localized to a 50-kilometer patch of empty ocean.

Inputting extremely high, low, or unexpected data types into cells to see if the sheet breaks or returns errors. Data Integrity:

Test that data validation prevents entries that are too long or outside a specific numeric range. Combine order data and customer data without VLOOKUP:

The "test" in this context is not merely a software launch; it is a structured process of verification. Students and professionals are required to design test plans, create test data, execute tests, and document the results. The dual requirement of using both and databases highlights the need to understand how different data structures handle logic and verification.

Checking that sorting or filtering data doesn't "de-couple" rows (e.g., Column A stays sorted but Column B doesn't move with it). Security & Protection: