Courses Offered at Cornell University
AEM 2840/5840: Python Programming for Data Analysis and Business Modeling
This course is an introduction to programming in Python, tailored specifically for students in business and finance. No prior programming or data analysis experience is required. The curriculum is divided into two main sections. In the first half of the semester, students will build a solid foundation in Python programming, covering key concepts such as Python syntax, conditional statements, loops, functions, and data structures. The second half of the course shifts to practical applications in data analysis, with a focus on financial data. Topics include textual data analysis, working with large datasets using Pandas, web scraping, data collection, basic data mining techniques, and data visualization in Python. Throughout the course, students will learn to design algorithms and implement their ideas using Python, preparing them to apply these skills in real-world business and financial contexts.Python programming for data analysis and business modeling to drive informed decision-making.
AEM 2830: Excel VBA for Data Analysis and Business Modeling
AEM 2830 introduces students to programming using Visual Basic for Applications (VBA), providing a foundation to elevate their Excel skills. The course covers key VBA programming skills, including syntax, creating custom Excel functions, implementing multi-level conditional logic, and writing loops. Students will also learn how to enhance the user experience by developing navigation tools and using Excel features such as input boxes, message boxes, and forms to interact with users. The course includes techniques for efficiently importing and exporting large datasets within Excel using VBA. Throughout the semester, students will explore the various stages of data analysis, from data collection and cleaning to processing and analysis. By the end of the course, they will be equipped to apply their VBA skills to model and solve a range of business scenarios.
AEM 2820: Introduction to Database Management Systems
This course is an introduction to relational database management systems (DBMS) and their business application. Students will explore both logical and physical database designs and develop a clear understanding of the concepts and terminology related to DBMS. Students will learn how to write SQL queries and how to create, update, and manipulate a database. The course is designed and focused on the business application of database management. The main objectives of this course are learning how to work with databases and data in various business scenarios and how to extract knowledge from a large relational database. Students learn two database platforms, MS Access, and MySQL. The course has three distinct parts: first, learning the syntax and the mechanics of working with a database; second, the systematic process of designing a database; and third, applying their knowledge to real-world business cases.
AEM 2010/2011 - Spreadsheet Modeling for Management and Economics
AEM 2010/2011 is focused on applied decision-making, analytical skills, and problem-solving using spreadsheets. The course covers essential tools and techniques for data analysis, such as importing and cleaning data, analyzing data, and making conclusions based on the results. Students learn various analytical skills and related spreadsheet tools through case studies. AEM 2010 is a Dyson core course, and AEM 2011 is the non-Dyson version of the same course, open to all Cornell students. AEM 2011 is in high demand with a long waitlist. This course has eleven modules. We complete one module each week. The class material and assignments are designed around a wide range of business scenarios, from finance, accounting, and marketing to production and management.