CISM 2201 FUNDAMENTALS OF         

COMPUTER APPLICATIONS

Amy Williams

Assistant Professor

 

Office:  Conger 218A

Phone:  (229) 391-4838

E-mail:  awilliams@abac.edu

Website:  www.abac.edu/awilliams

Office Hours:  (see website)
_____________________________________________________________________________________________________________________

COURSE DESCRIPTION

A course designed to assure a basic level of computer applications literacy to include word processing, spreadsheet, presentation software, database, LAN, e-mail, and Internet utilization.

Expected Student Outcomes:

 Upon completion of the course, the student will:

1. Understand how information technology aids business decision making.  

2. Identify the components of typical microcomputer system.  

3. Identify and describe the most widely used general microcomputer software applications, the difference between application software and  system software and understand the role of operating system software.  

4. Demonstrate knowledge of computer hardware and software, including “multimedia” and be familiar with the legal, ethical, and privacy  issues relating to the use of hardware and software in a business environment.  

5. Be familiar with computer networks and know the basic components of communications system to include e-mail, user interfaces,  communications and the Internet.  

6. Effectively use application software which includes:

a.   Word processing

b.   Spreadsheet

c.   Database management

d.   Presentation software

 

General Education Outcomes:

1) Communications: Oral and written communication will be characterized by clarity, critical analysis, logic, coherence, persuasion, precision, and rhetorical awareness.

Ability to communicate in various modes and media, including the proper use of appropriate technology;

 

2) Quantitative Reasoning and Mathematics: quantitative reasoning and mathematics will be characterized by logic, critical evaluation, analysis, synthesis generalization, modeling, and verbal, numeric, graphical, and symbolic problem solving.

Ability to identify and properly use appropriate technologies for scientific inquiry and communication including collecting and analyzing scientific data;

 

3) Scientific Reasoning: Scientific reasoning will be characterized by understanding and applying scientific method, laboratory techniques, mathematical principles, and experimental design to natural phenomena.

Ability to identify and properly use appropriate technologies for scientific inquiry and communication including collecting and analyzing scientific data;

 

Teaching Methods:

1. Students should plan to take notes, however, all material can be found in the texts or readings. Discussion is encouraged using the Bulletin Board and private e-mail

2. Assignments: Review Assignments, Case Problems, and readings will be periodically assigned to help support and supplement material found in the text. These assignments may require the application of various software packages.

3. Quizzes: scheduled quizzes will be given to help ensure students stay up with assigned material.

4. Exams: The exams will be closed book/note and will test assigned readings and material discussed in class or on-line.

5. Internet: All material will be distributed on the Internet. Class notes, instructional material, and student assignments will be posted on 'the net'.

 

Text & Materials:

Textbook: Shaffer, Cary, Parson, Jamrich, Oja, & Finnegan Fundamentals of Computer Applications, Cengage Learning, 2010.

Software: Microsoft Office 2010, Internet Explorer, and Windows 7 will be used. Instructor will provide information on how to use these programs.

SAM 2010 Access Code. You must purchase this from the bookstore.  Do not order this on-line from publisher. You can not reuse a student's access code from a previous semester. Students will first login to SAM 2010 under the guidance of the instructor in class.  You can not return the SAM 2010 access code to the bookstore if opened, so if you think you are going to drop the class, don’t open the packet.

 

ABAC ATTENDANCE POLICY

Courses at Abraham Baldwin Agricultural College are provided for the intellectual growth and development of students.  To attain maximum success, students must attend all their classes, be on time, and attend all scheduled course activities including, but not limited to, field trips, seminars, study sessions, individual conferences, and lectures. 

Students enrolled in CISM 2201 courses can only miss a maximum of 4 days of class. Students whose number of absences exceeds more than 4 days of class will receive a grade of “F” for the course. Students who have perfect attendance will have 3 points added to their final average in the class.

 

 

Grading:

Letter grades will be determined using a standard point evaluation as outlined below.
 

Exams:

 

Points

 

 

Points Earned

Grade

 

Exam #1  Concepts

100

 

 

900-1000

A

 

Exam #2  Windows

100

 

 

800-899

B

 

Exam #3  Internet

100

 

 

700-799

C

 

Exam #4  Word

100

 

 

600-699

D

 

Exam #5  Excel

100

 

 

