• Course Syllabus – Mr. Kanger (Room 107)

    Computer Applications 1 Full Year
    tkanger@tamaqua.k12.pa.us

    Course Description: Using the computer and Microsoft Office software, this course will include instruction on keyboarding, word processing, spreadsheets, database 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, Access, and PowerPoint.

    Objectives:

    Microsoft Word (Word Processing Software)

    Students will learn how to:

    • Create a document
    • Change the font and font size
    • Save and print a document
    • Use the spell check, thesaurus, and grammar features
    • Format paragraphs and characters and insert borders
    • Insert and resize clipart and watermarks
    • Utilize the Help Menu & use Wizards to produce a resume, calendar, and memo
    • Change margin settings, adjust line spacing, create headers & footers with page numbers and indent paragraphs
    • Use AutoCorrect, find and replace, and word count
    • Copy and paste text and utilize the drawing tools including WordArt
    • Navigate through an Internet hyperlink

    Internet Skills

    Students will learn how to:

    • Navigate through various websites
    • Research topics
    • Practice Internet safety

    Microsoft Excel (Spreadsheet Software)

    Students will learn how to:

    • Create, save and exit a worksheet
    • Use formulas, format, copy and print
    • Use functions, edit and print options
    • Perform additional formatting and editing; protecting and hiding data
    • Create charts and graphs
    • Change the format of numbers and characters in a cell
    • Add conditional formatting to a range of cells
    • Display and print the formulas version of the worksheet

    Microsoft Access (Database Software)

    Students will learn how to:

    • Create a database form and enter data
    • Create tables and enter data into those tables
    • Edit and print a table
    • Search and sort through a database
    • Perform queries and create reports

     

    Microsoft PowerPoint (Presentation Software)

    Students will learn how to:

    • Create, save and print a presentation
    • Enhance slides and work with text and objects
    • Present computer slide shows

    Integrated Projects:

    Students will learn how to:

    • Copy and paste a database report to a word processing document
    • Copy and paste database information to a spreadsheet to create charts
    • Copy and paste Microsoft Office applications within each other

    Textbook:

    Office 2007. Shelly, Cashman and Vermatt, Course Technology Thompson Learning, 2007. Cambridge, MA

    Evaluation: Tests (SAM and/or Production Tests)                         25%

                       Chapter Projects                                                     25%

                       Daily In-Class Assignments                                      40%

                       Timed Writings                                                        10%

                       Total                                                                    100%

                       Final grade will be determined by:

                                          Quarter grades                 80%

                                          Mid-Term grade (test)       10%

                                          Final grade (project)         10%

                                                                              100%

    Grading Scale:

    A = 93 to 100         C = 78 to 85

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

     

    Student Expectations:

    Attendance

    Follow Instructions

    Complete Class Assignments

    Prepare for testing

     

    Academic Detention:

    ·     Academic detention will be given to any student who is struggling in class academically or who is not doing as well as he or she should be as determined by the teacher, parents, or administration.

    ·     Academic detentions will be held from 2:30 pm. to 3:00 pm.  Students will be notified at least 24 hours prior to the detention so as to accommodate transportation after school if necessary.

    ·     Missing academic detentions is considered cutting and assigned area and will result in a Level I offense and progress as more are missed.  Parents will be notified in all cases of academic detentions.

     

    Conclusion:

    1.      You need this class to graduate from high school.

    2.      I will be excited to teach you all I know about how this class can help you.

    3.      You need to be responsible to pass this class.

    4.      I will treat you as you treat me.