Austin Community College

Northridge Campus

Course Information: COSC 1300 - Introduction to Computers
Spring 2004
16 week Session

 

Section

Room

When

 

 

 

 

 

 

 10511

4211

Tu-Th. 10:35 -11:50 AM

 

 LAB - Room 4230

Th        12:00 -12:50 PM

 

Instructor

E-Mail

Phone

Bob Bauhs

rbauhs@cs.com

223-4760

Office Hours

 By Appointment

252-8126

 

  

I.      Course description:

 

This course is a survey course. It lays a foundation by discussing computing terminology, components, software, programming concepts, the world wide web, ethics and the computer's integration into business activities.  Laboratory experience includes Windows, word processing, spreadsheet, and database software. Presentations using either Power Point or a Web Page are required.

 

 II.      Course objectives: To:

 

A.    Be able to understand what is being written about computer technology.

B.     Understand what a computer program is, and to distinguish between the different types of software.

C.     Understand the Internet and World Wide Web.

D.  Understand in general what a computer is, and what it can and cannot do.

E.    Have a general understanding of system analysis and design.

F.   Become familiar with the most popular personal computer software packages.

G.   Learn to express yourself using Microsoft Office software

 

III.      Course materials:

 

(1)   Text-Understanding Computers: Today and Tomorrow, 2002 Edition by Charles Parker & Deborah Morley.

(2)   Lab-Microsoft Office XP Brief Concepts and Techniques by Shelly, Cashman, and Vermaat.

(3)   Two floppy diskettes or one zip diskette.

(4)   Web site at: www.course.com/parker2002              (for text)

(5)   Web site at: www.scsite.com/offxp                          (for lab)

(6)   Web site at: www.austincc.edu/rbauhs                    (for web site)

 

 IV.       Course Requirements:

 

A.     Class attendance - Students are expected to attend all classes. If the student misses a class or is tardy, it is the student's responsibility to get assignments and missed material.

 

B.     Lab attendance - Lab attendance is required unless authorized by the  instructor.

 

C.     Lab assignments - During the semester you will be given lab assignments related to Microsoft Windows XP and Microsoft Office XP. Each assignment is due at the end of the testing period for that subject. In addition you will be expected to prepare an original presentation.

 

D.     Lab grading – only half credit will be given for late assignments. No credit will be given for assignments over 1 week late or for assignments submitted after the last day of class. Students are strongly encouraged to turn in each assignment as soon as it is completed. Negative points will result if a lab topic is not attempted.

 

E.      Copying someone else's work is not allowed. If the instructor determines that work has been copied, disciplinary action will result which could include referral to the College Dean.

 

V.           Examinations:

 

Four major examinations and one major presentation will be given during the semester.  If you miss an exam, a make-up exam will be given for excused absences only.  Contact the instructor before or immediately after the emergency that causes you to miss the exam to arrange for a make-up.  Graded examinations will be kept on file by the instructor. Exams will be reviewed during the class immediately following the test and/or by appointment.

 

VI.       Semester Grades:

 

A.     Grade Breakdown

Examinations (4 @ 20% ea)

80%

Labs

20%

Total

100%

A - 90% to 100%

B - 80% to   89%  

C - 70% to   79%

D - 60% to   69%

F - Below     60%

 

You must score 60% or above to pass this course.

 

WITHDRAWALS

 

A student may withdraw from this class or any class they are enrolled in by filling out a withdrawal from at any ACC Admissions and Records office.

 

                                    LAST DAY TO WITHDRAW, April 19, 2004

 

VII. Intended Schedule

 

 

Class

Date

Topic

Lab

1

Tue Jan 13

Orientation + INT 2 (Using your PC) (pp 37-50)

 

2

Thu Jan 15

INT1 (Intro to Computers)

Windows

3

Tue Jan  20

SW6 (Systems software)

 

4

Thu Jan 22

SW7 (Application  Software)

Explorer

5

Tue Jan 27

**** Exam 1 ****

INT1& INT2, SW1& SW2

 

6

Thu Jan 29

Database Management (chapter 14)

ACCESS

7

Tue Feb 03

HW3 (The system unit)

 

8

Thu Feb 05

HW3 (continued)  & ACCESS QBE

 ACCESS

9

Tue Feb 10

HW4 (Secondary Storage)

 

10

Thu Feb 12

HW5 (Input and Output)

ACCESS

11

Tue Feb 17

Review Day

 

12

Thu Feb 19

***Exam 2 ***

ACCESS, HW 3,4,5

ACCESS Due

13

Tue Feb 24

Net8 (communications & networks)  plus WORD

 

14

Thu Feb 26

NET 8 & Net 9 (The Internet)

WORD

15

Tue Mar 02

Net 10 (Web Page Design)

 

16

Thu Mar 04

