BCIS 1305 0340 - BUSINESS COMPUTER APPLICATIONS

Introduction

Syllabus

NORTH CENTRAL TEXAS COLLEGE

COURSE SYLLABUS

 

Course Title: 

Business Computer Applications

Course Prefix & Number:  

BCIS1305

Section Number:  

 0340

Semester/Year: 

FA 2019

Semester Credit Hours: 

3

Lecture Hours: 

2

Lab Hours: 

2

Course Description (NCTC Catalog): 

Introduces and develops foundational skills in applying essential and emerging business productivity information technology tools. The focus of this course is on business productivity software applications, including word processing, spreadsheets, databases, presentation

graphics, data analytics, and business-oriented utilization of the internet.  32 lecture hours + 32 laboratory hours. 

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

Required Course Materials:

  1. SIMnet Access Card w/eText:  Cheri Manning, Catherine Manning Swinson; “Microsoft Office - A Skills Approach 2019” SIMnet access card
    • Access Card should be purchased through IncludEd at time of enrollment
    • Access Card includes eText 
  2. MOS Voucher for Final Exam
    • Purchased by student before end of semester
    • Cost based on where purchased ($75.00 to $130.00)
    • Must purchase at least two days before Final Exam
    • Reminder announcement will be posted the week before the Final Exam
  3. Internet Access   
  4. MS Office 2016 software which includes MS Access (Professional version only)
    • MS Access software needed for one assignment
    • Students need to plan ahead to locate a computer with MS Access to complete the Access Challenge project
    • Verify software is on personal computer
      • If not, check with local library
      • If not, check if a family member has is on their computer
      • If not, ask a friend
      • An internet connection is needed as well
    • Best option is the school computers (all NCTC computers have MS Access)
    • Do not wait until the weekend the assignment is due!
    • MS Access software is not available on MAC computers
    • MS Access is not included in the Student Version of MS Office

Recommended Course Materials:

  1. Flash drive:  Strongly recommended students do not use the college server to store your documents
  2. Notebook and pen:  Notetaking
             

 

INSTRUCTOR INFORMATION

Name of Instructor:

 

Manuel Trevino  Jr

 

Campus/Office Location:

Corinth Campus – IT Career Connection Center, room 102                                          (Online office Hours are available by appointment)

Telephone Number:

940-498-6440 x6516

E-mail Address:

mtrevino@nctc.edu

 

OFFICE HOURS Room 331B: 

Monday

Tuesday

Wednesday

Thursday

Friday

9:00 - 3:00

9:00 - 3:00

9:00 - 3:00

9:00 - 3:00

 

Students should call or email for an appointment to meet.

 

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 concepts – hardware, software, security, and privacy.

2

Demonstrate proper file management techniques to manipulate electronic files and folders in local, network, and online environments.

3

Create business documents with word processing software using spelling and grammar check, format and layout, tables, citations, graphics, and mail merge.

4

Create business documents and analyze data with spreadsheet software using (1) tables, sorting, filtering, charts and graphics, pivot tables, macros; (2) statistical, financial, logical and look-up functions and formulas; and (3) add-ins.

5

Create business multimedia presentations with presentation software using templates, lists, groups, themes, colors, clip art, pictures, tables, transitions, animation, video, charts, and views.

6

Create databases and manage data with database software using tables, fields, relationships, indexes, keys, views, queries, forms, reports, and import/export functions.

7

Integrate business software applications.

8

Use web-based technologies to conduct ethical business research.

9

Use “goal seeking” and “what-if analysis” to solve problems and make adjustments/recommendations in a business environment.

 

GRADING CRITERIA

# of Graded

Course Elements

Graded Course Elements

Percentage or Point Values

3

Discussion Forums

10%

1

Final Project

10%

22

*Practicum Exams (24 exams)

40%

7

Projects

20%

3

Exams (pop quizzes not included in total)

10%

1

Final Exam – MOS Certification Exam

10%

Final%

A = > 89.5

B = 79.5 – 89.49

C = 69.5 – 79.49

D = 59.5 – 69.59

F = < 59.49

Grading is weighted per assignment type and is point driven. The maximum number of points may vary semester to semester.  Your total

earned points per graded course element will be divided by the maximum number of points graded course element. The calculation from each element will be multiplied by assigned weighted percentage and then added together for total grade.   

  • Grading policy may be amended during the semester at the instructor’s discretion
  • Announcements/information disseminated during class will take precedence over the syllabus
  • No picture taking, video recording, or audio recording unless accommodations are provided by OSD or with instructor permission  
  • Assignment grade appeals should be made within 48 hours after the assignment is graded
  • Overall grade appeals should be made within 48 hours after the enrolled term ends
  • Two lowest Practicum Exam grades are dropped
  • *Chapter Lessons (24) are used for extra credit and added to the Practicum Exam grade
  • Pop quizzes are a possibility and will be added to the weighted exam grade and can significantly improve a student’s overall exam grade 

