Computer Science 103 (Databases)                                            Mrs. Marjorie Yarger

Microsoft Access 2010 software                                                    Spring Semester 2013

Erin Nanovic, TA

 

Required Text:            Microsoft Office 2010, Access by Timothy and Linda O’Leary

 

Course Content:         Basic vocabulary and concepts in computer science;

Social and ethical issues involving the use of computers; history of computing;

Creation of a personal home page using Google docs; Microsoft Access 2010

 

Labs:   There are 8 lab assignments, each worth 15 points. Completed assignments are due on the dates listed on the back of this sheet. Late assignments will be marked down 1 point for each late class day. Assignments and classwork are saved into your own account on the H: drive of the Saint Mary’s computer network.

 

Projects:          One independent case project is assigned (100 points). Each student will do this by herself with consultation from the teaching assistant or instructor.

 

Exams:            There is one in-class midterm (100 points) on April 4th, and a final exam (100 points). The Final Exam will be Monday, May 6th at 10:30 in the classroom.

 

Papers:           2 papers are required. They are worth 15 points each. See the back of this sheet for due dates. See the paper assignment sheet for details.

 

Attendance:     Students are expected to attend all classes. If an absence occurs, the student must make up any missed work Before the next class. If an emergency or illness arises which results in a class being cancelled, the mathematics Department Administrative Assistant will make an announcement to the class.

 

Honesty Policy: You may ask questions and discuss the lab assignments with the teaching assistant, your classmates, or any faculty member, but the work you turn in must be your own. You may not copy anyone else’s work. You must design your own databases and solve all problems in this course. The academic honesty policy (The College Bulletin pp. 64-66) is enforced in this class.

 

Disability Statement: Any student who is eligible for accommodations to complete the requirements and expectations of this course because of a disability is invited to make her needs known to the instructor and should also contact Iris Giamo (x4262) to arrange for appropriate accommodations.

 

Grading           405-450                       A- to A range

Scale:              360-404                       B- to B+ range

                        315-359                       C- to C+ range

                        270-314                       D- to D+ range

 

Office:             340 Madeleva Hall                  Office Phone:    4551

Email: myarger@saintmarys.edu      Home Phone:    269-445-3940

CPSC 103 Home Page: http://www.saintmarys.edu/~myarger

 

Office             9:30-10:45 AM and 12:30-2 PM Tues. and Thurs,  

(First Tuesday of every month, 2-3PM), Other times by appointment.

                                         CPSC 103 Assignment Schedule

 

Date:         Readings/ Labs Completed:

Assignment(s) Due:

2/19   

 

2/21     Review handouts, purchase textbook

 

2/26     O’Leary Lab 1

 

2/28     O’Leary Lab 2

Lab 1 Exercise #5 (3); O’Leary page AC1.80 (1) and AC1.83 (1) printouts

3/5       O’Leary Lab 3

 

3/7     O’Leary Lab 4

Lab 2 Exercise #5 (1); O’Leary page AC2.79 (1) printouts

3/12 & 3/14   Spring Break   

                                                             

3/19    

Lab 3 Exercise #5 (1); O’Leary Page AC3.39 (1), AC3.46 (1), and AC3.68 (2) printouts

3/21    O’Leary Lab 5

3/26   O’Leary Lab 6 pages AC6.1-AC6.42,  also pages AC6.58-AC6.62

Lab 4 Exercise #5 (1 landscape); page AC4.53 (2) and AC4.54(1) printouts

 

3/28 

Lab 5 Exercise #5(1, landscape); page AC5.58 (1) printouts 

4/2    

Lab 6 Exercise #5 a-e (1); page AC6.42 (3) and AC6.62 (1) printouts

4/4      

 

Access Midterm through O’Leary Lab AC6.62 (Labels)

4/9      O’Leary Working Together 1; and O’Leary Working Together 2 (pages                    ACWT2.1-ACWT2.9 only)

Create macros for the Software Orders Form (1), EduSoft Titles Form (1) and the Software Package Sales Report (1) in LearnSoft Titles.accdb; Create 3 switchboards (3); and Create the switchboard items table (1). 7 printouts.

4/11     

4/16

Access Case Project Due

4/18   Read the ACM Code of Ethics

           

Lab ACWT1 Exercise #3 (1); O’Leary page ACWT1.6 (1) and ACWT1.12 (2); Lab ACWT2 Exercise #1 (1); Sports Company Web Page from class work (1). 6 printouts.

4/23

Paper 1 due (biography paper)

4/30

 

Paper 2 ( ethics paper)

5/2

 

5/6

Final Exam, in the classroom, 4:15-6:15