Frederick Community College

 

CIS111R-ONL– Business Software Applications

 

Spring 2012

 

Class Begins: 1/30/2012

Class Ends: 5/18/2012

Last Day to Drop: 4/16/2012

  

You must send your Academic Integrity Pledge to the instructor. The form is available at http://courses.frederick.edu/_utilities/regform.htm

 

Instructor Information

 

 

Name: Susan Boyne

Office:  C222

E-mail:  sboyne@frederick.edu

Phone Number:  301-846-2410

Office Hours:  See faculty information in Bb

Campus Mail Box #:  229

 

Course Information

 

 

Credits:  3

 

On-campus Meetings:  Orientation

On-campus Exams:  2

Prerequisites:  CIS101 or CIS116D

Co-requisites:  None

 

 Course Description

 

Covers the basic, intermediate and advanced features of word processing.  Students create, edit, format and save personal and business documents.  Along with data integration, special features such as mail merge, sorting, styles, columns, footnotes, outlines, table of contents, indexes, and templates are presented.

 

Core Learning Outcomes

 

By the completion of the course students will be able to:

·      Understand the fundamentals of Windows and an integrated suite of software products

·      Recognize the types of problems that can be solved using a computer and an integrated suite of products such as Microsoft Office

·      Properly use business software terminology

·      Utilize the software package tools in an integrated fashion

 

 Instructional Methods

 

Blackboard Website/Discussion Board/Practice Quizzes

Blackboard Required Quizzes                                

Instructor E-mail support

Software hands-on activities

Reading assignments (text and online)

Authors’ DVD demonstrations

 

 

Course Organization

 

This course is to be taken on the Internet.  With the exception of an orientation and two on-campus examinations, all correspondence, class instruction and notes, communication (both with students and instructor) and assignments are to be completed online.

 

Text(s) and Course Materials

 

                TEXT TITLE:      Your Office Microsoft Office 2010

                   AUTHOR:      Kisner, Amy
              PUBLISHER:      Pearson/Prentice Hall

 

              SOFTWARE:      Microsoft Office 2010

 

         TEXT WEBSITE:      http://www.pearsonhighered.com/youroffice

   COURSE WEBSITE:      http://www.frederick.blackboard.com

 

Evaluation Methods

Final Grade Scale

 

 

Hands on projects                    40% of grade

On-line theory quizzes            20% of grade

Theory exams                           40% of grade

90% & above               = A**

80% - 89%                   = B

70% - 79%                   = C

60% - 69%                   = D

Below 59%                   = F

If the graded performance for online assignments differs significantly from the grade average for proctored assignments, the instructor reserves the right to administer additional tests.

**NOTE: It will be necessary to hand in every chapter assignment to receive an “A” grade in this course.

 

Student Services

 

A variety of services are available to assist students in succeeding at FCC. Students can learn more about these services by visiting the Student Services web page: http://www.frederick.edu/student_services/index.aspx.

Students with disabilities who are in need of accommodations or who have questions related to disabilities services should contact the Services for Students with Disabilities (SSD) office at 301-846-2408. Students can learn more about these services by visiting the Services for Students with Disabilities web page: http://www.frederick.edu/student_services/disability.aspx.

If you currently receive services from the SSD office, please submit your Student Success Plan to me and make an appointment with me to discuss your accommodations and needs in class.  I will hold any information you share with me in strict confidence unless you give me permission to do otherwise.

 

Attendance/Participation Policy

 

Attendance:  Attendance on campus is required for the examinations.  You will have a week to take the exam in the testing center.   You will be required to sign in and provide a photo id at the testing center.

The quizzes will be administered online.  You will have an assigned week to log on and take each quiz.  Quizzes will be taken at home. 

Students are required to submit assignments via Bb's Assignment folder by the date assigned on the syllabus (unless otherwise instructed).  Refer to the Assignments folder for the weekly assignments.

 

Participation:  Students are required to participate in this class through Bb discussions, assignments, quizzes, exams, and e-mails.  Please submit all work via the Bb Assignments area by the due date.  Late assignments will be accepted with points deducted.  However, late assignments will NOT be accepted once the exam for the tutorial has been completed.

 

 E-Mail Policy

 

With the exception of MOL students, all FCC students will receive and are expected to use their FCC email address for correspondence with faculty and staff at the college. Students can establish and access their FCC email accounts at https://myfcc.frederick.edu. Email is an instructional tool essential to student-instructor and student-student communication. In the Blackboard environment by default, your email address is available to all students in this course. However, students are permitted to use email addresses of other students in this course only for the purpose and the duration of this course.

 