599 & below

F

 

Exam #6  Access

100

 

 

 

 

 

Exam #7  PowerPoint

100

 

 

 

 

 

Exam #8  Final Exam

100

 

 

 

 

 

 

 

 

 

 

 

Assignments

1-10 (20pt each)

200

 

 

 

 

Total Points

1000

 

 

 

 

 

Course Policies:

Eight Minute Rule: If a student enters the classroom once class has started, he or she is considered tardy. Two tardies equals one absence. If a student is more than 8 minutes late, the student is counted  absent. If a student leaves early from class without prior approval, the student is counted absent. If you do not attend at least 80% of the class period, you are considered absent.

Cell Phones & Pagers: Turn off all cell phones and pagers during class hours. Students should make themselves unavailable during class to outside calls or pages. Students who leave their cell phones on during class will be asked to leave.

Missed /Tests: The student is responsible for keeping track of tests and due dates for assignments posted on the calendar. There are no makeup exams.  Any uncoordinated missed exam will result in a score of 0 for that exam.  If you have a doctor's excuse, see me.  You must call/e-mail the instructor within 24 hrs if you are unable to take an exam.

Academic Dishonesty: Plagiarism and cheating are serious offenses and may be punished by failure on exam, paper or project; failure in course; and or expulsion from the college. For more information refer to the Academic Dishonesty policy in the ABAC Catalog.

Need for Assistance: The Student Development Center is the official office to provide disability services. If you have a documented disability that may require assistance, you will need to contact Dr. Maggie Martin at the Student Development Center for coordination of your academic accommodations. The Student Development Center is located on the first floor of the library. The telephone number is 391-5135.

Business Administration Students:

This course is required in Area F of the University System of Georgia Core Curriculum. You should not expect it to transfer to a School of Business in a senior college or university within the system unless your grade is a “C” or better.

 

Course Outline for Fall Semester:

Week

Topic

Assignments

 Exams

1/2

Essential Computer Concepts

Concepts

Exam #1

3

Windows 7: Exploring the basics of Microsoft Windows 7

Windows

Exam #2

4

Internet: Getting Started with Internet Explorer 7.0

Internet Explorer

Exam #3

5

Word 2010: Creating a Document with Microsoft Word 2010

Word Tutorial 1

 

 6 

Word 2010: Editing & Formatting a Document

Word Tutorial 2

 

7

Word 2010: Creating a Multiple-Page Report

Word Tutorial 3

 

8

Word 2010: Desktop Publishing & Mail Merge

Word Tutorial 4

Exam #4

9

Excel 2010: Getting Started with Excel

Excel Tutorial 1

 

10

Excel 2010: Formatting a Workbook

Excel Tutorial 2

 

11

Excel 2010: Working with Formulas and Functions

Excel Tutorial 3

 

12

Excel 2010: Enhancing a Workbook with Charts & Graphs

Excel Tutorial 4

Exam #5 

13

Access 2010: Creating a Access Database

Access Tutorial 1

 

14

Access 2010: Building a Database & Defining Table Relationships

Access Tutorial 2

 

 

Access 2010: Maintaining & Querying a Database

Access Tutorial 3

 

15

PowerPoint 2010: Creating a PowerPoint Presentation

PowerPoint Tutorial 1

 

16

PowerPoint 2010: Adding & Modifying Text & Graphic Objects

PowerPoint Tutorial 2

Exam #7

17

 

                                     

 FALL SEMESTER 2011

FINAL EXAM SCHEDULE

                                                 Exam #8

 

Course Outline for Spring Semester:

Week

Topic

Assignments

Exams

1/2

Essential Computer Concepts

Concepts

Exam #1

3

Windows 7: Exploring the basics of Microsoft Windows 7

Windows

Exam #2

4

Internet: Getting Started with Internet Explorer 7.0

Internet Explorer

Exam #3

5

Word 2010: Creating a Document with Microsoft Word 2010

Word Tutorial 1

 

 6 

Word 2010: Editing & Formatting a Document

Word Tutorial 2

 

7

Word 2010: Creating a Multiple-Page Report

Word Tutorial 3

 

8

Word 2010: Desktop Publishing & Mail Merge

Word Tutorial 4

Exam #4

9

Excel 2010: Getting Started with Excel

Excel Tutorial 1

 

