Austin Community College

Rio Grande Campus

Course Information: COSC 1300 - Introduction to Computers
Summer 2003
5 week Session

 

Section

Room

When

04221

110

M,T,W,Th 9:00-10:50 AM

 

LAB - Room 116

T,W,TH ..11:00-11:50 AM

 

 

 

 

 

 

 

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  news paper articles about computer technology.

B.     Understand what a computer program is, and distinguish between 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 Breif 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 book)

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

(6)   Web site at: www.Austincc.edu/rbauhs

 

 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, July 29, 2003

 

VII. Intended Schedule

 

 

Class

Date

Topic

Lab

1

Mon July 07

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

 

 

2

Tue  July 08

INT1 (Intro to Computers)

SW6 (Systems Software)

Windows

3

Wed July 09

SW6 (continued)

SW7 (Application Software + INT2 (pp50-70)

Windows

Explorer

4

Thu July 10

Review + Debate

**** Exam 1 ****

INT1, INT2, SW1, SW2

Start

ACCESS

5

Mon July 14

 

HW3 (The System unit)

 

 

6

Tue  July 15

HW4 (Secondary Storage)

Data Base Mgm (Chapter 14 +  QBE)

ACCESS

7

Wed July 16

HW5 (Input/Output)

ACCESS

 

8

Thu  July 17

Review + Debate

***Exam 2 ***

ACCESS, HW 3,4,5

 Lab test (Access)

9

Mon July 21

NET 8 (communications & networks)

 

 

10

Tues July 22

NET 9 (The Internet) +

_

WORD

WORD

 

11

Wed July 23

NET 10 (Web Pages)

 

NET 11 (E-Busines & E-commerce)

WORD

12

Thur July 24

Review + debate

***Exam 3***

WORD, NET 8,9,10,11

 

Lab test (Word)

 

 

13

Mon July 28

IS12 (Information Systems)

 

 

 

14

Tues July 29

IS12 plus EXCEL

 

Excel

 

15

Wed July 30

IS13 (program development)

 

LIV (social issues)

Excel

 

16

Thu  July 31

Review + debate

*** EXAM 4 ****

EXCEL, IS 12&13; LIV15

Lab test (Excel)

 

 

 

 

17

Mon Aug 04

Power Point + Presentation Prep

 

 

18

Tues Aug 05

Presentation Prep

Prep 

 

19

Wed Aug 06

Presentation Prep

Prep

 

20

Thur Aug 07

Presentations
Presentations

 

21

Mon Aug 11

Presentations

Presentations

 

22

Tues Aug 12

Any Make Up

 

Thee End

All done

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

Due dates coincide with the test date for the lab subject

 

 

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, on hand, cost and the calculated field  “on hand value:”  which is [units on hand] * [cost].  Display all items.

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

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

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

6. 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 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 (13PTs.)

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 the spreadsheet, as well as a pie chart. Make the bar chart a stacked bar chart.

5 points

Special Project from the instructor on test day

 

 

Power Point (3 PTS)

Using a Design Template to Create a Presentation

 

Review Power Point features in your lab book from pages PP 1.06 through PP 1.64

3 points

Do "In the lab" # 2 about “Electronics” on page PP1.72. Be sure to include an animation scheme, custom animation and slide transition techniques  illustrated in your lab book as well as clip art and sound to get the full 3 points.

Presentation

 (15 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 (3), Organization (4), Use of software features (5) and Presentation skills (3).

 Due Dates

All Assignment Due dates are given in the Syllabus Schedule