The instructor can be expected to respond to regular student e-mail inquiries (grades, posted assignments, and tests excluded) within the time frame of 24 to 48 hours.

 

Academic Integrity

 

Work in this course is subject to the provisions of the FCC Code of Academic Honesty. Plagiarism in any form will not be tolerated. As a student, it is your job to practice academic honesty at ALL times.  Make sure that all sources, particularly Internet sources, get proper credit for quotations, paraphrases, and ideas.  More information about this and the Student Conduct Code are available at http://www.frederick.edu/student_services/studentpolicies.aspx

You must send your Academic Integrity Pledge to the instructor. The form is available at http://courses.frederick.edu/_utilities/regform.htm

 

 

Progress Report:

 

 

Grades will be posted in the grade book section of the blackboard site weekly.  Students can monitor their progress/grades throughout the semester via the Blackboard grade book.

 

At the end of the sixth week, students will be notified by the instructor if they have a grade lower than a C.  You will have an opportunity to evaluate your progress in this course and decide if you need to make any adjustments (additional study, tutoring, conference with instructor) to assure your success in this course.

 

 

Notes:

 

1.         Within each week, you will be working in a self-paced environment in which you set the pace for reading and practicing the assigned tutorials and completing the assignments by their due dates.  You are advised to use your time wisely and efficiently in order to set your work speed, to make decisions and to set priorities in order to meet the weekly tutorial, assignment and quiz deadlines.

2.         You must have access to MS Office 2010 (either at home, work, or make time to use FCC’s computer labs).  This class and book are geared for Office 2010 using WINDOWS 7.  There are many differences in the software in the PC and MAC environments.  If you are using a MAC, it is your responsibility to investigate and resolve any software differences between the book and MAC’s version of Office. ALSO there are MAJOR changes in Office 2010, and you will not be able to following the directions in the book if you use earlier versions of MS Office!!!!!

3.         It is your responsibility to locate the assignments and due dates from the Bb site and adhere to the schedule.  You may hand in assignments late; however, points will be deducted.  Chapter assignments will NOT be accepted after the exam for that chapter has been graded.

4.         Computer problems or failure to connect to the Internet to access Bb/e-mail will not excuse you from completing the course requirements by the due dates.  The computer lab is available during posted hours.

5.         Student data files are on the CD that accompanies the book OR the files can be downloaded from the text's Web site.  There is a link to the text's Web site in Course Information folder in Bb and the link is also listed in the text.  Read the directions on downloading files BEFORE you attempt to download the data files. 

6.         In order to fully understand the concepts introduced in each chapter, to successfully complete the required assignments at the end of the chapter, and to receive the best possible grade in this course, all chapter exercises should be completed.  FYI:  In the past, students were unsuccessful in this course if they did not read the required chapters and complete the step-by-step exercises within the chapters.

7.         All assignments will be saved as directed in the book with one modification:  Please include your last and first names as the first part of the file name.  e.g. Boyne_Susan_RockMusic1stQuarterSales.xlsx

8.         You are welcomed (and encouraged) to send your assignments to me as soon as you finish them (as opposed to waiting until the due date).  I can then provide immediate feedback and grading, which may help in completing remaining assignments.

9.         All graded work will be submitted via Bb's Assignment folder.  Occasionally work will be e-mailed to the instructor as an attachment at the e-mail address listed in the Instructor Information section of this syllabus.

10.      Quizzes:  Online theory quizzes must be taken each week.  Quizzes are only available in the Assessments folder of Bb during the assigned timeframe.  Quizzes will expire and will no longer be accessible after the due date.

11.      Please notify the instructor immediately of any change in phone number(s), e-mail address, or any other means of contact**.  Also make these changes in Bb. 
**You are required to use your myfcc email address.

12.   If you have any questions or concerns, please notify the instructor by e-mail.

 


TOPICAL OUTLINE

Date

Content

Student Activities

Week 1

 

1/30/2012

Windows 7 Workshop 1:  ID the Windows Desktop
Using the Start Menu
Opening/Managing Windows
Working with Multiple Windows
Personalizing the Desktop
Using Windows Explore
Working with Folders/Files

Windows 7 Workshop 1: (NO Assignments, pay particular attention to):
Using Windows Explorer
Working with Folder/Files

 

 

Common Features Workshop 1:  Understanding the Common Features of MS Office 2010:
Switching Between Windows
Using the Ribbons
Using Contextual Tools
Managing Files

