St. Gregory's University syllabus: Fall 2000

Course: CIS 1023 Microcomputer Application

Lecture: MW 8:00 Lab: F 8:00

Location: Room 308 Janeway Academic Bldg.

Instructor: Theresa Talbot; B.S. Elementary Education (K-8) O.S.U

M.Ed., University of Central Oklahoma

Telephone: (405) 878-5615

Office Location: Janeway Academic Bldg. Rm. 318

Office hours: MWF 9:00 AM – 9:50 AM; MW 11:00 – 11:50 AM;

MW 1:00 – 1:50 AM; TR 4:00 – 4:40 PM

Some Saturdays (by appointment)

Course Description: Designed to familiarize the student with fundamental terminology and concepts of microcomputers, their operating systems and disk management, as well as major production applications including word processing, spreadsheets, database management systems, graphics, data communications and desktop publishing.

Required Text: Microsoft Office 2000: Introductory Concepts and Techniques, Shelly, Cashman, & Vermaat ISBN # 0-78-95-4650-7

(Other supplementary materials are included on the general bibliography for students.)

Purpose of the Course: This course is designed to give the student general computer competency and a foundation in current software (Microsoft Office 2000 suite). In addition to learning to use the microcomputer for general personal and business production, the student becomes familiar with general terminology and other concepts relating to the computers and their usage.

Departmental Goals: The Department of Computer Information Systems goals are:

1.To provide instruction for students who wish to upgrade or enhance present

professional computer information system skills

2.To provide instruction for students who wish to become competent in the use

of computer technology through college credit courses while pursuing

professional education in other departments at St. Gregory’s University

3.To provide instruction for students who wish to become computer

information system professionals through the Associate or Bachelor’s

Degree

Objectives: Upon completion of this course the student will be able to:

1. Discuss the major components of a computer system.

2. Use Microsoft Office 2000 software to research the Internet, to develop, and to print a research paper.

3. Use Internet Explorer to research external information sources,

assemble an information document in Microsoft Excel, attach/export portion of spreadsheet to Word, and e-mail the document to others.

4. Use Microsoft Word and Microsoft Publisher to design and

publish a web document.

5. Use Microsoft Excel spreadsheet to develop a simple decision

support system employing "what-if" analysis to analyze data as well

as a graphical presentation of the results.

6. Given a relational database of at least three tables, create the

relationship among the tables and develop at least two queries

representing typical user views of data in multiple tables using Microsoft

Access.

Attendance Policy: Attendance is recorded and reported. 10% of the student's grade is made up of attendance points. Students should be aware that research shows a strong correlation between attendance and final grade in most courses. Absence will not be considered an excuse for submitting assignments late and a penalty will be assessed against the grade. Students have the responsibility of processing a "Drop" from any class. Note: Most F's given at the end of the semester result from students ceasing attending the class and not processing a "Drop".

Methods of Student Evaluation:

Attendance 10%

Chapter Projects 10%

Mastery Tests 70%

Final Test 10%

Grading Scale: 90 - 100 = A, 80 - 89.99 = B, 70 - 79.99 = C, 60 - 69.99 = D, less than 69.99 = F . (Late assignments will be penalized 50%)

MISSED EXAMS: Make-up exams will be reviewed on a case by case basis.

Lab Notes: It is recommended that students maintain a copy of their work on disk as well as e-mail it to the instructor with delivery receipt requested.

American Disabilities Act: If any member of the class feels that he/she has a

disability and needs special accommodations of any nature whatsoever, the instructor will work with you to provide reasonable accommodations to ensure that you have a fair opportunity to perform in this class after the disability has been verified. Please advise the instructor of such disability and the desired accommodations as soon as possible.

Wait policy: This instructor is Director of the University's Computer Lab. As such, occasionally problems/incidents in the Lab result in the instructor being a few minutes late for class. Students are expected to wait 15 minutes past the scheduled class start time in the event that this instructor is late for class. Students who do not wait until 15 minutes after the hour will be counted absent.

Outline of Course: (See Addendum I for sub-skill components)

Part I: Email, schedule, and contact management using 1 Week

Microsoft Outlook.

Part II: Word Processing with Microsoft Word 2.3 Weeks

· Creating and editing a Word document

· Creating a research paper

· Using a Wizard to create a resume and creating a

cover letter with a table

· Creating web pages using Word

Part III: Spreadsheet application with Microsoft Excel 5 Weeks

· Creating a worksheet and embedded chart

