Carmody Middle School 7th Grade Computer Career Lab

Clarisworks Database Management Instruction:

Academic Achievement, Skills & Teaching Standards Scorecard!


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

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

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

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

Not Attempted: no effort given. Zero points to 59 points.

For specific learning outcomes, please go to rubrics for daily assignments and final database project at: Daily Rubric and Final Project.

For detailed database/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. Presidents #1
15, 18, 22, 23. 24
Y/N
Y/N
Y/N
Y/N
2. Countries & Capitals of the World
2, 3, 4, 18, 22, 24
Y/N
Y/N
Y/N
Y/N
3. Denver Broncos Background
3,6,7,13,16, 18, 24
Y/N
Y/N
Y/N
Y/N
4. Rivers of the World
8, 11, 22, 24
Y/N
Y/N
Y/N
Y/N
5. Colorado Avalanche
8, 11, 22, 24
Y/N
Y/N
Y/N
Y/N
6. Inventors
8, 11, 22, 24
Y/N
Y/N
Y/N
Y/N
7. Colorado Rockies 8, 11, 22, 24 Y/N Y/N Y/N Y/N

8. Our Solar System

8, 11, 22, 24
Y/N
Y/N
Y/N
Y/N
9. Mountains of the World
8, 11, 22, 24
Y/N
Y/N
Y/N
Y/N
10. Colorado Rapids
8, 11, 22, 24
Y/N
Y/N
Y/N
Y/N
11. Presidents #2
8, 11, 22, 24
Y/N
Y/N
Y/N
Y/N
12. Construct Your Own Database
5, 9, 10, 13, 14, 15, 16, 17, 19, 20, 24
Y/N
Y/N
Y/N
Y/N

Total Score: _______ 2100 Possible Points

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


Database Management Skills Taught

1 - What is a field?
2 - What is a record?
3 - Search for data
4 - Entering text
5 - Changing layout
6 - Changing Font
7 - Changing font size
8 - Browse database
9 - Create a report
10- Editing a database
11- Finding text
12- Find & replacing text
13- Print a database
14- Create a new record
15- Create text fields
16- Create numeric fields
17- Create data fields
18- What is a database?
19- How to define a field?
20- Create a new layout
21- How many records in a database?
22- How to show all records
23- How to sort records
24- How to go to a specific record
25- How to duplicate a record
26- How to set page margins

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, 2002 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: