NEW MEXICO JUNIOR COLLEGE

Advanced Business Computer Applications

SYLLABUS

  1. GENERAL COURSE INFORMATION
  2. A. Course Title: Advanced Business Computer Applications
    B. Course Number: CS 123G - 30785
    C. Semester: Fall 2019
    D. Days/Time: Online
    E. Credit Hours: 3
    F. Instructor: Shook, Angila
    G. Office: C.M. Burke University Center (UC) 232
    H. Email Address: AShook@nmjc.edu
    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
    L. Prerequisite(s): CS 123D Business Computer Applications
    M. Corequisite(s):
    N. Class Location: Virtual
  3. COURSE DESCRIPTION

    This course is a continuation of Business Computer Applications. The main focus of study is on advanced computer concepts relating to the business environment. This is a three credit hour course. Prerequisite: CS 123D Business Computer Applications

  4. COURSE RATIONALE / TRANSFERABILITY

    The target audience is anyone who desires an advanced computer course which covers the Microsoft Office Suite. This course may transfer to New Mexico schools. The student should check with the receiving institution.

  5. REQUIRED / SUGGESTED COURSE MATERIALS

    Required:

    Cengage - Cengage Unlimited, 1 term (4 months) Printed Access Card ISBN: 9780357700037
    OR
    Cable/Freund/Monk/Seebok/Vermaat- BNDL:SC MS OFFICE 365/OFFICE 2019 ADVANCED
    ISBN: 9780357269299


    Software: Word 2019, Excel 2019, Access 2019, PowerPoint 2019


    You will need to have a webcam, microphone, and speakers for this course.

    Suggested:

    Flash drive or google account to save coursework.

    You can buy your books online at the NMJC Bookstore.

  6. GRADING POLICY

    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 20%
    SAM Training (Hands on Training in the apply mode) 10%
    SAM Projects (Hands on Labs assigned in SAM) 20%
    Module Exams 25% (will consist of a M/C exam and SAM hands on exam)
    Final Exam (proctored) 25%

    Work submitted not following the communication standard will receive an initial grade of zero with an option to resubmit.
    Email communication must also follow the communication standards or points will be deducted from your professionalism grade.

    Communication standard for class:
    • 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.

  7. INSTITUTIONAL STUDENT LEARNING OUTCOMES

    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:

  8. DEPARTMENTAL STUDENT LEARNING OUTCOMES

    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

  9. SPECIFIC COURSE STUDENT LEARNING OUTCOMES

    At the completion of the course, a student should:
    • Create documents with a table, chart, watermark as well as use mail merge, and create professional newsletters using Microsoft Word.
    • Create spreadsheets which use financial functions, data tables, amortizations schedules, hyperlinks, work with list, and create templates using Microsoft Excel.
    • Create reports, forms, combo boxes, switchboards, pivot tables, pivot charts, enhance forms with OLE fields, hyperlinks, and sub forms using Microsoft Access.
    • Use visuals to enhance a slide show and be able to modify visual elements using Microsoft PowerPoint.

  10. REQUIRED TECHNICAL COMPETENCIES AND EQUIPMENT

    Student Requirements
    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.

    Canvas Assistance

    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.

  11. ADDITIONAL INFORMATION

    I will return messages within 24 hours Monday-Friday. Any messages received on the weekend will be returned on Monday.

    You can expect your work to be graded and posted no later than one week after the due date.

  12. GENERAL/MISCELLANEOUS

    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 krueda@nmjc.edu.

    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.

    Canvas Help
    If you experience difficulty with Canvas you may reach the Canvas Helpdesk at canvashelpdesk@nmjc.edu, or by calling the 24 hour helpdesk phone at (575) 399-2199.

    Netiquette
    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.

    Plagiarism
    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.

    Tutoring Assistance
    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.

    Withdrawal Policy
    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 Tuesday, November 19, 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.

  13. ACADEMIC CALENDAR
  14. FINALS SCHEDULE
  15. COURSE OUTLINE

    Module

    Topics Covered

    Due

    Outcome
    I-Institutional
    D-Departmental
    C-Course

    Module

    Word

    ·         Using Document Collaboration, Integration and Charting Tools

    1-22-2019

     I4, D2,C1

    ·         Creating a Reference Document with a Table of Contents and an Index

    1-29-2019

     I4, D2,C1

    ·         Creating a Template for an Online Form

    2-5-2019

     I4, D2,C1

    ·         Enhancing an Online Form and Using Macros

    2-12-2019

    I4, D2,C1

    ·         Module Review and Exam

    2-13-2019

    I4, D2,C1

    Module Professionalism

    ·         Do & Don't of Professionalism

    ·         Industry specific ethics (self & community),

    ·         Professionalism in the workplace.

    2-24-2019

    I(2,6,7)

    D(1,5)

    Module

    Excel

    ·         Working with Trendlines, PivotTables, PivotCharts, and Slicers

    3-4-2019

    I4, D2,C2

    ·         Formula Auditing, Data Validation, and Complex Problem Solving

    3-11-2019

    I4, D2,C2

    ·         Data Analysis with Power Tools and Creating Macros

    3-18-2019

    I4, D2,C2

    ·         Module Review and Exam

    3-20-2019

    I4, D2,C2

    Module

    Access

    ·         Macros, Navigation Forms, and Control Layouts

    4-8-2019

     I4, D2,C3

    ·         Administering a Database System

    4-15-2019

    I4, D2,C3

    ·         Module Review and Exam

    4-15-2019

    I4, D2,C3

    Module PowerPoint

    ·         Customizing a Template and Handouts Using Masters

    4-21-2019

    I4, D2,C4

    ·         Modifying a Presentation Using Graphical Elements

    4-28-2019

    I4, D2,C4

    ·         Module Review and Exam

    5-3-2019

    I4, D2,C4

    Final Exam May 7th at 8:00 a.m.