MICROCOMPUTER APPLICATIONS
SCHEDULE (2:00 MWF Section)
(CS 114) Spring, 2006
RETURN to the MICROCOMPUTER APPLICATIONS home page
INSTRUCTOR: Thomas C. Gibbons | Questions? Contact me at tgibbons@eicc.edu
Eastern Iowa Community College District | Clinton Community College
2:00PM - 3:00PM Mon Rm 127
2:00PM - 3:00PM Wed Rm 158
2:00PM - 3:00PM Fri Rm 158
3:10PM - 4:10PM Fri Rm 158 Individual Lab (May be taken at other times, if necessary)
Textbook is Nina Rutkosky & Denise Seguin, Microsoft
Office 2003 (Marquee Series)
|
DATES |
TOPICS AND CONCEPTS |
TEXTBOOK PAGES |
|
Jan 23 |
Overview of Programs in this course; Computer memory and various types of disk. |
WORD section pp. iii-iv EXCEL section pp. iii-iv ACCESS section pp. iii-iv POWERPOINT section pp. iii-iv |
|
Jan 25, 27 |
Basic Procedures with Windows Entering and exiting WORD, Typing text and making simple corrections, saving, retrieving (opening), and printing. |
In the WINDOWS section, pages 1-13 and 38-39 In the WORD section, pages 1-19 and 20-21 |
|
Jan 30 |
Computer memory and various types of disk,
keyboard, input/output and devices |
|
|
Feb 1, 3 |
Opening and inserting files, selecting the drive for opening and saving, use of folders (tree-structured directories), using WORD to search folders. Selecting and formatting text, use of fonts and other formatting, |
In the WORD
section: pages 8-9, 26-27, 33-39 In the WINDOWS section, pages: 22-23; page 27, pages 84-85 |
|
Feb 6 |
Computer system overview – a very brief
look at some more hardware |
|
|
Feb 8 Feb 10 |
moving and copying text, cut and paste. Using WORD to get help, spelling and
grammar checking, word count, find and replace, headers and footers, indents
and margins, alignment of text, bullets & numbering, Tabs, page breaks |
In the WORD section, pages: 10-15, 16-17, 18-19, 22-23, 40-63, 74-77,
78-81. |
|
Feb 13 Feb 15 Feb 17 |
Searching the internet, email, Use of a Web
browser Review of internet uses and issues |
In the INTERNET section, pages: 1-13 For Tables, WORD section pages 106-113 For making web pages, WORD section, pages
118-119 |
|
Feb 20 Feb 22 Feb 24 |
Headers and Footers Use of Graphics in WORD Using WINDOWS to get help |
In the WORD
section, pages: 82-83, 88-93, 116-117 In the WINDOWS section, pages 18-21 |
|
Feb 27 |
Complete the computer system overview |
|
|
Mar 1 |
TEST NUMBER ONE |
OVER THE ABOVE MATERIAL. MORE DETAIL WILL BE GIVEN IN A REVIEW SHEET TO GUIDE WHAT TO STUDY FOR THE TEST. |
|
Mar 3 |
Entering, exiting, navigating EXCEL, opening, closing, and printing worksheets, simple arithmetic, formatting as currency, changing width of a column, editing data in cells, undo. |
In the EXCEL
section, pages 1-13, 20-25, 34-35, 106-107 |
|
Mar 6 Mar 8 Mar 10
|
Spelling checker, column width & row height; using the computer to find a file, entering data, simple editing, using formulas, the SUM function, alignment, selecting cells, cut (copy) and paste, copy by dragging, fill command, relative vs. absolute copies, Office Assistant |
In the EXCEL section, pages 7-9, 14-19, 36-37, 40-41 |
|
Mar 13 Mar 15 Mar 17 |
Insert & delete rows and columns,
freeze panes, zoom, format, alignment within cells, working with multiple
worksheets, details of printing worksheets Macros in excel. |
In the EXCEL section, pages: 36-39, 42-53, 56-57, 74-79 |
|
Mar 27 Mar 29 Mar 31 |
Use of functions such as AVERAGE, MAX, MIN,
COUNT, PMT, NOW, ABS, IF Find & replace, insert, delete, move, copy whole worksheets |
In the EXCEL section, pages: 54-55, 66-73, 98-101 |
|
Apr 3 Apr 5 Apr 7 |
Charts and graphs in EXCEL, presenting results as bar and pie graphs with variations, editing and printing graphs, copy and paste to WORD. |
In the EXCEL section, pages 80-89 |
|
Apr 10 Apr 12 Apr 17 |
Additional windows material, customizing the
screen, making and using folders, backing up your work and making copies,
installing and running programs, the computer virus, how to use an antivirus
program Integrated software, the use of EXCEL and WORD together |
In the WINDOWS
section, pages: 22-35, 40-41 Use of the
internet to find material on the computer virus In the EXCEL section, pages: 126-127, 138-139, 146-149 |
|
Apr 19 |
TEST NUMBER TWO |
OVER THE ABOVE MATERIAL. MORE DETAIL WILL BE GIVEN IN A REVIEW SHEET TO GUIDE WHAT TO STUDY FOR THE TEST. |
|
Apr 21 |
Data base and ACCESS overview, creating a data base and tables using the design view, editing in the datasheet view, quick printing |
In the ACCESS section, pages: 1-11, 14-19, 24-25, 34-39, 98-99 |
|
Apr 24 Apr 26 Apr 28 |
printing with a report Creating a query, using and printing the query, integrating ACCESS with WORD and EXCEL |
In the ACCESS section, pages: 84-89 In the ACCESS section, pages: 66-67, 70-71 |
|
May 1 May 3 May 5 |
Integrating ACCESS with WORD and EXCEL Planning a database Using filters to select records, Multiple tables in a database |
In the ACCESS section, pages: 100-101 In the ACCESS section, pages 138-139, 140-145 |
|
May 8 May 10 May 12 May 15 |
PowerPoint basics, opening a presentation, viewing a presentation, creating a presentation, printing, editing and background effects, animations & transitions |
In the POWERPOINT section, pages: 1-27, 34-39, 50-57, 86-87 |
|
May 16, 17, or 18 (as given by the college’s final exam schedule) |
FINAL EXAM |
OVER THE ENTIRE COURSE AS DESCRIBED IN THE REVIEW SHEETS |