Data Architecture
This type of key uniquely identifies each record in a database table.
What is a Primary Key?
This quality process focuses on defect prevention, process design, and audits to stop bugs before they happen.
What is Quality Assurance?
To make sure different features are on the same scale for analysis, a data scientist might perform this, which involves shifting and scaling the data to have a mean of 0 and a standard deviation of 1.
What is standardization (or normalization)?
These are visual tools used to track, analyze, and display multiple Key Performance Indicators (KPIs) and metrics in a single, centralized screen.
What is a Dashboard?
This is the main piece of legislation guiding public education in British Columbia.
What is the School Act?
This type of database structure organizes data into tables connected by relationships.
What is a relational database?
This quality process focuses on identifying defects in the final product through active testing and bug reporting.
What is Quality Control?
This bell-shaped curve is defined entirely by its mean and standard deviation, and is the cornerstone of the central limit theorem.
What is the normal distribution?
This type of plot maps two continuous variables on an X and Y axis to reveal relationships, clusters, or correlations.
What is a scatter plot?
This is the full name of the certificate issued upon completion of the provincial graduation requirements.
What is the British Columbia Certificate of Graduation?
This term describes the ability to trace data continuously from its point of origin all the way to downstream reports and dashboards.
What is Data Lineage?
The data characteristic that ensures information matches the source and is 100% free from systemic or typographical errors.
What is accuracy?
It is the square root of the variance and tells you how far your data points generally deviate from the mean.
What is the standard deviation?
This foundational language in Power BI uses formulas and expressions for advanced calculations, row-level security, and dynamic metrics.
What is DAX (Data Analysis Expressions)?
The is the framework replaced traditional letter grades in K-9.
What is the Provincial Proficiency Scale?
This data architecture organizes data into layered stages—typically Bronze, Silver, and Gold— as it moves from raw to report ready.
What is Medallion Architecture?
This standard of data quality ensures that no necessary information or fields are missing from a record.
What is completeness?
This statistical test calculates the discrepancy between observed and expected frequencies.
What is the chi-squared test?
This chart type summarizes the distribution of numerical data through their quartiles, median, and whiskers.
What is a boxplot?
BC students learn about the histories and impacts of these institutions on Indigenous peoples.
What are Residential Schools?
This type of data warehouse schema, also known as a fact constellation, features multiple fact tables that share common dimension tables.
What is a galaxy schema?
The comprehensive term for the processes, roles, and policies that dictate how an enterprise secures and manages its data assets to maintain quality.
What is Data Governance?
This iterative technique is used to minimize the cost or loss function of a neural network by taking proportional steps in the opposite direction of the gradient.
This type of categorical field is used for slicing, dicing, and grouping your data in BI tools.
What is a dimension?
This declaration recognizes the rights of Indigenous peoples and helps guide educational policies in BC.
What is Declaration on the Rights of Indigenous Peoples Act (DRIPA)?