ADMN-1313: Spreadsheet Applications ( On Campus, Split | Fall 2017 )

Download this syllabus as a PDF Document.

Instructor Information
Instructor Name

Bobbie Hawkins

Instructor Rank

Associate Professor

Instructor Email bhawkins@southwest.tn.edu
Instructor Website

faculty.southwest.tn.edu/bhawkins

Instructor Office

MAB 257e Macon Cove

Office Hours

Posted on Office Door.

Instructor Phone

(901) 333-4682

Department Fax

(901) 333-4377

Department Phone

(901) 333-4150

Course Information
Course Description

This course is an instructor led, hands-on course in which the student uses an electronic spreadsheet to plan, create, manipulate, and print worksheets. The software used in this course is Microsoft EXCEL 2016. Topics include entering and editing data, formatting a worksheet, use of formulas and common functions, charts, advanced printing, and linking worksheets. This course meets Specialist MOS certification requirements.

Student Learning Objectives

Student learning outcomes -

The student will be able to open, navigate, and create basic worksheets.

The student will be able to edit and format a worksheet including the addition of charts.

The student will be able to enter formulas and functions to analyze data within worksheets

The student will be able to research for data within Excel and incorporate into a worksheet.

The student will be able to manage workbooks including the use of templates, hyperlinks, and printing.

Prerequisites

Keyboarding Skill and recommended INFS 1010 or similar class.

Instructional / Learning Methods

This course will utilize a variety of learning methods. Lecture, instructor-led chapter tutorials, lab assignments, written assignments, written tests, hands-on lab tests, and projects will be utilized.

Specific Course Requirements

In order to successfully complete this course, students must also possess basic computer skills, the ability to follow written directions, and be able to read for comprehension.

Textbooks, Supplementary Materials, Hardware, and Software Requirements
Hardware/Software Requirements

Student must have access to Excel 2016 for outside of class assignments (please note: Excel 2016 is available on all computers in the computer labs, Academic Support centers, and the libraries at all campuses.)

Southwest is a Microsoft approved e-Academy and is offering Microsoft Office 365 University, which is the Microsoft Office 2016 suite, to current students. More information about this can be found on your my.southwest account.

Required Text
  • Microsoft Excel 2016: Benchmark Series (Level 1) by Rutkosky, Roggenkamp, and Rutkosky, EMC Paradigm Publishing. [ISBN No. 978-0-76386-938-0 (Text + eBook)]
  • SNAP 2016 User Access Code

    NOTE: The Snap 2016 User Access Code must be purchased to be able to complete the required course assignments and tests.  It is necessary to purchase only one Access Code for each Southwest student; the same code can be used for all Administrative Professional Technology courses using SNAP--as long as the student is enrolled at Southwest.  Microsoft Office 2016 is required for SNAP.

Supplementary Materials

A flash drive is necessary for saving materials.

Hardware Requirements

This course requires the use of a PC computer with XP or Windows 7 operating system. (Vista can be used also).

If this course requires the use of a computer, these are general recommendations for accessing any of the services that Southwest offers on the Web (e.g. My.Southwest, etc.).

  • minimum Pentium IV or higher processor (recommended)
  • SVGA monitor, minimum resolution 800x600 (1024x768 strongly recommended)
  • CD-ROM or DVD drive
  • floppy drive, zip drive, or CD-RW drive
  • Mouse or compatible pointing device
  • at least 512 MB of RAM (recommended)
  • (optional) printer
Software Requirements

The software listed below is required for accessing course materials -

Microsoft Office 2016 with Spreadsheet Applications (Excel).

The software listed below is recommended for any student accessing Southwest services through the internet. Your course may have specific software requirements.

  • Windows 7, Vista, XP
  • Mac OS X (up to 10.6) (OS 10.6 recommended)
  • Linux with a Supported Browser
  • Microsoft Edge+
  • IE 10 & 11: some issues+
  • Firefox (latest)+
  • Firefox ESR+
  • Chrome (latest)+
  • Current Anti-Virus protection
  • Reliable Internet connection (broadband recommended but not required)

Many instructors may require assignments to be submitted using Microsoft Excel or Microsoft Word. To learn how to obtain discounted software from Microsoft, visit http://southwest.tn.onthehub.com.

Assessment and Grading
Method of Evaluation

The final academic grade given in the course is based on the following:

  • 50% Tests
  • 40% Assignments
  • 10% Attendance

 

Grading Scale

A = 90 - 100%

B = 80 - 89%

C = 70 - 79%

D = 60 - 69%

F =    0 - 59%

For students earning the AAS Degree in Administrative Professional Technology and/or the Computer Software Specialist Technology Certificate, minimum standards for successful completion of ADMN 1313 (Spreadsheet Applications) will be a grade of "C."

Testing Procedure / Policy

There will be three (3) tests; all three (3) will be given IN CLASS and in SNAP.  No makeup test will be given without documented proof of inability to come to class on the test dates.

   Test 1:  Unit 1 (Chapters 1-4)

   Test 2:  Unit 2 (Chapters 5-8)

   Test 3:  Final Exam (Comprehensive:  Chapters 1-8)

Major Assignments

Assignments will be submitted in class and in SNAP.

