Business Tech Midterm

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/83

encourage image

There's no tags or description

Looks like no tags are added yet.

84 Terms

1
New cards

Course Concept - Information Systems Definition

The combination of human context (inequality, bias, unintended consequences) and technology to manage/analyze data and facilitate decision-making.

2
New cards

Course Concept - Resource-Based View (RBV)

A framework stating that sustainable competitive advantage requires resources that are Valuable, Rare, Hard to Copy, and Non-Substitutable (VRIN).

3
New cards

Course Concept - RBV applied to AI

An AI model alone scores 1/4 on RBV (valuable, but not rare, hard to copy, or non-substitutable); it acts as a commodity cost rather than a strategic moat.

4
New cards

Course Concept - The Four Shields (Customer Retention)

1. Brand (direct recognition), 2. Scale (cost advantages from size), 3. Switching Costs (pain of leaving ecosystem), 4. Network Effects (value grows with users).

5
New cards

Course Concept - Gartner's Hype Cycle Stages

1. Emerging Innovation, 2. Inflated Expectations, 3. Trough of Disillusionment, 4. Slope of Enlightenment, 5. Plateau of Productivity.

6
New cards

Course Concept - Digital Platforms (Chapter 15)

Systems that facilitate many-to-many (M2M) interactions between suppliers and demanders.

7
New cards

Course Concept - SaaS Disruption by AI

AI coding tools and plugins disrupt traditional SaaS value propositions by converting software capabilities into easily reproducible files.

8
New cards

Course Concept - Crowdsourcing (Chapter 16)

Leveraging connected online groups for ideas, information, or work (e.g., GitHub, Stack Overflow, Hugging Face).

9
New cards

Course Concept - Open Source Software (OSS)

Software with freely accessible code driven by cost benefits, reliability, security, standard-setting, and talent attraction.

10
New cards

Excel Basics - Text vs. Number Data Types

Numbers stored as text are left-aligned with a green triangle in the top-left corner; they must be converted to numeric format for math operations.

11
New cards

Excel Basics - Boolean Comparisons

Logical tests using operators (>,

12
New cards

Excel Basics - Cross-Sheet Referencing Syntax

Syntax required to reference cells on another worksheet: 'SheetName'!Cell (e.g., 'Data_Input'!B5).

13
New cards

Excel Lookup - VLOOKUP Syntax

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

14
New cards

Excel Lookup - VLOOKUP Exact vs. Approximate Match

Use FALSE or 0 for an exact key match; use TRUE or 1 for approximate/range matches (e.g., grading scales or tax bands).

15
New cards

Excel Lookup - XLOOKUP Syntax

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

16
New cards

Excel Lookup - XLOOKUP Advantages over VLOOKUP

Requires only 3 primary arguments, can look left or right, doesn't break when columns are inserted, and has built-in error handling via if_not_found.

17
New cards

Excel Logic - IF Function Syntax

=IF(logical_test, value_if_true, value_if_false)

18
New cards

Excel Logic - Nested IF Functions

Placing an IF function inside another IF statement to handle 3 or more potential outcomes.

19
New cards

Excel Statistical - SUMIFS / AVERAGEIFS Argument Order

Sum or Average range is ALWAYS the first argument, followed by criteria range and criteria pairs: =SUMIFS(sum_range, criteria_range1, criteria1, ...)

20
New cards

Excel Statistical - COUNTIFS Syntax

=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)

21
New cards

Excel Dynamic Arrays - FILTER Function Syntax

=FILTER(array, include, [if_empty]) - Extracts rows/columns meeting logical criteria and spills results into adjacent cells.

22
New cards

Excel Dynamic Arrays - UNIQUE Function Syntax

=UNIQUE(array, [by_col], [exactly_once]) - Returns a list of distinct values from a range or array.

23
New cards

Excel Dynamic Arrays - Counting Unique Values

Combine COUNTA and UNIQUE to count total distinct entries: =COUNTA(UNIQUE(range))

24
New cards

Excel Errors - #N/A Error Meaning

Value Not Available; occurs when a lookup function cannot find the specified lookup_value in the search array.

25
New cards

Excel Errors - #SPILL! Error Meaning

Spill Range Blocked; occurs when a dynamic array formula (like FILTER or UNIQUE) is blocked by existing cell content in the output range.

26
New cards

Excel Errors - #CALC! Error Meaning

Calculation Error; occurs when an array formula or FILTER function returns an empty set or cannot evaluate the criteria.

27
New cards

Excel Errors - IFERROR Syntax

=IFERROR(value, value_if_error) - Traps and replaces Excel error codes with clean custom text or calculations.

28
New cards

Excel Modeling - Absolute vs Relative Cell References

Relative references (A1) adjust when copied; Absolute references ($A$1) lock the column and row using dollar signs ($).

29
New cards

Excel Modeling - Formatting Best Practices

