Instructor: Richard M. (Rick) Jensen, Adjunct Professor

Contact Telephone: (512) 228-7366

Office: RVSG 9138 (Classroom) or RVSG 9141 (CIT lab)

Office Hours: Monday/Wednesday 12:40-1:40 or call for appointment (512) 228-7366

E-mail: rjensen@austincc.edu

Home page: www.austincc.edu/rjensen

Course Description: Overview of computer systems—hardware, operating systems, and microcomputer application software, including the Internet, word processing, spreadsheets, presentation graphics, and databases. Current issues such as the effect of computers on society, and the history and use of computers in business, educational, and other modern settings are also studied.

This course provides the required computer literacy core competencies that all students need to attain by graduation.

Pre-requisite: Reading – R.

Keyboarding and mouse operation skills recommended.

Approved Course Texts:

CMPTR, 1^st Edition, Pinard/Romer, Course Technology, 2012.

NOTE: This textbook MUST be selected from one of two BUNDLES (the only difference is that one bundle provides a 180 day license to Microsoft Office 2010)

ISBN-13: 978-1133-22090-9 or ISBN-10: 1-133-22090-8 : (Textbook, CourseMate, and SAM Access)

ISBN-13: 978-0495-96549-7 or ISBN-10: 0-495-96549-9 : (Textbook, CourseMate, SAM Access, and 180 day Microsoft Office 2010 license) .

I do NOT recommend buying this book online. If you do, you must ensure that the book comes with the CourseMate and SAM Access packages (and it probably doesn’t). These are product-key activated online services which are required for the course. I DO recommend buying your textbook Bundle at any of the ACC bookstores to ensure you get the complete package. Do NOT buy a used book-it won’t come with complete package.

Other Course Materials: Though not absolutely required, you will find it helpful to have some removable storage media to transfer data from the classroom computers to your home computer. Classroom computers use any/all of the following:

· Any USB storage device – highly recommend a 2GB or bigger USB flash drive “memory stick”

· CD/R Disks – Our lab computers allow writing or “burning” your CDs

You do not have to buy Microsoft applications software for this course. The classroom and lab computers have all the software you’ll need. But, if you intend to use your own computer to work on the activities of this course, then you should have the Microsoft Office 2010 Suite. One textbook bundle comes with a 180-day Office 2010 license. You don’t need that if you already own Office 2010.

Instructional Methodology: This course will have both 2[rj1] hours of lecture and 2 hours of lab each week. If the students are unable to finish the assigned lab work within the lab time, they will need to visit the CIS open labs to complete their assignments.

Course Rationale: This course meets the Computer Literacy course requirements as defined by the Texas Higher Education Coordinating Board. This course is included in several degree plans and certificates including:

· Associate of Applied Science – Computer Programming

· Associate of Applied Science – Web Programming

· Associate of Applied Science – Local Area Network Administration

· Associate of Applied Science – User/Desktop Support

· Associate of Applied Science – Game programming

· Associate of Applied Science – Microcomputer Application Support

Course Objectives/Learning Outcomes:

The students will learn to “use computer-based technology in communicating, solving problems, and acquiring information”. Students will have an “understanding of the limits, problems, and possibilities associated with the use of technology, and acquire the tools necessary to evaluate and learn new technologies as they become available”. After successful completion of this course, students should be able to:

1. Define and describe the hardware used in information technology (IT).

2. Define and describe the types of software used in IT.

3. Delineate and discuss societal issues involving the use of IT and networks.

4. Demonstrate the ability to create and use documents, spreadsheets, presentations and databases in order to communicate and store information as well as to support problem solving.

5. Use IT to acquire, differentiate and evaluate information and technology.

SCANS (Secretary’s Commission on Achieving Necessary Skills):

Refer to http://www.austincc.edu/cit/courses/scans.pdf for a complete definition and explanation of SCANS. The following list summarizes the SCANS competencies addressed in this particular course:

RESOURCES

1.1 Manages Time

INTERPERSONAL

INFORMATION

3.1 Acquires and Evaluates Information

3.2 Organizes and Maintains Information

3.3 Uses Computers to Process Information

SYSTEMS

4.1 Understands Systems

4.2 Monitors and Corrects Performance

TECHNOLOGY

5.1 Selects Technology

5.2 Applies Technology to Task

BASIC SKILLS

6.1 Reading

6.5 Listening

THINKING SKILLS

7.2 Decision Making

7.3 Problem Solving

7.4 Mental Visualization

7.5 Knowing How to Learn

7.6 Reasoning

PERSONAL SKILLS

8.1 Responsibility

8.2 Self-Esteem

8.3 Sociability

8.4 Self-Management

8.5 Integrity/Honesty

Grade Policy:

Grade will be assigned based both on concepts and practical application. Written exams, homework and lab projects will be a part of the grade. An overall grade will be assigned on the following grading scale:

90% - 100% A

80% - 89% B

