Print

Syllabus

Spreadsheets II
IS111

YEAR:

2023-2024

CREDIT HOURS:

1.00

PREREQUISITES:

IS110 Spreadsheets I with a grade of C or better.

COREQUISITES:

None

COURSE NOTES:

Repeatable once for graduation credit if using a different software package.Students who do not have the required prerequisites must receive Departmental consent required before enrolling.

CATALOG COURSE DESCRIPTION:

Continuation of IS110 Spreadsheets I with use of advanced features of spreadsheets, lists and PivotTables, managing and auditing multiple worksheets and workbooks, collaborating with workgroups and creating and editing macros.

HutchCC INSTITUTION-WIDE OUTCOMES:

  1. Demonstrate the ability to think critically and make reasonable judgments by acquiring, analyzing, combining, and evaluating information.
  2. Demonstrate the skills necessary to access and manipulate information through various technological and traditional methods.
  3. Demonstrate effective communication through reading, writing, listening, and speaking.
  4. Demonstrate effective interpersonal and collaborative skills.
  5. Demonstrate effective quantitative-reasoning and computational skills.

AREA OR PROGRAM OUTCOMES

  1. Demonstrate professional attitude and work ethic including collaboration and communication skills.
  2. Evaluate current operating systems, application programs, hardware, networking, security and troubleshooting techniques.
  3. Develop and apply specialized computer technology skills, in a hands-on industry setting.
  4. Distinguish and appropriately apply industry terminology and standards in computer technology.
  5. Research and obtain appropriate information, evaluate alternative solutions and make decisions as applied to computer technology.

COURSE OUTCOMES AND COMPETENCIES:

  1. Use advanced functions.
    1. Insert a function
    2. Use Search for a function (insert function dialog)
    3. Use Select a category (insert function dialog)
    4. Use financial functions (PMT, PV, and FV)
    5. Identify function arguments
    6. Select appropriate data and/or cells in each argument
    7. Use mathematical functions (ROUND, RAND, and SUMIF)
    8. Use statistical functions (COUNTIF)
    9. Name ranges
    10. Use named ranges in functions/formulas
    11. Use Lookup and reference functions (VLOOKUP)
    12. Use Logical functions (IF)
    13. Use array formulas
    14. Explain the purpose of an array formula
  2. Effectively utilize lists.
    1. Identify records, fields, and field names in a list
    2. Enter data using the data form
    3. Locate data using the data form
    4. Delete data using the data form
    5. Explain the purpose of setting a Data Validation
    6. Use Data Validation
    7. Use the Settings of Data Validation
    8. Use appropriate Input Messages
    9. Use appropriate Error Alert messages
    10. Change the error alert style
    11. Sort a List
    12. Create a Custom List
    13. Outline a worksheet
    14. Use the Outline to hide/show certain information
    15. Insert Subtotals in a List
    16. Remove Subtotals from a List
    17. Change what is Subtotaled
    18. Change the Subtotal function
    19. Filter a List
    20. Use AutoFilter
    21. Create a custom AutoFilter
    22. Filter a List using Advanced Filters
    23. Extract unique records
    24. Use the advanced filter dialog box
    25. Create a list
    26. Modify data this is part of a list
    27. Use database functions (DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, and DSUM)
  3. Effectively use Excel's analysis tools.
    1. Create and modify a PivotTable
    2. Interoperate a PivotTable
    3. Create a PivotChart
    4. Format a PivotTable
    5. Sort a PivotTable
    6. Use the PivotTable toolbar
    7. Filter a PivotTable report
    8. Manage a PivotTable report
    9. Hide details in the PivotTable
    10. Change the layout of the PivotTable
    11. Remove subtotals and grand totals from the PivotTable
    12. Use PivotTable options
    13. Use the Chart Wizard for a PivotTable
    14. Create interactive PivotTables for the web
    15. Publish information to the web
    16. Use Goal Seek
    17. Use Solver
    18. Change Solver options
    19. Analyze data using Solver
    20. Create scenarios
    21. Analyze scenarios
    22. Create a trendline on a chart
    23. Perform regression analysis
  4. Manage and audit worksheets.
    1. Plan a Macro
    2. Record a Macro
    3. Stop recording a Macro
    4. Run a Macro
    5. Edit a Macro
    6. Identify a floating toolbar
    7. Identify a docked toolbar
    8. Hide toolbars
    9. Display toolbars
    10. Customize toolbars and menus
    11. Audit workbooks
    12. Use the Auditing toolbar
    13. Trace dependents
    14. Trace precedents
    15. Trace errors
    16. Locate invalid data and formulas
    17. Explain the different errors
    18. Set a validation
    19. Evaluate formulas
  5. Demonstrate problem solving and concept understanding.
    1. Use the correct techniques on case problems and simulation assignments
    2. Demonstrate problem solving skills
    3. Analyze spreadsheets to explain presented information
    4. Review spreadsheets to identify errors and possible problems
    5. Create and use business spreadsheets (invoices, cash flow statements, purchase order, payroll, income statement, templates, accounts receivable ledger, accounts payable ledger, journals, budgets, etc.)

