ITE 140
Spreadsheet Software (MsExcel)
Syllabus

General ELI Policies and Procedures

COURSE SUMMARY
This course provides a working knowledge of MsExcel which will include designing a variety of worksheets, preparing graphs, working with database query, macro writing, and menu techniques. Emphasis is on the functional rather that the technical approach to understanding, using, and managing electronic spreadsheets. Prerequisite:  ITE 115 (IST 117) or division approval.

return to top

COURSE MATERIALS

The textbook is:  Excel 2000 Complete Concepts and Techniques   Shelly, Cashman, Quasney
The textbook may be purchases in any NVCC campus bookstore or from the Publisher's Web Site .  You can also find a link to download the student data files on the Publisher's Web Site in the event that your textbook doesn't have the student data disk.

All students must have access to the internet.  You will need a web browser and email capabilities.  If you do not have access to an Internet Service Provider, you may use an internet account at the college which will require you to come on campus to use NVCC's internet connection.

Spring 2005 Students ONLY

SAM 2003 Assessment (2.0)
ISBN: 0619-17259-2. You will need this CD for taking online quizzes and exams. For instructions on how to install and use SAM 2003 see Syllabus/Online Quizzes and Exams Using SAM 2003.

To run SAM 2003, your computer must meet the following system requirements:



return to top

COURSE OBJECTIVES
Upon completion of this course, the student will be able to:

  1. Discuss electronic spreadsheet characteristics, capabilities, limitations, applications, and problems
  2. Create, save, retrieve, and update a spreadsheet.
  3. Use the full range of spreadsheet capabilities for data analysis.
  4. Create formats and call for reports from a spreadsheet file management system.
  5. Develop standard graphics presentations.
  6. Create and use keyboard macros.
  7. Apply "what if" techniques to simple analytic models.
  8. Interchange data with other application programs.


return to top

GRADING SCALE


Assignments
% of Final Grade
Introductory Letter
5%
Assignment 1
5%
Assignment 2
5%
Assignment 3
10%
Assignment 4
10%
Assignment 5
10%
Assignment 6
10%
Exam 1
15%
Exam 2
15%
Exam 3
15%
Total Grade
100%


Final grades are based on the following scale:
A = 94 - 100%
B = 84 - 93%
C = 74 - 83%
D = 64 - 73%
F = below 64%

return to top

COURSE NOTES
You must pass, with a 64% or better, 2 out of the 3 exams in order to pass this course, regardless of the percentage of points you have earned.

Please note that your Start date, Withdrawal date, and End of Enrollment date are very important.  They are listed on the Quick Start Syllabus you received in the mail.  Please note the meaning of each in this course:

Start Date:  This is the date when your semester begins and you may begin submitting assignments.

Withdrawal Date: You may choose to withdraw from the course prior to this date for any reason.  After this date you must have a mitigating circumstance as well as instructor approval.

Please note: In order to avoid being administratively withdrawn from the course the instructor must receive your Introductory Email prior to your withdrawal date.  Once the Introductory Email has been received, you will not be administratively withdrawn from the course and it will be your responsibility to initiate a withdraw from the course should you desire to do so.

End of Enrollment Date:  This is the date by which you need to submit all assignments and exams.  If you get close to your end of enrollment date and find you need a time extension, you may send the instructor an email requesting one provided you have successfully completed at least 50% of the course requirements.  Fifty percent of the course requirements would be:  Assignments 1-3 and Exam 1.

return to top
 
 


Return to ITE 140 Home Page