Monthly Archives: February 2016

In The Beginning Life Was Simple

In the Beginning, life was simple
But
Our information needs
Kept growing. (The Spider web)
Purpose
To explore and discuss the purpose and principles of data warehousing.

So What Is a Data Warehouse?
Definition: A data warehouse is the data repository of an enterprise. It is generally used for research and decision support.
By comparison: an OLTP (on-line transaction processor) or operational system is used to deal with the everyday running of one aspect of an enterprise.
OLTP systems are usually designed independently of each other and it is difficult for them to share information.
Why Do We Need Data Warehouses?
Consolidation of information resources
Improved query performance
Separate research and decision support functions from the operational systems
Foundation for data mining, data visualization, advanced reporting and OLAP tools
What Is a Data Warehouse Used for?
Knowledge discovery
Making consolidated reports
Finding relationships and correlations
Data mining
Examples
Banks identifying credit risks
Insurance companies searching for fraud
Medical research

Goals
Structure
Size
Performance optimization
Technologies used
Comparison Chart of Database Types
Design Differences
Star Schema
Supporting a Complete Solution
Data Warehouses, Data Marts, and Operational Data Stores
Data Warehouse -The queryable source of data in the enterprise. It is comprised of the union of all of its constituent data marts.
Data Mart -A logical subset of the complete data warehouse. Often viewed as a restriction of the data warehouse to a single business process or to a group of related business processes targeted toward a particular business group.
Operational Data Store (ODS) -A point of integration for operational systems that developed independent of each other. Since an ODS supports day to day operations, it needs to be continually updated.

Building a Data Warehouse
Analysis
Design
Import data
Install front-end tools
Test and deploy
Stage 1: Analysis
Identify:
Target Questions
Data needs
Timeliness of data
Granularity
Create an enterprise-level data dictionary
Dimensional analysis
Identify facts and dimensions
Stage 2: Design
Star schema
Data Transformation
Aggregates
Pre-calculated Values
HW/SW Architecture
Dimensional Modeling

Fact Table -The primary table in a dimensional model that is meant to contain measurements of the business.
Dimension Table -One of a set of companion tables to a fact table. Most dimension tables contain many textual attributes that are the basis for constraining and grouping within data warehouse queries.
Stage 3: Import Data
Identify data sources
Extract the needed data from existing systems to a data staging area
Transform and Clean the data
Resolve data type conflicts
Resolve naming and key conflicts
Remove, correct, or flag bad data
Conform Dimensions
Load the data into the warehouse
Importing Data Into the Warehouse
Stage 4: Install Front-end Tools
Reporting tools
Data mining tools
GIS
Etc.
Stage 5: Test and Deploy
Usability tests
Software installation
User training
Performance tweaking based on usage
Special Concerns
Time and expense
Managing the complexity
Update procedures and maintenance
Changes to source systems over time
Changes to data needs over time

Goals of the STORET Central Warehouse
Improved performance and faster data retrieval
Ability to produce larger reports
Ability to provide more data query options
Streamlined application navigation
Old Web Application Flow
Central Warehouse Application Flow
Web Application Demo
STORET Central Warehouse -Potential Future Enhancements
More query functionality
Additional report types
Web Services
Additional source systems?
Data Warehouse Components
Data Warehouse Components -Detailed

Let S Compare Our Definitions

The Abbott Secondary Education Initiative focuses on three key areas for grades 6-12.
Smaller organizational structures
Academic Rigor
Personalization
The Abbott Secondary Education Initiative focuses on three key areas for grades 6-12.
Smaller organizational structures
Academic Rigor
Personalization

These challenges are more acute in urban and rural districts.
In addition, students from non-English-speaking backgrounds face additional challenges as they attempt to adjust to American schools and excel academically.
SIOP
A research based
Sheltered Instruction Observation Protocol
What Students Need to Learn: Language and Content
ESL Standards
What to Teach

How to Teach What Students Need
SIOP

Content Area Standards
What to Teach

