Home

CIS 100 Lab Home

Overview

Lab Slides

Multimedia

Tutorial

Workshop

References

Project Details

Project Groups

Examination

Summary

 

 

 

Multimedia Lectures


There are no multimedia lecture modules for this course at this time.

Week  Projects Multimedia Modules Time (Hr:Sec) Task
1

Vista 1

   

 

2 Word 1 & 2 W2-1 Margins and Spacing
W2-2 Header and Footer
W2-3 Autocorrect and Footnote
W2-4 Page Breaks Hyper Link and Word Count
W2-5 Sorting Spelling Find and Replace
2:25
7:32
5:57
5:41
7:11

 

 

3 Word 3 & X W3-1 Preparing a Resume
W3-2 Letter Head Preparation
W3-3 Using the Clipboard
W3-4 Tab and Autotext
W3-5 Creating Tables
W3-6 Emailing a Document
W3-7 Printing Envelopes
W3-8 Document Summary
8:32
5:41
3:22
6:04
6:56
2:58
4:04
1:08

 

4

Excel 1 & 2

E1-1 Introduction to Excel Worksheets
E1-2 Auto Sum Feature
E1-3 Quick Formatting Features
E1-4 Creating a Chart
E1-5 Storing Opening and Printing a Worksheet
E1-6 Auto Calculate Feature
E2-1 Using Formulas in Worksheets 
4:48
5:11
3:13
5:04
6:43
1:37
5:46
 

 

5

Excel 3 & X

E3-1 Auto Series and Format Printer
E3-2 More on Filling the Series
E3-3 More Formatting and Freezing of Panes
E3-4 Absolute Cell Reference
E3-5 IF Function and Date
E3-6 Formatting and Completing the Sheets
E3-7 Creating a Pie Chart
E3-8 More Formatting of the Pie Chart
E3-9 Exploding Rotating and Tilting the Chart
E3-10 Print Preview Features
E3-11 Storing Worksheet as a Static Web Page
E3-12 Displaying Dynamic Web Pages
E3-13 More on Dynamic Web Pages

 

4:26
2:49
7:54
5:44
6:12
3:11
4:17
4:55
3:43
3:34
3:17
3:37
4:13

 

 

6

Mid Term Review

   

 

7 Access 1 & 2 A1-1 Introduction to Access
A1-2 Introduction to Tables
A1-3 Creation of a Table
A1-4 Entering Data
A1-5 Creating A Query
A1-6 Creating A Form
A1-7 Creating a Report

A2-1 Creating and Storing a Simple Query
A2-2 Criteria and Parameter Based Query
A2-3 Multiple Criteria and Unique Values
A2-4 Join Query
A2-5 Joint Query with Condition
A2-6 Using Formulas in Query
A2-7 Summary Statistics and Grouping
A2-8 Crosstab Query
 
5:01
6:44
8:31
5:11
5:10
5:49
5:27

2:11
6:51
5:52
5:39
2:01
4:35
4:17
4:42

 

 

8

Access 3 & X

A3-1 Updating and Filtering Data
A3-2 Deleting Records and Changing Structure
A3-3 Mass Updating
A3-4 Validation Rules
A3-5 Lookup Field
A3-6 Referential Integrity
A3-7 Creating and Using Indexes
5:52
5:25
7:00
8:46
2:45
5:40
7:43

 
 
9 PowerPoint 1 & 2      
10 Power Point X        
11 Finals Week      

 

 


(c) Professor N. Ganesan, All Rights Reserved.