NEW MEXICO JUNIOR COLLEGE
Introduction to Spreadsheets
|A.||Course Title:||Introduction to Spreadsheets|
|B.||Course Number:||CS 224 - 10828|
|G.||Office:||C.M. Burke University Center (UC) 232|
|I.||Office Phone:||(575) 492-2658|
|J.||Office Hours:|| Monday: 7:30:00 AM-9:00:00 AM (MST);10:15:00 AM-11:00:00 AM (MST);12:15:00 PM-12:45:00 PM (MST);
Tuesday: 7:30:00 AM-9:30:00 AM (MST);
Wednesday: 7:30:00 AM-9:00:00 AM (MST);10:15:00 AM-11:00:00 AM (MST);
Thursday: 7:30:00 AM-9:30:00 AM (MST);
If you need a different time, please contact me to setup an appointment.
|K.||Time Zone:||Mountain Time|
This course is designed to give students a thorough understanding of spreadsheets, and prepares students for the MOS: Microsoft Office Excel Expert certification exam. The student should gain extensive hand-on experience in each facet of the application
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.
Edition / Copyright: 17 - Current Edition
Publisher: Cengage Learning
Book Type: Paperback
Sam 16 Assessment (only need one license if taking multiple courses requiring)
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%
Training (apply mode) 10%
Chapter Lectures 10%
Module Exams 25%
Proctored Final Exam 15%
All communication and submitted work must follow the communication standard.
• No text language (For example do not use i, BTW, LOL, IDK…)
• Correct spelling and proper capitalization
• Complete sentences (Start a sentence with a capital letter and end it with a period.)
• Logical organization
Retrieving Grades from T-BirdWeb Portal
Go to the New Mexico Junior College T-BirdWeb Portal login page. Please enter your User Identification Number (ID), which is your Banner ID, and your Personal Identification Number (PIN). When finished, click Login.
Tips for Success in Online Courses:
1. Log in to class regularly.
2. Pay attention.
3. Take notes.
4. Keep up with readings and assignments.
5. Ask questions when you do not understand something.
6. Utilize your professor’s office hours and e-mail.
7. Read the text.
8. Adhere to the deadlines posted in the course outline.
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:
1. Demonstrate an understanding of industry specific ethics (self & community),
2. Prepare and interpret documents,
3. Interpret and characterize data appropriate to the course (critical thinking),
4. Demonstrate computer skills appropriate to the course, and
5. 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
If you have not already received login information for Canvas/T-BirdWeb Portal/E-mail, you will need to contact the Enrollment Management office at (575) 492-2546.
Check first-time login page for instructions at www.nmjc.edu/distancelearning/coursescourseschedules/canvasinstructions.aspx.
You must have access, on a regular basis, to a computer that supports the Canvas minimum specifications and has an active connection to the Internet. See the minimum computer specification requirements at www.nmjc.edu/distancelearning/coursescourseschedules/Canvasinstructions.aspx.
I will return phone/mail messages by the the end of the next business day. Grades for work will be posted no later than one week after the assignment deadline.
Students will be held responsible for the information on these pages.
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 email@example.com.
Attendance Policy and Participation Expectations
It is expected that you regularly log into class at least three times weekly and check your Canvas mail to ensure you have not missed any changes/updates. Students are expected to complete discussions/quizzes/tests/ assignments before deadlines expire.
If you experience difficulty with Canvas you may reach the Canvas Helpdesk at firstname.lastname@example.org, or by calling the 24 hour helpdesk phone at (575) 399-2199.
The professor is responsible for monitoring and evaluating student conduct and student behavior within the Canvas course. By registering for this class, the student is assumed to have entered into an agreement with New Mexico Junior College and the professor to log into 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 and dropped for the semester. For comprehensive information on the common rules of netiquette and other online issues, please review the NMJC Online Student Handbook.
Online Learning Environment
By participating in an online class, you undertake responsibility for your own progress and time management.
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.
Free tutoring services are available to all NMJC students through Brainfuse and the Academic Success Center located at the Pannell Library on the 1st floor.
The instructor has the right to drop any student who has failed to log on to Canvas for two weeks or more, but it is not guaranteed that the instructor will drop you. 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 www.nmjc.edu, or submitting the required paperwork to the Registrar’s Office by 5:00 p.m. on Thursday, April 18, 2019. Failure to withdraw yourself from a course by this date may result in your receiving an “F” in the course. All students are encouraged to discuss their class status with the professor prior to withdrawing from the class.
Industry specific ethics (self & community),
I2, I6, I7,D1, D5
Creating a Worksheet and a chart
Formulas, Functions, and Formatting
Working with Large Worksheets, Charting, and What-If Analysis
Module training and exam
Financial Functions, Data Tables, and Amortization Schedules
Working with Multiple Worksheets and Workbooks
Creating, Sorting, and Querying a table
Module training and exam
I4, D2,C2,C5, C6,C9
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
User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features in Excel
Module training and exam
I4, D2,C7, C10, C11
Final Exam May 4-7 (proctored)