|
NORTH CENTRAL TEXAS COLLEGE
COURSE SYLLABUS
|
|
|
Course Title:
|
SPREADSHEETS
|
|
Course Prefix & Number:
|
POFI 1349
|
Section Number: 0380
|
|
Semester/Year:
|
SP20
|
|
Semester Credit Hours:
|
3
|
Lecture Hours:
|
32
|
Lab Hours:
|
32
|
|
Course Description (NCTC Catalog): Skill development in concepts, procedures, and application of spreadsheets.
|
|
Course Prerequisite(s): NONE
|
|
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.
MOS Voucher - 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.
|
INSTRUCTOR INFORMATION
OFFICE HOURS
|
Monday
|
Tuesday
|
Wednesday
|
Thursday
|
Friday
|
|
6:30pm - 8:30pm
|
|
|
|
|
|
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:
|
|
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
|
Pre-Test, Chapter Assignment, Post-Test
|
80% or better
|
|
1
|
Course Competency Assignments
|
80% or better
|
|
1
|
MOS Certification Final
|
80% or better
|
| |
|
|
COURSE SUBJECT OUTLINE (Major Assignments, Due Dates, and Grading Criteria)
|
Creating and Editing Workbooks
|
Students will Create, save, and open an 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, cell 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
|
March 12, 2020
|
|
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, Use formula auditing tools in a worksheet, 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
|
March 12, 2020
|
|
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 effects, Use pictures, shapes, and WordArt in a chart, Build pie charts and combination charts, Create sunburst and waterfall charts, and Insert and format sparklines in a worksheet
|
March 12, 2020
|
|
Formatting, Organizing, and Getting 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 or more columns or by attribute, Filter data by using AutoFilters and by 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
|
March 12, 2020
|
|
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
|
March 12, 2020
|
|
Exploring the Function Library
|
Students will Use database functions such as DSUM and DAVERAGE, Build AND, OR, nested, and IFS functions, Explore the Lookup & Reference 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 such as 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
|
March 12, 2020
|
|
Working with Templates and Sharing Work
|
Students will Set data validation, input messages, and error alerts, Create and use a form with form controls and ActiveX controls, Create a workbook from a template and save a new template, Mark a workbook as final and encrypt a workbook with a password, Share a workbook, set change tracking options, and compare and merge workbooks, and Inspect a workbook, check compatibility, and define a trusted location
|
March 12, 2020
|
|
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 variables, 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
|
March 12, 2020
|
|
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, Create a macros-only workbook
|
March 12, 2020
|
|
Customizing Excel and Using OneDrive and Office Online
|
Students will Customize Excel 2016 options, the Ribbon, and the Quick Access toolbar to personalize your working environment, View and modify Office account settings and install an Office add-in, Create a folder, add a file, move and copy a file in OneDrive, Share OneDrive files and folders, Open, create, and edit an Excel workbook in Office Online, Explore Office Online applications and productivity tools
|
March 12, 2020
|
|
FINAL MOS CERTIFICATION EXAM
|
March 12, 2020
|
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)
Last day to withdraw from a course with a “W” is February 21, 2020.
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
□ Academic General Education Course (from ACGM but not in NCTC Core)
□ Academic NCTC Core Curriculum Course
X 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:
-
Academic Reprimand – A verbal or written notice warning to the student that academic misconduct has occurred.
-
Assigning a failing grade (no credit) on the specific assignments, projects, papers, programs, labs, or examinations.
Grade Appeals and Incomplete Grades: Students can read more about the college's grade appeal processes and procedures for assigning incomplete grades by visiting the Academic Catalog: https://www.nctc.edu/catalog/academic-policies/grades-reports/student-grade-appeal.html (Links to an external site.) and https://www.nctc.edu/catalog/academic-policies/grades-reports/incomplete-grades.html (Links to an external site.).
The capstone for the BOT Certificate is the POFT 1220 – Job Search Skills.
The capstone requirement for the Business Office Technology AAS Degree is POFT 2380 – Cooperative Education It should be taken the last semester before graduation. This course may not be substituted.
QUESTIONS, CONCERNS, or COMPLAINTS
|
Name of Chair/Coordinator:
|
Dr. Cherly Furdge, Division Chair
|
|
Office Location:
|
Corinth Campus, Suite 239 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
|