Using the Ribbons
Using Contextual Tools
Managing Files

Common Features Workshop 1:  (NO Assignments, pay particular attention to):
Using the Ribbons
Managing Files

 

 

Word Workshop 1: Reviewing & Modifying a Document
Exploring the Word interface
Opening documents
Displaying nonprinting characters/ruler
Saving/closing documents
Using Spell Check
Creating/Editing AutoCorrect entries
Save as .pdf/Skydrive
Viewing Backstage
Editing/Printing documents

Word WS 1 Exercises/Practices

 

Word WS 1 Quiz

Week 2

 

2/6/2012

Word Workshop 2: Creating & Editing a Document
Working with Word Styles
Adjusting Paragraph/Line spacing
Indenting lines
Adding Bullets/Numbers/Symbols
Cutting/Copying/Pasting text
Changing Page Setup/Page Background
Using Themes
Using Format Painter/Find & Replace

Word WS 2 Exercises/Practices

 

Word WS 2 Quiz

 

Word Module 1 Capstone Assignments

 

Word Workshop 3: Including Tables & Objects
Using WordArt
Creating SmartArt
Inserting Text Boxes/Graphics
Inserting Text from Another Document
Setting Tabs
Creating/Modifying Tables
Inserting Page Breaks
Avoiding Orphan/Widow Lines

Word WS 3 Exercises/Practices

 

Word WS 3 Quiz

Week 3

 

2/13/2012

Word Workshop 4: Formatting Special Documents & Using Mail Merge
Working with Columns
Inserting Citations
Adding Footnotes/Endnotes
Using an Annotated Bibliography
Crediting/Editing a Bibliography

Word WS 4 Exercises/Practices

 

Word WS 4 Quiz

 

Word Module 2 Capstone Assignments

 

Week 4

 

2/20/2012

 

Excel Workshop 1: Understanding & Manipulating Microsoft Excel 2010
Exploring the Excel Interface
Enter/Edit Data
Cut/Copy/Paste
Use AutoFill
Insert/Delete Cells/Rows/Columns
Select Contiguous/Noncontiguous Columns/Rows
Use AutoFit
Name Worksheets
Print/Print Preview Worksheets

 

Excel WS 1 Exercise/Practices

 

Excel WS 1 Quiz

 

Excel Workshop 2: Formatting, Formulas, & Functions
Format Cell/Cell Ranges/Worksheets
Create Formulas/Functions
Insert/Remove Conditional Formatting

Excel WS 2 Exercises/Practices

 

Excel WS 2 Quiz

 

Excel Module 1 Capstone Assignments

Week 5

 

2/27/2012

Excel Workshop 3: Conducting Excel Analysis Through Functions & Charts
Use Absolute and Mixed Cell Referencing
Create/Use Name Ranges
Create Common Date/Math/Statistical/Financial/Logical Functions

Excel WS 3 Exercises/Practices

 

Excel WS 3 Quiz

Week 6

 

3/5/2012

Excel Workshop 4: Using Charts
Create/Modify Pie/Line/Column/Bar/Scatter Charts
Analyze Using Trendlines

Excel WS 4 Exercises/Practices

 

Excel WS 4 Quiz

 

Excel Module 1 Capstone Assignments

Week 7

 

3/12/2012

Theory/Production Test:  Word & Excel

The exam will be a multiple choice theory test given in the Testing Center
The test will be available from:  March 14 – March 20

Spring Break

March 19 – 23

FCC open (NO classes) March 19-20

FCC closed:  March 21-24

Week 8

 

3/26/2012

Access Workshop 1: Understanding the Four Main Database Objects
Exploring the Access Interface
Customizing the Navigation Pane
Using the Search Box
Importing a Table
Creating/Printing Queries/Forms/Reports

Access WS 1 Exercises/Practices

 

Access WS 1 Quiz

 

Week 9

 

4/2/2012

Access Workshop 2: Gathering Data into a Database
Importing Data from Other Sources
Enter Data Manually
Creating a Table in Design View
Working with Input Masks
Designating Primary/Foreign/Composite Keys
Creating 1-M and M-M Relationships
Cascade Up/Cascade Delete Referential Integrity

Access WS 2 Exercises/Practices

 

Access WS 2 Quiz

 

Access Module 1 Capstone Assignments

Week 10

 

4/9/2012

