ITE 115 Basic Computer Literacy

(16 weeks) B
o
Professor: Corinne Hoisington t
t
Semester: Spring 2010 o
m
Phone:(434) 832-7682
o
FAX: (434) 832-7835 f
Instructor E-mail: hoisingtonc@[Link]
F
Office Hours: posted on my CVCC web site o
r
My Web Site: [Link] m
Shelly/Cashman Web Site: [Link]/sc/off2007/ Click on the Word, Excel, Access and
PowerPoint links on the left.
Course Description
This course covers microcomputer applications using Microsoft Office 2007 Professional. These
applications include Microsoft Word 2007, Microsoft Excel 2007, Microsoft Access 2007, and Microsoft
PowerPoint 2007. This course will cover operating system concepts as well as word processing,
spreadsheets, database and graphics presentation packages. At the conclusion of this course, students
should have a working knowledge of covered package concepts. This course is designed to give 3
semester credits.
Objectives:
At the conclusion of this course the student should be able to:
1. Understand and articulate basic computer hardware and software concepts
2. Work effectively within the Windows Vista operating environment
3. Perform basic Word processing tasks using Microsoft Word 2007
4. Perform basic Spreadsheet tasks using Microsoft Excel 2007
5. Prepare basic Presentations using Microsoft PowerPoint 2007
6. Perform basic Database tasks using Microsoft Access 2007
7. Create a basic Web page from a Word, Excel, and/or PowerPoint document
Textbook and supplies
Microsoft Office 2007: Introductory Concepts and Techniques
Gary B. Shelly, Thomas J. Cashman, Misty E. Vermaat ISBN-13: 9780324826852. A SAM CD is also
required and is bundled with the book. The CD contains training methods to help learn the concepts in the
text. A Guided Tour of Hot Technologies CD is also bundled and is necessary ISBN-13: 9780324829563.
The textbook also has videos in the front cover that you can watch to see each project of the book
created.
CVCC Bookstore link
You must use Office 2007 to do your assignments. A 180 day copy of Office 2007 comes with your book.
Office 2007 is VERY different than the older versions and most assignments use new features from Office
2007 that cannot be done with older versions.
GRADING
Course Grade Points Approximate % of Grade
Announced examinations (4 at 100 points each); Average of the tests = 40% of final grade
Practice Assignments & SAM Assignments (usually In the Lab Assignments) (10 at 100 points each)
Average of the Practice Assignments = 15% of final grade
End of Chapter assignments (usually Cases and Places Assignments)(10 at 100 points each) Average of
End of Chapter Assignments = 25% of final grade
Final Exam 100 points = 20% of final grade
Please note: If a student neglects to submit an assignment, a zero will be given. Please note: A student
cannot expect to pass this course unless all but one of the In the Lab and Cases and Places
Assignments are submitted for grading and receive a grade of 50% or better. Only one zero in each
category will be accepted for a passing grade. The zero will be averaged with the other grades and
cannot be dropped from consideration. It is in the best interests of the student to complete all
assignments and do the SAM assignments first.
Point System: total assigned points = (test average) * .4 + (practice assignments( usually In the Lab)
average) * .15 + (end of chapter assignments(usually Cases and Places)) * .25 + (exam grade) * .2 The
resulting value will be assigned a letter grade based upon:
A = 90 - 100
B = 80-89
C = 70-79
D = 60-69
F = below 60
COURSE POLICIES
Examination Policy
Four announced tests will be given. No make-up tests will be allowed without prior arrangements being
made. Make-up tests must be taken when scheduled. The instructor will make a test available on-line. The
student must take the test at some point during the scheduled days. Once the student signs onto the
system to take a test, a timer will begin - starting from the time he/she signs into the test. The student
should finish the test during the specified time limit at that one sitting. The student may not re-enter the test
after he/she has signed off the test.
Please note: If your Internet Service Provider frequently disconnects, it is urged that you come to
CVCC and take your tests in the Open Lab (room 2414) to prevent being "kicked off" while taking at
test or exam. Once you leave a test or exam for any reason, you will not be allowed back into the
test.
Preparing for Examinations: The majority of examinations will be practical in nature. You will be
required to create, save and place in the dropbox your completed practical files to the instructor.
The practical examinations will incorporate the concepts practiced in the practice and end of
chapter assignments. The student is encouraged to study the chapters, rework the assignments
and study and review the Quick Reference Summary at the back of the book for the application on
which you are being tested.
Appeals Policy
To appeal a grade, send an e-mail to your instructor's e-mail address within two weeks of the grade
having been received. Overdue appeals will not be considered.
Incomplete Policy
Students will not be given an incomplete grade in the course without sound reason and
documented evidence as described in the Student Handbook. In any case, for a student to receive
an incomplete, he or she must be passing and must have completed a significant portion of the
course.
Cheating Policy
Students are expected to uphold the school's standard of conduct relating to academic honesty.
Students assume full responsibility for the content and integrity of the academic work they submit.
The guiding principle of academic integrity shall be that a student's submitted work, examinations,
reports, and projects must be that of the student's own work. Students shall be guilty of violating
the honor code if they:
 1. Represent the work of others as their own.
