MICROCOMPUTER APPLICATIONS SCHEDULE (2:00
MWTh Section)
(CS 114) Fall, 2005
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:00-3:00PM Mon Rm 127
2:00-3:00PM Wed Rm 158
2:00-3:00PM Thu Rm 158
3:10-4:10PM Thu 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 |
|
Aug. 25 |
Overview of software used in this course Course schedules |
WORD section pp. iii-iv EXCEL section pp. iii-iv ACCESS section pp. iii-iv POWERPOINT section pp. iii-iv |
|
Aug 29 |
Computer memory and various types of disk,
keyboard, input/output and devices |
|
|
Aug 31 |
Basic Procedures with Windows 2000 |
In the WINDOWS section, pages 1-13 and 38-39 |
|
Sep. 1 |
Entering and exiting WORD, Typing text and
making simple corrections, saving, retrieving (opening), and printing. |
In the WORD section, pages 1-19 and 20-21 |
|
Sep 7 |
Opening and inserting files, selecting the drive for opening and saving, use of folders (tree-structured directories), using WORD to search folders by browsing. |
In the WORD
section: pages 26-27 In the WINDOWS
section, pages: 22-23; page 27, pages 84-85 |
|
Sep 8 |
Selecting and formatting text, use of fonts and other formatting, moving and copying text, cut and paste, obtaining help in WORD. |
In the WORD
section, pages: 8-9, 16-17, 34-63, 78-81 |
|
Sep 12 |
Computer system overview – a very brief
look at some more hardware |
|
|
Sep 14 Sep 15 |
spelling and grammar checking, word count,
find and replace, indents and margins, alignment of text, bullets &
numbering, Tabs, page breaks |
In the WORD section, pages: 10-15, 18-19,
22-23, 74-77 |
|
Sep 19 Sep 21 Sep 22 |
Searching the internet, email, Use of a Web
browser |
In the INTERNET section, pages: 1-13 For Tables, WORD section pages 106-113 For making web pages, WORD section, pages
118-119 HANDOUT on email |
|
Sep 26 |
Review of internet uses and issues |
|
|
Sep 28 Sep 29 Oct 3 |
Headers and Footers Use of Graphics in WORD Obtaining help in WINDOWS |
In the WORD
section, pages: 82-83, 88-93, 116-117 In the WINDOWS
section, pages 18-21 |
|
Oct 5 |
TEST NUMBER ONE (PROBABLY NO CLASS OCT 4 DUE TO A MEETING. CHECK WITH THE INSTRUCTOR) |
OVER THE ABOVE MATERIAL. MORE DETAIL WILL BE GIVEN IN A REVIEW SHEET TO GUIDE WHAT TO STUDY FOR THE TEST. |
|
Oct 6
|
Entering, exiting, navigating EXCEL, opening, closing, and printing worksheets, simple arithmetic, formatting as currency, changing width of a column, editing data in cells, undo, spelling checker, column width & row height; using the computer to find a file, obtaining help in EXCEL |
In the EXCEL
section, pages 1-13, 20-25, 34-35, 106-107 |
|
Oct 10 Oct 12 Oct 13 |
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, obtaining help, making EXCEL search for a file |
In the EXCEL section, pages 7-9, 14-19, 36-37, 40-41 |
|
Oct 17 Oct 19 Oct 20 |
Insert & delete rows and columns, find
& replace, freeze panes, zoom, format, alignment within cells, working
with multiple worksheets, details of printing worksheets, page setup macros in excel. |
In the EXCEL section, pages: 36-39, 42-53, 56-57, 74-79 |
|
Oct 24 Oct 26 Oct 27 |
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 |
|
Oct 31 Nov 2 Nov 3 |
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 |
|
Nov 7 Nov 10 Nov 14 |
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 NO CLASS NOV 9 DUE TO ADVISING DAY |
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 |
|
Nov 16 |
TEST NUMBER TWO |
OVER THE ABOVE MATERIAL. MORE DETAIL WILL BE GIVEN IN A REVIEW SHEET TO GUIDE WHAT TO STUDY FOR THE TEST. |
|
Nov 17
|
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 |
|
Nov 21 Nov 23 |
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 |
|
Nov 28 Nov 30 Dec 1 |
Using
filters to select records Planning a data base, Multiple tables in a
Data Base Integrating ACCESS with EXEL and WORD |
In the ACCESS section, pages: 100-101 In the ACCESS section, pages 138-139, 140-145 |
|
Dec 5 Dec 7 Dec 8 Dec 12 |
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 |
|
As given in the College's Final Exam Schedule, sometime between Dec 14 & Dec 16 |
FINAL EXAM |
OVER THE ENTIRE COURSE AS DESCRIBED IN THE REVIEW SHEETS |