· Formulas, function, formatting, and web queries

· What-If analysis, charting, and working with large

worksheets

· Creating static and dynamic web pages using Excel

Part IV: Creating and managing a database with Microsoft Access 5 Weeks

· Creating a database using design and datasheet views

· Querying a database using the select query window

· Maintaining a database using design and update

features

· Publishing to the Internet using data access pages

Part V: Presentations with Microsoft PowerPoint 1 Weeks

· Using design template and auto-layouts to create a

presentation

· Using Outline View and clip art to create a slide show

· Creating a presentation on the Web using PowerPoint

Part VI Integrating Office 2000 Application and the World Wide Web 0.7 Weeks

· Integrate the Office 2000 application to create a Web site

· Add hyperlinks to a Word document

· Embed an Excel chart into a Word document

· Add scrolling text to a Web page created in Word

· Add a hyperlink to a PowerPoint Slide

· Create a data access page from an Access database

Part VII: Desktop publishing with Microsoft Publisher 1 Week

· Brochures

· Cards

· Web page design

Teacher Education Objectives Covered:

Supplementary Resources:

Addendum I

Microsoft Office Sub-skill components listed by topic as taught:

Outlook:

· Open the Calendar folder

· Create a personal subfolder

· Enter one time appointments

· Enter reoccurring appointments

· Use the Date Navigator to move to different days

· Use natural language phrases to enter appointment dates and times

· Move and edit appointments

· Create an event

· Display a calendar in Day, Work Week, Week, and Month views

· 10.Print the calendar in Daily Style, Weekly Style, and Monthly Style

· Create and print a contact list

· Use the find contact feature

· Create a category of contacts

· Import and export personal subfolders

· Delete personal subfolders from the hard disk

Word

· Start Word

· Zoom page width

· Change the default font size of all text

· Enter text into a document

· Check spelling as you type

· Scroll trough a document

· Save a document

· Select text

· Change the font of selected text

· Bold selected text

· Right-align a paragraph

· undo commands or actions

· Italicize selected text

· Underline selected text

· Insert clip art into a document

· Resize a graphic

· Print a document

· Open a document

· Correct errors in a document

· Use Microsoft Word Help*

· Change the margin settings in a document

· Adjust line spacing in a document

· Use a header to number pages of a document

· Enter text using Click and Type

· Apply formatting using shortcut keys

· Indent paragraphs

· Use Word's AutoCorrect feature

· Add a footnote to a research paper

· Modify a style

· Insert a symbol automatically

· Insert a manual page break

· Create a hanging indent

· Create a hyperlink

· Sort selected paragraphs

· Go to a specific location in a document

· Find and replace text

· Move text

· Find a synonym for a word

· Count the words in a document

· Check spelling and grammar at once

· Display the Web site associated with a hyperlink

· E-mail a copy of a document*

· Create a resume using Word's Resume Wizard

· Identify the Word screen in a print layout view

· Zoom text width

· Identify styles in a document

· Replace selected text with new text

· Insert a line break

· Use Print preview to view, reduce the size of, and print a document

· Open a new document window

· Add color to character

· Set and use tab stops

· Switch from one open Word document to another

· Collect and paste

· Insert a symbol

· Add a bottom border to a paragraph

· Create an AutoText entry

· Insert a non-breaking space

· Insert a Word table

· Enter data into a Word table

· Format a Word table

· Prepare and print an envelope address*

Excel

· Discuss the Excel worksheet

· Reset menus and toolbars

· Select a cell or range of cells

· Enter the and number

· Use the AutoSum button to sum a range of cells

· Copy a cell to a range of cells using the gill handle

· Change the size of the font in a cell

· Bold cell entries

· Apply the AutoFormat command to a format range

· Center cell contents across a series of columns

· Use the Name box to select a cell

· Create a Column chart using the Chart Wizard

· Save a workbook

· Print a worksheet

· Use the Auto-Calculate area to determine totals

· Correct errors on a worksheet

· Use Office Assistant and other online Help tools to answer your questions

· Enter multiple lines of text in the same cell

· Enter a formula using the keyboard

· Enter formulas using Point mode

· Identify the arithmetic operators +,-,*,/,%,and ^

· Apply the AVERAGE, MAX, AND MIN functions

· Determine a percentage Verify a formula

· Change the font of a cell (style)

· Color the characters and background of a cell

· Add borders to a grange

· Format numbers using the Format Cells dialog box

