Link to Rocha's  Homepage

CISA 310 Schedule

Campus Email -- Home Email -- Los Rios Blackboard Login

SCC Homepage -- Business Area Webpage

Text Web Site:

These are the TENTATIVE dates, topics and assignments for this course. The Instructor reserves the right to adjust or change this schedule or assignments. Labs are due at the first class meeting of the following week. Labs that are 1 class late lose 20% automatically. Final Project is due at the last class meeting.

All lessons must be completed by the end of the semester in order to receive a final grade.  Responsibility is placed on the individual student to complete all assignments in a timely matter in order to complete the course. Keep copies of all files until the final week to verify the accuracy of the Blackboard gradesheet.

All assignments: Enter your name, laboratory assignment name and number, and the date in the custom header. Check the print preview and adjust to print as efficiently as possible.

Week

Lecture

Lab

1

Using Excel to Manage Data

Tutorial 1–Cases 2 and 3

2

Working with Formulas and Functions
Introduce Final Project

Tutorial 2—Cases 3 and 4

3

Developing a Professional Document

Tutorial 3—Cases 2, 3, and 4

4

Working with Charts and Graphics

Tutorial 4—Cases 1, 2, and 3

Independent Project

Handout 

5

Working with Excel Lists

Tutorial 5—Cases 2, 3, and 4

Working with Multiple Worksheets and Workbooks

Tutorial 6—Cases 2, 3, and 4

6

Working with Excel’s Editing and Web Tools

Tutorial 7—Cases 1 and 4

Developing an Excel Application

Tutorial 8—Cases 1 and 4

7

Data Tables and Scenario Manager

Tutorial 9—Cases 1, 3, and 4
Final Project Rubric

Using Solver
Questions on Final Project

Tutorial 10—Cases 2 or 3

8

Importing Data into Excel Questions on Final Project

Tutorial 1l—Cases 3 and 4

9

Final Project

Submit Final Project

 

Contents remain the sole property of Patricia Rocha

Last Update: August 2006