Participation / Attendance Policy

Students are expected to attend class and submit assignments in a timely manner.  Class attendance is 10% of the semester grade. Roll will be taken for each class period, and students who miss class will be reported on a regular basis as required by the college. Attendance on test days is MANDATORY, since no makeup or take-home tests will be given.

Guidelines for Communications
Email Guidelines

Each student has been provided a Southwest e-mail account. Please do not email your classmates unless the topic relates specifically to this course. E-mails that contain advertisements, solicitations, personal interests, etc. are strictly forbidden. Below are a few guidelines that you should keep in mind when sending email:

  • Always include a subject line.
  • Typing in all CAPS is considered SHOUTING in Cyberspace. So please use upper and lower case characters when sending e-mails.
  • Remember, without facial expressions some comments may be taken the wrong way. Be careful in wording your e-mails and use good Netiquette
  • Use standard fonts.
  • Do not send large attachments without permission.
  • Respect the privacy of other class members.

Online instructors will respond to all e-mails within 48 hours.

Discussion Guidelines

Below are a few guidelines that should be adhered to when using the Discussion forum. Messages that contain advertisements, solicitations, personal interests, etc. are strictly forbidden.

  • Review the discussion threads thoroughly before entering the discussion.
  • Please try to maintain threads by using the "Reply" button rather starting a new topic.
  • Do not make insulting or inflammatory statements to other members of the class. Be respectful of others' ideas.
  • Be patient and read the comments of other group members thoroughly before entering your remarks.
  • Be positive and constructive in group discussions.
  • Respond in a thoughtful and timely manner.
Technical Support
Technical Support

My.Southwest: Submit a Student Technical Support Request. Please provide a full detailed explanation of the problem.

PAWS: For course related questions, contact your instructor. For technical issues with the PAWS website, contact the College Helpdesk at (901) 333-4357.

Course Topics
Tentative Schedule
  • Course Orientation, Getting Started
  • Preparing an Excel Worksheet--Chapter 1
  • Inserting Formulas in a Worksheet--Chapter 2
  • Formatting an Excel Worksheet Chapter--3
  • Enhancing a Worksheet--Chapter 4
  • Unit 1 Performance Assessments  (Chapters 1-4)
  • Moving Data within and between Workbooks--Chapter 5
  • Maintaining Workbooks--Chapter 6
  • Creating a Chart in Excel--Chapter 7
  • Adding Visual Interest to Workbooks--Chapter 8
  • Unit 2 Performance Assessments  (Chapters 5-8)
  • Final Exam (Chapters 1-8)
Student Services
Embedded Librarian Service This service may be found inside PAWS courses.
Two Southwest Librarians are assigned to work with you and your instructor throughout the course for the entire semester. The Librarians will suggest library resources and answer questions sent to "Ask A Librarian".

To contact a Librarian, go to the Classlist and select the "Ask A Librarian" tab.
Student Services Links

Academic Support

The Academic Support Center(ASC) provides free services and resources to help Southwest students successfully reach their academic and career goals. These services include tutoring by peer and master tutors, computer labs, success workshops, academic coaching, early alerts from your instructors and areas for individual or group study at numerous locations. The ASC also provides Supplemental Instruction in some of our general education classes and the Center is also responsible for Academic Progress Reporting so that you will be award of your academic standing during the 5th-6th week of the semester. Online tutoring services are offered through Smarthinking 24 hours a day, 7 days a week. Simply login to your PAWS to access this online tutoring resource.

Drop/Withdrawal Dates

See the official college catalog for the current withdrawal policies. Important semester drop and withdrawal dates can be found on the college Web site at http://www.southwest.tn.edu.

Academic Misconduct

Plagiarism, cheating, and other forms of academic dishonesty are prohibited. A student guilty of academic misconduct, either directly or indirectly, through participation or assistance, is immediately responsible to the instructor of the class. The instructor has the authority to assign an “F” grade or a zero for the exercise or examination, or to assign an “F” for the course. College sanctions for academic misconduct may include suspension or dismissal from the College. Please see the section in the current Catalog on Academic Misconduct.

Classroom Behavior: Any student engaged in disruptive conduct or conduct violating the general rules or regulations of the College may be ordered to temporarily leave the classroom. Extended or permanent exclusion from the classroom can be achieved only through appropriate procedures of the College.

Open Labs

Macon Cove

  • Academic Support Center: Available during working hours
  • Bert Bornblum Library: Available during library hours
  • Farris 2131: M-R 8-5:30, F 804:30

Union Avenue

  • Academic Support Center - F Building, Room 319, available during working hours
  • Parrish Library - Available during library hours
  • M105: 8-6:30

Gill

  • Computer Lab- Room 101 (Please note - this room is available when classes are not scheduled. Schedule fluctuates each semester.)
  • Library - Available during Library hours only.

Maxine Smith

  • Open Lab- Room 101.
  • Library - Available during Library hours only.

Whitehaven

  • Open Lab Building 6, Room 127
  • Library - Available during Library hours only.
Syllabus Updates The instructor reserves the right to make changes as necessary to this syllabus. If changes are necessitated during the term of the course, the instructor will immediately notify students of such changes.