ST. Gregory’s UNIVERSITY
COURSE
SYLLABUS For Spring 2001
|
COURSE |
Advance Microcomputer Applications CS
1823 |
|
TIME/LOCATION |
MWF 2:00 – 2:50, Room 308 |
|
PREREQUISITE |
PD 1012 Using Computers |
|
INSTRUCTOR |
Mrs. Connie Farthing |
|
OFFICE |
Room 442b, 878-5150, csfarthing@sgc.edu |
|
HOURS |
MWF 12:00-1:00 or by appointment |
COURSE
DESCRIPTION:
This advanced course is designed to extend the student’s
computer skills to a level necessary for survival in the business world of the 21
st century. Competencies will include
creating and maintaining active links, posting Web applications, develop
spreadsheet and database templates, and designing and documenting macros. Students aware to create processional
quality reports and forms including charts, graphs, tables, input forms and
query scenarios
Objectives:
Upon
completion of this course the student should:
·
Learn how to create a document with a
table, chart, and watermark
·
Learn how to generate a from letter,
mailing label and envelopes
·
Learn how to generate a Newsletter
·
Learn how to merge a form letter to
E-mail addresses using an access table
·
Learn how to use the financial
functions, amortize schedules, and hyperlinks
·
Learn how to create templates and work
with multiple worksheets
·
Learn how to link an Excel Worksheet to
a Word Document
·
Learn how to create reports, forms and
combo boxes
·
Learn how to enhance forms with
hyperlinks and subforms
·
Learn how to sort and query a worksheet
database
·
Learn how to integrate Office
applications
These objectives can
only be achieved through joint effort.
I will work to stimulate your interest and learning, but you are to
display initiative and a program of self-study. In that sense, a complementary objective is to provide you with
an environment that will encourage and reward your intellectual effort, while
simultaneously maintaining rigorous standards that identify those who are
motivated to pursue excellence in their own educational preparation for a
business career.
Students are
advised that cheating and plagiarism are not tolerated at St. Gregory’s
University. Students are expected to
abide by the University's academic regulations and policy and are responsible
for awareness of the University's definition of these activities. The
consequences of violating the academic honesty standard may include a grade of
"0" on the assignment/exam, a grade of "F" in the course,
and, possibly, expulsion from the University.
TEXTS:
Microsoft Office 2000 Advanced Concepts and Techniques, Shelley, Cashman, Vermaat, Course Technology, 2000.
METHODS OF ASSESSMENT
AND STUDENT EVALUATION
|
Exams |
20% |
|
Projects |
60 |
|
Presentation |
20 |
|
Attendance |
10 |
|
Total points |
100% |
·
If any exam question is left
unattempted, the value of that question will be subtracted from the exam
score.
·
Being prepared and present for the
exams and presentations is your responsibility. The exam and
presentation will be given on schedule.
Mark your calendars now.
Each homework
assignment must be e-mailed. It is your
responsibility to see that the e-mail was received. Late homework will not be accepted.
The schedule is
flexible. Much material is
required. It is not possible for an
instructor to cover all the course material without student independent
study. As students are interested in a
particular topic or as test scores warrant review, more time will be spent on a
chapter, or as may be required.
|
Wk |
Project |
Topic |
Assignments |
|
1 |
|
Introductions |
|
|
2 |
4 |
Microsoft Word 2000: Creating a Document with a Table,
Chart, and Watermark |
#2 Creating a Proposal Using Downloaded Clip Art and a
Chart p. WD 4.64-4.65 |
|
3 |
5 |
Generating Form Letters, Mailing Labels, and Envelopes |
In the Lab: #1 Creating a Data Source, Form Letter,
and Mailing Labels p. WD 5.60 |
|
4 |
6 |
Creating a Professional Newsletter |
In the Lab: #3 Creating a Newsletter from Scratch p.
WD 6.66 |
|
5 |
|
Merging Form Letters to E-Mail Addresses Using an
Access Table |
#3 Creating an Access Table for a Merge to E-Mail
Addresses p. WDI 1.11 |
|
6 |
4 |
Microsoft Excel 2000: Financial Functions, Data
Tables, Amortization Schedules, and Hyperlinks |
In the Lab: #2 Doug’s LA Denim LTD. Quarterly Income
Statement and Break-Even Analysis p. E4.58-4.60 |
|
7 |
5 |
Creating, Sorting, and Querying a Worksheet Database |
In the Lab: #2 Filtering and Sorting a Database of
Office 200 Specialists p. E 5.54-5.57 |
|
8 |
6 |
Creating Templates and Working with Multiple Worksheets
and Workbooks |
In the Lab: #2 Using a Template to Create a
Multiple-Sheet Workbook p. 6.67-6.68 |
|
9 |
|
Linking an Excel Worksheet to a Word Document |
In the Lab: #2 Linking a Weekly Expense Memo to a
Weekly Expense Workbook p. EI 1.10 |
|
9 |
4 |
Microsoft Access 2000: Reports, Forms and Combo Boxes |
In the Lab: #2 Presenting Data in the City Area Bus
Company Database p. A4.54-4.55 |
|
10 |
5 |
Enhancing Forms with OLE Fields, Hyperlinks, and
Subforms |
In the Lab: #2 Enhancing the City Area Bus Company
Database p. 5.54 – 5.56 |
|
11 |
6 |
Creating an Application System Using Macros, Wizards,
and the Switchboard Manager |
In the Lab |
|
12 |
|
Integrating Excel Worksheet Data into an Access
Database |
In the Lab: #2 Linking an Excel Worksheet p. AI 1.10 |
|
14 |
3 |
Using Embedded Visuals to Enhance a Slide Show |
In the Lab: #2 Embedding an Organization Chart and
Inserting a Picture p. 3.64-3.66 |
|
15 |
|
Integration Case Studies |
#1 Integrating Excel, Word, PowerPoint, and E-Mail p.
I 1.1 – 1.13 |
|
16 |
|
Final |
|