10

Excel 2010: Formatting a Workbook

Excel Tutorial 2

 

11

Excel 2010: Working with Formulas and Functions

Excel Tutorial 3

Exam #5 

12

Excel 2010: Enhancing a Workbook with Charts & Graphs

Excel Tutorial 4

 

13

Access 2010: Creating a Access Database

Access Tutorial 1

 

14

Access 2010: Building a Database & Defining Table Relationships

Access Tutorial 2

 

 

Access 2010: Maintaining & Querying a Database

Access Tutorial 3

 

15

PowerPoint 2010: Creating a PowerPoint Presentation

PowerPoint Tutorial 1

 

16

PowerPoint 2010: Adding & Modifying Text & Graphic Objects

PowerPoint Tutorial 2

Exam #7

17

 

SPRING SEMESTER 2012

FINAL EXAM SCHEDULE

 

Exam #8

                                                                                      Back to Home Page

 

 

 

 

 

 

.

 

Text Box:

Week

Date

Topic
Regular class in Blue (as seen in WebCT)
On-line Class in Red

Material

On-line Quizzes

 

1

June 7

 

Introduction to Course

---

 

 

June 8

WebCT

 

 

 

June 9

 

Browser Basics Overview

ECC Tutorial

Practice Quiz

 

June 10

SAMXP (setup)

 

 

 

June 11&14

 

Essential Computer Concepts Overview

Win Tutorial 1

Practice Quiz

2

June 15

 

Windows 2000: Working with Files

Win Tutorial 2

Practice Quiz

 

June 16

 

Windows 2000: Exploring the Basics

BEB Tutorial

Practice Quiz

 

June 17

 

Exam #1  M/C test covering Browser Basics, Concepts, Win 1 & 2

Exam/ WebCT

 

 

June 18

 

Introduction to Office

Intro Tutorial

 

 

June 18

 

Word 2002: Creating a Document

Word Tutorial 1

Quiz 1

June 21

 

Word 2002: Editing and Formatting a Document

Word Tutorial 2

Quiz 2

 

June 22

SAMXP Practice Word Tut 1 & 2

 

 

 

June 23-24

 

Word 2002: Creating a Multiple-Page Report

Word Tutorial 3

Quiz 3

 

June 25

 

Word 2002: Desktop Publishing a Newsletter

Word Tutorial 4

Quiz 4

4

June 28

SAMXP Practice Word Tut 3 & 4

 

 

 

June 29

 

Exam #2 Hands-on SAM  Tut 1-4

----

 

 

June 30

 

Excel 2002: Using Excel to Manage Financial Data

Excel Tutorial 1

Quiz 5

 

July 1

 

Excel 2002: Working with Formulas and Functions

Excel Tutorial 2

Quiz 6

 

July 2

SAMXP practice Excel Tut 1 & 2

 

 

5

July 6

 

Excel 2002: Developing a Professional-Looking Worksheet

Excel Tutorial 3

Quiz 7

 

July 7

 

Excel 2002: Working with Charts and Graphics

Excel Tutorial 4

Quiz 8

 

July 8

Practice SAMXP Excel 3 & 4

 

 

 

July 9

Exam #3  Hands-on SAM  Tut 1-4
 

 

 

6

July 12

 

Access 2002: Introduction to Microsoft Access 2002

Access Tutorial 1

Quiz 9

 

July 13

 

Access 2002: Creating and Maintaining a Database

Access Tutorial 2

Quiz 10

 

July 14

 

Access 2002: Querying a Database

Access Tutorial 3

Quiz 11

 

July 15

 

Access 2002: Creating Forms and Reports

Access Tutorial 4

Quiz 12

 

July 16

SAMXP Practice test Access 1-4

 

 

7

July 19

Exam #4  Access Hands-on SAM
 

 

 

 

July 20

 

PowerPoint 2002: Creating a Presentation

PPT Tutorial 1

Quiz 13

 

July 21

 

PowerPoint 2002: Applying and Modifying Text and Graphic Objects

PPT Tutorial 2

Quiz 14

 

July 22

SAMXP Practice PP 1-2.

 

 

 8

July 26

 Exam #5 PowerPoint Hands-on SAM
 

Last class day

 

 

July 28

 

Final Exam (comprehensive M/C) 

8:00-10:00am