2. Use or obtain unauthorized assistance in any academic work.
3. Give unauthorized assistance to other students.
4. Modify, without instructor approval, an examination, paper, record, or report for the
purpose of obtaining additional credit.
5. Misrepresent the content of submitted work.
The penalty for violating the honor code is severe. Any student violating the honor code is subject
to receive a failing grade for the course and will be reported to the Office of Dean of Students. If a
student is unclear about whether a particular situation may constitute an honor code violation, the
student should meet with the instructor to discuss the situation.
For this class, it is permissible to assist classmates in general discussions of computing
techniques. General advice and interaction are encouraged. Each person, however, must develop
his or her own solutions to the assigned projects, assignments, and tasks. In other words,
students may not "work together" on graded assignments. Such collaboration constitutes
cheating. A student may not use or copy (by any means) another's work (or portions of it) and
represent it as his/her own. If you need help on an assignment, contact your instructor not other
classmates. If any 2 (or more) students are using the same computer to complete and submit
assignments for the same course, the instructor should be notified immediately. In such a case,
the instructor will give a modified assignment schedule with different assignments for one of the
students. Which student will do the modified assignments will be decided between the students.
Once the decision is made, the students are to stick with the choice of assignments made
throughout the semester.
Disabilities Policy
In compliance with the Americans with Disabilities Act (ADA), all qualified students enrolled in this
course are entitled to "reasonable accommodations." Please notify the instructor during the first
week of class of any accommodations needed for the course.
Laboratory Policy
Although the laboratory End of Chapter assignments (usually Cases and Places) comprise only
30% of a grade, a student will receive a final grade of F if any laboratory assignments are not
handed in (except as outlined above). Laboratory assignments receiving less than a 50% score are
considered not turned in. The student is urged to walk-through each chapter project in the text
prior to attempting the In the Lab and Cases and Places graded assignments. The majority of the
concepts employed in the graded assignments are covered in the chapter project work. The
student will receive the maximum benefit from each project by completing all the chapter
exercises, even though not required for submission to the instructor.
VIEWING YOUR ITE 115 GRADES
1. Click on TOOLS.
2. Click on Check Grade. If you scroll to the right, all grades should be available under the
column heading for each assignment and test.
It is your responsibility to check grades throughout the semester and report lab grade
discrepancies to your instructor.
ASSIGNMENTS AND EXAMINATION SCHEDULE
You are expected to read each assigned project prior to submitting the In the Lab, SAM, or End of
Chapter (Cases and Places)Assignments.
In the Lab and Cases and Places assignments may be submitted ahead of the week date stated in
the calendar and it is suggested the student do so. All In the Lab or Cases and Places assignments
must be submitted to the Digital Drop Box by the due date stated in the syllabus and calendar. The
due date on the syllabus page is absolutely the last day the project will be accepted for grading.
The assignment submitted to the Digital Drop Box after the stated deadline date will not be
accepted for grading and the student will receive a zero (0) for the assignment. Please do not ask
for an extension on the stated date as you have already had an extra week's extension in the stated
date. Projects submitted in the Digital Drop Box after the due date will receive a zero grade.
Plan to spend approximately eight to ten hours each week working on laboratory assignments.
Make sure your name, student ID, and exercise number appear in the upper-left corner of any
submissions to the instructor. It is assumed all work will be deposited in the Digital Drop Box Icon
provided on the TOOLS page. Please note: Periodic, temporary network "down time" will not be an
acceptable excuse for work being submitted late. Please allow for temporary down time when
scheduling your work. Of course, extended network problems will be given due consideration. It
may be necessary to submit more than one file for an assignment. If an assignment indicates you
are to "print" the work, then, please save that work as one file and upload that file. Make any
indicated modifications to the work, then re-save the file with a different name. Both files should be
uploaded for that assignment.
All In the Lab and Cases and Places Assignments are to be done on your computer with all your
work submitted as a file upload activity in the Digital Drop Box icon on the TOOLS page.
Please work ahead of schedule, if possible. If your machine at home misbehaves, you can always
come to the open lab in room 2414 to complete your assignments. This lab is open on Mondays
from 8 a.m. to 5 p.m. and Tuesdays - Thursday from 8 a.m. until 9 p.m. On Fridays, the lab is open
from 8 a.m. until noon..
If your Internet Service Provider frequently "kicks" you off or you lose your connection to the Net
often, please plan to come to the Open Lab to take your tests. Once you have left a test (whether or
not the ISP loses the connection), you may not re-enter the test.