SOLANO COMMUNITY COLLEGE

neckafterthoughtAI and Robotics

Dec 1, 2013 (3 years and 11 months ago)

148 views

Page
1

of
7


SOLANO COMMUNITY COLLEGE



COMPUTER AND INFORMATION SCIENCES 78


DATABASE MANAGEMENT SYSTEMS



INSTRUCTOR
: Earl T. Wylie, Ph.D.


PHONE
:


864
-
7000 voice mail box
4
662


EMAIL


earl.wylie@solano.edu

Data Files
http://bcs.solano.edu


M:

Class outline:

Http://earl.wylie.solano.edu

Software Purchase:
www.collegesoftware.org

http://dreamspark.com



OFFICE HOURS
: Room 514

To be Announced



CLASS
DATES
:
1/14/13 to 5/22/13


CRN
-
11080

CLASS ROOM:

503


CLASS TIME
:
11
:00 to
12
:
15

TTh



LAB HOURS
:
room 507 or 504
.


”Lab hours may be scheduled or TBA depending on the section.


Students are expected to complete both
the lecture and lab portions of the
course
.”


All students are required to use the computer lab

an average

of 1 hour a week for a total of 16 hours but not all 16 hours in one week. (Summer School has the
Lab Built In) You must log in on the lab attendance computer prior to entering the lab

and as you
leave the lab during hours when an instructor is on duty. If you forget to log out you will only
receive 15 minutes on the attendance computer. Yes, you can do more than one hour a week but
you must do an hour a week.




REQUIRED TEXT


Adamsk
i, J, & Finnegan,K.
New Perspectives on

Microsoft Access
2010

Comprehensive
. Course Technology,
Cambridge, MA
. 2012
. ISBN
978
-
0
-
538
-
79847
-
1


The first two tutorials of this book cover Windows
. These

chapters will not be covered in lectures in this class
.
If you have any questions on Windows please feel free to ask during class.


SOFTWARE USED:

MS Access
2010


MATERIAL REQUIRED

USB Chip aka flash drive

3
-
882 scantrons.


OBJECTIVES


Page
2

of
7

1.

Comprehend relational database concepts and database design.

2. Work
with Tables, Forms, Queries, Reports, Macros, and Modules

3. Understand the process of setting up a data base.

a.

Identify all fields/attributes of the fields

b.

Group field into tables

4
. Integrity Issues
-

Referential, Domain, Entity, Normalizing, one to man
y, one to one, many to
many..

5
. Work with data types and Assign properties to each field.

6
. Work with data types and properties

7
. Relate multiple tables

8
. SQL
-

Introduction

9
. Automating task with Macros and Modules (Visual Basic)


10
. Print database documentation, encrypt and decrypt, set password, link databases, set user profiles and
security.


In the classroom we will work though a
Chapter/Tutorial a week. Online students, you should do the sam
e.




GRADING


Test
-

Level 1 = 100

Test
-

Level 2 = 100

Test
-

Level 3 = 100

Labs 1 to 14 = 140

Lab 15 = 100


Total 540


Lab assignments 1 to
15
, Level 1, Level 2, and Level 3 exams will determine your final grade. Th
e following
scale of total points will be used to assign course grades:



90
-
100%

A

Excellent >=4
8
6


82
-
91%

B

Good >=4
3
2


70
-
81%

C

Satisfactory >=378


60
-
69%

D

Passing >=324


0
-
59%

F

Failure <324

H
ome work:

Page
3

of
7

Write
a two page single spaced essay on each of the
following films.

Discuss the impact that this developing
technology will have on your life.

From
http://earl.wylie.solano.edu


1. Click on the DARPA link and pick

out 10 and view from
the list of short films.

2. Click on the Beyond Human link and view all 9 short
videos.

3. Click on the Developing Brain link and view film.

4. Click on the Social robots, Cybernetics, and 6
th

sense
device at MIT and view short films

5. From Netflix The Great Robot Race view the entire film.


CIS78 LAB ASSIGNMENTS
Data Files


1. From your home you will type in
http://bcs.solano.edu
.

2. Click on
H:

drive.

3. Click on
Ewylie

4. Click on
CIS 78

5. C
lick on access
2010
files


You will see as you scroll down:


5. Right Click on
Access1 or access2 or acces3.


Access1 files are for chapters 1
-
4

Access2 files are for chapters 5
-
8

Access3 files are for chapter 9
-
12

6. Click on
tutorial folder

or review
folder or case folder.

7.
Right click on a file name and save target as.

Page
4

of
7

8. Navigate to where you want the file to be saved.


Note: you will have to download each file individually.


From the c
lassroom or computer lab on main

campus

These files will be available on
H:
\
ewlie
\
cis78
\
access2010files

Access1 files are for chapters 1
-
4

Access2 files are for chapters 5
-
8

Access3 files are for chapter 9
-
12


Class outline is on
earl.wylie.solano.edu



All lab assignments will have the
students name, class, instructor, and date in the top right hand corner of the
assignment. All assignments larger than one page will be stapled in the top left hand corner. All lab
assignments must be completed and turned in. The following lab assignment
s are required:


All labs are to be turned in at th
e beginning of class on th
e day
that they are

due. Labs
not turned in at the time they are due will receive no credit


0 Note you must
do step 1 through all steps of each lab. Additionally you must do a
ll the
preceding chapters of
Case 1 Pine Hill Music.

in order to turn in the
assignment

for chapter 4, 7, and 11.


I suggest that you first work through each tutorial which will build up your skill set to
do the assigned labs.



Lab


Due Date

