Computer Applications

2016-17

Name of course:Computer Applications

Length of course:One year

Required/elective:ElectiveGrade level: 9-12

Instructor:Matt Schafer ()

(503) 556-4215

Text used:Century 21 Computer Keyboarding, 8th ed.

OVERVIEW:

This course is an introduction to the Windows environment (Windows10) and its applications using Microsoft Office 2016. Students will gain experience using Microsoft Word, Excel, PowerPoint, and Access. Students may also learn some game design in Multi-Media Fusion as well as some HTML coding and Google Sketch up, time permitting. While learning thekeyboard, students are expected to learn the alphabetic and numeric keys to the degree they are able to type by touch using home row. Class will be built around performance assessments and projects in all of the areas mentioned.

College credit may be available Lower Columbia College and/or Clatsop Community College for those who receive an 84% or better.

COURSE CONTENT:

  • General Windows 10 environment.
  • Appropriate business behaviors, attitudes (accountability).
  • Keyboarding by touch (Alphabet, number, symbol keys, and 10-key numeric keypad.)
  • Keyboard covers are available upon request (not mandated)
  • Microsoft Word (word processing).
  • Business letters, memos, tables, reports, etc.
  • Microsoft Excel (spreadsheet).
  • Equations, graphs, pivot tables, lookup tables
  • Microsoft PowerPoint (Professional presentations).
  • Microsoft Access (relational data base).
  • Google Docs
  • Basic HTML5 and web design
  • Multi-Media Fusion/Games Factory 2
  • Google Sketch up

COURSE COMPETENCIES:

  • Operate the letter, number keys, and 10-key using correct fingering and

the touch method of typing including the “enter” and tab keys.

  • Copy paragraph material at a speed of not less than 30 words per minute

for three minutes with 5 or fewer errors.

  • Proofread typed work and identify typographical errors.
  • Identify parts of a computer and a computer keyboard.
  • Use correct spacing and punctuation marks, sentences, and abbreviations.
  • Identify hardware components and parts of program screen; define software

and common word processing terms.

  • Write simple macros.
  • Create, save, retrieve, edit and print documents.
  • Apply and remove character formatting, boldfacing, underlining, italics,

font changes.

  • Select and use line and format features: custom tab stops, alignment,

margin changes, centering, line spacing, page numbering headers/footers, footnotes,

and endnotes.

  • Use spelling, grammar, and thesaurus features.
  • Cut, Copy, past, and move text.
  • Use indents, numbered and bulleted lists.
  • Create, modify, format, and edit tables.
  • Use correct formatting for basic business documents.
  • Create and Present electronic presentations in Microsoft PowerPoint
  • Identify different application solutions to various challenges.
  • Understand how business technology influences people and procedures.
  • Be able to enter, edit, format, and print word processing documents such as business letters, memos, and reports.
  • Integrate database and spreadsheet functions with word processing functions.
  • Create and manipulate records within a database.
  • Create electronic spreadsheets and graphs (including lookup tables and pivot tables)
  • Develop skills for effective team building.
  • Develop research tools in effective career planning (Career Information System).
  • Develop an appreciation of how student actions affect the whole group.
  • Emphasize successful personal/professional behaviors and traits for the workplace.

GRADING POLICY

Student’s grades will be weighted as follows:

70% / Tests and major projects (summative assessments)
30% / Assignments and quizzes (formative assessments)

Formative assessments and summative projects maybe graded on the following scale:

4 / Exceeds (outstanding/above and beyond/handed in on time) 100%
3 / Meets (assignment requirements met) 85%
2 / Learning (haven’t quite met requirements) 65%
1 / Novice (beginner with little if any understanding of assignment) 50%
0 / No attempt made to complete assignment 0%

*Methods of scoring other summative tests are at the discretion of the teacher.

GRADE SCALE:

100-90% / A
89-80% / B
79-70% / C
69-60% / D
59% and below / F

*84% necessary for college credit if available

Formative assessments will be make up 30% of total grade while summative assessments will comprise the remaining 70%

If a student fails a summative assessment and wishes to retake it, they must complete all relevant formative assessments for that unit, regardless whether or not it is accepted for credit.

If a formative assessment is turned in after the due date, a maximum score of 2 will be given. If a summative assessment is late, a maximum score of 3 will be given. All student work is due the Friday before quarter 1, semester 1, quarter 3 and semester 2. After those Fridays work will not be accepted.

•quarter 1 (Oct. 28)

•semester 1 (Jan. 20)

•quarter 3 (March 31)

•semester 2 (June 9)-For seniors.

•after those Fridays work will not be accepted.

If a student is absent (excused), they have the number of days absent to make up the work. After that, a maximum of 3 may be earned on any assignment. If a student needs extra time to work on an assessment, arrangements may be made on an individual basis for a later assignment submission.

If a student is removed from a computer or desk due to failure to follow established rules and guidelines, the assessment may be turned in for no credit.