Dennis Kamarainen

Instructor, Business & Computers

Fifth Floor of the SVI Campus

Home
About Site
Policies
Assistance

Classes:

AOP0608
AOP0908

 

AOP0608:

Spreadsheet Prod
Dig Img & Web Revs
Spreadsheets
Keyboard Appl

 

AOP0908:

Word Procg

 

Spreadsheet Assignments

 

Table of Contents:

Daily Assignments  |  Required Exercises  |  Assignments Received

 

Notice:  Submit all assignments to dkamarainen@sccd.ctc.edu.  The Subject line should show: 

"Assignment:"  with the name(s) of the assignment(s) that you have attached. 

Daily Assignments:

 

Your course information is posted below by your Studend ID number.

If you feel that you want to improve your score on the Final Exam, you may re-take it by contacting Yonas in the Makeup Lab.  (Thursday will be the last day for re-takes).

Reminder:  Part of your grade is the assignments.

 
  Terms Final Ex 1 Ex 2 Ex 3 Ex 4 Ex 5 Ex 6
SID Date Score Date Score Cmpl/Late Cmpl/Late Cmpl/Late Cmpl/Late Cmpl/Late Cmpl/Late
980-04-2248     7/18 retake            
980-06-9122 7/8 100 7/18 98 x x x x    
980-11-1991 7/8 89 7/18 95     x x    
980-15-0695     7/18 email x   x   x  
980-30-7281 7/8 96 7/18 88 x x x x x  
980-32-1894 7/8 98 7/18 92 x   x x x  
985-54-6665 7/8 92 7/18 email x x x x    
985-62-2777 7/8 92 7/18 82 x          
985-67-1049     7/18 77            
985-75-0703                    
996-50-3728 7/8 93 7/18 retake x x x x x x
996-51-2675                    
996-51-4414 7/8 92 7/18 100 x x x x x  
996-51-4449 7/8 64                
996-51-4471 7/8rt30 90 7/18 96 x x x x x x
996-51-4608 7/8 94 7/21rt0 85 x   x x x  
996-51-4647 7/8 51 7/18 94 x   x x    
996-51-4681 7/8rt   rt 7/18 81 x x x x x  
996-51-4693 7/8 92 7/18 98 x   x   x  
996-51-4694 7/8 52 7/18 retake x   x      

 

 

7/18/08, Fri:  Final Examination

To get credit for your assignments, they must be submitted to your instructor by 11:59 pm on Monday, July 21, 2008.

 

7/17/08, Thu:  Review for Final Exam

We will work together on a Practice Exam to prepare you for tomorrow's Final Examination.

Check your answer against the Practice Final Exam - KEY.

 

7/16/08, Wed:  Outlook in the Office Environment

Discussion and interactive demonstration of Outlook features -- Mail, Calendar, Contacts, Tasks, and Notes.

 

7/15/08, Tue:  Creating and Working with Charts

Complete Excel Exercises 5 and 6, compare them to the Excel Exercise 5 - KEY and Excel Exercise 6 - KEY, and email them to your instructor.

 

7/11/08, Fri:  Creating and Working with Charts

Discussion and interactive demonstration of editing objects in a chart, changing source data, changing a chart type, pie charts, titles, gridlines, and data tables (p. 138 - 144). 

 

7/10/08, Thu:  Formatting a Work sheet

Complete Exercises 3 & 4.  Compare your files to the exercise solutions -- Excel Exercise 3 - KEY and Excel Exercise 4 - KEY.   After you have verified that your answers are correct, email your files to your instructor at dkamarainen@sccd.ctc.edu

 

7/9/08, Wed:  Formatting a Work sheet

Interactive demonstration and discussion of cell alignment, borders, colors, patterns,  format painter, and AutoFormat.  (p. 108 - 115)

 

7/8/08, Tue:  Terminology & Basic Skills Quiz

Interactive demonstration and discussion of row height and column width (p. 104 - 107)

 

7/3/08, Thu:  Review for the Terminology & Basic Skills Quiz

 

The Terminology & Basic Skills Quiz is scheduled for Tuesday, July 8, 2008.

 

7/2/08, Wed:  Formatting a Work sheet

Quick review of the Practice Quiz.

Interactive demonstration and discussion of formatting fonts and values.  (p. 99 - 103)

 

7/1/08, Tue:  Editing a Worksheet

Complete Exercises 1 and 2.

 

6/27/08, Fri:  Editing a Worksheet

Interactive demonstration and discussion of file management, comments, and recovery.  (p. 84 - 91).  Complete the Exercise 1 handout.

 

6/26/08, Thu:  Editing a Worksheet

paste special, inserting and deleting (cells, rows, and columns), repeat, spell check, find and replace, and advanced printing.  (p. 72  - 83)

 

6/25/08, Wed:  Editing a Worksheet

Interactive demonstration and discussion of cutting, copying, pasting, moving with drag and drop, clipboard, and absolute and relative cell references. (p. 64 - 71)

 

6/24/08, Tue:  The Fundamentals

Interactive demonstration and discussion of formulas, AutoFill, Print Preview, help, date values, AutoComplete, and editing cells.  (p. 38 - 63)

 

6/20/08, Fri:  The Fundamentals

Interactive demonstration and discussion of opening, saving, navigating, and ent