Amarillo College Logo

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

Instructor Information

Instructor

(Curriculum Vitae)

E-Mail

jgmills@actx.edu

Phone

<p>(806) 236-8934</p>

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

Online 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, and print a database.
    2. Design, create, edit, and print electronic presentations.
    3. Design, create, edit, and print presentation slides. 

    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

    \N

    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 requires.

    Calendar

    COURSE SCHEDULE
    ITSC 1309
    Online
    Spring 2015

    Week of:

     

    Jan. 20 - 26
     

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

    Jan. 27 – Feb. 2

     

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

    Assignment:  Access Chapter 1 Exercises and Assessments

    Feb. 3 - 9

     

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

    Assignment:  Access Chapter 2 Exercises and Assessments

    Feb. 10 - 16

     

    Access Chapter 3 Performing Queries—Pages 77-128

    Assignment:  Access Chapter 3 Exercises and Assessments

    Feb. 17 - 23

     

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

    Assignment:  Access Chapter 4 Exercises and Assessments

    Feb. 24 – Mar. 2

     

    Performance Assessment over Chapter 1-4

    Peruse Access Chapter 5

    Mar. 3 - 9

     

    Access Chapter 5 Creating Forms—Pages 183-228

    Assignment:  Access Chapter 5 Exercises and Assessments

    Mar. 10 - 15

     

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

    Assignment:  Access Chapter 6 Exercises and Assessments

    Mar. 16 -22

    SPRING BREAK

    Mar. 23 - 29

     

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

    Assignment:  Access Chapter 7 Exercises and Assessments

    Mar. 30 – April 6

     

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

    Assignment:  Access Chapter 8 Exercises and Assessments

    April 7 - 13

    Performance Assessment over Chapter 5-8

    April 14 - 20

     

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

    Assignment:  PowerPoint Chapter 1 Assessments

    April 21 - 27

     

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

    Assessments

    April 28 – May 4

     

    PowerPoint Chapter 3 Formatting Slides—Pages 79-124

    Create original presentations

    May 5 - 11

    Performance Assessments over PowerPoint

    Additional Information

    \N

    Syllabus Created on:

    11/30/-1 12:00 AM

    Last Edited on:

    11/30/-1 12:00 AM