70% - 79% C

60% - 69% D

0% - 59% F

Each student’s grade for this course consists of non-comprehensive exams on Concepts (Chapters 1-6), chapter homework on Microsoft Office 2010 applications (Chapters 7-22), a PowerPoint 2010 project, and a standardized departmental final exam. .

Each Microsoft Office 2010 Lab/Homework Assignment is due at the beginning of the next scheduled class following the laboratory. Late Lab/Homework assignments will be accepted for one week with a late penalty of 10%. No credit will be given for exercises received after one week. Exams must be taken in the classroom on the date shown in the schedule. The last date/time to submit assignments for consideration this semester is 5/9/2012, 12:40 p.m[rj2] .

Graded Efforts are as follows:

Graded Effort	Points per	Total Points
3 – Concepts (Ch 1-6) Exams	100 points	300
4 – LAB (Ch 7-22) Exams	100 points	400
16 Chapter Lab/Homework Assignments	20 points	320
PowerPoint Presentation	100 points	100
Departmental Assessment	80 points	80
TOTAL		1200 points

The concepts exams are closed book exams. The lab exams are SAM based, and you may use

your textbook, your notes, WWW search, or the Windows/Office “Help” feature as references. However, you may not seek or use the aid of another person.

Course/Class Policies:

Academic Integrity

A student is expected to complete his or her own projects and tests. Students are responsible for observing the policy on academic integrity as described in the current ACC Student Handbook, under “Student Discipline Policy, Section C”.

The penalty accessed will be in accordance with the current ACC Student Handbook policy. See http://www.austincc.edu/handbook/policies4.php for more information.

For this course, the penalty for scholastic dishonesty is a grade of ‘F’ for the course.

Incomplete

A student may receive a temporary grade of “I” (Incomplete) at the end of the semester only if ALL of the following conditions are satisfied:

1. The student is unable to complete the course during the semester due to circumstances beyond their control.

2. The student must have earned at least half of the grade points needed for a “C” by the end of the semester.

3. The request for the grade must be made in person to the instructor and necessary documents completed.

4. To remove an “I”, the student must complete the course before the end of the following semester. Failure to do so will result in the grade automatically reverting to an “F”.

Freedom of Expression Policy

It is expected that faculty and students will respect the views of others when expressed in classroom discussions.

Tutoring

Free tutoring is available for this course. For schedules and details please refer to http:://www.austincc.edu/cit .

Attendance / Withdrawal

Students are expected to attend classes and will be held responsible for all material covered in class. Regular attendance helps ensure satisfactorily progression towards completion of the course.

It is the student’s responsibility to complete a Withdrawal Form in the Admissions Office if they wish to withdraw from this class. The instructor may withdraw students from this class after they miss 2 or more scheduled exams. It is not the responsibility of the instructor to withdraw the students from their class even though the instructor has the prerogative to do so under the above listed circumstances.

ALERT: New state law for new students. No more than six course withdrawals throughout your undergraduate education, regardless of how many colleges you attend. Students who entered college before fall 2007 are not affected. Ask a counselor for details.

Student Files – Privacy

The information that a student stores in his/her student volume (their H:\ drive) in the Computer Studies Labs may be viewed by the instructor for educational and academic reasons. Instructors have read-only access to the students’ classroom files.

Students with Disabilities

Each ACC campus offers support services for students with documented physical or psychological disabilities. Students with disabilities must request reasonable accommodations through the Office for Students with Disabilities on the campus where they expect to take the majority of their classes. Students are encouraged to make this request three weeks before the start of the semester. (Refer to the current ACC Student Handbook).

Communication

Instructors will use the ACC online Blackboard system http://acconline.austincc.edu and the ACCmail accounts as the official communication system during this semester. Instructors can post lecture notes, handouts, changes to course schedule or assignments and your grades on Blackboard and can send all email communication via the ACCmail accounts. Instructors will expect all students to check both Blackboard and their ACCmail accounts on a regular basis. In order to use Blackboard, you must first activate your ACC Electronic ID (ACCeID). You probably did this when you first registered for school. For information on ACCeID activation, visit https://acceid.austincc.edu/idm/user/login.jsp[rj3] . For information on how to log onto ACCmail please visit the following site http://www.austincc.edu/google/. Instructors/Lab Technicians will conduct a brief lab orientation during the first class laboratory period.

Initial 16 Week Schedule for COSC 1301 (Subject to Change: Current Schedule will be maintained on Blackboard)

