Florida Gulf Coast University

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 Info| Readings| Teaching Philosophy| Learning Objectives| Grading Policy|
Students Honesty Policy| Course Outcomes| Schedule| Microsoft Certification|]

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
  1. Catapult. (1997). Microsoft Word 97 Step by Step. Redmond, WA: Microsoft Press. (ISBN: 1-57231-313-7).
  2. Catapult. (1997). Microsoft Excel 97 Step by Step. Redmond, WA: Microsoft Press. (ISBN: 1-57231-314-5).
  3. 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
  1. Provide the key concepts of word processing, spreadsheet, and presentation software
  2. Familiarize with software packages that you will be using throughout the rest of your academic and professional career
  3. Be aware of the ethical issues we face as responsible computer users, in the context of an increasingly computing dependent society
  4. 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