CSc210 / CSc501H - Professor Domanski - Applications Programming

Unofficial Final Grades are Posted Here

Grades

Course Contents: Microsoft Office 2007 components including:

Virtual Lecture - Click on Image Topic
Video thumbnail. Click to play

Virtual Lecture:  3/25/2008 -
Excel Chapter 4 -
Financial Functions, Data Tables,
Amortization Schedules

Click To Play
 
Video thumbnail. Click to play
 

Virtual Lecture:  4/07/2008 -
Excel Chapter 5 - Data Tables
Excel Chapter 6- Templates

Click To Play

 
Video thumbnail. Click to play
 

Virtual Lecture - 5/06/2008
Access Chapter 6
Macros, Switchboards, Pivot Tables & Pivot Charts

Click To Play

Prereq: CSc102 or Equivalent, or CSc126

Textbook - Available in the CSI Bookstore under "BUS 250": 
Microsoft Office 2007 Advanced Concepts & Techniques
Shelly, Cashman & Vermaat
Thomson Course Technologies
ISBN: 1-4188-4332-6
Data Files for Students - 38Mb ZIP

To Order Books - If you need a book for this or any course, and the college bookstore doesn't have it, ORDER IT from Amazon.com via this link, and 5% of your order goes to the CSI Computer Science department to do good for the earth and universe.

Course Outline / Contents
Powerpoint Presentations - click on the corresponding links below
Word 2007
4. Creating a Document with a Title Page, Table, Chart, and Watermark
 Lab 1 (Word) - Creating a Proposal that includes a SmartArt graphic, a table, and a chart (page 1)
 Lab 1 - page 2
Note, these links take you to scanned images of pages WD298-299 in the textbook; the scans are a little bit crooked! Please forgive me!  Also, there are 2 pages in total to look at!

5. Generating Form Letters, Mailing Labels, and Directories
 Lab2 - Mail Merge - p1
Lab2 = p2
Lab2 - p3

6. Creating a Professional Newsletter - SKIP

7. Integration Feature: Linking an Excel Worksheet and Chart to a Word Document
Lab3 - Linking Excel to Word
Web Features of Word

Excel 2007
4. Financial Functions, Data Tables, and Amortization Schedules
Powerpoint Slides for Excel-chapter4
Lab 4- Simple Data Table

SAMPLE QUESTIONS W/ANSWERS FOR QUIZ 1
Word - Chap 4
Word - Chap 5
Word - Integration w/Excel
Excel - Chap 4

5. Creating, Sorting, and Querying a Table
Powerpoint Slides for Excel-chapter 5 --> Data Tables
Lab5: Tables, Conditional Formatting & Database Functions - p.EX 404-405
  Excel-Lab5 (above), page 1
  Excel-Lab5 (above), page 2

6. Creating Templates and Working with Multiple Worksheets and Workbooks
Powerpoint Slides for Excel Chapter 6 - Multiple Worksheeets & Templates
Lab6 - Your choice of these two: page EX504
 - Public Safety Division Budget Proposal - Cases & Places 1
 - Creating a Consolidated Balance Sheet - Cases & Places 2

Project 1 -
Your Choice of these 2: pages EX504-505
 - Analyzing company Profits by Category - Cases & Places 3
     first half of 3 on bottom, second half on next page (below)
 - Analyzing Annual College Expenses & Resources - Cases & Places 4

More to Come ...

6b.    Graphics Feature: SmartArt and Images
 

Access 2007
4. Creating Reports and Forms
Powerpoint for Creating Reports & Forms
JSP Recruiters Database - use in chapter 4, 5 & 6
Access-Lab for chapter 4
The Bike Database for Access- chapter 4 Lab

5. Multi-Table Forms

6. Using Macros, Switchboards, PivotTables, and PivotCharts
Powerpoint for Access chapter 6
JSP Recruiters Database - use in chapter 4, 5 & 6
Access Lab for Chapter 6 - page 1
Access Lab for Chapter 6 - page 2
Files & DBs for the Access chapter 6 Lab
 

-  SQL Feature: Using SQL

PowerPoint 2007
 Zip Containing All the Powerpoint about Powerpoint Presentations!  (Big: 20Mb)
3. Creating a Presentation with Custom Backgrounds and SmartArt Diagrams
4. Working with Information Graphics
Collaboration Feature: Collaborating on and Delivering Presentations

Outlook 2007
2. Managing Calendars and Instant Messaging

Microsoft Office 2007 Integration
Microsoft Office 2007 Integration Case Studies
 

Site by Domanski  --  Last Update: Thursday, May 29, 2008 10:11 AM -0400
 Email:  domanski [at] mail [dot] csi [dot] cuny [dot] edu