The role of databases in data analytics cannot be overstated; databases facilitate efficient, secure and accurate information storage and retrieval across multiple users and platforms. As a result, proficiency in database design and knowledge of SQL programming are essential skills for the modern analyst and data scientist. This course is designed to help students develop these skills.
Data hardly ever comes ready to be analyzed. In fact, in many analytics projects, –the preparation of data (be it collecting, loading, organizing, filtering, etc.) can take more than 80% of the team’s time and resources, often forcing them to rush through the analyses in order to produce results. This course will demonstrate how relational database design coupled with efficient programming can alleviate the burden of handling messy data, allowing analysts and data scientists to focus on delivering accurate, reliable and reproducible results.
While the Structured Query Language (SQL) has not changed much in the past decade, database systems and the tools that interact with them have continued to evolve. Students will be introduced to the latest programs and database connectors that allow for tight integration with Python and R as well as interactive visualization in Power BI and Tableau.
Additionally, students will be exposed to NoSQL database systems optimized for big data analytics and the techniques necessary for interacting with massive amounts of data.
This course features a final project in which students will leverage their newfound skills to tackle real-life data management scenarios by designing appropriate database schemas and demonstrating how raw data can be transformed into actionable insights.
Weekly Class Meeting 110 min x 14 = 1,540 min; Recitations (Category A) 14 sessions x 50 min = 700 min; Project Group Meeting (Category E) 1 session x 40 min = 40 min; TOTAL = 2,280 min (for entire semester)
The role of databases in data analytics cannot be overstated; databases facilitate efficient, secure and accurate information storage and retrieval across multiple users and platforms. As a result, proficiency in database design and knowledge of SQL programming are essential skills for the modern analyst and data scientist. This course is designed to help students develop these skills.
Data hardly ever comes ready to be analyzed. In fact, in many analytics projects, –the preparation of data (be it collecting, loading, organizing, filtering, etc.) can take more than 80% of the team’s time and resources, often forcing them to rush through the analyses in order to produce results. This course will demonstrate how relational database design coupled with efficient programming can alleviate the burden of handling messy data, allowing analysts and data scientists to focus on delivering accurate, reliable and reproducible results.
While the Structured Query Language (SQL) has not changed much in the past decade, database systems and the tools that interact with them have continued to evolve. Students will be introduced to the latest programs and database connectors that allow for tight integration with Python and R as well as interactive visualization in Power BI and Tableau.
Additionally, students will be exposed to NoSQL database systems optimized for big data analytics and the techniques necessary for interacting with massive amounts of data.
This course features a final project in which students will leverage their newfound skills to tackle real-life data management scenarios by designing appropriate database schemas and demonstrating how raw data can be transformed into actionable insights.
Weekly Class Meeting 110 min x 14 = 1,540 min; Recitations (Category A) 14 sessions x 50 min = 700 min; Project Group Meeting (Category E) 1 session x 40 min = 40 min; TOTAL = 2,280 min (for entire semester)
This elective course addresses the growing need for ethical leadership among communications and marketing professionals—both to build trust among increasingly socially conscious stakeholders and protect an organization’s reputation. Students will learn—through case studies, class discussions and assignments—how to identify ethical dilemmas, analyze potential risks and opportunities by applying ethical reasoning, and to formulate persuasive arguments for winning support for their positions from within and outside their organizations. Students will also learn how to integrate ethical decision making into long-term communications and business planning. This course will concentrate heavily on current events involving issues specific to communications and marketing professionals, including the growing influence of false and misleading information, micro-targeting racial, ethnic and other groups, misuse of consumer data and other potentially career-defining challenges.
Weekly Class Meeting 110 min x 14 = 1,540 min; Winter Symposium (Category B) 1 session x 540 min = 540 min; Final presentation during exam week (Category A) 1 session x 170 min = 170 min; TOTAL = 2,250 min (for entire semester)
This is the recitation course associated with APAN 5310 Data Analytics Using SQL and Relational Databases.
Review of the types of strategic risks, such as a flawed strategy, inability to execute the strategy, competitor risk, supply chain risk, governance risk, regulatory risk, M&A risk, international risk, etc. Includes case studies, research, and common mitigation techniques, such as strategic planning practices, management techniques, governance practices, supply-chain management, etc.
Weekly Class Meeting 110 min x 14 = 1,540 min; Case/Project Team Work Feedback (Category E) 1 semester x 450 min = 450 min; Required Instructor Meetings (Category E) 30 min x 13 = 390 min; TOTAL = 2,380 min (for entire semester)
Prerequisites: student expected to be mathematically mature and familiar with probability and statistics, arbitrage pricing theory, and stochastic processes. The course will introduce the notions of financial risk management, review the structure of the markets and the contracts traded, introduce risk measures such as VaR, PFE and EE, overview regulation of financial markets, and study a number of risk management failures. After successfully completing the course, the student will understand the basics of computing parametric VaR, historical VaR, Monte Carlo VaR, cedit exposures and CVA and the issues and computations associated with managing market risk and credit risk. The student will be familiar with the different categories of financial risk, current regulatory practices, and the events of financial crises, especially the most recent one.
This is a course that provides a comprehensive set of financial management tools for nonprofit professionals, including managers and staff, whether they oversee financial statements and reporting or need to translate financial statements and reporting across stakeholders. This course emphasizes the requirements for nonprofits in recording and budgeting the financials to support the organization’s mission. Additionally, the course will provide students with the ability to analyze financial statements and answer financial questions typically asked by stakeholders such as the governing board, donors, the public, beneficiaries, media, and regulators. Finally, the course will identify the risks and opportunities found in an organization's financial information to increase the public's confidence in and understanding of the organization's mission and operations.
Weekly Class Meeting 110 min x 14 = 1,540 min; Pre-Recorded Video Lecturers (Category D) 10 sessions x 45 min = 450 min; Pre-Final Presentation Faculty Review (Category E) 1 meeting x 120 min = 120 min; Pre-Semester Financial Management Boot Camp (Category A) 1 session x 140 min = 140 min; TOTAL = 2,250 min (for entire semester)
This course introduces students to selected legal and policy texts that have addressed issues in bioethics and shaped their development. Students will explore and contrast legal reasoning and bioethical analysis, often of the same issues. By the end of the course, students will understand the legal or regulatory status of selected issues and have begun to independently navigate major legal, regulatory, and policy texts. Individual sessions will be focused around particular issues or questions that have been addressed by (usually) American courts and/or in legislation, regulation or policy, and that have been the subject of scholarship and debate within bioethics.
The course begins with a theoretical look at the relationship between law and ethics, and includes a brief introduction to legal decision-making and policy development. We then survey a range of bioethics issues that have been addressed by the courts and/or in legislation, regulation, or significant policy documents, contrasting and comparing legal argument and reasoning with arguments utilized in the bioethics literature.
Weekly Class Meeting 120 min x 14 = 1,680 min;
Role Play Labs (Category A) 1 session x 80 min = 80 min;
Discussion Forum (Category C) 35 min x 14 = 490 min;
TOTAL = 2,250 min (for entire semester)
As the field of communication becomes increasingly mobile and social, students need a solid foundation in current digital practices and emerging media technologies. This course covers major themes in digital communication, such as channel and content strategy, digital user experience, mobile, programmatic marketing, leveraging digital insights and more. Using recent case studies highlighting public relations, marketing and corporate communication challenges, students will also learn approaches for developing, implementing and measuring integrated digital media campaigns.
Weekly Class Meeting 150 min x 14 = 2,100 min; Final presentations during exam period (Category A) 1 session x 150 min = 150 min; TOTAL = 2,250 min (for entire semester)
This course focuses on developing an entrepreneurial mindset that enables students to recognize opportunities, turn ideas into action, and navigate uncertainty within the sports industry. Students will explore the process of identifying unmet needs, testing new ideas, developing business models, communicating compelling visions, and driving innovation in a variety of professional settings, from startups to established sports organizations. Through case-based learning, hands-on problem-solving, group projects, and direct engagement with entrepreneurs, investors, and industry innovators, students will gain practical experience applying entrepreneurial thinking to real-world business challenges. The course emphasizes experimentation, collaboration, adaptability, and learning through feedback while preparing students to lead and contribute to innovation across the sports business landscape.
Weekly Class Meeting 110 min x 14 = 1,540 min; Discussion Posts (Category C) 45 min x 13 = 585 min; Framework Review Meetings (Category D) 30 min x 5 = 150 min; TOTAL = 2,275 min (for entire semester)
Apart from its justice and equity imperative, Diversity, Equity, and Inclusion (DEI) has become an operational imperative as organizations become increasingly diverse. This course aims to equip students with critical faculties and practical tools to be informed and ethical practitioners of DEI in the charitable sector. This course prepares students to manage and lead the practice of DEI in core operational functions, as directors of DEI offices/initiatives or as DEI champions within their organizations. It will equip students with an understanding of the advantages and challenges of leading diverse teams and will provide the knowledge, critical analysis, and practical tools required to lead inclusive organizations. It provides a framework and strategic foundation for driving an organization through the stages of gaining awareness about DEI, practicing DEI, and amplifying the work of equity and inclusion beyond the workplace.
Today’s workforce is more diverse, with employees coming from different demographic, social, and cultural backgrounds. Leaders are expected to attract and retain talent, manage diversity, and promote inclusion. The practice of DEI has undeniably become integral to the success and sustainability of organizations. Nonprofit organizations gain the trust and support of the public by representing constituents and community stakeholders among their leadership and ranks. Government agencies fulfill their mandates through public servants who represent key constituents. More and more investors are betting on companies driven by environmental, social, and governance
(ESG) concerns and customers purchase products and services with social impact.
Weekly Class Meeting 110 min x 14 = 1,540 min; Recitation (Category A) 2 sessions x 30 min = 60 min; Monitored Online Discussion Board on Canvas (Category C) 12 sessions x 37.5 min = 450 min; Field Trip (Category B) 1 meeting x 200 min = 200 min; TOTAL = 2,250 min (for entire semester)
Digital Product Innovation and Entrepreneurship aims to provide students with the knowledge and expertise in innovation and new product development required to create, test, and launch a new digital product. In this course, students will undertake the following: perform a competitive analysis, investigate novel knowledge-based digital products, gather user requirements, validate the feasibility of proposed products, devise a go-to-market strategy, construct a financial plan, develop a high-fidelity digital product prototype, and pitch their business idea to a panel of venture capitalists. Students can expect to engage in a fast-paced, rigorously hands-on curriculum focused on developing a pre-revenue business.
The exponential increase in data and information, coupled with the combination of increasingly potent analytics and natural language processing platforms, AI, and LLMs, provides entrepreneurs with tremendous opportunities to bring innovative, customer-focused digital products to market. While there are no direct paths to bring a new product idea to market successfully, the application of the lean startup methodology provides a well-tested path from idea to profit.
This course is 3 credits and runs for 14 weeks. Weekly class meetings are 110 minutes per week for 14 weeks, for a total of 1,540 minutes; weekly recitations (Category A) are 60 minutes per week for 14 weeks, for a total of 840 minutes. The course includes 2,380 total minutes (39.7 hours) of instructional time for the entire term.
Review of the types of operational risks, such as technology risk (e.g., cyber-security), human resources risk, disasters, etc. Includes case studies, risk analysis frameworks and metrics, and common mitigation techniques, such as insurance, IT mitigation, business continuing planning, etc.
Weekly Class Meeting 110 min x 14 = 1,540 min; Case/Project Team Work Feedback (Category E) 1 semester x 450 min = 450 min; Required Instructor Meetings (Category E) 30 min x 13 = 390 min; TOTAL = 2,380 min (for entire semester)
Prerequisites: comfortable with algebra, calculus, probability, statistics, and stochastic calculus. The course covers the fundamentals of fixed income portfolio management. Its goal is to help the students develop concepts and tools for valuation and hedging of fixed income securities within a fixed set of parameters. There will be an emphasis on understanding how an investment professional manages a portfolio given a budget and a set of limits.
Citizens’ Assemblies and Innovations in Conflict Resolution examines deliberative practices and citizens’ assemblies — representative bodies of randomly selected members of the public convened to deliberate on a contested question and produce recommendations — as both a democratic intervention and a conflict resolution tool. Over six sessions, students study the theoretical foundations of deliberation and the core components of a citizens’ assembly (sortition and recruitment, information provision, facilitation, and deliberation structure); examine the use of citizens’ assemblies and related deliberative mini-publics to address contested public issues, divided and conflict-affected societies, and organizational conflict; build hands-on facilitation skills through a dedicated, structured training session; and design and present a conflict-resolution intervention of their own before a panel of deliberative-practice experts. The course pays particular attention to citizens’ assemblies as an emerging field of practice: it situates them within the theoretical foundations of deliberative practice and the current crisis of engagement, explains how they embody the core principles of representativeness, informed judgment, and deliberation, and examines how they can be institutionalized and sustained, drawing on the instructor’s own experience designing assemblies around the world. This course is designed for students in the Negotiation and Conflict Resolution program interested in organizational conflict and institutional reform, who will go on to practice in the private sector, the public sector, and international organizations, and who want to add process design, program management, and facilitation skills for large-scale, multi-party public deliberation to their negotiation, mediation, and consensus-building toolkit.
The course extends the program’s foundational coursework in negotiation theory, conflict analysis, and engagement across difference into an emerging and rapidly growing area of practice: the design of structured, representative deliberative processes as a tool for resolving conflict among diverse and often polarized stakeholders in the public and private sectors. Citizens’ assemblies share a resemblance with multi-party negotiation and consensus-building processes — both depend on careful process design, skilled facilitation, and legitimacy in the eyes of the parties — and the course asks students to compare and contrast thes
This graduate-level course offers an interdisciplinary exploration of neuroethics, focusing on the ethical, legal, and social implications of advances in clinical neurology and neuroscience research. We will explore ethical issues that arise in the diagnosis and management of neurological and psychiatric disorders, including dementia, traumatic brain injury, movement disorders, mental illness, addiction, and brain death/disorders of consciousness. We will investigate the impact of emerging neuroscience technologies on society and address the legal implications of neuroscience, ranging from concrete applications, such as the use of brain imaging in court proceedings, to abstract questions regarding criminal responsibility.
Students will analyze real-world clinical cases, focusing on informed consent, capacity assessment, surrogate decision-making, personhood, and end-of-life care. We will examine the ethical dimensions of neuroscience research, including the use of brain imaging and various neurotechnologies, such as neuroenhancement, brain-computer interfaces, and artificial intelligence. We will address the bioethical challenges in conducting research involving vulnerable populations, the developing concept of “neurorights”, and neurodiversity. Through debates and philosophical reasoning, we will engage critically with issues at the cutting edge of neuroethics.
Weekly Class Meeting 110 min x 14 = 1,540 min;
Discussion Forum (Category C) 14 sessions x 51 min = 714 min;
TOTAL = 2,254 min (for entire semester)
Students without a strong math background and experience with Excel will require significant additional time and effort to achieve the learning objectives and work through the course assignments.
This course builds a foundation in the mathematics and statistics of risk management. Students are empowered to understand the output of quantitative analysts and to do their own analytics. Concepts are presented in Excel and students will have the opportunity to practice those concepts in Excel, R or Python.
This course is a required prerequisite for registering for the following courses: Coding for Risk Management, Financial Risk Management, Quantitative Risk Management, Credit Risk Management, Market Risk Management, Credit Risk Analytics, Applied Coding for Risk Management, Derivatives Risk Management, Model Risk Management, ERM Modeling, and Machine Learning for Risk Management.
Weekly Class Meeting 110 min x 14 = 1,540 min; Skills-Based Seminar (Category A) 12 session x 90 min = 1,080 min; TOTAL = 2,620 min (for entire semester)
Data analysis and statistical understanding are essential to effective decision-making across every area of the sports industry, from marketing and finance to human resources, facilities, and competition. This course introduces students to the fundamental statistical concepts and techniques used to support data-driven business decisions. Using sports data as a practical learning tool, students will develop the skills to perform common business calculations, analyze and interpret data, and present findings using Microsoft Excel. The course emphasizes understanding statistical concepts and formulas while preparing students to evaluate analytical results, ask informed questions, and apply quantitative reasoning to real-world business challenges within the sports industry and beyond. Weekly Class Meeting 110 min x 15 = 1,650 min; Excel and Stats Bootcamp (Category A) 1 session x 180 min = 180 min; Discussion Posts (Category C) 45 min x 6 = 270 min; Excel Review Sessions (Category A) 60 min x 2 = 120 min; Final Project Meetings (Category E) 30 min x 2 = 60 min; TOTAL = 2,280 min (for entire semester)
Equips students with the ability to adopt the programming culture typically present in the ERM/risk areas of most financial organizations. By studying Python, SQL, R, git, and AWS, students gain exposure to different syntaxes. Students apply these skills by coding up market risk and credit risk models. Students also gain familiarity with working in the cloud.
Weekly Class Meeting 110 min x 14 = 1,540 min; Skills-Based Seminar (Category A) 12 session x 90 min = 1,080 min; TOTAL = 2,620 min (for entire semester)
A survey of market, credit, liquidity, and systemic risk. Includes case studies, risk quantification methods, and common mitigation techniques using portfolio management, hedging, and derivatives. Also addresses traditional risk management practices at banking institutions.
Weekly Class Meeting 110 min x 14 = 1,540 min; Case/Project Team Work Feedback (Category E) 1 semester x 720 min = 720 min; Required Instructor Meetings (Category E) 2 sessions x 50 min = 100 min; TOTAL = 2,360 min (for entire semester)
Course covers modern statistical and physical methods of analysis and prediction of financial price data. Methods from statistics, physics and econometrics will be presented with the goal to create and analyze different quantitative investment models.
This course provides an overview of the business and financial operations of professional sports organizations, with an emphasis on the accounting and financial skills necessary for effective decision-making in the sports industry. Students will examine the business models, financial structures, and economic landscape of major sports leagues and organizations while developing practical skills in financial analysis, accounting principles, budgeting, and organizational management. Through hands-on exercises, simulations, and real-world case studies, students will learn to apply financial and accounting concepts to the challenges and decisions routinely faced by sports industry professionals. Weekly Class Meeting 110 min x 15 = 1,650 min; SPS Excel Training Sessions (Category D) 3 sessions x 45 min = 135 min; Journal Entries and T Chart Review (Category A) 1 session x 45 min = 45 min; Homework Review Sessions (Category A) 45 min x 11 = 495 min; TOTAL = 2,325 min (for entire semester)
This course provides an overview of the business and financial operations of professional sports organizations, with an emphasis on the accounting and financial skills necessary for effective decision-making in the sports industry. Students will examine the business models, financial structures, and economic landscape of major sports leagues and organizations while developing practical skills in financial analysis, accounting principles, budgeting, and organizational management. Through hands-on exercises, simulations, and real-world case studies, students will learn to apply financial and accounting concepts to the challenges and decisions routinely faced by sports industry professionals. Weekly Class Meeting 110 min x 15 = 1,650 min; SPS Excel Training Sessions (Category D) 3 sessions x 45 min = 135 min; Journal Entries and T Chart Review (Category A) 1 session x 45 min = 45 min; Homework Review Sessions (Category A) 45 min x 11 = 495 min; TOTAL = 2,325 min (for entire semester)
This course examines questions such as: What does the telling and reading of narratives do for the ill or disabled individual? How can clinicians effectively elicit, interpret, and act upon such narratives? Who owns a story, and what is the role of co-authorship, power and witnessing in story-telling and story-listening? Whose voice do we hear? What are the roles of power and hierarchy in story-telling and listening? What is the impact of familial, cultural, social, institutional, political contexts on the individual story? And finally, how can personal stories be translated to political advocacy and action? Texts assigned weekly will be broadly interdisciplinary – drawing from memoir, poetry, essays, fiction, feature and documentary films, narrative theory, and disability studies, exploring the relationship between disability/illness experience and narrative. This elective course is open to all students in the Narrative Medicine CPA program. Students should be prepared to engage with each other and with the instructor and to offer their questions, comments, insights, and analysis.
This is an essential, practically applied element of narrative medicine study and it is exemplary as a way to illustrate the impact of narrative study in shaping experience, opening awareness, and highlighting the need for change and new stories. A narrative medicine course focused on disability and illness narratives is an important aspect of narrative medicine study. Exploring narratives presented in a variety of formats by using narrative medicine methods can encourage deeper perspective-taking and promote activism for underrepresented voices.
Disability and Illness Narratives: Storytelling For Awareness and Activism
is an elective course in the Narrative Medicine CPA program. In addition, this course is open to cross-registrants in other programs who demonstrate some understanding of narrative medicine and/or participate in the online asynchronous narrative medicine orientation course before the semester begins. Narrative Medicine CPA students are required to have completed, or be simultaneously enrolled in the course,
Narrative Medicine Methods: Close Reading and Writing
, course number K5120, and have completed the required program online asynchronous orientation course. CPA courses are all 10 weeks/modules long, and they are online and asynchronous, which means there are no meeting times. Each module represents one week of the course. All modules begin on a Tuesday and end on Monday of th
Review of types of insurance risk, such as pricing risk, underwriting risk, reserving risk, etc. Includes case studies, risk quantification methods (e.g., market-consistent economic capital models, dynamic financial analysis (DFA) models, catastrophe models, etc.), and common mitigation techniques, such as asset-liability management (ALM), reinsurance, etc. Also addresses traditional risk management at insurance companies and ERM actuarial standards of practice (ASOPs).
Weekly Class Meeting 110 min x 14 = 1,540 min; Case/Project Team Work Feedback (Category E) 1 semester x 120 min = 120 min; Required Instructor Meetings (Category E) 55 min x 13 = 715 min; TOTAL = 2,375 min (for entire semester)
The course will cover practical issues such as: how to select an investment universe and instruments, derive long term risk/return forecasts, create tactical models, construct and implement an efficient portfolio,to take into account constraints and transaction costs, measure and manage portfolio risk, and analyze the performance of the total portfolio.
Credit Risk Management requires business acumen, the monitoring of internal and external data, disciplined execution, and organizational intelligence. A solid understanding of this enables a credit risk manager to help organizations achieve their objectives. Through readings, case studies, and modeling projects, students learn how risk managers decide on credit risk management strategy applied throughout the client lifecycle.
Weekly Class Meeting 110 min x 14 = 1,540 min; Case/Project Team Work Feedback (Category E) 1 semester x 720 min = 720 min; Required Instructor Meetings (Category E) 2 sessions x 50 min = 100 min; TOTAL = 2,360 min (for entire semester)
Capstone projects afford a group of students the opportunity to undertake complex, real-world, client-based projects for nonprofit organizations, supervised by a Nonprofit Management program faculty member. Through the semester-long capstone project, students will experience the process of organizational assimilation and integration as they tackle a discrete management project of long or short-term benefit to the client organization. The larger theoretical issues that affect nonprofit managers and their relationships with other stakeholders, both internal and external, will also be discussed within the context of this project-based course.
Weekly Class Meeting 110 min x 14 = 1,540 min; Monitored Online Discussion Board on Canvas (Category C) 5 sessions x 28 min = 140 min; Industry Sponsor Check-Ins with Faculty Present (Category B) 6 meetings x 60 min = 360 min; Required 360 Project Review with Faculty (Category E) 1 meeting x 30 min = 30 min; Final Group Presentations with Sponsor and Faculty (Category A) 1 session x 180 min = 180 min; TOTAL = 2,250 min (for entire semester)
Data-driven decision-making is increasingly shaping how sports organizations evaluate business opportunities, engage fans, and generate revenue across the industry. This course examines how quantitative analysis and business intelligence can be used to identify opportunities and maximize revenue across key areas such as media, sponsorship, ticketing, and marketing. Students will explore current industry trends, best practices, and the metrics that drive the financial and commercial success of sports properties. Through practical, real-world analysis, students will develop the ability to translate business challenges into data-driven insights, conduct key revenue-focused analyses, and communicate findings and recommendations effectively to senior management. The course prepares students to apply analytical skills and strategic thinking to revenue generation and business growth within the sports industry. Format:Weekly Class Meeting 110 min x 15 = 1,650 min; Faculty Introduction (Category E) 1 session x 30 min = 30 min; Project Check In (Category E) 1 session x 30 min = 30 min; Homework Recitation (Category A) 45 min x 13 = 585 min; TOTAL = 2,295 min (for entire semester)
This upcoming fall, we are going to kick off the “Practitioners Seminar” course, where successful practitioners from various industry fields (tech, finance, insurance, pharmaceutical, etc..) will have a chance to meet our students and present the projects they work on, technologies they utilize to achieve their goals, solutions they came up with etc. In addition, guest speakers will share their career development path (what kind of obstacles they faced, what pitfalls to avoid, and in general give advice on career development in their fields). We will finish up the meeting with a Q&A session with students.
This course is intended to provide a mechanism to MA students in Statistics who undertake on-campus project work or research. The course may be signed up with a faculty member from the Department of Statistics for academic credit. Students seeking to enroll in the course should identify an on-campus project and a congenial faculty member whose research is appealing to them, and who are able to serve as their mentor. Students should then submit an application to enroll in this course, which will be reviewed and approved by the Faculty Director of the MA in Statistics program.
Prerequisites: GR5203; GR5204 &GR5205 and at least 4 approved electives This course is an elective course for students in the M.A. in Statistics program that counts towards the degree requirements. To receive a grade and academic credits for this course, students are expected to engage in approved off-campus internships that can be counted as an elective. Statistical Fieldwork should provide students an opportunity to apply their statistical skills and gain practical knowledge on how statistics can be applied to solve real-world challenges.
Great managers of analytic projects are more than mere data users; they are key decision makers and strategic owners in the underlying data processes. This course provides students with foundational context for managing data so that it can be leveraged and used with confidence.
Analytic teams work closely with technology partners in managing data. Languages and techniques unique to each team can impede cooperation. To bridge this gap, this course provides a broad overview of data technology concepts including database engines and associated technologies.
Sound policies and procedures are also essentials to ensure high quality of data throughout the analytics lifecycle. But the challenges of putting these measures into practice are significant. There are often legacy repositories and business functions to unravel, as well as social and political barriers to overcome. Data ownership and accountability are hard to implement. Operational disruption and conflicting stakeholder requirements pose additional barriers.
This course will expose students to foundational data principles, governance processes and organizational prerequisites needed to overcome challenges to ensure data quality.
Weekly Class Meeting 110 min x 14 = 1,540 min; Recitations (Category A) 14 sessions x 50 min = 700 min; Discussion Forum (Category C) 1 session x 40 min = 40 min; TOTAL = 2,280 min (for entire semester)
Great managers of analytic projects are more than mere data users; they are key decision makers and strategic owners in the underlying data processes. This course provides students with foundational context for managing data so that it can be leveraged and used with confidence.
Analytic teams work closely with technology partners in managing data. Languages and techniques unique to each team can impede cooperation. To bridge this gap, this course provides a broad overview of data technology concepts including database engines and associated technologies.
Sound policies and procedures are also essentials to ensure high quality of data throughout the analytics lifecycle. But the challenges of putting these measures into practice are significant. There are often legacy repositories and business functions to unravel, as well as social and political barriers to overcome. Data ownership and accountability are hard to implement. Operational disruption and conflicting stakeholder requirements pose additional barriers.
This course will expose students to foundational data principles, governance processes and organizational prerequisites needed to overcome challenges to ensure data quality.
Weekly Class Meeting 110 min x 14 = 1,540 min; Recitations (Category A) 14 sessions x 50 min = 700 min; Discussion Forum (Category C) 1 session x 40 min = 40 min; TOTAL = 2,280 min (for entire semester)
While this course is designed to introduce students to the fundamentals of clinical ethics and the basic terminology and framework of ethical analysis in biomedical ethics, it offers a more sociological perspective, putting the contemporary clinical issues into a broader context. We will look briefly at the development of clinical ethics and its impact on hospital care and doctor-patient relationships, on the prevailing autonomy norm and its critique. The course then focuses on issues encountered in clinical practice such as informed consent, patient capacity, decision-making, end of life, advance directives, medical futility, pediatrics ethics, maternal-fetal conflicts, organ transplantation, cultural competence and diversity of beliefs and others. The course will examine the role of the clinical ethics consultant (CEC) and assignments will mimic the work that CECs may perform in the hospital setting.
Over the span of the semester, students become familiar with the ethical questions surrounding major topics in the clinic with a practical case-based approach toward ethics dilemmas and ethics consultation. During the semester, students in New York attend a meeting of the adult or pediatric ethics committees of New York Presbyterian and Morgan Stanley Children's Hospital or another area hospital, as well as ethics lectures given at the medical center.
Students are expected to complete five case write-ups using a template that will be given by the instructor. Students will be using these cases to refine and hone their ethical analysis skills and to show their knowledge of law, policy and ethical principles and how they might apply to each situation.
Weekly Class Meeting 110 min x 14 = 1,540 min;
Discussion Forum (Category C) 14 sessions x 45 min = 630 min;
Ethics Committee Meeting (Category B) 1 session x 80 min = 80 min;
TOTAL = 2,250 min (for entire semester)
Operations plays an important role in fulfilling all the responsibilities needed to maintain a productive and profitable business. Yet, operations is often overlooked as a key insurance discipline.
A KPMG International Cooperative study entitled “Operational Excellence in Insurance” stated that 25% of every premium dollar is consumed by operating expenses, a consistent pattern for the past 10 years despite premium growth and evolving technology. Consequently, the industry has put a larger emphasis on mitigating operational challenges and improving back office efficiencies.
This course brings operations to the forefront by studying the functions, strategies, processes, and tasks associated with its core responsibilities and stakeholder obligations. Students will address nuances of interdependent and collaborative working along with technological developments like Artificial Intelligence (AI), Robotic Process Automation (RPA) and Machine Learning (ML). This course also addresses managing resources, end-to-end processing, operational risk, and the effects of regulation within the industry.
The course goal is to address complex insurance challenges through discussions, team assignments, and Problem-Based Learning (PBL). Upon course completion, students will have a comprehensive operational playbook to assist in managing operational activities in the midst of extraordinary circumstances.
Pre-recorded lecture videos on Canvas with tracked completion (Category D) 70 min x 14 = 980 min; Monitored online discussion board on Canvas with instructor feedback (Category C) 50 min x 14 = 700 min; Recorded guest lecturer sessions with tracked completion (Category D) 3 sessions x 60 min = 180 min; Assigned operations webinar with tracked completion (Category D) 1 webinar x 60 min = 60 min; Module group activities with instructor feedback (Category A) 6 activities x 55 min = 330 min; TOTAL = 2,250 min (for entire semester)
The Tax Planning course explores the various methods of the U.S. tax system, its development, its applicability to individual (and corporate) taxpayers, and steps taxpayers of various income and wealth levels take to determine, meet, and minimize their tax obligations, depending on their goals. Students will learn how to identify sources, nature, and taxability of taxpayers income and gains, to determine the deductibility of any expenses they incur to reduce income, identify credits they may have to offset taxes due, understand filing and payment obligations, and apply the methods of minimizing tax - avoidance, deferral, and use of lower brackets or realization by other taxpayers.
This is the recitation course associated with APAN 5400 Fundamentals of Data Engineering.
This is the recitation course associated with APAN 5400 Fundamentals of Data Engineering.
This course provides the tools to measure and manage market risk in the context of large financial institutions. The volume and complexity of the data itself, at large institutions, makes it a challenge to generate actionable information. We will take on this challenge to master the path from data to decisions.
We cover the essential inputs to the engines of financial risk management: VaR, Expected Exposure, Potential Exposure, Expected Shortfall, backtesting, and stress testing as they apply to asset management and trading. We explore the strengths and weaknesses of these different metrics and the tradeoffs between them. We also cover how regulatory frameworks impact both the details and the strategy of building these engines. Lastly, we cover counterparty-credit methodologies, mainly as they apply to Trading Book risk.
Weekly Class Meeting 110 min x 14 = 1,540 min; Case/Project Team Work Feedback (Category E) 1 semester x 360 min = 360 min; Required Instructor Meetings (Category E) 30 min x 12 + 60 min x 1 = 420 min; Professional Development Guest-Led Seminar (Category B) 1 session x 60 min = 60 min; TOTAL = 2,380 min (for entire semester)
This course examines leadership development and organizational behavior within the sports industry, combining leadership theory with practical applications to prepare students to become effective leaders and managers. Students will explore key leadership principles and management challenges, including communication, motivation, planning, decision-making, change management, staffing, conflict resolution, and ethical decision-making. Through individual and team exercises, current industry news, case discussions, and insights from experienced sports industry leaders, students will have opportunities to apply leadership concepts to real-world situations. The course also emphasizes self-awareness and the development of essential personal leadership skills, preparing students to navigate organizational challenges, build effective teams, and lead with integrity in an evolving sports business environment.Format: Weekly Class Meeting 110 min x 15 = 1,650 min; Listening and Self Awareness Workshop (Category B) 1 session x 300 min = 300 min; Leadership Through Fencing Workshop (Category B) 1 session x 180 min = 180 min; Recitation Hours (Category C) 60 min x 2 = 120 min; TOTAL = 2,250 min (for entire semester)
This course examines leadership development and organizational behavior within the sports industry, combining leadership theory with practical applications to prepare students to become effective leaders and managers. Students will explore key leadership principles and management challenges, including communication, motivation, planning, decision-making, change management, staffing, conflict resolution, and ethical decision-making. Through individual and team exercises, current industry news, case discussions, and insights from experienced sports industry leaders, students will have opportunities to apply leadership concepts to real-world situations. The course also emphasizes self-awareness and the development of essential personal leadership skills, preparing students to navigate organizational challenges, build effective teams, and lead with integrity in an evolving sports business environment.Format: Weekly Class Meeting 110 min x 15 = 1,650 min; Listening and Self Awareness Workshop (Category B) 1 session x 300 min = 300 min; Leadership Through Fencing Workshop (Category B) 1 session x 180 min = 180 min; Recitation Hours (Category C) 60 min x 2 = 120 min; TOTAL = 2,250 min (for entire semester)
This course examines leadership development and organizational behavior within the sports industry, combining leadership theory with practical applications to prepare students to become effective leaders and managers. Students will explore key leadership principles and management challenges, including communication, motivation, planning, decision-making, change management, staffing, conflict resolution, and ethical decision-making. Through individual and team exercises, current industry news, case discussions, and insights from experienced sports industry leaders, students will have opportunities to apply leadership concepts to real-world situations. The course also emphasizes self-awareness and the development of essential personal leadership skills, preparing students to navigate organizational challenges, build effective teams, and lead with integrity in an evolving sports business environment.Format: Weekly Class Meeting 110 min x 15 = 1,650 min; Listening and Self Awareness Workshop (Category B) 1 session x 300 min = 300 min; Leadership Through Fencing Workshop (Category B) 1 session x 180 min = 180 min; Recitation Hours (Category C) 60 min x 2 = 120 min; TOTAL = 2,250 min (for entire semester)
This course examines leadership development and organizational behavior within the sports industry, combining leadership theory with practical applications to prepare students to become effective leaders and managers. Students will explore key leadership principles and management challenges, including communication, motivation, planning, decision-making, change management, staffing, conflict resolution, and ethical decision-making. Through individual and team exercises, current industry news, case discussions, and insights from experienced sports industry leaders, students will have opportunities to apply leadership concepts to real-world situations. The course also emphasizes self-awareness and the development of essential personal leadership skills, preparing students to navigate organizational challenges, build effective teams, and lead with integrity in an evolving sports business environment.Format: Weekly Class Meeting 110 min x 15 = 1,650 min; Listening and Self Awareness Workshop (Category B) 1 session x 300 min = 300 min; Leadership Through Fencing Workshop (Category B) 1 session x 180 min = 180 min; Recitation Hours (Category C) 60 min x 2 = 120 min; TOTAL = 2,250 min (for entire semester)
Tropical Highland Ecosystems - Vietnam is an intensive, field-based sustainability course that immerses students in the study of tropical highland ecosystems from within an area that is home to two UNESCO-designated Biosphere Reserves; Province, with a National Park as the core zone) and Lang Biang Province. These two regions span an ecological transect from coastal drylands and marine ecosystems to high-elevation montane and cloud forests and is home to multiple indigenous peoples, highlighting their exceptional biodiversity and cultural value. Their recognition under UNESCO's Man and the Biosphere Program illustrates their international significance as areas for balancing conservation and sustainable development. The significance of tropical highlands becomes increasingly apparent as the global climate warms and sea level rise forces migration away from deltaic lowlands. Critical ecosystems services provided by these highland environments are threatened not only by a warming climate, but also by changes in land use and increased population. Local indigenous people have survived in these highlands for generations, and are particularly at risk from these changes, comprise one of our main areas of interest. Furthermore, we will be immersed within an area of high biodiversity and endemism, with more than 14 tropical ecosystems that serve as home to numerous endangered species, including the sun bear, the antelope-like saola, giant and Truong Son muntjacs (barking deer), and the gray-shanked douc langur. The region is also rich in endemic plant species, including the enigmatic krempfii pine that is found only in the Central Highlands, and several other rare or endemic conifers. A single highland forest can exhibit exceptional species richness, with studies in the Central Highlands finding up to 70 tree species per hectare. This course is designed for graduate students in the Master of Science in Sustainability Science program at Columbia University who are preparing for careers in environmental science, restoration ecology, climate adaptation, or ecosystem-based management. It is especially suitable for those interested in field-based research, biodiversity monitoring, nature-based solutions, and the integration of science with sustainability practice. The course provides foundational exposure to tropical highlands ecology while deepening competencies in interdisciplinary environmental problem-solving. Class Meeting 165 min x 14 = 2,310 min; TOTAL = 2,310 min (for entire semester).
This course offers to the student who may find an examination of printmaking an asset to their art practice.
The course will cover several printmaking processes like relief, intaglio, silkscreen, and monotype. In addition, we will discuss printmaking concepts such as repetition, matrix, original/translation, reproducibility, and multiple considering the works produced in class.
We will involve a separate in-depth study of each process by alternating studio time, demonstrations, field trips, individual and group critiques.
Through the printmaking processes, students will explore assignments and projects and be encouraged to incorporate them into their own body of work.
Advanced introduction to classical sentential and predicate logic. No previous acquaintance with logic is required; nonetheless a willingness to master technicalities and to work at a certain level of abstraction is desirable. Note: Due to significant overlap, students may receive credit for only one of the following three courses: PHIL UN3411, UN3415, GR5415.
TBA
TBA
Tech Arts: Post Production II continues teaching the core techniques for picture and sound editing and the post production workflow process for Columbia Film MFA students. We will cover preparing for a long-form edit, digital script integration, color management and continuity, advanced trimming, and advanced finishing. The hands-on lessons and exercises will be conducted using the industry-standard Non-Linear Editing Systems, Avid Media Composer, and Davinci Resolve. Each week’s class will consist of hands-on demonstrations and self-paced practice using content created by the students and provided by the program.
Indicators of companies running into hard times typically include revenue volatility, loss of key personnel, reputational damage, and increased litigation. However, company failures are frequently marked by insufficient liquidity, or the lack of cash to meet obligations. Liquidity risk is the unexpected change in a company’s cash resources or demands on such resources that results in the untimely sale of assets, and/or an inability to meet contractual demands and/or default. In extreme cases, the lack of sufficient cash creates severe losses and results in company bankruptcy.
An institution’s cash resources and obligations can and must be managed. Indeed, the field of liquidity risk management is an established part of treasury departments at sizable institutions. The regularity of cash flows and the turbulence of business and markets must be assessed and quantified. This course provides students the tools and techniques to manage all types of liquidity challenges including the need to sell assets unexpectedly in the market, or work through ‘‘run‐on-the‐bank’’ situations for financial services companies.
Weekly Class Meeting 110 min x 14 = 1,540 min; Case/Project Team Work Feedback (Category E) 1 semester x 240 min = 240 min; Required Instructor Meetings (Category E) 45 min x 13 = 585 min; TOTAL = 2,365 min (for entire semester)
The application of Machine Learning (ML) algorithms in the Financial industry is now commonplace, but still nascent in its potential. This course provides an overview of ML applications for finance use cases including trading, investment management, and consumer banking.
Students will learn how to work with financial data and how to apply ML algorithms using the data. In addition to providing an overview of the most commonly used ML models, we will detail the regression, KNN, NLP, and time series deep learning ML models using desktop and cloud technologies.
The course is taught in Python using Numpy, Pandas, scikit-learn and other libraries. Basic programming knowledge in any language is required.
Increasingly, issues of medical research and clinical care are posing complex ethical issues not only in the United States, but in other countries in both the industrialized and the developing world. Yet varying economic, political, social, cultural, and historical contexts shape these issues. In diverse contexts in Asia, Africa, Europe and North and South America, practices and policies, along with cultures and moral values, differ enormously. Yet ethical issues are arising not in isolation, but as part of global communities and discourses.
In research, multinational pharmaceutical companies are increasingly conducting studies in both industrialized countries and the developing world, posing numerous ethical tensions. In clinical care, uses of reproductive technologies differ across national borders, leading to “reproductive tourism”. End of life care varies widely, reflecting in part differing attitudes toward death and dying. This course examines the political, economic, social, cultural, philosophical, medical, and historical roots and implications of these issues.
The course meets once a week for two hours, and offers extensive live-session interaction and post-session discussion forums to explore the various bioethical issues contemplated throughout the semester.
Weekly Class Meeting 120 min x 14 = 1,680 min;
Discussion Forum (Category C) 41 min x 14 = 574 min;
TOTAL = 2,254 min (for entire semester)
Using Blockchain, decisions can be made without relying on a single centralized authority, allowing for greater transparency and trust between participants. By using smart contracts and distributed ledgers, users can easily create, modify, and manage agreements between stakeholders, ensuring that all parties have access to the same information and can make informed decisions. As a result, Blockchain technology reduces the risks associated with decision-making, and improves efficiency and accuracy. This course first examines the risks and rewards of implementing Blockchain at large organizations engaging in decentralized decision-making processes. The course then explores the Blockchain as a tool for risk management.
Weekly Class Meeting 110 min x 14 = 1,540 min; Case/Project Team Work Feedback (Category E) 1 semester x 540 min = 540 min; Required Instructor Meetings (Category E) 50 min x 6 = 300 min; TOTAL = 2,380 min (for entire semester)
This survey course examines a range of sustainable and impact investing fixed income and equity products before transitioning to the asset owner perspective on sustainable and impact investing. Each class session includes elements of financial analysis, financial structure, social or environmental impact, and policy and regulatory context. Brief guest lectures, podcasts, and three experiential exercises bring these topics to life. At the end of the course, each student will be able to (i) construct a diversified portfolio of impact investments based on the range of products tackled in class, (ii) integrate ESG into debt and equity valuation, (iii) develop an impact investing product that an asset manager or investment bank could launch, (iv) develop an impact investing strategy for an asset owner, and (v) lead either side of the investor-corporate dialogue on sustainability. The lectures are designed to prepare students for both the impact investing product development exercise and the impact investing asset owner strategy exercise, and these two exercises are designed to prepare students for impact investing leadership over the course of their careers. As an early innovator in social finance, dating back 24 years, the instructor provides students with a practical toolkit, honed by making mainstream financial institutions and products more beneficial to a broader range of stakeholders and making specialist impact investment firms more relevant to and integrated with mainstream markets. Weekly Class Meeting 110 min x 14 = 1,540 min; Bootcamp (Category A) 720 min x 1 = 720 min; TOTAL = 2,260 min (for entire semester).
This course provides an overview of the way sustainability (environmental, social and governance) factors are analyzed in private markets. It focuses on preparing students to implement their understanding of the financial and societal risks and opportunities within the investment making process. In private markets, limited partners (pension funds, endowments, high net-worth individuals) have pushed the sustainability imperative and social consciousness of private equity funds and asset managers by seeking greater clarity around how their money is invested in both a responsible and financially meaningful way. Alongside this trend, an evolving regulatory environment globally has propelled the need to systemize evaluation frameworks for stakeholders within investment functions and advisors who support them.Unlike public markets, sustainability information is harder to glean in private markets and requires a skilled extraction and evaluation process. During this course, we examine a traditional ESG due diligence process embedded within the wider investment lifecycle (sourcing, diligence, hold and exit) through the lens of changing geographic regulatory landscape in financial investing and the market leading frameworks that quantify ESG factors for evaluation. The course culminates with a deal due diligence process that mimics an investment committee (IC) comprised of private equity leaders that understand the commercial and purpose-driven viability of an investment. Weekly Class Meeting 110 min x 14 = 1,540 min; Required Instructor Meeting (Category E) 60 min x 12 = 720 min; TOTAL = 2,260 min (for entire semester).
Data analytics have become an essential component of business intelligence and informed decision making. Sophisticated statistical and algorithmic methodologies, generally known as data science, are now of predominant interest and focus. Yet, the underlying cloud computing platform is fundamental to the enablement of data management and analytics.
This course introduces students to cloud computing concepts and practices ranging from infrastructure and administration to services and applications. The course is primarily focused on the development of practical skills in utilizing cloud services to build distributed and scalable analytics applications. Students will have hands-on exposure to VMs (Virtual Machines), databases, storage, microservices, and AI/ML (Artificial Intelligence and Machine Learning) services through Google Cloud Platform, et al. Cost and performance characteristics of alternative approaches will also be studied. Topics include: overview of cloud computing, cloud systems, parallel processing in the cloud, distributed storage systems, virtualization, security in the cloud, and multicore operating systems. Throughout, students will study state-of-the-art solutions for cloud computing developed by Google, Amazon, Microsoft, and IBM.
Weekly Class Meeting 110 min x 14 = 1,540 min; Recitations (Category A) 14 sessions x 50 min = 700 min; Discussion Forum (Category C) 1 session x 40 min = 40 min; TOTAL = 2,280 min (for entire semester)
This course uses a combination of lectures and case studies to introduce students to the modern credit analytics. The objective for the course is to cover major analytic concepts, ideas with a focus on the underlying mathematics used in both credit risk management and credit valuation. We will start from an empirical analysis of default probabilities (or PD), recovery rates and rating transitions. Then we will introduce the essential concepts of survival analysis as a scientific way to study default. For credit portfolio we will study and compare different approaches such as CreditPortfolio View, CreditRisk+ as well as copula function approach. For valuation we will cover both single name and portfolio models.
This is the recitation course associated with APAN 5450 Cloud Computing.
This course introduces students to how healthcare policy is created and implemented in the United States and abroad, while also raising critical ethical issues surrounding healthcare policy for the US, and other industrialized as well as poorer nations. Through lectures, discussions, and readings from the current literature, we will explore the political processes and concerns which produce our current policy; examine the major issues being debated surrounding the creation and delivery of healthcare, including ethical issues; explore the process by which we induce biomedical progress and development; explore barriers to sound healthcare production and delivery in various countries, and examine the recent reforms wrought through the Affordable Care Act (Obamacare). In addition, we will spend a few units looking, in detail, at the unusual challenges posed in delivering healthcare to the poor and the elderly.
Weekly Class Meeting 110 min x 14 = 1,540 min;
Discussion Forum (Category C) 12 sessions x 60 min = 720 min;
TOTAL = 2,260 min (for entire semester)
In today’s digital age, with the collection and usage of personal information growing at an exponential rate, the study of privacy risk management is crucial. As organizations grapple with the dual challenge of monetizing technological innovation without running afoul of regulatory and legal restrictions, the ERM professional who understands how to identify, assess, and manage privacy risk is in high demand. In this course, students will develop an understanding of the legal frameworks governing data usage, the ethical issues associated with the use of personal information, and how to develop robust privacy frameworks and controls in order to manage privacy risk.
Weekly Class Meeting 110 min x 14 = 1,540 min; Case/Project Team Work Feedback (Category E) 1 semester x 180 min = 180 min; Required Instructor Meetings (Category E) 50 min x 13 = 650 min; TOTAL = 2,370 min (for entire semester)
The objective of this course is to introduce students to interest rates models and to build step by step a coherent understanding of the interest rates world, from the stripping of a yield curve to the modern frameworks of option pricing. Adopting a practitioner’s perspective, it will put an emphasis on building a strong intuition on the products and models, and will adopt a balanced approach between formal derivation and concrete applications.
This course provides students with a comprehensive introduction to the legal, ethical, and public policy issues that shape the sports industry. Students will examine the complex legal challenges facing professional leagues, teams, athletes, event organizers, and other industry stakeholders while developing foundational skills in legal analysis, issue identification, and problem-solving. Key topics include antitrust, labor law, contracts, torts, intellectual property, dispute resolution, governance, compliance, risk management, and player health and safety. The course will also explore emerging issues such as Name, Image, and Likeness (NIL), sports betting, technology, media, discrimination, and international sports regulations. Through real-world cases and practical applications, students will develop an understanding of the legal frameworks and ethical considerations that influence decision-making across the sports industry. Format: Weekly Class Meeting 110 min x 14 = 1,540 min; Topical Review Sessions (Category A) 60 min x 3 = 180 min; Jurisdiction Review Discussion Posts (Category C) 5 sessions x 30 min = 150 min; Case Support (Category E) 45 min x 9 = 405 min; TOTAL = 2,275 min (for entire semester)