|
Course: CIS 103-Section 902– PC APPLICATIONS ONLINE 3
Credits
Description: A study of
personal computer applications and the Internet as information processing tools
in business and academic environments.
This is a course for students who wish to develop competence in word
processing, electronic spreadsheets, databases, and the use of the Internet for
research and e-mail for communication.
This course, which is required for all CIS majors, prepares students for
Microsoft Office Users Specialist certification in Word and Excel.
Textbook: Shelly,
Gary, Cashman, Tom, and Vermaat, Misty, Introductory
Concepts, Book One, Thomson Publishing Company, 2003. ISBN: 1418822833
The
textbook package sold through the CCP Bookstore includes: Textbook, SAM/TOM CD, and a 60 MB USB port
Materials: Computer with Internet connection.
Software
= Microsoft Office XP Professional Edition; Word (2002), Excel (2002), Access
(2002) & PowerPoint (2002); Internet browser such as Internet Explorer,
Fire fox, OR Netscape Navigator.
First Time
Online Student? Read the links below:
|
• How to Login to WebStudy |
|
|
|
Important dates to
remember: Click and read College
Calendar |
Specific Objectives:
Students
will learn:
1. Windows
XP; moving, sizing Windows; basic Windows file management, including saving,
copying, moving, backup.
2. Basic word processing; word wrap, editing, formatting,
characters, formatting pages, and formatting documents. This course will also cover basic typography
concepts such as typeface, font style, and type size. Students will learn to use editing features
such as spell check, grammar check, Thesaurus, and AutoFormat to aid
productivity. Special formatting
features for professional documents will be introduced such as headers,
footers, endnotes, footnotes, tables, sections, and styles. Graphic elements such as clip art and Word
Art will be used to enhance documents.
3. Basic spreadsheets using columns, rows, editing, and
formatting will be introduced. Students
will learn how to complete formulas, calculations and graph data. The student will gain proficiency in the use
of relative and absolute references to create a spreadsheet; explain the
importance of isolating the assumptions in a worksheet; use the fill handle to
copy a cell formula to a range of adjacent cells; insert a hyperlink into an
Excel worksheet; learn statistical functions such as MAX, MIN, and AVG, as well
as the IF and VLOOKUP functions that provide decision making within a
worksheet. Students will become familiar
with publishing organized data to the Web and accessing real-time data from Web
sites.
4. Basic Databases; creating databases using Design and Datasheet views and generating reports. Students will learn querying by using the Select Query Window. The student will gain proficiency in maintaining a database using the design and update features of Microsoft Access. Students will become familiar with publishing to the Internet using data access pages.
5. The Internet as a
resource will include: the World Wide Web, search engines; students will also
learn how to create Word, Excel, Access and PowerPoint documents for the Web. This course will require students to
understand the concepts and terminology of how to use the Internet. Students
will also learn to use the Internet to send e-mail and attachments.
Course
Requirements:
Attendance
and Assignments: Online
courses are completed through the Internet; therefore, the instructor takes
attendance by checking for completion of all assignments, forums, and quizzes. Completion means that you are doing the work
in a timely manner similar to attending and submitting classwork
on a regular basis in a face-to-face class.
1.
Online students who do not submit (send)
assignments for two weeks of class will be dropped from the course on the
Monday,
2. Software
and hardware problems are not acceptable excuses for late work. Problems with disks, computer viruses, and computer
crashing are not valid reasons for not submitting the work. You the student are
responsible for your home computer when you register for online courses.
3. Students
will be assigned tasks that will increase their practical knowledge of the
software. Students will need to practice
the specific functions of the software required for each task. It is suggested that students arrange
personal and/or work schedules at the beginning of the semester to spend at
least eight to ten (8-10) hours each week to read, practice, and
complete the assignments.
4. Assignments
will be graded individually or returned
for reworking since they serve as preparation and practice for the major
quizzes. Each project or exercise is worth 10 points.
5.
6. “Print
and submit to Instructor” directions in textbook exercises in an online course
means—
”Complete and save the work on your computer and send the file to instructor
through WebStudy’s Work2Do (tab).” Do not send assignments through WebStudy
e-mail.
7. Assignments
should be saved on your home computer for reference and submitted to the
instructor for grading. Save each file with the student’s initials
at the end of the filename; for example, Project1Wordjsp, page W1-31.
8. All
assignments must be labeled in the top left corner using a header:
Example: Student's Name, Project # or Exercise #, Page
#, Date
9. Suggestion: Do not wait until the last minute to prepare
and submit your assignments.
10. Forum
posts are expected. Forum questions will
be sent by the instructor about 10 times during the semester and will be listed
in the Assignment and Forum sections of WebStudy. Students will click on Forum
and type a response to the question.
Each student will be able to read and learn what others have
responded. A short paragraph of at
least 4 sentences is required. Each Forum post will have a point value of
10. Forum posts must be done during the week assigned. Late posts earn 0
points. Example:
Week 1 post must be done before Monday
11. Quizzes have two parts: online multiple choice
type quiz and a problem to be submitted to instructor. Quizzes must be taken on the dates
specified. Online quizzes are available
for 48-72 hours and can be taken only one (1) time.
12. The
student must complete all aspects of the course, including the final examination,
in order to receive a passing grade for the course.
13. The Three-Week Attendance Report for Online
students means:
|
Completed Forums |
Satisfactory |
|
Assignments |
Satisfactory |
|
Quiz on Windows |
Satisfactory |
14. Midterm grade will comprise of
|
Assignments |
50% |
|
Quizzes on Word/Windows |
50% |
Evaluation:
(Final Grade)
|
Average of weekly graded assignments |
30% |
|
Quizzes |
20% |
|
Web and Internet Projects |
20% |
|
Final Project/Final Exam |
20% |
|
Average of Forum Posts |
10% |
Methodologies
- Forum discussions, LIVE Chat online, practical exercises, projects, written
tests, hands-on problems
To Succeed In This Course:
§
Log
into WebStudy
§
Open
WebStudy on Monday of each week to view:
P News (announcements) by instructor
P
Timeline –
Instructor’s Discussion, important links, or summary of what we are doing for
the week.
P
Materials -
course materials to help you understand and to reinforce concepts introduced in
the chapter.
P
Read assigned textbook chapters (in our textbook,
chapters are called “projects”)
P
Assignment
with due date – what you send to instructor.
P
Email (envelope icon at top of screen)
ask me questions – (do not send documents). Expect no more than 24 hours
turnaround time for instructor to return message. Instructor logs in
approximately twice a day. Weekends, only once a day.
P
Do not click
on the calendar symbol in the
WebStudy to access assignments. (Some of my former students never read the
Timeline information and really became confused with the assignments in the
calendar.)
§
Ask
questions in e-mail if you do not comprehend. (Be sure to use an appropriate Subject line)
§
Submit
assignments on due date to receive credit for your work.
§
Make
an appointment with instructor for extra help.
Grading Policy:
The
following is the grading scale used for all Computer Information Studies
Department:
|
|
|
90
-100 = A 80 – 89 = B 70 –79 = C 60 - 69 = D Below 59 = F |
|
|
§
TO STUDENTS RECEIVING TITLE IV FINANCIAL AID FUNDS
Effective Fall 2000, students who receive Title IV
financial aid funds and who withdraw from ALL their classes before completion
of 60% of the term, i.e., the 10th week (or its equivalent for summer terms)
may be required to return all or a portion of their financial aid award. If it is determined that funds must be
returned to the financial aid programs, students must make satisfactory payment
arrangements within 45 days of notification or they become ineligible for
further financial aid funding.
§
STUDENT’S RESPONSIBLE COMPUTER USE
The student’s responsibility for
acceptable computer use at the College (in class and computer labs) is stated
below. It is taken in part from the
College’s Acceptable Use Policy for Computer Use. The full description is
located on the College’s Web page under Academic Computing.
Individual Responsibility
The College's Acceptable Use
Policy, set forth below, contains restrictions on accessing inappropriate
material. There is a wide range of material available on the Internet, some of
which may not be fitting with the particular values of students and employees.
It is not practically possible for the College to monitor and enforce a wide
range of social values in student/employee Internet use. Furthermore, the
College recognizes that individuals bear primary responsibility for
transmitting their particular values.
The use of the College's
interactive systems is a privilege, not a right, and inappropriate use can
result in a termination or suspension of some or all of those privileges. Users
will be expected to abide by generally accepted rules of network etiquette,
including (but not limited to) the Acceptable Use Policy set forth below.
- Users must use the system only for educational purpose and
professional or career development activities.
- Users must not download large files (thirty minute time limit)
unless absolutely necessary. If necessary, users will download the file at
a time when the system is not being heavily used and immediately remove
the file from the system computer to their personal computer.
- Users must not post chain letters or engage in
"spamming." Spamming is defined as sending an annoying or
unnecessary message to a large number of people.
Plagiarism and Copyright
Infringement
- Users must not plagiarize works that they find on the
Internet. Plagiarism is defined as
taking the ideas or writings of others and presenting them as if they were
original to the user.
- Users must respect the rights of copyright owners. Copyright
infringement occurs when an individual inappropriately reproduces a work
that is protected by copyright. If
a work contains language that specifies acceptable use of that work, the
user should follow the expressed requirements. If the user is unsure
whether or not he/she can use a work, he/she should request permission
from the copyright owner.
Inappropriate Access to Material
Users must not use the College
system to access material that is profane or obscene (including pornography),
that advocates illegal acts, or that advocates violence or discrimination
towards other people. For students, a special
exception may be made for potentially inappropriate material if the purpose of
such access is to conduct research and access is approved by the instructor.