Name of course: Computer Applications (college credit)
Length of course: One year
Required/elective: Elective Grade level: 9-12
Instructor: Matt Schafer (matt_schafer@rsd.k12.or.us)
(503) 556-4215
Text used: Century 21 Computer Keyboarding, 8th ed.
Supplies needed: Textbook (will be maintained in the classroom), computer
OVERVIEW:
This course is an introduction to the Windows environment (WindowsXP) and its
applications using Microsoft Office 2007. Students will gain experience using
Microsoft Word 2007, Excel 2007, PowerPoint 2007, and possibly Access 2007.
Students will also use Alice to program in an interactive, 3D environment.
While learning the
keyboard, students are expected to learn the alphabetic keys to the degree they
are able to type by touch (with hands covered) using home row. They will also
have an introduction to the internet and HTML basics. Class will be built around
performance assessments and projects in all of the areas mentioned. Individual assignments
and tests will be assigned as needed. College credit may be available through
Clatsop Community College and/or Lower Columbia College for those who qualify.
COURSE CONTENT:
General Windows XP environment.
Keyboarding by touch (fingers covered).
Alphabet, number, symbol keys, and 10-key numeric keypad covered.
Business letters, memos, tables, reports, etc.
Microsoft Word 2007 (word processing).
Technical drawing (using Word 2007)
Microsoft Excel 2007 (spreadsheet).
Microsoft PowerPoint 2007. (electronic presentations).
Basic HTML and web design.
Programming with interactive 3D programming using Alice.
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.
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.
Copy paragraph material at a speed of not less than 30 words per minute
for three minutes with 5 or fewer errors.
Identify hardware components and parts of program screen; define software
and common word processing terms.
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 intents, numbered and bulleted lists.
Create, modify, format, and edit tables.
Proofread typed work, and identify typographical errors.
Use correct formatting for basic business documents
Create and Present electronic presentations in Microsoft PowerPoint
Create and manipulate data in Microsoft Excel
Grading scale:
100-90% = A Assignments (including projects)=50% of grade
89-80% = B Participation (daily points)=20% of grade
79-70% = C Quizzes/tests (individual or group)=30% of grade
69-60% = D
59% = F
Grading Policy:
Students are expected to be in class and hand in assignments on time. Students may turn
in assignments up to one week late for 70% (maximum) credit. After that, 50% (maximum)
credit may be earned up until the day before each grading period. (There are 8)
There will be two assignments each quarter, however, that will have an inflexible due date
and will not be accepted after the due date. I'll let you know what these are.
If you miss a test, you must make arrangements to make it up before the next test is given.
Extremely special circumstances will be handled on a case-by-case basis.
Absence Policy:
If a student is absent (excused) from class (parent/guardian must notify school),
he/she will have the number of days absent to make up the work. If the
absence is unexcused, the student will have the opportunity to make up the work,
but it will not be accepted for a grade. Your presence in this class is very
important. If a student is absent more than two days in a row, the parent/guardian
should call the school and request homework be sent to the office.
Pre-arranged absences due to school function or personal need should be announced
to the teacher at least two days in advance. The student is to turn in the
assignment immediately upon return or the assignment will be counted as late.