BCIS 1305 0394 - BUSINESS COMPUTER APPL-HYBRID

Introduction

NORTH CENTRAL TEXAS COLLEGE COURSE SYLLABUS
Course Title:	Business Computer Applications
Course Prefix & Number:		BCIS 1305	Section Number:	394	Semester/Year:	2020 Spr
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:* 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 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 Internet Access MS Office 2019 software which includes MS Access (Professional version only) MS Access software needed for Access projects and the Integrated Project 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:* Flash drive: Strongly recommended students do not use the college server to store your documents Notebook and pen: Notetaking

INSTRUCTOR INFORMATION

Name of Instructor:		Linda Janoe
Campus/Office Location:	Corinth Campus – Room 331B
Telephone Number:	940-498-6427
E-mail Address:	ljanoe@nctc.edu

CLASSROOM HOURS

*Monday*	*Tuesday*	*Wednesday*	*Thursday*	*Friday*
BCIS 1305.400 10:00–11:50 Corinth – Room 253		BCIS 1305.400 10:00–11:50 Corinth – Room 253
			BCIS 1305.391 11:00–12:50 Corinth – Room 253
		BCIS 1305.394 2:00–3:20 pm Flower Mound – Room 216
Online sections include: BCIS1305.310, IMED1316.340

OFFICE HOURS Room 331B:

*Monday*	*Tuesday*	*Wednesday*	*Thursday*	*Friday*
12:00 – 1:00	10:00 – 1:00		10:00 – 11:00
			1:00 – 2:00
Online Office Hours
*Monday*	*Tuesday*	*Wednesday*	*Thursday*	*Friday*
	2:00 – 3:00		3:00 – 4:00	10:00 – 12:00
Students should call or email for an appointment to meet at a different time.

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*
21	Chapter Lessons (23 lessons)	10%
3	Discussion Forums (4 discussions, 1 is extra credit)	10%
21	Practicum Exams (23 exams)	35%
10	Projects	15%
3	Quizzes	10%
1	Final Project	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
Lowest Practicum Exam grade dropped Pop quizzes are a possibility and will be added to the weighted exam grade and can significantly improve a student’s overall exam grade
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: An “F” for the course Scholastic Dishonesty report Zero on assignment

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

Assignment	Points
Essential Skills for Microsoft Office	19
Word - Chapter 1 - Getting Started with Word	16
Word - Chapter 2 - Formatting Text and Paragraphs	20
Word - Chapter 3 - Formatting Documents	20
Discussion Forum #1 (DF #1) Extra Credit	0
Word - Chapter 4 - Working with Pictures, Tables, and Charts	23
Word - Chapter 5 - Working with Reports and Collaborating with Others	21
Word Addendum Mailings	7
Word 2019 Skills Approach - Ch 4 Challenge Yourself 4.2	25
Word 365/2019 Capstone – Level 2 Writing a Research Paper	39
Essential Skills	27
Word Ch 1 2019	30
Word Ch 2 2019	28
Word Ch 3 2019	25
Word Ch 4 2019	30
Word Ch 5 2019	30
Word Mailings	9
Discussion Forum #2 (DF #2)	20
Quiz 1	50
Excel - Chapter 1 - Getting Started with Excel	20
Excel - Chapter 2 - Formatting Cells	22
Excel - Chapter 3 - Using Formulas and Functions	20
Excel - Chapter 4 - Formatting Worksheets and Managing the Workbook	22
Excel - Chapter 5 - Adding Charts and Analyzing Data	22
Excel 2019 Skills Approach - Ch 3 Challenge Yourself 3.3	35
Excel 2019 Skills Approach - Ch 5 Skill Review 5.2	27
Excel Ch 1 2019	40
Excel Ch 2 2019	40
Excel Ch 3 2019	32
Excel Ch 4 2019	37
Excel Ch 5 2019	35
Excel – Chapter 8 - Exploring Advanced Data Analysis	25
Excel - Chapter 10 - Working with Macros	10
Excel 2016 Skills Approach - Ch 8 Challenge Yourself 8.4	27
Excel 2019 Skills Approach - Ch 10 Skill Review 10.2	14
Excel Ch 8 2019	30
Excel Ch 10 2019	19
Access - Chapter 1 - Getting Started with Access	20
Access - Chapter 2 - Working with Tables	19
Access - Chapter 3 - Working with Forms and Reports	22
Access - Chapter 4 - Using Queries and Organizing Information	22
Discussion Forum #3 (DF# 3)	20
Access - Chapter 5 - Exploring Advanced Tables and Queries	17
Quiz 2	50
Access 2019 Skills Approach - Ch 2 Skill Review 2.1	33
Access 2019 Skills Approach - Ch 4 Fix It 4.6	14
Office 2016 Integrated Applications – Project 2 Word, Access, Excel	42
Access Ch 1 2019	40
Access Ch 2 2019	29
Access Ch 3 2019	32
Access Ch 4 2019	25
Access Ch 5 2019	25
PowerPoint - Chapter 1 - Getting Started with PowerPoint	19
PowerPoint - Chapter 2 - Adding Content to Slides	23
Emerging Technology Topic	-
Quiz 3	50
Discussion Forum #4 (DF #4)	20
Final Project – Emerging Technology	100
PowerPoint - Chapter 3 - Formatting Presentations	21
PowerPoint - Chapter 4 - Managing and Delivering Presentations	20
PowerPoint Ch 1 2019	32
PowerPoint Ch 2 2019	30
PowerPoint Ch 3 2019	29
PowerPoint Ch 4 2019	30
MOS Certification Exam (taken at a CertiPort Testing Center)	100

Tip for success: Do not wait until the last minute to complete assignments. When you wait until the last minute, you are not allowing for technical issues, personal issues, and/or the correct amount of time to complete your work.

All due dates 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

NCTC now drops students who have not attended class before the “Official Date of Record.” This is when rolls are certified. Students in face-to-face classes, including hybrid, must attend class in order to be counted for roll certification. Completing assignments outside of class does not count toward attendance.

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 Practicum Exams will be used to determine regular attendance for online students and the FIVE classes missed will apply for absences.

IMPORTANT DATES

Martin Luther King Day - College closed January 20

Spring Break – College closed March 16-21

Last day to withdraw from a course with a “W” is April 3

Final Exams – May 11-16

Term Ends – May 16

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:

An “F” for the course
Scholastic Dishonesty report
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