If you are a 7th Grade Student, click here: http://wclassroom.blogspot.com/2015/03/wednesday-april-1st-7th-grade.html?_sm_au_=iVVvSSqVHFfrfQRT
If you are a 8th Grade Student, click here: http://wclassroom.blogspot.com/2015/03/wednesday-april-1st-8th-grade-database.html?_sm_au_=iVVvSSqVHFfrfQRT
Tuesday, March 31, 2015
Wednesday, April 1st- 8th Grade- Database- Data Types versus Field Properties
s
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 04-01-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Databases- Using an input mask
| |
Standards:
|
DB-2 Know Data Types associated with a database
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can use an input mask.
|
Students use input masks.
|
Literacy/Vocabulary Strategies (Word Wall)
|
An input mask FORCES an user to put the data into the database in a certain way.
It helps to cut down mistakes.
https://www.flickr.com/photos/fstorr/6512990915/
|
Bell-Ringer/Connecting Strategy
|
On page 71, type lines 05 and 06.
We are using our left INDEX finger for the 4 key.
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
@ Students will open their INN database.
@ Student will get out their Data Type or Field Properties? worksheets.
@ Data Type and Field Properties PowerPoint
Is it a data type or a field property? candy review
@ The Wonderful Wizards of Access - Part 2 - Using the Input Mask A http://www.youtube.com/watch?v=fBlT1KrQUsY
Start at 1 minute and end at 4 minutes .
@ Open the Field Property- Input Mask PowerPoint in the Database folder.
@ Go to your INN database.
@ Miss W will walk you through setting up a phone number input mask.
@ Miss W will show you a 2nd way to get to the Design View (right click on table name.)
Independent Exercise:
@ Students will create a zip code input mask.
@ Students will make the following notes:
Today’s Notes:
on the first page
Number- used for data that may be calculated or sorted
on the second page
at the top of the page write:
Record- a group of related fields of information
Memo- like text, but maximum of 64,000 characters
Lookup wizard- allows you to create a finite (limited) set of choices for that field’s entry values.
at the bottom of the page write:
Entry- data and formulas keyed in a field
@ Students will use study guide to solve data type crossword puzzle http://worksheets.theteacherscorner.net/puzzle/cw-PXtIPiL/
Monday’s Notes:
Yes/No is also a true/false field. will contain a check box yes/ no. Default is no.
Text includes words and/or numbers not used in calculations.
Currency monetary values
Input mask a format often applied to dates, time and zip codes.
at the bottom of the page write:
Field- one item of information in a record. represented by a column.
|
Higher Order Thinking Questions
|
Why would you want to use an input mask in your database?
|
Student Technology/Differentiation
|
Students use Access to add an input mask to their database.
|
Closure Strategy
|
Lesson Reflections
|
Wednesday, April 1st- 7th Grade- Practicing with Functions
 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 04-01-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Spreadsheets-
Functions- built in calculation shortcuts | |
Standards:
|
SSB-1 Know the components of spreadsheets
SSB-3 Know spreadsheet operations
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can use a function.
|
Students use functions to get answers.
|
Literacy/Vocabulary Strategies (Word Wall)
|
What if we had 30 years of data and we wanted to find the
highest or MAXIMUM number in the data? We could look at
thousands of numbers or we could use the MAX function.
http://en.wikipedia.org/wiki/Solar_maximum
|
Bell-Ringer/Connecting Strategy
|
On page 71, type lines 05 and 06.
We are using our left INDEX finger for the 4 key.
|
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
|
Guided Lesson:
=F2+F3+F4+F5
=Sum(F2:F5)
It is important to understand the parts of a function (equals sign, function name, parentheses, beginning of the range, colon, ending of the range and parentheses).
Open the Understanding Functions Word document
Open up the "Functions goes with youtube" file.
Excel 2010 Tutorial- Functions
1 min to 3 min Functions
3 mins to 4:30 mins Range
4:30 mins to 8:30 mins Practice
Stop at Count function at 8:30 mins
Open the Spreadsheet Vocabulary file
Slides 35 through 41 (functions)
Open up the Hurricane file.
Class practice of Hurricane sheet using functions
We are going to practice inserting the following FUNCTIONS or shortcuts:
Sum- adds all of the numbers in a range
Max- finds the largest number in a range
Min- finds the lowest number in a range
Average- calculates the average of a range of numbers
Count- counts the numbers of entries in a range
Independent Activity:
@ Spreadsheet flashcard 32 calculates averages
@ Additional function practice as needed.
@ Students will critique Educational PowerPoint presentations.
|
Higher Order Thinking Questions
|
When and how should you use a function?
|
Student Technology/Differentiation
|
Students will use Excel to understand functions.
|
Closure Strategy
|
Exit Activity #8:
Exit Activity #9:
Choose home row and easy. Turn off sound.
Exit Activity#10:
Working in pairs and using the PINK Study Guide answer the questions.
These will be the next test questions.
|
Monday, March 30, 2015
Tuesday, March 31st- CTE Career Day for BOTH 7th Grade and 8th Grade
1. Bellringer- LOOK IN TYPING BOOK- on page 63 type lines 8 and lines 9
2. Click on http://www.careeroutlook.us/table.php?state=NC&cluster=sci&interest=all
2. Click on http://www.careeroutlook.us/table.php?state=NC&cluster=sci&interest=all
- Choose 6 careers from the Science, Technology, Engineering and Math page.
- Fill in your worksheet for the following categories:
Occupation
|
Minimum
Education
|
Growth
Outlook
|
Current
Workers
|
Salary
Entry
|
Job Description
|
You only need to write the first sentence in the job description blank.
- Choose one of the 6 careers and create a PowerPoint.
# The first slide should have your name and occupation and a picture with a citation.
# Look at the ENTIRE job description. Have one or more slide for each sentence.
You may copy and paste job description sentences.
# You need at least 6 slides including the title page.
# Find interesting pictures about that occupation and have one picture per slide with
the proper citations.
# Save to your lunch number.
If the link for the job description does not work use Google to get the job description.
If the link for the job description does not work use Google to get the job description.
Subscribe to:
Posts (Atom)