Derek Coursen

Adjunct Assistant Professor of Public Administration

Derek Coursen has extensive experience leading the management of information across the human service, justice and public health fields. His focus is on how systems thinking can clarify and resolve the complex challenge of designing information systems in public service settings. Derek has published articles in academic and professional venues on techniques for producing rich data to simultaneously serve diverse and fluid stakeholder purposes: program planning, front-line service provision, performance measurement, program evaluation, and fiscal administration.

After graduating from the University of Delaware, Derek spent six years in Central America working on educational and journalistic projects, followed by four years at Queens Library planning immigrant services and managing the library system's performance data. In 1998 he joined the Vera Institute of Justice, where he formed and led a department that carried out software development and performance measurement projects in juvenile justice, child welfare, substance abuse treatment, ex-offender re-entry, healthcare advocacy, crime mapping, court automation, and the intersection of race and prosecution. Derek joined Public Health Solutions in 2007, and currently directs planning and informatics for the administration of a large portfolio of public health contracts on behalf of the NYC Department of Health and Mental Hygiene.

Derek is a member of the Board of husITa (Human Service Information Technology Applications). He has been a technical advisor to many initiatives, most recently Measures for Justice, a nonprofit organization that promotes common performance measures for the U.S. justice system; and Open Referral, a project of Code For America that aims to make information about human service programs easier to maintain, share, find and use.

Derek holds M.S. degrees in management (NYU Wagner), information systems (Pace University) and information and library science (Pratt Institute).

Many roles in public and nonprofit organizations require staff to become sophisticated consumers, analysts and presenters of data. But before data can be used, it must first be specified and collected—and that is increasingly done via information systems.  

This upstream area is rife with complex problems. Data may seem hidden from stakeholders as if it were in a black box. Communication between non-technological staff and information system developers is often fraught. Data and information systems are frequently an arena of contention among different stakeholder groups including executive leadership, front-line workers and their supervisors, measurers of performance, evaluators, and funders. And information system projects are inherently risky.

This course will provide students with a deep level of literacy about upstream data so that they can be more effective stakeholders in information systems. The course teaches practical techniques for querying databases and for understanding the implications of the data architecture that underlies an information system.

The majority of the course focuses on developing a practical understanding of relational databases. Students will learn the essential elements of Structured Query Language (SQL) and practice writing basic scripts. They will learn how to read a data model and how to reverse engineer one from an existing database. They will also learn to consider the practical implications of definitions and taxonomies embedded in databases.

The course also addresses challenges that organizations face with procuring information systems. Students will become familiar with the tiered structure of information systems; the impact of data architecture on labor and financial cost; stages of information system projects; and factors that contribute to success or failure.

The course includes readings from the systems thinking traditions which are helpful for understanding the diverse ways of construing the boundaries and nature of the organizational environment; for understanding the virtues, limitations and pitfalls of common approaches to information system development; and for designing more effective, holistic and evolvable information systems.

Download Syllabus

Many roles in public and nonprofit organizations require staff to become sophisticated consumers, analysts and presenters of data. But before data can be used, it must first be specified and collected—and that is increasingly done via information systems.  

This upstream area is rife with complex problems. Data may seem hidden from stakeholders as if it were in a black box. Communication between non-technological staff and information system developers is often fraught. Data and information systems are frequently an arena of contention among different stakeholder groups including executive leadership, front-line workers and their supervisors, measurers of performance, evaluators, and funders. And information system projects are inherently risky.

This course will provide students with a deep level of literacy about upstream data so that they can be more effective stakeholders in information systems. The course teaches practical techniques for querying databases and for understanding the implications of the data architecture that underlies an information system.

The majority of the course focuses on developing a practical understanding of relational databases. Students will learn the essential elements of Structured Query Language (SQL) and practice writing basic scripts. They will learn how to read a data model and how to reverse engineer one from an existing database. They will also learn to consider the practical implications of definitions and taxonomies embedded in databases.

The course also addresses challenges that organizations face with procuring information systems. Students will become familiar with the tiered structure of information systems; the impact of data architecture on labor and financial cost; stages of information system projects; and factors that contribute to success or failure.

