| Instructor
Information: |
| Instructor:
|
Ms. Shiaoling Peng |
|
Office Hours: |
On-campus: Tuesday, Thursday: 10:00 - 10:50 a.m.;
12:30 - 1:50 p.m.
Online: Monday, Wednesday, Friday: 12:00 noon -
3:00
p.m.
Emails received during office hours will be replied the
same day. They will be replied during the next office hour if
received outside of the office hours.
|
|
Office Location: |
Business
Building, Room 129 |
|
Email: |
speng@inverhills.edu |
|
Office Phone: |
(651) 450-3611 |
|
Web Site: |
http://faculty.inverhills.edu/speng/ |
|
| Course Material: |
The
two books and the access code to SAM 2010 are bundled in one package and is available at the Inver
Hills Community College book store.
Each item may cost more if purchased separately.
|
|
Software for the Class:
Microsoft Office 2010 |
|
You will need to
have access to a computer with the following software
installed:
Word 2010,
PowerPoint 2010, Excel 2010 and Access 2010.
|
All required software are available on the computers in the
open lab on campus.
If working on campus is not feasible for you, you must make
sure you have access to a computer with required software off campus at the beginning of the
class.
Please
note the home and student edition of Office 2010 do not include Access.
|
|
| Course Websites: |
This class
will use three Websites:
 |
Desire2Learn (D2L): you will use this site to do the following:
 |
