Introduction to Spreadsheets Syllabus for 2014-2015
Return to Syllabus List

Instructor Information

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

Prerequisite: Keyboarding skill of 30 wpm required

Course Description

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

Student Resources Student Resources Website

Department Expectations

\N

Occupational License Disclaimer

Hours

(3 sem hrs; 3 lec, 1 lab)

Class Type

Online Course

Syllabus Information

Textbooks

Benchmark Series:  Microsoft Excel 2013 Levels 1 & 2. Text with data files CD, by Rutkosky, Seguin, Davidson, Roggenkamp, and Rutkosky, published by Paradigm.
ISNB# 978-0-76385-389-1

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

Supplies

1. Textbook:  Benchmark Series:  Microsoft Excel 2013 Levels 1 & 2. Text with data files CD, by Rutkosky, Seguin, Davidson, Roggenkamp, and Rutkosky, published by Paradigm.
   

   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.
   \
   2. \ Perform basic mouse operations.
   \
   3. \ Manage files and folders using copy, paste, rename, and delete operations.
   \
   4. \ Create, modify, and delete Start menu changes and shortcuts.
   \
   5. \ Identify spreadsheet terminology and concepts.
   \
   6. \ Create, edit, and format Excel worksheets.
   \
   7. \ Enter and edit formulas and functions in a worksheet.
   \
   8. \ Create, edit, and format Excel datalist.
   \
   9. \ Edit, sort, and query an Excel datalist.
   \
   10. \ Create, edit and format Excel pivot tables.
   \
   \

   \ END-OF-COURSE OUTCOMES:  Define spreadsheet terminology and concepts, create formulas and functions, use formatting features, and generate charts, graphs, and reports.

   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

     60% of semester grade - Exams
     20% of semester grade - Lab Assignmens (Chapter Assessments)
     20% of semester grade - Final Exam
   100% Semester Grade

   Attendance

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

   Calendar

   Introduction to Spreadsheets—ITSW 1304
   Spring 2015
   Lesson Schedule

   Week Of
   January 20-26	Chapter 1 Preparing an Excel Worksheet—Pages 3-28
   January 27-February 2	Chapter 2 Inserting Formulas in a Worksheet—Pages 35-53
   February 3-9	Chapter 3 Formatting an Excel Worksheet—Pages 61-88
   February 10-16	Chapter 4 Enhancing a Worksheet—Pages 99-130
   February 17-23	Production #1
   February 24-March 2	Chapter 5 Moving Data within and between Workbooks—Pages 149-176
   March 3-9	Chapter 6 Maintaining Workbooks—Pages 187-220
   March 10-15	Chapter 7 Creating Charts and Inserting Formulas—Pages 229-260
   March 16-22	SPRING BREAK
   March 23-30	Chapter 8 Adding Visual Interest to Workbooks—Pages 271-294
   March 31-April 6	Production #2
   April 7-13	Level 2 Chapter 1 Advanced Formatting Techniques—Pages 3-31
   April 14-20	Level 2 Chapter 2 Advanced Functions and Formulas—Pages 39-62
   April 21-27	Level 2 Chapter 4 Summarizing and Consolidating Data—Pages 103-134
   April 28-May 4	Level 2 Chapter 7 Macros only—Pages 227-235
   May 5-11	Final Production

    

   Additional Information

   \N

   Syllabus Created on:

   11/30/-1 12:00 AM

   Last Edited on:

   11/30/-1 12:00 AM