Week	Class Period	Date	Concepts Lecture (50 min)	Lab Session (50 min)	Homework Assignment
1	1	1/18	Course Orientation	Lab Orientation / SAM Logons	All Registrations
2	2	1/23	Chapter 1 (LO 1.1, 1.2)	Chapter 7 – Windows 7 (LO 7.1, 7.2, 7.3, 7.4, 7.5, 7.6)	Practice It 7-1
2	3	1/25	Chapter 1 (LO 1.3, 1.4)	Chapter 8 – Managing Files (LO 8.1, 8.2, 8.3)	Practice It 8-1
3	4	1/30	Chapter 2 (LO 2.1, 2.2)	Chapter 9 – Intro Office 2010 (LO 9.1, 9.2, 9.3)
3	5	2/1	Chapter 2 (LO 2.3, 2.4)	Chapter 9 – Intro Office 2010 (LO 9.4, 9.5, 9.6)	Practice It 9-1
4	6	2/6	Chapter 2 (LO 2.5, 2.6)	Chapter 10 – Creating a Document (LO 10.1 – 10.7)
4	7	2/8	Concept Exam 1 Review	Chapter 10 – Creating a Document (LO 10.8 – 10.11)	Chapter 10 Lab Homework(SAM Project)
5	8	2/13	Concept EXAM (CH 1 - 2)	Chapter 11 – Formatting a Long Document (LO 11.1 – 11.2, 11.4)
5	9	2/15	Chapter 3 (LO 3.1, 3.2)	Chapter 11 – Formatting a Long Document (LO 11.5 – 11.7, 11.9)	Chapter 11 Lab Homework(SAM Project)
6	10	2/20	Chapter 3 (LO 3.3 3.4)	Chapter 12 – Enhancing a Document (LO 12.1 – 12.2, 12.4, 12.6)	Chapter 12 Lab Homework(SAM Project)
6	11	2/22	WORD Lab Exam (SAM Projects)
7	12	2/27	Chapter 3 (LO 3.5, 3.6, 3.7)	Chapter 13 – Creating a Workbook (LO 13.1, 13.2, 13.3)
7	13	2/29	Chapter 4 (LO 4.1, 4.2)	Chapter 13 – Creating a Workbook (LO 13.4, 13.5, 13.6, 13.7)	Chapter 13 Lab Homework(SAM Project)
8	14	3/5	Chapter 4 (LO 4.3, 4.4)	Chapter 14 – Formatting a Worksheet (LO 14.1 – 14.6)	Chapter 14 Lab Homework(SAM Project)
8	15	3/7	Chapter 4 (LO 4.5, 4.6)	Chapter 15 – Working with Formulas and Functions (LO 15.1 – 15.3)	Chapter 15 Lab Homework(SAM Project)
			SPRING BREAK-NO CLASS
			SPRING BREAK-NO CLASS
9	16	3/19	Concept Exam 2 Review	Chapter 16 – Inserting and Formatting Charts (LO 16.1 - 16.4)
9	17	3/21	Concept Exam 2 (CH 3-4)	Chapter 16 – Inserting and Formatting Charts (LO 16.5 –16.9)	Chapter 16 Lab Homework(SAM Project)
10	18	3/26	EXCEL Exam (SAM Project)
10	19	3/28	Chapter 5 (LO 5.1, 5.2)	Chapter 17 – Creating a Database (LO 17.1 – 17.3,17.6)
11	20	4/2	Chapter 5 (LO 5.3, 5.4)	Chapter 17 – Creating a Database (LO 17.6 – 17.8)	Chapter 17 Lab Homework(SAM Project)
11	21	4/4	Chapter 6 (LO 6.1, 6.2)	Chapter 18 – Maintaining and Querying a Database (LO 18.1 – 18.7, 18.9 only)	Chapter 18 Lab Homework(SAM Project)
12	22	4/9	Chapter 6 (LO 6.3, 6.4)	Chapter 19 – Creating Forms and Reports (LO 19.1 – 19.7)	Chapter 19 Lab Homework(SAM Project)
12	23	4/11	ACCESS Exam (SAM Project)
13	24	4/16	Chapter 6 (LO 6.5, 6.6)	Chapter 20 – Creating a Presentation (LO 20.1 – 20.4)
13	25	4/18	Concept Exam 3 Review	Chapter 20 – Creating a Presentation (LO 20.4 – 20.7)	Chapter 20 Lab Homework(SAM Project)
14	26	4/23	Concept Exam 3 (CH 5-6)	Chapter 21 – Enhancing a Presentation (LO 21.1 – 21.4)
14	27	4/25	TBD	Chapter 21 – Enhancing a Presentation (LO 21.5 – 21.7)	Chapter 21 Lab Homework(SAM Project)
15	28	4/30	PowerPoint Exam (SAM Project)
15	29	5/2	Present PowerPoint Projects
16	30	5/7	Review for Departmental Assessment	Chapter 22 - Integrating Word, Excel, Access, and PowerPoint (LO 22.1 and 22.5 only)	Practice It 22-1 (p.767-768) steps 1-15
16	31	5/9	Departmental Assessment

NOTE: The instructor has the prerogative to change the course schedule as required. Current schedule will be maintained in the SCHEDULE section of Blackboard. Students are expected to read and study the assigned material BEFORE each class, including the lab chapters.