LEARN NC

K–12 teaching and learning · from the UNC School of Education

Learn more

Related pages

  • Books we've read: This lesson plan creates a classroom database collecting information on books that students have read over a period of time determined by the teacher and/or students. By sorting and filtering, students evaluate the data and can later create other products from their findings.
  • Periodic table database: These lessons are designed to help students use their computer skills to create their own database using teacher directions, and they also learn how to read the periodic table and understand what it means.
  • Integrated unit on South America: This lesson includes information concerning database operations, word processing, desktop publishing, and spreadsheet formatting. Students will solve math problems.

Related topics

Help

Please read our disclaimer for lesson plans.

Legal

The text of this page is copyright ©2008. See terms of use. Images and other media may be licensed separately; see captions for more information and read the fine print.

Learning outcomes

The learner will use technology to access, analyze, interpret, synthesize, apply, and communicate discipline information. Therefore, by using the Shark Net database, students become proactive in monitoring and controlling their own behaviors, as well as acquiring and utilizing skills in database operation.

Teacher planning

Time required for lesson

20 minutes

Materials/resources

Technology resources

  • One computer with printer
  • Microsoft Works

Pre-activities

Teacher will need to review Microsoft Works database basics

Activities

  1. Teacher will need to create a database including the following fields: first name, last name, date, block, problem code, comments by students, time-out, time-in. In the header, the teacher will place his or her name and the name of this discipline record. Since we are the Shark Team, we call ours the Shark Net. In the footer the teacher will place the code key so it may be viewed any time a student prints a report.
  2. Any time a student breaks a rule, must leave the classroom, or does outstanding work, the teacher indicates to the student the need to enter the net by saying “Net.” When giving an outstanding, the teacher would say “Outstanding net.”
  3. When a student enters the net they type the following: first name, last name, date, block, code, and any comments he/she may have. If the student leaves the room he/she enters the net and includes time-out and time-in. Students are not allowed to respond out loud to the directions “Sign the net.” If the student desires to respond, it must be done in the comment field.
  4. If a student enters the net twice in one period for a negative code (1, 3, 4, 5, 6, or 7), he/she must pick up a student behavior journal sheet and go to another designated teacher’s classroom and fill out the sheet. After completing the sheet, the student may return.
  5. If a student enters the net a third time in one period for a negative code, the student goes to the designated teacher’s room to finish the class period. At a designated time, the teaching team meets with the student to create an action plan to help the student function successfully in class. Also, the parent is notified of the problem and the plan.
  6. At two-week intervals, students filter their records to calculate a class participation grade. Codes 1, 3, 4, 5, 6, and 7 result in a 10 point reduction, code 2 does not affect the grade, while code 8 raises a grade 20 points. Each student starts with 100 points. The codes and what they stand for are as follows:
  1. No homework
  2. Bathroom
  3. No effort
  4. Talking without permission
  5. Disrespect
  6. Tardy
  7. Other
  8. Outstanding

Assessment

Students start each nine weeks with 100 points. Negative nets result in a 10 point reduction and outstanding nets result in a 20 point addition. Totals are calculated at the end of the nine weeks to determine class participation grades (no grades higher than 100 points are allowed). Class participation counts 10% toward final nine week grades. Also, filtered reports generated at progress report, conferences, and report card time count as classwork grades.

North Carolina Curriculum Alignment

Computer Technology Skills (2005)

Grade 6

  • Goal 1: The learner will understand important issues of a technology-based society and will exhibit ethical behavior in the use of computer and other technologies.
    • Objective 1.06: Identify and use database terms/concepts (e.g., reports, layout, format) to describe and explain findings. Strand - Database
  • Goal 3: The learner will use a variety of technologies to access, analyze, interpret, synthesize, apply, and communicate information.
    • Objective 3.04: Use database sort and search/filter strategies to organize, analyze, interpret, and evaluate findings in content areas and cite sources. Strand - Database

Grade 7

  • Goal 1: The learner will understand important issues of a technology-based society and will exhibit ethical behavior in the use of computer and other technologies.
    • Objective 1.06: Demonstrate knowledge of why databases are used to collect, organize, and report information in a variety of settings. Strand - Database
    • Objective 1.07: Use knowledge of database terms/concepts, functions, and operations to describe and explain content area findings. Strand - Database
  • Goal 3: The learner will use a variety of technologies to access, analyze, interpret, synthesize, apply, and communicate information.
    • Objective 3.03: Modify/edit databases to organize, analyze, interpret data, and create reports (e.g., documents, multimedia project, webpages). Strand - Database

Grade 8

  • Goal 1: The learner will understand important issues of a technology-based society and will exhibit ethical behavior in the use of computer and other technologies.
    • Objective 1.07: Use knowledge of database terms/concepts, functions, and operations to explain strategies used to organize, analyze, and report information in content area assignments. Strand - Database
  • Goal 2: The learner will demonstrate knowledge and skills in the use of computer and other technologies.
    • Objective 2.02: Modify/create and use databases to organize, report, and display data. Strand - Database
  • Goal 3: Select and use a variety of technology tools to collect, analyze, and present information. Strand - Societal/Ethical Issues
    • Objective 3.03: Modify/create and use databases to analyze, interpret, and evaluate data and report findings. Strand - Database

Guidance (2001)

Grade 6–8

  • Goal 1: Acquire the attitudes, knowledge and skills that contribute to effective learning in school and across the life span.