What does filtering do?
Filtering displays only rows that satisfy specified conditions while leaving the underlying values unchanged when used as a view or query.
Study 6. Filtering and Exploring Data with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.
What does filtering do?
Filtering displays only rows that satisfy specified conditions while leaving the underlying values unchanged when used as a view or query.
In a data table, what do rows and columns represent?
Rows represent observations, while columns represent variables such as date, region, product, quantity, or price.
What is sorting?
Sorting rearranges rows according to one or more columns, such as alphabetically, numerically, chronologically, or by custom categories.
What does grouping do?
Grouping combines records that share a category or interval so they can be compared or summarized.
How does grouping differ from sorting?
Grouping creates categories for comparison, whereas sorting only places records in an order.
What is an aggregation?
An aggregation reduces many values to a summary value, such as a count, sum, average, median, minimum, or maximum.
What formula calculates order revenue?
Revenue equals Units × Unit Price. In the example, the three orders generate $48, $40, and $36.
How is weighted average price calculated?
Weighted average price equals total revenue divided by total units, giving each unit the appropriate influence.
Which chart examines change over time?
A line chart is appropriate for examining change over time.
Which chart examines two numeric variables?
A scatter plot examines the relationship between two numeric variables.
What should be done with raw data first?
Preserve an unchanged copy of the original file before transforming or analyzing the data.
What should be documented after applying a filter?
Record the exact filtering rule and the number of rows remaining after filtering.
A medium-difficulty assessment of programming fundamentals, algorithmic problem solving, control flow, data structures, testing, debugging, complexity, and decidability. Questions progress from foundational understanding to applied reasoning.
A practical review of the integrated Java skills, debugging habits, algorithm reasoning, and free-response strategies needed for AP Computer Science A.
A progressive guide to designing, operating, and testing systems that continue useful service despite component faults, overload, data loss, and recovery challenges.
A medium-difficulty quiz on how independently operated networks, protocols, addresses, naming systems, transport services, and routing mechanisms work together to form the Internet.
Learn how to create, modify, traverse, and analyze Java lists with ArrayList, wrapper types, standard algorithms, and the Collections utility class for AP Computer Science A.
Build a clear understanding of Java Boolean expressions, logical operators, selection statements, nested branching, equivalent logic, and systematic code tracing for AP Computer Science A.
A practical introduction to Java program structure, data types, operators, input and output, problem-solving strategy, testing, and debugging for AP Computer Science A.
A practical guide to Java inheritance, constructor chaining, method overriding, polymorphism, access control, and object behavior for tracing and writing AP Computer Science A programs.
A focused guide to Java classes, object references, constructors, methods, strings, wrapper classes, and API usage for AP Computer Science A.
A focused guide to Java primitive types, expression evaluation, numeric conversion, floating-point behavior, integer overflow, and common methods in the Math class for AP Computer Science A.
A focused review of Java primitive types, expression evaluation, numeric conversion, arithmetic behavior, Math methods, randomness, and tracing techniques for AP Computer Science A.
A progressive guide to how packet-switched networks encapsulate data, move it across links, and manage delay, throughput, queues, and congestion.