Office    none                   Student/Teacher communication - Before/after class or via Email & Web Site

Course Description  This course introduces the basics of computing, the role of the computer in
modern society and ethical considerations.  Practical aspects are emphasized using “hands-on”
experiences with various contemporary software.  The impact of the computer on interpersonal
and group communications such as email, blogs, and social networks (chat room, MySpace, Facebook, etc.)
will be examined.   (Modified from Course Catalogue listing)

Evaluation Method    Students will be evaluated using quiz grades, homework assignments,
portfolio, class participation, web site construction. handson LAB and written/performance final.

Teaching Methods  The class will be taught at Jackson County High School using adult pedagogy.  Course
will include online communications, assignments and "dropping" homework in an assigned mailbox.

Course Goal  To provide sufficient resources and instruction to assure that each student completing this
course is able to manipulate data files in various application packages producing information that is useful to
the student's academic success and employment.

Late Work Policy  All assigned tasks must be completed (and submitted/posted) by the assigned due
dates.  Participation exercises, threaded discussions, case studies and quizzes must be completed by the
assigned due dates (late work will not be accepted).
Late homework assignments will be deducted 10 points each class period they are late (regardless of the total
points for the assignment).  Class quizzes cannot be "made up."
Students with Disabilities  It is the policy of Midway College to accommodate individuals with disabilities pursuant to federal law
and the College's commitment to equal educational opportunities. It is the responsibility of the student to inform the instructor of any
necessary accommodations at the beginning of the course. Any student with a disability requiring accommodations should contact the
Director of Student Affairs in the Student Center or at 846-5391.
________________________________________
Learning Outcomes    
    1.        Design, create and edit basic word processing documents
    2.        Create word processing documents that are formatted for a given style manual,
                using wizards and templates
    3.        Understand and explain word processing terminology and functions
    4.        Design, create and edit moderately complex electronic spreadsheets
    5.        Create and edit spreadsheet charts
    6.        Understand and create spreadsheets that utilize absolute and relative addressing
    7.        Understand and create spreadsheets that utilize selection functions (IF)
                and conditional formatting
    8.        Understand and create spreadsheets that utilize sensitivity analysis and goal seeking
    9.        Understand and explain spreadsheet terminology and functions
    10.      Design, create and maintain moderately complex databases
    11.      Design, create and maintain database tables
    12.      Design, create and maintain database forms, queries and reports
    13.      Understand and explain database terminology and functions
    14.      Design, create and maintain moderately complex databases
    15.      Design, create and maintain electronic presentations
    16.      Understand and explain electronic presentation terminology and functions
    17.      Research, compose and present business application software features
________________________________________
Weekly Topics        All assigned tasks must be completed by the beginning
of each class period.  LAB time will be given at the end of each class meeting.

Week and Activity                                       

Week 1: Getting Started                                       
    Introduction
    Becoming familiar with course expectations.
    Identifying  Vista features
    Email use for homework
                    
Week 2: Microsoft Word                                     
    Basic Word features
    Creating a research paper using Word
                  
Week 3: Microsoft Word                                        
    Using Word wizards
    Quiz on Microsoft Word

Week 4: Microsoft PowerPoint
    Designing and creating electronic presentations
            Sept 10, 2008     
    Creating a Web site
       
Week 5: Microsoft Excel                                Sept  , 2009         
    Microsoft Power Point Project Presentation
    Basic spreadsheet terminology and features
    Using formulas and functions
    Basic charts

Week 6: Microsoft Excel                                     
    Relative and absolute address
    Assumptions
    Modifying charts

Week 7: Microsoft Access                                        
    Database terminology
    Designing and building relational tables
    Report wizard - Designing and creating queries
    Excel Quiz

Week 8: Microsoft Access                                   
    Final
    includes Quiz on Microsoft Access
    Final Web Portfolio Project Due
    Written/performance final                



________________________________________
Grading Policy        A 10-point scale will be used to determine a student's final course grade:
Percentage        Grade
90-100                      A
80-89                        B
70-79                        C
60-69                        D
Below 60                 F


A student’s course grade will calculated as follows:
Component        Points Possible
Class Participation (8 weeks @ 10 points each)        80
LAB Assignments (8 weeks @ 15 points each)       120
Homework (8 weeks @ 25 points each)                     200
Reading and working through textbook chapters              100
Quizzes (4 quizzes/projects @ 25 points each)          100
Final Project
(4 components @ 50 points each                                   300
plus  Written/Performance final)
           Total       900
Course Syllabus
    CS  235
    Advanced Software Applications
    Midway College

Instructor   Larry C. Bobbert, Ed. D        
bobbert@bobbert.biz
     Phone 859 623 9645  

Scroll down  below the
outline of each class
assignment.

All homework assignments
are listed, but remember
some special assignments
page so that I know you are
checking out the web site
each week.

The detailed outline will change
as the class progresses.
Midway College
but is a private site paid for by
Dr. Larry C. Bobbert
who is solely responsible for content
Sept 4, '09

Weekly Topics Revised
Sept 4, '09