Syllabus | POFI 1349 340 - SPREADSHEETS

You are required to participate in thirteen (13) discussion forums. Each discussion forum is worth 10 points. You are required to make an initial post, two response post and respond to two people who responded to your post.

The initial post is due by Wednesday at 11:59 p.m. Central Time. The initial post must consist of no less than 100-words. Your response to two classmates must be made by Sunday at 11:59 p.m. When you respond to your classmates, please do not put I agree. That is not a response. Your response must be no less than 50 words in length.

Additionally, you will respond to at least two (2) posts from other students made to your “Initial Post” by Sunday. In the event that no one has posted to your “Initial Post”, you should respond to two (2) other student’s “Reply Posts”. This must be done Sunday by 11:59 p.m.

Forums are scholarly dialogs, so while sharing what you think and not just what published authors wrote is encouraged, only stating opinion isn't acceptable. The key textbook concepts must be used when completing discussion forum posts.

Instead, thoughtfully integrate relevant Textbook concepts and theories or research you read about this week and strive to make connections between that academic content and your own observations and experiences.
Formal citations are not required in the discussion forums.
Your responses to the postings of other students should be relevant and substantive. It must contribute significantly to the discussion.
Reply posts containing just a few sentences or statements of agreement or disagreement only or that stray away from the topic, congratulating classmates for a “good job”, or repeat what another classmate has already said in his or her posts does not demonstrate substantive discussion.
A ZERO will be given if all of your post are made on Sunday.

Weekly Discussion Forum Rubric:

	Excellent	Satisfactory	Needs Improvement	Unsatisfactory	Points Awarded
Initial Post Content MUST be made before Midnight on Wednesday to receive credit.	Comments are thorough, well written, and insightful. Ideas are well organized. Student’s mastery of content is demonstrated through critical analysis of the material and comments are grounded in scholarly research or textbook concepts and theories. Posting demonstrates in-depth understanding of the topics.	Comments are well written and complete. Ideas are mostly well organized. Student demonstrates analysis of the material and makes some integration of research or textbook concepts and theories. Posting demonstrates an understanding of the topics.	Comments lacks critical analysis and depth. Student demonstrates a basic understanding of the topics, but does not support that understanding with relevant research or textbook concepts and theories.	Posting does not meet the requirements for the assignment and demonstrates little understanding of the material.
Peer Responses and Replies Content MUST be made before Midnight on Sunday to receive credit.	Student posts at least four, well-developed, substantive posts to classmates that demonstrate in-depth analysis and critical thinking.	Student posts at least three posts which are well-developed, substantive, and demonstrate in-depth analysis and critical thinking.	Student posts at least two post to peers which somewhat contributes to the discussion; however, post does not demonstrate in-depth analysis or critical thinking.	Student does not post to peers and/or posts do not add to the discussion.
Utilizes Correct Grammar, Mechanics, Spelling and Sentence Structure	Postings are professional and generally free of errors in mechanics, spelling, usage and sentence structure. (Excellent: 9-10 Points)	Postings are professional but may contain minor errors in mechanics, spelling, usage and sentence structure. (Satisfactory: 7-8 Points)	Posting is adequate but contains some errors in mechanics, spelling, usage and sentence structure that somewhat interfere with understanding. (Needs Improvement: 5-6 Points)	Posting has numerous errors in mechanics, usage, spelling and sentence structure. Errors interfere with readability. (Unsatisfactory: 0-4 Points)
Total points earned					/10

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 April 4, 2019.

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.

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:	2100 Building Gainesville Campus Office #2106
Telephone Number:	940-668-3357
E-mail Address:	dhuffman@nctc.edu

Course Title:	SPREADSHEETS
Course Prefix & Number:		POFI 1349	Section Number: 340		Semester/Year:	SP19
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.

Name of Instructor:	Tamara Brooks
Campus/Office Location:	Corinth Campus, by appointment only
Telephone Number:	GoogleHangouts: https://hangouts.google.com/group/lG41RMQVUTojiy2N2
E-mail Address:	tnbrooks@nctc.edu / (Canvas E-Mail)

Monday	Tuesday	Wednesday	Thursday	Friday
6:30pm - 8:30pm
Online

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

# of Graded Course Elements	Graded Course Elements	Percentage or Point Values
10	Pre-Test, Chapter Assignment, Post-Test	41%
9	Independent Projects	21%
13	Discussion Forums	21%
1	MOS Voucher	1%
1	MOS Certification - Final Exam	16%

POFI 1349 340 - SPREADSHEETS

Introduction

POFI 1349 340 - Spreadsheets

Syllabus File(s)

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	January 27, 2019
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	February 3, 2019
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	February 10, 2019
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	February 17, 2019
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	February 24, 2019
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 3, 2019
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 10, 2019
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 24, 2019
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 31, 2019
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	April 7, 2019
Excel 2016 In Practice - Ch 1 Independent Project 1-4 ALT Excel 2016 In Practice - Ch 2 Independent Project 2-4 ALT		April 14, 2019
Excel 2016 In Practice - Ch 3 Independent Project 3-4 ALT Excel 2016 In Practice - Ch 4 Independent Project 4-5 ALT		April 21, 2019
Excel 2016 In Practice - Ch 5 Independent Project 5-7 ALT Excel 2016 In Practice - Ch 6 Independent Project 6-6 ALT		April 28, 2019
Excel 2016 In Practice - Ch 7 Independent Project 7-6 ALT Excel 2016 In Practice - Ch 8 Independent Project 8-5 ALT		May 5, 2019
Excel 2016 In Practice - Ch 9 Independent Project 9-5 ALT		May 12, 2019
FINAL MOS CERTIFICATION EXAM		May 15, 2019