Instructor: Adjunct Professor Richard M. (Rick) Jensen

Office Telephone: (512) 228-7366

Office: SAC1 1208 (classroom) or SAC1 1207 (CIT Lab)

Office Hours: TTh 1:45-2:45 or call for appointment

E-mail: rjensen@austincc.edu

Home page: http://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). Either,

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

2. 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: When you buy either of the two Textbook bundles listed above, you will get a registration code that allows you access to a web-based software package called SAM (Skills Assessment Manager). You must have access to SAM to complete the course. We will also be using the ACC standard Blackboard web-based to communicate between student and instructor. You must be proficient in Blackboard to successfully complete the course. 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 50% lecture and 50% laboratory. 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 and Computer Support

· Associate of Applied Science – Game and Visualization Programming

· Associate of Applied Science – Information Technology Application

· Associate of Applied Science – Security Administration

· Associate of Applied Science – Software Testing

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. Objective (multiple choice type) hands-on homework (demonstrated use of the Office 2010 applications, in-class lab projects and a PowerPoint presentation 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 Computer 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 20%. 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 12/13/2012, 4:30 p.m.

Graded Efforts are as follows:

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

The Concepts exams timed open-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. Most homework is SAM-based and you can ask the lab technicians for help on homework. You will give the PowerPoint Presentation in class in lieu of a PowerPoint Lab exam.

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 ACC Administrative Rules at http://www.austincc.edu/admrule/1.04.006.htm , section 5.

The penalty accessed will be in accordance with the school’s current policy.

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 at the instructor’s office and necessary documents completed.

4. To remove an “I”, the student must complete the course by two weeks 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 provided for this course both on line and face-to-face. For online schedules and details please refer to http:://www.austincc.edu/cit .

http://www.austincc.edu/testctr/

Attendance / Withdrawal

Regular and punctual class and laboratory attendance is expected of all students. If attendance or compliance with other course policies is unsatisfactory, the instructor may withdraw students from the class.

It is the student’s responsibility to complete a Withdrawal Form in the Admissions Office if they wish to withdraw from this class. 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.

Students who enroll for the third or subsequent time in a course taken since Fall 2002 are charged a higher tuition rate. State law permits students to withdraw from no more than six courses during their entire undergraduate career at Texas public colleges or universities. With certain exceptions, all course withdrawals automatically count towards this limit. Details regard this policy can be found in the ACC College Catalog.

Student Files – Privacy

The information that a student stores in his/her student volume in the Computer Studies Labs may be viewed by their instructor for educational and academic reasons.

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 Policies).

Communication

The ACC online Blackboard system http://acconline.austincc.edu and the ACCmail accounts will be used as the official communication system during this semester. Lecture notes, handouts, changes to course schedule or assignments and your grades will be posted on Blackboard and all email communication will be via the ACCmail accounts. All students are expected to check both Blackboard and their ACCmail accounts on a regular basis. For information on how to log onto Blackboard and ACCmail please visit the following sites: http://irt.austincc.edu/blackboard/StudentSupport.php and http://www.austincc.edu/google/.

Safety Statement

Each student is expected to learn and comply with ACC environmental, health and safety procedures and agree to follow ACC safety policies. Emergency posters and Campus Safety Plans are posted in each classroom. Additional information about safety procedures and how to sign up to be notified in case of an emergency can be found at http://www.austincc.edu/emergency/.

Anyone who thoughtlessly or intentionally jeopardizes the health or safety of another individual will be immediately dismissed from the day’s activity, may be withdrawn from the class, and / or barred from attending future activities.

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

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