Tuesday, December 2, 2014

Wednesday, Dec 3rd- 7th Grade- Spreadsheets- Count and Count A functions

*
Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 12-03-2014



Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheet- Count and Count A functions

Standards:
SSB-1 Know the components of Spreadsheets
SSB-2 Know Spreadsheet operations



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can create  Count and Count A  functions.
Students can create Count and Count A  functions.


Literacy/Vocabulary Strategies (Word Wall)

To find a function, click the down arrow next to the Autosum button,
Click on “More functions”
Type in the name of the function you are looking for and click GO.
Then click OK.
Insert Function Dialog Box

Bell-Ringer/Connecting Strategy

We are learning the numeric keypad.
Your thumb goes on the 0 at the bottom
  • The right index finger will control the 1 key.
  • The right middle finger will control the 2 key.
  • The right ring finger will control the 3 and . keys.


The daily bellringers will now be practicing the number pad
Choose exercise 1 and then click on the word "start."
Time will not start until you put your cursor
in the white rectangle and start typing.
Record your typing speed and accuracy in your typing file.

Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Lesson:
@ Students will review instructions.

Independent Exercise

@ Open the count and count a practice file.
@ Use the count and counta functions.
@ Use the count if (the range is their names) function.
@ Use the sum, max, min and average functions.
@ Student will write definitions for validated and nonvalidated functions
and any other definitions they have not completed..



Higher Order Thinking Questions

Why is the IF function needed in video games?

Student Technology/Differentiation

Students will use animation to create IF functions.

Closure Strategy

Exit Activity 11: Spreadsheet Review
2 items you may have forgotten:
Absolute value- is when you need cells to remain the same when copied
# means the column is too narrow and you need to make it wider to see the data

 






Monday, December 1, 2014

Tuesday, December 2nd Short Cut Links

If you are a 7th Grade student click here http://www.wclassroom.blogspot.com/2014/12/tuesday-dec-2nd-7th-grade-spreadsheet.html

If you are a 8th Grade student click here http://www.wclassroom.blogspot.com/2014/12/tuesday-dec-2nd-8th-grade-database.html

Tuesday, Dec. 2nd- 8th Grade- Database Relationships


Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 12-02-2014



Teacher:
Witkowski

Lesson/Unit Topic:
Database-  Relationship vocabulary

Standards:
DB-3 Demonstrate the management of a database



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can tell the difference between a one-to-one database and a one-to-many database.
Students can tell the difference between a one-to-one database and a one-to-many database.
Literacy/Vocabulary Strategies (Word Wall)
A good example of a one to many database relationship is Netflix
or the International Movie database http://www.imdb.com/ .
There is only ONE movie named The Last Airbender however
you can click on MANY links such as “director” or “cast”.
Netflix members rated The Last
Bell-Ringer/Connecting Strategy

We are learning the numeric keypad.

Your thumb goes on the 0 at the bottom.
Your  index finger on the 4
Your middle finger on the 5
Your ring finger on the 6
Your pinky will hit the plus sign +
The daily bellringers will now be practicing the number pad
Choose exercise 2 and then click on the word "start."


Guided Lesson:
@ Miss W will explain the difference between a one-to-one database
    and a one-to-many database.

Database Design 13 - One-to-Many Relationships
until minute 2

Primary and Foreign Keys https://www.youtube.com/watch?v=8vKjhuQj0gk


Independent Exercise:
@ Using the movie of their choice at http://www.imdb.com/  
    students will create a visual definition of the following vocabulary words:
    one-to-one database,    
    one-to-many database,
     primary key,
     foreign key,
     and join line.
Use the database relationship definition sheet.
Rubric:
10 points Your Name
10 points definition of one-to-one database used correctly.
10 points definition of one-to-many database used correctly. 
10 points definition of primary key used correctly.
10 points definition of foreign key used correctly.
10 points definition of join lines used correctly.
10 points spelling and grammar.
10 points for citation (may use one citation if you get all images from imdb)
10 points for using text boxes
10 points for creativity (having pictures of movie, stars, director and design elements- white space, balance, alignment, repetition, contrast
                      and proximity/unity)
@ Save to the Database folder then the DB Relationship Project folder.

@ Students will open their Inn database.
@ Students will open 9 Independent Practice Filtering and Sorting a Database.
@ Students will open their Word filter file. 
@ Students will screen print their answers for questions 1 to 7 to their filter file.
@ Students will  crop their answers so they are readable. 
@ Students will save the file to their lunch number. 

Higher Order Thinking Questions
What is the difference between a one-to-one database and a one-to-many database?
Student Technology/Differentiation
Students will use a Word document and the online IMDB database to create a visual definition of different database relationship vocabulary words.
Closure Strategy
Exit Activity #14: Database relationships

Tuesday, Dec 2nd- 7th Grade- Spreadsheet Functions- VLOOKUP

*
Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 12-02-2014



Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheet- VLookup function

Standards:
SSB-1 Know the components of Spreadsheets
SSB-2 Know Spreadsheet operations



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can create a VLookup function.
Students can create a VLookup function.


Literacy/Vocabulary Strategies (Word Wall)

“In basic terms, VLOOKUP is used to look up a value from a different location in your workbook. It’s useful because when dealing with large amounts of data because you always need to look things up.”
http://www.trackpal.co.uk/blog/vlookup-for-beginners/
vlookup - company demo

Bell-Ringer/Connecting Strategy

We are learning the numeric keypad.
Your thumb goes on the 0 at the bottom
Your  index finger on the 4
Your middle finger on the 5
Your ring finger on the 6
Your pinky will hit the plus sign +

The daily bellringers will now be practicing the number pad
Choose exercise 2 and then click on the word "start."
Time will not start until you put your cursor
in the white rectangle and start typing.
Record your typing speed and accuracy in your typing file.

Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)

Guided Lesson:
@ Students will write out the LIST definition.
Independent Exercise
@ In pairs, one student will open the VLookup file and one student will click on
the instruction link.
@ Open up the VLookup file.
@ Students will complete a VLookup function as the teacher demonstrates the process.
@ Student will write the definitions for Lookup and VLookup
 
@ Students will write out the VLookup definition.
 
@ Open the count and count a practice file.
@ Use the count and counta functions.
@ Use the count if (the range is their names) function.
@ Use the sum, max, min and average functions.
@ Student will write definitions for validated and nonvalidated functions.
 
 

If time: Students will practice the IF function.


Higher Order Thinking Questions

Why is the IF function needed in video games?

Student Technology/Differentiation

Students will use animation to create IF functions.

Closure Strategy

Exit Activity 11: Spreadsheet Review
2 items you may have forgotten:
Absolute value- is when you need cells to remain the same when copied
# means the column is too narrow and you need to make it wider to see the data

 






Monday, December 1st Short Cut Links

If you are a 7th Grade student click here http://wclassroom.blogspot.com/2014/12/monday-dec1st-7th-grade-spreadsheets.html?_sm_au_=iVVDqJDjrZMF5ksP

If you are a 8th Grade student click here http://wclassroom.blogspot.com/2014/12/monday-dec-1st-8th-grade-databases-sort.html?_sm_au_=iVVDqJDjrZMF5ksP