NORTH CENTRAL TEXAS COLLEGE

COURSE SYLLABUS

 

Course Title:

Business Computer Applications

Course Prefix & Number: 

BCIS1305

Section Number: 

340

Semester/Year:

2017 FA

Semester Credit Hours:

3

Lecture Hours:

2

Lab Hours:

2

Course Description (NCTC Catalog):

Computer terminology, hardware, software, operating systems, and information systems relating to the business environment. The main focus of this course is on business applications of software, including word processing, spreadsheets, databases, presentation graphics, and business-oriented utilization of the Internet. 32 lecture hours + 32 laboratory hours. 

Course Prerequisite(s): High School Algebra, Geometry or Business Mathematics

Required or Recommended Course Materials:

Book, SIMnet access card, & MOS Voucher:  Cheri Manning, Catherine Manning Swinson; “Microsoft Office – A Skills Approach 2016” with SIMnet account and MOS Voucher; ISBN:   9781260266221 (Should be bundled together in bookstore).

Flash drive:  It is strongly recommended that students do not use the college server to store documents.

Notebook and pen:  Notetaking in class

Internet Access, working computer, MS Office software including MS Access:  You must have access to the internet and a working computer with MS Office (includes MS Access).  MS Access software is not available on MAC computers; it is the student responsibility to find a computer with MS Access to complete the Access project.

 

No picture taking, video recording or audio recording unless accommodations are provided by OSD or with instructor permission. 

             

 

INSTRUCTOR INFORMATION

Name of Instructor:

Linda Janoe

Campus/Office Location:

Corinth Campus – Room 313

Telephone Number:

940-498-6427

E-mail Address:

ljanoe@nctc.edu

 

OFFICE HOURS

Monday

Tuesday

Wednesday

Thursday

Friday

10:00-12:00

3:30-5:00

10:00-2:30

3:00-5:00 online

 

online

 

2:30-4:30 online

 

 

 

 

 