· Add conditional formatting to a range of cells

· \Align text in cells

· Change the width of a column and height of a row

· Check the spelling of a worksheet

· Preview how a printed sheet will look

· Distinguish between portrait and landscape orientation

· Print a partial or complete worksheet

· Di9splay and print the formulas version of a worksheet

· Print to fit

· Use a Web query to get real-time data from a Web site

· Rename sheets

· E-mail the active workbook from within Excel

· Rotate text in a cell

· Use the fill handle to create a series of month names

· Copy a cell's format to another cell using the Format Painter button

· Copy a range of cells to a nonadjacent past area

· Freeze column and row titles

· Insert and delete cells

· Format numbers using format symbols

· Use the NOW function to display the system date

· Format the system date

· Use absolute cell references in a formula

· Use the IF function to enter one value or another in a cell on the basis of a logical test

· Copy absolute cell references

· Display and dock toolbars

· Add a drop shadow to a range of cells

· Create a 3-D Pie chart on a separate chart sheet Format a 3-D Pie chart

· Rearrange sheets in a workbook

· Preview and print multiple sheets

· Use the Zoom box to change the appearance of the worksheet

· View different parts of the worksheet through window panes

· Use Excel to answer what-if questions

· Use the Goal Seek command to analyze worksheet data

· Save an Excel Workbook as a Static Web Page

· View the Static Web Page using your browser

· Save the Excel chart as a Dynamic Web Page

· Viewing and manipulating the Static Web Page Using Your Browser

· Modifying the worksheet on a Dynamic Web Page

Access:

· Discuss and describe databases and database management

· Describe the features of the Access screen

· Create a database

· Create a table

· Define the fields in a table

· Open a table

· Add records to an empty table

· Close a table

· Close a database

· Add records to a nonempty table

· Print the contents of a table

· Use a form to view data

· Create a custom report

· State the purpose of queries

· Create a new query

· Use a query to display all records and all fields

· Run a query

· Print the answer to a query

· Close a query

· Clear a query

· Use a query to display selected fields

· Use text data in criteria in a query

· Use wildcards in criteria

· Use numeric data in criteria

· Use comparison operators

· Use compound criteria involving AMD

· Use compound criteria involving OR

· Sort the answer to a query

· Join tables in a query

· Restrict the records in a join

· Use calculated fields in a query

· Calculate statistics in a query

· Use grouping with statistics

· Save a query

· Use a saved query

· Open a database

· Add, change, and delete records in a table

· Locate records

· Filter records

· Change the structure of a database

· Restructure a table

· Change field characteristics

· Add a field

· Save the changes to the structure

· Update the contents of a single field

· Make changes to groups of records

· Specify a required field

· Specify a range

· Specify a default value

· Specify legal values

· Specify a format

· Save rules, values, and formats

· Update a table with validation rules

· Specify referential integrity

· Use sub-datasheets

· Order records

· Create single-field and multiple-field indexes

· Publish to the Internet using Data Access pages

PowerPoint:

· Select a design template

· Create a title slide

· Describe and use text attributes such as font size and font style

· Save a presentation

· Add a new slide

· Create a multi-level bulleted list slide

· Move to another slide in normal view

· End a slide show with a black slide

· View a presentation in slide show view

· Quit PowerPoint

· Open a presentation

· Check the spelling and consistency of a presentation

· Edit a presentation

· Change line spacing on the slide master

· Display a presentation in black and white

· Print a presentation in black and white

· Use the PowerPoint Help system

· Create a presentation from an outline

· Start a presentation as a mew PowerPoint Document

· Use Outline view

· Create a presentation in outline view

· Add a slide in outline view

· Create multilevel bulleted list slides in outline view

· Create a closing slide in outline view

· Save and review a presentation

· Change the slide layout

· Insert clip art from Microsoft Clip Gallery

· Move clip art

· Change clip art size

· Add a header and footer to outline pages

· Add animation and slide transition effects

· Apply animation effects to bulleted slides

· Animate clip art objects

· Format and animate a title slide

· Run an animated slide show

· Print a presentation outline

· Email a slide show from within PowerPoint

Integrating:

· Integrate the Office 2000 applications to create a Web site

· Add hyperlinks to a Word document

· Embed an Excel chart into a Word document

· Add scrolling text to a Web page created in Word

· Add a hyperlink to a PowerPoint slide

· Create Web pages from a PowerPoint presentation

· Create a data access page from an Access database

Addendum II

