Tuesday, May 5, 2015

Wednesday, May 6th- 7th Grade- Writing IF functions

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 05-06-2015
Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheet- Writing IF 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 write an IF function.
Students can write IF functions.
Literacy/Vocabulary Strategies (Word Wall)

The IF function helps the computer answer true or false questions.
File:IF-THEN-ELSE-END

Bell-Ringer/Connecting Strategy

We are learning the numeric keypad.
Your  index finger on the 1
Your middle finger on the 2
Your ring finger on the 3
Your ring finger on the . period key.

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 Practice:
@ Miss W will review IF statements
@ LISTEN before you color!
@ Students will highlight the =IF and () and , in yellow
                will  underline the logical test (what you are looking for) in red
                will underline the if true statement in green and
                will underline the if false statement in blue.
                   
Independent Exercise:
@ Students will complete the Practice with IF statements on page 13.
Remember words need to have quotation marks around them AND
    all formulas and functions start with an equal sign.
    For example: =IF(A5="Carrot","Vegetable","Amphibian")
@ Students are WRITING the if statements on their paper.

If we have time-
@ Students will enter the if statements in our spreadsheet.
@ Students will answer questions on the spreadsheet crossword puzzle.




Higher Order Thinking Questions

How does an IF function work? Why?

Student Technology/Differentiation

Students will use Excel 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






Posted by at 6 comments:

Monday, May 4, 2015

Tuesday, May 5th Short Cut Links

If you are a 7th Grade Student, click here:   http://wclassroom.blogspot.com/2015/05/tuesday-may-5th-7th-grade-spreadsheet.html?_sm_au_=iVVf3wHjFk26f1R6


If you are a 8th Grade Student, click here:   http://wclassroom.blogspot.com/2015/05/tuesday-may-5th-8th-grade-databases.html?_sm_au_=iVVf3wHjFk26f1R6
Posted by at No comments:

Tuesday, May 5th- 8th Grade- Databases- Importing Data

Interlocking AT.jpg
Archdale-Trinity Middle School
Lesson Plan
 
Date: 05-05-2015
Teacher:
Witkowski

Lesson/Unit Topic:
Database-  Advance filtering and Importing Text

Standards:
DB-3 Demonstrate the management of a database



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can import text into a database.
Students will import text into a database.
Literacy/Vocabulary Strategies (Word Wall)
Importing means bringing an item in from an outside source.
This map shows countries that import oil.
countries by oil imports
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.

Guided Lesson:
@ Students will open 9 Independent Practice Filtering and Sorting a Database WORD document.
@ Miss W will show the class how to get the answers to 8 and 9.

IMPORTANT NOTICE!
You must close the database first before you close the access file.
You must click on the inside “x” before you click on the outside “x”
If you don’t close following the above instructions, it will freeze the program.

@ Open the Importing Text Files PowerPoint
@ Students will import text data into a database using an existing file.
@ Miss W will show students how to import data to a database
by saving as a plain text file. Name your Database Class.
@ Remember to save as a plain text file, NO spaces between the commas.
@ We will be using the External Data Tab (Ribbon).
@ In the Import and Link group, we will be clicking on the Text File button.
@ Students will need to Rename the fields, either by going to Design view
or using the menu option.
@ Open and Save the School Information file to your lunch number.

Independent Exercise:
@ Students will import text data into a database using their own data.
@ Name your database and table SCHOOLS
@ Name, Ownership, Type, Enrollment, InState, OutofState
    are your field names.
@ Every field is text except InState,  and OutofState they are currency.
@ If you do it correctly you will not need to type dollar signs.
@  If you make a mistake on the field names or type, go to the Design view to correct it.

If time:
Guided Lesson:
@ Miss W will explain the difference between a one-to-one database
Database Design 13 - One-to-Many Relationships
until minute 2

Database Design (Family example) https://www.youtube.com/watch?v=P_nhBKs25DQ
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.
@ Save to the Database folder then the DB Relationship Project folder.
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)


Higher Order Thinking Questions
Why do they call it importing data?  
Student Technology/Differentiation
Students use Access to import data into a database.
Closure Strategy
Exit Activity #14:
Words that are new:
Report- display data in a custom format
Field selector- the box containing the field name
Lesson Reflections


Posted by at No comments:
Subscribe to: Posts (Atom)