CSE 2111: Modeling and Problem Solving with Spreadsheets and Databases
Covers quantitative problem-solving and business modeling utilizing advanced spreadsheet functionality, data analysis tools, automated formulas, and relational database management with SQL.
Independent study archive Learn more
Materials are uploaded by users for self-study purposes. PwnHero is an independent platform, not affiliated with, sponsored by, or endorsed by any university or institution.
Common aliases: CSE 2111
Study Resources for Modeling and Problem Solving with Spreadsheets and Databases
Midterm (Exam 1) 2017
Midterm (Exam 2) 2016
Final Exam 2010
Midterm (Exam 1) 2018
Midterm (Exam 1) 2019
Midterm (Exam 1) 2020
Quiz 1
Assessment Inventory for CSE 2111 (7 Documents)
| Document | Format | Year | Access |
|---|---|---|---|
| Midterm (Exam 1) 2020 | Midterm | 2020 | Illustrative Archive |
| Midterm (Exam 1) 2019 | Midterm | 2019 | Illustrative Archive |
| Midterm (Exam 1) 2018 | Midterm | 2018 | Illustrative Archive |
| Midterm (Exam 1) 2017 | Midterm | 2017 | Illustrative Archive |
| Midterm (Exam 2) 2016 | Midterm | 2016 | Illustrative Archive |
| Final Exam 2010 | Final | 2010 | Illustrative Archive |
| Quiz 1 | Quiz | — | Illustrative Archive |
Complete inventory of all 7 assessments (sorted by most recent). Select any document to inspect or use the search bar above to filter.
Course Overview & Exam Syllabus
This archive catalogs 7 free educational resources and past exams for CSE 2111 (Modeling and Problem Solving with Spreadsheets and Databases) at Ohio State University (OSU), containing 5 midterm papers, 1 final examination, and 1 quiz. Dated documents represent 6 distinct academic years between 2010 and 2020.
Core Exam Topics & Learning Objectives
- Advanced spreadsheet modeling: logical functions (IF, AND, OR), lookup functions (VLOOKUP, XLOOKUP, INDEX/MATCH) in CSE 2111
- Data analysis and scenario tools: PivotTables, Goal Seek, Solver optimization, and what-if financial modeling at OSU
- Relational database design principles: tables, primary/foreign keys, entity-relationship models, and normalization
- SQL query construction: SELECT queries, WHERE filtering, multi-table JOIN operations, and aggregate grouping in Modeling and Problem Solving with Spreadsheets and Databases
Frequently Asked Questions
Which assessment formats are cataloged in this CSE 2111 archive?
This collection for CSE 2111 at Ohio State University (OSU) catalogs 7 total resources across the following formats: Midterms, Finals, Quizzes. Each document is listed in the assessment inventory table with its individual format tag and academic year where recorded.
What academic years are covered in this CSE 2111 collection?
Dated materials in this archive span from 2010 to 2020, representing 6 distinct academic years. Coverage varies by the records currently cataloged for this course.
How can students access these free CSE 2111 past exams?
All cataloged CSE 2111 past exams and study materials are free to request. The catalog, metadata, assessment inventory, and illustrative thumbnails are public; source documents are not shown on this page. Use the connect options to request a study resource, and confirm current course topics and grading policies with the Ohio State University (OSU) course syllabus.