IIT+2015-16+Q4

=Introduction to Information Technology - School Year 2015 - 2016 Schedule =

=__**Class Links:**__ = =Pearson Course = @http://mylabs.px.pearsoned.com/ =Download [|GMetrix SMS] on Home Computer =
 * 1) www.engradepro.com
 * 2) __www.schoology.com__ Class Code: 6FQCR-DBNCZ
 * 3) __www.certiport.com__
 * 4) www.gmetrix.net
 * 5) www.outlook.com/rbmaritime.org
 * 6) www.typing.com
 * 7) www.newsela.com Class Code: 3XZA4F
 * 8) HELP FROM Mr. Miller

=Excel Certification Exam Preparation = Warm Up Exercises must be complete: GMetrix Tests must be complete:
 * Excel Warm Up - Day 1
 * Excel Warm Up - Day 2
 * Excel Warm Up - Day 3
 * Excel Review Test 1 (Charts, Tables, Images) (Training Mode - score 90% or better)
 * Excel Review Test 2 (Formulas, Data) (Training Mode - score 90% or better)
 * Excel Review Test 1 (Charts, Tables, Images) (Testing Mode - score 80% or better)
 * Excel Review Test 2 (Formulas, Data) (Testing Mode - score 80% or better)
 * Excel Review Test 2 (Formulas, Data) (Testing Mode - score 80% or better)

Extra Credit - Must be complete BEFORE taking Excel Certification Exam
 * Excel Core Test 1 - Training Mode
 * Excel Core Test 2 - Training Mode

=Week 30=

Monday & Tuesday, March 28 - 29
Warm Up:
 * [[file:Excel Review - Day 2.xlsx]]
 * Follow instructions on Worksheet Tabs (3 tabs)
 * Upload to Engrade - Warm Up: Excel Day 2

Lesson:
 * GMetrix Practice
 * Do the "Tests" listed below in GMetrix
 * Attempt each question without help
 * If you get it wrong, then use the help file
 * If you get it wrong a second time, ask for help
 * Make sure to get a screen shot using the Snipping Tool to upload to Engrade


 * Excel Review Test 1 (Charts, Tables, Images) (Training Mode - score 90% or better)
 * Excel Review Test 2 (Formulas, Data) (Training Mode - score 90% or better)
 * Excel Review Test 1 (Charts, Tables, Images) (Testing Mode - score 80% or better)
 * Excel Review Test 2 (Formulas, Data) (Testing Mode - score 80% or better)

Wednesday/Thursday March 30 & 31
Warm Up: Lesson:
 * [[file:Excel Review - Day 3.xlsx]]
 * Follow instructions on Worksheet Tabs (3 tabs)
 * Upload to Engrade - Warm Up: Excel Day 3
 * GMetrix Practice
 * Do the "Tests" listed below in GMetrix
 * Attempt each question without help
 * If you get it wrong, then use the help file
 * If you get it wrong a second time, ask for help
 * Make sure to get a screen shot using the Snipping Tool to upload to Engrade


 * Excel Review Test 1 (Charts, Tables, Images) (Training Mode - score 90% or better)
 * Excel Review Test 2 (Formulas, Data) (Training Mode - score 90% or better)
 * Excel Review Test 1 (Charts, Tables, Images) (Testing Mode - score 80% or better)
 * Excel Review Test 2 (Formulas, Data) (Testing Mode - score 80% or better)

=Week 31=

Monday/Tuesday April 4 & 5
Lesson:
 * Review Excel Topics - Data Tables 2013 (Class Files --> IIT --> Excel)
 * Sort & Filter
 * Formulas on other sheets
 * SumIf
 * AverageIf
 * Concatenate
 * Count
 * Min
 * Max
 * Indent
 * Cell Styles


 * Excel Review Test 1 (Charts, Tables, Images) (Testing Mode - score 80% or better)
 * Excel Review Test 2 (Formulas, Data) (Testing Mode - score 80% or better)


 * Excel Core Test 1 - Training Mode - (Score at least 90% - EC Points - Classwork)
 * Excel Core Test 2 - Training Mode - (Score at least 90% - EC Point - Quiz Grade)

