Quick Links
Skip to main content Skip to navigation

Computer Applications - 1st Semester Syllabus


Ajax Loading Image


Meredosia-Chambersburg High School

Course Syllabus – Computer Applications


Course Information

Teacher Information

Credit Hour:  .5

Name: Mr. Shupe

Marking Period: First Semester

Phone: 217.584.1291


E-Mail: jshupe@mcsd11.net




Course Description:

This course will provide the student with a working knowledge of Microsoft Word and Microsoft Excel.


Course Competencies/ Learning Objectives

Students who successfully complete Computer Applications will be able to:


Microsoft Office Basics

  • Identify common Microsoft Office screen elements.
  • Navigate with file explorer.
  • Create and delete folders.
  • Analyze data storage.
  • Save files properly.

 Microsoft Word

  • Create documents with headers and footer.
  • Format documents with themes and styles.
  • Edit and correct Word documents.
  • Adjust alignment and spacing.
  • Create letters and envelopes.
  • Format text with fonts and effects.
  • Format and sort lists.
  • Insert pictures, text boxes, and shapes.
  • Format graphics objects.
  • Work with SmartArt graphics, text effects, and page borders.
  • Check spelling and grammar.
  • Move and copy selections.
  • Insert, align, and draw tables.
  • Perform calculations in tables.
  • Format a one-page report.
  • Manage sources and control text flow.
  • Work newsletter columns.
  • Enhance paragraphs with dropped capitals, borders, and shading.
  • Use format painter, highlights, symbols, and quick parts.
  • Create letters and labels with mail merge.
  • Create forms and macros.
  • Protect documents.
  • Format web pages with Word.

Microsoft Excel

  • Add worksheet contents.
  • Format worksheets.
  • Work with ranges.
  • Create formulas
  • Copy and paste and move data
  • Create tables.
  • Work with named ranges.
  • Create the NOW function.
  • Create IF functions.
  • Create Text functions.
  • Freeze labels.
  • Use conditional formatting.
  • Use find and replace.
  • Rotate cell entries.
  • Work with multi-worksheet operations.
  • Build basic charts.
  • Format charts.
  • Compare and analyze data.
  • Work with hyperlinks.
  • Work with graphic.
  • Use advanced sorts.
  • Use advanced filtering.


Student Evaluation

The grading system for Computer Applications is based on total points. The assessments will be participation, classwork, homework, projects, and tests.


Attendance Policy

The attendance policy stated in the school’s handbook will be followed.


Classroom Expectations

  1. Arrive to class on time
  2. Be prepared
  3. Respect your classmates and teacher
  4. Give your all, all the time
  5. Be responsible for your actions
  6. No eating, drinking, cell phones, or iPods permitted in the classroom


Classroom Level Consequences

Students not following classroom/district rules may receive the following consequences from Mr. Shupe):

  • Verbal Warning                              
  • Change of seat assignment
  • Before or After School Detention


Class Requirements

If you are absent, it is YOUR responsibility to make up the assignments and/or tests when you return.  You may check the parental portal to check your grades and missing assignments.


Plagiarism, Cheating, and Academic Integrity

Plagiarism is the practice of copying words, sentences, images, or ideas for use in written or oral assessments without giving proper credit to the source. Cheating is defined as the giving or receiving of illegal help on anything that has been determined by the teacher to be an individual effort. Both are considered serious offenses and will significantly affect your course grade.



A combination of class discussion, teacher guided activities, independent activities, and tests will be used in this course. Grades will be determined by the satisfactory and timely completion of assignments. The grade of each assignment is based on the prerequisite given for each assignment. Below is an overview of topic/ units for this course. Please note these topics are subject to change.



  • Microsoft Office Basics
  • Microsoft Word
  • Microsoft Excel