Instructor: Diane Perreault

Phone (Messages can be left) 278-6315

E-Mail: dperreault@csus.edu Web Page www.csus.edu/indiv/p/perreault/

RequiredTextbook: Comprehensive Microsoft Excel 2000 by Parsons, Oja, Ageloff and Carey

Additional Material:

5 – 15 Diskettes or one zip disk. The book is divided into 3 levels. Each level has separate data files. The authors have created separate folders for each of the 3 levels. Within each level, there is a folder for the chapter tutorials, review assignment, which we will not be using, and each of the cases within each chapter. The last level also has data files for the additional cases at the end of the book. To assure that you will not run out of space, you should store the data in the same organization. You should be able to hold files for a chapter on a diskette, but you may want to have a separate disk for the chapter files and the cases. If you are using a zip disk, all the files should fit on the zip disk. Once the data files have been copied, the assignments can be done at home if you have Excel 2000 at home. These files will be recognized with Excel 97 and Excel XP.

PERFORMANCE OBJECTIVES

Level 1 Covered in CIS 12A

· Identify parts of the Excel Screens and Toolbars

· Create Excel worksheets using built-in functions

· Understand relative, mixed and absolute cell addresses

· Apply edit features to a worksheet

· Create Charts

Level 2 Covered in CIS 12A and CIS 12B

· Working with Excel Lists—Filtering, inserting Subtotals, and creating Pivot Tables

· Integrating Excel with other programs

· Using the World Wide Web and hyperlinks

· Creating Templates and using Macros

· Working with Multiple worksheets and workbooks

Level 3 Covered in CIS 12B

· Using data tables and creating Scenarios

· Using Solver

· Importing Data into Excel

· Using Visual Basic with Excel

COURSE COMPLETION REQUIREMENTS

· Attend class during the time for which you registered.

· Read the assigned chapters and complete the assigned chapter exercises before coming to class.

· Complete and hand in assignments on time.

· Complete theory or hands on exams

· Complete the final theory exam and/or project

GRADING: labs(10 points each) & Review Sheets 45 %

Exams 45 %

Final Project 10 %

A - 90 - 100 % B - 80 - 89 % C - 70 - 79 % D - 60 - 69 %

Course Assignments

The chapter tutorials printout requirements are listed on the next page. Unless otherwise stated in class, you are required to turn in each of the first four cases at the end of each chapter.

Week	Topic	Assignment Covered	Assn Due
1^st ^03/29/03	Creating Templates Last Day to Register for the Class 3/30/03	Tutorial 7
2^nd ^04/05/03	Working with Multiple Worksheets and Workbooks Last day to Petition Credit/No Credit 4/11/03	Tutorial 8	Chapter 7 Printout Chapter 7 Review Tut 7 Cases 1,2,3,4
3^rd ^04/12/03	Data Tables and Scenario Management 4/13/03 Last Day to Drop Without Notation	Tutorial 9	Chapter 8 Printout Chapter 8 Review Tut 8 Cases 1,2,3,4
4^th	Spring Break No Class 4/19/03
5^th ^04//26/03	Using Solver	Tutorial 10	Chapter 9 Printout Chapter 9 Review Tut 9 Cases 1,2,3,4
6^th ^05/03/03	Importing Data into Excel	Tutorial 11	Chapter 10 Printout Chapter 10 Review Tut 10 Cases1,2,3,4
7^th ^05/10/03	Enhancing Excel with Visual Basic	Tutorial 12	Chapter 11 Printout Chapter 11 Review Tut 11 Cases 1,2,3,4
8^th ^05/17/03	Review		Chapter 12 Printout Chapter 12 Review Tut 12 Cases 1,2,3,4
9^th	Exam Tutorials 7 - 12 Final Projects 05/24/03 10:45 – 12:45

Any indication of academic dishonesty (cheating) will result in a zero for the quiz, exam, assignment, etc. The matter will be referred to the Business Division Dean and Campus Discipline Officer for appropriate action.

Chapter Tutorial Printed Requirements Chapters 7 – 12

Chapter 7 401K.xls Need Formulas and Macro Code

Page 7.44 Figure 7-45

Print report, entire sheet, formulas and macro code

Chapter 8 New Worksheet Grades2.xls

Page 8.23 Print all sheets Need formulas for Summary Sheet

Skip section on templates (section 8.2)

White.xls TA1.xls TA2.xls TA3.xls TA4.xls

Page 8.37 Figure 8-30 Need formulas

Print Section 1 of TA1.xls

Page 8.45 Figure 8-37

Chapter 9 Davis.xls Do not need formulas printed

Page 9.22 After step 7

Page 9.36 Figure 9-36

Chapter 10 New Workbook Goldstar.xls Do not need formulas printed

Page 10.28 Figure 10-25 Print Answer Report and worksheet

Chapter 11 History.txt

Page 11.11 Figure 11.11 Print chart

Sunrise.mdb

Page 11.26 Figure 11-24

Page 11.28 Print Pivot Table

Chapter 12 Imageon.xls

Page 12.60 Print visual basic code and a screenshot of worksheet

(hit print scrn button on your keyboard, then open word and paste the image into a word document)

Files used in Chapter Cases Chapters 7 – 12

Chapter 7

Case 1 New Workbook

Print both versions of data, formulas, and macro code

Case 2 New Workbook

Print all versions of data, formulas, and macro code

Case 3 New Workbook

Print all versions of data, formulas, and macro code

Case 4 Invoices.xls

Print worksheet, formulas, and macro code

Chapter 8

Case 1 Copies.xls Steps 1 – 9 only Need Formulas printed

Case 2 Kitchen.xls Need Formulas printed

Case 3 Index.xls Need Formulas printed

Case 4 R1.xls R2.xls R3.xls R4.xls and New Workbook Need Formulas printed

Chapter 9 No formulas needed to print

Case 1 HomeEd.xls

Case 2 Prints.xls

Case 3 Bakery.xls

Case 4 Chen.xls

Chapter 10 No formulas needed to print. Do need worksheet and Answer Report

Case 1 Couches.xls

Case 2 Pontoon.xls

Case 3 Pizza.xls

Case 4 New Workbook

Chapter 11 No formulas needed to print

Case 1 Invoice.txt

Case 2 New Workbook

Case 3 New Workbook

Case 4 New Workbook

Chapter 12 Need Visual Basic code printed along with the worksheet

Case 1 Casey.xls

Case 2 Brakdale.xls

Case 3 Stocks.xls

Case 4 New Workbook