If you are an 8th grade student click here http://wclassroom.blogspot.com/2013/10/wed-oct-23-8th-grade-nsa-database.html
If you are a 7th grade students click here http://wclassroom.blogspot.com/2013/10/wed-oct-23-7th-grade-spreadsheets.html
Tuesday, October 22, 2013
Wed, Oct 23- 7th Grade- Spreadsheets- Relative Cell References
Bellringer:
1. Open your typing book to page 398
and type the paragraph "Create a Bar Chart"
2. Make up any number pad exercises 1-8 you are missing
http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
What are we learning?
4.0 Spreadsheet Basics and Formulas
4.1 Know the components of Spreadsheets
4.2 Creation and Formatting of Spreadsheets
4.3 Know spreadsheet operations
Guided Lesson:
Vocabulary test is on MONDAY
Introduction to Relative References Video http://www.youtube.com/watch?v=Wli4L_tECPg
Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folderthen- choco nutties file
Examples of Relative and Absolute References http://www.youtube.com/watch?v=PFOe0TKnAuE
Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folderthen- blooming bells nursery file
Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folder
then- rose variety file
Independent Activity:
Students will work individually to complete the Spreadsheet Ribbon worksheet
Exit Activity:
Work in groups of 2 or 3
http://www.quia.com/hm/174125.html
all words have been covered.
1. Open your typing book to page 398
and type the paragraph "Create a Bar Chart"
2. Make up any number pad exercises 1-8 you are missing
http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
What are we learning?
4.0 Spreadsheet Basics and Formulas
4.1 Know the components of Spreadsheets
4.2 Creation and Formatting of Spreadsheets
4.3 Know spreadsheet operations
Guided Lesson:
Vocabulary test is on MONDAY
Introduction to Relative References Video http://www.youtube.com/watch?v=Wli4L_tECPg
Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folderthen- choco nutties file
Examples of Relative and Absolute References http://www.youtube.com/watch?v=PFOe0TKnAuE
Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folderthen- blooming bells nursery file
Go to My Computer- then Student Docs- then Witkowski folder
then- Spreadsheet folder- then RELATIVE CELL REFERENCE folder
then- rose variety file
Independent Activity:
Students will work individually to complete the Spreadsheet Ribbon worksheet
Exit Activity:
Work in groups of 2 or 3
http://www.quia.com/hm/174125.html
all words have been covered.
Wed, Oct 23- 8th Grade- NSA Database Project Catch Up Day
Bellringer-
1. Open your NSA Glog and keep it minimized.
2. Finish your NSA Glog if not finished.
3. Check the NSA Glog RUBRIC to see if you have all items completed.
4. Type the answers to your ten NSA questions.
5. If you are missing the number pad 1- 8 exercises
Go to http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
6. Complete all missing work on board.
7. Practice with the Database Test Question Review
The first database test will be on these questions.
http://www.quia.com/rr/
8. Complete the spreadsheet cell reference candy challenge.
9. Reward time when Miss W confirms you have completed all tasks!
What are we learning?
Understand the basics of databases.
How is database information used, organized, and managed in business?
What formatting options are available when creating databases?
Guided Lesson:
Intelligence gathering has occurred throughout history.
The NSA uses "queries" (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. ) to meet its objectives of counterterrorism,
counterproliferation and cyber security. However, many people
question if gathering huge amounts of metadata without a
warrant violates our 4th Amendment rights. (The right of the people to be
secure in their persons, houses, papers, and effects, against unreasonable
searches and seizures)
Review NSA Database Project Rubric:
A visual look at how the NSA works https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3kwqiZTH2k3EGcDmSQPJ3_MWfoPtivy-1kGMdNpZXU9b4nLUTnj5-koertbf3kR2aHrbOAukY_uUN181z7IkuiJ0AqbmIIMNxfXlA6fC8eG-HLGmvqllduMx587aqZpUWGGBm91C2Vc_u/s1600/Google.png
A sample of a finished project http://misswitkowski.edu.
Independent Activity:
Go to http://edu.glogster.com/
In the upper right corner click the PINK log in box.
8th grade LOG-INS:
students first initial and last name followed by atms14.
EXAMPLE: uid: tmoseratms14 pw: 01011999
If a student has a "common" name (smith, jones, hill, bryant,etc)
Exit Activities: Database Test Questions
The first database test will be on these questions.
http://www.quia.com/rr/
There are some questions we covered today.
To put data in a particular order is to sort.
1. Open your NSA Glog and keep it minimized.
2. Finish your NSA Glog if not finished.
3. Check the NSA Glog RUBRIC to see if you have all items completed.
4. Type the answers to your ten NSA questions.
5. If you are missing the number pad 1- 8 exercises
Go to http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
6. Complete all missing work on board.
7. Practice with the Database Test Question Review
The first database test will be on these questions.
http://www.quia.com/rr/
8. Complete the spreadsheet cell reference candy challenge.
9. Reward time when Miss W confirms you have completed all tasks!
What are we learning?
Understand the basics of databases.
How is database information used, organized, and managed in business?
What formatting options are available when creating databases?
Guided Lesson:
Intelligence gathering has occurred throughout history.
The NSA uses "queries" (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. ) to meet its objectives of counterterrorism,
counterproliferation and cyber security. However, many people
question if gathering huge amounts of metadata without a
warrant violates our 4th Amendment rights. (The right of the people to be
secure in their persons, houses, papers, and effects, against unreasonable
searches and seizures)
Review NSA Database Project Rubric:
A visual look at how the NSA works https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3kwqiZTH2k3EGcDmSQPJ3_MWfoPtivy-1kGMdNpZXU9b4nLUTnj5-koertbf3kR2aHrbOAukY_uUN181z7IkuiJ0AqbmIIMNxfXlA6fC8eG-HLGmvqllduMx587aqZpUWGGBm91C2Vc_u/s1600/Google.png
A sample of a finished project http://misswitkowski.edu.
| NSA Glogster Rubric Criteria
Items that need to be on Glogster
|
Points
|
Grade
|
Your Name
|
5
| |
Spelling and Grammar
|
15
| |
Design Principles followed contrast, alignment, repetition,
white space, proximity, and balance |
10
| |
NSA National Security Agency definition
|
10
| |
Definition of either Counterterrorism OR counterproliferation
OR cybersecurity |
10
| |
5 different items that NSA can track you by. You must have picture and item’s name.
|
50
| |
Final Grade
| ||
Go to http://edu.glogster.com/
In the upper right corner click the PINK log in box.
8th grade LOG-INS:
students first initial and last name followed by atms14.
No spaces, dashes, etc. NOT YOUR NICKNAMES!
PASSWORDS:
are student birthdays again with no slashes, spaces, or dashes
in the mmddyyyy format.
EXAMPLE: uid: tmoseratms14 pw: 01011999
If a student has a "common" name (smith, jones, hill, bryant,etc)
they may need to use the first two letters of their first name.
When you are finished (Make sure your LAST NAME is NOT on Glog)
you will post your NSA Glog web address to edmodo.
and write one positive thing about the NSA and one area of concern.
you will post your NSA Glog web address to edmodo.
and write one positive thing about the NSA and one area of concern.
Exit Activities: Database Test Questions
The first database test will be on these questions.
http://www.quia.com/rr/
There are some questions we covered today.
Ascending is small to large, A-Z order.
Descending is large to small, Z-A order.
Two examples of connector words are OR and AND.
A feature that displays records that meet one or more specific
criteria or condition is called a filter or query.
Descending is large to small, Z-A order.
Two examples of connector words are OR and AND.
A feature that displays records that meet one or more specific
criteria or condition is called a filter or query.
CIA code breaking
Code 5 or 6 your choice
Monday, October 21, 2013
Tuesday, October 22 Short Cut Links
If you are an 8th grade student click here http://wclassroom.blogspot.com/2013/10/tuesday-oct-22-8th-grade-databases.html
If you are a 7th grade student click here http://wclassroom.blogspot.com/2013/10/tuesday-oct-22-7th-grade.html
If you are a 7th grade student click here http://wclassroom.blogspot.com/2013/10/tuesday-oct-22-7th-grade.html
Tuesday, Oct 22- 7th Grade- Default Alignment, AutoSum and AutoFill
Bellringer:
1. Open your typing book to page 365
and type the two SENTENCES
in the paragraph with the title
"Edit and Format Data"
2. Make up any number pad exercises 1-8 you are missing
http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
What are we learning?
4.0 Spreadsheet Basics and Formulas
4.1 Know the components of Spreadsheets
4.2 Creation and Formatting of Spreadsheets
4.3 Know spreadsheet operations
Guided Lesson:
Excel 2010 Autosum http://www.youtube.com/watch?v=1wnP9CVCEDk
Spreadsheet flashcard 32 calculates averages
Spreadsheet flashcard 6 alignment of data
Notice that the words(labels) are aligned to the left
and the numbers (values) are aligned to the right.
Default alignment is how the items will be if you do not format them.
Excel 2010 Autofill http://www.youtube.com/watch?v=l24ZjX1m3Y8
Independent Activity:
Students will work individually to complete the Spreadsheet Ribbon worksheet
Exit Activity:
Work in groups of 2 or 3
http://www.quia.com/hm/174125.html
there are a few words we have not covered yet
1. Open your typing book to page 365
and type the two SENTENCES
in the paragraph with the title
"Edit and Format Data"
2. Make up any number pad exercises 1-8 you are missing
http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
What are we learning?
4.0 Spreadsheet Basics and Formulas
4.1 Know the components of Spreadsheets
4.2 Creation and Formatting of Spreadsheets
4.3 Know spreadsheet operations
Guided Lesson:
Excel 2010 Autosum http://www.youtube.com/watch?v=1wnP9CVCEDk
Spreadsheet flashcard 32 calculates averages
Spreadsheet flashcard 6 alignment of data
Notice that the words(labels) are aligned to the left
and the numbers (values) are aligned to the right.
Default alignment is how the items will be if you do not format them.
Excel 2010 Autofill http://www.youtube.com/watch?v=l24ZjX1m3Y8
Independent Activity:
Students will work individually to complete the Spreadsheet Ribbon worksheet
Exit Activity:
Work in groups of 2 or 3
http://www.quia.com/hm/174125.html
there are a few words we have not covered yet
Tuesday, Oct 22- 8th Grade- Databases- Finishing Up NSA Project
Bellringer:
1. Look on the board if your name is on the board
work on the missing assignment. If you are missing the number pad 1- 8 exercises
Go to http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
2. On a new Word document
type your name and the answers to the ten NSA questions.
What are we learning?
Understand the basics of databases.
How is database information used, organized, and managed in business?
What formatting options are available when creating databases?
Guided Lesson:
Intelligence gathering has occurred throughout history.
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.
Queries can be saved. You can also "filter" information
in a database to find information that meets certain conditions,
such as all students, who are older than 13 years old.
Review NSA Database Project Rubric:
A visual look at how the NSA works https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3kwqiZTH2k3EGcDmSQPJ3_MWfoPtivy-1kGMdNpZXU9b4nLUTnj5-koertbf3kR2aHrbOAukY_uUN181z7IkuiJ0AqbmIIMNxfXlA6fC8eG-HLGmvqllduMx587aqZpUWGGBm91C2Vc_u/s1600/Google.png
A sample of a finished project http://misswitkowski.edu.
Independent Activity:
Go to http://edu.glogster.com/
In the upper right corner click the PINK log in box.
8th grade LOG-INS:
EXAMPLE: uid: tmoseratms14 pw: 01011999
If a student has a "common" name (smith, jones, hill, bryant,etc)
Exit Activities:
Database Test Questions
The first database test will be on these questions.
http://www.quia.com/rr/
There are some questions we covered today.
To put data in a particular order is to sort.
1. Look on the board if your name is on the board
work on the missing assignment. If you are missing the number pad 1- 8 exercises
Go to http://www.typeonline.co.uk/number_pad_big_plus_lesson4.html
2. On a new Word document
type your name and the answers to the ten NSA questions.
What are we learning?
Understand the basics of databases.
How is database information used, organized, and managed in business?
What formatting options are available when creating databases?
Guided Lesson:
Intelligence gathering has occurred throughout history.
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.
Queries can be saved. You can also "filter" information
in a database to find information that meets certain conditions,
such as all students, who are older than 13 years old.
Review NSA Database Project Rubric:
A visual look at how the NSA works https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3kwqiZTH2k3EGcDmSQPJ3_MWfoPtivy-1kGMdNpZXU9b4nLUTnj5-koertbf3kR2aHrbOAukY_uUN181z7IkuiJ0AqbmIIMNxfXlA6fC8eG-HLGmvqllduMx587aqZpUWGGBm91C2Vc_u/s1600/Google.png
A sample of a finished project http://misswitkowski.edu.
| NSA Glogster Rubric Criteria
Items that need to be on Glogster
|
Points
|
Grade
|
Your Name
|
5
| |
Spelling and Grammar
|
15
| |
Design Principles followed contrast, alignment, repetition,
white space, proximity, and balance |
10
| |
NSA National Security Agency definition
|
10
| |
Definition of either Counterterrorism OR counterproliferation
OR cybersecurity |
10
| |
5 different items that NSA can track you by. You must have picture and item’s name.
|
50
| |
Final Grade
| ||
Go to http://edu.glogster.com/
In the upper right corner click the PINK log in box.
8th grade LOG-INS:
students first initial and last name followed by atms14.
No spaces, dashes, etc. NOT YOUR NICKNAMES!
PASSWORDS:
are student birthdays again with no slashes, spaces, or dashes
in the mmddyyyy format.
EXAMPLE: uid: tmoseratms14 pw: 01011999
If a student has a "common" name (smith, jones, hill, bryant,etc)
they may need to use the first two letters of their first name.
When you are finished (Make sure your LAST NAME is NOT on Glog)
you will post your NSA Glog web address to edmodo.
and write one positive thing about the NSA and one area of concern.
you will post your NSA Glog web address to edmodo.
and write one positive thing about the NSA and one area of concern.
Exit Activities:
Database Test Questions
The first database test will be on these questions.
http://www.quia.com/rr/
There are some questions we covered today.
Ascending is small to large, A-Z order.
Descending is large to small, Z-A order.
Two examples of connector words are OR and AND.
A feature that displays records that meet one or more specific
criteria or condition is called a filter or query.
Descending is large to small, Z-A order.
Two examples of connector words are OR and AND.
A feature that displays records that meet one or more specific
criteria or condition is called a filter or query.
CIA code breaking
Code 4
Subscribe to:
Posts (Atom)