CGS 1100

Welcome
CGS1100 (Fall '98) Students

Introduction to Computers

[ Go To WebBoard | What is WebBoard?]

Final Exam
Due by midnight on December 11, 1998
Final.pdf
Appendix1.pdf
Appendix2.pdf
Appendix3.pdf
Final01.doc
Final02.xls

Course Information

Reference #	80680
School:	College of Business
Subject Area:	Computer Information Systems
Credit Hours:	3
Class Meetings:	August 28, October 2, December 11 (final exam) from 8:30 a.m. - 11:00 a.m in Griffin Hall, Room 114
Location:	Griffin 114 (for the three class meetings)
Limitations:	None
Instructor:	Rajendra (Raj) Bandi
Phone #:	590-7361
E-mail:	rbandi@fgcu.edu
Office:	Academic Building II; Room 131
Office hours:	Tue - Thu 9:30 a.m. - 10:30 a.m.; Tue - Thu 3:00 p.m. - 4:30 p.m.
Description:	This course is designed to give you the skills necessary to effectively function within the three most commonly used components of the Microsoft Office 97 suite of software applications. These programs include Word 97 for word processing, Excel 97 for spreadsheets, and PowerPoint 97 for presentations. Currently, this product family accounts for approximately 80% of the worldwide market. In this course we will also discuss the ethical issues that emerge as we move towards becoming a computing dependent society. Since this is an Internet based class, you must have access to PCs with Microsoft Office 97. Office 97 software is available on all the computers in the PC lab. This course prepares you for using the products on a daily basis and for taking the Certified Microsoft Office User (CMOU, see Appendix) exams by giving you ample opportunity to use each software product under a variety of conditions. You will learn basic skills by performing the textbook exercises during the classroom lecture/lab days. You will gain experience in applying and combining these skills through an integrative homework assignment for each program. You will demonstrate your mastery of each product by performing a number of real world tasks in each product under timed test conditions. Finally, you will use all of your skills simultaneously on the final exam by producing a fully integrated solution using all three products. *Note: This course involves a lot of typing activities; if your keyboarding skills are not too good, I would strongly recommend that you practice. There is just no substitute to practicing.*

[Go to Top]

Readings

Required	Catapult. (1997). Microsoft Word 97 Step by Step. Redmond, WA: Microsoft Press. (ISBN: 1-57231-313-7). Catapult. (1997). Microsoft Excel 97 Step by Step. Redmond, WA: Microsoft Press. (ISBN: 1-57231-314-5). Perspection. (1997). Microsoft PowerPoint 97 Step by Step. Redmond, WA: Microsoft Press. (ISBN: 1-57231-315-3).
Recommended	Catapult. (1997). Microsoft Office 97 Integration Step by Step. Redmond, WA: Microsoft Press. (ISBN: 1-57231-317-x).

[Go to Top]

Teaching Philosophy

Learning is an active and collaborative process. As your teacher my role is to select relevant resources and assignments, to clarify and summarize complex material, to motivate and help you become a reflective practitioner. The field of computers is changing so rapidly that every course is a learning experience for the students as well as for the teacher. I look forward to working with you and in making it a mutual learning experience.
An ancient Chinese proverb says: "A Teacher may open the door but you must enter by yourself." I hope you take the challenge and enjoy the experience!

[Go to Top]

Learning Objectives

Provide the key concepts of word processing, spreadsheet, and presentation software

Familiarize with software packages that you will be using throughout the rest of your academic and professional career

Be aware of the ethical issues we face as responsible computer users, in the context of an increasingly computing dependent society

Prepare to sit for the Certified Microsoft Office Users (CMOU) Proficient User Exams in Microsoft Word 97 and Excel 97 and Expert User Exam in Microsoft PowerPoint 97

[Go to Top]

Exams and Grading Policies

GRADE BREAKDOWN
Exam #1 -------------------------------------> 15%
Exam #2 -------------------------------------> 15%
Exam #3 -------------------------------------> 15%
Final Exam ----------------------------------> 15%
Assignment # 1 ------------> 10%
Assignment # 2 ------------> 10%
Assignment # 3 ------------> 10%
Quizzes etc. --------------------------------> 10%
Total======================>>100%

GRADING SCALE
90.00-100----> A
80.00-89.99---> B
70.00-79.99---> C
60.00-69.99---> D
00.00-59.99---> F

Exams: You will take three exams and one final exam, each counting for 15% of your total course grade, during the course of the semester. Each test covers one specific application, while the final exam covers all three products. The truest measure of your proficiency in each application is how well you are able to utilize the application to perform tasks common to each application. Consequently, the tests will not be multiple choice or essay-type. Rather, you will demonstrate your knowledge of and skills in each application by performing a number of real world tasks within the application during the test.
Assignments: You will undertake three individual assignments during the semester. Each assignment will count for 10% of your total course grade. The assignments will involve significant use of each software application to prepare a document, spreadsheet, and presentation. More details will be given as the semester progresses.
Quizzes: Unannounced quizzes will be given periodically during the semester. Quizzes will cover textbook readings. Quizzes account for 10% of total course grade.
[Go to Top]

Students Honesty Policy
You are expected to maintain the highest standards of academic honesty and integrity while in this course and as a student at Florida Gulf Coast University. If you fail to maintain these standards as a student in this class, I will pursue the fullest possible implementation of academic discipline for your offense-this could be as severe as expulsion from the University. If you have any questions about the university's code of academic conduct, please consult the University Bulletin or me. In short lying, cheating, stealing, or deception of any type will not be tolerated in any way, shape, or form.
[Go to Top]

Course Outcomes and Skill Sets

Listed below are the skills that you can expect to learn during the semester. These skills and outcomes serve as the foundation for the Certified Microsoft Office User exam for each product (see appendix).

Microsoft Word 97
Microsoft Word is the world’s leading word processing program. During the course of your education and career you can expect to use Word in a variety of ways including preparing reports, mail-mergers, resumes, and letters.
By the end of this course, you should be able to produce the following types of documents using Microsoft Word 97:

Basic reports

Documents for the Internet or intranet

Envelopes and mailing labels

Faxes

Resumes

Single- and multiple-page letters and memos

Time sheets

Microsoft Excel 97
Excel is Microsoft’s spreadsheet program. It is designed to assist in all type of mathematical calculations. Excel enables you to perform mathematical, statistical, and financial calculations.
By the end of this course, you should be able to produce the following types of documents using Microsoft Excel 97:

Basic financial statements

Budgets

Expense reports

Invoices and purchase orders

Marketing and sales reports

Spreadsheets for use on the Internet and intranet

Microsoft PowerPoint 97
PowerPoint is Microsoft’s presentation graphics software. PowerPoint enables you to produce slides, overheads, and other transparencies quickly and easily for professional business presentations. PowerPoint excels in importing data from Microsoft Word and Excel. By the end of this course, you should be able to produce the following types of documents using Microsoft PowerPoint 97:

Slide shows

Multimedia presentations

Presentations on the Internet

[Go to Top]

Tentative Course Schedule Information

Date	Topics	Readings
08/24 - 08/28	Introductory Material Introduction and Course Overview If You are New to Windows 95 Class Meeting on 8/28 (8:30 - 11:00 am; Griffin 114)	Word 97 Step by Step: Appendix A
08/31 - 09/04	Exploring & Researching the Internet More about the Internet Microsoft Word 97 Creating and Saving Documents Moving and Copying Text	Lesson 1 Lesson 2
09/08 - 09/11	Changing the Appearance of Text Printing Your Document Increasing Editing Productivity	Lesson 3 Lesson 4 Lesson 5
09/14 - 09/18	Establishing the Look of a Page Using Styles Saving Time by Using Templates and Forms	Lesson 6 Lesson 7 Lesson 8
09/21 - 09/25	Tracking Changes in Documents Organizing a Document by Using Outlining Creating and Printing Merged Documents	Lesson 9 Lesson 10 Lesson 11
09/28 - 10/02	Arranging Text and Graphics in a Document Microsoft Excel 97 Working in the Excel Environment Setting up a Worksheet *Homework Assignment # 1 Due: MS Word97* Class Meeting on 10/02 (8:30 - 11:00 am; Griffin 114)	Lesson 12 Lesson 1 Lesson 2
10/05 - 10/09	*Test: MS Word97 (10/05)* Writing Formulas Formatting Your Worksheet for a Professional Look	Lesson 3 Lesson 4
10/12 - 10/16	Consolidating Multiple Lists Filtering to Find Specific Information Sorting and subtotaling to Organize Your Data	Lesson 5 Lesson 6 Lesson 7
10/19 - 10/23	Creating PivotTables to Summarize Data Charting to Assess Trends and Relationships	Lesson 8 Lesson 9
10/26 - 10/30	Printing Reports to Distribute Information Offline Comparing Alternatives for Better Decisions Microsoft PowerPoint 97 Creating a Presentation Working with a Presentation	Lesson 10 Lesson 11 Lesson 1 Lesson 2
11/02 - 11/06	*Homework Assignment # 2 Due: MS Excel 97* *Test: MS Excel 97* Printing a Presentation Outling Your Ideas	Lesson 3 Lesson 4
11/09 - 11/13	Adding and Modifying Text Applying and Modifying Templates Using a Color Scheme	Lesson 5 Lesson 6 Lesson 7
11/16 - 11/20	Drawing and Modifying Objects Inserting Information into PowerPoint Creating and Editing a Graph	Lesson 8 Lesson 9 Lesson 10
11/30 - 12/04	Producing a Slide Show Creating a Multimedia Presentation *Homework Assignment # 3 Due: PowerPoint 97* *Test: Microsoft PowerPoint 97 (12/04)*	Lesson 11 Lesson 12
12/11	Final Exam:Microsoft Word, Excel & PowerPoint (8:30 - 11:00 am; Griffin 114)

[Go to Top]

Microsoft Certification
This course is designed to prepare you to sit for three different Certified Microsoft Office User (CMOU) exams: Microsoft Word 97 Proficient User, Microsoft Excel 97 Proficient User, and Microsoft PowerPoint 97 Expert User (PowerPoint does not have a proficient user exam).
Passage of both the Word 97 and Excel 97 Proficient User exams makes you a Microsoft Certified Microsoft Office User at the Proficient User level. The CMOU program reflects the growing demand from the business community that successful applicants for positions have a demonstrated knowledge of the software products that they will be using on a daily basis. Possession of the CMOU will play a vital role in helping you to differentiate yourself from the crowd in today's highly competitive job market. Microsoft describes the complete CMOU program on its World Wide Web site at: http://www.microsoft.com/office/train_cert/.
Overview of the CMOU Tests
The exams for the Microsoft Office User program cost $50 each and are administered by independent testing centers. The Microsoft CMOU test page (http://www.microsoft.com/office/train_cert/s2/step2.htm) describes the overall tests as follows:
Certification as a Microsoft® Office User provides a valuable industry credential - proof that users have the skills required by employers. The exams are developed with input from subject matter experts in the corporate and education markets.
Test content comes from real-world scenarios and accurately mirrors on-the-job performance. Unlike multiple-choice tests that ask questions about the software, CMOU exams take place within the Microsoft Office programs themselves. Test-takers must demonstrate their skills in realistic tasks.
Microsoft describes the actual testing procedure as follows:
All Certified Microsoft® Office User (CMOU) testing is computer-based and is conducted on the Windows® 95 or Windows NT® operating system with the full array of Windows capabilities, including the graphical user interface. You will not be asked questions about Microsoft Office programs; you will be asked to perform tasks. The tests mirror actual job assignments within each Office product.
All of the exams take one hour or less - some take only about 30 minutes. In addition to measuring your skills, the tests also measure your productivity and efficiency. You may not use notes, manuals, a laptop, or any other aid to help you during the exam. You can take advantage of the built-in Office Help features, but be aware that doing so may use precious time and cause you to fail the test.
Additional Certification-CMOU Expert Level
The PowerPoint exam, along with additional Expert exams in Word, Excel, Access, FrontPage, and Outlook, are the foundations of the Certified Microsoft Office User Expert level certification.
CGS 1100 Outcomes, Skill Sets mapped to CMOU Requirements
The tables below map the skills that you learn during the semester to the CMOU requirements. These skills and outcomes serve as the foundation for the Certified Microsoft Office User exam for each product.

Microsoft Word Proficient User Skills
The following table lists the skill areas and required tasks for Microsoft Word 97 Proficient Users.

Skill area	Required tasks
Character formatting	Apply font styles (bold and italic) Use all underline options Apply character effects (superscript, subscript, and so on) Select and change fonts and font size (automatically and manually)
Columns	Enter and edit text in columns Revise column structure Delete and move columns
Drawing tools	Create and modify lines, objects, and 3-D shapes
File management	Locate and open an existing document Save a document with the same and/or different name Create a sub-directory
Internet and intranet document creation	Save as HTML Create a hyperlink Browse through files
Outlines	Create and modify an outline
Page layout	Create and modify page numbers, headers and footers Create sections with formatting that differs from other sections Create alternate headers and footers
Paragraph formatting and tab settings	Align tabs (left, center, and so on) Set tabs with leaders Use indentation options (first line, hanging indent, etc.,)
Printing	Use print preview Print a document, envelopes and labels
Styles and templates	Create (edit) and apply styles Use a template Create a fax
Tables	Create and format tables Add borders and shading to tables Modify table structure (merge cells, change height and width, and so on) Rotate text in a table
Text editing	Find and replace text Navigate through a document Set AutoCorrect exceptions Create and apply frequently used text
Text placement and alignment	Use hyphenation (non-breaking and soft hyphens) Align text horizontally and vertically Set margins Insert page breaks, date and time Set line spacing options Prepare envelopes and labels
Text processing	Cut, copy, insert, and move text Add bullets and numbering Use the Undo and Redo commands Use Overtype mode
Writing tools	Use the spelling checker Use the grammar checker

Microsoft Excel Proficient User Skills
The following table lists the skill areas and required tasks for Microsoft Excel 97 Proficient Users.

Skill area	Required tasks
Charts	Create, format, and modify charts Preview and print charts
Creating workbooks	Open electronic workbooks Enter text, numbers and formulas Save workbooks Close workbooks
Using drawing tools	Create and modify lines, objects and 3-D shapes
Formatting worksheets	Modify cell size and alignment Apply number and font formats Apply outlines
Functions	Use the AVERAGE, MIN, and MAX functions Use worksheet functions
Internet and intranet	Save as HTML
Modifying workbooks	Delete cell contents, worksheets Revise text, numbers, formulas Rotate and indent text Copy and move data Insert, modify, and delete rows and columns Use references (absolute, relative, and mixed) Sort data
Printing workbooks	Preview and print worksheets Print the screen and ranges Print headers and footers
Ranges	Create and name ranges Clear and format ranges Copy and move ranges

Microsoft PowerPoint 97 Proficient User Skills

Skill area	Required tasks
Creating presentations	Create from a template Create from an existing presentation Delete slides
Adding textual information	Enter text in a slide and outline view Enter bulleted information Change the text alignment
Adding visual elements	Add formatting Build a graph Draw, rotate, fill, scale and size an object Add a table Add shapes Animate objects Add transitions and set custom options Add an organizational chart Check styles
Importing an exporting data	Add clip art Insert a Microsoft Excel chart Import text from Microsoft Word Add scanned images, sound and movies Export an outline to Word
Modifying presentations	Change the sequence of a slide Find and replace text Modify the slide master Modify sequence in outline mode Change tabs, fonts, alignment of text
Editing presentations	Using the spelling checker Add speaker notes Set automatic slide timing
Customizing presentations	Create a custom background Customize a color scheme Customize clip art and other objects Recolor and edit objects Apply a template from another presentation Add links to other slides within the presentation Hide slides
Delivering presentations	Start a slide show from any slide Use on-screen navigation tools Generate meeting notes Incorporate meeting feedback electronically Print slides in a variety of formats Print color presentations Export to overhead Export to 35mm slides Deliver through Presentation Conferencing Save a presentation to use on another computer Save a presentation to deliver over the Internet

[Go to Top]

Last Updated: October 21, 1998
Raj Bandi

Welcome CGS1100 (Fall '98) Students

Welcome
CGS1100 (Fall '98) Students