Semester Computer Applications 1

  • Semester Computer Applications 1

    Course Syllabus – Mr. Kanger (Room 107)
    tkanger@tamaqua.k12.pa.us

    Objectives:

    Using the computer and Microsoft Office software, this course will include instruction on keyboarding, word processing, spreadsheets, and presentation software. It will also include Internet activities. Students will be able to use these skills for their personal use, for assignments required in other classes, and for future secondary education and/or workplace activities.

    Course Goal: To learn computer application skills in Word, Excel, and PowerPoint.

     Curriculum for the Semester course (18 weeks) will be:

    1. Microsoft Word
      Module One: Creating, Formatting, and Editing a Word Document with a Picture
    2. Module Two: Creating a Research Paper with References and Sources
      3. Module Three: Creating a Business Letter with a Letterhead and Table
    3. Microsoft Excel
      Module One: Creating a Worksheet and a Chart
      2. Module Two: Formulas, Functions, and Formatting
      3. Module Three: Working with Large Worksheets, Charting, and What-if-Analysis
    4. Microsoft PowerPoint
      Module One: Creating and Editing a Presentation with Pictures
      2. Module Two:  Enhancing a Presentation with Pictures, Shapes, and WordArt
      3. Module Three: Reusing a Presentation and Adding Media and Animation
    5. The course final will be a project final

    Culminating project that tests skills in Microsoft Word, Excel, and PowerPoint
    Approximate Timeline for Completion

    Week 1

    Word Module One Instruction & Tutorial

    Week 2

    Word Module One Activities & Module Testing

    Week 3

    Word Module Two Instruction & Tutorial

    Week 4

    Word Module Two Activities & Module Testing

    Week 5

    Word Module Three Instruction & Tutorial

    Week 6

    Word Module Three Activities, Module Testing, & Unit Testing

    Week 7

    Excel Module One Instruction & Tutorial

    Week 8

    Excel Module One Activities & Module Testing

    Week 9

    Excel Module Two Instruction & Tutorial

    Week 10

    Excel Module Two Activities, Module Testing, & Unit Testing

    Week 11

    Excel Module Three Instruction & Tutorial

    Week 12

    Excel Module Three Activities, Module Testing, & Unit Testing

    Week 13

    PowerPoint Module One and Two Instruction & Tutorial

    Week 14

    PowerPoint Module Two Activities & Module Testing

    Week 15

    PowerPoint Module Three Instruction & Tutorial

    Week 16

    PowerPoint Module Three Activities, Module Testing, & Unit Testing

    Week 17

    Word, Excel, and PowerPoint Review/Reinforcement Activities

    Week 18

    Word, Excel, and PowerPoint Final Project (comprehensive, culminating)

    Biweekly

    Timed Writings/Keyboarding assessments will be completed on a biweekly basis.

     Evaluation: Production Tests                                                     25%

                       Chapter Projects                                                      25%

                       Daily In-Class Assignments                                       40%

                       Timed Writings                                                         10%

                       Total                                                                    100%

                        Final grade will be determined by:

                                          Quarter grades (2*40%)                       80%

                                          Final grade (project)                             20%

                                                                                                  100%

    Grading Scale:

    A = 93 to 100         C = 78 to 85

    B = 86 to 92           D = 70 to 77          F = 0 to 69