Print

Syllabus

Advanced Microcomputer Applications
IS105

YEAR:

2023-2024

CREDIT HOURS:

3.00

PREREQUISITES:

IS104 Microcomputer Applications.

COREQUISITES:

None

COURSE NOTES:

Students who do not have the required prerequisites must receive Departmental consent before enrolling.

CATALOG COURSE DESCRIPTION:

Extension of basic knowledge of microcomputers and various software applications and operating systems using advanced features of word processing, spreadsheets, database, and presentation graphics to properly solve real world problems.

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. Create and prepare documents using advanced word processing features.
    1. Add borders to text, paragraphs, and pages
    2. Insert graphics both in line and floating into a document
    3. Center text vertically on a page
    4. Insert section breaks - next page and continuous
    5. Insert a document into the open document
    6. Create headers and footers different from previous section
    7. Draw, format, and enter data into a table
    8. Chart a word table and format it
    9. Use customized bullets
    10. Insert a watermark
    11. Insert an autoshape and format it
    12. Create and edit a source document to be used with mailmerge
    13. Create a form letter using merge fields and if statements
    14. Use multiple ways to merge documents
    15. Create and merge mailing labels
    16. Create and merge envelopes
    17. Insert and format a WordArt drawing
    18. Add ruling lines both horizontal and vertical
    19. Insert and format multiple columns
    20. Use drop caps
    21. Insert a column break
    22. Create a pull-quote
    23. Insert a diagram
    24. Insert, view, and edit comments
  2. Create and prepare worksheets using advanced spreadsheet features.
    1. Use appropriate formatting for values and labels, including conditional formatting
    2. Use appropriate formatting such as borders and shading
    3. Create and use cell and range names
    4. Use the payment function
    5. Create formulas using addition, subtraction, multiplication, division, and the sum function
    6. Create and format a data table
    7. Create and format an amortization schedule
    8. Insert a graphic
    9. Insert a hyperlink
    10. Print a worksheet multiple ways
    11. Set up protection on a worksheet
    12. Create and format a spreadsheet database
    13. Sort a database multiple ways
    14. Display subtotals in a database
    15. Use multiple ways to filter the database
    16. Use database functions such as dcount and daverage
    17. Use the vlookup and/or hlookup functions
    18. Create and use a spreadsheet template
    19. Create a spreadsheet with multiple sheets
    20. Create 3-D formulas that reference multiple sheets
    21. Create 3-D formulas that reference other spreadsheet files
    22. Use headers and footers with multiple sheets
    23. Print multiple sheets
    24. Create and format 3-D charts
    25. Add a comment to a cell
    26. Link a worksheet to a word processing document
  3. Use database software to store, organize, and design easy access to data.
    1. Create a custom report from a query
    2. Create a custom report with groupings
    3. Create a custom report with groupings
    4. Create a custom report with calculated fields and custom fields
    5. Create and use a custom form with combo boxes and custom fields
    6. Design and create a custom form with a subform
    7. Add OLE, memo, and hyperlink fields to a form
    8. Set up input masks and lookup fields
    9. Modify a form
    10. Modify a report
    11. Create and use macros
    12. Create and use a custom menu system
    13. Import a worksheet into a database
    14. Export a database table to a spreadsheet
    15. Export a database table to a word processing document
  4. Create and run custom slideshows using presentation software.
    1. Import an outline into a presentation
    2. Insert and modify a graphic
    3. Use the slide masterto modify a presentation
    4. Insert and format a table on a slide
    5. Create, insert, and format an organizational chart on a slide
    6. Add animation to slides
    7. Create a custom background
    8. Create a WordArt element on a slide
    9. Add sound to slides
    10. Insert a chart on a slide
    11. Insert a chart imported from a spreadsheet
    12. Insert a table imported from a word process file
    13. Add hyperlinks to a slide
    14. Set up a slide show to run automatically
    15. Review, accept, and reject comments and changes from a workgroup
  5. Integrate the use of word processing, spreadsheets, database, and presentation software.
    1. Import a spreadsheet into a word processing document
    2. Import a spreadsheet chart into a presentation
    3. Use a database as the source file for a mail merge operation
    4. Convert a database table to a word processing document
    5. Convert a database table to a spreadsheet

COURSE ASSESSMENT AND EVALUATION:

1. Final examination (100 points) 2. Word module (225 points) 3. Excel module (250 points) 4. Access module (250 points) 5. PowerPoint module (225 points) Each module includes 1. Project exercises 2. Case problems 3. 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