DIT+2016-17+Q4

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

Any Assignments beyond the current week are subject to change
=__**Class Links:**__ = =Pearson Course = @http://mylabs.px.pearsoned.com/ Sign up instructions for Pearson Course
 * 1) www.engradepro.com
 * 2) __www.schoology.com__
 * 3) __www.certiport.com__
 * 4) www.gmetrix.net
 * 5) email.rbmaritime.org
 * 6) www.typing.com
 * 7) www.newsela.com Class Code: 32AE7B
 * 8) Certiport Extended Time Application (Test Name: Microsoft Office Specialist)
 * 9) HELP FROM Mr. Miller

__**Schoology**__: Period 2: VB9T7-MVMGT Period 4: TFQB2-TWVXP Period 5: 64S43-3886V Period 6: QVG9M-GDHD8

=Download GMetrix program at home. = Video on how to install GMetrix

=Excel Certification Exam Preparation = Warm Up Exercises must be complete:
 * Excel Warm Up - Day 1
 * Excel Warm Up - Day 2
 * Excel Warm Up - Day 3

GMetrix Tests must be complete:
 * 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)

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 27 & 28
Warm Up: Lesson:
 * [[file:Excel Review - Day 2.xlsx]]
 * Follow instructions on Worksheet Tabs (3 tabs)
 * Upload to Engrade - Warm Up: Excel Day 2
 * 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 2013 Core Test 1 (Training Mode - score 90% or better)
 * 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 29 & 30
Warm Up:
 * [[file:Excel Review - Day 3.xlsx]]
 * Follow instructions on Worksheet Tabs (3 tabs)
 * Upload to Engrade - Warm Up: Excel Day 3

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)

=Week 31 =

Monday/Tuesday April 3 & 4
Lesson: media type="custom" key="29100925"
 * 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 5 & 6
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 =

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.

Wednesday/Thursday April 12 & 13
__**Warm Up**__: __**Lesson**__: PowerPoint Chapter 2 media type="custom" key="29118901"
 * 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
 * Creating New Slides
 * Change Layouts
 * Printing a Presentation
 * Black & White/Grayscale

Chapter 3
 * 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 =

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Monday/Tuesday April 17 & 18
Warm Up: Lesson:
 * Vocabulary through Lesson 5

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 4: Pictures
media type="custom" key="29129139"
 * Insert Pictures
 * Adjust settings (Crop, Brightness, Contrast, Size, Shadow, Effects)

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 5: Editing Text
media type="custom" key="29129135"
 * Using Find & Replace
 * Replace Fonts
 * Placeholders (formatting)
 * Clear All and Reset

Practice/Homework
 * Lesson 4 Apply (Page 873)
 * Lesson 5 Apply (Page 880)

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Wednesday/Thursday, April 19 & 20
Warm Up: Lesson:
 * Vocabulary through lesson 9

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 8: Rearranging Slides
media type="custom" key="29129133"
 * Reuse Slides
 * Duplicate Slides
 * Move Slides
 * Delete Slides

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Lesson 9: Transitions
media type="custom" key="29129131"
 * Adding Transitions
 * Adding sound to transitions
 * Using Transition Effects
 * Automatically advancing slides
 * Adding slide numbers


 * Practice/Homework
 * Lesson 8 Apply (Page 896)
 * Lesson 9 Apply (Page 900 - bottom of page)
 * Lesson 3 Practice (Page 866)

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

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Monday/Tuesday April 24 & 25
Warm Up: Lesson:
 * Complete vocabulary

<span style="color: #333333; font-family: arial,helvetica,sans-serif; font-size: 1.1em;">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"
 * Insert a chart
 * Changing the chart type
 * Modify styles and colors
 * Edit data (extending the range of numbers)

Practice/Homework
 * 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;">Wednesday/Thursday April 26 & 27
Warm Up: media type="youtube" key="MjcO2ExtHso" height="360" width="480" Lesson:
 * Complete vocabulary as listed on the RBMA-IT PowerPoint Notebook

<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="custom" key="29142137" Practice/Homework:
 * 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
 * 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;">Week 35 =

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

<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" Practice/Homework =<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Wednesday/Thursday, May 3 & 4 =
 * 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
 * Lesson 24 Apply (Page P-11)
 * Lesson 21 Apply (Page 989)
 * Lesson 20 Practice (Page 979)

<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)

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

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">May 8 - 11
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 Engrade


 * 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 Engrade
 * GMetrix PowerPoint Practice Test 1 - Testing (Testing Mode)
 * Must score at least 800 to count
 * Upload to Engrade
 * GMetrix PowerPoint Practice Test 2 - Testing (Testing Mode)
 * Must score at least 800 to count
 * Upload to Engrade

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Wednesday/Thursday, May 17 & 18

 * Certifications Tests (PowerPoint)

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Tuesday/Wednesday, May 22 & 23

 * Prepare for Final Exam

=<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Final Exam Schedule =