Spreadsheet Applications - Version 2003
CT 183-H1
Fall 2006
Used SAM (Skills Assessment Manager) for training and testing
Used WebCT to upload files for grading)
Dates Material Covered Assignments
August 22 Print Course Syllabi & Course Outlines and go over
Show students new college-wide discipline,
Internet & E-Mail policies.

Project 1 PreTest
 

 Have students obtain a jump drive from bookstore and purchase SAM if needed.
August 24 PreTest for course Need textbook, jump drive, and pocket folder next class.
August 29 Make folders on USB drive.
LEARN IT:
Lecture Project 1
SAM Training for Project 1		 LEARN IT:  Homework--
Work through Project 1, starting with page 17, following the numbered steps (red squares with white numbers in them) all the way through the project. DO NOT print until you get to class Thursday.

You MUST save your project with the proper filename in the proper folder on your jump drive. (Drive E, Project 1 folder)

MUST DO THE FOLLOWING:
Remember to PREVIEW the spreadsheet, then click the SETUP button, then click the HEADER/FOOTER tab, then click the CUSTOM HEADER button.  You will then type your name, press ENTER, click the DATE button.  TAB twice to the right side and click the PATH & FILENAME button (the yellow folder).  Keep clicking OK to work your way back to the preview screen.  There you will see your name and the other information in the header area.
August 31 Extreme Blading 2nd Quarter Sales:
Printout #1 - in color
Printout #2 - black and white

LEARN IT: Follow directions given at the right for Header information
In the Lab #2, pages EX59-61
Printout #1 - in color
Printout #2 - Black and white
Printout #3 - Black and white

EXPAND IT!
Cases & Places #1, page EX63:
Printout #1 - in color
Printout #2 - black and white

 MUST DO THE FOLLOWING:
Remember to PREVIEW the spreadsheet, then click the SETUP button, then click the HEADER/FOOTER tab, then click the CUSTOM HEADER button.  You will then type your name, press ENTER, click the DATE button.  TAB twice to the right side and click the PATH & FILENAME button (the yellow folder).  Keep clicking OK to work your way back to the preview screen.  There you will see your name and the other information in the header area.
September 5 All folders are due with all assignments inside them.  Also, you should have e-mailed all assignments to instructor through WebCT.

REVIEW IT!
Review in SAM with Task review and Objective Review.  Grades WILL be taken on these.

 Formulas Version must be printed for each new spreadsheet created.  Here's how:

1) Have spreadsheet open in Excel
2) PRESS the combination CTRL + ~ on the keyboard. This will display formulas within the cells where they reside.
3) Using Print Preview, click SETUP, then the PAGE tab, then choose LANDSCAPE in the Orientation section, and then choose PRINT TO 1 PAGE in the SCALING section.
4) Print in Black and White
5) After obtaining printout, go back to setup and choose PORTRAIT in the orientation section and ADJUST TO 100% NORMAL SIZE.
6) Click OK
7) Close PREVIEW.
September 7 TEST IT!
SAM ProGrader Exam on Project 1		  
September 12 WebCT Link (you may download your graded work to see your mistakes)

LEARN IT!
Lecture - Project 2

 HOMEWORK!!
Work through numbered steps in Project 2 to create the Blue Chip Stock Club Investment Analysis spreadsheet.  Complete all steps throughout Project 2. No printouts needed for instructor. You will E-mail the file through WebCT.
September 14 WebCT Link (You may upload any completed assignments)

LEARN IT!
Training on Project 2 in SAM
In the Lab #2 Assignment

 No Printouts Needed
September 19 EXPAND IT!  Cases & Places #1

WebCT Link (You may upload any completed assignments)
September 21 Complete all assigned exercises  
September 26 REVIEW IT!
Review in SAM with Task review and Objective Review.  Grades WILL be taken on these.		  
September 28 TEST IT!
SAM ProGrader Exam on Project 2		  
October 3 LEARN IT!
Project 3 Lecture

Students begin work on spreadsheet in the project.

 Homework:
Complete spreadsheet for next class.
October 5 E-Mail assigned spreadsheet from Project 3

LEARN IT!
Training on Project 3 Tasks in SAM

  
October 10 LEARN IT!
In the Lab Assignment		 Work on assignment to have ready for next class.
October 12 EXPAND IT!
Cases & Places Assignment		 Work on assignment to have ready for next class.
October 17 REVIEW IT!
Review Quizzes on Project 3 in SAM		  
October 19 TEST IT!
SAM ProGrader Exam on Project 2		  
October 24 LEARN IT!
Lecture Project 4		 HOMEWORK:
Complete Project 4 e-Money Lenders Loan Payment Calculator spreadsheet.
October 26 Submit the e-Money Lenders Loan Payment Calculator spreadsheet through WebCT

LEARN IT!
1) Training on Project 4 in SAM
2) Assignment to be completed by October 31:  In the Lab #1, pages EX 297-299.

 HOMEWORK:
Complete In the Lab #1 by Tuesday, October 31 to submit through WebCT
October 31 Submit the Lab 4-1 Part 1 401(k) Planning Sheet and the Lab 4-1 Part 2 401(k) Planning Sheet through WebCT

REVIEW IT!
Quizzes in SAM (objective and Task Quizzes) over Project 4

 HOMEWORK:
EXPAND IT!
Cases & Places #1 (There are two handouts to help with this spreadsheet.  Get from instructor)
DUE in WEBCT by November 7, 2006
November 2 TEST IT!
SAM ProGrader Exam on Project 4		 Practice project 4 training as needed to prepare for tasks assignment below.
May redo Project 4 tasks as a homework assignment.  I will count highest grade. It will be available to you until Tuesday of next week.
November 7 Cases & Places #1 Due Today.
LEARN IT!
Lecture on Project 5 Objectives.		 HOMEWORK:
Complete Project 5 for next class.
November 9 E-mail Project 5 spreadsheet to instructor
LEARN IT!
Project 5 Training in SAM		 HOMEWORK:
LEARN IT!
In the Lab #3.  Do all 5 parts!!  You will not print anything, but you must complete all 5 parts to know if you can do the work and understand it.  You will have two files when you finish.  Send both of them to me thru WebCT. They are:
Lab 5-3 Enviro Student Club List
Lab 5-3 Enviro Student Club List Final
November 14 EXPAND IT!
CASE #1 Assignment		  
November 16 REVIEW IT!
Project 5 Task Quiz
Project 5 Objective Quiz		  
November 21 TEST IT!
Project 5 SAM Exam (Tasks Only)		  
November 23 Thanksgiving Holiday! - No Classes  
November 28 LEARN IT!
Complete Project 6		 Complete Project 6 Spreadsheet by next class.
November 30 E-Mail Project 6 to instructor.
LEARN IT!
Training on Project 6
POSTTEST		 REVIEW available in SAM over Projects 1 - 6)
December 6 10:30 - 12:30 Final Exam (SAM tasks over Projects 1 - 6)