back

IT4116 – Introduction to PC Software and Information Systems

Spring 2005

Topic Outline

Date	Class Topics	Assignment	Topic Websites
3/8/05	Course Introduction Course objectives Grading policy Syllabus Lab procedures Intro - computers, components, networks Win2k	Assignment: EC 1 essential concepts WIN2000 1 tutorials	Windows 2000
3/15/05	Browser & Email Basics Office Overview buttons, panes, windows	Assignment: BEB 1 OFF 1	Browser and E-mail Basics Intro to Office XP
3/22/05	MS Word word processing create a document fonts smart tags printing envelopes paragraph format cut & paste	Assignment: Assignment 1 WD 1, 2	Microsoft Word
3/29/05	MS Word continued tabs sections, columns headers, footers tables hyperlinks Word Art graphics Word & the Web	Assignment: WD 3, 4 WEB 1	Microsoft Word
4/5/05	MS Excel spreadsheet what is a spreadsheet? rows, columns text in a cell column size selecting AutoSum relative, absolute references functions	Assignment: EX 1, 2	Microsoft Excel
4/12/05	MS Excel continued formatting AutoFormat header / footer charts chart fill formats	Assignment: EX 3, 4	Microsoft Excel
4/19/05	Excel & the web Integrating Word & Excel cross-including documents Access what is a database? star, hierarchical, grid, relational database, tables, columns, rows queries query by example SQL forms compacting	Assignment: WEB 1 (Excel) INT 1 AC 1	Microsoft Access
4/26/05	Access continued database normalizing data types field properties add, change, delete records relationships sort and & or	Assignment: AC 2, 3 create 3 table database	Microsoft Access
5/3/05	Access continued Access & the web Integrating Word, Excel, Access	Assignment: AC 4 WEB 1 (Access) INT 2 (Word, Excel, Access) add report, form to 3 table database	Microsoft Access
5/10/05	Powerpoint Powerpoint & the web Integrating Word, Excel, Access, PP	Assignment: PP 1 WEB 1 (PowerPoint) INT 3	PowerPoint
5/17/05	Final Exam	Assignment: Study for exam	Textbook MOS MS MOS

updated 13mar05

 home