Net 11 (E-Business & E- Commerce

WORD

17

Tue Mar 09

Review

 

18

Thu Mar 11

***Exam 3***

WORD, NET 8,9,10,11

Word Due

 

 

Spring Break
 

19

Tue Mar 23

IS12 (Information Systems)
 

20

Thu Mar 25

IS12 plus EXCEL

EXCEL

21

Tue Mar 30

IS12 & IS13 (program development)

 

22

Thu Apr 01

Self study day

EXCEL

23

Tue Apr 06

Visit to Fry’s (special assignment)

 

24

Thu Apr 08

Excel

Excel

25

Tue Apr 13

Social issues (LIV15)

 

26

Thu Apr 15

***Exam 4 ***

 

EXCEL, IS 12&13, LIV15

EXCEL due

27

Tue Apr 20

Power Point + Presentation Prep

 

28

Thu Apr 22
Prep

Prep

29

Tue Apr 27

Presentations

 

30

Thu Apr 29

Presentations

Presentations

31

Tue May 04

Presentations done

 

32

Thu May 06

Any Make Up

THE END

 All done

VII.           Lab Assignments-Microsoft Office XP 2002 Work Book-Shelly Cashman Vermaat

Due dates are shown under the Lab Column of the Intended Schedule.

 

Windows (1 PTS)

Required to create the basis for all other LAB work

 

Fundamentals of Using Windows

 

...Read and Do exercises from pages INT 1.10 to INT1.30

 1 point

...Send me an E-Mail

 

Using Windows Explorer

 

...Read and Do exercises from pages INT 1.30 to INT1.42

 

   See “Help” features in Appendix “A”. Do problem 1 on page MO A.12

Access (14PTS)

Creating a Database using Design and Datasheet Views

2 points

Read and Do the “Alisha Vending Services” exercises from pages A 1.06 to A 1.49

3 points

Do "Cases and Places" # 2 about “Baseball logo” on page A 1.63

A.  Look for ways to normalize the data. Create a form for the table(s). Design a report to print Item, Description, On Hand, and Supplier number.

3 points

Do the following queries on the Baseball data base.

.1. Display the description., cost and units on hand, & supplier name of all items supplied by Beverage Holders.

2. Display item id, description, units on hand, selling price of all items selling for more than $15.00.

3. Display item id, description, units on hand, supplier name & telephone number if there is less than 10 units on hand.

4. Display the description, cost and selling price, sorted in descending order by selling price.

5. Display the description, on hand, selling price, supplier name if: on hand is greater than 10 and price is greater than $5” or the supplier is “AC”

6. Repeat display # 5 if the on hand is greater than 10 and price is greater than $5 and the supplier is “AC”

6 points

Special assignment from the instructor on test day

Word (12 PTs.)

Creating and Editing a Word Document

2 points

Read and Do “Sail the Waters” exercises from pages WD 1.19 to WD 1.61

3 points

Eagle HS will be celebrating their 25th reunion this year. Prepare an attractive 1 page announcement to be sent to class members. Include a graphic of the school’s mascot, an eagle. The reunion will be held at Fisher Country Club and will feature live entertainment by the Jazzicians, a local band. The reunion will be held on Saturday, October 27. Doors open at 6:00 PM with dinner at 7:00PM, followed by entertainment from 8:00 PM to 11:00PM. Cost is $50 per person. It will be an opportunity to reminisce about old times, catch up with old friends and share future plans. More information can be obtained by calling Sue Nordic at 555-9808. Use the concepts and techniques you have learned so far to complete this assignment. Make good use of  “white” space, and consider using bullets and/or word art.

3 points

Use the resume wizard under the menu option “File”, “New” to create your resume.

4 points

Special assignment from the instructor on test day

Excel (14PTs.)

Creating a Worksheet and Embedded Chart

2 points

Read and Do “Dynamite Music” Exercises from pages E 1.17 to E 1.54

3 points

Do In the Lab assignment 3 about College Cash Flow on page E 1.61 and 1.62 (parts 1 & 2 only) . Skip paragraph 7 in part 1.

3points

Do "Cases and Places" # 5 about the “Virtual Reality Theatre” on page E 1.64. Add a percentage calculation to get the ratio to total revenue and compose a pie chart. Make your bar chart a stacked bar chart.

6 points

Special Project from the instructor on test day

 

 

Power Point (3 PTS)

Using a Design Template to Create a Presentation

3 points

Review Power Point features in your lab book from pages PP 1.06 through PP 1.64. Do the exercise plus add an animation scheme, some custom automation and a slide transition technique. Include some clip art and sound to get the full 3 points.

Presentation

 (17 points)

 

You can use either Front Page Express or PowerPoint as your presentation software. The presentation can be done either individually or in a 2 man team. The presentation should be based upon either:

 

The information in Chapter 16; “You and Your PC.”

 

 Or Project 9 on page 677 of your text.

 

 0r A Web Page Presentation of your resume.

 

You are encouraged to choose your own topic for approval by the instructor.

 

Standards for grading will be explained in class, but include Content (4), Organization (4), Use of software features (5) and Presentation skills (4).

 Due Dates

All Assignment Due dates are given in the Syllabus Schedule