Module 0
1. Introduction to Databases
2. Data, Databases, and DBMSs
3. The Conceptual Design
4. Refining the Design
5. Implementing the Design
6. Introduction to SQL
7. Physical Data Storage
8. Database Management
9. Database Administration
10. Data Uses and Issues
11. Databases and the WWW
12. Advanced Database Topics
Online IST Print Library
IST Solutions Exchange
Angel Course Materials Includes Calendar, oOnline Quizzes, Assignments, Handouts, O
Course Policies and Grading
 
 
 
  Online IST 210 : Section 1
December 20 2007
 

Welcome to the syllabus for Online IST 210: Organization of Data! Online IST 210 brings databases to life with a unique approach that focuses not only on constructing databases and using database tools, but also the implications of data uses and issues.

This site is simple to navigate. You will find links to the primary topics of Online IST 210 in the course topics navigation window to the left. In addition to the direct links to course topics, you will find in the course components window; links to the Online IST Roadmap: an essential document to your success, a link to the course content interface: a flash-based course content browser, a link to Penn State's course communication space: ANGEL, and a link to the IST Solutions Exchange: an access point to extended Online IST learning opportunities and resources. In addition to that, there are also navigation windows providing direct access to course related assignments, labs, and resources.


Instructor Information


Instructor:**************************************************************************
Instructor Home Page                                 
Charlotte Eudy McConn, M.S., CDP                      Office: 145 CLRC Bldg (Click to see a map)
Instructor in MIS, IST, CmpSc                             Spring Office Hours: MW: 1-1:45pm, R: 3-4pm
Associate Degree in Business Co-ordinator                                 M: 5:30-6:00,by appt only
Division of Business & Engineering
Penn State University, Altoona College             Phone: 814-949-5292
Ivyside Drive, Altoona, Pa 16601                       

Assignments will be distributed using the 'Angel' course managagement system at cms.psu.edu.

**************************************************************************

You will need the Adobe Acrobat Reader Plug-in, the Macromedia Flash 6 plug-in and the Apple QuickTime Plug-in to take full advantage of this course. These are all free downloads. To obtain more information pertaining to Online IST, visit the IST Solutions Exchange.

Course Overview

This is an introductory course used to teach the fundamentals and basic principles of databases and their related technologies. Throughout this course, students will explore the areas that are fundamental to the design, development, and implementation of enterprise wide information systems. Throughout their exploration, students will develop an understanding of the social, ethical, and legal issues surrounding such implementations.

In this course, we will cover the following major topics:

  • Introduction to Databases
  • Data, Databases, and DBMSs
  • The Conceptual Design
  • Refining the Design
  • Implementing the Design
  • Introduction to SQL
  • Physical Data Storage
  • Database Management
  • Database Administration
  • Data Uses and Issues
  • Databases and the WWW
  • Advanced Database Topics

Course Goals

  • Provide an introduction to databases and database technologies
  • Provide the steps of the database creation process
  • Demonstrate the fundamentals of SQL
  • Present issues relating to database management and administration
  • Understand the implications and future directions of databases and database technologies

Course Objectives

Upon completion of this course, each student should be able to:

  • Discuss the importance of data, databases, and database management.
  • Describe the various types of databases and database management systems.
  • Create a conceptual database design.
  • Refine a conceptual database design.
  • Implement a database design.
  • Design SQL queries that will be used to create and manipulate data from within a database.
  • Describe how database data is stored.
  • Discuss the major issues revolving around database management systems.
  • Explain the role of a database administrator.
  • Discuss the major uses and issues around using databases.
  • Summarize how the World Wide Web utilizes databases.
  • Identify future trends in database management systems

Assignments and Grading

Link to Prof. McConn's Class Policies

IST 210 - Grading Percents:

Tests & lecture assignments: 55%, Lab work: 40%, Angel practice quizes 5%

Tentative Class Schedule and Course Outline

Can be found on the Angel Course calendar at cms.psu.edu

Academic Integrity Policy (According to the Penn State Principles and University Code of Conduct):

Academic integrity is a basic guiding principle for all academic activity at Penn State University, allowing the pursuit of scholarly activity in an open, honest, and responsible manner. In according with the University's Code of Conduct, you must not engage in or tolerate academic dishonesty. This includes, but is not limited to cheating, plagiarism, fabrication of information or citations, facilitating acts of academic dishonesty by others, unauthorized possession of examinations, submitting work of another person, or work previously used without informing the instructor, or tampering with the academic work of other students.

Any violation of academic integrity will be investigated, and where warranted, punitive action will be taken. For every incident when a penalty of any kind is assessed, a report must be filed. This form is used for both undergraduate and graduate courses. This report must be signed by both the instructor and the student, and then submitted to the Senior Associate Dean.

Affirmative Action & Sexual Harassment Policy:

The Pennsylvania State University is committed to a policy that all persons shall have equal access to programs, facilities, admission, and employment without regard to personal characteristics not related to ability, performance, or qualifications as determined by University policy or by Commonwealth or Federal authorities. Penn State does not discriminate against any person because of age, ancestry, color, disability or handicap, national origin, race, religious creed, gender, sexual orientation, or veteran status. Direct all inquiries to the Affirmative Action Office, 211 Willard Building.

Americans with Disabilities Act:

IST welcomes persons with disabilities to all of its classes, programs, and events. If you need accommodations, or have questions about access to buildings where IST activities are held, please contact us in advance of your participation or visit. If you need assistance during a class, program, or event, please contact the staff or faculty member in charge of your IST department.

An Invitation to Students with Learning Disabilities:

It is Penn State's policy to not discriminate against qualified students with documented disabilities in its educational programs. If you have a disability-related need for modifications in your testing or learning situation, your instructor should be notified during the first week of classes so that your needs can be accommodated. You will be asked to present documentation from the Office of Disability Services (located in 116 Boucke Building, 863-1807) that describes the nature of your disability and the recommended remedy. You may refer to the Nondiscrimination Policy in the Student Guide to University Policies and Rules.

[Top]