TS 1010 Prospectus

TS 1010, Introduction to Excel 2000

Johnson & Wales University

Instructor: Ray Merry Contact Email: ray@raymerry.com

Office: Adjunct Faculty Office

Office Hours: Mon, Wed. 11AM-12, 3-4 PM

Website: www.raymerry.com Then click on Classes, and then J&W TS 1010

Course Description:

This course is an introduction to Microsoft Excel 2000. In these eight units, you will learn basic through intermediate skills, including building, editing, and formatting worksheets and charts. Additional skills coverage includes working with formulas and functions, managing workbooks and preparing them for the Web, automating Worksheet tasks, and using lists. Basic experience with Windows is assumed. After completing this course, you will have learned all the skills necessary to pass the MOUS (Microsoft Office User Specialist) Exam to become certified in Excel 2000.

Text/Materials:

Text: Reding, Microsoft Excel 2000 - Illustrated Introductory, Course Technology, 2000.

Project files: Available through the www.course.com Web site, or from the instructor.

Student Online Companion - MediaLoft Intranet Web site: www.course.com/illustrated/medialoft.

This site is used for the WebWorks exercise (Independent Challenge 4) at the end of each unit, and builds upon the MediaLoft case study used throughout the book. The site presents a fictional intranet for MediaLoft.

Software: Microsoft Excel 2000, Internet Explorer, and Windows 98.

Handouts: Additional handouts may be provided during the course.

Prerequisite: Introduction to Personal Computing Using Windows 95 or Windows 98

Teaching Methods:

Lectures/Demonstrations: The first half of each class will be used to highlight the important material within each unit using interactive discussions, group work, handouts, and computer demos.
Labs: The last half of each class is dedicated to hands-on learning, facilitated by the instructor. You will work at your own pace during this portion of the class to solidify the lesson material or to begin work on the weekly projects.
Projects: Each project consists of three parts: the Concepts Review, Skills Review, and Visual Workshop from the end of the unit discussed during that week. Eight projects that correlate to Units A-H will be assigned throughout the course.
Quizzes: Four hands-on quizzes will be given. Quiz exercises are pulled from the Independent Challenges at the end of each unit.
Internet Support: Check the class Web page for additional information about Excel, to post a question about this course, or to download student data files. Note that Independent Challenge 4 in each unit requires Internet access.

Grading Grading (Subject to Change):

		TOTAL POSSIBLE POINTS	YOUR SCORE	FINAL LETTER GRADE	TOTAL POINTS
PROJECTS	Unit A	15		A	180-200
8 @ 15 points each	Unit B	15		B	160-179
	Unit C	15		C	140-159
	Unit D	15		D	120-139
	Unit E	15		F	0-119
	Unit F	15
	Unit G	15
	Unit H	15

QUIZZES	Unit A & B	20
4 @ 20 points each	Unit C & D	20
	Unit E & F	20
	Unit G & H	20
TOTAL:		200

Course Policies:

Requirements: You are required to have a text book every day of class. Anyone without a book will be marked as half an absence. You are also required to have 2 floppy diskettes or one zip disk for your class exercises and homework.

Attendance: as per standard J&W Policy, two missed classes and you are out of the class. People more than 5 minutes late are tardy. Three times tardy equals one absence! People doing Email or other unauthorized tasks during class will loose the points for that day's work.

Late Homework/Missed Classes: You are responsible for the activities of each class period. Homework is not accepted late except for excused absence. If you know of a conflict ahead of time, you are welcome to submit projects early. If you do not take a test on the scheduled day, contact me for a makeup quiz.

Assignments: All assignments are due at the end of class on the date due.

Academic Dishonesty: Plagiarism and cheating are serious offenses and may be punished by failure on exam, paper or project; failure in course; and/or expulsion from the University. For more information refer to the "Academic Dishonesty" policy in the University Catalog.

Need for Assistance: If you have any condition, such as a physical or learning disability for which you need extra assistance, please see me immediately. If you have already met with Special Services, please provide me with information regarding your special need as soon as possible so that appropriate accommodations can be made.