Wednesday, October 1, 2014

Thursday, Oct 2nd- 8th Grade- Databases- Uses



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



Teacher:
Witkowski

Lesson/Unit Topic:
Databases- Uses

Standards:
DB-1 Know the use and purpose of a database



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can explain the advantages of a database.
TEST ON FRIDAY
Students can explain the advantages of a database.


Literacy/Vocabulary Strategies (Word Wall)
An advantage of a database is that it can add, delete, or edit data easily.
What are some advantages of a National Database
letting people know what cyber attacks have taken place?
Database page describing a
Bell-Ringer/Connecting Strategy
On page 31, type lines 5 and 6.
Remember to use your thumb for the space bar.
We are using our right INDEX finger for the B key.
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Practice:
@ Miss W will review for Friday’s test.

Guided Practice:

Who has the world's largest database?

The National Security Agency has the world's largest database.
The NSA's responsibilities include  "global monitoring, collection, decoding, translation and analysis of information and data for foreign intelligence and counterintelligence purposes." http://en.wikipedia.org/wiki/National_Security_Agency

Intelligence gathering has occurred throughout history.

World War II Code Breakers

New word "query"- A database query is a piece of code (a query) that is sent to a database in order to get information back from the database
NSA Deputy Director John C Inglis - How Does the NSA Save Lives?  
The NSA's DataBase and Who Uses It  (Until 3:40)

What are records and fields that NSA might use?
Amendment 4
The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized.

Independent Activity: @ In groups of 2 or 3 (two groups may have 3 people) students will read a paragraph from the article "N.S.A Gathers Data on Social Connections of U.S. Citizens" from http://www.nytimes.com/2013/09/29/us/nsa-examines-social-networks-of-us-citizens.html?pagewanted=all&_r=0 .
@ In their own words, students will write a 10 to 15 word sentence about what their paragraph is about and share with class.

@ Students will read the entire article and answer questions.

@ Students will create a Glogster about the NSA


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 the positives and the negatives about the NSA?
Student Technology/Differentiation
Students will create a glogster about the world’s largest database.
Closure Strategy
Exit Activity #9:


Exit Activity #10:
Choose home row and easy. Turn off sound.

Exit Activity #11: Database Test Questions
The first database test will be on these questions.
There are some questions we have not covered yet.
A feature that displays records that meet one or more specific
criteria is a filter/query.

Exit Activity#12:
CIA code breaking
Code breaking game

Exit Activity #13: Database terms

Exit Activity #14: Database terms

 



 


 

Thursday, Oct 2nd- 7th Grade- Spreadsheets- Formatting Charts and Understanding Functions



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




Teacher:
Witkowski

Lesson/Unit Topic:
Spreadsheets- functions (short cuts)

Standards:
SSB-1 Know the components of Spreadsheets
SSA-2 Create Charts and Graphs used in Business



“I Can…” Statement
Criteria for Success-Formative/Summative Assessments
I can format a chart.
I can understand why a function is a short cut.
TEST ON FRIDAY
Students format their car charts correctly.
Students understand why a function is a short cut.


Literacy/Vocabulary Strategies (Word Wall)
Functions- are short cuts. The computer types most of the  formulas for you.
This is what the function button looks like.
Matemáticas, Función, Símbolo
Bell-Ringer/Connecting Strategy
On page 31, type lines 5 and 6.
Remember to use your thumb for the space bar.
We are using our right INDEX finger for the B key.
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
Guided Lesson:  
@ Review for Friday’s test.
   Functions will NOT be on Friday’s test.

@Chart creation and formatting
  • hide the "miles" column
  • highlight your car lot data- model and price
  • Insert a column chart
  • click on the chart and the Chart Tools Tab will appear
  • We are going to look at the Design Tab.
  • Choose a chart style color.
  • We are going to  look at the Layout tab.
  • insert the chart title "My Car Lot". It will explain the chart's purpose.
  • insert horizontal axis title "model"
  • insert vertical axis title "price"
  • click on data labels and click on show
  • click on data table and click on show
  • change chart wall, go to more options and pick a fill color
  • change chart floor, go to more options and pick a different color
  • make sure you have gridlines they will make the plot area easier to read.
Open the Spreadsheet Vocabulary file
Slides 31 through 34 (formatting and formulas)

@ Open up the Spreadsheet Vocabulary PowerPoint file
slides 37 and 38 Understanding Functions (Shortcuts)
@ Function as a shortcut example
@ Miss W will review the Function handout
@Depending on time several functions examples will be completed.
***Students will open the payroll file and by using functions
        find the following information:
        the maximum hourly rate
        the minimum hourly rate
        the sum of the hourly rates
        the average of the hourly rates
@ Spreadsheet flashcard 32 calculates averages
@ Additional function practice as needed.

Independent Activity:
@ Complete the function practice worksheet.
@Complete Exit Activity by yourself without any help.

Homework:
Students need to decide for which ACADEMIC topic
(Typing Posture/Technique, Language Arts, Science,
Social Studies, or Math) they will create a
PowerPoint presentation soon. We will be using the
PowerPoint you create to learn different old and new
features of PowerPoint 2010.

Higher Order Thinking Questions
How do I format a chart?
How are functions short cuts?
Student Technology/Differentiation
Students will use Excel to understand charts and functions.
Closure Strategy

Exit Activity #7:

Exit Activity #8:
Choose home row and easy. Turn off sound.

Exit Activity #9:  Ribbon Vocabulary words
review words and definitions here http://quizlet.com/3089570/flashcards
then play activity here http://quizlet.com/3089570/scatter

We have not covered one question yet.
Built in calculations are called functions.
Horizontal is like laying down flat on the ground.
Vertical is up and down
You may use the Spreadsheet Vocabulary PowerPoint.
Play until you have won a million dollars