Integrated Software Applications I Syllabus for 2014-2015
Return to Syllabus List

Instructor Information

Office Location

R. E. Byrd Business Building 

Office Hours

Course Information

Recording Policy

Disability Statement

Any student who, because of a disabling condition, may require some special arrangements in order to meet course requirements should contact disAbility Services (Student Service Center room 119, phone 371-5436) as soon as possible.

Statement for Mental Health and Advocacy & Resource Center:

As a student you may experience a range of issues that can cause barriers to learning, such as strained relationships, increased anxiety, alcohol/drug problems, feeling down, difficulty concentrating and/or lack of motivation. These mental health concerns or stressful events may lead to diminished academic performance or reduce a student's ability to participate in daily activities. Amarillo College offers services to assist you with addressing these and other concerns you may be experiencing. If you or someone you know are suffering from any of the aforementioned conditions, you can learn more about the broad range of confidential mental health services available on campus by calling the AC Counseling Center at 806-371-5900. The AC Counseling Center website is https://www.actx.edu/counseling/ . Also, if you are in need of social services (affordable housing, utilities, transportation, food, clothing, childcare, medical/dental/vision, legal), please call the AC Advocacy & Resource Center at 806-371-5439. The AC Advocacy & Resource Center website is https://www.actx.edu/arc

Amarillo College Tutoring for Success Policy:

Administrative Drop Policy

N/A

Student Withdrawal Procedures

N/A

Privacy Statement

The Amarillo College Privacy Policy is found at https://www.actx.edu/-amarillo-college-privacy-notice , and applies to all Amarillo College students.  If you have questions about this privacy statement or you believe that your personal information has been released without your consent, send email to humanresources@actx.edu .

Course

ITSC-1309-001 Integrated Software Applications I

Prerequisites

Prerequisite: Keyboarding skill of 30 wpm required

Course Description

Introduction to business productivity software suites using word processing, spreadsheets, databases and/or presentation software.

Student Resources Student Resources Website

Department Expectations

\N

Occupational License Disclaimer

Hours

(3 sem hrs; 2 lec, 4 lab)

Class Type

On Campus Course

Syllabus Information

Textbooks

Benchmark Series:  Microsoft Access 2013 Level 1, Text with data files CD, by Rutkosky, Roggenkamp, and Rutkosky, published by Paradigm
ISBN# 978-0-76385-393-8

Benchmark Series:  Microsoft PowerPoint 2013, Text with data files CD, by Rutkosky, Roggenkamp, and Rutkosky, published by Paradigm
ISBN# 978-0-76385-395-2

Supplies

  1. Textbooks - Benchmark Series:  Microsoft Access 2013 Level 1, Text with data files CD, by Rutkosky, Roggenkamp, and Rutkosky, published by Paradigm
    ISBN# 978-0-76385-393-8
  2. <

    Student Performance

    The student will use word processing, spreadsheet, database, and/or presentation media software; apply integration techniques and produce combined documents; and explain the process of integrating data between applications.

    By the end of the semester, the student will be able to complete satisfactorily all of the listed Learning Outcomes (Minimum Competencies) with a competency level based on the completion of required examinations administered under the supervision of the instructor and evaluated according to the instructor’s grading scale in Office Administration Department.

    After studying the material presented in this course, the student will be able to do the following as evaluated by the faculty in the Office Administration Department:

    1. Design, create, edit, including modifying tables, table structure, queries, forms, and reports.
    2. Design, create, edit, and print databases.
    3. Design, create, edit & print power point presentations.

    END-OF-COURSE OUTCOMES:  Use word processing, spreadsheet, database, and/or presentation software; and integrate applications to produce documents.

    Students Rights and Responsibilities

    Student Rights and Responsibilities

    Log in using the AC Connect Portal

    In order to receive your AC Connect Email, you must log in through AC Connect at https://acconnect.actx.edu .

    If you are an active staff or faculty member according to Human Resources, use "Exchange". All other students, use "AC Connect (Google) Email".

    Expected Student Behavior

    No behavior expectations available

    Grading Criteria

    GRADING SCALE:  90-100 = A; 80-89 = B; 70-79 = C; 60-69 = D; <60 = F

      20% of semester grade  -  Chapter Exercises & Assessments
      80% of semester grade  -  Unit Exams 
    100%                             -  Semester Grade

     

    Attendance

    \ Since this is an online course, attendance is not recorded.  You are expected to invest approximately the same amount of time as a traditional, seated course.

    Calendar

    COURSE SCHEDULE
    ITSC 1309
    Online
    Fall 2015

    Week of:

     

    August 24 – 26

     

    Syllabus – Print and Study
    Review “Browsing the Internet Using Internet Explorer 8.0” in your Access textbook

    August 31 – Sept. 2

     

    Access Chapter 1 Managing and Creating Tables—Pages 3-42

    Assignment:  Access Chapter 1 Exercises and Assessments


    Sept. 7
     

    Sept. 9
     

     

    LABOR DAY HOLIDAY

    Access
    Chapter 2 Creating Relationships between Tables—Pages 43-76

    Assignment:  Access Chapter 2 Exercises and Assessments

    Sept. 14 – 16

     

    Access Chapter 3 Performing Queries—Pages 77-128

    Assignment:  Access Chapter 3 Exercises and Assessments

    Sept. 21 – 23

     

    Access Chapter 4 Creating and Modifying Tables in Design View—Pages 129-180

    Assignment:  Access Chapter 4 Exercises and Assessments

    Sept. 28

    Sept. 30

    Review Chapters 1-4

    Performance Assessment over Chapter 1-4

    Oct. 5 – 7

     

    Access Chapter 5 Creating Forms—Pages 183-228

    Assignment:  Access Chapter 5 Exercises and Assessments

    Oct. 12 – 14

     

    Access Chapter 6 Creating Reports and Mailing Labels—Pages 229-262

    Assignment:  Access Chapter 6 Exercises and Assessments

    Oct. 19 – 21

     

    Access Chapter 7 Modifying, Filtering, and Viewing Data—Pages 263-290

    Assignment:  Access Chapter 7 Exercises and Assessments

    Oct. 26 – 28

     

    Access Chapter 8 Exporting and Importing Data—Pages 291-318

    Assignment:  Access Chapter 8 Exercises and Assessments

    Nov. 2

    Performance Assessment over Chapter 5-8

    Nov. 4-9

     

    PowerPoint Chapter 1 Preparing a PowerPoint Presentation—Pages 3-42

    Assignment:  PowerPoint Chapter 1 Assessments

    Nov. 11-16

     

    PowerPoint Chapter 2 Modifying a Presentation and Using Help—Pages 43-78

    Assessments

    Nov. 18-23

     

    PowerPoint Chapter 3 Formatting Slides—Pages 79-124

    Create original presentations

    Nov. 25

    Create original presentation

    Nov. 30-Dec. 2 Present to class
    Nov. 7-11 Performance Assessment over PowerPoint

    Additional Information

    No additional information available

    Syllabus Created on:

    11/30/-1 12:00 AM

    Last Edited on:

    11/30/-1 12:00 AM