Monday/Wednesday/Friday

Weekly Schedule

Date Topic Text & Exercise Test Pts

8/23	Outlook Calendar, Recurring appointments, Editing Appointments	O 1.1 - 1.35		50
8/25	Outlook - Scheduling Events, Task Lists	O 1.35 - 1.51	E-mail instructor & print a calendar of your class schedule	50
8/28	Word Flyer & Insert Picture	WD 1.1 - 1.42
8/30	Word Formatting Flyer & Starting a Research Paper	WD 1.43 - 2.30	E-mail a copy of the picture	10
9/1	Word	WD 2.31 -2.52
9/4	Labor Day Holiday -No Class
9/6	Word - Application	WD 2.53 - 2.61	Do Exercise 2 Research Paper (Virtual Reality)	75
9/8	Word - Resume	WD 3.1 - 3.26
9/11	Word - Letterhead & Cover Letter w/table & envelope	WD 3.27 - 3.60
9/13	Word - Application	WD 3.65	Create your own Resume/Letterhead/Cover Letter	25
9/15	Word Integration Web Page Design	WDW 1.1 - 1.13	Publish your Web page on Campus web pages	90
9/18	Excel Create a Worksheet	E1.1 - 1.35
9/20	Excel Embed a chart & correcting errors	E 1.36 - 1.51
9/22	Excel - Application	E 1.63	Case 2 New Cars & Truck Data
9/25	Excel - Formulas	E 2.1 - 2.36
9/27	Excel - Function & Formatting	E 2.37 - 2.57
9/29	Excel - Web Query	E 2.58 - 2.63
10/2	Excel - Application	E 2.69 -2.72	In Lab # 2 Mortimer's Seaside Emporium
10/4	Excel - Application	E 2.78	Case # 4 Oil Production Data
10/6	Excel - Entering formulas containing absolute cell references	3.1 -3.26
10/9	Excel - The IF function	3.27 - 3.43
10/11	Excel - Charting & Analyzing Changing Values	3.43 - 3.66
10/13	Excel - Application	E 3.70 - 3.72	In the Lab #1 R&R Hotel
10/16	Excel - Application	E 3.73 - 3.76	In the Lab # 2 E-Book.com
10/17	Mid-term Grades Due in
10/18	Excel - Creating Static & Dynamic Web Pages	EW 1.1 - 1.13
10/20	Fall Break - No Class
10/23	Excel - Application	EW 1.15	In the Lab - # 1 Shocking Sound International Web Page
10/25	Access -.Creating a Table, Defining Fields, Adding Records to a Table	A 1.1 - 1.25
10/27	Access - Add Additional Records, Creating Additional Tables, Forms, & Reports	A 1.26 - 1.49
10/30	Access - Designing a Database - Application	A 1.57-1.58	In the Lab - Creating the School Connection Database
11/1	Access - Application	A 1.63	Case 1 - Computer Science Club
11/3	Access - Querying a Database	A 2.1 - 2.23
11/6	Access - Querying using Compound Criteria, Joining Tables, Using Calculated Fields in a Query, Calculating Statistics	A 2.24 - 2.43
11/8	Access - Application	A 2.44 - 2.45	Querying the School Connection Database
11/10	Access - Application	A 2.48	Case #1 Query Computer Science Club
11/13	Access - Adding & Changing	A 3.1 - 3.25
11/15	Access - Deleting Records in a Table, Default Values, Validating, Referential Integrity, & Indexes	A 3.26 - 3.51
11/17	Access - Application	A 3.53 - 3.54	Maintaining the School Connection
11/20	Access - Publishing to the Internet Using Data Access Pages	AW 1.1 - 1.10
11/22	Access - Application	AW 1.11 - 1.12	Creating a Data Access Page for the Sidewalk Scrapers Database
11/24	Thanksgiving Holiday -No Class
11/27	PowerPoint - Design Templates, Text Attributes, Saving to disk, Adding Slide, Bulleted Lists, Auto-Layout,	PP 1.1 - 1.68
11/29	PowerPoint - From an Outline, Mullti-level Bulleted Lists, Clip-Art, Header/Footer, Animation Effects, Transitions, & E-mailing the Slide Show	PP 2.1 - 2.57
12/1	PowerPoint - Application	PP 2.66	Case # 2 Flu
12/4	Publisher - Brochures & Cards		Create a Holiday Card and a Business Card
12/6	Publisher - Web page designs
12/8	Catch-up Day
Final	TBA