STUDENT LEARNING OUTCOMES (From Academic Course Guide Manual/Workforce Education Course Manual/NCTC Catalog

At the successful completion of this course the student will be able to:

1

Describe the fundamentals of Information Technology (IT) infrastructure components: hardware, software, and data communications systems.

2

Explain the guiding principles of professional behavior in computing.

3

Demonstrate proper file management techniques to manipulate electronic files and folders in a local and networked environment.

4

Use business productivity software to manipulate data and find solutions to business problems.

5

Explain the concepts and terminology used in the operation of application systems in a business environment.

6

Identify emerging technologies for use in business applications.

7

Complete projects that integrate business software applications. 

 

GRADING CRITERIA

# of Graded Course Elements

Graded Course Elements

Percentage or Point Values

20

Chapter Lessons

20%

5

Discussion Forums

10%

17

Practicum Exams (18 exams)

25%

4

Projects

20%

4

Exams

20%

1

Final Exam – MOS Certification Exams

5%

·         The grading policy may be amended during the semester at the instructor’s discretion.

·         Any announcements/information disseminated during class will take precedence over the syllabus.

·         Lowest Practicum Exam grade dropped

·         Students found sharing project files, plagiarizing a project, cheating on exams, or cheating on practicum exams in this course may receive an “F” for the course along with a report turned into the Dean for Scholastic Dishonesty.

·         Online students may have an opportunity (instructor discretion) at the end of the semester to make-up one assignment, a Chapter Lesson, Practicum Exam, or Project to improve their grade.  Opportunity for make-up will be provided for online students only.

 

COURSE SUBJECT OUTLINE (Major Assignments, Due Dates, and Grading Criteria)

Assignment

Points

Due Date

Overview - Chapter 1 - Essential Skills for Office 2016

18

9/3/2017

File Management Basics

12

9/3/2017

Word - Chapter 1 - Getting Started with Word 2016

15

9/3/2017

Word - Chapter 2 - Formatting Text and Paragraphs

20

9/10/2017

Word - Chapter 3 - Formatting Documents

20

9/10/2017

Word - Chapter 4 - Working with Pictures, Tables, and Charts

21

9/17/2017

Word - Chapter 5 - Working with Reports, References, and Mailings

21

9/17/2017

Discussion Forum #1  (DF1)

20

9/17/2017

Discussion Forum #2  (DF2)

20

9/17/2017

Word 2016 Skills Approach - Ch 5 Challenge Yourself 5.3

13

9/17/2017

Word Ch 1 2016

25

9/21/2017

Word Ch 2 2016

30

9/21/2017

Word Ch 3 2016

24

9/21/2017

Word Ch 4 2016

31

9/21/2017

Word Ch 5 2016

30

9/21/2017

Word 2016

100

9/24/2017

Excel - Chapter 1 - Getting Started with Excel 2016

18

10/1/2017

Excel - Chapter 2 - Formatting Cells

22

10/1/2017

Excel - Chapter 3 - Using Formulas and Functions

20

10/8/2017

Excel - Chapter 4 - Formatting Worksheets and Managing the Workbook

21

10/8/2017

Excel - Chapter 5 - Adding Charts and Analyzing Data

23

10/15/2017

Discussion Forum #3  (DF3)

20

10/15/2017

Excel 2016 Skills Approach - Ch 6 Challenge Yourself 6.4

9

10/15/2017

Excel Ch 1 2016

41

10/19/2017

Excel Ch 2 2016

48

10/19/2017

Excel Ch 3 2016

32

10/19/2017

Excel Ch 4 2016

32

10/19/2017

Excel Ch 5 2016

42

10/19/2017

Excel 2016

100

10/22/2017

Access - Chapter 1 - Getting Started with Access 2016

20

10/29/2017

Access - Chapter 2 - Working with Tables

19

10/29/2017

Access - Chapter 3 - Working with Forms and Reports

22

11/5/2017

Access - Chapter 4 - Using Queries and Organizing Information

21

11/12/2017

Discussion Forum #4  (DF4)

20

11/12/2017

Access 2016 Skills Approach - Ch 5 Challenge Yourself 5.4

25

11/12/2017

Access Ch 1 2016

36

11/16/2017

Access Ch 2 2016

24

11/16/2017

Access Ch 3 2016

31

11/16/2017

Access Ch 4 2016

29

11/16/2017

Access 2016

100

11/19/2017

PowerPoint - Chapter 1 - Getting Started with PowerPoint 2016

19

11/26/2017

PowerPoint - Chapter 2 - Adding Content to Slides

20

11/26/2017

PowerPoint - Chapter 3 - Formatting Presentations

19

12/3/2017

PowerPoint - Chapter 4 - Managing and Delivering Presentations

20

12/3/2017

Discussion Forum #5  (DF5)

20

12/3/2017

Final Project – PowerPoint Drop Box

100

12/3/2017

PowerPoint Ch 1 2016

30

12/7/2017

PowerPoint Ch 2 2016

21

12/7/2017

PowerPoint Ch 3 2016

32

12/7/2017

PowerPoint Ch 4 2016

32

12/7/2017

PowerPoint 2016

100

12/10/2017

MOS Certification

100

12/13/2017

 

All due dates are subject to change.  It is the student’s responsibility to know when assignments open and are due.

 

GENERAL CLASSROOM CONDUCT AND COURSE INFORMATION

Students will observe appropriate online communication etiquette when addressing fellow classmates as well as your instructor.  It is the student’s responsibility to familiarize himself or herself with the Canvas, the student learning management system, as well as the student online skill assessment, SIMnet (McGraw-Hill).

Questions are welcome!  Please avoid emailing instructor about general course information, schedule, or syllabus.  If the student question is not covered in Canvas, then email instructor.  Questions should be specific and not generalized, such as:  “I am confused about the assignment.”  Please allow up to 24 hours for instructor to answer an email Monday thru Thursday and 48 hours, Friday thru Sunday. 

When having difficulty with software or your computer, keep in mind the instructor cannot fix your computer or the software utilized.  When having difficulty, email instructor with the specific issue, send a screen-shot, and the helpdesk reference number, before the assignment due date.  If the problem is on the instructor side, then the instructor should resolve the issue within 24 hours and will provide extra time if there is instructor error.  Students waiting to complete assignments at the last minute, do not receive “grace” because of computer glitches, software issues, and/or connectivity issues, unless there are campus-wide difficulties.

College education is intended to broaden the student’s knowledge base.  Any and all material read, discussed, heard, or observed is subject to being referenced on an examination.  Do not expect the body of knowledge to be narrowed by “reviews” from which test questions will be selected.  All Exams are closed book.

Face-to-face/Hybrid classes:  No cell phones out when instructor is lecturing.  Student may be dismissed from class and/or be counted as absent for the day.

 

The expectation is that you, as college students, will learn to modify the behavior of your peers through the channels available in your contextual universe.  If the instructor is forced to manage your behavior such will be accomplished via the following procedure:

  1. You will be warned by the instructor that your behavior is not acceptable.
  2. You will be told to leave class and not return until:
    You have met with the Dean of Students (Rodney Lipscomb)
    b. You have signed a letter of probation
    c. The Dean of Students notifies the instructor that you have done ‘a’ and ‘b’, and that you may return to class.
  3. A third event will result in your probation becoming suspension and you will be removed from the class permanently.

 

ATTENDANCE POLICY

Regular and punctual attendance is expected of all students in all classes for which they have registered.  All absences are considered to be unauthorized unless the student is absent due to illness or emergencies as determined by the instructor.  It is the student responsibility to provide documentation as to the emergency for approval and judgement by the faculty member.  Approved college sponsored activities are the only absences for which a student should not be held liable and only when provided by a college official ahead of the absence.  Valid reasons for absence, however, do not relieve the student of the responsibility for making up required work.  Students will not be allowed to make up an examination missed due to absence unless they have reasons acceptable to the instructor.  A student who is compelled to be absent when a test is given should petition the instructor, in advance if possible, for permission to postpone the exam.  Student will be dropped from a class by the Registrar upon recommendation of the instructor who feels the student has been justifiably absent or tardy a sufficient number of times to preclude meeting the course’s objectives.    Persistent, unjustified absences from classes or laboratories will be considered sufficient cause for College officials to drop a student from the rolls of the College. From Board Policy FC (LOCAL)

Students absent for TEN classes may receive an “F” for the course or be dropped from the course for classes that meet twice a week.  Students absent for FIVE classes may receive an “F” for the course or be dropped from the course for classes that meet once a week.  Chapter Lesson assignments and Exams will be used to determine regular attendance for online students and the FIVE classes missed apply for absences.  

 

A student that is compelled to be absent when a test is given, will petition the instructor, in advance, for permission to take the exam at a different time.   Required work not completed by due dates will not be allowed after due date.  Students will receive a zero for any and all late assignments. 

 

There are no make-up exams, make-up assignments, and/or make-up exercises of any kind, for any reason.

 

 

Last day to withdraw from a course with a “W” is _November 9th__.

 

GENERAL DESCRIPTION

 

Calendar begins August 28th

This course is divided into six modules.  The first two modules will be combined for the first 4 weeks.  Each module is open for approximately 3-4 weeks and contains multiple Chapter Lessons, a project, and at least one Discussion Forum.  Practicum Exams and a 100 question Exam will close out the last week of each module. 

Final Module – The Final Exam – MOS Certification will be the last module and will be the last week of the semester.  Practice exams will be made available for students to prepare for the MOS Certification.

Modules 1 & 2 – Office 2016 & Word 2016 (4 weeks):  An introduction to Office 2016, discussing the essential skills needed to open, close, and organize files onto different types of drives will be practiced.  Word 2016 will be introduced and practical application will be applied to format text, paragraphs, and printed documents.  Other skills learned will include working with images, tables, charts, reports, references, and mailings.  The unit will close with a Practicum and Written exam covering all Word 2016 chapters.

Module 3 – Excel 2016 (4 weeks):  An introduction to Excel 2016 and the purpose of using spreadsheets will be discussed.  Students will learn how to format cells, use formulas and functions, format worksheets, apply themes, add charts, and analyze data.  The unit will close with a Practicum and Written exam covering all Excel 2016 chapters.

Module 4 – Access 2016 (4 weeks):  Students will be introduced and learn the basics of Access 2016.  Students will create and design tables, forms and reports.  Queries and organizing data will culminate the Access chapters.  The unit will close with a Practicum and Written exam covering all Access 2016 chapters.

Module 5 – PowerPoint 2016 (3 weeks):  The ability to present in the classroom and the workplace is essential in today’s world.  Students will be designing and creating presentations utilizing PowerPoint 2016. The unit will close with a Practicum and Written exam covering all PowerPoint 2016 chapters.

Module 6 – Final Exam (1 week):    Final Exam will be the MOS certification for all units.  Practice exams will be provided in the Final Exam week module.  Exams will be taken on campus at the IT Career Connection Center located at Pinnell Square, 1400 N. Corinth St., Suite 101, Corinth, TX.

 

DISABILITY SERVICES (Office for Students with Disabilities)

The Office for Students with Disabilities (OSD) provides support services for students with disabilities, students enrolled in technical areas of study, and students who are classified as special populations (i.e. single parents).

Support services for students with disabilities might include appropriate and reasonable accommodations, or they may be in the form of personal counseling, academic counseling, career counseling, etc.  Furthermore, OSD Counselors work with students to encourage self-advocacy and promote empowerment. The Counselors also provides resource information, disability-related information, and adaptive technology for students who qualify.

If you feel you have needs for services that the institution provides, please reach out to either Wayne Smith (940) 498-6207 or Yvonne Sandman (940) 668-4321.  Alternative students may stop by Room 170 in Corinth or Room 110 in Gainesville.

CORE CURRICULUM FOUNDATIONAL COMPONENT AREA (For classes in the Core)________     

 

          Communication

          Mathematics              

          Life and Physical Science

          Language, Philosophy & Culture

          Creative Arts

          American History

 

          Government/Political Science

          Social and Behavioral Sciences

          Component Area Option

 


REQUIRED CORE OBJECTIVES (For classes in the Core)

 

             Critical Thinking

             Communication

             Empirical and Quantitative

 

             Teamwork

             Personal Responsibility

             Social Responsibility

 

COURSE TYPE

 X          Academic General Education Course (from ACGM but not in NCTC Core)

          Academic NCTC Core Curriculum Course

          WECM Course

 

STUDENT HANDBOOK

Students are expected to follow all rules and regulations found in the student handbook and published online.

 

ACADEMIC DISHONESTY

Scholastic dishonesty shall include, but is not limited to cheating, plagiarism, academic falsification, intellectual property dishonesty, academic dishonesty facilitation and collusion.  Faculty members may document and bring charges against a student who is engaged in or is suspected to be engaged in academic dishonesty.  See Student Handbook, “Student Rights & Responsibilities: Student Conduct ([FLB(LOCAL)]”. 

 

Consequences for academic dishonesty may include:

  • An “F” for the course
  • Scholastic Dishonesty report
  • Zero on assignment

 

QUESTIONS, CONCERNS, or COMPLAINTS

Name of Chair/Coordinator:

Judy Archer

Office Location:

Corinth, Room 233

Telephone Number:

940-498-6292

E-mail Address:

jarcher@nctc.edu

Name of Instructional Dean:

Debbie Huffman

Office Location:

Gainesville, CTC 2106

Telephone Number:

940-668-3357

E-mail Address:

dhuffman@nctc.edu

 

Other Pertinent Information

Complaint Procedures

If the complaint involves a problem with an instructor, the student shall discuss the matter with the instructor before requesting a conference with the department chair… If the complaint involves a grade received, the student shall collect all tests, papers, daily assignments, class notes and other relevant material prior to the conference with the instructor in question.  (See Student Handbook > Discussion of Complaint)

ADA Statement

North Central Texas College is committed to providing equal access to educational opportunities to its students with disabilities by providing assistance through “reasonable accommodations”; and a variety of services and resources through the Special Populations Office. The College does not discriminate on the basis of disabilities in admission or access to its programs. Students are responsible for notifying the office of their need for assistance at least two weeks prior to the beginning of a semester. Students with documented disabilities such as mobility, hearing or visual impairments, learning, and/or psychological disorders are eligible for services. The Special Populations Office on the Gainesville Campus is located in the Counseling/Testing Center room ASC 108 (next door to the bookstore). For assistance, call 940/668-4216 ext. 344. 

Civil Rights

In compliance with Title VI of the Civil Rights Act of 1964 (P.L.88-352), Title IX of the Education Amendments of 1972 (P.L. 92-318). and the Age Discrimination Act of 1978 (P.L. 92-256), North Central Texas College does not discriminate against or exclude from participation in any of its programs or activities, either in the student body or the staff, any person on the grounds of sex, race, color, religion, age, handicap, national origin, or veteran status.

Web Page

Visit the North Central Texas College web page for information on registration, financial aid, counseling/advising, and cost of tuition and fees. You will also find information on the catalog and semester schedules as well as courses of study. You can keep up with what is happening on campus by checking the calendar of events and the sports news. The web has information on the library as well as links to other areas of interest. Check out our web page at http://www.nctc.edu .

Additional content for this course may be found in your Canvas account. Please check there for updates and news.

 

 

There are no Handouts for this set.