Comprehensible Input
Is one of the main components that distinguishes effective sheltered instruction from high-quality nonsheltered instruction.
Is important and should be measured throughout the lesson to ensure that students are taking in and understanding what is being communicated to them.
Comprehensible Input Section of the SIOP
4 3 2 1 0 N/A
10. Speech appropriate Speech sometimes Speech inappropriate
for students’ inappropriate for for students’ proficiency
proficiency level students’ proficiency level
(i.e. slower rate, level
enunciation, and simple
sentence structure for
beginners
11. Explanation of Explanation of academic Explanation of academic
academic tasks tasks somewhat clear tasks unclear
clear
12. Uses a variety of Uses some techniques Uses few or no techniques
techniques to make to make content concepts to make content concepts
content concepts clear clear clear
(i.e. modeling,
visuals, hands-on
activities, demonstrations,
gestures, body language)
Speaking the Same Language

One of the keys to transferring information is to be able to develop a common language.
AXIS
CHORD
POWER
PRODUCT
RANGE
SOLUTION
YARD

Let’ s Compare Our Definitions
AXIS
AXIS
Health: second vertebra in neck: the second vertebra in the neck, which acts as the pivot on which the head and first vertebra turn
Agriculture: central part of plant: the main part of a plant, usually the stem and the root, from which all subsidiary parts develop
Geometry: one of two or more lines on which coordinates are measured. Often on a graph two axis form its left and lower margins.
CHORD
CHORD
Construction: horizontal connecting part: the horizontal part of a truss designed to absorb tension, for example, in a roof.
Mathematics: A segment whose endpoints are points on a circle.
POWER
POWER
Transportation: electricity: electricity made available for use.
Transportation: measure of rate of doing work: a measure of the rate of doing work or transferring energy, usually expressed in terms of wattage or horsepower. 
Transportation: energy to drive machinery: energy or force used to drive machinery or produce electricity.
POWER Continued
Mathematics: number of multiplications: the number of times a quantity is to be successively multiplied by itself, usually written as a small number to the right of and above the quantity.
PRODUCT
PRODUCT
Business: company’ s goods or services:¬†the goods or services produced by a company.
Mathematics: result of multiplying: the result of the multiplication of two or more quantities.
RANGE
RANGE
Transportation: distance traveled without refueling: the farthest distance that a vehicle or aircraft can travel without refueling.
Agriculture: open land for grazing farm animals: a large area of open land on which farm animals can graze. 
Construction: north-south strip of townships: a north-south strip of townships six miles square and numbered east and west from a meridian in a U.S. public land survey.
RANGE Continued
Mathematics: set of values: the set of values that can be taken by a function or a variable.
Statistics: extent of frequency distribution: the difference between the smallest and the largest value in a frequency distribution.
SOLUTION
SOLUTION
Health: fluid with substance dissolved in it: a substance consisting of two or more substances mixed together and uniformly dispersed, most commonly the result of dissolving a solid, fluid, or gas in a liquid. It is also, however, possible to form a solution by dissolving a gas or solid in a solid or one gas in another gas.
Mathematics: value satisfying an equation: a value for a variable that satisfies an equation.
YARD
YARD
Business: Slang for one billion dollars. Used particularly in currency trading, e.g. for Japanese yen since on billion yen only equals approximately US$10 million. It is clearer to say, ” I’m a buyer of a yard of yen,” than to say, “I’m a buyer of a billion yen,” which could be misheard as, “I’m a buyer of a million yen.
Agriculture: livestock enclosure: an enclosed area of land for livestock.
YARD Continued
Agriculture: land around a house: the area of land immediately surrounding a house, often covered with grass or landscaping. 
Agriculture: winter grazing area: an area of land where deer, moose, or other animals graze in winter.
Mathematics: imperial unit of length: a unit of length equal to 0.9144 m (3 ft).
Identifying Levels of Second Language Acquisition
It is very important that teachers determine the English language acquisition levels of their students.
Once this is ascertained, teachers can make content comprehensible based on the language needs of each student.
Teachers can also encourage students to increase their English proficiency by providing activities and opportunities for them to frequently use English.
The following seven stages of language acquisition are fluid: that is, students do not move in concrete steps from one stage to another.
Beginning (Pre-Production)
Students have little comprehension of oral and written English, and they are unable to produce much if any oral or written English at this point.

Teachers should provide abundant listening opportunities, use many physical gestures and movement to convey meaning, and include a great deal of context for shared reading and writing.
Beginning (Early Production)
Students have limited English comprehension but they can now give one or two word oral responses.

For students learning to read English, teachers can use predictable and patterned books and encourage them to label and manipulate pictures or fill in contextualized sentences.
Beginning (Early Speech Emergence)
Students speak in simple sentence and can comprehend highly contextualized oral and written information.

Teachers can expect students to respond to simple open-ended questions.
They should continue to provide sufficient language development opportunities and include many activities that require students to read, write, listen, and speak.
Intermediate (Early)
Students have some proficiency in communicating simple ideas.
They have comprehension of contextualized information.

Teachers can encourage these students to expand on simple responses while developing critical thinking skills.
Intermediate
Students have proficiency in communicating ideas and they can comprehend contextualized information in English.

Teachers should provide explicit instruction in figurative language, making predictions, using text features to read a book, and English grammar.
These students can participate in generative activities that promote higher levels of thinking.
Early Advanced
Students can communicate well and have adequate vocabulary to achieve academically.
They have a good comprehension of information.

Teachers should provide for a variety of realistic writing and speaking opportunities.
These students can be exposed to activities to further practice critical thinking skills.
Advanced
Students have near native speech fluency and expanded vocabulary to achieve academically.
They have good comprehension of information in English.
These students can lead group discussions, and they should be given the opportunity to do presentations and have many opportunities to produce oral and written forms of communication.
Numerous studies reveal that a knowledge of mathematics vocabulary directly affects achievement in arithmetic particularly problem solving .
Common sense tells us that as more words can be used in a meaningful manner, the easier it becomes to communicate effectively.
Today, we are going to look at some techniques we can use in our mathematics classrooms to make content concepts clear.
Today, we are going to look at some techniques we can use in our mathematics classrooms to make content concepts clear.
Alternate Materials
Use many materials to make content comprehensible to students.
The more variation you find, the better you will be able to connect with different students’ learning styles and backgrounds.

Let’ s look at an alternate way to teach the geometry concepts of:
Point
Line
Plane
Visualizing a 3-Dimensional Space page 8
Materials:
3 Index Cards (per person)
Hole Punch
Scotch Tape
Uncooked spaghetti (one per person)
Visualizing a 3-Dimensional Space page 8
Materials:
3 Index Cards (per person)
Hole Punch
Scotch Tape
Uncooked spaghetti (one per person)
Visualizing a 3-Dimensional Space
Directions:
1. Punch a hole in each index card. Label the holes F, G, and H.
2. Tape the three index cards together to form a corner (i.e. two adjacent walls and a ceiling).
3. Draw a line through F. Label this line l.
4. Put a piece of spaghetti through holes F and G.
Visualizing a 3-Dimensional Space
What do the holes represent?
What does the spaghetti represent?
What do the index cards represent?
How many points do line l and the spaghetti have in common?
Visualizing a 3-Dimensional Space
Draw a line on the same index card as l in such a way that it will not have any points in common with line l, even though both lines continue forever. Label this line m.

How many lines can you draw that will satisfy this condition?
Visualizing a 3-Dimensional Space
Draw a line on an index card that does not contain line l in such a way that it will not have any points in common with the other lines, even though they continue forever. Label this line x.

How many lines can you draw that will satisfy this condition?
Visualizing a 3-Dimensional Space
Draw a line that is completely contained in two index cards. Label this line n.

How many lines can you draw like this using the same two index cards?
Visualizing a 3-Dimensional Space
Use your model to create each of the following situations, if possible.

A line and a plane with exactly one point in common.
A line and a plane with exactly two points in common.
A line and a plane with exactly no points in common.
Vocabulary Activities
As teachers we often think of vocabulary cards for review.
However, they can also be used to introduce or frontload vocabulary at the beginning of a lesson.
This process helps students build background knowledge and increases comprehension of the lesson or unit they will be studying.
Visual Boxing
Word Problems (Math Connection)
The teacher gives students a list of vocabulary words from the chapter.

Then the students, working either independently or in pairs, use two or three of the vocabulary words to create a word problem which can then be solved by other class members.
Word Problem Example
Sum Plus First
Total Add Next
Altogether More
Addition How Many
Vocabulary Notebook
Students will create and maintain a notebook specifically for mathematic vocabulary words.

The notebook will include the word, the textbook or dictionary definition, the student’ s own definition, and an example.

This notebook can be used as reference throughout the course.
Vocabulary Notebook Example
Net:
A two-dimensional pattern you can form into a three-dimensional figure.
A pattern for making a box, can, pyramid or other object. You cut it out and fold it.

Vocabulary Cards
One side of the card is reserved for the term/concept word and illustration.

The drawing is a visual clue that is significant for the student making the card, and will help trigger the meaning of the word.

The definition of the word is written on the reverse side of the card.

A sentence that uses the word in a rich context may also be included.
Vocabulary Cards Example
Vocabulary Cards
Incorporate the use of the vocabulary cards in your lessons.

Use the cards as a reference for class discussions, spelling and/or meanings.

Develop review or word games that require the use of the cards.

If you have a word wall, include words from the vocabulary cards.
Connect Two
Students need to be able to see connections between the various concepts they are learning about in mathematics. This is extremely important for vertical alignment as well as for horizontal alignment.

Once students have their vocabulary for the unit, ask them to choose two words from their list.

Students will then make connections with the two mathematical words they have chosen.

This may be done as a written paper or a page with words and graphics as illustrations.
Connect Two Example
Data Set Data Value Mode Mean
Median Outlier Measure of Central Tendency
Graphic Organizer: Concept Mapping
Graphic organizers are a way for students to make connections between concepts and vocabulary words.
There are 5 basic steps to follow
Graphic Organizer: Concept Mapping
Step 1: Students write down as many different words as they can that relate to a word the teacher gives them.
Step 2: Students work in small groups. Each group must sort the cards they just created into at least 4 different categories.
Step 3: Students check to see if they put their cards into appropriate categories.
Step 4: The teacher leads the class in a discussion of the categories the students decided on and create a class concept map on the board.
Step 5: The teacher then recreates the class map on a worksheet and gives each student a copy of the map. The students then adjust and refine their maps as they learn more about the concept.
Graphic Organizer: Concept Mapping
Every Student Gets a Chance
The teacher writes a new concept or idea on the board and reads it aloud.
He or she then asks for a volunteer to read aloud what was written.
Then, instead of moving on to another concept or example, the teacher asks for a second volunteer to read aloud the same information.
This continues so that each student who feels comfortable can choose to read the information aloud.
Every Student Gets a Chance
Students who are at beginning levels of English proficiency will feel more comfortable repeating information after they have heard it spoken by each of their classmates.

In this activity, students are hearing the same input over and over from other students, rather then from the teacher.

Thus they hear other pronunciations, inflections, and intonations.
Every Student Gets a Chance
This activity is very effective for teaching, practicing, and reinforcing a concept such as place value and reading large numbers, and for helping students remember important definitions and vocabulary.
Every Student Gets a Chance
For example, English learners need to learn the words million, thousand, hundred, and tens and ones in order to read the number
196,325,704
Teach students to identify the numbers in their sets of three:
196 (one hundred ninety six) million
325 (three hundred twenty five) thousand
704 (seven hundred four)
Recognition of a working mathematics vocabulary is very important. Students must be able to translate words into their appropriate mathematical symbols .
It is important that you specifically teach mathematics word lists and vocabulary. The student who can recognize a mathematical operation when described through multiple words or phrases can translate these words into a meaningful number sentence and perform the requisite computation.
Because mathematics has its own unique vocabulary, you, the math teacher, must teach vocabulary explicitly.
Use slower speech, clear enunciation, controlled vocabulary, syntax, and sentence length.
Pose questions and design tasks that engage students in higher-level thinking. Ask students to justify ideas orally and in writing.
Tips for Teachers
Insist that students use correct mathematical vocabulary in their explanations (when developmentally appropriate).
Make sure students are familiar with the terms used in the New Jersey Core Content Standards.

Make a conscious effort to focus on Comprehensible Input.
Implement at least one of the strategies we discussed today in your classroom this year.
Remember that students at lower levels of English proficiency are not necessarily functioning at lower levels of cognitive ability. Frequently, these students are able to use higher level thinking skills in their primary language but have a more difficult time understanding the academic content and expressing their knowledge in English.
Thank you for coming!
If you have any questions, please feel free to contact me.
Betsy Urschel
burschel@shermanisd.net
Word Wall
Display of vocabulary/concept words.

Always place the words on a specific wall area, so students will know to refer to this site for the current vocabulary.

When new terms are introduced, move the old words to a different location where they are still accessible.

Have students, periodically, read the wall for review.
Word Wall Example

Risk Ranking And Filtering And Its Role In Risk Management

Risk Ranking and Filtering and Its Role in Risk Management
H. Gregg Claycamp, Ph.D., CHP
Center for Veterinary Medicine
July 21, 2004

Risk is a Concept
Risk is intuitive and familiar to everyone, yet it can be sophisticated and elusive when organizations seek definitions of risk for specific risk management programs.

Risk Management
Risk assessment is not a single process, but a systematic approach to organizing and analysing scientific knowledge and information that supports a risk decision. NRC (1994)

Risk management is a systematic process for the identification, assessment, control and communication of risks to life, property, or other valued objects.

Premises
As a broad concept, risk inherently has many possible meanings depending on the individual or organization.

Any effort as complex in scope as the FDA’ s risk initiative necessarily defines risk at different contextual levels and can do so without departure from the mission to reduce, manage or control risk to public health.
Levels of Risk Management
Multiple Levels of Risk Management
As used here,
high-level refers to broadly-based, general and principle-driven approaches.
low-level refers to detailed, specific and discipline-driven approaches.
There is a hierarchy in processes and systems.
Risk Ranking and Filtering is a high-level approach (or process).
Examples

Sources of Risk from a Medical Product
Sources of Risk from a Medical Product
Dual Impact of Quality Systems
Risk Tools Supporting Quality Systems
Risk Tools for High-Level Prioritization Among Many Products
Risk Questions and Tools Change With the Level of Analysis
Low level: Risk questions focus on identifying and characterizing risks to drug quality for specific drug products or within a specific products classes.
Quantitative and qualitative tools available.
Analysis-driven.

High level: Risk questions focus on how risks within different drug/product classes compare with each other.
Risk analysis tools are essentially customized for each application.
Principle-driven.
Low-Level Example
Low Level Modeling (Fault Tree Analysis)
Faults/Pathways Magnified N-fold for a Simple Manufacturing Process!
Why Use High-Level Systems Methods in Risk Management?
Low-level approaches are elegant and capture details, but may miss interactions and relevance across systems.
Complex quantitative models may convey a level of precision and understanding about the system that is unjustified.
Different levels of understanding and quantification may exist for each sub-component of the system. High-level methods seek optimal use of diverse kinds of information to inform risk decisions.
High-Level Models for Risk Management
Systems approaches/thinking
Risk management of complex systems is
Multi-objective
Multi-decision maker
Hierarchical (overlapped)
Sometimes conflicted/confounded
Complex systems exceed human capacity to capture everything in a simple model.

High-Level Risk Management Begins With Brainstorming (HHM)
A High-Level Approach
Drilling Down to Sources of Risk for Model Building
Systematically Developing the Low-Level Details
Sometimes, Only Qualitative Information is Available for a Specific Product or Process
High-Level Combinations of Severity and Probability
Risk Ranking & Filtering (e.g., Haimes, 1998)
Filtering: Policy Meets Risk Management
The Filtering in RRF
Once risks/hazards are ranked a filter may be used to reflect resources limitations and/or programmatic goals.
Filters are policy-derived. For example,
Selecting worst N (or X%) of risks across all organizational units; versus
Selecting worst M (or Y%) of risks for the entire organization.
Filters may have a risk, resource, or other bases, each possibly imparting differential effects on the final ranking of risks for mitigation.
Example: Next slide

Using RRF Results: Filtering
RRF in the Risk Analysis Cycle

Risk management and decision-making are all about [confronting probabilities] and where the balance between measurement and gut becomes the focal point of the whole story.

(P.L. Bernstein, 1996, Against the Gods:
The Remarkable Story of Risk p. 56)

– Identifying The Business Definitions

Modeling the Data Warehouse
Chapter 7
Data Warehouse Database Design Phases
Defining the business model (conceptual model)
Creating the dimensional model (logical model)
Modeling summaries
Creating the physical model
Performing Strategic Analysis
Creating the Business Model
Phase 1: Defining the Business Model
Performing strategic analysis
Creating the business (conceptual)model
– Defining business requirements
– Identifying the business measures
– Identifying the dimensions
– Identifying the grain
– Identifying the business definitions
and rules
– Verifying data sources
Creating the Business Model
Performing strategic analysis
Creating the business (conceptual) model
– Defining business requirements
– Identifying the business measures
– Identifying the dimensions
– Identifying the grain
– Identifying the business definitions
and rules
– Verifying data sources

Business Requirements Drive the Design Process
Identifying Measures and Dimensions
Determining Granularity
Identifying Business Rules
Creating the Dimensional Model
Identify fact tables
– Translate business measures into fact tables
– Analyze source system information for
additional measures
– Identify base and derived measures
– Document additivity of measures
Identify dimension tables
Link fact tables to the dimension tables
Create views for users

Dimension Tables
Dimension tables have the following characteristics:
Contain textual information that represents the attributes of the business
Contain relatively static data
Are joined to a fact table through a foreign key reference
Fact Tables
Fact tables have the following characteristics:
Contain numeric measures (metric) of the business
May contain summarized (aggregated) data
May contain date-stamped data
Are typically additive
Have key value that is typically a concatenated key composed of the primary keys of the dimensions
Joined to dimension tables through foreign keys that reference primary keys in the dimension tables

Star Schema Model
Central fact table
Radiating dimensions
Denormalized model
Star Schema Model
Easy for users to understand
Fast response to queries
Simple metadata
Supported by many front end tools
Less robust to change
Slower to build
Does not support history

Snowflake Schema Model
Snowflake Schema Model
Direct use by some tools
More flexible to change
Provides for speedier data loading
May become large and unmanageable
Degrades query performance
More complex metadata
Using Summary Data
Phase 3: Modeling summaries
Provides fast access to precomputed data
Reduces use of I/O, CPU, and memory
Is distilled from source systems and precalculated summaries
Usually exists in summary fact tables
Designing Summary Tables
Average
Maximum
Summary Tables Example
Summary Management in Oracle8i
Using Time in the Data Warehouse
The Time Dimension
Time is critical to the data warehouse
A consistent representation of time is required for extensibility
Creating the Physical Model
Phase 4: Creating the Physical Model
Translate the dimensional design to a physical model for implementation
Define storage strategy for tables and indexes
Perform database sizing
Define initial indexing strategy
Define partitioning strategy
Update metadata document with physical information
Physical Model Design Tasks
Define naming and database standards
Perform database sizing
Design tablespaces
Develop initial indexing strategy
Develop data partition strategy
Define storage parameters
Set initialization parameters
Use parallel processing
Using Data Modeling Tools
Tools with a GUI enable definition, modeling, and reporting
Avoid a mix of modeling techniques caused by:
– Development pressure
– Developers with lack of knowledge
– No strategy
Determine a strategy
Write and publish formally
Make available electronically

Summary
This lesson discussed the following topics:
Creating a business model
Creating a dimensional model
Modeling the summaries
Creating a physical model