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

Review advanced Word topics:

Create table and work with the text in them. Edit programs and set them up into columns. Working with graphics and charts. Finally collaborating and sharing tools in Word.

278-428

Exercises at the end of each chapter.

Quiz on topic

3

WEEK 3

CLASS OFFICER ELECTIONS

6^TH- 12^TH)

Wrap up Word and start on Powerpoint: (Talk about the project)

Introduction to Powerpoint:

• What is it?
• Becoming familiar with the navigation bar
• Basic skills
• Students will chose a topic to present and that’s what they will work on.

Lesson 1

811-845

Lesson Applications

Pg 842

4

WEEK 4

PERSONAL SAFETY

A basic presentation:

Using AutoContent wizard

• Basic presentation tools
• Creating/Editing slides and their content
• Adding transitions
• Adding a header and footer

Lesson 2

846-886

Quiz on basic concepts

Lesson Applications

Pg 877

5

WEEK 5

OPEN HOUSE

Advancing in skill:

Creating a presentation from scratch

• Creating a blank document
• Changing slide layouts (for printing)
• Working with templates
• Shortcuts

Lesson 3

888-921

Lesson Applications

Pg 918

On Your Own exercises

Pg 921

6

WEEK 6

HUMILITY

Editing the look of the slides:

Outlines, Hyperlinks, and HTML:

• Adjusting text and outline
• Split and /or join slides
• Moving bulleted items
• Creating an outline in Word
• Hyperlinks

Lesson 4

922-953

Skills Review

Pg 946

Lesson Applications

Pg 951

Exam 1

7

WEEK 7

SELF DISCIPLINE

Developing your slide show:

Text and Placeholders

• Fonts
• Place holders and alignment
• Turn bullets on and off
• Using text boxes

Lesson 5

954-981

Lesson Applications

Pg 978 &

on Your Own

8

WEEK 8

CULTURAL DIVERSITY

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

Creating Objects

• Working with drawing tools
• Draw constraint lines (editing and moving)
• Using the AutoShapes function.
• Inserting and Editing images

Lesson 6

982-1019

Lesson Applications

Pg 1016

Work on project

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

Formatting objects:

Lines and Grids

• Applying and edit a border
• Changing the fill color of objects
• Selecting multiple objects
• Align and distribute objects (with or without a grid)

Lesson 7

1020-1066

Unit 2 Applications

Pg 1060

2

WEEK 11

Finalizing the presentation:

Customizing Templates

• Working with backgrounds
• Editing Template Graphics
• Title Slide Master
• Save as a New Template

Lesson 8

1068-1091

Lesson Applications

Pg 1089

Quiz

3

WEEK 12

TEAM WORK

Bringing life to your slides:

Animation and Slide Show Effects

• Using animation schemes
• Inserting movies and sound clips
• Create and run custom shows
• Creating action buttons

Lesson 9

1092-1115

Lesson Applications

Pg 1112

4

WEEK 13

MARATON ON SATURDAY

Wrap up and Presentation:

Charts, Tables and Presentation

• Charts & Tables(Flow Charts)
• Distributing and presenting your work
• Setting up a review cycle
• Presentation as a web page
• Presenting on a projector

Lesson 10& Lesson 11

Pg 1116-1192

Lesson Applications

Pg 1143

&

Unit 3

Applications

Pg 1185

5

WEEK 14

THANKS-

GIVING DAY

Overview of Powerpoint:

Presentation of projects and overview of what was learned

Project Presentations

6

WEEK 15

CARING AND SHARING

Get Started with Excel

• Start Excel
• Navigate in a workbook
• Open an existing workbook
• Edit and manage files
• Printing Excel files

Lesson 1

438-469

Exam 2 on Powerpoint

Lesson Applications

Pg 466

7

WEEK 16

X- MAS PLAY Rehearsal

Basic Skills:

Creating a workbook

• Enter labels and change their fonts
• Select cell ranges
• Modify column and row sizes
• Enter values
• Enter basic formulas

Lesson 2

470-507

Lesson Applications

Pg 504

8

WEEK 17

EMPATHY

CHRISTMAS PLAY

(1^ST – 6^TH)

Advancing in skills:

Using Editing and Formatting tools

• Setting and using AutoCorrect to fix errors
• Spell check
• Finding and editing data
• Creating a series and copying with fill handle
• Applying AutoFormat

Lesson 3

508-543

Lesson Applications

Pg 540

9

WEEK 18

Quarter Evaluation Week /MIDTERM EXAM REVIEW

No new class during this week!

Review and Quarter Eval

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

Advancing in skills:

Working with cells, columns, rows, and sheets

• Insert and delete worksheets
• Insert and delete cells
• Using AutoComplete to add labels
• Copy, cut and paste cell contents
• Applying AutoFormat
• Shading, styles, and page breaks.

Lesson 4

544-592

Unit 1 Applications

Pg 588

2

WEEK 21

Calculations and formulas:

Working with simple formulas

• Creating a workbook using a template
• Building formulas for addition, subtraction, division, and multiplication
• Compare formulas
• Using relative, absolute, ,and mixed references

Lesson 5

594-625

Lesson Applications

Pg 622

Quiz

3

WEEK 22

COURAGE

Functions more in depth:

Functions and hyperlinks

• Math and trig functions
• Insert functions
• Truncation and conditions
• Key and format dates (custom time format)
• PMT, avg, min, and max
• Formatting numbers

Lesson 6

626-694

Lesson Applications

Pg 683

4

WEEK 23

Building Charts and Diagrams

• Creating, previewing and editing charts
• Format the data series and axes
• Cycle diagram

Lesson 7

696-729

Quiz

Lesson Applications

Pg 726

5

WEEK 24

Independence Week Celebration

Spicing up your spreadsheets:

Callouts, Comments, and Pictures

• Call outs
• Format the data series and axes
• Editing drawing objects\
• AutoShape
• Inserting comments & pictures
• Saving as a webpage

Lesson 8

730-759

Overview

Lesson Applications

Pg 752

6

WEEK 25

CURIOSITY

Overview of excel

Concept assessment

Then talk about web page project and begin intro to web pages. (Students will come up with a concept for their page and work on it as the course progresses and it will be checked by the teacher as a project grade.

Exam

7

WEEK 26

Introduction to web pages:

HTML building blocks

• Writing HTML tags
• Nesting
• Spacing and Special symbols
• File names & URLs

Students will pick the topic for their web pages

HTML

Book

21-27

8

WEEK 27

CREATIVITY

St. Patrick’s Day

Starting a web page:

Design & Organization stage

• Layout design
• Creating a new web page (title)
• The foundation of the page
• Organizing the web page
• Saving and viewing your page

HTML

Book

31-42

9

WEEK 28

Quarter Evaluation Week      No new classes this week!

Q.E.

FOURTH QUARTER – LEARNING TO DO

CUARTO CUATRIMESTRE – APRENDER A HACER

1

WEEK 29

COOPERATION

Working with the content:

Text Formatting

• Changing the font & making it I, B, U
• Working with font size & color
• Superscript and subscripts
• Strike through, making text blink, hiding text

HTML

Book

45-56

2

WEEK 30

Bringing your web page to life:

Working with Images

• Inserting images on a page
• Specifying size for viewing
• Linking icons to images
• Wrapping text around an image

HTML

Book

82-87

WEEK 31

EASTER…..HOLY WEEK….NO CLASS

3

WEEK 32

TEAMWORK

Organization:

Page Layout

• Background: color and images
• Margins and Aligning
• Specifying space between paragraphs
• Creating columns
• Using block quotes

HTML

Book

98-113

4

WEEK 33

Expanding & linking:

Link

• Linking to another web page
• Creating anchors
• Linking to anchors
• Targeting links to a specific place
• Image Maps

HTML

Book

118-123

Quiz

5

WEEK 34

INICIATIVE

Sequenced Text:

Lists

• Ordered lists
• Unordered Lists
• Nested Lists

HTML

Book

135-141

6

WEEK 35

Tables

·         Mapping out your page

·         Creating a table

·         Working with table borders

·         Wrapping text around table

·         Spanning cells

·       Changing a cells colors or adding background image

HTML

Book

143-159

Quiz

7

WEEK 36

REFLECTION

Frames

• Creating Framesets: in Columns or rows
• Combining framesets
• Adjusting frame margins
• Showing or hiding scroll bars (Keeping visitors from resizing)
• Link to a particular frams

HTML

Book

167-181

8

WEEK 37

Forms

·         About CGI scripts

·         Preparing scripts & creating a form

·         Sending a form via email

·         Creating:

1.       Text boxes

2.       Password Boxes

3.       Text areas

4.       Radio & check buttons

·         Submitting data:

1.       Submit button

2.       Submitting with an image

HTML

Book

188-208

9

WEEK 38

Quarter Evaluation Week, REVIEW FOR SEMESTER EXAMS.

No new class during this week!

Final Project presentation

Final Project

WEEK 39

Second Semester Exams