INTRODUCTION TO DATA ANALYSIS USING SPREADSHEETS
Introduction to data analysis for social scientists using spreadsheets software - with specific applications to economics, business and finance - including data management and manipulation; formulas and calculations; data visualization and presentation using charts and graphics; statistical and visual analysis of economic indicators using tables, functions, graphs and descriptive statistics; and optimization of functions with economic and financial data.
Prerequisites & course information
Requisites: None Course Designation: Core GenEd - Mathematics & Quantitative Reasoning Repeatable for Credit: No Last Taught: Fall 2026 Learning Outcomes: 1. Use basic Excel software, download and manipulate economic and financial data, and create basic formulas and functions. Audience: Undergraduate 2. Create, refine and interpret Excel charts and other graphics with real world economic and financial data, and display and organize data using tables and PivotTables. Audience: Undergraduate 3. Present, analyze and interpret trends and relationships among and between various economic indicators. Audience: Undergraduate 4. Use Solver and Goal Seek to numerically find optimal solutions. Audience: Undergraduate Learning Outcomes: 1. Use basic Excel software, download and manipulate economic and financial data, and create basic formulas and functions. Audience: Undergraduate 2. Create, refine and interpret Excel charts and other graphics with real world economic and financial data, and display and organize data using tables and PivotTables. Audience: Undergraduate 3. Present, analyze and interpret trends and relationships among and between various economic indicators. Audience: Undergraduate 4. Use Solver and Goal Seek to numerically find optimal solutions. Audience: Undergraduate
Sources
- Course catalogue ↗2026-2027