Wednesday/Thursday April 6 & 7
Lesson:
 * Review Excel Topics -
 * Fill a series
 * Insert Row/Columns
 * Delete Row/Columns
 * Decimal places
 * Format rules (mmm or yy or d)
 * Named Range
 * Name Table
 * Printing
 * Set Print Area
 * Print Titles
 * Enable Grid lines/Heading
 * Insert Text file
 * Left/Right/Concatenate


 * Excel Review Test 1 (Charts, Tables, Images) (Testing Mode - score 80% or better)
 * Excel Review Test 2 (Formulas, Data) (Testing Mode - score 80% or better)


 * Excel Core Test 1 - Training Mode - (Score at least 90% - EC Points - Classwork)
 * Excel Core Test 2 - Training Mode - (Score at least 90% - EC Point - Quiz Grade)

=Week 32=

Monday, April 11

 * Excel Review Test 1 (Charts, Tables, Images) (Testing Mode - score 80% or better)
 * Excel Review Test 2 (Formulas, Data) (Testing Mode - score 80% or better)


 * Excel Core Test 1 - Training Mode - (Score at least 90% - EC Points - Classwork)
 * Excel Core Test 2 - Training Mode - (Score at least 90% - EC Point - Quiz Grade)

Excel Certification Exam:

 * You must have Excel Review Test 1 & 2 completed with a score of at least 80% to take the exam.
 * If you don't feel prepared you do NOT have to take the exam on the scheduled day.
 * If you don't take the exam on this day (absent, not done with Excel Review Test or don't feel ready yet) you will need to schedule a time to take the exam after school. You will be required to attend weekly tutoring of 1 hour each week after school until you are ready to take and pass the exam.

Thursday/Monday April 14 & 18
__**Warm Up**__:
 * Open Documents folder and delete folders and files (except for notebook files)
 * Create a Word document, Name it PowerPoint Notebook
 * Save PowerPoint Notebook to documents
 * Work on vocabulary: Lessons 2 & 3

