SSAC General Collection Modules

Following are short descriptions of the available modules. To access any of them, select from the list and you will connect to cover material including learning goals, context of use, and other information. Within the cover material (under "Teaching Materials") there is a link by which you can download the student version of the module.

There are a couple of ways of searching for modules. The box below left provides a full-text search of the cover material about the module, so you can search by author, subject, or keyword. The controlled vocabularies below right allow targeted searches by three different dimensions (click on the links to see the full, hierarchical vocabularies): Math content (Quantitative Concept) (Microsoft Word 41kB Jun17 10), Context (Subject) (Microsoft Word 29kB Jul13 07), and Excel Skill (Microsoft Word 32kB Jul13 07).

Skip to search results Skip to search facet filtersSkip to text search formSkip to pagination


Current Search Limits:
Subject
Business, economics and finance

Results 1 - 10 of 10 matches

Simple vs. Compound Interest -- Spreadsheeting the Difference part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across Curriculum module. Students build spreadsheets to tabulate, graph and compare the future value of investments with compound vs. simple interest. Spreadsheet level: beginner.

Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Descriptive statistics; trend lines :Line- and curve-fitting, Algebra; Modeling; Functions:Modeling:Forward modeling, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Exponential function, Algebra; Modeling; Functions:Straight lines and linear functions, Basic arithmetic; Number sense:Comparisons; percent difference, change, increase, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Basic arithmetic; Number sense:Ratio and proportion; percentage; interpolation, Creating and manipulating tabular data, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Exponential (geometric) growth, Basic arithmetic; Number sense:Rates:Rates of Change
Subject: Business, economics and finance :Finance, Mathematics, statistics and computers:Mathematics
Excel Skills: Basic Arithmetic:Nested Formulas, Simple Formulas, Graphs and Charts:XY Scatterplot:Multiple Plots, Trendlines

First Accounting Cycle, 1 -- Classifying Accounting Data Using Excel part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets across the Curriculum module. Students build a spreadsheet to post financial transactions and use a table-lookup function to classify them.

Quantitative Concepts: Creating and manipulating tabular data:Lookup function, Organizing and classifying data
Subject: Business, economics and finance : Business
Excel Skills: Other Manipulations and Functions:Lookup Functions

Understanding Mortgage Payments part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets across the Curriculum module. Students build Excel spreadsheets to calculate monthly mortgage payments and evaluate how much of their payment is applied to the principle and interest.

Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Visual display of data :Bar graphs; column graphs; stacked bar graphs, Algebra; Modeling; Functions:Multivariable functions, Creating and manipulating tabular data, Basic arithmetic; Number sense:Ratio and proportion; percentage; interpolation, Algebra; Modeling; Functions:Modeling:Forward modeling, Basic arithmetic; Number sense:Rates
Subject: Business, economics and finance , Finance
Excel Skills: Other Manipulations and Functions, Financial Functions, Basic Arithmetic:Arithmetic Functions:SUM, Graphs and Charts:Bar Graph:Stacked, Graphs and Charts:Bar Graph, Basic Arithmetic, Simple Formulas, Arithmetic Functions, Graphs and Charts

Calzones vs. Mini-Pizzas -- A Linear Programming Problem part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to find the combination of mini-pizzas and calzones that maximizes revenue given constraints on labor time and baking time.

Quantitative Concepts: Calculus; Numerical methods:Finding maximum/minimum, Algebra; Modeling; Functions:Straight lines and linear functions:Slope, intercept; linear trends, Algebra; Modeling; Functions:Manipulating equations, Straight lines and linear functions:Linear programming, linear inequalities, Algebra; Modeling; Functions:Multivariable functions, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots
Subject: Mathematics, statistics and computers:Mathematics, Business, economics and finance : Business
Excel Skills: Basic Arithmetic:Arithmetic Functions:SUMPRODUCT, Basic Arithmetic:Nested Formulas, Logic Functions:AND, Graphs and Charts:XY Scatterplot:Multiple Plots, Logic Functions:IF

Creating a Household Budget part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students track their expenses and use Excel to compare them to Seattle/Tacoma averages. Developed for adult students taking English as a Second Language.

