AUSTIN COMMUNITY COLLEGE
DEPARTMENT OF COMPUTER STUDIES AND ADVANCED TECHNOLOGY
Course Syllabus: COSC 1301 (3-2-2) – Introduction to
Computing
Synonym 44258–
Spring 2012
Lecture/ Lab Distance Learning - Online
Office Telephone: 223-0183
Office: RRC
Office Hours:
|
Day |
Campus |
Room |
Hours |
|
Mon |
Round Rock |
2232.21 |
10:45am-2:45pm |
|
Tues |
Round Rock |
2232.21 |
9:00am – 10:55am |
|
Wed |
Round Rock |
2232.21 |
10:45am-2:45pm |
|
Thur |
Round Rock |
2232.21 |
9:00am – 10:55am |
|
Fri |
Round Rock |
2232.21 |
8:30am – 12:00 noon |
|
|
|
|
or by appointment |
E-mail: jwebb@austincc.edu
Home page: http://www.professorwebb.net
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, 1st 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-10: 1-133-22090-8 : (Textbook, CourseMate, and SAM Access)
ISBN-10: 0-495-96549-9 : (Textbook, CourseMate, SAM Access, and 180 day Microsoft Office 2010 license)
Instructional Methodology: This course will have both 2 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, chapter homework on Microsoft office 2010 applications, Microsoft Office 2010 projects, and a departmental final exam. .
Each Microsoft Office 2010 Lab is due at the beginning of the next scheduled class following the laboratory. Late assignments will be accepted for one week with a late penalty of 20%. No credit will be given for exercises received after one week. Scheduling of computer time outside of regular lab time is the student’s responsibility. Availability of computers is NOT an excuse for being late with any assignment. The last date to submit assignments for consideration this semester is [fill in date].
|
3 - Concept Exams |
100 points |
300 points total |
|
Concept Enrichment Assignment |
100 points |
100 points total |
|
3 – LAB Exams |
100 points |
300 points total |
|
16 Chapter Homework Assignments |
5 points |
160 points total |
|
PowerPoint Presentation |
45 points |
45 points total |
|
Department Assessment |
75 points |
75 points total |
|
TOTAL |
|
1000 points |
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 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. For schedules and details please refer to http:://www.austincc.edu/cit .
Testing Center Policy [Open Campus Sections Only]
http://www2.austin.cc.tx.us./testctr/
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 if their absences exceed 10% of the total number of class meetings or if the student fails to attempt 4 graded assignments by the last date to receive credit. The last date to withdraw for this semester is [insert date here]. 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 in the Computer Studies Labs may be viewed, but not changed by his/her instructor for educational and academic reasons. Instructors have read-only access to the students’ 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. For information on how to log onto Blackboard 8.0 and ACCmail please visit the following sites: http://irt.austincc.edu/blackboard/stlogin.html http://www.austincc.edu/google/. Instructors/Lab Technicians will conduct a brief lab orientation during the first class laboratory period.
Proposed 16 Week Schedule for COSC 1301
|
Week1 |
Concepts Lecture (50 min) |
Lab Session (50 min) |
Homework Assigned |
|
1 |
Course Orientation |
Lab Orientation / SAM Logons |
|
|
1 |
Chapter 1 (LO 1.1, 1.2) |
Chapter 7 – Office XP (LO 7.1, 7.2, 7.3, 7.4, 7.5, 7.6) |
SAM CH 7 or Practice It 7-1 |
|
2 |
Chapter 1 (LO 1.3, 1.4) |
Chapter 8 – Managing Files (LO 8.1, 8.2, 8.3) |
SAM CH 8 or Practice It 8-1 |
|
2 |
Chapter 2 (LO 2.1, 2.2) |
Chapter 9 – Intro Office 2010 (LO 9.1, 9.2, 9.3) |
|
|
3 |
Chapter 2 (LO 2.3, 2.4) |
Chapter 9 – Intro Office 2010 (LO 9.4, 9.5, 9.6) |
SAM CH 9 or Practice It 9-1 |
|
3 |
Chapter 2 (LO 2.5, 2.6) |
Chapter 10 – Creating a Document (LO 10.1 – 10.5) |
|
|
4 |
Concept EXAM (CH 1 - 2) |
Chapter 10 – Creating a Document (LO 10.6 – 10.11) |
SAM CH 10 or Practice It 10-1 |
|
4 |
Chapter 3 (LO 3.1, 3.2) |
Chapter 11 – Formatting a Long Document (LO 11.1 – 11.5) |
|
|
5 |
Chapter 3 (LO 3.3 3.4) |
Chapter 11 – Formatting a Long Document (LO 11.6 – 11.9) |
SAM CH 11 or Practice It 11-1 |
|
5 |
Chapter 3 (LO 3.5, 3.6, 3.7) |
Chapter 12 – Enhancing a Document (LO 12.1 – 12.5 only) |
SAM CH 12 or Practice It 12-1 |
|
6 |
WORD Lab Exam (SAM Projects) |
||
|
6 |
Chapter 4 (LO 4.1, 4.2) |
Chapter 13 – Creating a Workbook (LO 13.1, 13.2, 13.3) |
|
|
7 |
Chapter 4 (LO 4.3, 4.4) |
Chapter 13 – Creating a Workbook (LO 13.4, 13.5, 13.6, 13.7) |
SAM CH 13 or Practice It 13-1 |
|
7 |
Chapter 4 (LO 4.5, 4.6) |
Chapter 14 – Formatting a Worksheet (LO 14.1 – 14.6) |
SAM CH 14 or Practice It 14-1 |
|
8 |
Concept Exam (CH 3-4) |
Chapter 15 – Working with Formulas and Functions (LO 15.1 – 15.6) |
SAM CH 15 or Practice It 15-1 |
|
8 |
Chapter 5 (LO 5.1, 5.2) |
Chapter 16 – Inserting and Formatting Charts (LO 16.1 - 16.4) |
|
|
9 |
Chapter 5 (LO 5.3, 5.4) |
Chapter 16 – Inserting and Formatting Charts (LO 16.5 –16.9) |
SAM CH 16 or Practice It 16-1 |
|
9 |
EXCEL Exam (SAM Projects) |
||
|
|
November 17th - Last Day to Withdraw |
||
|
10 |
Chapter 6 (LO 6.1, 6.2) |
Chapter 17 – Creating a Database (LO 17.1 – 17.4) |
|
|
10 |
Chapter 6 (LO 6.3, 6.4) |
Chapter 17 – Creating a Database (LO 17.4 – 17.8) |
SAM CH 17 or Practice It 17-1 |
|
11 |
Chapter 6 (LO 6.5, 6.6) |
Chapter 18 – Maintaining and Querying a Database (LO 18.1 – 18.4 only) |
SAM CH 18 or Practice It 18-1 |
|
11 |
Concept Exam (CH 5-6) |
Chapter 19 – Creating Forms and Reports (LO 19.1 – 19.7) |
SAM CH 19 or Practice It 19-1 |
|
12 |
ACCESS Exam (SAM Projects) |
||
|
12 |
Enrichment Assignment |
Chapter 20 – Creating a Presentation (LO 20.1 – 20.4) |
|
|
13 |
Enrichment Assignment |
Chapter 20 – Creating a Presentation (LO 20.4 – 20.7) |
SAM CH 20 or Practice It 20-1 |
|
13 |
Enrichment Assignment |
Chapter 21 – Enhancing a Presentation (LO 21.1 – 21.4) |
|
|
14 |
Enrichment Assignment |
Chapter 21 – Enhancing a Presentation (LO 21.5 – 21.7) |
SAM CH 21 or Practice It 21-1 |
|
14 |
Present PowerPoint Projects |
||
|
15 |
PowerPoint Exam (SAM Projects) |
||
|
15 |
Enrichment Assignment |
Chapter 22 - Integrating Word, Excel, Access, and PowerPoint (LO 23.1 only) |
SAM CH 22 or Practice It 22-1 (steps 1-15 only) |
|
16 |
Department Assessment |
|
|
NOTE: The open lecture periods are for instructor provided enrichment and / group projects.