# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 265083224

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Define group/aggregate functions.

Definition

Definition should include that group functions are commands that operate on sets of rows to give one result per group and include
  • AVG
  • COUNT
  • MAX
  • MIN
  • STDDEV
  • SUM
  • VARIANCE.

Related Standards of Learning

English

10.2

The student will examine, analyze, and produce media messages.
  1. Create media messages for diverse audiences.
  2. Credit information sources.
  3. Evaluate sources for relationships between intent, factual content, and opinion.
  4. Analyze the impact of selected media formats on meaning.
  5. Analyze the purpose of information and persuasive techniques used in diverse media formats.
  6. Evaluate the motives (e.g., social, commercial, political) behind media presentation(s).
  7. Describe possible cause and effect relationships between mass media coverage and public opinion trends.
  8. Monitor, analyze, and use multiple streams of simultaneous information.
  9. Demonstrate ethical use of the Internet when evaluating or producing creative or informational media messages.

10.5

The student will read, interpret, analyze, and evaluate nonfiction texts.
  1. Analyze text features and organizational patterns to evaluate the meaning of texts.
  2. Recognize an author’s intended audience and purpose for writing.
  3. Skim materials to develop an overview and locate information.
  4. Compare and contrast informational texts for intent and content.
  5. Interpret and use data and information in maps, charts, graphs, timelines, tables, and diagrams.
  6. Draw conclusions and make inferences on explicit and implied information using textual support as evidence.
  7. Analyze and synthesize information in order to solve problems, answer questions, and generate new knowledge.
  8. Analyze ideas within and between selections providing textual evidence.
  9. Summarize, paraphrase, and synthesize ideas, while maintaining meaning and a logical sequence of events, within and between texts.
  10. Use reading strategies throughout the reading process to monitor comprehension.

11.2

The student will examine how values and points of view are included or excluded and how media influences beliefs and behaviors.
  1. Describe possible cause and effect relationships between mass media coverage and public opinion trends.
  2. Create media messages with a specific point of view.
  3. Evaluate media sources for relationships between intent and content.
  4. Analyze the impact of selected media formats on meaning.
  5. Determine the author’s purpose and intended effect on the audience for media messages.
  6. Manage, analyze, and synthesize multiple streams of simultaneous information.
  7. Demonstrate ethical use of the Internet when evaluating or producing creative or informational media messages.

11.5

The student will read, interpret, analyze, and evaluate a variety of nonfiction texts including employment documents and technical writing.
  1. Apply information from texts to clarify understanding of concepts.
  2. Read and correctly interpret an application for employment, workplace documents, or an application for college admission.
  3. Analyze technical writing for clarity.
  4. Paraphrase and synthesize ideas within and between texts.
  5. Draw conclusions and make inferences on explicit and implied information using textual support.
  6. Analyze multiple texts addressing the same topic to determine how authors reach similar or different conclusions.
  7. Analyze false premises, claims, counterclaims, and other evidence in persuasive writing.
  8. Recognize and analyze use of ambiguity, contradiction, paradox, irony, sarcasm, overstatement, and understatement in text.
  9. Generate and respond logically to literal, inferential, evaluative, synthesizing, and critical thinking questions about the text(s).

Other Related Standards

Microsoft Imagine Academy Resources

[3.158] SQL Server 2008 Release 2: Grouping and Summarizing Data in Microsoft SQL Server 2008—E-Learning Module 2

[5.037] Access 2010: Project 5