The course includes readings from the systems thinking traditions which are helpful for understanding the diverse ways of construing the boundaries and nature of the organizational environment; for understanding the virtues, limitations and pitfalls of common approaches to information system development; and for designing more effective, holistic and evolvable information systems.

Download Syllabus

Many roles in public and nonprofit organizations require staff to become sophisticated consumers, analysts and presenters of data. But before data can be used, it must first be specified and collected—and that is increasingly done via information systems.  

This upstream area is rife with complex problems. Data may seem hidden from stakeholders as if it were in a black box. Communication between non-technological staff and information system developers is often fraught. Data and information systems are frequently an arena of contention among different stakeholder groups including executive leadership, front-line workers and their supervisors, measurers of performance, evaluators, and funders. And information system projects are inherently risky.

This course will provide students with a deep level of literacy about upstream data so that they can be more effective stakeholders in information systems. The course teaches practical techniques for querying databases and for understanding the implications of the data architecture that underlies an information system.

The majority of the course focuses on developing a practical understanding of relational databases. Students will learn the essential elements of Structured Query Language (SQL) and practice writing basic scripts. They will learn how to read a data model and how to reverse engineer one from an existing database. They will also learn to consider the practical implications of definitions and taxonomies embedded in databases.

The course also addresses challenges that organizations face with procuring information systems. Students will become familiar with the tiered structure of information systems; the impact of data architecture on labor and financial cost; stages of information system projects; and factors that contribute to success or failure.

The course includes readings from the systems thinking traditions which are helpful for understanding the diverse ways of construing the boundaries and nature of the organizational environment; for understanding the virtues, limitations and pitfalls of common approaches to information system development; and for designing more effective, holistic and evolvable information systems.

Download Syllabus

Many roles in public and nonprofit organizations require staff to become sophisticated consumers, analysts and presenters of data. But before data can be used, it must first be specified and collected—and that is increasingly done via information systems.  

This upstream area is rife with complex problems. Data may seem hidden from stakeholders as if it were in a black box. Communication between non-technological staff and information system developers is often fraught. Data and information systems are frequently an arena of contention among different stakeholder groups including executive leadership, front-line workers and their supervisors, measurers of performance, evaluators, and funders. And information system projects are inherently risky.

This course will provide students with a deep level of literacy about upstream data so that they can be more effective stakeholders in information systems. The course teaches practical techniques for querying databases and for understanding the implications of the data architecture that underlies an information system.

The majority of the course focuses on developing a practical understanding of relational databases. Students will learn the essential elements of Structured Query Language (SQL) and practice writing basic scripts. They will learn how to read a data model and how to reverse engineer one from an existing database. They will also learn to consider the practical implications of definitions and taxonomies embedded in databases.

The course also addresses challenges that organizations face with procuring information systems. Students will become familiar with the tiered structure of information systems; the impact of data architecture on labor and financial cost; stages of information system projects; and factors that contribute to success or failure.

The course includes readings from the systems thinking traditions which are helpful for understanding the diverse ways of construing the boundaries and nature of the organizational environment; for understanding the virtues, limitations and pitfalls of common approaches to information system development; and for designing more effective, holistic and evolvable information systems.

Download Syllabus

The goal of this course is to prepare non-technical stakeholders working in the human service, justice and public health arenas to participate effectively in decision-making about information management practices and tools. Using a framework of general systems concepts to explore organizational and technical issues, the course will address how various roles—clients, front-line workers and supervisors, performance measurement staff, evaluators and funders—conceive of useful information; the challenges of developing information management capacity and acquiring information systems; and the context and implications of creating comparable measures and/or integrating data across multiple programs and agencies. The course is designed to enable students to understand differences between various stakeholder groups’ desire for and use of information; analyze the costs required to collect data and produce information; become familiar with the structure, development and customization of software; and the factors that contribute to success or failure. Students will also learn to understand the particular complex problems that client-serving agencies face around competing internal priorities, software acquisition, reporting to external funders, integration of data across multiple programs, and managing change; and learn how emerging trends in shared measurement and data integration may affect agencies.

Download Syllabus