Amarillo College Logo

Introduction to Spreadsheets Syllabus for 2011-2012
Return to Syllabus List

Instructor Information

Instructor

Della Lummus (Curriculum Vitae)

E-Mail

Phone

Phone number not available

Office Location

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

ITSW-1304-001 Introduction to Spreadsheets

Prerequisites

Keyboarding skill of 30 wpm required

Course Description

Instruction in the concepts, procedures and importance of electronic spreadsheets.

Student Resources Student Resources Website

Department Expectations

\N

Occupational License Disclaimer

Hours

(3 sem hrs; 3 lec, 1 lab)

Class Type

On Campus Course

Syllabus Information

Textbooks

Benchmark Series:  Microsoft Excel 2007 Levels 1 & 2, Windows XP Edition, by Nita Rutkosky, Denise Seguin, and Audrey Roggenkamp, EMC Paradigm, ©2008.
ISNB# 978-0-76383-007-6

Current textbook selections are available at the Washington Street Campus bookstore.

Supplies

  1. Textbook - Benchmark Series:  Microsoft Excel 2007 Levels 1 & 2, Windows XP Edition, by Nita Rutkosky, Denise Seguin, and Audrey Roggenkamp, EMC Paradigm, ©2008.
    ISNB# 978-0-76383-007-6

    Student Performance

    The student will identify spreadsheet terminology and concepts; create formulas and functions; use formatting features; and generate charts, graphs, and reports.

    \

    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.

    The student will be able to complete satisfactorily all of the listed Performance Learning Objectives with a competency level based on the completion of required examinations administered under the supervision of the instructor and evaluated according to the instructors grading scale.
    \
    \

    \
      \
    1. Identify basic concepts of an operating system. *(C1,C10,C11,C12, C13,C14,C18,C19,C20,F1,F2,F3,F5,F7,F8,F9,F10,F11,F12)
      2. \
    2. Perform basic mouse operations. *(C1,C10,C11,C12,C13,C14,C18, C19,C20,F1,F2,F3,F5,F7,F8,F9,F10,F11,F12,F13,F16,F17)
      3. \
    3. Manage files and folders using copy, paste, rename, and delete operations.*(C1,C10,C11,C12,C13,C14,C18,C19,C20,F1,F2,F3,F5,F7, F8,F9,F10,F11,F12,F13,F16,F17)
      4. \
    4. Create, modify, and delete Start menu changes and shortcuts.*(C1, C10,C11,C12,C13,C14,C18,C19,C20,F1,F2,F3,F5,F7,F8,F9,F10,F11,F12,F13,F16,F17)
      5. \
    5. Identify spreadsheet terminology and concepts.*(C1,C10,C11,C12, C13,C14,C18,C19,C20,F1,F2,F3,F5,F7,F8,F9,F10,F11,F12,F13,F16,F17)
      6. \
    6. Create, edit, and format Excel worksheets.*(C1,C10,C11,C12, C13,C14,C18,C19,C20,F1,F2,F3,F4,F5,F7,F8,F9,F10,F11,F12,F13,F16,F17)
      7. \
    7. Enter and edit formulas and functions in a worksheet.*(C1,C10, C11,C12,C13,C14,C18,C19,C20,F1,F2,F3,F4,F5,F7,F8,F9,F10,F11,F12,F13,F16,F17)
      8. \
    8. Create, edit, and format Excel datalist.*(C1,C10,C11,C12,C13, C14,C18,C19,C20,F1,F2,F3,F4,F5,F7,F8,F9,F10,F11,F12,F13,F16,F17)
      9. \
    9. Edit, sort, and query an Excel datalist. *(C1,C10,C11,C12,C13, C14,C18,C19,C20,F1,F2,F3,F4,F5,F7,F8,F9,F10,F11,F12,F13,F16,F17)
      10. \
    10. Create, edit and format Excel pivot tables. *(C1,C10,C11,C12, C13,C14,C18,C19,C20,F1,F2,F3,F4,F5,F7,F8,F9,F10,F11,F12,F13,F16,F17)
      \
      \ *(Refers to SCANS-the Secretary Commission on Achieving Necessary Skills according to the U.S. Department of Labor. The SCANS will be explained by your instructor at the first class meeting.)
      11. \

    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

    See the Office Adminstration Department Policy distributed by your instructor the first class meeting.

    \

    CELL PHONES: Please turn off your cell phones before coming to class. Do not bring IPODS to class.

    \

     

    Grading Criteria

    Grading Scale:

     20% - Lab Assignments
     80% - Exams
    100%

    HOMEWORK

    All lab assignments must be typed. When answering True/False and Multiple Choice questions, type the questions and highlight the answer.

    Label lab assignments in the upper right corner including student name, Chapter and Exercise or Assessment Number. Staple all papers together for each Chapter.

    Lab assignments are due at the beginning of class.

               NO LATE LAB ASSIGNMENTS WILL BE ACCEPTED.

    EXAMS

    Note the date for exams on the course schedule. These exams must be taken on the date indicated. Exams may not be taken early or late.

    Attendance

    Employees in the business world are expected to be at work promptly each day; therefore, students in business classes are expected to be in class promptly each day.  This class meets twice each week.  After one absence for any reason, three points will be deducted from the semester average for each additional absence.  There are no excused absences.  Three tardies equal one absence.  If you leave class while class is being conducted, it will count as a tardy.  If you are more than 10 minutes late, it will be counted as an absence.

    Calendar

    COURSE SCHEDULE
    Introduction to Spreadsheets -- ITSW1304
    6:00 p.m. to 10:00 p.m. Tuesday and Thursday
    Summer I, 2012

    Date                            Topic

    May 22
     

     

    Discussion:            Syllabus
                                     ExcelChapter 1

    Assignment:         Chapter 1 Exercises, Concepts Check,  Assessments

    May 24

     

    Discussion:            ExcelChapter 2

    Assignment:         Chapter 2 Exercises, Concepts Check,  Assessments

    May 29

     

    Discussion:            Excel Chapter 3

    Assignment:         Chapter 3 Exercises, Concepts Check,  Assessments

    May 31

    Discussion:            Excel Chapter 4

    Assignment          Chapter 4 Exercises, Concepts Check,  Assessments

    June 5

    Unit 1 Performance Assessments

    June 7

    EXAM 1 OVER EXCEL CHAPTERS 1 – 4

    June 12

     

    Discussion:            Excel Chapter 7

    Assignment:         Chapter 7 Exercises, Concepts Check, Assessments

    June 14
     

     

    Discussion:            Excel Chapter 8

    Assignment:         Chapter 8 Exercises, Concepts Check, Assessments
                                                Unit 2 Performance Assessments 4, 5, 6, 7, 8, 9

    June 19

     

    Discussion:            Excel Level 2
                                                Chapter 1

    Assignment:          Chapter 1 Exercises, Concepts Check, Assessments                              

    June 21


     

    Discussion:            Excel Level 2
                                                Chapter 2

    Assignment:          Chapter 2 Exercises, Concepts Check, Assessments    

    June 26

     

    Discussion:            Review for Comprehensive Final Exam

    Assignment:         Practice Test

    June 28

    COMPREHENSIVE FINAL EXAM 2

    Additional Information

    \N

    Syllabus Created on:

    11/30/-1 12:00 AM

    Last Edited on:

    11/30/-1 12:00 AM