Access Workshop 3: Accessing Information from an Access Database
Finding Records
Filtering Datasheets
Modifying Datasheet Appearance
Run Find Duplicates/Find Unmatched Query
Create Queries in Design View
Using And/Or Logical Operators

Access WS 3 Exercises/Practices

 

Access WS 3 Quiz

 

 

Week 11

 

4/16/2012

Access Workshop 4: Accessing Information from an Access Database
Finding Records
Filtering Datasheets
Modifying Datasheet Appear

 

LAST DAY TO WITHDRAW FROM COURSE

Access WS 4 Exercises/Practices

 

Access WS 4 Quiz

 

Access Module 2 Capstone Assignments

Week 12

 

4/23/2012

PowerPoint Workshop 1: Communicating with Presentations
Exploring the PowerPoint Interface
Create/Modify a Presentation
Working with Print-Friendly/Screen-Friendly Fonts
Workings with Themes/Templates
Printing Slides/Handouts/Outlines

PP WS 1 Exercises/Practices

 

PP WS 1 Quiz

 

 

 

PowerPoint Workshop 2: Applying & Modifying Text & Graphics
Reviewing a Storyboard
Developing the Presentation Content
Inserting Slide Footers/Slide Numbers/Special Symbols
Reusing Slide Content
Inserting/Modifying Clip Art/Pictures/Graphics/WordArt
Creating Shapes/Lines
Applying a Picture as a Slide Background
Creating/Modifying Tables
Creating/Inserting Charts
Creating a SmartArt Graphic

PP WS 2 Exercises/Practices

 

PP WS 2 Quiz

 

PP Module 1 Capstone Assignments

Week 13

 

4/30/2012

PowerPoint Workshop 3: Applying & Modifying Multimedia
Using Transitions/Animations
Creating Hyperlinks
Inserting Audio/Video
Creating Photo albums
Crating a Custom Slide Show
Saving/Sending Presentations

 

PP WS 3 Exercises/Practices

 

PP WS 3 Quiz

 

 

PowerPoint Workshop 4: Customizing, Collaborating, & Presenting
Modifying the Slide Master
Customizing the Notes Page Master
Customizing the Handout Master
Collaborating with Others on a Presentation
Delivering a Presentation

PP WS 4 Exercises/Practices

 

PP WS 4 Quiz

 

PP Module 2 Capstone Assignments

Week 14

 

5/7/2012

Integrating Word/Excel/Access/PowerPoint

Integration Assignments

Week 15

 

5/14/2012

Theory/Production Test:  Access & PowerPoint

The exam will be a multiple choice theory test given in the Testing Center
The test will be available from:  May 10 – May 18

NOTE:  The instructor reserves the right to make changes to this outline as needed.

 


MS Office is a SKILLS-BASED course which means that the more time you spend working  applying the new concepts, the more familiar and proficient you will become with the individual software.

Below is a list of the required weekly work and the estimated time it will take to complete this work:

Week

Read/Complete Step-By-Step Chapter Exercise

Chapter Practice  Assignments

Chapter Quiz Preparation &
Completion

Module Capstone Assignments

Test Preparation &
Completion

APPROXIMATE WEEKLY HOURS

1

80-100 minutes

45-60 minutes

45-60 minutes

 

 

3-4

2

120-180 minutes

90-120 minutes

60-90 minutes

60-90 minutes

 

6-8

3

60-90 minutes

45-60 minutes

45-60 minutes

60-90 minutes

 

4-5

4

120-180 minutes

60-90 minutes

60-90 minutes

60-90 minutes

 

4-7

5

60-90 minutes

45-60 minutes

45-60 minutes

 

 

3-4

6

60-90 minutes

45-60 minutes

45-60 minutes

60-90 minutes

 

4-6

7

 

 

 

 

120-180 minutes

2-3

8

90-120 minutes

60-90 minutes

45-60 minutes

 

 

3-5

9

90-120 minutes

60-90 minutes

45-60 minutes

60-90 minutes

 

4-6

10

90-120 minutes

60-90 minutes

45-60 minutes

 

 

3-5

11

90-120 minutes

60-90 minutes

45-60 minutes

60-90 minutes

 

4-6

12

120-180 minutes

60-90 minutes

60-90 minutes

60-90 minutes

 

5-8

13

120-180 minutes

60-90 minutes

60-90 minutes

60-90 minutes

 

4-8

14

 

 

 

120-180 minutes

 

2-3

15

 

 

 

 

120-180 minutes

2-3

APPROXIMATE HOURS spent on this course the entire semester:

51.5-78 HOURS