| Instructor
Information: |
| Instructor:
|
Ms. Shiaoling Peng |
|
Office Hours: |
On-campus: Tuesday 2:00 - 3:50 p.m.;
Thursday 2:00 - 2:50 p.m.
Online: Monday, Wednesday 11:00 a.m. -
2:00
p.m.; Friday 2:00 p.m. - 4:00 p.m.
Emails received during these 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-8611 |
|
Web Site: |
http://faculty.inverhills.edu/speng/index.htm |
|
|
Textbook: |
Microsoft
Excel 2010 (Author:
Parsons, Oja, Ageloff, Carey
Publisher:
Course Technology ISBN:
978-0-538-74291-7)
This class covers tutorial 1-4.
|
| Prerequisite: |
- Working Knowledge of Windows
- Math
0096/0099 on assessment test.
|
| Course Description: |
This
course provides an introduction to Microsoft Excel 2010.
Topics include worksheet creation,
formulas, functions, what-if analysis, formatting, graphing, and
printing. |
| Class
Policies: |
|
Quizzes |
|
There will be four in-class quizzes and a take-home quiz. No
make-up quizzes will be given unless an arrangement is made
PRIOR to the time of the quiz.
|
|
In-Class Assignments |
|
For each tutorial, I will walk you through the steps in class.
You will have created an excel file by the end of the tutorial.
This file is submitted to D2L by the end of the class and will
be graded as "In-Class" assignments. If you have to miss a class, you will need
to make up the work on your own and submit the file before 6:00
pm on the date of the following class. I will not be able to go
through the tutorial outside of the class. No late In-Class
assignments will be accepted.
|
|
Take-Home Assignments |
|
To reinforce the skill you have learned from the Tutorial, you
will be working on the "Review Assignment" after the tutorial.
There will be four take-home assignments. Late take-home
assignments will be penalized by 20% and must be submitted
within one week from the due date.
|
|
Incomplete: |
To receive an
"Incomplete", you must be achieving a grade of C or
better and have completed at least 75% of
the required work unless you have a documented medical
condition. It is your responsibility to provide a written request
for the "Incomplete".
|
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.
|
|
The "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.
|
|
| Grading: |
Your
final grade will be determined based on the total points you earn on the quizzes, in-class assignments,
and take-home assignments.
- In-class assignments: This is the result of following
the tutorial in the book. I will walk you through the steps in
class.
- Take-home assignments: You will be asked to create
Excel files using the skills you have learnt in class. You will
need to figure out the steps on your own.
- Quizzes: A quiz will be given after each tutorial.
The in-class quizzes are closed book.
In general, 91-100% guarantees
an A, 81-90.9% for B, 71-80.9% for C, 61-70.9% for D, and a
percentage below 61% is an F.
| Category |
Number
of Units |
Points |
Percentage
(approximate) |
| Points
per Unit |
Category
Total |
|
Quizzes |
5 |
20 |
100 |
50% |
|
In-Class
Assignments |
4 |
5 |
20 |
10% |
|
Take-Home Assignments |
4 |
20 |
80 |
40% |
| Total |
|
|
200 |
100% |
|
|
|
|
Special Needs: |
Students
with special needs should contact me or the Disability Services Office
located at L-224 (phone, 651/450-8628; TTY, 651/450-8369). |
|
Assignments:
|
All
take-home assignments are to be submitted electronically via D2L. You do
not need to submit the printed copies of the files.
I do not accept assignments emailed to me. |
|
Tutorial 1 Assignment: |
Review
Assignment on pages EX
49 - 50 |
|
Tutorial 2 Assignment: |
Review
Assignment on pages EX
108 - 109 |
|
Tutorial 3 Assignment: |
Review
Assignment on pages EX
163 - 164 |
|
Tutorial 4 Assignment: |
Review
Assignment on pages EX
223 - 224 |
|
Tentative Calendar: |
| Dates |
Class Contents |
| 8/23 |
-
Syllabus
- IHCC Network Account
- Desire2Learn
- Managing Your Files
- Office 2010
|
| 8/30 |
- Quiz on
Managing Your Files and Office 2010
- Tutorial
1: Getting Started with Excel
-
Take-home Tutorial 1 assignment Due 6:00 p.m. 9/6
|
| 9/6 |
- Quiz on
Tutorial 1
- Tutorial
2: Formatting a Workbook
-
Take-home Tutorial
2 assignment Due
6:00 p.m. 9/13
|
| 9/13 |
- Quiz on
Tutorial 2
- Tutorial
3: Working with Formulas and Functions
-
Take-home Tutorial
3 assignment Due
6:00 p.m. 9/20
|
| 9/20 |
- Quiz on
Tutorial 3
- Tutorial
4: Working with Charts and Graphics
-
Take-home Tutorial
4
assignment Due 9/26
- Take-home quiz on Tutorial 4 due 9/26
|
|