COURSE ASSESSMENT AND EVALUATION:

1. Exercises 2. Performance assessments 3. In-class hands-on computer assessments 4. Projects (case problems and simulations) 5. Daily work 6. Projects 7. Assignments 8. Quizzes 9. Final examination

ACCOMMODATIONS STATEMENT:

Any student who has a documented disability and wishes to access academic accommodations (per the 1973 Rehabilitation Act and Americans with Disability Act) must contact the HCC Coordinator of Disability Services, at 620-665-3554, or the Student Success Center, Parker Student Union. The student must have appropriate documentation on file before accommodations can be provided.

ACADEMIC HONESTY:

Education requires integrity and respect for HutchCC's institutional values. HutchCC students are required to maintain honesty through a "responsible acquisition, discovery, and application of knowledge" in all academic pursuits. Preserving and upholding academic honesty is the responsibility of Hut chCC students, faculty, administrators and staff.

I. Student Responsibilities

All HutchCC students are required to:

  • Submit all work in all courses without cheating, fabrication, plagiarism, dissimulation, forgery, sabotage, or academic dishonesty as defined below.
  • Provide all academic records such as transcripts and test scores that are free of forgery.
  • Refrain from participating in the academic dishonesty of any person.
  • Use only authorized notes and student aids.
  • Use technology appropriately, including refraining from submitting AI (Artificial Intelligence)-generated work without express written consent from your instructor.
  • Protect the security of passwords/login/privacy/electronic files, and maintain sole individual access for any online course information.

II. Definition of Academic Dishonesty

  • Academic dishonesty is any intentional act, or attempted act, of cheating, fabrication, plagiarism, dissimulation, forgery, or sabotage in academic work.
  • Cheating includes using unauthorized materials of any kind, whether hard copies, online, or electronic, such as unapproved study aids in any academic work, copying another student's work, using an unauthorized "cheat sheet" or device, or purchasing or acquiring an essay online or from another student.
  • Fabrica tion is the invention or falsification of any information or citation in any academic work, such as making up a source, providing an incorrect citation, or misquoting a source.
  • Plagiarism is the representation of words, ideas and other works that are not the student's own as being original to the student. A no n-inclusive list of examples includes work completed by someone else, work generated by an external entity (such as AI), omitting a citation for work used from another source, or borrowing the sequence of ideas, arrangement of material, and/or pattern of thought of work not produced by the student, even though it may be expressed in the student's own words.
  • Dissimulation is the obscuring of a student's own actions with the intention of deceiving others in any academic work, such as fabricating excuses for absences or missed assignments, or feigning attendance.
  • Forgery of academic documents is the unauthorized altering, falsification, misrepresentation, or construction of any academic document, such as changing transcripts, changing grades on papers or on exams which have been returned, forging signatures, manipulating a digital file of academic work, or plagiarizing a translation.
  • Sabotage is any obstruction or attempted obstruction of the academic work of another student, such as impersonating another student, stealing or ruining another student's academic work.
  • Aiding and abetting academic dishonesty is considered as knowingly facilitating any act defined above.
  • Academic honesty violations can also include the omission or falsification of any information on an application for any HutchCC academic program.

III. Sanctions for Academic Dishonesty

Students who violate the Academic Honesty Policy may be subject to academic or administrative consequences.

Instructor Sanctions for Violation:

