Carmody Middle School 7th Grade Computer Career Lab

Clarisworks Spreadsheet Instruction:

Academic Achievement, Skills & Teaching Standards Scorecard!

Non-Compliant: multiple problems in typos, formatting errors, spelling, grammar, did not follow directions. Zero points to 69 points.

Basic: Few mechanical errors in typos, formatting, spelling, grammar and did follow directions. 70 points to 79 points.

Above Average: no major mechanical errors in typos, formatting, spelling, grammar and did follow directions. 80 to 89 points.

Outstanding: exemplary creativeness in visual layout plus no mechanical errors in typos, formatting, spelling, grammar and did follow directions. 90 to 100 points.

Preliminary Pen Pal Letter: Completion has few mechanical errors in typos, formatting, spelling, grammar and did follow directions, zero to 100 points based on non compliant, basic, above average and outstanding work.

Final Pen Pal Letter: zero to 300 points based on non compliant, basic, above average and outstanding work.

For detailed word processing grading expectations, please go to: http://www.kuzmich.com/carmody/Assignment_Error_Summary.html

Lessons:
Skill(s) Taught
Non-Compliant
Basic
Above
Outstanding
1. Introduction Spreadsheet
1, 2, 3, 4, 5, 6,11, 12, 18, 21, 14, 15, 16, 17
Y/N
Y/N
Y/N
Y/N

2. First Spreadsheet
1, 2,3,4, 5, 6,11, 12, 18, 21, 14, 15, 16, 17, 18
Y/N
Y/N
Y/N
Y/N
3. Two-Three Day Spreadsheet
1, 2,3, 4,5,6,11, 12, 18, 21, 14, 15, 16, 17, 18, 19, 20
Y/N
Y/N
Y/N
Y/N
4. Family Budget Spreadsheet
8, 9, 22
Y/N
Y/N
Y/N
Y/N
6. Food Storage Spreadsheet
8, 9, 22
Y/N
Y/N
Y/N
Y/N
7.Final Spreadsheet Project
22, 23, 24, 25, 27
Y/N
Y/N
Y/N
Y/N

Total Score: _______ 900 Possible Points

Scale:
90 - 100 = A
80 - 89 = B
70 - 79 = C
60 - 69 = D
Below 69 = F

Database Skills Taught

1 - What is a spreadsheet?
2 - What is a cell?
3 - Cell address
4 - Entry bar
5 - Row
6 - Column
7 - Changing font size
8 - Formulas (Addition)
9 - Formulas (Subtraction)
10- Formulas (Division)
11- Formuilas (Multiplying)
12- Formulas (Average)
13- Formulas (Square Root)
14- Formulas Displayed
15- Formulas Not Displayed
16- Text Cells
17- Number Cells
18- Adjust column width?
19- Adjust numbers to currency
20- Adjust numbers to fixed decimals
21- How to print reports
22- How to copy formulas
23- How to set page margins
24- Underlining text
25- Undo command
26- Bold text
27- Using the help files

Student Name: _________________________________________ Period ___ Team ___

National Teaching Standards & Goals Taught from Curriculum Skills

Content areas of instruction that are covered in all 7th Grade Computer Class taught by Dr. Data fall, 1999 semester include the following benchmarks and evaluation.

Benchmarks----------------------------------Evaluation---------------------------------------------

Students will be able to type faster than they can handwrite with a pencil or pen. Students will possess a minimum competency of 10 words per minute or faster over a time period of 4 minutes with a high degree of accuracy of 80%. Students will be tested both for handwriting and typing and posted to gradebook.

Students will possess a minimum competency of 10 words per minute or faster over a time period of 4 minutes with a high degree of accuracy of 80%. Students will be tested both for handwriting and typing and posted to gradebook.

Students will be video typed to illustrate the coordination and concentration in which the home row is evident and with excessive eye contact with the keyboard.

Word processing with the following concepts learned: Undo command, indenting text, centering text, finding and changing text, spelling checker, thesaurus, outline, cut and paste, copy and pasting, justification, adding graphics, inserting date, making multiple columns, saving files, opening file, printing a document, editing a document and adding color to word processing. Teach all designated standards content/goals on a daily basis. Completed assignments equate to standards. Projects for all units of instruction are given to further evaluate standards taught and mastered. 80% of standards content/goals will be mastered by all students.

Database management concepts learned: define fields, search for data, change layout and browse database.

Teach all designated standards content/goals on a daily basis. Completed assignments equate to standards. Projects for all units of instruction are given to further evaluate standards taught and mastered. 80% of standards content/goals will be mastered by all students.
Spreadsheet concepts learned: labels, raw data,
formulas (add, subtract, divide, multiply divide, average, and square root).		 Teach all designated standards content/goals on a daily basis. Completed assignments equate to standards. Projects for all units of instruction are given to further evaluate standards taught and mastered. 80% of standards content/goals will be mastered by all students.

Internet concepts learned: finding URL's, surfing via search engines with compound searches as well, understanding a web browser and e-mail.

Teach all designated standards content/goals on a daily basis. Completed assignments equate to standards. Projects for all units of instruction are given to further evaluate standards taught and mastered. 80% of standards content/goals will be mastered by all students.

Multimedia instructional concepts learned: designing newsletters, PowerPoint Multimedia Slideshow presentations and web pages for the Internet.

Teach all designated standards content/goals on a daily basis. Completed assignments equate to standards. Projects for all units of instruction are given to further evaluate standards taught and mastered. 80% of standards content/goals will be mastered by all students.

Painting and drawing concepts learned: editing,
formatting, arranging and transforming art work.

Teach all designated standards content/goals on a daily basis. Completed assignments equate to standards. Final projects for all units of instruction are given to further evaluate standards taught and mastered. 80% of standards content/goals will be mastered by all students
Music concepts learned: creating rhythm section music with drum-set, bass, keyboard and guitar, changing musical styles, tempo, adding an improvised solo, constructing a musical composition with chords, designing chord symbols. Teach all designated standards content/goals on a daily basis. Completed assignments equate to standards. Final projects for all units of instruction are given to further evaluate standards taught and mastered. 80% of standards content/goals will be mastered by all students.
Designing computer games learned: adding animation and special sound effects while designing a computer game in which the student structures it to include number of players, scoring, theme, and more ingredients. Teach all designated standards content/goals on a
daily basis. Completed assignments equate to standards. Final projects for all units of instruction are given to further evaluate standards taught and mastered. 80% of standards content/goals will be mastered by all students.

Go Back to EssentialsWeb Page: