POFI 1349 - Spreadsheets

POFI 1349:

Description
Skill development in concepts, procedures, and application of spreadsheets. This course is designed to be repeated multiple times to improve student proficiency.
Credits 3 Lecture Hours 2 Lab Hours 4
Extended Hours
0
Contact Hours
96
State Approval Code
5204070000
Alternate Operations During Campus Closure

In the event of an emergency or announced campus closure due to a natural disaster or pandemic, it may be necessary for Panola College to move to altered operations. During this time, Panola College may opt to continue delivery of instruction through methods that include, but are not limited to: online learning management system (CANVAS), online conferencing, email messaging, and/or an alternate schedule. It is the responsibility of the student to monitor Panola College's website (www.panola.edu) for instructions about continuing courses remotely, CANVAS for each class for course-specific communication, and Panola College email for important general information.

Class Attendance

Regular and punctual attendance of classes and laboratories is required of all students. When a student has been ill or absent from class for approved extracurricular activities, he or she should be allowed, as far as possible, to make up for the missed work. If a student has not actively participated by the census date, they will be dropped by the instructor for non-attendance. This policy applies to courses that are in-person, online, hybrid, and hyflex.

Attendance in online courses is determined by submission of an assignment or participation in an activity. According to federal guidelines, simply logging into a distance learning course without participating in an academic assignment does not constitute attendance. Distance learning is defined as when a majority (more than 50%) of instruction occurs when the instructor and students are in separate physical locations. Students must engage in an academic activity prior to the course census date. 

When an instructor feels that a student has been absent to such a degree as to invalidate the learning experience, the instructor may recommend to the Vice President of Instruction that the student be withdrawn from the course. Instructors may seek to withdraw students for non-attendance after they have accumulated the following number of absences: 

Fall or spring semesters: 

3 or more class meeting times per week - 5 absences

2 class meeting times per week - 3 absences

1 class meeting per week -  2 absences

The student is responsible for seeing that he or she has been officially withdrawn from a class. A student who stops attendance in a class without officially withdrawing from that class will be given a failing grade; consequently, the student must follow official withdrawal procedures in the Admissions/Records Office.

Please note: Health Science and Cosmetology courses may require more stringent attendance policies based on their accreditation agencies. Please see the addendum and/or program handbook for further information concerning attendance.  

Pregnant/Parenting Policy

Panola College welcomes pregnant and parenting students as a part of the student body. This institution is committed to providing support and adaptations for a successful educational experience for pregnant and parenting students. Students experiencing a need for accommodations related to pregnancy or parenting will find a Pregnancy and Parenting Accommodations Request form in the Student Handbook or may request the form from the course instructor.

Artificial Intelligence (AI) Course Policy

No use of Generative AI permitted.

This option assumes that all work submitted by students will be generated by the students themselves, whether they are working individually or in groups. Students should not have another person or entity do the writing of any portion of an assignment, which includes hiring a person or a company to write assignments and/or using artificial intelligence (AI) tools like ChatGPT. Use of any AI-generated content in this course qualifies as academic dishonesty and violates Panola College’s standards of academic integrity.

Instructional Goals and Purposes

The purpose of this course is to teach students to identify spreadsheet terminology and concepts, calculate data using formulas and functions, create and modify workbooks, insert graphics, generate charts and reports, and create and use special functions.

Learning Outcomes
  1. Launch Excel and navigate the worksheet.
  2. Enter and edit data in a worksheet.
  3. Build worksheets.
  4. Enhance worksheets.
  5. Preview and print worksheets and workbooks.
  6. Create charts and share information.
  7. Link worksheets and workbooks.
  8. Create, sort, and filter lists.
  9. Increase productivity with macros, templates, and custom toolbars and menus.
  10. Use problem-solving tools.
  11. Use auditing tools.
  12. Summarize data with data analysis, PivotTables, and PivotCharts.
  13. Work with charts and the drawing tools.
  14. Import and export data from other applications.
  15. Share workbooks with others.
  16. Integrate Excel with the Internet or an Intranet.
Specific Course Objectives (includes SCANS)

After studying the material presented in the text and online, the student should be able to complete all behavioral/learning objectives listed below with a minimum competency of 70% on assignments and exams.

  1. Launch Excel and navigate the worksheet. (1a-i, 1c-iv, 2c-i, 2c-ii, 2c-iv, 2e-ii)
    1. Launch Excel.
    2. Identify the components of the Excel window.
    3. Locate and open an existing workbook.
    4. Navigate a worksheet.
    5. Select cells, columns, and rows.
    6. Insert, reposition, and delete worksheets.
    7. Save a workbook.
    8. Preview and print a worksheet.
    9. Close a workbook.
    10. Create a new workbook from a template.
    11. Exit Excel.
  2. Enter and edit data in a worksheet. (1a-i, 1a-iii, 1b-iii, 2c-ii, 2c-iv)
    1. Create new workbooks.
    2. Enter text and numbers in cells.
    3. Edit cell contents.
    4. Use Undo and Redo.
    5. Change the Zoom setting.
    6. Rename a sheet tab.
    7. Change a sheet tab color.
  3. Build worksheets. (1a-i, 1b-vi, 2c-ii, 2c-iv)
    1. Create and revise formulas.
    2. Use cut, copy, and paste.
    3. Copy formulas with relative, absolute, and mixed cell references.
    4. Use basic functions.
    5. Use the Insert Function dialog box.
    6. Use 3-D references in formulas.
  4. Enhance worksheets. (1a-i, 1b-iv, 2c-iv)
    1. Create worksheet and column titles.
    2. Format cells, rows, and columns.
    3. Use Paste Special.
    4. Define and apply styles.
    5. Manipulate rows, columns, and cells.
    6. Filter lists using AutoFilter.
  5. Preview and print worksheets and workbooks. (1a-i, 1b-iii, 2c-i, 2c-ii, 2c-iii, 2c-iv)
    1. Use Find and Replace.
    2. Check spelling.
    3. Set print options and print worksheets.
    4. Print an entire workbook.
  6. Create charts and share information. (1a-i, 1a-ii, 1b-vi, 2c-i, 2c-ii, 2c-iii, 2c-iv)
    1. Use the Chart Wizard to create a chart.
    2. Format and modify a chart.
    3. Insert, resize, and move a graphic.
    4. Work with embedded charts.
    5. Preview and print charts.
    6. Use workgroup collaboration.
    7. Use Go To.
  7. Link worksheets and workbooks. (1a-i, 1b-vi, 2c-ii, 2c-iii, 2c-iv)
    1. Group worksheets to share data, formatting, and formulas.
    2. Insert and format a documentation worksheet.
    3. Use named ranges.
    4. Consolidate data from multiple worksheets.
    5. Create 3-D references and links between workbooks.
    6. Work with multiple workbooks.
  8. Create, sort, and filter lists. (1a-i, 1a-iii, 1b-ii, 2c-ii, 2c-iv)
    1. Identify basic terms and guidelines for creating lists.
    2. Enter data in a list using data validation.
    3. Use the data form.
    4. Create custom filters.
    5. Perform single and multilevel sorts.
    6. Use grouping and outlines to create subtotals.
  9. Increase productivity with macros, templates, and custom toolbars and menus. (1a-i, 2-c-ii, 2-c-iv)
    1. Use macros to automate repetitive tasks.
    2. Edit a macro.
    3. Use workbooks containing macros.
    4. Create and edit templates.
    5. Customize toolbars and menus.
  10. Use problem-solving tools. (1a-i, 1a-iii, 1b-vi, 2c-i, 2c-ii, 2c-iii, 2c-iv)
    1. Create data tables.
    2. Use Goal Seek and Solver.
    3. Create scenarios.
    4. Create a trendline.
  11. Use auditing tools. (1-a-i, 1-b-vi, 2-c-iii)
    1. Use Range Finder to check and review data.
    2. Identify relationships between precedent and dependent cells.
    3. Use error checking.
    4. Identify invalid data.
  12. Summarize data with data analysis, PivotTables, and PivotCharts. (1a-i, 1b-ii, 2c-i, 2c-ii, 2c-iii, 2c-iv)
    1. Use data analysis.
    2. Create PivotTable reports.
    3. Modify a PivotTable report.
    4. Format a PivotTable report.
    5. Create PivotChart reports.
  13. Work with charts and the drawing tools. (1a-i, 2c-ii, 2c-iii, 2c-iv)
    1. Create special charts.
    2. Modify charts.
    3. Use the drawing tools.
    4. Create and edit a conceptual diagram.
  14. Import and export data from other applications. (1-a-i, 2-c-i, 2-c-ii, 2-c-iii, 2-c-iv)
    1. Integrate Excel data with Word and PowerPoint.
    2. Integrate Excel with Access.
    3. Import data from text files.
  15. Share workbooks with others. (1a-i, 2c-i, 2c-ii, 2c-iii, 2c-iv)
    1. Create and apply custom number and conditional formats.
    2. Use lookup and reference functions.
    3. Use workgroup features.
  16. Integrate Excel with the Internet or an Intranet. (1a-i, 1b-vi, 2c-i, 2c-ii, 2c-iii, 2c-iv)
    1. Import data from the Internet.
    2. Work with XML.
    3. Publish worksheets and workbooks to the web.
    4. Send a workbook via e-mail.
Course Content

A general description of lecture/discussion topics included in this course are listed in the Learning Outcomes/Specific Course Objectives sections of this syllabus.

Students in all sections of Spreadsheets will be required to do the following:

  1. Students will submit an assignment each week. Each assignment stresses features and functions common to spreadsheet applications including creating formulas, formatting worksheets, working with multiple worksheets, creating charts, sorting and filtering lists, etc.
  2. Students will complete three hands-on, application exams using a spreadsheets program in the presence of a testing proctor.
Methods of Instruction/Course Format/Delivery

Students in both the traditional class and in the Internet class will have access to this course via Canvas. Students in the traditional class will meet regularly for lecture over the material. Students in the Internet class will only be required to meet with the instructor for testing; however, Internet students are always welcome to attend the traditional class (especially for exam reviews).

All assignments will be submitted through Canvas. After the assignment has been graded, the student will be able to view his or her grade by returning to the assignment or by clicking the Grades link in the left banner. All exams will be hands-on application tests and students will not be able to view the answers to the exams online; however, they will be able to see their grade in Grades and drop by the office to review their exams. Work is generally graded and posted within two days following the deadline.

Students in both the traditional and Internet classes should use email within Canvas to communicate with the instructor. Using Canvas email gives you access to the instructor and other classmates without having to remember or type email addresses—you just select a name from the list. If you are not able to contact your instructor using email in Canvas, you may use his or her Panola College email address. Panola College instructors attempt to respond to all email within 24 hours.

Assignments

The following items will be assigned and assessed during the semester and used to calculate the student’s final grade:

Assignments

Students will work through 9 projects in your textbook. At the end of each project, there will be an assignment that will be graded—either Apply Your Knowledge or In the Lab exercises. Generally, only one or two exercises will be assigned at the end of a chapter—you are only responsible for completing the exercises assigned. Always check the Assignments link to make sure which exercises are required. These documents will be submitted through the assignment itself and will be graded and returned to you in the same manner. Homework is due as assigned and 10 points will be deducted for each day work is late. Late work will not be accepted after homework has been graded and returned to the class. Remember: If you are having trouble with your computer or Canvas, there are other ways to turn your documents in on time—even if you have to deliver it in person. Submission of someone else’s work will receive a zero.

Exams

Exams 1-3 covering Projects 1-9 will be application tests where you demonstrate what you have learned—the problems on the exam will be very similar to your lab assignments. Exam instructions will be provided in your Canvas course, and you will take the exams at home using Microsoft Office 365 on your computer; if you do not have a computer with MS Office installed, you may take the exams at one of the Panola College testing centers in Carthage, Center, or 5 Marshall. If you are unable to take a test when it is scheduled, you must reschedule the test with the instructor PRIOR to the testing date. An excused absence and makeup test may be granted for sudden illness or unforeseen circumstances. Deductions on assignments and tests will occur for minor and major formatting errors, as well as, typographical errors. Each exam is worth 20% of your final grade.

Course Grade

The grading scale for this course is as follows:

  • Assignments – 40%
  • Exams – 60%

All of your grades including a mid-semester and final grade will be posted to Grades in Canvas.

Cheating is defined as unauthorized help on an examination or assigned course material. A student must not submit another student’s work as his or her own. A student must not receive from any other student or give to any other student any information, answers, or help during an exam. A student must not "steal" the answers from an unsuspecting student during an exam. A student must not use any sources for answers during an exam (including but not limited to notes, books, or electronic devices) without prior authorization from the professor. A student must not obtain exam questions illegally, tamper with the exam questions, nor change the results of an exam after it has been graded. All cheating infractions will result in a grade of “0” for the assignment.

Plagiarism is defined as the taking of a person's ideas, words, or information and claiming those properties as one's own. The use of all ideas, words, or information from any source must be properly referenced and due credit must be given to its author. All written assignments must be submitted through Canvas which uses turnitin.com to calculate percent originality of the submission. For compositions, a student’s work must show 0% plagiarism. For research assignments, properly quoting and citing information from other sources is usually required in the assignment; however, since the integrity of the assignment is based upon the originality of the student's work, no student may turn in a paper which exceeds a 30% score in properly quoted and cited material. The instructor reserves the right to employ other means outside of turnitin.com to check the "originality" of a student’s work. Any submission that contains copied material (other than cited material in a research paper) will automatically receive a grade of "0" for the assignment.

A student will fail the class upon his or her second cheating and/or plagiarism offense. These policies shall be adhered to unless mitigating circumstances should prove a lesser penalty should apply. Students shall have the right to contest a cheating or plagiarism claim; the appeals process is specifically defined in the student handbook.

Texts Materials, and Supplies
  • Microsoft Excel 2016: Comprehensive, Freund, Starks, and Schmieder, Cengage Learning, 2017, ISBN: 9781305870727. You may purchase or rent a used textbook for this class; no code or other supplemental materials are required.
  • Access to a computer with Microsoft Office installed. You may use MS Office 365, 2016, 2019, or 2021 for this course. Details for how to download the free MS Office 365 are available in the Introduction section of your Canvas course. DO NOT use the live, online version of MS Office 365—it does not have all of the features you will need to complete this course.
  • Access to the Internet.
  • Student data files that must be downloaded from Canvas, the publisher’s site, or obtained from instructor.
Required Readings
  • Projects 1-9, Microsoft Excel 2016 Comprehensive.
Recommended Readings

None

