Analytics Exam II

• Context

• Layout

• Action

• Style & tone

• Persona

What does CLASP stand for?

CLASP

Acronym which outlines what every AI prompt should contain

Zero-shot

A type of prompting which requests no examples

Few-shot

A type of prompting which requests 3-5 examples

Chain of thought

A type of prompting which asks AI to think through a concept step by step

Chain of verification

A type of prompting which asks the model to check its own draft

Tree of thought

A type of prompting which asks the model to explore several paths

ReAct

A type of prompting which asks the model to reason and act through a concept

1. Direct

2. Contextual

3. Reasoning

4. Verifying

5. Agentic

From least to most complex, list the levels of the prompting ladder

CO-STAR

Advanced architecture for building master prompts. Involves context, objective, style, tone, audience, and response

Extensible markup language (XML)

A prompting technique which stores and organizes data with labels, called tags, so different computer systems can read and exchange it and treats text as data instead of instructions

Precise, creative

A prompting temperature of 0 would be considered _________ and a temperature of 1.2+ would be considered _________

Lost in the middle

• Refers to a concept where AI model can get distracted by a long document and instructions together that it interprets the beginning and end well, but not the middle

• Can be fixed by tagging sections and having a closing line

Chain of verification (COV)

A prompting technique which involves generating an initial response, generating verification questions about it, answering those independently, and making a final, verified response → subject to hallucinations

Rephrase and respond

A prompting technique which rewrites your prompt into a better version and answers that version, not yours, like a consultant refining the brief

Simplex LP

Solves linear problems

GRG nonlinear

Solves along smooth curves

Evolutionary

Solves irregular, non-smooth problems

(lookup value, lookup array, return array, if not found, match mode, search mode)

What format is XLOOKUP?

Exact match

What does a match mode of 0 mean in an XLOOKUP?

Exact match or next smaller

What does a match mode of -1 mean in an XLOOKUP?

Exact match or next larger

What does a match mode of 1 mean in an XLOOKUP?

Wildcard match

What does a match mode of 2 mean in an XLOOKUP?

Search first to last

What does a search mode of 1 mean in an XLOOKUP?

(lookup value, table array, column index, range lookup)

What is the formula structure for VLOOKUP?

(lookup value, table array, row index, range lookup)

What is the formula structure for HLOOKUP?

Exact match

What is the default match mode for XLOOKUP?