WCTS 130 - Introduction to Microcomputer Applications
Course Schedule

 

Due Date

Topic

References 

Assignment
02/04/03

Introduction to the PC

  • Windows Terminology
    Windows Concept & Components
  • Hardware/Software
  • Drives & Memory Type (RAM & ROM)
  • Function Keys
  • Ctrl & Alt Keys
  • Keyboard Shortcuts

Class Discussion/Demonstration

Visit Instructor's
 Web Site
www.oocities.org/~resand

Send e-mail message to instructor [Be sure to include requirement information as indicated on handout on the 1st day of class]

Request a printout of course schedule (For reference)

Download a copy of the Adobe Acrobat Reader

 

02/22/03

 

 



 

 

File Management (Windows)


In-class demonstration & lab-guided exercises by instructor 

  • Create folders: OS, WP, SP, DB, PP, Internet & Web Design
  • Select Files (adjacent, non-adjacent, all)
  • Copy  files from  floppy disk to local drive and folder [Backup]
  • Copy files from local drive to floppy disk & folders
  • Electronic Label on Diskette
  • Copy Disk [Source/Target]
  • Create Desktop Shortcut [Local Drive/Folder]
  • Modify Shortcut Properties
  • Screen Capture Active Windows   Desktop
  • Create/Save/Print Word Pad Document

Reference:  Textbook:  Microsoft Office XP
Publisher:  Course Technology

Assignment 1 - Windows
Operating System

 

Click Here for Instructions

 

 
03/01/03
 		  The Internet

ISP [Internet Service Provider]

Browsers [MS Explorer & Netscape]

 Reference:  Textbook:  Microsoft Office XP
Publisher:  Course Technology 
  • Multitasking between applications
  • Copy/paste text, graphic image, URL
  • Format text
  • Sending on-line greeting cards
  • Other items

In-class demonstration & lab-guided exercises by instructor

 Assignment 2
 The Internet

Click Here for Instructions

Click to View Sample Copy

 
03/15/03 Word Processing - MS Word

 

 

 

 Reference:  Textbook:  Microsoft Office XP
Publisher:  Course Technology
 
  • Cursor/Document Navigation
  • Text Selection [character, word, paragraph, sentence, entire document]
  • Character/Paragraph Formatting
  • Copy/Cut Text
  • Format Painter
  • Headers/Footers
  • Save vs. Save As
  • Format a letter
  • Generate an envelope
  • Work with Graphic, Bullets, and Page Border
  • Other items


In-class demonstration & lab-guided exercises by instructor

 Assignment 3 - Word Processing
Shelly & Evans Consulting
Part A
 Click Here for Instructions

Creating an Announcement Graphics, Bullet, Page Border  Part B
 Click Here for Instructions

Click Here for Sample Copy - Part B

03/22/03

 Spreadsheets - MS Excel

 

 Reference:  Textbook:  Microsoft Office XP
Publisher:  Course Technology 
  • Create and format a worksheet
  • Enter labels, values, formulas
  • Use built-in functions [SUM, AVERAGE, MIN, MAXIMUM, COUNT]
  • Establish Conditional Formats
  • Range Sorting
  • Creating Charts
  • Other items

In-class demonstration & lab-guided exercises by instructor

Assignment 4 - Electronic Spreadsheet

[Click Here for Instructions]
04/05/03 DBMS - MS Access


 

 

 Reference:  Textbook:  Microsoft Office XP
Publisher:  Course Technology
 

Work with existing database objects to:

  •  Modify table structure
  • Add records to table or form
  • Create, save, execute, and print queries
  • Modify report design and properties
  • Print report
  • Other items

In-class demonstration & lab-guided exercises by instructor

 Assignment 5 - Database Management System

Click Here for Instructions

04/05/03

Integration of Microcomputer Applications

 Submission of  proposed end-of-class project outline.  Outline must be submitted in typed format

See Project Assignment Handout

 
04/12/03 Presentations-MS Power Point Reference:  Textbook:  Microsoft Office XP
Publisher:  Course Technology

Create and format an electronic presentation

  • Apply Slide Design Template
  • Apply Slide Auto Layout
  • Format text, bullet list, slide title
  • Insert graphic images
  • Insert hyperlink
  • Copy URL and Internet image
  • Apply Header/Footer
  • Create and format chart
  • Apply slide transition, animation, etc.
  • Insert sound
  • Slide Show
  • Other items

 In-class demonstration & lab-guided exercises by instructor

 Assignment 6 - Electronic Presentation

Click Here for Instructions


Click Here to See Sample
Copy of  Presentation

 
TBA SPSS  

Assignment 7 - [Statistical Software on the College's PCs in the Computer Lab)

See Separate Handout
04/26/03

Using an HTML Editor
FrontPage

 

 

 

Design a Basic Web Page

  • Character Formatting: Bold, Underline, Italic, Font Style & Size
  • Paragraph Formatting
  • Line Break
  • Background: Color vs. Graphic Image
  • Web Components
  • Scrolling Marquee
  • Create/Format a Table
  • List: Ordered and Unordered
  • Hyperlinks:   URL, E-mail, Graphic, and Bookmark
  • Apply Alternate Text
  • Apply DHTML
  • Other items

In-class demonstration & lab-guided exercises by instructor

Assignment 8 - Basic Web Page Design

Click Here for Instructions

Instructor will provide sample copy
TBA

Case Study

  

 Assignment 9

See Project Assignment Handout

 
04/26/03
Presenters [1-10]

05/03/03
Presenters [11-20]

 

 

Submission of hardcopy and diskette and/or CD-ROM of the integration of the microcomputer application project.  Click here to obtain additional information

 

15-20 Minute Oral Presentations Given by Each
Student or Group
05/10/03

Final Examination 

 

Revised:  02/14/03