Keep inputs, calculations, and outputs clearly formatted; format raw numbers into currency ($), percentages (%), or integers for readability.

30
New cards

Course Policy - Late Work Penalty

Late assignments incur a 25% score deduction within 24 hours and a 50% deduction within 48 hours.

31
New cards

Course Policy - Revision Tokens

Students receive 4 revision tokens per semester to adjust or redo scores below 80% on Excel Labs and Knowledge Checks.

32
New cards

Course - Information Systems Definition

The combination of human context (inequality, bias, unintended consequences) and technology to manage/analyze data and facilitate decision-making.

33
New cards

Course - Resource-Based View (RBV)

A strategic framework stating that a sustainable competitive advantage requires resources that are Valuable, Rare, Hard to Copy, and Non-Substitutable (VRIN).

34
New cards

Course - RBV Applied to AI

An AI model alone scores 1/4 on RBV (valuable, but not rare or hard to copy); it acts as an operational cost rather than a strategic moat.

35
New cards

Course - The Four Shields (Customer Retention)

1. Brand (direct recognition), 2. Scale (cost advantages from size), 3. Switching Costs (pain of leaving ecosystem), 4. Network Effects (value grows with users).

36
New cards

Course - Gartner's Hype Cycle Stages

1. Emerging Innovation, 2. Inflated Expectations, 3. Trough of Disillusionment, 4. Slope of Enlightenment, 5. Plateau of Productivity.

37
New cards

Course - Digital Platforms (Chapter 15)

Systems that facilitate many-to-many (M2M) interactions between suppliers and demanders.

38
New cards

Course - SaaS Disruption by AI

AI code/plugins disrupt traditional SaaS value propositions by turning software tools into easily reproducible files.

39
New cards

Course - Crowdsourcing (Chapter 16)

Leveraging connected online groups for ideas, information, or work (e.g., GitHub, Stack Overflow, Hugging Face).

40
New cards

Course - Open Source Software (OSS)

Software with freely accessible code driven by cost benefits, reliability, security, standard-setting, and talent attraction.

41
New cards

Chapter 1.1 - Business Definition

An entity that seeks to earn a profit by providing goods or services to others.

42
New cards

Chapter 1.1 - Goods vs. Services

Goods are tangible products (cars, food); services are intangible activities (education, banking, healthcare).

43
New cards

Chapter 1.1 - Revenue vs. Profit vs. Loss

Revenue is total money taken in; Profit is earnings above expenses; Loss occurs when expenses exceed revenues.

44
New cards

Chapter 1.1 - Standard of Living vs. Quality of Life

Standard of living is the amount of goods/services money can buy; Quality of life is general societal well-being (freedom, safety, environment).

45
New cards

Chapter 1.1 - Stakeholders

All the people who stand to gain or lose by the policies and activities of a business.

46
New cards

Chapter 1.2 - Factors of Production

The resources used to create wealth: Land, Labor, Capital, Entrepreneurship, and Knowledge (Entrepreneurship + Knowledge are key today).

47
New cards

Chapter 1.2 - Business Environment Components

Economic, Competitive, Social (demographics), and Technological environments that help or hinder business growth.

48
New cards

Chapter 2.1 - Micro vs. Macroeconomics

Macroeconomics looks at a nation's economy as a whole; Microeconomics looks at behavior of people/markets.

49
New cards

Chapter 2.1 - Invisible Hand Theory

Adam Smith's concept that self-directed gain turns into social and economic benefits for all.

50
New cards

Chapter 2.2 - Four Basic Rights of Capitalism

1. Right to private property, 2. Right to keep profits, 3. Right to open competition, 4. Right to freedom of choice.

51
New cards

Chapter 2.2 - Degrees of Competition

Perfect Competition (many sellers, identical products), Monopolistic Competition (many sellers, differentiated products), Oligopoly (few sellers dominate), Monopoly (one seller).

52
New cards

Chapter 2.3 - Free-Market vs. Command Economies

Free-market economies let market forces decide production; Command economies have governments decide (Socialism/Communism).

53
New cards

Chapter 2.4 - Economic Indicators (GDP, CPI, PPI)

GDP = total value of final goods/services; CPI = measures consumer inflation; PPI = measures wholesale inflation.

54
New cards

Chapter 2.4 - Types of Unemployment

Frictional (job switching/new entrants), Structural (skills mismatch/firm restructuring), Cyclical (recession-driven).

55
New cards

Chapter 2.4 - Fiscal vs. Monetary Policy

Fiscal Policy = government taxes and spending; Monetary Policy = Federal Reserve management of money supply and interest rates.

56
New cards

Chapter 3.1 - Comparative vs. Absolute Advantage

Comparative = producing a good most efficiently relative to others; Absolute = virtual monopoly or producing more efficiently than all others.

57
New cards

Chapter 3.2 - Trade Balance Terms

Trade Surplus (Exports > Imports); Trade Deficit (Imports > Exports); Balance of Payments (total money flow in vs. out).