Keep your grade book. |
|
Submit in-class software projects. |
|
Take tests on Discovering Computers book.
|
|
|
CoursePort (http://login.course.com):
You will use this site to do the following
|
Take practice test for each chapter in the Discovering Computers book. |
|
Work on the online labs (Student Edition Labs). |
|
Watch videos. |
|
The Class Code is
3DCF2608
|
|
|
SAM2010
(http://sam2010.course.com): You will use this site to do the following
|
Take practice test and the actual test on Word, Excel, Access, and PowerPoint. |
|
Download start files and instructions for SAM software projects. |
|
Submit SAM software projects. |
| The
IHCC institution key needed to register at SAM is
T2047469
|
|
|
| Course Topics: |
This class
has two components: the concepts related to computers (using the
Discovering Computers 2011 book) and application software (using the
Office 2011 book). The topics covered are:
|
Concepts
covered in the Discovering Computers Fundamental 2011 book
|
Computer
Basics: System Unit, Input, Output, Storage, Operating System |
|
Communications
and the Internet |
Computer
Software covered in the
Office 2007 book:
|
Operating Systems |
|
Word Processing Software: MS Word |
|
Presentation Software: Power Point |
|
Spreadsheet Software: MS Excel |
|
Data Base Software: MS Access |
|
We will
cover chapters 1 through 8 from the
Discovering Computers book and all chapters on Word, Power Point, Excel,
and Access, from the Office 2011 book.
|
| Student Responsibility: |
| Know
and adhere to the class policies, deadlines. |
| Spend
9-12 hours per week studying and working on assignments for the class. |
| Complete
all assignments and tests. |
| Read the class announcements at D2L for each class period. |
|
|
Assignments: |
Assignments in this
class cover both books.
|
|
Discovering Computers |
For each chapter in this book, you will be given a quiz. The
quiz contains 20 multiple questions based on the chapter. Each of
these quizzes is timed at 20 minutes. Each quiz can be taken only
once.
To prepare for a quiz before you take it at D2L, you should
take the practice test for the chapter at CoursePort. CoursePort provides other resources helpful for your
understanding of the course material. You should explore the
the site to see which fit you the best. While you can do any
activities as you like, the work you do at CoursePort
will NOT be recorded or graded. The practice tests can be repeated as many times as you
like. However, each quiz at D2L can be taken only once.
At the end of the semester, there is a comprehensive exam
covering all chapters in the book.
|
| Office 2010 |
For each chapter in this book, you will be graded as
the following:
|
I will walk through the steps in the book with your
in class to create a file (or files). You will submit these files
using the drop boxes at D2L at the end of the class. I
will grade these assignments manually. These assignments
must be done and completed in class. If you miss an in-class
assignment, you can make it up by taking a quiz at D2L.
|
|
To reinforce what you have learned from the chapter, you
will work on a SAM Project. For these projects, you will
log in to SAM to download the instruction and a
start file. You will follow the instructions to modify
the start file. When you are done, you will submit the
file to SAM. These files will be graded immediately
by a software and you can see your score right
away. You are allowed five attempts for each assignment
at SAM. If you are not satisfied with the score
after a submission, you should read the report for any
marked errors. You can resubmit the assignment (up to
five submissions) after you make corrections.
|
There is a unit exam after each of the following
Office component: Word, PowerPoint, Excel, and Access. Tis
exam can be taken only once.
|
|
| Class
Policies: |
| Late Assignments |
|
Late
take home assignments will not
be accepted in this class. If you missed an in-class assignment, you
can make up the assignment by taking the corresponding quiz
before its deadline.
|
|
Incomplete: |
To receive an
"Incomplete", you must have completed at least 75% of
the required work and is getting a grade of C or better unless you have a "documented" medical
condition. It is your responsibility to provide a written request
for the "Incomplete".
|
| Academic Dishonesty: |
Each student must do all of their
own work, including every single step of every single problem. Letting
other people do your work and taking the credit as your own is a form of academic dishonesty. An
assignment, quiz, or exam will receive a score of zero if
you cheat.
|
Grade
Book Keeping:
Your
grades will be kept at D2L course site. You can check your
grades anytime during the semester. If you have disputes regarding
the score of a specific item, you must talk to the instructor
within two weeks from the time the score becomes available at
D2L.
Deadline
for "W" grade:
If you have
decided not to participate in this class during the semester, it is
important that you officially withdraw from the class at the registration
office. Otherwise, your grade for this class will be F on your
transcript. The
last day to drop with a "W" is April 18, 2012.
| | |
|
| Grading: |
The
following table shows the break down of your
grade
for this class.
In general, 92-100% guarantees
an A, 82-91.9% for B, 72-81.9% for C, 60-71.9% for D, and a
percentage below 60% is an F.
| Category |
Percentage
of the maximum total |
|
Concepts (Discovering Computers) |
40% |
|
Word |
15% |
| PowerPoint |
15% |
| Excel |
15% |
| Access |
15% |
| Total |
100% |
|
|
| Special Needs: |
Students with
special needs should contact me or
the Disability
Services Office located at L-224 (phone, 651/450-3628; TTY, 651/450-3369). |
| Tentative
Calendar: |
| Dates |
Tuesday |
Thursday |
| 1/10, 1/12 |
--Syllabus
--IHCC Network Account
--Desire2Learn
--CoursePort
and SAM2010 |
DC 11: Ch. 1
Introduction to Computers
Office 2010: Introduction to Computers |
| 1/17, 1/19 |
DC 11: Ch.2
The Internet and World Wide Web |
Office 2010: Office 2010 and Windows 7
DC 11: Ch. 3 Application Software |
| 1/24, 1/26 |
Office 2010:
Word
Chapter 1 |
Office 2010: Word Chapter 2 |
| 1/31, 2/2 |
Office 2010:
Word
Chapter 2 |
DC 11: Ch. 4
The Components of the System Unit |
| 2/7, 2/9 |
Student Success Day |
Office 2010: Word Chapter 3 |
| 2/14, 2/16 |
Office 2010: Word
Chapter 3 |
Office 2010:
PowerPoint Chapter 1 |
| 2/21, 2/23 |
DC 11: Ch. 5
Input |
Lab Test:
Word |
| 2/28, 3/1 |
Office 2010:
PowerPoint Chapter 2 |
Office 2010:
PowerPoint Chapter 3 |
| 3/6,
3/8 |
Spring Break |
| 3/13,
3/15 |
DC 11: Ch. 6
Output |
Lab Test:
PowerPoint |
| 3/20,
3/22 |
Office 2010: Excel Chapter 1 |
Office 2010: Excel Chapter 2 |
| 3/27, 3/29 |
Office 2010: Excel Chapter
2 |
Office 2010: Excel Chapter
3 |
| 4/3, 4/5 |
Office 2010: Excel Chapter
3 |
DC 11: Ch. 7
Storage |
| 4/10, 4/12 |
Lab Test:
Excel |
Office 2010: Access Chapter
1 |
| 4/17, 4/19 |
Office 2010: Access Chapter
2 |
Office 2010:
Access Chapter 2 |
| 4/24, 4/26 |
Office 2010: Access Chapter 3 |
Office 2010: Access Chapter
3 |
| 5/1, 5/3 |
DC 11: Ch. 8
Operating Systems and Utility Programs |
Lab Test:
Access |
| 5/7-5/10 | There is no class during the final's week. |
| 5/16 | Grades available |
|
