Northeast Texas Community College

Course Syllabus        BCIS 1305

 

 

Instructor:                               Ms. O. A. Tuttle

 

Office:                                       Math/Science L

Phone:                                       903-434-8286

E-mail:                                      [email protected]

 

 

Office Hours:                             Posted outside office

                            

                             Others by appointment.

 

 

This syllabus is intended as a set of guidelines for this course.  Northeast Texas Community College and your instructor reserve the right to make modifications in content, schedule, and requirements as necessary to promote the best education possible within prevailing conditions affecting this course.

 

Course Title:              Business Computer Applications

 

Course Number:        BCIS 1305

 

Credit Hours:             3

 

Catalog Description 

 

Three hours credit.  Integration of applications from popular business productivity software suites.  Instruction in using word processing, spreadsheets, databases, presentation, and Internet software.   Prerequisite: none.  Suggested prerequisite:  POFT 1127 Introduction to Keyboarding.

 

Textbook and Supplies

 

            Text:                MS Office 2007 Windows XP Edition: Intro. Concepts…  Shelly, Cashman, Vermaat                    ISBN  1428326480 (bundle)

 

            To begin:

 

            Jump Drive to use for all assignments and tests.

 

            At least five labeled folders with pockets for turning in assignments.

 

            Clear plastic folder for tests, available in bookstore.

           

Project:

 

A project will be assigned after class has begun.

 

 

Course Objectives

 

After completing this course, each student will be able to...

 

1.      Use appropriate techniques when interacting with Microsoft Windows:

a.       Boot the computer and shut down Windows

b.      Use the mouse to point, click, double-click, right-click, drag, right-drag, and scroll

c.       Use the keyboard to enter data and commands

d.      Open and close programs and windows

e.       Maximize, minimize, restore, move, and resize windows

f.       Use WordPad to create, modify, save, and print documents

g.      Use Windows Explorer to view, select, copy, delete, and rename files and folders

h.      Use online help

 

2.      Use Word to produce simple documents:

a.       Create, edit, save, and print new and existing documents

b.      Enter text and blank lines, using wordwrap and autocorrect

c.       Enter a bulleted list of items, and create hanging indents and first-line indents

d.      Delete and insert characters, words, and phrases, and find and replace text

e.       Select, bold, italicize, underline, and resize words, lines, and paragraphs

f.       Change the default font size and margin settings

g.      Change the line spacing and horizontal alignment of paragraphs

h.      Display nonprinting characters, and change the zoom percentage

i.        Undo and redo actions

j.        Spell check documents, use the thesaurus

k.      Add manual page breaks

l.        Browse through a document by scrolling, and by page

m.    Create headers, footers, and footnotes

n.      Insert a table, enter data into a table, and autoformat a table

o.      Sort paragraphs

p.      Insert and use hyperlinks

q.      Download pictures from the Web

r.        Insert pictures into documents, and resize pictures

 

3.      Use Excel to produce simple workbooks:

a.       Create, edit, save, and print new and existing workbooks

b.      Enter numeric and text data

c.       Spell check workbooks

d.      Add column and pie charts, and manipulate the appearance of charts

e.       Use AutoFormat

f.       Select, bold, underline, format, align, and resize cell contents

g.      Center cell contents across columns

h.      Change background and font colors, and add borders

i.        Change row heights and column widths

j.        Clear cell contents, and delete embedded charts

k.      Copy cell contents to adjacent cells using the fill handle

l.        Use the Sum, Average, Max, and Min functions using AutoSum, AutoCalculate, and the Function Box

m.    Enter formulas using the keyboard and the mouse

n.      Print formulas, worksheet sections, and selected worksheets, and fit worksheets to one page

o.      Rearrange and rename worksheets

 

4.      Use Access to create simple databases:

a.       Create, edit, save and print new and existing tables

b.      Create and print reports and forms using AutoForm and AutoReport

c.       View data in datasheet and form views

d.      Create, save, run, print, clear, and close queries

e.       Include all fields or selected fields in a query, and use compound fields

f.       Join tables in a query, and restrict records in a join

g.      Sort data in a query using single or multiple keys

h.      Specify criteria in a query containing comparison operators, AND, OR, wildcards, text, and numbers

 

5.      Use PowerPoint to:

a.       Edit existing files

b.      Create new presentations

c.       Use on Internet

 

6.      Use the Internet to:

a.       Be introduced to the Internet and the World Wide Web

b.      Use basic e-mail and browser software

c.       Learn browser basics

d.      Search for information, based on differing criteria

 

Objectives met with SCANS Competencies:

1.         C1, C5, C6, C7, C8, C13, C15, C18, C19, F1, F2, F5, F7, F9, F10, F11, F12, F13, F14, F16, F17

 

2.         C1, C5, C6, C7, C8, C13, C15, C18, C19, F1, F2, F5, F7, F9, F10, F11, F12, F13, F14, F16, F17

 

3.         C1, C5, C6, C7, C8, C13, C15, C18, C19, F1, F2, F3, F4,  F5, F7, F8, F9, F10, F11, F12, F13, F14, F16, F17

 

4.         C1, C5, C6, C7, C8, C13, C15, C18, C19, F1, F2, F5, F7, F8, F9, F10, F11, F12, F13, F14, F16, F17

 

5.         C1, C5, C6, C7, C8, C13, C15, C18, C19, F1, F2, F3, F4,  F5, F7, F8, F9, F10, F11, F12, F13, F14, F16, F17

 

6.         C1, C5, C6, C7, C13, C15, C18, F1, F2, F5, F7, F8, F9, F11, F12, F13, F14, F16, F17