58
New cards

Chapter 3.3 - Global Market Entry Strategies

From lowest to highest risk/investment: Exporting -> Licensing -> Franchising -> Contract Manufacturing -> Joint Venture -> Foreign Direct Investment (FDI).

59
New cards

Chapter 3.5 - Trade Protectionism Tools

Tariffs (taxes on imports), Import Quotas (quantity limits), Embargoes (complete trade bans).

60
New cards

Chapter 4.1 - Compliance vs. Integrity Ethics Codes

Compliance-based emphasizes preventing unlawful behavior through control/penalties; Integrity-based stresses shared values, accountability, and ethical culture.

61
New cards

Chapter 4.2 - Corporate Social Responsibility (CSR)

A business's concern for societal welfare, spanning Corporate Philanthropy, Social Initiatives, Responsibility, and Policy.

62
New cards

Excel Data - Text vs. Numeric Formatting

Numbers stored as text align left with a green corner triangle and cannot perform math; numeric data aligns right.

63
New cards

Excel Data - Absolute ($A$1) vs. Relative (A1) References

Relative references shift when copied across cells; Absolute references ($) lock the column and/or row in place during copying.

64
New cards

Excel Data - Syntax for Cross-Sheet Referencing

'SheetName'!CellAddress (e.g., 'Summary_Data'!B10).

65
New cards

Excel Formula - VLOOKUP Function

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) - Searches the first column of a table and returns a value in the same row.

66
New cards

Excel Formula - VLOOKUP Match Types

Range_lookup = FALSE (or 0) for exact key match; Range_lookup = TRUE (or 1) for approximate range lookup (e.g., tax/grade bands).

67
New cards

Excel Formula - XLOOKUP Function

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found]) - Modern lookup that works left or right and handles missing values cleanly.

68
New cards

Excel Formula - IF Function Logic

=IF(logical_test, value_if_true, value_if_false) - Evaluates a condition and returns one value if true, another if false.

69
New cards

Excel Formula - Nested IF Statements

Placing IF statements inside one another (=IF(cond1, val1, IF(cond2, val2, val3))) to evaluate 3 or more conditions.

70
New cards

Excel Formula - SUMIFS / AVERAGEIFS Syntax

=SUMIFS(sum_range, criteria_range1, criteria1, ...) - Sums cells meeting multiple criteria. Note: sum_range is ALWAYS first.

71
New cards

Excel Formula - COUNTIFS Syntax

=COUNTIFS(criteria_range1, criteria1, ...) - Counts the number of cells that meet one or more specified conditions.

72
New cards

Excel Formula - FILTER Function

=FILTER(array, include, [if_empty]) - Dynamic array tool that returns rows/columns matching logical criteria and spills results.

73
New cards

Excel Formula - UNIQUE Function

=UNIQUE(array) - Returns a list of distinct values from a range; combine as =COUNTA(UNIQUE(range)) to count unique items.

74
New cards

Excel Formula - IFERROR Function

=IFERROR(value, value_if_error) - Traps Excel errors (#N/A, #VALUE!) and replaces them with clean text or alternative math.

75
New cards

Excel Errors - #N/A Error

"Value Not Available" — Occurs when a lookup function cannot find the lookup_value in the reference table.

76
New cards

Excel Errors - #SPILL! Error

"Spill Range Blocked" — Occurs when an array formula (like FILTER/UNIQUE) is blocked by text/data in adjacent output cells.

77
New cards

Excel Errors - #CALC! Error

"Calculation Error" — Occurs when an array formula fails to evaluate or FILTER finds no matching criteria.

78
New cards

Excel Tables - Structured Excel Table vs. Cell Range

Excel Tables (Ctrl+T) auto-expand formulas, use structured header references (e.g., Table1[Revenue]), and offer dynamic filtering/total rows.

79
New cards

Excel Charts - Clustered Column vs. Stacked Column Chart

Clustered compares individual values side-by-side across categories; Stacked shows total category size while breaking down sub-component proportions.

80
New cards

Excel Charts - Line Chart vs. Scatter Plot

Line Charts plot data evenly across categorical time intervals; Scatter Plots plot numeric X and Y coordinates to reveal correlations.

81
New cards

Excel Charts - Pie Chart Usage Rules

Best used ONLY to show proportions of a single whole (100% total); avoid using for dynamic time trends or when categories exceed 5-7 slices.

82
New cards

Excel Tables - PivotTable Functionality

An interactive tool used to summarize, sort, group, aggregate (SUM/COUNT/AVERAGE), and cross-tabulate large datasets without formulas.

83
New cards

Course Policy - Late Work Penalty (Rules)

25% score deduction within 24 hours late; 50% deduction within 48 hours late.

84
New cards

Course Policy - Revision Tokens (Rules)

Students get 4 tokens per semester to revise/redo Excel Labs or Knowledge Checks scoring below 80%.