Course Description: 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 prerequisites: High School Algebra, Geometry or Business Mathematics
Required course materials (the materials listed below are not optional for this course and are essential to completing assignments):
- eTextbook with SIMnet Access Card – student already has textbook and access card, purchased when enrolled in course
- MOS voucher for Final Exam
-
- Final Exam is mandatory
- Final Exam is taken the last week of the semester (student must have Dean approval to take exam early)
- Purchase voucher through Certiport
- Final exam taken at an authorized Certiport testing facility
- NCTC Corinth Campus has an authorized facility
- Student may purchase any time before end of semester; directions will be posted in an announcement and Get Started! and Final Exam module on how to purchase
- Working computer (should support MS Office software, including MS Access)
- Internet access
- MS Office Professional 365/2021 software which includes MS Access (required):
-
- NCTC provides a student version of MS Office which includes MS Access
- MS Access will not work on a Mac OS
- Students will need to download software onto computer
- Do not use the online version of MS Office
- Keyboarding skills (if you lack keyboarding skills, you can learn this skill quickly using a free online software such as: https://www.typingclub.com/)
Name of instructor: Linda Janoe
Office location: Corinth Campus, Room 331B
Telephone number: 940-498-6427
Email address: ljanoe@nctc.edu (Students need to use Canvas to contact instructor)
Office hours for students: Office hours for students: Monday and Wednesday 10:00 to 11:00 room 331B, Wednesday 1:00 – 3:00 room 331B; online office hours Tuesday 10:00-2:00 and Thursday 10:00-12:00
SYLLABUS CHANGE DISCLAIMER
The faculty member reserves the right to make changes to this published syllabus if it is in the best interest of the educational development of this class. Any such changes will be announced as soon as possible in person and/or writing.
SUMMARY OF COURSE ASSIGNMENTS
This course is assignment heavy and hands-on with over 60 assignments. The Chapter Lessons and Projects are how students learn the skills and the practicum exams test the skills learned.
List of graded assignments: Points Due Date
Essential Skills for Microsoft Office 14 9/2/2024
Word - Chapter 1 - Getting Started with Word 16 9/2/2024
Word - Chapter 2 - Formatting Text and Paragraphs 21 9/2/2024
Word - Chapter 3 - Formatting Documents 21 9/2/2024
Word - Chapter 4 - Working with Pictures, Tables, and Charts 23 9/9/2024
Word - Chapter 5 - Working with Reports and Collaborating… 21 9/9/2024
Word Addendum A Mailings 7 9/9/2024
Discussion Forum #1 (DF #1) Extra Credit 0 9/9/2024
Course Syllabus Quiz 10 9/9/2024
Word 2021 Skills Approach - Ch 4 Skill Review 4.2 28 9/12/2024
Word 365/2021 Capstone – Level 2 Writing a Research Paper 39 9/12/2024
Essential Skills 2021 Exam 23 9/16/2024
Word Ch 1 2021 Exam 30 9/16/2024
Word Ch 2 2021 Exam 30 9/16/2024
Word Ch 3 2021 Exam 26 9/16/2024
Word Ch 4 2021 Exam 30 9/16/2024
Word Ch 5 2021 Exam 30 9/16/2024
Word Mailings Exam 9 9/16/2024
Excel - Chapter 1 - Getting Started with Excel 20 9/23/2024
Excel - Chapter 2 - Formatting Cells 22 9/23/2024
Excel - Chapter 3 - Using Formulas and Functions 22 9/23/2024
Excel - Chapter 4 - Formatting Worksheets and Managing the… 22 9/30/2024
Excel - Chapter 5 - Adding Charts and Analyzing Data 25 9/30/2024
Discussion Forum #2 (DF #2) 20 10/3/2024
Quiz 1 50 10/3/2024
Excel 2021 Skills Approach - Ch 3 Challenge Yourself 3.3 37 10/3/2024
Excel 2021 Skills Approach - Ch 5 Skill Review 5.2 29 10/3/2024
Excel Ch 1 2021 Exam 30 10/7/2024
Excel Ch 2 2021 Exam 30 10/7/2024
Excel Ch 3 2021 Exam 30 10/7/2024
Excel Ch 4 2021 Exam 30 10/7/2024
Excel Ch 5 2021 Exam 30 10/7/2024
Excel – Chapter 8 - Exploring Advanced Data Analysis 25 10/14/2024
Excel - Chapter 10 - Working with Macros 10 10/14/2024
Excel 2021 Skills Approach - Ch 8 Challenge Yourself 8.4 27 10/17/2024
Excel 2021 Skills Approach - Ch 10 Skill Review 10.2 14 10/17/2024
Excel Ch 8 2021 30 10/21/2024
Excel Ch 10 2021 19 10/21/2024
Access - Chapter 1 - Getting Started with Access 20 10/28/2024
Access - Chapter 2 - Working with Tables 19 10/28/2024
Access - Chapter 3 – Using Queries and Organizing Information 23 10/28/2024
Access - Chapter 4 – Working with Forms and Reports 22 11/4/2024
Discussion Forum #3 (DF# 3) 20 11/4/2024
Quiz 2 50 11/4/2024
Access 2021 Skills Approach - Ch 2 Challenge Yourself 2.3 24 11/7/2024
Access 2021 Skills Approach – Ch 2 Fix It 2.6 15 11/7/2024
Access 2021 Skills Approach - Ch 3 Skill Review 3.2 26 11/7/2024
Office 2021 Integrated Applications – Project 2 Word, Access,… 41 11/7/2024
Access Ch 1 2021 Exam 30 11/11/2024
Access Ch 2 2021 Exam 29 11/11/2024
Access Ch 3 2021 Exam 30 11/11/2024
Access Ch 4 2021 Exam 25 11/11/2024
PowerPoint - Chapter 1 - Getting Started with PowerPoint 19 11/18/2024
PowerPoint - Chapter 2 - Adding Content to Slides 23 11/18/2024
PowerPoint - Chapter 3 - Formatting Presentations 21 11/25/2024
PowerPoint - Chapter 4 - Managing and Delivering Presentations 20 11/25/2024
Emerging Technology Topic (post topic to discussion forum) 0 11/26/2024
Quiz 3 100 12/2/2024
Discussion Forum #4 (DF #4) 20 12/2/2024
Final Project – Emerging Technology 100 12/2/2024
PowerPoint 2021 Skills Approach – Ch 3 Challenge Yourself 3.4 18 12/5/2024
PowerPoint Ch 1 2021 Exam 32 12/9/2024
PowerPoint Ch 2 2021 Exam 30 12/9/2024
PowerPoint Ch 3 2021 Exam 29 12/9/2024
PowerPoint Ch 4 2021 Exam 30 12/9/2024
Final Exam 100 12/9-12/12
Final grade scale:
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 a total grade. Review Get Started! module for weighted percentages.
Grading scale has already allowed for rounding up. No more rounding up will be allowed.
Late work policy:
Unexcused absences
- No late work accepted! No excuses!
- No make-up or redo assignments
Students waiting to complete assignments at the last minute, do not receive “grace” because of computer glitches (this includes thunderstorms, tornadoes, loss of electricity), software issues, and/or connectivity issues, unless there are campus-wide difficulties.
Approved absences
Students will be allowed to make up missed assignments with instructor approval once proper documentation is provided. It is the student responsibility to provide proper documentation of any emergency. Scheduled vacations are not approved absences.
SEE CANVAS FOR THE COMPLETE COURSE CALENDAR, OUTLINE, DETAILED DESCRIPTION OF GRADED WORK, AND OTHER RELATED MATERIAL.
COURSE POLICIES
Academic Integrity Policy:
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 (5 or more words) a project (Turnitin will flag plagiarism, student must correct before date provided by instructor)
- 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.
Will receive any or all the listed consequences below:
- An “F” for the course
- Scholastic Dishonesty report
- Zero on assignment
Artificial Intelligence Policy:
Students found utilizing AI/Natural Language Programs (NLPs)/Large Language Models (LLMs) such as ChatGPT or any other AI composition software (Turnitin does detect AI programs and violation of this policy will be considered an academic dishonesty/integrity issue) will receive any or all the listed consequences below:
- An “F” for the course
- Scholastic Dishonesty report
- Zero on assignment
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 proper 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.
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)
NCTC drops students who have not attended class before the “Official Date of Record” when rolls are certified. Students in face-to-face, hybrid, synchronous or asynchronous online must attend class or complete assignments outside of class each week to count toward attendance. Logging into Canvas does not constitute class attendance.
Chapter lesson assignments and exams are used to determine regular attendance for online students. Students absent (excused or unexcused) for 5 of 16 week, 4 of 10 week, or 3 of 8 week semester may receive an “F” for the course. The instructor may drop the student before the last day to withdraw from the course with a “W” due to excessive absences or missed assignments.
Withdrawal Policy: A student may withdraw from a course on or after the official date of record. It is the student’s responsibility to initiate and complete a Withdrawal Request Form.
Labor Day Holiday College Closed – September 2, 2024
Last day to withdraw from the course with a “W” is: November 4, 2024
Thanksgiving Holiday College Closed – November 27 through December 1
Student Learning Outcomes:
At the successful completion of this course the student will be able to:
- Describe the fundamentals of information technology concepts – hardware, software, security, and privacy.
- Demonstrate proper file management techniques to manipulate electronic files and folders in local, network, and online environments.
- Create business documents with word processing software using spelling and grammar check, format and layout, tables, citations, graphics, and mail merge.
- 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.
- Create business multimedia presentations with presentation software using templates, lists, groups, themes, colors, clip art, pictures, tables, transitions, animation, video, charts, and views.
- Create databases and manage data with database software using tables, fields, relationships, indexes, keys, views, queries, forms, reports, and import/export functions.
- Integrate business software applications.
- Use web-based technologies to conduct ethical business research.
- Use “goal seeking” and “what-if analysis” to solve problems and make adjustments/recommendations in a business environment.
Core Objectives:
COLLEGE POLICIES