Students suspected of violating the Academic Honesty Policy may be charged in writing by their instructor and any of the following may apply:

  • Assign Avoiding Plagiarism Bridge Module
  • Receiving written warning that could lead to more severe sanction if a second offense occurs
  • Revising the assignment/work in question for partial credit
  • Voiding work in question without opportunity for make-up
  • Reducing the grade for work in question
  • Lowering the final course grade
  • Failing the work in question

Institutional Sanctions for Violation:

Students charged with academic dishonesty, particularly in instances of repeated violations, may further be subjected to an investigation and any of the following may apply:

  • Instructor recommendation to the Vice President of Academic Affairs (VPAA) to dismiss the student from the course in which the dishonesty occurs
  • Instructor recommendation to the VPAA to dismiss student from the course in which the dishonesty occurs with a grade of 'F." Student will not be allowed to take a 'W' for the course
  • Instructor recommendation to the VPAA that the student be suspended and/or dismissed from the program
  • Student barred from course/program for a set period of time or permanently
  • May be recommended by the instructor (after documented repeated offenses) to the VP AA that the student be placed on probation, suspended and/or dismissed from the institution.

IV. Procedure

  • Instructor will communicate in writing via the student's HutchCC email account and/or LearningZone email account to the student suspected of violating the Academic Honesty Policy.  That communication may include sanction(s). Department Chair will notify the student's academic advisor upon receipt of the Academic Honesty Violation Form.
  • For each violation, the instructor will submit a completed Academic Honesty Violation Form to the Department Chair. Department Chair will notify the student's academic advisor upon receipt of the Academic Honesty Violation form.
  • Should the instructor choose to pursue institutional sanctions, the instruct or shall notify the student in writing via the student's HutchCC email account.  Instructor shall also submit a completed Academic Honesty Violation Form and all prior completed forms regarding said student to the Department Chair and the office of the VPAA with recommendation to proceed with specific Institutional Sanctions. Department Chair will notify the student's academic advisor upon receipt of the Academic Honesty Violation Form.
  • The decision of the VPAA on Institutional Sanction is final. The VPAA will notify the student's academic advisor of any institutional sanctions.

V. Due Process Rights

Students charged with violations of academic honesty have the right of appeal and are assured of due process through the Academic Honesty Appeal process.

Academic Honesty Appeal Process

I. Due Process Rights: Students charged with violations of academic honesty have the right of appeal and are assured of due process through the Academic Honesty Appeal process.

  • If an instructor has recommended course or program dismissal, the student may continue in coursework (provi ding there are no threatening or security behavioral issues) until appeal processes are concluded. However, if an issue has been documented at a partnership location (e.g., clinical sites, secondary institutions, correctional or military facilities), then the student is no longer eligible to continue participation in internships, apprenticeships, and/or clinical-based practice. For clinical sites, this sanction is immediate.

II. Process

If the student disagrees with the charge of a violation of academic honesty, the student has the right to due process as described in the Academic Honesty Appeal process below:

  • If the matter is not resolved upon communicating with the instructor about the violation, the student shall, within five business days of the issuance of the written notice of violation, submit a completed Academic Honesty Appeal Form and supporting documentation to the appropriate department chairperson to initiate an Academic Honesty Appeal.
  • Within two business days of receiving the student's completed Academic Honesty Appeal Form, the Department Chair and VPAA will review and the VPAA will render a decision.
  • Within two business days, a response will be sent to the student's HutchCC email address. The VPAA's decision is final.

INCOMPLETE GRADE:

Instructors may give a student a grade of Incomplete (I) under the following conditions:

  1. The student must initiate the request prior to the time final course grades are submitted to Records.
  2. The request must be made because of an emergency, illness or otherwise unavoidable life-event.
  3. The instructor must agree to the request before a grade of Incomplete can be submitted.
  4. A written contract between the instructor and student, signed by both, will document the work required and date needed to complete course work.
  5. If a student does not complete the course requirements within the time frame established by the instructor, a grade of "F" will be recorded on the student's transcript at the end of the next semester.

HLC ACCREDITATION:

Hutchinson Community College is accredited by the Higher Learning Commission (HLC). The Higher Learning Commission is one of six regional institutional accreditors recognized by the US Department of Education and the Council on Higher Education Accreditation (CHEA).

Last Revised: 07/01/2015