Computer Applications for Business

CGS 2100

Syllabus - Spring Semester 2010

Instructor: Greg Shaw

Office:376A (Biscayne Bay Campus, Academic 1)

Hours:Tuesday: 12:50 – 1:50, 6:25 – 7:25

Thursday:12:50 – 1:50, 3:50 – 4:50,

6:25 – 7:25

(all times pm, others by appointment)

Phone:(305) 919-5970

E-mail:

Web:

Objectives:Solving business-related problems using state-of-the-artelectronic spreadsheet and database management applications

Required Texts:

  1. New Perspectives On Microsoft Office Excel 2007 --- Introductory

by Parsons, Oja, Ageloff, and Carey

  1. New Perspectives On Microsoft Office Access 2007 --- Introductory

by Adamsky and Finnegan

published by Thomson / Course technology

Common Course Outcomes for CGS 2100

  1. Master Getting Started with Excel
  2. Master Formatting a Workbook
  3. Master Working with Formulas and Functions
  4. Master Working with Charts and Graphics
  5. Master Working with Excel Tables, PivotTables, and PivotCharts
  6. Master Managing Multiple Worksheets and Workbooks
  7. Master Using Advanced Functions, Conditional Formatting, and Filtering
  8. Master Developing an Excel Application
  9. Master Creating a Database
  10. Master Building a Database and Defining Table Relationships
  11. Master Maintaining and Querying a Database
  12. Master Creating Forms and Reports
  13. Master Creating Advanced Queries and Enhancing Table Design
  14. Master Using Form Tools and Creating Custom Forms
  15. Master Creating Custom Reports

Tests and Other Important Dates

Test 1:Excel Tutorials 1 through 6

(Outcomes 1 thru 6)

Thursday, February 25th

Drop Date:Friday, 26th

Test 2:Access and Excel Tutorials 7 and 8

(Outcomes 7 through 13)

Thursday, April22nd - 11:00 am

Tests will be multiple-choice. There will be no makeup tests. If you are unable to attend on a test day, you must let me know far enough in advance to arrange to take the test before the scheduled day.

Prerequisite: Microsoft® Windows XP

Basic mouse skills - creating a folder –selecting, moving, copying, deleting, and renaming files and folders – saving a file: Save vs. Save As...

These topics will not be covered in class, but are covered thoroughly in the online notes. Students not familiar with any of these are welcome to come to office hours for help.
Unit I. Microsoft®Office Excel 2007

Tutorial1 – Getting Started with Excel

Assignment 1 (Outcome1)

Tutorial2 – Formatting a Workbook

Assignment 2 (Outcome 2)

Tutorial 3 – Working with Formulas and Functions

Assignment 3 (Outcome 3)

Tutorial4 –Working with Charts and Graphics

Assignment 4 (Outcome4)

Tutorial 5 – Working with Excel Tables, PivotTables, and PivotCharts

Assignment 5 (Outcome5)

Tutorial6 – Managing Multiple Worksheets and Workbooks

Assignment 6(Outcome 6)

Tutorial7 – Using Advanced Functions, Conditional Formatting, and FilteringNote: Session 7.1 and the VLOOKUP function only!

Assignment 7(Outcome7)

Tutorial 8 – Developing an Excel Application

Assignment 8(Outcome8)

Unit II. Microsoft® Office Access 2003

Tutorial 1 – Creating a Database

Assignment 9 (Outcome 9)

Tutorial2 – Building a Database and Defining Table Relationships

Assignment 10 (Outcome 10)

Tutorial3 – Maintaining and Querying a Database

Assignment 11 (Outcome 11)

Tutorial4 –Creating Forms and Reports

Assignment 12 (Outcome 12)

Tutorial 5 – Creating Advanced Queries and Enhancing Table Design

Assignment 13 (Outcome 13)

Tutorial6 – Using Form Tools andCreating Custom Forms

Assignment 14 (Outcome 14)

Tutorial7 – Creating Custom Reports(Outcome 15)

Grades

  1. There will be 14assignments (one per tutorial), which will be gradedand returned because students deserve and need regular assessments of their progress in the class. However, the assignment grades will not be used in computation of the course grade.
  1. The course grade will be based solely on the two tests, which will count 50% each. In order to pass the class, an average of 60% on the tests is required.
  1. Course grades are "curved" by comparing each person's test average to the highest in the class. For example, suppose the highest average in the class is 90%. Then, an average of 75 would curve to an 83, because 75 is 83% of 90.
  1. Each student’s curved average is then converted to a letter grade according to the following scale:

Numeric Average / Letter Grade
93..100 / A
90..92 / A-
87..89 / B+
83..86 / B
80..82 / B-
77..79 / C+
70..76 / C
60..69 / D
0..59 / F

Etc

Class policies on late assignments, partial credit, makeup tests, academic honesty, incompletes, etc, are covered in the document “Class Rules and Gregulations.”

Note

Students must have a USB “Flash” Drive on which to turn in assignments. Assignments will not be accepted on any other medium.