FIRST QUARTER – LEARNING TO BE YOU

PRIMER CUATRIMESTRE – APRENDER A SER

1

Week 1

DECORUM AND PUNCTUALITY

CONCEPTS/CONTENT

Diagnostic Assessments: Set a benchmark of the level of the students before beginning with classes. 

PAGES

ASSESSMENT

2

Week 2

DECORUM AND PUNCTUALITY

Intro to Access:

Getting Started with a Database

Start Access and identify parts of the screen

Look at database objects

Work with table and queries

Manage access file and exit access

Talk about the semester project and due dates.

Lesson 1

6-42

Skills Review

Pg 36

Students should think of a topic for their project

3

Week 3

CLASS OFFICER ELECTIONS

6^TH- 12^TH)

Hands on:

Adding and Editing Data

• Add and delete records
• Edit data in a table or through query
• Add records in a form
• Change view through a form & working with a record

Lesson 2

44-85

Skills Review

Pg 74

4

Week 4

PERSONAL SAFETY

Hands on:

Adding and Editing Data

• Add and delete records
• Edit data in a table or through query
• Add records in a form
• Change view through a form & working with a record

Lesson 2

44-85

Skills Review

Pg 74

Exam

5

Week 5

OPEN HOUSE

Working with a lot of data:

Finding and sorting records

• Finding specific text
• Use the replace command
• Sort records & building query
• Using filters

Lesson 3

86-125

Lesson Applications

Pg 122

6

Week 6

HUMILITY

Tables:

Adding and Modifying Tables

• Create a new database & using table wizard
• Create a table in Datasheet view
• Edit field properties
• Insert and delete fields
• Import and export data

The flow of data:

DFDs, Flow charts

• What is a DFD?

• Creating a flow chart from the topics chosen

• How DFDs relate to tables and databases

• Start planning the tables

Lesson 4

126-168

Unit Application

Pg 164

Exam

7

Week 7

SELF DISCIPLINE

Tables:

Adding and Modifying Tables

• Create a new database & using table wizard
• Create a table in Datasheet view
• Edit field properties
• Insert and delete fields
• Import and export data

The flow of data:

DFDs, Flow charts

• What is a DFD?

• Creating a flow chart from the topics chosen

• How DFDs relate to tables and databases

• Start planning the tables

Lesson 4

126-168

Data Flow Diagram work sheets

8

Week 8

CULTURAL DIVERSITY

MULTICULTURAL FAIR (1^ST – 9^TH) / UN MODEL DEBATE (10^TH –12^TH)

Keeping the integrity of data:

Managing Data Integrity

• Create the relationships between tables
• Work with subdatasheets and integrity
• Default values, formats, validation rules and input masks
• Lookup Wizard
• Track object dependency

Lesson 5

170-203

Concept and Skills review

9

Week 9

INTEGRITY

Quarter Evaluation Week / No new class during this week!

Review and Quarter Evals

Quarter

Eval

SECOND QUARTER  - LEARNING TO LIVE TOGETHER

 SEGUNDO CUATRIMESTRE – APRENDER A VIVIR JUNTOS

1

Week 10

RELIABLE

Keeping the integrity of data:

Managing Data Integrity

• Create the relationships between tables
• Work with subdatasheets and integrity
• Default values, formats, validation rules and input masks
• Lookup Wizard
• Track object dependency

Lesson 5

170-203

Concept and Skills review

Quiz

2

Week 11

Designing Queries

• Create and modify a select query
• Use criteria and operators in a query
• Query properties
• Add a calculated fields to a query

Lesson 6

204-235

Skills Review

Pg 265

3

Week 12

TEAM WORK

Forms:

Adding and Modifying fields

• AutoForm and form wizard
• Form controls
• Add a calculated control to a form
• Use the web to display the data

Lesson 7

236-273

Skill Review

Pg 229

4

Week 13

MARATON ON SATURDAY

Reports:

Adding and Modifying Reports

• Create and modify AutoReports & Report Wizard
• Report controls
• Use format painter and conditional formatting
• Create multicolumn report and labels

Lesson 8

274-313

Unit Applications

Pg 310

Quiz

5

Week 14

THANKS-

GIVING DAY

Relationships and Links:

Building Links, Relationships, and Indexes

• Work with linked data
• Create and edit joins & relationships
• Create and modify a relationships report
• Creating and deleting an index

Building Advanced Forms and Reports

• Create a forms and reports in design view
• Edit form appearance
• Create a summary report with multiple groups
• Page breaks and images

Lesson 9

316-347

Lesson 11

374-412

Skills Review

Pg 340

Skills Review

Pg 404

Exam

6

Week 15

CARING AND SHARING

Relationships and Links:

Building Links, Relationships, and Indexes

• Work with linked data
• Create and edit joins & relationships
• Create and modify a relationships report
• Creating and deleting an index
•  

Integrating Access with Data and Applications

• Convert a database
• Import, export, and merge data
• Data Access pages
• Pivot Tables and Charts
• Create a grouped data access page
• Security tools

Lesson 9

316-347

Lesson 12

412-460

Skills Review

Pg 340

Lesson Applications

Pg 455

7

Week 16

X- MAS PLAY Rehearsal

Designing Advanced Queries

• Summary query
• Parameter query
• Update query
• Make-table query
• Delete and append query

Lesson 10

348-372

Skills Review

Pg 366

8

Week 17

EMPATHY

CHRISTMAS PLAY

(1^ST – 6^TH)

Project presentations

Project Presentations

9

Week 18

Quarter Evaluation Week /MIDTERM EXAM REVIEW

No new class during this week!

Review and Quarter Eval

Project/Quarter Eval

Week 19

Semester Exams    

THIRD QUARTER – LEARNING HOW TO LEARN    THREE ‘C’s

TERCER CUATRIMESTRE – APRENDER A CONOCER- Tres ‘C’’s

1

Week 20

COMPREHENSION

2

Week 21

3

Week 22

COURAGE

4

Week 23

5

Week 24

Independence Week Celebration

6

Week 25

CURIOSITY

7

Week 26

8

Week 27

CREATIVITY

St. Patrick’s Day

9

Week 28

Quarter Evaluation Week      No new classes this week!

FOURTH QUARTER – LEARNING TO DO

CUARTO CUATRIMESTRE – APRENDER A HACER

1

Week 29

COOPERATION

2

Week 30

Week 31

EASTER…..HOLY WEEK….NO CLASS

3

Week 32

TEAMWORK

4

Week 33

5

Week 34

INICIATIVE

6

Week 35

7

Week 36

REFLECTION

8

Week 37

9

Week 38

Quarter Evaluation Week, REVIEW FOR SEMESTER EXAMS.

No new class during this week!

Week 39

Second Semester Exams