|
|
|
|
Introduction to Microcomputers CS
190
Text Book Essentials Microsoft XP Enhanced
edition - Fox
Instructor Joseph DeMaria
Office # -
Rm.246 Kirkwood Iowa City Credit Center
Ph # 887-3643
e-mail [email protected]
Web page www.geocities.com/josephdemaria
Course Description Familiarizes the
student with business, personal and industrial uses of microcomputers. Topics
include storage media, file organization and application software. The student
will become familiar with word processing, spreadsheet and database programs
during this course.
Grading A>94%, A- >90%, B+>87%,
B>83%, B->80%, C+>77%, C>73%, etc. based on
3 - 100pt Exams
12 - Homework assignments 10 to 20 pts each
In class work approx.
100 pts
Materials 2 3 ½ inch
High Density floppy disks.
Software - This course uses the Microsoft
Office Suite 2000 programs (Word, Excel, Access and PowerPoint). You can do all
of your assignments in the Wesleyan Labs. If you have the correct programs at
home you can do your work there but it is your responsibility to verify that the
software you use is compatible.
Attendance Attendance is very important to
your success as a student. Especially since we only meet once a week. If you
miss one night you miss one tenth of the course. Points covered during lecture
will show up on the exams. It is your responsibility to keep up with the class
work if you must be absent. If you miss a quiz you MUST make up that quiz before
the next class. No Exceptions! Homework assignments are due at the start of
class. Late assignments will receive fewer points. When a section is finished
all assignments from that section must be turned in or they will not receive any
points.
Plagiarism The school policy on cheating
and behavior is in the Student Handbook. Familiarize yourself with the rules so
there will be no surprises. There is a fine line between "working together" and
cheating.
|
Week of Tuesday |
Lecture |
Lab/Homework |
|
Feb 15 |
Overview of Windows and Common
Elements Formatting Disks, Directories Using Find and Help Features |
Basic Computer Concepts pages 1 64 &
Overview of Windows XP pages 1 31 yes they start from 1 in each chapter.
WORD Part 1 Projects 1 & 2 Print out pg. 49 (Proposal LetterWB2L &
Envelope) & Skill Drill pg. 54(Chambers
LetterWB2SD) |
|
|
Windows and Common Elements of Word |
WORD Projects 3 8 Print outs from pages
77,(Office Software-WB3L) 105(Status Report-WB4L), 141(Annual
Report-WB5L), 174 (1 and 5 only (Desktop Pub-WB6L), 200(Book LetterWB7L),
230(NewsletterWB8L) |
|
March 1 |
Spring Break Week |
|
|
March 8 |
Windows/Word Exam
1 |
EXCEL page 241 Projects 1 & 2
260(revenues), 286 (revenues2002) |
|
|
Excel Formatting |
EXCEL Projects 3 - 6, Print outs from pages 308
(format), 335 (Demoabsolute Condensed-IS "BEFORE YOU DELETE IT" 2 print
outs), 365 (Functions & formulas), 393
(Dataform) |
|
March 22 |
Sorting and Graphs |
EXCEL Projects 7 & 8 , Print outs from
pages 424 (Mycharts), 451 &
453(Marie90Budget) |
|
|
PowerPoint |
PowerPoint Projects 1 2 & 3 , Print outs
from pages 724 (Sales Promotion), 754 (Status Report handout
mode) 785 (Quality Training handout
mode) |
|
April 5 |
Transitions, Animation
Excel/PowerPoint Exam 2 |
Projects 4 5 6 & 7 Print outs
from pages 804 ( |
|
April 12 |
Access Create Sort Query |
ACCESS page 461 Projects 1 2 & 3 Print outs
from pages530 (Fig 3.9), 539 (Fig 3.19), 541 (Fig
3.21) |
|
April 19 |
Access Calculated Fields Forms Reports and Labels |
Projects 4 5 & 6 Print outs from pages 559
(Fig 4.9) 562 (Fig 4.12) 566 (Fig 4.17 & 4.18)
|
|
|
Multiple Table Queries |
568 (Fig 4.21), 581 (Fig 5.5), 597 (Fig 5.22),
612 (Softball Team), |
|
May 3 |
Access Mail Merge, Import and Data
Pages |
Projects 7 & 8 Print outs from pages 659 (Fig 7.21 Mail Merge) 681, 684 (Fig 8.17), 689 (Fig 8.22) Final Exam |
