Week
1 : August
16 - 20.......... Database Fundamentals-
Section 1: Vocabulary
Lesson 1 Introduction
to the Oracle Internet Academy
Lesson 2 History of
Computing - Abacus to Video Games
Lesson 3 Introduction
to the Oracle Corporation
Lesson 4 History of
the Database
Lesson 5 Major Transformations
in Computing:
Section 2: Vocabulary .....Due
Thursday August 17
Lesson 1 Conceptual
and Physical Models
Lesson 2 Entities and Instances
Lesson 3 Attributes
and Unique Identifiers
Lesson 4 DJs on Demand (Example Project)
DJ - Interview DJ
- ERD
Week
2........ August 23 - 27
Take good notes and keep notebooks organized for notebook check
Vocabulary words for Sections 3 and 4 due Tuesday.
All Test are to be completed in class
Section 3 Vocabulary
(Section 3 and 4)
Lesson 1 Identify
Relationships
Lesson 2 ER Diagramming
Conventions
Lesson 3 Drawing Relationships
and Speaking ERDish
Lesson 4 Matrix Diagram
Lesson 5 Data vs Information
Friday
August 27:
Vocabulary Test 1 Section 1 and 2---
Vocabulary Test 2: Section 2 and 3
Section 4 Week
of August 30 - Sept. 3......... Quiz 1
Lesson 1 Video Store
(Due Monday, Aug. 30 homework)
Lesson 2 Global Fast
Foods ( Progressive project)
Lesson 3 Supertypes
and Subtypes (Sept 8)
Lesson 4 Documenting
Business Rules (Sept 9)
Lesson 5 Review Quiz 2 and Notebook check (Sept 13)
Monday: Sept. 13: Daily
Assignment for Section
Tuesday: Sept. 14: Daily
Assignment for Section
Wednesday: Sept. 15: Daily Assignment
Section 5 Vocabulary
Lesson 1 Relationship Transferability TryIt/ Slide
6-7 and Slide 8
Lesson 2 Relationship Types TryIt/ Assignments
Lesson 3 Resolving Many to Many Relationships TryIt/Assignments
Lesson 4 Normalization and First Normal Form Try
it/Assignment
Friday: Sept 17: Test-
Quiz 3 Daily Assignment
Lesson 5 Review : Quiz 3 and Notebook check -
Section 6 Vocabulary:
Lesson 1 Finding
a Context
Lesson 2 Source Document: Receipt
Lesson 3 Source
Document : Price List(homework 8/17)
Monday: September 20: Daily Assignment
Lesson 4 Refining Global Fast Foods (8/20)
Lesson 5 Second Normal Form (8/20)
Section 7 Vocabulary:
Lesson 1: Review of Unique Identifiers (8/20)
Tuesday: September 21: "Daily
Assignment"
Lesson 2 Identification
and Third Normal Form
Lesson 3 Arcs and Exclusive Relationships
Lesson 4 Hierarchies and Recursive Relationships
Lesson 5 Review, Quiz 4 and Notebook check (Test
Wednesday: Sept 22)
Wednesday: Sept 22: Daily Assignment
Section 8 Vocabulary
Lesson
1 Modeling
Historical Data (Wed)
Lesson 2 Case Study: International Oracle Users Group (IOUG)(Wed
- Thurs)
Lesson 3 What is a Consultant?
Lesson 4 Overcoming the Fear Factor
Lesson 5 (IOUG) Case Study Presentation (Project
grade) (Monday 9/27)
Monday: Sept. 27: Daily Assignment
Tuesday: Sept 28 Daily Assignment
Wednesday: Sept 29: Daily Assigment
Thursday: Sept 30: Presentations---
Friday: Oct 1: Revise and Read ahead
Section
9 Vocabulary 9 and 10
(Monday
- Wednesday) Presentations Thurs and Friday revise
Lesson 1 Interview
with the Director of Animal Shelter (Project grade)(Tues 9/28)
Lesson 2 Business
Rules of the Animal Shelter (Rubric)(Tues
9/28)
Lesson 3 Creating
the Animal Shelter ERD (Project grade)(Wed 9/29)
Lesson 4 Presentation
to the Animal Shelter Client (Project grade) (Thurs 9/30)
Lesson 5 Final Revisions to Animal Shelter
(Project grade) (Friday 10/1)
Section 10 Vocabulary
9 and 10 Activities Section
10
Lesson 1 Modeling Change - Time
Lesson 2 Modeling Change - Price (finished
10/1)
Lesson 3 Adding Time Element to Animal
Shelter
Lesson 4 Leaders in Information Technology (read only)
Lesson 5 (Quiz 5- Notebook check)
Monday: October 4 - Friday : October 8 (Tues FCat testing)
Section 11 Vocabulary 11 and 12
Lesson 1 What about Me?
Lesson 2 Drawing Conventions for Readability(mon)
Lesson 3 Generic Modeling(mon)
Lesson 4 Introduction to Relationship DB Concepts(wed)
Lesson 5 Review Quiz 6 (test 5 and 6 Thurs)
Section 12 Vocabulary 11 and 12
Lesson 1 The Changing Nature of Work(wed)
Lesson 2 Basic Mapping - The Transformation Process(wed)
Lesson 3 Relationship Mapping(thurs)
Lesson 4 Subtype Mapping(thurs)
Lesson 5 Introduction to HTML DB - Music Tables(Friday)
Section 13
Lesson 1 SQL Introduction - Querying the Database(Friday)
Lesson 2 Basic Table Modifications
Lesson 3 Teaming Up
Lesson 4 Project Overview and Getting Started
Lesson 5 Project Management
Section 14
Lesson 1 System Development Lifecycle
Lesson 2 Creating Tables for the Final Presentation
Lesson 3 Overview of Final Presentation
Lesson 4 Preparing Written Documentation
Lesson 5 Preparing Visual Materials
Section 15
Lesson 1 Review/Refine / Rehearse
Lesson 2 - 5 Presentations
Section 16
Lesson 1: Oracle Database Environment
Lesson 2 Relational Database Technology
Lesson 3 Using Applications
Lesson 4 Career Portfolio
Lesson 5 Anatomy of a SQL Statement
Section 17
Lesson 1 Working with columns, characters and
Rows
Lesson 2 Practice Exercises
Lesson 3 Work Experience and Community involvement
Lesson 4 Limit Rows Selected
Lesson 5 Comparison Operators
Section 18
Lesson 1: Logical Comparisons and Precedence Rules
Lesson 2 Sorting Rows
Lesson 3 Practice Exercises
Lesson 5 Introduction to Functions - Single Row Functions
|
Journal
:
Week 7: October 4 - Oct. 8
Week 6: September 27 - Oct. 1
Week 5: September 20
- 24
Week 4:Journals
Week 3 Journals
Week 2 Journals
Week 1 Journals
Test: Term Final
Wed./ Oct
13
Tests:
Vocabulary
(3) Tuesday- Sept 21
(4) Tuesday-Sept. 28 ( 7 & 8)
(5) TBA
Section Tests:
(1) Quiz 1 Wed. August 26
(2) Quiz 2, Monday, Sept 13
(3) Quiz 3, Friday, Sept 17
(4) Quiz 4, Wed, Sept 23
(5) Qiz 5 - 6: TBA
Projects:
- "Letters A - Z"
- Fast Food Powerpoint
- IOUG
- Animal Shelter
|
