Computer Applications in the Public Sector


Introduction

In the last several decades the computer has become one of the most important resources available to public and private sector managers. The computer’s ability to store, retrieve and manipulate large amounts of data rapidly and cheaply has led to its wide spread use in managing many clerical , accounting and service documentation functions in organizations. More recently, with the advent of management information systems (MIS), artificial intelligence (AI), expert systems and decision support systems (DSS), the computer is being used as an aid in making more and more complex decisions in unstructured situations. The rapid growth and importance of the role of computers for management makes this an important area for study.

Recently, the data base environment has emerged for using computers in public organizations to support decision making at the tactical, strategic and policy levels. In this environment, end-users (project managers, policy analysts, financial managers, and other non-computer specialists) directly use computers to quickly produce the information necessary for decision making. In the older file environment of computing, end-users depended on intermediaries (computer programmers and system analysts from the data processing department) to produce the necessary information. For many decisions, the file environment is a costly, inflexible, and slow approach to meeting information needs. The data base environment is thus a key to increasing efficiency and effectiveness in public management.

he data base environment has been made possible by recent developments in computer hardware providing relatively inexpensive but powerful computers, and by two software innovations: (1) the data base management system (DBMS) for managing the data base, and (2) end-user computing via very high level non-procedural computer languages and object oriented applications. DBMS make possible integration of data from multiple sources for multiple purposes by multiple users, while the new computer languages support computer use by non-computer specialist to retrieve and analyze data very quickly. In 1970 there was very little end-user computing, by 1980 it accounted for approximately 40% of computing in organizations, and by 1990 it has increased to 75 to 90% of computing in organizations. DBMS make the right data available and end-user computing provides appropriate tools for the effective conversion of data to information. This process should improve the quality of decision making in public organizations where it is successfully implemented.

Objectives

Provide an introduction to the design and use of data bases.

The course introduces the major data models, but focuses on the relational model, which is the easiest to use, and most flexible. Students learn the details of table operations (SELECT, JOIN, and PROJECT), and the normalization process for designing relational data bases. The course primarily makes use of ACCESS 2.0 under the Windows Operating System.

Build competence in end-user computing.

Students make use of both DOS and Windows Operating Systems, Word Processing Software, (Microsoft Word, etc.), Internet electronic, Spreadsheet Software (i.e. Excel, Lotus 1-2-3, Supercalc) and ACCESS 2.0 for hands-on experience in end-user computing applications. Through these experiences general problem solving techniques for working with computer will be developed.

Teach material on computers in the context of public sector problems

Mini-cases and projects will allow students to apply their skills to design and implement public sector data bases (e.g., fund accounting systems, public personnel systems, fire fighting and health inspection applications).

Expose students to problems of managing information systems in Public Organizations

Students review MIS literature and learn how public and private organizational differences result in different strategies for managing information systems in the public sector.

Introduce students to concept and techniques associated with Project Management

Students will learn about Critical Path Methods, Gantt Charts while making use of Window’s based project management software to manage database group projects.

Text Books:


Rob, Peter, and Carlos Coronel, DATABASE SYSTEMS: Design, Implementation, and Management, 2nd Edition Wadsworth Publishing Co.: Belmont, CA, 1995.
Viescas, John L., Running Microsoft Access 2 For Windows, Microsoft Press: Redmond, WA, 1994.

Prerequisites and Using Computers:

I expect each of you to know how to start and stop a workstation or personal computer as well as the basics of working in a Windows environment (i.e. point and click). I also expect each student to be able to make use of electronic mail (e.g. Eudora and/or Pine on the Mailbox system), Excel and some word processing software such as Word or WordPerfect.

A major difficulty in studying information technology is the heavy use of jargon like words which tend to confuse beginning students. One approach for dealing with this problem is to obtain an introductory text book on computers or management information systems which contains a glossary of terms. While such a book can be expensive it does provide a useful long term technical resource. In the past we have Mandell's, Computers and Information Processing. I have order a few copies of the most recent edition of this book for those of you who wish to acquire such a reference book. I will cover some these topics (at lightning speed) in the first week of the course.

As part of your general education in public management it is important for each of you to lean to manage various aspects of the electronic office. Therefore I will be making heavy use of electronic communications for various aspects of this course. For example I will be using EMAIL make various announcements to the class as well as communicating with each of you individually. I want to encourage you to make use of EMAIL to ask questions. I will also be sending out files that will be attachments to a standard EMAIL letter. These file documents will include lecture notes, homework assignment and other hand out materials, typically in the form of Microsoft Word documents. You may then make use of these either electronically or by producing your own hard copy versions.

SYLLABUS

  1. Review of Basics (Mandell or alternative text)
    1. Hardware/Software Review
    2. Operating Systems (DOS, Windows)
    3. Software Development and Programming
    4. EMAIL
    5. Word Processing
    6. Problem Solving
  2. Framework for Dealing with Multiple Application and Operating Systems
    1. Input to Process to Output
    2. Files, File Structures, File Coding
    3. Communicating Across Systems and Applications
  3. Software Design and Spreadsheet (Ronen, et al.)
    1. Spreadsheet Basics
    2. Role of Documentation
    3. Parameterization and an Example
  4. Introduction to Data Base Theory
    1. Overview of Data Base Management Systems (RC, Chapters 1, 12, 13 and V, Chapter 1, 2)
      1. Applications vs. Data Base Environment
      2. Components of DBMS
      3. The Data Base Administrator
      4. Client/Server Model
    2. Conceptual Data Models (RC, Chapters 2, 4, 14, 15)
      1. Entities, Attributes and Relationships
      2. Relational Model
      3. Hierarchical Model
      4. Network Model
    3. The Conceptual Model and Design Process (RC, Chapters 4, 5, 6, 7, 8 and V, Chapter 4)
      1. Surveying the User Community
      2. The Data Dictionary
      3. The Data Flow Diagram (Static vs. Dynamic Data)
      4. Relational Concepts for the Design Process
      5. Normalization
      6. DDL, DML and Query Languages
  5. Project Management and Ethical Issues in Computing
    1. Project Management (McKenna)I>
    2. Ethical Issues in Computing (Mason)

  6. Building Data Base Applications
    1. Reviews of Software and Computing Environments (V, Chapter 3)
    2. Introduction to ACCESS 2.0 (V, Chapters 5, 6)
      1. How ACCESS is structured
      2. Global Features
      3. Creating a Data Base
      4. Modifying a Structure
    3. Query Language (RC, Chapter 3, V, Chapters 7, 8, 9, 11)
    4. Entering and Editing Data with Forms ( V, Chapters 13, 14, 15)
    5. Creating Reports (V, Chapters, 16, 17, 18)
    6. Developing Applications and Modules (V. Chapters 19, 20, 21)
      1. Principles of Structured Programming
      2. Algorithm Design and Testing
      3. Programming Commands
      4. á

      5. Examples
  7. Public Management Information Systems