1/83
Looks like no tags are added yet.
Course Concept - Information Systems Definition
The combination of human context (inequality, bias, unintended consequences) and technology to manage/analyze data and facilitate decision-making.
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).
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.
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).
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.
Course Concept - Digital Platforms (Chapter 15)
Systems that facilitate many-to-many (M2M) interactions between suppliers and demanders.
Course Concept - SaaS Disruption by AI
AI coding tools and plugins disrupt traditional SaaS value propositions by converting software capabilities into easily reproducible files.
Course Concept - Crowdsourcing (Chapter 16)
Leveraging connected online groups for ideas, information, or work (e.g., GitHub, Stack Overflow, Hugging Face).
Course Concept - Open Source Software (OSS)
Software with freely accessible code driven by cost benefits, reliability, security, standard-setting, and talent attraction.
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.
Excel Basics - Boolean Comparisons
Logical tests using operators (>,
Excel Basics - Cross-Sheet Referencing Syntax
Syntax required to reference cells on another worksheet: 'SheetName'!Cell (e.g., 'Data_Input'!B5).
Excel Lookup - VLOOKUP Syntax
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
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).
Excel Lookup - XLOOKUP Syntax
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
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.
Excel Logic - IF Function Syntax
=IF(logical_test, value_if_true, value_if_false)
Excel Logic - Nested IF Functions
Placing an IF function inside another IF statement to handle 3 or more potential outcomes.
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, ...)
Excel Statistical - COUNTIFS Syntax
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Excel Dynamic Arrays - FILTER Function Syntax
=FILTER(array, include, [if_empty]) - Extracts rows/columns meeting logical criteria and spills results into adjacent cells.
Excel Dynamic Arrays - UNIQUE Function Syntax
=UNIQUE(array, [by_col], [exactly_once]) - Returns a list of distinct values from a range or array.
Excel Dynamic Arrays - Counting Unique Values
Combine COUNTA and UNIQUE to count total distinct entries: =COUNTA(UNIQUE(range))
Excel Errors - #N/A Error Meaning
Value Not Available; occurs when a lookup function cannot find the specified lookup_value in the search array.
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.
Excel Errors - #CALC! Error Meaning
Calculation Error; occurs when an array formula or FILTER function returns an empty set or cannot evaluate the criteria.
Excel Errors - IFERROR Syntax
=IFERROR(value, value_if_error) - Traps and replaces Excel error codes with clean custom text or calculations.
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 ($).
Excel Modeling - Formatting Best Practices
Keep inputs, calculations, and outputs clearly formatted; format raw numbers into currency ($), percentages (%), or integers for readability.
Course Policy - Late Work Penalty
Late assignments incur a 25% score deduction within 24 hours and a 50% deduction within 48 hours.
Course Policy - Revision Tokens
Students receive 4 revision tokens per semester to adjust or redo scores below 80% on Excel Labs and Knowledge Checks.
Course - Information Systems Definition
The combination of human context (inequality, bias, unintended consequences) and technology to manage/analyze data and facilitate decision-making.
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).
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.
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).
Course - Gartner's Hype Cycle Stages
1. Emerging Innovation, 2. Inflated Expectations, 3. Trough of Disillusionment, 4. Slope of Enlightenment, 5. Plateau of Productivity.
Course - Digital Platforms (Chapter 15)
Systems that facilitate many-to-many (M2M) interactions between suppliers and demanders.
Course - SaaS Disruption by AI
AI code/plugins disrupt traditional SaaS value propositions by turning software tools into easily reproducible files.
Course - Crowdsourcing (Chapter 16)
Leveraging connected online groups for ideas, information, or work (e.g., GitHub, Stack Overflow, Hugging Face).
Course - Open Source Software (OSS)
Software with freely accessible code driven by cost benefits, reliability, security, standard-setting, and talent attraction.
Chapter 1.1 - Business Definition
An entity that seeks to earn a profit by providing goods or services to others.
Chapter 1.1 - Goods vs. Services
Goods are tangible products (cars, food); services are intangible activities (education, banking, healthcare).
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.
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).
Chapter 1.1 - Stakeholders
All the people who stand to gain or lose by the policies and activities of a business.
Chapter 1.2 - Factors of Production
The resources used to create wealth: Land, Labor, Capital, Entrepreneurship, and Knowledge (Entrepreneurship + Knowledge are key today).
Chapter 1.2 - Business Environment Components
Economic, Competitive, Social (demographics), and Technological environments that help or hinder business growth.
Chapter 2.1 - Micro vs. Macroeconomics
Macroeconomics looks at a nation's economy as a whole; Microeconomics looks at behavior of people/markets.
Chapter 2.1 - Invisible Hand Theory
Adam Smith's concept that self-directed gain turns into social and economic benefits for all.
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.
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).
Chapter 2.3 - Free-Market vs. Command Economies
Free-market economies let market forces decide production; Command economies have governments decide (Socialism/Communism).
Chapter 2.4 - Economic Indicators (GDP, CPI, PPI)
GDP = total value of final goods/services; CPI = measures consumer inflation; PPI = measures wholesale inflation.
Chapter 2.4 - Types of Unemployment
Frictional (job switching/new entrants), Structural (skills mismatch/firm restructuring), Cyclical (recession-driven).
Chapter 2.4 - Fiscal vs. Monetary Policy
Fiscal Policy = government taxes and spending; Monetary Policy = Federal Reserve management of money supply and interest rates.
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.
Chapter 3.2 - Trade Balance Terms
Trade Surplus (Exports > Imports); Trade Deficit (Imports > Exports); Balance of Payments (total money flow in vs. out).
Chapter 3.3 - Global Market Entry Strategies
From lowest to highest risk/investment: Exporting -> Licensing -> Franchising -> Contract Manufacturing -> Joint Venture -> Foreign Direct Investment (FDI).
Chapter 3.5 - Trade Protectionism Tools
Tariffs (taxes on imports), Import Quotas (quantity limits), Embargoes (complete trade bans).
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.
Chapter 4.2 - Corporate Social Responsibility (CSR)
A business's concern for societal welfare, spanning Corporate Philanthropy, Social Initiatives, Responsibility, and Policy.
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.
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.
Excel Data - Syntax for Cross-Sheet Referencing
'SheetName'!CellAddress (e.g., 'Summary_Data'!B10).
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.
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).
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.
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.
Excel Formula - Nested IF Statements
Placing IF statements inside one another (=IF(cond1, val1, IF(cond2, val2, val3))) to evaluate 3 or more conditions.
Excel Formula - SUMIFS / AVERAGEIFS Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, ...) - Sums cells meeting multiple criteria. Note: sum_range is ALWAYS first.
Excel Formula - COUNTIFS Syntax
=COUNTIFS(criteria_range1, criteria1, ...) - Counts the number of cells that meet one or more specified conditions.
Excel Formula - FILTER Function
=FILTER(array, include, [if_empty]) - Dynamic array tool that returns rows/columns matching logical criteria and spills results.
Excel Formula - UNIQUE Function
=UNIQUE(array) - Returns a list of distinct values from a range; combine as =COUNTA(UNIQUE(range)) to count unique items.
Excel Formula - IFERROR Function
=IFERROR(value, value_if_error) - Traps Excel errors (#N/A, #VALUE!) and replaces them with clean text or alternative math.
Excel Errors - #N/A Error
"Value Not Available" — Occurs when a lookup function cannot find the lookup_value in the reference table.
Excel Errors - #SPILL! Error
"Spill Range Blocked" — Occurs when an array formula (like FILTER/UNIQUE) is blocked by text/data in adjacent output cells.
Excel Errors - #CALC! Error
"Calculation Error" — Occurs when an array formula fails to evaluate or FILTER finds no matching criteria.
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.
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.
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.
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.
Excel Tables - PivotTable Functionality
An interactive tool used to summarize, sort, group, aggregate (SUM/COUNT/AVERAGE), and cross-tabulate large datasets without formulas.
Course Policy - Late Work Penalty (Rules)
25% score deduction within 24 hours late; 50% deduction within 48 hours late.
Course Policy - Revision Tokens (Rules)
Students get 4 tokens per semester to revise/redo Excel Labs or Knowledge Checks scoring below 80%.