First Day Orientation

1
First Day Orientation

• Simple Quiz to Survey Knowledge

2
First Day Orientation

• Introduction
• Text Book
• Simple Quiz
• Syllabus

• Course Objectives
• Grade Determination
• My Availability

3
Introduction

• Mr. Brian Goldberg - Programmer
• M-CARE, Corporate Services
• STATPROBE, Statistical Reporting
• MEDSTAT, Data Conversion
• Computer Sciences Corporation, EPA

4
Introduction

• Taught Computer Science I and II
• Taught Introduction to Computers
• Taught Windows 95
• Taught DOS

5
Education

• M.A. Math/CS, EMU
• B.S. Math/Stats, Carnegie Mellon University,
  Pittsburgh, PA

6
Text Book

• Running Microsoft Access 97
• by John L. Viescas
• Publisher Microsoft Press

7
Simple Quiz to Survey Knowledge
8
Syllabus

• 1/6 Introduction
• 1/13 Introduction to Databases
• 1/20 Building
• 1/27 Modifying
• 2/3 Datasheets
• 2/10 Queries
• 2/17 Action Queries

• 2/24 Midterm
• 3/2 Spring Break
• 3/9 SQL
• 3/16 - 3/23 Forms
• 3/30 - 4/6 Reports
• 4/13 - 4/20 Macros
• 4/20 Final Exam

9
Course Objectives

• Building Databases
• Modifying Databases
• Using Datasheets
• Using Queries
• Using Action Queries

• SQL
• Forms
• Reports
• Macros

10
Good Study Habits

• Class Attendance / Discussion
• Complete assigned reading
• Projects completed on time
• Study for the Mid-Term and Exam
• Ask questions about Access

11
Grade Determination

• Four projects
• first simple project 60 points
• project on SQL 60 points
• project on Forms 60 points
• project on Reports 60 points

12
Grade Determination

• Project 240 points
• 12 points extra credit for being early
• 6 or 12 points off for being late
• Mid-Term 100 points
• Final Exam 100 points
• Maximum 96 point for attendance (3 points/ roll,
  roll is taken twice each class)

13
Index Cards

• Name / student number
• Hobbies
• Contact information/times/phone/e-mail
• I will make a class e-mail distribution list for
  e-mail only (I will not distribute name/numbers
  and student numbers)