Miss Witkowski's Computer Science Discoveries Class

Monday, February 23, 2015

Wednesday, Feb. 25th- 8th Grade- Making a Database

	Archdale-Trinity Middle School Lesson Plan
Date: 02-25-2015

Teacher:

Witkowski

Lesson/Unit Topic:

Databases- Parts of a Database

Standards:

DB-1 Know the use and purpose of a database

“I Can…” Statement

Criteria for Success-Formative/Summative Assessments

I can explain what a database is and give an example of a database.

Students can give examples of databases.

Literacy/Vocabulary Strategies (Word Wall)

Database, Table, Field, Entry,

Record is a row of information about 1 subject

https://www.flickr.com/photos/shalf/10130225605/

Bell-Ringer/Connecting Strategy

1. On page 18, type lines 9 and 10.

Remember to use your thumb for the space bar.

We are using our right INDEX finger for the N key.

2. Students will gather data for their first database.

Lesson-Instructional Strategies & Procedures for Teacher and Students

(Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Lesson:

@ Students will complete online flashcards for the test items they missed.

@Students will create online flashcards at http://quizlet.com/

@ Access 2010: Introduction to Databases

http://www.youtube.com/watch?v=eXiCza050ug

Over 20,000 jobs in NC for a Database Manager
http://www.simplyhired.com/search?q=database+manager&l=North+Carolina

Over 740,000 jobs in the US for a Database Manager http://www.simplyhired.com/search?q=database+manager

@ Students will open in the DATABASE folder

the 1 Database Fundamentals PowerPoint

@ Students will open their practice database.

You must click on the word TABLE in the left column to open it.

@ Students will compete their database table.

@ Miss W will review slides 10 - 15

@Class will practice identifying records, fields, and entries.

Independent Activity:

@ If time: Students will participate in Database Bingo.

Homework- Extra Credit for 3rd test:

Ask your parents if they have a business card or

have one in their wallets from a business or

have a friend with a business card or the next

time you go into a business or they go into a

business see if they have a business card or

at home go to Google and then images and type

"business card" then print a business card.

If you give Miss W a business card sometime

this week you will get 5 points extra credit on

the second test. MUST be appropriate for school-

no alcohol, guns or bad words on cards.

MUST BE IN BY MONDAY

Higher Order Thinking Questions

What are examples of databases?

Student Technology/Differentiation

Students will create a database using Access.

Closure Strategy

Exit Activity #5:

Practice on the beginner level (#1 home row keys) at http://www.freetypinggame.net/play11.asp

Choose beginner if you are in the beginner category

Choose intermediate if you are in the average category

Click to turn off the sound.

Exit Activity #6:

Choose home row and easy. Turn off sound.

http://www.typingweb.com/tutor/games/play/game/23

Exit Activity #7:

We are practicing for accuracy not speed.

If you get less than 95% accuracy; retake practice.

http://www.typingweb.com/tutor/lesson/index/id/319/

Exit Activity #8:

Frog Game Home Row Keys http://www.freetypinggame.net/play3.asp

Exit Activity #9:

Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html

Wednesday, Feb. 25th- 7th Grade- Reviewing for Test & Learning Styles 10 Step Project

Archdale-Trinity Middle School

Lesson Plan

Date: 2-25-2015

Teacher:

Witkowski

Lesson/Unit Topic:

PowerPoint- 10 Step Learning Style Presentations

Standards:

PB-2 Procedure for developing a presentation

“I Can…” Statement

Criteria for Success-Formative/Summative Assessments

I can use the 10 steps for developing a presentation. 10 step test THURSDAY.
If snow, test will be on Friday.

Students remember presentation information during review.

Literacy/Vocabulary Strategies (Word Wall)

Step 4- Select a Design- Should be appropriate for the purpose of the presentation; use a template if desired. This floral design would be appropriate for a nature themed presentation.

http://pixabay.com/id/bunga-bunga-floral-design-flora-98164/

Bell-Ringer/Connecting Strategy

On page 18, type lines 9 and 10.

Remember to use your thumb for the space bar.

We are using our right INDEX finger for the N key

Lesson-Instructional Strategies & Procedures for Teacher and Students

(Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Practice:

Learning Styles Choices Lesson: I CAN EXPLAIN THE TEN STEPS.

Students will have the choice of working individually or in groups.

Students will need to choose one of the 10 steps presentation activities below to complete:

Project Rubric- Accuracy is worth 50 points, CREATIVITY is 40 points, EFFORT is 10 points.

1. Visual Learners: Draw a poster that includes pictures of the ten steps.

2. Visual/Kinesthetic Learners: Create Charades of the ten steps.

3. Audio Learners: Create a song/or rap about the ten steps.

4. Audio/Kinesthetic Learners: A narrator explains the ten steps while other students act them out.

5. Kinesthetic Learners: Create a “Simon says” game where they tell the class to do certain

                                     motions that signify the 10 steps.

6. Linguistic (Word Smart) Learners: Describe in words how you would make a video game of a

                                     students going through the 10 steps.

7. Linguistic (Word Smart) Learners: Write a funny story about a student using the 10 steps.

Independent Exercise:

@ Exit Activity 8

@ Exit Activity 9

@ Decide which study activity you want to do for the 10 steps

@ Typing assessment (class participation grade)

go to http://www.typingtest.com

@ Students will give present their 10 step activities

@ Exit Activity 3

@ Review for Thursday test (if snow, test will be on Friday)

Higher Order Thinking Questions

What are different design techniques that enhance a presentation?

Student Technology/Differentiation

Students will use PowerPoint to learn different presentation skills.

Closure Strategy

Exit Activity #3 Purpose of Presentation

A continuous loop is like our tv messages. It is a broadcast.

http://www.quia.com/rr/859688.html

Exit Activity #8: 10 steps Matching Game

http://www.quia.com/mc/2539313.html

Exit Activity #9: 10 steps create a picture game-

must complete picture within 2 attempts

http://www.quia.com/pp/279397.html

Exit Activity #10: Frog Game Home Row Keys http://www.freetypinggame.net/play3.asp

Saturday, February 14, 2015

Monday, February 23rd Short Cut Links

If you are a 7th Grade Student, click here: http://wclassroom.blogspot.com/2015/02/tuesday-feb-17th-7th-grade-10-steps-of.html

If you are a 8th Grade Student, click here: http://wclassroom.blogspot.com/2015/02/tuesday-feb-17th-8th-grade-what-is.html

Monday, Feb 23rd- 8th Grade- What is a Database?

Archdale-Trinity Middle School

Lesson Plan

Date: 02-23-2015

Teacher:

Witkowski

Lesson/Unit Topic:

Databases- Beginning Databases and Examples

Standards:

DB-1 Know the use and purpose of a database

“I Can…” Statement

Criteria for Success-Formative/Summative Assessments

I can explain what a database is and give an example of a database.

Students can give examples of databases.

Literacy/Vocabulary Strategies (Word Wall)

Database, Table, Record, Field, Entry

The iTunes Store is a database of music you can buy. A database holds a collection of information, in this case the information is songs for purchase.

http://en.wikipedia.org/wiki/ITunes

Bell-Ringer/Connecting Strategy

On page 17, type lines 5 and 6.

Remember to use your thumb for the space bar.

We are using our left INDEX finger for the T key.

Lesson-Instructional Strategies & Procedures for Teacher and Students

(Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Lesson:

@ Students will complete online flashcards for the test items they missed.

@Students will create online flashcards at http://quizlet.com/

@ Access 2010: Introduction to Databases

http://www.youtube.com/watch?v=eXiCza050ug

@ Students will open in the DATABASE folder

the 1 Database Fundamentals PowerPoint

Independent Activity:

@ Students will gather data for their first database.

@ If time: Students will participate in Database Bingo.

Homework- Extra Credit for 3rd test:

Ask your parents if they have a business card or

have one in their wallets from a business or

have a friend with a business card or the next

time you go into a business or they go into a

business see if they have a business card or

at home go to Google and then images and type

"business card" then print a business card.

If you give Miss W a business card sometime

this week you will get 5 points extra credit on

the second test. MUST be appropriate for school-

no alcohol, guns or bad words on cards.

MUST BE IN BY MONDAY

Higher Order Thinking Questions

What are examples of databases?

Student Technology/Differentiation

Students will create online flashcards at http://quizlet.com/

Closure Strategy

Exit Activity #5:

Practice on the beginner level (#1 home row keys) at http://www.freetypinggame.net/play11.asp

Choose beginner if you are in the beginner category

Choose intermediate if you are in the average category

Click to turn off the sound.

Exit Activity #6:

Choose home row and easy. Turn off sound.

http://www.typingweb.com/tutor/games/play/game/23

Exit Activity #7:

We are practicing for accuracy not speed.

If you get less than 95% accuracy; retake practice.

http://www.typingweb.com/tutor/lesson/index/id/319/

Exit Activity #8:

Frog Game Home Row Keys http://www.freetypinggame.net/play3.asp

Exit Activity #9:

Typing Adventure http://www.learninggamesforkids.com/keyboarding_games/keyboarding_games_typing_adventure1.html/