# 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. You can also request an instructor's version by clicking on the "request" link under Teaching Materials.

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).

Help# Quantitative Concepts

# Subject

Results 31 - 40 of **55 matches**

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.

Subject: Business, economics and finance : Business

Excel Skills: Other Manipulations and Functions:Pivot Table, Pivot Chart

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.

Subject: Business, economics and finance : Business

Excel Skills: Other Manipulations and Functions:Lookup Functions

Getting Your Fair Share -- Jelly beans, student groups, and Alexander Hamilton part of Spreadsheets Across the Curriculum:General Collection:Examples

Spreadsheet Across the Curriculum module. Students develop an Excel spreadsheet to work with the quota method of apportionment designed by Alexander Hamilton.

Subject: Social science:History

Excel Skills: Other Manipulations and Functions:ROUND, ROUNDUP, ROUNDOWN, Basic Arithmetic:Arithmetic Functions:SUM, Basic Arithmetic:Nested Formulas, Simple Formulas, Percent (format), Statistical Functions:One array:LARGE, SMALL, etc, Logic Functions:IF

From Isotopes to Temperature: Working With A Temperature Equation part of Spreadsheets Across the Curriculum:General Collection:Examples

Spreadsheets Across the Curriculum module. Students build a spreadsheet to examine from a dataset the relation between oxygen isotopes in corals and the temperature of surrounding seawater.

Subject: Natural science:Biology, Chemistry, Earth science

Excel Skills: Graphs and Charts:Line Graph, Statistical Functions:One array:MAX, MIN, etc, Graphs and Charts:XY Scatterplot:Trendlines, Graphs and Charts:Bar Graph, Logic Functions:COUNTIF, Statistical Functions:One array:STDEV, STDEVP, etc, Basic Arithmetic:Simple Formulas, Nested Formulas, Statistical Functions:One array:AVERAGE

The Mole in Chemistry: How do you determine the number of atoms or molecules in everyday items? part of Spreadsheets Across the Curriculum:General Collection:Examples

Spreadsheets across the Curriculum Module. Students build spreadsheets to practice converting between moles, grams, and atomic mass units.

Subject: Natural science:Chemistry, Natural science

Excel Skills: Basic Arithmetic, :Simple Formulas

Energy Flow through Agroecosystems (Farms) part of Spreadsheets Across the Curriculum:General Collection:Examples

Spreadsheets across the Curriculum module. Students build spreadsheets that allow them to calculate the different values needed to examine energy flow through agroecosystems.

Subject: Engineering, agriculture:Agriculture and agricultural engineering, Natural science:Biology

Excel Skills: Basic Arithmetic:Arithmetic Functions:SUM, Basic Arithmetic:Simple Formulas, Graphs and Charts:Pie Chart

Powers of 2: Many Grains of Wheat part of Spreadsheets Across the Curriculum:General Collection:Examples

Spreadsheets Across the Curriculum module. Students use a spreadsheet to connect powers of 2 to powers of 10 to help understand exponential growth.

Subject: Mathematics, statistics and computers:Mathematics

Excel Skills: Basic Arithmetic

Dirty Jobs vs. Clean Jobs part of Spreadsheets Across the Curriculum:General Collection:Examples

Spreadsheets Across the Curriculum module. Students use spreadsheets to help find the difference in percentages of salaries between dirty and clean jobs.

Subject: Mathematics, statistics and computers:Statistics

Excel Skills: Basic Arithmetic:Arithmetic Functions, Percent (format), Graphs and Charts:Bar Graph

How Diverse Are We? -- Comparing Racial Composition of NYC and USA, 1980-2000 part of Spreadsheets Across the Curriculum:General Collection:Examples

Spreadsheets Across the Curriculum module. Students analyze the percentage of change in the diversity of the US compared to New York City over 20 years.

Subject: Mathematics, statistics and computers:Statistics, Humanities

Excel Skills: Graphs and Charts:Bar Graph:Stacked, Basic Arithmetic:Percent (format), Simple Formulas, Graphs and Charts, :Line Graph, Basic Arithmetic, Graphs and Charts:Bar Graph

Calculating Readability part of Spreadsheets Across the Curriculum:General Collection:Examples

Spreadsheets Across the Curriculum module. Students use the Gunning FOG Index, the Flesch Reading Ease Scale and the FORCAST Readability Formula to understand the readability level of a given passage.

Subject: Humanities: Reading and writing

Excel Skills: Basic Arithmetic:Simple Formulas