Excel certification Preparation
|When do I work on this class?||
Although you can work on this class 24/7, this is not a self-paced class. Weekly lessons will be printed by the students, but each lesson may be worked on at any time during the week.
|When does the class begin?||This class begins on Aug. 27 Any students who has not contacted the instructor by e-mail message or phone call by Aug. 30 may be dropped from the class. The e-mail message need only say the student is ready to begin.|
|When are assignments due?||Assignments are always due on the day specified in the class calendar. Since in an online class, assignments can be turned in any hour of the day or night, it is necessary to have a time due. Messages placed inside WebCT and containing assignments can have a time stamp of 11:59:59 pm. as long as the date is the due date. A message containing a time stamp of 00:00:01 and a date showing the next day will be considered late. The moral of this is finish up the assignment and send it during the day it is due.|
|What if I am absent?||
This class is intensive and requires attendance and work completed each week. Anyone not in communication with me for any two week period (without prior approval) may have an F grade recorded as the final class grade. The worst part of an online class is procrastination!!!
|Where are the tests?||
The traditional class tests are replaced with projects. The midterm project will be worked on by a small group of students. The final project will be an individual effort.
|What is this individual project?||You will be expected to build a working workbook designed to solve a specific problem. it will be worth more than other assignments. It will be due on Dec. 10. More information will be given out half way through the semester.|
|Can I do extra credit to improve my grade?||Yes, if your average is below a C and if you have turned in all assignments. It does no good to do extra credit if you are not turning in regular assignments.|
|Can I turn in late assignments?||Yes. Each week an assignment is late, its worth drops 5 points. Since most assignments are worth 20 points, this means after 3 weeks late, the assignment won't be worth enough to bother turning in. The late assignment is graded and the result reduced the 5, 10 or 15 points. Any last, late assignments must be turned in no later than Dec. 7.|
|What version of Excel is covered in this class?||
This class covers Microsoft Excel 2003 (although 2002 or 2007 can be used, the book is specifically for 2003.) Any files sent from Excel 2007, must be converted to 2003 before they are turned in.
|What should I know as I begin this class?||
This is a second course in Excel. Students should have already worked with Excel, either work experience, or have have taken taken a class such as IS 201 or a one-credit Excel class. although not mandatory as part of the class, it is aimed toward students passing the Microsoft Office User Specialist Certification in Excel 2003 Expert.
|Why is it called Excel certification Preparation||Although not part of the class, the goals of this class are to prepare you to take the MOUS Excel Expert certification test.|
Text: New Perspectives MS Excel 2003 Comprehensive,Expert by Parsons, Oja, Ageloff and Carey.
To find cheaper textbooks, click here
Revision date: April 22, 2007
Instructor: Larry Hyslop
Office: High Tech Center- 132
Office hours: M-W,F 10-11
Great Basin College
1500 College Pkwy.
Elko, NV 89801
Phone: 775-753-2305 (office)
753-8095 (home, before 8pm)
775-738-8771 (college fax)
Email (outside of WebCT): larryh (at) gwmail.gbcnv.edu
Note: I check my email M-F only.
CIT 202 Excel Certification Preparation (3) In-depth exploration of Excel spreadsheets. Topics include advanced functions, importing and exporting data, multiple tables and workbooks, pivot tables, macros and VBA. Team and student projects are conducted. Prerequisite: IS 201 or instructor’s approval.
Course Objectives/Measured by:
Use Excel to solve business-oriented problems./a,b,c
Build well-designed, easily understood and easily worked workbooks./a,b,c
Work with advanced features of Excel, such as pivot tables, auditing, sharing, validation, query and advanced formulas./a,b,c
Enhance workbooks with macros and Visual Basic./a,b,c
The above objectives will be measured using a combination of:
The class will be taught by introducing a new skill or concept. The student practices on the computer by going through a tutorial in the book. Assignments are completed and turned in.
The assignments will consist of exercises from the instructor and the book. Each assignment will be graded on a points system. The assignments can be completed on your own time, and will require substantial time spent in the computer lab to complete. Two assignments will require two students to work together in completing a task.
Cumulative grades will be determined as follows:
92-90 A- Worth:
89-88 B+ Assignments: 65%
87-83 B Team Projects: 15%
82-80 B- Individual Project: 20%
Cumulative grading will use + and - on assignments, tests and the final, recorded grade.
Some times, and for very good reasons, a student is not able to finish a class, and needs to withdraw from the class.
Through week 12:
A grade of W (withdrawn) will be recorded for anyone who formally withdraws by meeting with the instructor and filling out a withdraw form.
A grade of F will be recorded for anyone who simply does not come to class any more.
It is important to realize that for any one withdrawing from the class, the difference between earning an W on the official class record or earning an F is the process of formally withdrawing
After week 12:
Anyone withdrawing will receive a grade based on all assignments, including those missed.
Extra credit may be earned if your grade is currently a D or below.
Before doing anything regarding this class, please consult with me. It is my job to assist you in making class decisions.
Some times during the class, your completed
assignments may be displayed for the benefit of the entire class. If this
bothers you, please notify me in writing during the first week of class.
Do not allow yourself to get snowed under by a command or concept you do not understand. Meet with the instructor and get it straightened out. Expect to spend considerable time on the computer outside of class.
The student will communicate with the instructor through e-mail, online office hours and telephone calls. The students will communicate with each other through e-mail and a discussion board.
A main set of student files will be downloaded from the Internet. Instructions will be part of lesson 1.Any additional files will be sent to students attached to email messages.
This is a full semester class requiring considerable time spent on the computer each and every of the 16 weeks. You must be prepared to make this commitment.
GBC supports providing equal access for students with disabilities. An advisor is available to discuss appropriate accommodations with students. Please contact the ADA Officer (Julie Byrnes at 775-753-2271 at your earliest convenience to request timely and appropriate accommodations.