Other
SCANS Criteria
  1. Foundation skills are defined in three areas: basic skills, thinking skills, and personal qualities.
    1. Basic Skills: A worker must read, write, perform arithmetic and mathematical operations, listen, and speak effectively. These skills include:
      1. Reading: locate, understand, and interpret written information in prose and in documents such as manuals, graphs, and schedules.
      2. Writing: communicate thoughts, ideas, information, and messages in writing, and create documents such as letters, directions, manuals, reports, graphs, and flow charts. 
      3. Arithmetic and Mathematical Operations: perform basic computations and approach practical problems by choosing appropriately from a variety of mathematical techniques.
      4. Listening: receive, attend to, interpret, and respond to verbal messages and other cues.
      5. Speaking: Organize ideas and communicate orally.
    2. Thinking Skills: A worker must think creatively, make decisions, solve problems, visualize, know how to learn, and reason effectively. These skills include:
      1. Creative Thinking: generate new ideas.
      2. Decision Making: specify goals and constraints, generate alternatives, consider risks, and evaluate and choose the best alternative.
      3. Problem Solving: recognize problems and devise and implement plan of action.
      4. Visualize ("Seeing Things in the Mind's Eye"): organize and process symbols, pictures, graphs, objects, and other information.
      5. Knowing How to Learn: use efficient learning techniques to acquire and apply new knowledge and skills.
      6. Reasoning: discover a rule or principle underlying the relationship between two or more objects and apply it when solving a problem.
    3. Personal Qualities: A worker must display responsibility, self-esteem, sociability, self management, integrity, and honesty.
      1. Responsibility: exert a high level of effort and persevere toward goal attainment.
      2. Self-Esteem: believe in one's own self-worth and maintain a positive view of oneself.
      3. Sociability: demonstrate understanding, friendliness, adaptability, empathy, and politeness in group settings.
      4. Self-Management: assess oneself accurately, set personal goals, monitor progress, and exhibit self-control.
      5. Integrity and Honesty: choose ethical courses of action.
  2. Workplace competencies are defined in five areas: resources, interpersonal skills, information, systems, and technology.
    1. Resources: A worker must identify, organize, plan, and allocate resources effectively.
      1. Time: select goal-relevant activities, rank them, allocate time, and prepare and follow schedules.
      2. Money: Use or prepare budgets, make forecasts, keep records, and make adjustments to meet objectives.
      3. Material and Facilities: Acquire, store, allocate, and use materials or space efficiently. Examples: construct a decision timeline chart; use computer software to plan a project; prepare a budget; conduct a cost/benefits analysis; design an RFP process; write a job description; develop a staffing plan.
    2. Interpersonal Skills: A worker must work with others effectively.
      1. Participate as a Member of a Team: contribute to group effort.
      2. Teach Others New Skills.
      3. Serve Clients/Customers: work to satisfy customer's expectations.
      4. Exercise Leadership: communicate ideas to justify position, persuade and convince others, responsibly challenge existing procedures and policies.
      5. Negotiate: work toward agreements involving exchange of resources, resolve divergent interests.
      6. Work with Diversity: work well with men and women from diverse backgrounds. Examples: collaborate with a group member to solve a problem; work through a group conflict situation, train a colleague; deal with a dissatisfied customer in person; select and use appropriate leadership styles; use effective delegation techniques; conduct an individual or team negotiation; demonstrate an understanding of how people from different cultural backgrounds might behave in various situations.
    3. Information: A worker must be able to acquire and use information.
      1. Acquire and Evaluate Information.
      2. Organize and Maintain Information.
      3. Interpret and Communicate Information.
      4. Use Computers to Process Information. Examples: research and collect data from various sources; develop a form to collect data; develop an inventory record-keeping system; produce a report using graphics; make an oral presentation using various media; use on-line computer databases to research a report; use a computer spreadsheet to develop a budget.
    4. Systems: A worker must understand complex interrelationships.
      1. Understand Systems: know how social, organizational, and technological systems work and operate effectively with them.
      2. Monitor and Correct Performance: distinguish trends, predict impacts on system operations, diagnose deviations in systems' performance and correct malfunctions.
      3. Improve or Design Systems: suggest modifications to existing systems and develop new or alternative systems to improve performance. Examples: draw and interpret an organizational chart; develop a monitoring process; choose a situation needing improvement, break it down, examine it, propose an improvement, and implement it.
    5. Technology: A worker must be able to work with a variety of technologies.
      1. Select Technology: choose procedures, tools or equipment including computers and related technologies.
      2. Apply Technologies to Task: understand overall intent and proper procedures for setup and operation of equipment.
      3. Maintain and Troubleshoot Equipment: Prevent, identify, or solve problems with equipment, including computers and other technologies. Examples: read equipment descriptions and technical specifications to select equipment to meet needs; set up and assemble appropriate equipment from instructions; read and follow directions for troubleshooting and repairing equipment.