__**Lesson**__: PowerPoint Chapter 2 media type="youtube" key="i5iJbxMMsIs" width="420" height="315" Chapter 3
 * Creating New Slides
 * Change Layouts
 * Printing a Presentation
 * Black & White/Grayscale
 * Reuse Slides
 * Change slide size and orientation
 * Adding Notes
 * Activating Headers/Footers
 * File Properties


 * Lesson 2 Apply - Page 860 (Bottom - Don't do Practice)
 * Lesson 3 Apply - Page 867

=Week 33=

Monday April 18
__**Warm Up**__:
 * Open Documents folder and delete folders and files (except for notebook files)
 * Create a Word document, Name it PowerPoint Notebook
 * Save PowerPoint Notebook to documents
 * Work on vocabulary: Lessons 2 & 3

__**Lesson**__: PowerPoint Chapter 2 media type="youtube" key="i5iJbxMMsIs" width="420" height="315" Chapter 3
 * Creating New Slides
 * Change Layouts
 * Printing a Presentation
 * Black & White/Grayscale
 * Reuse Slides
 * Change slide size and orientation
 * Adding Notes
 * Activating Headers/Footers
 * File Properties


 * Lesson 2 Apply - Page 860 (Bottom - Don't do Practice)
 * Lesson 3 Apply - Page 867

Tuesday/Wednesday April 19 & 20
Warm Up: Lesson:
 * Vocabulary through Lesson 5

Lesson 4: Pictures
media type="youtube" key="B2tlFtM58GY" height="360" width="480"
 * Insert Pictures
 * Adjust settings (Crop, Brightness, Contrast, Size, Shadow, Effects)

Lesson 5: Editing Text
media type="youtube" key="b6H5FgUvlWg" width="420" height="315" Practice/Homework
 * Using Find & Replace
 * Replace Fonts
 * Placeholders (formatting)
 * Clear All and Reset
 * Lesson 4 Apply (Page 873)
 * Lesson 5 Apply (Page 880)

Thursday/Monday, April 21 & 25
Warm Up: Lesson:
 * Vocabulary through lesson 9

Lesson 8: Rearranging Slides
media type="youtube" key="VwT60h4xwfo" height="480" width="640"
 * Reuse Slides
 * Duplicate Slides
 * Move Slides
 * Delete Slides

Lesson 9: Transitions
media type="youtube" key="OZ6Rvpzc8jI" height="480" width="640" Practice/Homework
 * Adding Transitions
 * Adding sound to transitions
 * Using Transition Effects
 * Automatically advancing slides
 * Adding slide numbers
 * Lesson 8 Apply (Page 896)
 * Lesson 9 Apply (Page 900 - bottom of page)
 * Lesson 3 Practice (Page 866)

=Week 34=

Monday, April 25
Warm Up: Lesson:
 * Vocabulary through lesson 9

Lesson 8: Rearranging Slides
media type="youtube" key="VwT60h4xwfo" height="480" width="640"
 * Reuse Slides
 * Duplicate Slides
 * Move Slides
 * Delete Slides

Lesson 9: Transitions
media type="youtube" key="OZ6Rvpzc8jI" height="480" width="640" Practice/Homework
 * Adding Transitions
 * Adding sound to transitions
 * Using Transition Effects
 * Automatically advancing slides
 * Adding slide numbers
 * Lesson 8 Apply (Page 896)
 * Lesson 9 Apply (Page 900 - bottom of page)
 * Lesson 3 Practice (Page 866)

Tuesday/Wednesday April 26 & 27
Warm Up:
 * Complete vocabulary

Lesson:

Lesson 10: Lists
=<span style="color: #333333; font-family: arial,helvetica,sans-serif;">media type="youtube" key="GOwR0z7ykbE" height="480" width="640" =
 * Insert a bulleted list
 * Change a bulleted list to a numbered list
 * Use symbols for bullets
 * Use pictures for bullets
 * Add slide numbers and date, but NOT on the Title Slide

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 23: Charts
media type="youtube" key="hd3j17_4tgs" height="360" width="640" Practice/Homework
 * Insert a chart
 * Changing the chart type
 * Modify styles and colors
 * Edit data (extending the range of numbers)
 * Lesson 10 Apply (Page 910)
 * Lesson 23 Apply (Page 1001)
 * Lesson 4 Practice (Page 873)

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Thursday/Monday April 28 & May 2
Warm Up:
 * Complete vocabulary as listed on the RBMA-IT PowerPoint Notebook

media type="youtube" key="MjcO2ExtHso" height="360" width="480" Lesson:

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 16 - SmartArt
media type="youtube" key="X5Uc7MOwOsI" height="360" width="480"
 * Convert a list to SmartArt
 * Change the order of SmartArt pieces
 * Modify the style and color of SmartArt
 * Use Picture based SmartArt
 * Add picture fill to SmartArt shapes

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 20 - Animation
media type="youtube" key="kccHinbeUFc" height="360" width="480"
 * Insert the 4 types of animations (Entrance, Emphasis, Exit and Motion Paths)
 * Set animations settings (Start, Delay & Duration)
 * Change the order of animations
 * Copy animations with the Animation Painter
 * Remove animations

Practice/Homework:
 * Lesson 16 Apply (Page 952) Bottom of page
 * Lesson 20 Apply (Page 981)
 * Lesson 23 Practice (Page 1000)

=Week 35=

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Monday, May 2
Warm Up:
 * Complete vocabulary as listed on the RBMA-IT PowerPoint Notebook

media type="youtube" key="MjcO2ExtHso" height="360" width="480" Lesson:

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 16 - SmartArt
media type="youtube" key="X5Uc7MOwOsI" height="360" width="480"
 * Convert a list to SmartArt
 * Change the order of SmartArt pieces
 * Modify the style and color of SmartArt
 * Use Picture based SmartArt
 * Add picture fill to SmartArt shapes

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 20 - Animation
media type="youtube" key="kccHinbeUFc" height="360" width="480"
 * Insert the 4 types of animations (Entrance, Emphasis, Exit and Motion Paths)
 * Set animations settings (Start, Delay & Duration)
 * Change the order of animations
 * Copy animations with the Animation Painter
 * Remove animations

Practice/Homework:
 * Lesson 16 Apply (Page 952) Bottom of page
 * Lesson 20 Apply (Page 981)
 * Lesson 23 Practice (Page 1000)

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Tuesday/Wednesday May 3 & 4
Warm Up:
 * Complete work not done last class
 * Lesson 16 Apply
 * Lesson 20 Apply
 * Lesson 23 Practice
 * Vocabulary as listed on PowerPoint Vocabulary Page

Lesson:

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 24: Masters
media type="youtube" key="HWYeFSgtaqg" height="480" width="640"
 * Access the slide master
 * Change color and font settings for all slides
 * Change slide size (on master)
 * Access Notes Master
 * Change placement of placeholders (Header/Footer/Slide #)

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 21: Multimedia
media type="youtube" key="ghHhjkpLgYo" height="360" width="640"
 * Add Video to a presentation
 * Adjust start settings on the presentation
 * Crop & Trim the video
 * Set the volume level for the video
 * Add a song and have it play across slides

Practice/Homework
 * Lesson 24 Apply (Page P-11)
 * Lesson 21 Apply (Page 989)
 * Lesson 20 Practice (Page 979)

=Thursday/Monday, May 5 & 9=

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 27: Set Up Show/Custom Show
media type="youtube" key="yVGXFaEhzTY" height="480" width="640"
 * Add Sections with names
 * Create a custom slide show
 * Adjust settings for a slide show
 * Hide a slide
 * Give a presentation
 * Show a hidden slide
 * Annotate a presentation
 * Save annotations

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 22: Tables & Comments
media type="youtube" key="jyLM-McKPvI" height="480" width="640" Practice/Homework:
 * Insert Tables into PowerPoint
 * Adjust rows & columns (adding/deleting)
 * Use merge and center in tables
 * Add/delete comments
 * Insert slides from outlines
 * Adjust text boxes and picture frames
 * Lesson 27 Apply (Page P-35)
 * Lesson 22 Apply (Page 995)

=Week 36= =<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Monday, May 9 =

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 27: Set Up Show/Custom Show
media type="youtube" key="yVGXFaEhzTY" height="480" width="640"
 * Add Sections with names
 * Create a custom slide show
 * Adjust settings for a slide show
 * Hide a slide
 * Give a presentation
 * Show a hidden slide
 * Annotate a presentation
 * Save annotations

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 22: Tables & Comments
media type="youtube" key="jyLM-McKPvI" height="480" width="640" Practice/Homework:
 * Insert Tables into PowerPoint
 * Adjust rows & columns (adding/deleting)
 * Use merge and center in tables
 * Add/delete comments
 * Insert slides from outlines
 * Adjust text boxes and picture frames
 * Lesson 27 Apply (Page P-35)
 * Lesson 22 Apply (Page 995)

May 10 - 18
Review for Certification
 * GMetrix PowerPoint Practice Test 1 (Training Mode)
 * Attempt without help
 * If incorrect use help file
 * If incorrect again ask for assistance from instructor
 * You must score a 900 or better to get credit.
 * Upload to Schoology
 * GMetrix PowerPoint Practice Test 2 (Training Mode)
 * Attempt without help
 * If incorrect use help file
 * If incorrect again ask for assistance from instructor
 * You must score a 900 or better to get credit.
 * Upload to Schoology
 * GMetrix PowerPoint Practice Test 1 - Testing (Testing Mode)
 * Must score at least 800 to count
 * Upload to Schoology
 * GMetrix PowerPoint Practice Test 2 - Testing (Testing Mode)
 * Must score at least 800 to count
 * Upload to Schoology
 * Upload to Schoology

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Thursday/Monday, May 19 & 23

 * Certifications Tests (PowerPoint)

Tuesday/Wednesday, May 24 & 25

 * Prepare for Final Exam

= Final Exam Schedule =