Quantitative Concepts: Creating and manipulating tabular data, Basic arithmetic; Number sense:Units and Dimensions:Unit Conversions, Basic arithmetic; Number sense:Estimation, Measurement; Data presentation and analysis; Probability:Visual display of data :Pie charts, Basic arithmetic; Number sense:Ratio and proportion; percentage; interpolation, Measurement; Data presentation and analysis; Probability:Gathering data , Basic arithmetic; Number sense:Average; weighted average
Subject: Business, economics and finance :Finance, Mathematics, statistics and computers:Mathematics
Excel Skills: Basic Arithmetic:Arithmetic Functions:SUM, Basic Arithmetic:Percent (format), Statistical Functions:One array:AVERAGE, Graphs and Charts:Pie Chart, Basic Arithmetic:Simple Formulas

Index Numbers: Gasoline and Inflation -- Why We Need the Consumer Price Index part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across Curriculum module. Students build spreadsheets to examine the price of gasoline, 1978-2005. QL: using ratios and proportions to make comparisons.

Quantitative Concepts: Creating and manipulating tabular data, Basic arithmetic; Number sense:Ratio and proportion; percentage; interpolation, Comparisons; percent difference, change, increase, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots
Subject: Business, economics and finance :Economics
Excel Skills: Basic Arithmetic:Percent (format), Simple Formulas, Graphs and Charts:XY Scatterplot:One Plot, Multiple Plots, Basic Arithmetic:Nested Formulas

Investing for Retirement part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students use the Compound Interest Equation and an annuity equation to calculate the growth of investments over time.

Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Creating equations; text-to-math translation, Visual display of data :XY scatter plots, Algebra; Modeling; Functions:Modeling:Forward modeling, Algebra; Modeling; Functions:Manipulating equations, Basic arithmetic; Number sense:Estimation, Creating and manipulating tabular data, Basic arithmetic; Number sense:Ratio and proportion; percentage; interpolation, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Power function, Exponential (geometric) growth, Basic arithmetic; Number sense:Rates:Rates of Change
Subject: Business, economics and finance :Finance, Mathematics, statistics and computers:Statistics
Excel Skills: Basic Arithmetic:Percent (format), Graphs and Charts:XY Scatterplot

The Price is Right - Or is it? part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students learn through the use of spreadsheets how to optimize profits and revenues.

Quantitative Concepts: Creating and manipulating tabular data, Algebra; Modeling; Functions:Modeling:Forward modeling, Algebra; Modeling; Functions:Nonlinear functions of a single variable:Quadratic function, Measurement; Data presentation and analysis; Probability:Visual display of data :XY scatter plots, Basic arithmetic; Number sense:Rates, Calculus; Numerical methods:Finding maximum/minimum, Basic arithmetic; Number sense:Number operations:Number operations: addition, subtraction, multiplication, division
Subject: Business, economics and finance , Business
Excel Skills: Basic Arithmetic, Graphs and Charts:XY Scatterplot, Graphs and Charts

First Accounting Cycle, 2 -- Sorting and Grouping Data Using Excel part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets across the Curriculum module. Students work with the spreadsheet they created in Part I to sort and classify the data they entered using a Pivot Table.

Quantitative Concepts: Creating and manipulating tabular data:Organizing and classifying data, Pivot table, Sorting data
Subject: Business, economics and finance : Business
Excel Skills: Other Manipulations and Functions:Pivot Table, Pivot Chart

Driving Across Town for Cheaper Gas -- A Cost/Benefit Analysis part of Spreadsheets Across the Curriculum:General Collection:Examples
Spreadsheets Across the Curriculum module. Students build a spreadsheet to explore the trade-offs between "bargain-priced" gas vs. the extra mileage needed to get it. A modeling problem.

Quantitative Concepts: Measurement; Data presentation and analysis; Probability:Creating equations; text-to-math translation, Gathering data , Basic arithmetic; Number sense:Rates, Estimation, Algebra; Modeling; Functions:Modeling:Forward modeling, Basic arithmetic; Number sense:Units and Dimensions:Unit Conversions, Basic arithmetic; Number sense:Ratio and proportion; percentage; interpolation
Subject: Business, economics and finance :Finance
Excel Skills: Basic Arithmetic:Simple Formulas