µ Online students - may have an opportunity (instructor initiated and discretion) at the end of the semester to make‐up one assignment, A Practicum Exam or Project to improve their grade. Opportunity for make‐up will be provided for online students only.  Announcement will be posted after the drop date with details of how to request a make-up/redo assignment.

 ACADEMIC DISHONESTY AND INTEGRITY VIOLATIONS

Students found: 

  • Sharing project files (SIMnet has embedded information within downloaded file which will flag student sharing and student receiving file for Integrity Violation.  If you are the individual sharing a file, it is considered collusion which is considered Academic Dishonesty.)
  • Plagiarizing a project (VeriCite will flag plagiarism, student must correct before submitting final copy and before the final copy due date)
  • Cheating on exams or cheating on practicum exams (exams are closed book as well all browsers and other devices)
  • Taking exam outside of classroom without instructor permission (this does not pertain to online students since they take their exams outside the classroom) will potentially receive an “F” for the course and a report turned in the Dean for Scholastic Dishonesty.

 

Consequences for academic dishonesty may include:

  1. An “F” for the course 
  2. Scholastic Dishonesty report
  3. Zero on assignment 

 

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

Assignment

Points

Discussion Forum #1 (DF #1)

20

Word 2016 Skills Approach - Ch 5 Challenge Yourself 5.3

13

Word 2016 Capstone – Level 2 Writing a Research Paper

40

Essential Skills

36

Word Ch 1 2016

29

Word Ch 2 2016

27

Word Ch 3 2016

25

Word Ch 4 2016

36

Word Ch 5 2016

27

Discussion Forum #2 (DF #2)

20

Excel Ch 1 2016

42

Excel Ch 2 2016

44

Excel Ch 3 2016

32

Excel Ch 4 2016

34

Excel Ch 5 2016

45

Excel 2016 Skills Approach - Ch 6 Challenge Yourself 6.4

9

Excel 2016 Skills Approach - Ch 8 Challenge Yourself 8.4

27

Excel 2016 Skills Approach - Ch 10 Skill Review 10.2

14

Excel Ch 6 2016

38

Excel Ch 7 2016

52

Excel Ch 8 2016

36

Excel Ch 10 2016

19

Access 2016 Skills Approach - Ch 5 Challenge Yourself 5.4

25

Office 2016 Integrated Applications – Project 2 Word, Access, Excel

42

Access Ch 1 2016

39

Access Ch 2 2016

25

Access Ch 3 2016

34

Access Ch 4 2016

31

Access Ch 5 2016

30

Discussion Forum #3 (DF #3)

20

Final Project – Emerging Technology

100

PowerPoint Ch 1 2016

31

PowerPoint Ch 2 2016

32

PowerPoint Ch 3 2016

26

PowerPoint Ch 4 2016

30

MOS Certification Exam (taken at a CertiPort Testing Center)

100

 

Many assignments are due at the same time and are open a reasonable range of time.  Do not wait until the last minute to start assignments or they will become overwhelming. 

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

 

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)

Absences

Students absent (excused or unexcused) for TEN classes may receive an “F” for the course or be dropped from the course for classes that meet twice a week for a full semester. 

Students absent (excused or unexcused) for FIVE classes may receive an “F” for the course or be dropped from the course for classes that meet once a week for a full semester or twice a week for an 8-week semester. 

Online Students:  Chapter Lesson assignments and Exams will be used to determine regular attendance for online students and will apply for absences and the student may receive an “F” for the course or be dropped from the course for FIVE classes.  

 

IMPORTANT DATES

 

Labor Day - College closed September 2nd

Last day to withdraw from a course with a “W” is November 1st

Thanksgiving Holiday - College closed November 27th - 30th

Final Exams – December 9th - 12th

Term Ends December 14th

 

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

Creative Arts

American History

Government/Political Science

☐

☐

☐  

☐

Life and Physical Science

Language, Philosophy & Culture

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

☒          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:

  1. An “F” for the course
  2. Scholastic Dishonesty report
  3. Zero on assignment

 

QUESTIONS, CONCERNS, or COMPLAINTS

Name of Chair/Coordinator: 

Susan Svane

Office Location:

Corinth, Room 233

Telephone Number:

940-498-6292

E-mail Address:

ssvane@nctc.edu

Name of Instructional Dean: 

Debbie Huffman

Office Location:

Gainesville

Telephone Number:

940-668-3357

E-mail Address:

dhuffman@nctc.edu  

 

Syllabus File(s)

There are no Handouts for this set.