a.

Project Outline


Use guidelines on pages
AC
46
to
AC
50

Identify all

b.


the fields needed.

Do not confuse the project outline with


the final project

guide
lines at the end of the document
.

c.

Group related fields into tables

d.

Determine each table’s primary key

e.

Include a common field in related tables

f.

Avoid data redundancy

g.

Determine properties of each field.

h.

Prepare an entity relationship diagram
-

AC A
10

to A
C A11.


1/24/13

1. Page
AC42
-
43

Review Assignments
turn in step 10
-


1/31/13

2. Page
AC98
-
99


Review Assignments
turn in step
9

2/7/13

3. Page
AC158
-
59


Review Assignments
turn in step 14

2/12/13

4. Page
AC205
-
6

Review Assignments
turn in step
20
.


2/28/13

5. Page
AC206
-
7


Pine Hill Music

Case 1
Turn in step
19


Note: You
must do the


P
revious

Chapters
Pine Hill Music case

assignment in order to turn this
one in. This is
This is
also true for Lab 9 and Lab 14.


6. Page
AC274
-
75

Review Assignments
Turn in step 13

3/7/13

7. Page
AC350
-
51

Review Assignments
Turn in step 8i Print out the
form frmcompnieswithproducts.

3/14/13

8. Page
AC408
-
09

Review Assignments
Turn in step 6d. Print out the
report rptcompanymailinglabels.


3/21/13

9. Page
AC464



Review Assignment Turn in step 9 The PivotChart


3/28/13

Page
5

of
7

10. Page AC
4
65

Pine Hill Music Case 1 Step

7

Pivot Chart


4/11/13

11. Page
AC
512

Review Assignment
Step 9

4/18/13

12. Page
AC
564

Step
3

Use
AltPriScn

to capture the

FrmNavigation

and paste into word at the end of
3



4/25/13

13. Page
AC
606

step 4 b Capture the

procedures

frmcompanywithproducts and frmproduct
word
into word and

print

5/2/13

14. Page
AC606

Pine Hill Music Case
capture the

procud
ures

frmteachersandconctrtact
and

frmcontract

paste into word.

5/9/13

15. Final Project: Create a database project of your own choosing.

5/14/13






When the student first begins to use the tutorial database they must save all of the tables, queries,

reports,
forms, and macros created
.

Due to conflicts with advance macros and visual basic there wi
ll be no spaces in
module names or field names.

Furthermore, all forms and reports created by the student will have a label box
in the form or report head
er with the students name, class, date, chapter, page and lab number. The text will
be colorful.



Make up of missed exams and extra credit work by arrangement with the instructor.


Class Schedule

Important Dates:



Date

Activity

1/14/13

Class begins

1/21/13

MLK

2/14/13

Flex cal
-

no class

2/15/13

Lincolns birthday

2/18/13

Washington’s Birthday

㈯ㄹ⼱2

c汥x⁃慬


no⁣污ss

㈯㈶⼱2

䱥癥vne⁥x慭a

ch慰t敲‱ 瑯‴†

㌯ㄳ⼱3

c汥x⁃慬


no⁣污ss

㐯4
-
㔯ㄳ

印物p朠䉲敡k

㐯㤯ㄳ

䱥癥v⁴wo⁥x慭
-

cha灴e爠
㔠5o‸

㔯ㄶ
-
㈲⼱2

c楮慬s

㔯㼯ㄳ

c楮慬⁅ 慭aㄱ㨰〠Woom‵〳⁃ha灴e爠㤠瑯‱






CIS 78 Final Project Guide Lines

These are the items that will be graded on for the final project.
All reports and forms will have your company
logo on it and grand totals
in the report footer. Online students you will put entire database, including the data
access page in the drop box. You must have a least 30 records in the database.



Remember because you meet the minimal guidelines does not mean you received all 60 poin
ts.


1.

Tables


Field types

Page
6

of
7

a.

Text

b.

Number

c.

Auto number

d.

Date/Time

e.

Yes/No

f.

OLE

g.

Hyperlink



i.


Word


ii.


Excel

iii.


Http:


iv.


JPG, GIF, BMP, JPN

v. e
-
mail

vi. bookmark

h.

Lookup Field

i.

Attachment

j.

Currency

k.

Memo

l.

Number

m.

Primary Key

n.

Foreign Key

2.

Forms

a.

Custom form

b.

Sub form

c.

Query list box

d.

Reports list box


e.

Navigation form


3.

Queries

a.

Select query

b.

Aggregate

c.

Action

i.


Delete

ii.

Append


iii.

Update


iv.


Make table

d.

Calculated Fields in query

e.

Criteria


i.



Relation operators


ii.


And, or

iii.


Like, between, in()

iv.


*, ?

f.

Parameter Query


4.

Reports

Report Header


Date


Logo


Report Writer

a.

Page Header
-

labels

b.

Group Header


at least one.

c.

Detail

d.

Group Footer


calculated fields

e.

Report footer


calculated fields

f.

Page Footer

g.

Report based on table

h.

Report based on query

5.

Macros

a.

frmnavigation

Page
7

of
7

b.

reports list box

c.

query list box

d.

event procedures

6.

Modules

a.

Function

b.

Sub procedure

c.

Event procedures

d.

Form event procedures

7.

Relationships

a.

One to many

b.

One to one

c.

Many to many

d.

Right outer

e.

Left outer

f.

Inner

g.

Self Join

8.

Startup



a.

User unable to change anything.

b.

One entry point and one exit point out of the program.

c.

Navigation form is displayed on start up.

d.

Compa
ct