MICROCOMPUTER APPLICATIONS
SCHEDULE (First Session, 5/31/05-7/1/04, 1:00 PM - 5:20 PM )
(CS 114) SUMMER, 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
1:00PM - 2:00PM Mon, Tue, Thurs, Rm 127/158
2:00PM - 3:10PM Mon, Tue, Thurs, Rm 158
3:10PM - 4:20PM Mon, Tue, Thurs, Rm 158
4:20PM - 5:20PM Mon, Tue, Thurs, Rm 158 (*)
(*) Individual Lab
between 4:20 and 5:20 PM
(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 |
|
Tue, May 31 |
Overview of Programs in this course; Computer
memory and various types of disk. Basic Procedures with Windows Entering and exiting WORD, Typing text and
making simple corrections, saving, retrieving (opening), and printing. |
WORD section pp. iii-iv EXCEL section pp. iii-iv ACCESS section pp. iii-iv POWERPOINT section pp. iii-iv In the WINDOWS section, pages 1-13 and 38-39 In the WORD section, pages 1-19 and 20-21 |
|
Thu, June 2 |
Computer system overview. Opening and inserting files, selecting the
drive for opening and saving, use of folders (tree-structured directories),
using WORD to search folders. Using
WORD and WINDOWS to get help. 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 |
|
Mon, June 6 |
Complete the computer system overview. Moving and copying text, cut and paste,
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. |
|
Tue, June 7 |
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 |
|
Thu, June 9 |
Headers and Footers Use of Graphics in WORD |
In the WORD section, pages: 82-83, 88-93, 116-117 In the WINDOWS section, pages 18-21 |
|
Mon, June 13 (also see below) |
TEST NUMBER ONE |
OVER THE ABOVE MATERIAL. MORE DETAIL WILL
BE GIVEN IN A REVIEW SHEET TO GUIDE WHAT TO STUDY FOR THE TEST. |
|
Mon, June 13 AFTER THE TEST |
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 |
|
Tue, June 14 |
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 |
|
Thu, June 16 |
Insert & delete rows and columns, find
& replace, 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 |
|
Mon, June 20 |
Use of functions such as AVERAGE, MAX, MIN,
COUNT, PMT, NOW, ABS, IF Find & replace, insert, delete, move,
copy whole worksheets 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: 54-55, 66-73, 98-101 In the EXCEL section, pages 80-89 |
|
Tue, June 21 |
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 |
|
Thu, June 23 (also see below) |
TEST NUMBER TWO |
OVER THE ABOVE MATERIAL. MORE DETAIL WILL BE
GIVEN IN A REVIEW SHEET TO GUIDE WHAT TO STUDY FOR THE TEST. |
|
Thu, June 23 AFTER THE TEST |
Data base and ACCESS overview, creating a
data base and tables using the design view, editing in the datasheet view,
quick printing Printing with a report. |
In the ACCESS section, pages: 1-11, 14-19, 24-25, 34-39, 98-99 In the ACCESS section, pages: 84-89 |
|
Mon, June 27 |
Editing the fields of a table, using
filters to select records Creating a query, using and printing the query,
integrating ACCESS with WORD and EXCEL Multiple Tables in a Database |
In the ACCESS section, pages: 66-67, 70-71 In the ACCESS section, pages: 100-101 In the ACCESS section, pages 138-139,
140-145 |
|
Tue, June 28 |
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 |
|
Thu, June 30 |
FINAL EXAM |
OVER THE ENTIRE COURSE AS DESCRIBED IN THE REVIEW
SHEETS |