NORTH CENTRAL TEXAS COLLEGE
COURSE SYLLABUS
The North Central Texas College (NCTC) Course Syllabus provides the following as required by the Texas Higher Education Coordinating Board (THECB): (1) a brief description of the course including each major course requirement, assignment and examination; (2) the learning objectives for the course; (3) a general description of the subject matter of each lecture or discussion; and (4) any required or recommended readings. Contact information for the instructor is also provided. The Course Syllabus also provides institutional information to indicate how this course supports NCTC’s purpose and mission. Information specific to a particular section of the course will be included in the Class Syllabus and distributed to enrolled students.
|
Course Title: Spreadsheets
|
|
|
Course Prefix & Number: POFI1349
|
Section Number: 360
|
Term Code: 172S
|
|
|
Semester Credit Hours: 3
|
Lecture Hours: 32
|
Lab Hours: 32
|
|
|
Course Description (NCTC Catalog):
Skill development in concepts, procedures, and application of spreadsheets for business.
|
|
|
Course Prerequisite(s): None
|
|
|
Course Type:
o - Academic General Education Course (from Academic Course Guide Manual but not in NCTC Core)
o - Academic NCTC Core Curriculum Course
x - WECM Course
|
|
|
Name of Instructor:
|
Angela Sellers
|
|
Campus/Office Location:
|
Corinth Campus
|
|
Telephone Number:
|
940-498-NCTC
|
|
E-mail Address:
|
asellers@nctc.edu Course email in Canvas preferred.
|
| |
|
|
|
|
|
Name of Chair/Coordinator:
|
Dr. Cherly Furdge, Division Chair
|
|
Office Location:
|
Corinth 234
|
|
Telephone Number:
|
940-498-6238
|
|
E-mail Address:
|
cfurdge@nctc.edu (preferred)
|
REQUIRED OR RECOMMENDED COURSE MATERIALS
|
In-Practice Microsoft Excel 2016 Complete ebook and access code for SIMnet. This access card can be purchased from the NCTC bookstore or online. You will access SIMnet within Canvas for all assignments.
|
|
AND
MOS Voucher (This voucher is included in the course tuition, please contact Sarah Morrow at smorrow@nctc.edu or Mallory Batts at mbatts@nctc.edu to arrange access to this voucher that is REQUIRED to complete the final exam in this course) – This product includes one Microsoft Office Specialist Exam Voucher with a retake, which may be used for any of the MOS exam (Word, Word Expert, Excel, Excel Expert, PowerPoint, Access, Outlook, Access, OneNote, SharePoint) in versions for Office 2010, 2013 and 2016. The final will be a MOS Certification Exam that you will need to schedule with the testing center.
All POFI1349 Course materials/books can purchased at the NCTC Bookstore
|
Required Software: Microsoft® Excel 2016
GRADING POLICY:
A 90%-100%
B 80%-89%
F 0%-79%
INSTITUTIONAL LEARNING GOALS
o A quality general education curriculum in all associate degree programs.
o Quality freshman and sophomore level courses in arts and sciences which parallel the lower division offerings of four-year colleges and universities.
x Quality technical programs leading directly to careers in semi-skilled and skilled occupations, and quality technical education programs up to two years in length leading to certificates and associate degrees.
o Quality programs and services in support of adult literacy and basic skills development as a mean of workforce enhancement and expanding access to higher education.
PROGRAM PURPOSE STATEMENT
NCTC seeks to implement its goal of providing quality technical programs leading directly to careers in semi-skilled and skilled occupations, and quality technical education programs up to two years in length leading to certificates and associate degrees by offering a coherent sequence of courses with appropriate breadth and depth to prepare students for success in the workforce.
DEPARTMENTAL PURPOSE STATEMENT
The Office Systems Technology department provides quality courses in office systems technology that will prepare students for employment and advancement in today’s technology intense workplace. Through this preparation, students will have the opportunity to transfer to four year universities to continue their education in Applied Sciences.
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:
|
|
LO1
|
Identify spreadsheet terminology and concepts.
|
|
LO2
|
Calculate data using formulas and functions
|
|
LO3
|
Create and modify workbooks
|
|
LO4
|
Insert graphics
|
|
LO5
|
Generate charts and reports
|
|
LO6
|
Create and use special functions
|
GRADING CRITERIA
|
# of Graded Course Elements
|
Graded Course Elements
|
Percentage or Point Values
|
|
10
|
Chapters:
Each chapter includes:
Pre-Test
Chapter Assignments
Post-Test
|
Must score 80% or better on all assignments in order to pass this course. Please see Canvas for detailed course information and course map.
|
|
1
|
Course Competency Assignments
|
|
1
|
MOS Certification Final
|
GENERAL DESCRIPTION OF SUBJECT MATTER FOR EACH LECTURE/DISCUSSION
|
Topic
|
General Description of Subject Matter
|
|
Creating and Editing Workbooks
|
Students will create, save, and open and Excel workbook; enter and edit labels and values in a worksheet; use the SUM function to build a simple formula; format a worksheet with font attributes, borders, fill, cells styles, and themes; modify columns and rows in a worksheet; insert, delete, and move worksheets in a workbook; modify the appearance of a workbook by adjusting zoom size, changing views, and freezing panes; and review and prepare a workbook for final distribution by spell checking, setting properties, and adjusting page setup options.
|
|
Working with Formulas and Functions
|
Students will build and edit basic formulas; set mathematical order of operations in a formula; use absolute, mixed, relative, and 3D references in a formula; work with STATISTICAL and DATE & TIME functions, work with functions from the FINANCIAL, LOGICAL, and LOOKUP & REFERENCE categories, and build functions from the MATH & TRIG category.
|
|
Creating and Editing Charts
|
Students will create Excel chart objects and chart sheets; use quick layouts and chart styles to design a chart; edit chart elements including titles, data labels, and source data; format chart elements with shape styles, fill, outlines, and special effect; use pictures, shapes, and WordArt in a chart; Build pie charts and combination charts; create sunburst and waterfall charts; insert and format sparklines in a worksheet.
|
|
Formatting, Organizing, and Gathering Data
|
Students will create and format a list as an Excel table; apply CONDITIONAL FORMATTING rules as well as COLOR SCALES, ICON SETS, and DATA BARS; sort data by one of more columns or by attribute; filter data by using AUTOFILTERS and creating an ADVANCED FILTER, use subtotals, groups, and outlines for tabular data in a worksheet; import data into an Excel worksheet from a text file, a database file, and other sources; export Excel data as a text file and into a Word document, and build and format a PIVOTTABLE.
|
|
Consolidating, Linking, and Inserting Objects
|
Students will create a static data consolidation; create a dynamic data consolidation; consolidate data by category; group worksheets for editing and formatting; link workbooks to consolidate data; insert illustrations using SMARTART, screenshots, and pictures in a worksheet, insert hyperlinks in a worksheet; and safeguard work by marking it as final or by setting a password.
|
|
Exploring the Functions Library
|
Students will use DATABASE functions such as DSUM and DAVERAGE; build AND, OR, nested, and IFS functions; explore the LOOKUP & REFEERENCE category with INDEX, MATCH, AND TRANSPOSE, build date, time, and statistical calculations; use FINANCIAL functions such as PV, FV, and NPV, work with text functions including TEXTJOIN, CONCAT, EXACT, and REPLACE; use multiple criteria in SUMIFS, AVERAGEIFS, and COUNTIFS functions; and monitor and edit functions with the WATCH WINDOW and FIND AND REPLACE.
|
|
Working with Templates and Sharing Work
|
Students will use a template to create a workbook and save a workbook as a template; set data validation, input messages, and error alerts; use the FORM button and FORM CONTROLS; set worksheet and workbook protection to manage editing; share a workbook, track changes, and compare and merge workbooks; inspect a workbook for metadata; check compatibility; and define a trusted location.
|
|
Exploring Data Analysis and Business Intelligence
|
Students will create and manage scenarios for worksheet data; use GOAL SEEK to backsolve a cell value for a formula; use SOLVER to find a solution for a formula; build data tables with one and two varibales; create a forecast sheet for time-based data; get and transform data in a query; explore PIVOTTABLE tools; and use the ANALYSIS TOOLPAK to calculate statistical measures.
|
|
Recording and Editing Macros
|
Students will run a macro; record a macro; assign a macro to a BUTTON form control; edit a macro in the Visual Basic Editor (VBE); record a macro with relative references; save a macro-enabled template; and create a macros-only workbook.
|
|
FINAL MOS CERTIFICATION EXAM
|
|
Last day to Withdraw
|
For the Spring 2018 semester, the last day to withdraw from a course with a “W” is February 22, 2018. In order to drop the course, you must schedule an appointment with Sarah Morrow, Fast Start IV Grant Coordinator at 940-668-7731 ext. 4957 or schedule an appointment by emailing Sarah at smorrow@nctc.edu.
|
|
Student Rights & Responsibilities
|
NCTC Board policy FLB (Local) Student Rights and Responsibilities states that each student shall be charged with notice and knowledge of the contents and provisions of the rules and regulations concerning student conduct. These rules and regulations are published in the Student Handbook published in conjunction with the College Catalog.
|
|
Scholastic Integrity
|
Scholastic dishonesty shall constitute a violation of college rules and regulations and is punishable as prescribed by Board policies. Scholastic dishonesty shall include, but not be limited to cheating on a test, plagiarism, and collusion. See the Student Handbook for more information.
|
|
STUDENT SUPPORT SERVICES
|
|
Disability Services (OSD)
|
The Office for Students with Disabilities (OSD) provides accommodations for students who have a documented disability. On the Corinth Campus, go to room 170 or call 940-498-6207. On the Gainesville Campus, go to room 110 or call 940-668-4209. Students on the Bowie, Graham, Flower Mound, and online campuses should call 940-668-4209.
North Central Texas College is on record as being committed to both the spirit and letter of federal equal opportunity legislation, including the Americans with Disabilities Act (ADA) of 1990, ADA Amendments Act of 2009, and Section 504 of the Rehabilitation Act of 1973 (P.L. 93-112). http://www.nctc.edu/StudentServices/SupportServices/Disabilityservices.aspx
|
|
Student Success Center
|
The Student Success Center is designed to help all students at NCTC develop tools to achieve their academic goals. The center links students to FREE tutoring, including a Writing Center, a Math Lab, and free online tutoring in the evening. The program helps students acclimate to college by providing students free interactive workshops about Time Management, Study Skills, Test Anxiety, and much more. For more information, please visit your nearest Student Success Center.
|
|
Financial Aid, Scholarships, and Veterans Services
|
The Financial Aid Office is responsible for administering a variety of programs for students who need assistance in financing their education. The first step for financial aid is to complete a FAFSA. For more information, please visit your nearest Financial Aid Office.
|
|
Tobacco-Free Campus
|
NCTC restricts the use of all tobacco products including cigarettes, cigars, pipes and smokeless tobacco on campus property.
|
|
| |
|
|
|
ATTENDANCE POLICY
In lieu of classroom attendance, the following will constitute the course attendance policy: Each student is expected to log in at least three times a week and complete weekly assignments to constitute regular attendance. Failure to log in for two successive weeks will be cause for concern and will be reported to the Fast Start IV Grant Coordinator.
The last day to drop is February 22, 2018. In order to drop the course, you must schedule an appointment with Sarah Morrow, Fast Start IV Grant Coordinator at 940-668-7731 ext. 4957 or schedule an appointment by emailing Sarah at smorrow@nctc.edu.
This online course requires dedication and effort on your part. You must set aside time each week to do your assignments. You should expect to spend 10 to 12 hours each week on this course. It is very easy to fall behind and it is difficult to catch up on missed work!
Course Success Tip: Stay current in your work, log in often, and check announcements for any special notices.
OTHER PERTINENT INFORMATION
- This course begins Janaury 16, 2018 and ends March, 9 2018. This course is designed as a self-paced course. There are no weekly deadlines. However, it is highly encouraged that you log in at least four-five times a week to work on assignments.
- All course material is available via the internet through NCTC’s Canvas Learning Management System. Access Canvas at https://nctc.instructure.com/login. Please go to https://nctc.instructure.com/login and bookmark (save to favorites) this site. It is not necessary to access Canvas through the NCTC Website.
- It is the student’s responsibility to check the Canvas, SAM through Canvas, and his or her course mail at least three times weekly.
- If a student should experience problems accessing the course material in Canvas or SAM or sending/receiving course mail, it is the student’s responsibility to resolve the issue with the appropriate Help resource and notify the instructor immediately.
- Student data files may be downloaded and/or accessed from the textbook publisher’s website through Canvas.
- Expect to spend 10 to 15 hours per week working in this course. It is recommended to spread the weekly assignments out throughout the week.
- Students are required to complete all course work with a grade of 80% or higher in order to pass this course.
- Emails should be reserved for private, personal, and non-content related topics and will be answered within 48 hours.
- All students are expected to conduct themselves in a professional manner.
- Each student will be provided a Canvas email account for course communication. All e-mails to the instructor are to be sent through Canvas. Emails will be answered within 48 hours.
Workforce Education Program Elements (SCANS Skills)
The Secretary’s Commission on Achieving Necessary Skills (SCANS) conducted extensive research and interviews and determined that “workplace know-how” consists of two elements: foundations skills and workplace competencies. Upon successful completion of the courses in this program, students will have demonstrated the following competencies:
(1) Foundation Skills
(a) Basic Skills: A worker must (i) read, (ii) write, (iii) perform arithmetic and mathematical operations, (iv) listen, and (v) speak effectively.
(b) Thinking Skills: A worker must (i) think creatively, (ii) make decisions, (iii) solve problems, (iv) visualize, (v) know how to learn, and (vi) reason effectively.
(c) Personal Qualities: A worker must display (i) responsibility, (ii) self-esteem, (iii) sociability, (iv) self-management, (v) integrity, and (vi) honesty.
(2) Workplace Competencies
(a) Resources: A worker must identify, organize, plan, and allocate resources effectively. This includes (i) time, (ii) money, (iii) material and facilities, and (iv) human resources.
(b) Interpersonal Skills: A worker must work with others effectively to (i) participate as a member of a team, (ii) teach others new skills, (iii) serve clients/customers, (iv) exercise leadership, (v) negotiate, and (vi) work with diversity.
(c) Information: A worker must be able to (i) acquire and use information, (ii) organize and maintain information, (iii) interpret and communicate information and (iv) use computers to process information.
(d) Systems: A worker must understand complex interrelationships as in (i) understanding systems, (ii) monitor and correct performance, and (iii) improve and design systems.
(e) Technology: A worker must be able to work with a variety of technologies, e.g. (i) select technology, (ii) apply technology, and (iii) maintain and troubleshoot equipment.
QUESTIONS, CONCERNS, or COMPLAINTS
|
Name of Grant Coordinator:
|
Sarah Morrow
|
|
Office Location:
|
Gainesville, CTC 2109
|
|
Telephone Number:
|
940-668-7731 x 4957
|
|
E-mail Address:
|
smorrow@nctc.edu
|
|
Name of Division Chair:
|
Dr. Cherly Furdge, Division Chair
|
|
Office Location:
|
Corinth Campus, Room 234
|
|
Telephone Number:
|
940-498-6238
|
|
E-mail Address:
|
cfurdge@nctc.edu
|
|
Name of Instructional Dean:
|
Debbie Huffman
|
|
Office Location:
|
Gainesville, CTC 2106
|
|
Telephone Number:
|
940-668-3357
|
|
E-mail Address:
|
dhuffman@nctc.edu
|