Print

Syllabus

Spreadsheets I
IS110

YEAR:

2023-2024

CREDIT HOURS:

1.00

PREREQUISITES:

None

COREQUISITES:

None

COURSE NOTES:

Repeatable for graduation credit if using a differnt software package. Use a computer independently (general computer understanding of concepts, terminology, and operations) required.

CATALOG COURSE DESCRIPTION:

Use of spreadsheet software to demonstrate competencies in using formatting techniques, features and functions with hands-on experience; managing financial statements; working with formulas and functions; developing professional-looking worksheets; charting and graphic capabilities.

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. Prepare and format an Excel worksheet.
    1. Open Excel
    2. Explain uses of spreadsheets
    3. Identify the Title Bar
    4. Identify the Menu Bar
    5. Identify the standard toolbar
    6. Identify the formatting toolbar
    7. Display the Formatting toolbar and Standard toolbar on two rows
    8. Identify the Name Box
    9. Identify the Formula Bar
    10. Identify the Status Bar
    11. Identify the Sheet Tabs
    12. Identify the active cell
    13. Identify the scroll bars
    14. Competency 14 - Demonstrate moving using the scrollbar
    15. List five ways to navigate within a worksheet
    16. List three ways to edit the content of a cell
    17. Explain the purpose and uses of column headings
    18. Explain the purpose and uses of row headings
    19. Identify Gridlines
    20. Enter data into the active cell
    21. Open the Go to dialog box using the keyboard
    22. Accurately use the Go To dialog
    23. Explain the purpose and uses of worksheets
    24. Explain the purpose and uses of name box
    25. Explain the purpose of cell references
    26. Identify the Status bar
    27. Explain the uses/purpose of the Status Bar
    28. Identify the Cell Pointer
    29. Demonstrate using the Cell Pointer
    30. Save a workbook
    31. Save a workbook with a new filename
    32. Open a workbook
    33. Close Excel
    34. Print a workbook
    35. Identify Expanding Drop-Down menus
    36. Demonstrate using Expanding Drop-Down menus
    37. Change Expanding Drop-Down menus to Full menus
    38. Switch between sheets
    39. Select a range using the mouse
    40. Select a range using the control key
    41. Select a range using the shift key
    42. Identify the purpose of adaptive menus
    43. Display a screen tip
    44. Enter text into cells
    45. Identify a text entry
    46. Enter values into cells
    47. Identify a value entry
    48. Identify a date entry
    49. Use ESC to cancel cell entry
    50. Explain the AutoComplete feature
    51. Explain the AutoCorrect feature
    52. Add AutoCorrect options
    53. Explain the AutoFill feature
    54. Identify the fill handle
    55. Use the fill handle
    56. Identify the Auto Fill Options button
    57. Usethe Auto Fill Options button
    58. List the options when using the Auto Fill Options button
    59. Use the AutoFormat
    60. List 5 ways to select ranges
    61. Select nonadjacent cells
    62. Select columns
    63. Selecting rows
    64. Use the Ask a Question Text Box
    65. Use Print Preview
    66. Change the Zoom
    67. Use the buttons on the Formatting toolbar
    68. Explain the purposes of the buttons on the Formatting toolbar
    69. Resize columns (two methods)
    70. Resize rows (two methods)
    71. Format data in cells
    72. Use the Format Cells dialog
    73. Make changes using the Format Cells dialog
    74. Change alignment
    75. Rotate text
    76. Identify options in the Format Cells dialog in the Alignment tab
    77. Identify options in the Format Cells dialog in the Font tab
    78. Change the Font using the Format Cells dialog
    79. Insert a row
    80. Insert a column
    81. Insert a cell
    82. Describe the purpose and uses of shifting cells when inserting cells
    83. Clear the content of a cell
    84. Delete cells
    85. Delete rows
    86. Delete columns
    87. Clear data in cells
    88. Use the Borders button
    89. Change the border thickness
    90. Use the borders toolbar
    91. Change the border style
    92. Draw a border using the Draw Border tool
    93. Use the Fill Color button
    94. Apply a fill pattern
    95. Change the pattern color
    96. Change the pattern style
    97. Use the Merge and Center button
  2. Effectively use formulas and functions.
    1. Use the SUM function
    2. Describe when to use the SUM function
    3. Explain a concern of order of precedence
    4. Copy a formula with relative references
    5. Enter a formula by keying it in
    6. Enter a formula by click cells
    7. Differentiate between an error and non-error
    8. Fix an error
    9. Use the Trace Error button
    10. List two ways to insert a function
    11. Describe when to use the AVERAGE function
    12. Use the AVERAGE function
    13. Describe when to use the MIN function
    14. Use the MIN function
    15. Describe when to use the MAX function
    16. Use the MAX function
    17. Use the Insert Function dialog
    18. List two ways to insert a function
    19. Use the FV function
    20. Describe when to use the FV function
    21. Use the IPMT function
    22. Describe when to use the IMPT function
    23. Use the PMT function
    24. Describe when to use the PMT function
    25. Use the PV function
    26. Describe when to use the PV function
    27. Develop a logical test for the IF function
    28. Use correct logic when inputting true and false arguments
    29. Describe the parts of functions
    30. Insert a function by category
    31. Insert a function using the Insert Function search
    32. Identify a logical result from a function
    33. Copy a formula
    34. Paste a formula
    35. Fill a formula
    36. Describe when to use an absolute reference
    37. Identify a absolute reference
    38. Identify a mixed reference
    39. Make a reference absolute
    40. Make a reference absolute using the function key
  3. Enhance a worksheet and move data within and between workbooks.
    1. Format a worksheet page
    2. Use Page Setup dialog to change how information is printed on the page
    3. Center vertically on page
    4. Use the Page Setup in Print Preview
    5. Change the page orientation
    6. Change the scaling
    7. Insert a header
    8. Insert a footer
    9. Use the Left Section box
    10. Use the Center Section box
    11. Use the Right Section box
    12. Insert the page number
    13. Insert the date
    14. Insert the time
    15. Insert the filename
    16. Insert the tab name
    17. Change the formatting of the header
    18. Change the formatting of the footer
    19. Set a Print Area
    20. Insert a Page Break
    21. Repeat rows on each printed page
    22. Repeat columns on each printed page
    23. Adjust scaling to Fit to 1 page
    24. Change worksheet margins
    25. Insert page breaks
    26. Remove page breaks
    27. Print gridlines
    28. Hide a row
    29. Hide a column
    30. Unhide a row
    31. Unhide a column
    32. Print an active worksheet
    33. Print a selection
    34. Use Spelling Check
    35. Use Undo
    36. Use Redo
    37. Use Replace
    38. Replace formatting
    39. Sort data
    40. Sort using more than one column
    41. Create a List
    42. Filter a List
    43. Use Print Area
    44. Move selected cells
    45. Copy selected cells
    46. Use the Office Clipboard
    47. Display the Clipboard Task Pane
    48. Print the entire workbook
    49. Insert worksheets
    50. Delete worksheets
    51. Select worksheets
    52. Rename worksheets
    53. Change the color of worksheet tabs
    54. Move worksheets
    55. Copy worksheets
    56. Hide worksheet
    57. Unhide worksheets
    58. Format multiple worksheets
    59. Split a worksheet into windows
    60. Freeze panes
    61. Unfreeze panes
    62. Name a range
    63. Use a range in a formula
    64. Open multiple workbooks
    65. Close multiple workbooks
    66. Arrange workbooks
    67. Hide workbooks
    68. Unhide workbooks
    69. Size workbooks
    70. Move workbooks
    71. Move and copy data between workbooks
    72. Minimize workbooks
    73. Restore workbooks
    74. Link data between worksheets
    75. Create a 3-D reference
    76. Copy worksheets into a Word document
  4. Work with charts.
    1. Use the Chart Wizard button
    2. Choose a chart type
    3. Explain the differences of the chart types and subtypes
    4. Choose the Data Source
    5. Change a Data Source
    6. Add a Series
    7. Remove a Series
    8. Define the Chart Elements
    9. Insert a Chart Title
    10. Insert a Category (x) Axis
    11. Insert a Category (y) Axis
    12. Save chart as a new sheet
    13. Save chart as an embedded chart
    14. Change the Chart Location
    15. Move an Embedded Chart
    16. Resize an Embedded Chart
    17. Explain how to update a chart with new values
    18. Create a Pie Chart
    19. Add percentage labels to the chart
    20. Rotate a Pie Chart
    21. Explode a slice of a Pie Chart
    22. Add labels to a Column Chart
    23. Format the Chart Labels
    24. Insert an unattached text entry
    25. Apply a border around an unattached text entry
    26. Change a column to a gradient fill
    27. Change the transparency
    28. Apply a preset gradient fill
    29. Apply a two color gradient fill
    30. Apply a one color gradient fill
    31. Change the shading style
    32. Change a column to a textured fill
    33. Change a column to a pattern fill
    34. Change the colors of a pattern fill
    35. Change the style of a pattern fill
    36. Change a column to a picture fill
    37. View the y-axis scale
    38. Change the major unit box
    39. Change the minor unit box
    40. Change the Chart Type to another chart sub-type
    41. Change the elevation
  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, 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. Assignments 7. Quizzes 8. Final examination Common final for all sections

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