Introduction to Spreadsheets


  2. A. Course Title: Introduction to Spreadsheets
    B. Course Number: CS 213 - 10043
    C. Semester: Spring 2017
    D. Days/Time: T Th 11:00:00 AM - 1:30:00 PM
    E. Credit Hours: 3
    F. Instructor: Shook, Angila
    G. Office: C.M. Burke University Center (UC) 232
    H. Email Address:
    I. Office Phone: (575) 492-2658
    J. Office Hours: Monday: 7:45:00 AM-9:00:00 AM (MST); 10:45:00 AM-11:00:00 AM (MST); 12:45:00 PM-1:15:00 PM (MST);
    Tuesday: 8:30:00 AM-11:00:00 AM (MST);
    Wednesday: 7:45:00 AM-9:00:00 AM (MST); 10:45:00 AM-11:00:00 AM (MST);
    Thursday: 8:30:00 AM-11:00:00 AM (MST);
    Friday: 7:45:00 AM-8:45:00 AM (MST); 10:30:00 AM-11:00:00 AM (MST);
    If you need a different time, please contact me to setup an appointment.
    K. Time Zone: Mountain Time
    L. Prerequisite(s): Grade of C or higher in CS123D or consent of instructor.
    M. Corequisite(s):
    N. Class Location: BUC237

    This course is designed to give students a thorough understanding of spreadsheets, including graphics, windows, database functions, and macro design. The student should gain extensive hands-on experience in each facet of the application. This is a three credit hour course. Prerequisite: A grade of C or higher in CS 123D Business Computer Applications or consent of the instructor


    The target audience is the individual who requires a beginning to advanced course in spreadsheets (using Microsoft Excel). There is no guarantee of transferability and the student is advised to check with the receiving institution if they intend to transfer to another institution.



    Microsoft Office 365 & Excel 2016: Comprehensive
    Author(s): Freund, Steven M.
    ISBN: 1-305-87072-7
    ISBN-13: 978-1-305-87072-7
    Edition / Copyright: 17 - Current Edition
    Publisher: Cengage Learning
    Book Type: Paperback

    Sam 16 Assessment (only need one license if taking multiple courses requiring)
    Course Technology
    ISBN-13: 978-1-337-37266-4


    Flash drive or a google account for saving course work.

    You can buy your books online at the NMJC Bookstore.


    Students attending New Mexico Junior College will be evaluated according to the following grading scale:

    						90 - 100%	=	A
    						80 -  89%	=	B
    						70 -  79%	=	C
    						60 -  69%	=	D
    					 	 0 -  59%	=	F

    Late work will not be accepted!

    Final semester grades will be awarded based on the following percentages.
    Course Professionalism 10%
    SAM Training (apply mode) 10%
    SAM Projects 30%
    Chapter Lectures 10%
    Module Exams 40%

    *Exams include hands on tasks


    New Mexico Junior Collegeís institutional student learning outcomes represent the knowledge and abilities developed by students attending New Mexico Junior College. Upon completion students should achieve the following learning outcomes along with specific curriculum outcomes for respective areas of study:


    Students in the Computer Science Departments should be able to:
    *Demonstrate an understanding of industry specific ethics (self & community),
    *Prepare and interpret documents,
    *Interpret and characterize data appropriate to the course (critical thinking),
    *Demonstrate computer skills appropriate to the course, and
    *Demonstrate the value of professionalism in the workplace.


    At the completion of the course, a student should:
    1. Demonstrate Managing Data in a spreadsheet
    2. Develop spreadsheets with Formulas and Functions
    3. Develop a Professional-Looking Worksheet
    4. Produce spreadsheets with Charts and Graphics
    5. Produce spreadsheets with Excel Lists
    6. Manage with Multiple Worksheets and Workbooks
    7. Produce spreadsheets with Excel's Editing and Web Tools
    8. Develop an Excel Application
    9. Produce spreadsheets with Data Tables and Scenario Management
    10. Use Solver for Complex Problems
    11. Import Data into Excel
    12. Extend Excel with Visual Basic for Applications


    I will return phone/mail messages by the the end of the next business day. Grades for work will be posted by one week past the assignment deadline.


    Students will be held responsible for the information on these pages.

    Academic Honesty
    Each student is expected to maintain the highest standards of honesty and integrity in online academic and professional matters. The College reserves the right to take disciplinary action, up to and including dismissal, against any student who is found guilty of academic dishonesty or otherwise fails to meet these standards. Academic dishonesty includes, but is not limited to, dishonesty in quizzes, tests, or assignments; claiming credit for work not done or done by others; and nondisclosure or misrepresentation in filling out applications or other College records. Cheating or gaining illegal information for any type of graded work is considered dishonest and will be dealt with accordingly.

    Americans with Disabilities Act (ADA) Information
    Any student requiring special accommodations should contact the Special Needs Student Services Coordinator at (575) 492-2576 or by e-mail at

    Attendance Policy
    Attendance is required at every session of each course for which the student is enrolled. When unavoidable circumstances make attendance impossible, students must provide a satisfactory explanation of their absences to their professors. College-sponsored activities are considered excused absences and the appropriate sponsor of those students who will be absent from class will notify professors. Students having absences due to college-sponsored activities will need to make arrangements with the affected classes / professor to take care of required work; however, arrangements for make-ups should be made within a reasonable time frame, usually within one week of the absence. Regarding make-up work, absences due to late registration are considered the same as regular absences.

    Cell Phones/Pagers
    All cell phones and pagers must be turned off when the student is participating in any lecture, laboratory, or other learning activity.

    Classroom Conduct
    The professor is responsible for maintaining a class environment best suited for effective learning. By registering for this class, the student is assumed to have entered into an agreement with New Mexico Junior College and the professor to attend the class regularly and to behave in an appropriate manner at all times. Disruptive behavior may result in the student being removed from the class.

    Food and Drink Policy
    Food items and soft drinks may not be consumed in NMJC classrooms. Students are also discouraged from bringing food and drink items into the classroom even though these items remain in sealed packaging. Bottled water is permissible.

    No Children in the Classroom
    In order to adhere to instructional procedures as well as maintain the safety of children, NMJC’s policy of no children in the classrooms (lecture, lab, etc.) will be followed.

    Offering the work of another as one’s own, without proper acknowledgment, is plagiarism; therefore, any student who fails to give credit for quotations or essentially identical expression of material taken from books, encyclopedias, magazines and other reference works, or from the themes, reports, or other writings of a fellow student, is guilty of plagiarism. Plagiarism violates the academic honesty policy and is considered cheating.

    Smoking/Use of Tobacco
    New Mexico Junior College is cognizant of the health hazards associated with smoking / use of tobacco for the smoker, as well as the non-smoker. In an effort to provide a healthy environment for students, employees, and others who may frequent the campus, NMJC prohibits smoking / use of tobacco inside any campus building or facility.

    Tutoring Assistance
    Free tutoring services are available to all NMJC students through Brainfuse and the Academic Success Center located in Mansur Hall room 123 and 124.

    Withdrawal Policy
    Regular, punctual attendance is required for all classes at NMJC. Although the professor has the right to drop any student who has missed the equivalent of 2 weeks of instruction (based on a 16 week semester) whether itís a face to face, online, or a hybrid course, it is not guaranteed that the professor will drop the student. If the student chooses to stop attending a class, he/she should withdraw from the class by accessing your student account in the T-Bird Web Portal at, or submitting the required paperwork to the Registrar’s Office by 5:00 p.m. on Thursday, April 20, 2017. All students are encouraged to discuss their class status with the professor prior to withdrawing from the class.

  15. COURSE OUTLINE Instructor reserves the right to modify due dates.


    Topics Covered

    Due Date

    Module 0

    Introduction to Canvas and course


    Module 1

    Do & Don't of Professionalism

    Industry specific ethics (self & community),

    Professionalism in the workplace.


    Module 2

    Creating a Worksheet and a chart

    Formulas, Functions, and Formatting

    Working with Large Worksheets, Charting, and What-If Analysis


    Module 3

    Financial Functions, Data Tables, and Amortization Schedules

    Working with Multiple Worksheets and Workbooks

    Creating, Sorting, and Querying a table


    Module 4

    Templates, Importing Data, and Working with SmartArt, Images, and Screenshots

    Working with Trendlines, PivotTables, PivotCharts, and Slicers

    Formula Auditing, Data Validation, and Complex Problem Solving


    Module 5

    Data Analysis with Power Tools and Creating Macros

    User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features in Excel


    Final Exam

    5-8-2017 @ 12:00 - 1:45 PM

    The course will be divided into modules containing projects, quizzes, and exams. It will be administered in Canvas and SAM. The exams and quizzes will consist of multiple choice and true false questions and hands on skills.