(14 Days of Instruction)
By Dr. John Kuzmich, Jr.
October to November for first semester and March to April for second semester classes
| Introduction | Daily Assignments | On-Line Database Assignments | Clarisworks Instructions | Extra-Credit
Introduction to the Database Unit
The first eleven assignments with Clarisworks involves using their database capabilities. Each assignment requires a separate printed worksheet. Assignments can not be done at home because students must have access to the Clariworks database on school computers and Dr. Data's database files.
As an introduction to database management, there are three essential parts of a database. One: a file represents a collection of information represents a given topic, such as the following assignments listed below. Two, a series of individual records about a given topic which form a database file. There are many records that comprise a given data file. Three, a series of fields or bits of information that comprise one record. A telephone book is a simple illustration of database for the information is organized by companies and contains related information about the company such as: address, city, state, telephone number, zip code and related services. The database file assignments are as follows: Please do them in the following order. Note: Fridays will be typing test day and makeup day for missing assignments.
On-line tutorial for learning ClarisWorks database at:
Clarisworks Database Management of Twelve Daily Assignments:
See rubric for daily assignments and final project guidelines at: http://www.kuzmich.com/carmody/dailyrubric.html
Note: all assignment and their respective clue sheets have a security lock with a required password. Dr. Data will provide passwords to student for student use only. All instruction material is copyrighted and can only be printed and not copied and pasted.
Clue sheets are provided because students will need to see how database searches are conducted in a step-by-step process with all answers provided. Students who can do the assignments without using the clue sheet, will be awarded 200 points per assignment rather than the standard 100 points. Note: Fridays are generally a makeup day for students to do missing, unsubmitted assisgnments plus usually we have two typing tests required every Friday.
Directions for finding the daily database files so you can open them up for doing the daily searching.
Two Levels of Learning and Earning Credit for Daily Database Assignments
One: Students are do use a cue sheet designated to demonstrate and guide the student in learning how to search a database in a step-by-step manner. Each level-one database assignment is worth 100 points.
Two: Students are to complete the database worksheets without using a cue sheet to demonstrate their mastery of searching a database. Each level-two database assignment is worth 200 points.
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
Specific Daily Assignments with General Learning Objectives
For the Specific Twenty-Six Database Concepts and Objectives Taught Within Each Daily Assignment:
Go to: http://www.kuzmich.com/carmody/Scorecard_DB.html
Presidents #1 Worksheet - assignment #1 - C-3. Special clue sheet available with not only the answers, but more importantly, specific steps in learning how to use a database to search for the correct answers: President No. 1 Clue Sheet. Learning objective: After completing this lesson, the student will be able to search for data in a database by choosing the field to be search. Name of the data file to be opened up in Clarisworks is: "Pres.cwk."
Extra-Credit Assignments:
Scrabble a photo of Dr. Data into
order for 25 points. Simply print it out and submit to Dr. Data, President's
Worksheet #2, Denver Nugget Player Background, Birds, Zoos of the World,
Denver Broncos Statistics,
and Denver Nugget Statistics.
Each extra-credit assignment completed is worth 25 extra-credit points. 500
points will be awarded to any student who can develop a good clue sheet for
the Denver Nugget Player Background, Birds and Zoos of the World.
On-Line Database Assignments for Home Use
The link for the instant web publishing for your class databases. http://www.adlineagency.com/kuzmich. Use the following account information and you have access to all of the database assignments that can be done at home. You do not have to have Clarisworks or Appleworks on your home computer in order to do the assignments on your home computer.
Account Name: john (be sure lower case for j in
John)
Password: drdata (be sure it is lower case)
Go to layout to find specific database file to work on. Thisi on-line database works just like Clarisworks or Appleworks on our PC lab computers.
Good luck!
Dr, Data
ClarisWorks Data Base Operating Instructions