IIT+2015-16+Q3

=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

=Week 19=

Tuesday & Wednesday January 5 & 6
Warm Up:
 * Log into Engrade (Check 2nd quarter grade, Mid-Term)
 * Log into Schoology (See your grade for Mid-Term --> In 2nd Quarter Folder)
 * Log into Outlook (Show Mr. Miller you can log in/know your password)

__**Lesson**__: media type="youtube" key="vuuLmwKRBIo" height="480" width="640" media type="youtube" key="e2ScEw-Ziv8" height="480" width="640"
 * How to Install Office 365 on your Computer
 * Video Questions: Installing Microsoft Office (Repeat quiz until you score a perfect score)
 * Create Log in for GMetrix.net
 * Put GMetrix username and password in your notebook
 * Give Mr. Miller your GMetrix log in information.
 * Applying fills to shapes and pages
 * SmartArt
 * Tables
 * Multilevel list
 * Hyperlinks

Thursday, January 7
Warm Up: Using the Snipping Tool media type="youtube" key="RyHdx7Cjj8Q" height="480" width="640"

Lesson: Complete GMetrix Practice Test 1 (Training Mode)
 * Attempt question without help
 * If wrong Retry and use the help file
 * If wrong again, get instructor assistance
 * You MUST complete the practice test with at least a score of 900. If you score less, retake the whole test.
 * Provide a screen shot using the snipping tool to Engrade.

=Week 20 =

Monday, January 11
Warm Up: Using the Snipping Tool media type="youtube" key="RyHdx7Cjj8Q" height="480" width="640"
 * [|Kahoot.it]

Lesson: Complete GMetrix Word 2013 Core Test 1 (Training Mode)
 * Attempt question without help
 * If wrong Retry and use the help file
 * If wrong again, get instructor assistance
 * You MUST complete the practice test with at least a score of 90. If you score less, retake the whole test.
 * Provide a screen shot using the snipping tool to Engrade.

Tuesday/Wednesday, January 12/13
Warm Up:

Lesson: Complete GMetrix Word 2013 Core Test 2 (Training Mode)
 * Attempt question without help
 * If wrong Retry and use the help file
 * If wrong again, get instructor assistance
 * You MUST complete the practice test with at least a score of 90. If you score less, retake the whole test.
 * Provide a screen shot using the snipping tool to Engrade.

Thursday, January 14
Complete **GMetrix Word 2013 Core Test 1** (Testing Mode) This counts as a quiz grade Complete **GMetrix Word 2013 Core Test 2** (Testing Mode) This counts as a quiz grade
 * You MUST complete the practice test with at least a score of 80. If you score less, retake the whole test.
 * Provide a screen shot using the snipping tool to Engrade.
 * You MUST complete the practice test with at least a score of 80. If you score less, retake the whole test.
 * Provide a screen shot using the snipping tool to Engrade.

=Week 21=

Tuesday, January 19 (Odd Day - Make up for 2 missed Mondays)
Complete **GMetrix Word 2013 Core Test 1** (Testing Mode) This counts as a quiz grade Complete **GMetrix Word 2013 Core Test 2** (Testing Mode) This counts as a quiz grade
 * You MUST complete the practice test with at least a score of 80. If you score less, retake the whole test.
 * Provide a screen shot using the snipping tool to Engrade.
 * You MUST complete the practice test with at least a score of 80. If you score less, retake the whole test.
 * Provide a screen shot using the snipping tool to Engrade.

Wednesday, Thursday January 20 & 21
Complete **GMetrix Word 2013 Core Test 1** (Testing Mode) This counts as a quiz grade Complete **GMetrix Word 2013 Core Test 2** (Testing Mode) This counts as a quiz grade Complete **GMetrix Word 2013 Core Project 1** (Testing Mode)
 * You MUST complete the practice test with at least a score of 80. If you score less, retake the whole test.
 * Provide a screen shot using the snipping tool to Engrade.
 * You MUST complete the practice test with at least a score of 80. If you score less, retake the whole test.
 * Provide a screen shot using the snipping tool to Engrade.
 * This will mimic the actual certification exam in the way the test will be delivered. Completing this will give you the ability to see some of the required skills you will need on the exam.

=Week 22=

Monday, Tuesday January 25 & 26
Complete **GMetrix Word 2013 Core Test 2** (Testing Mode) This counts as a quiz grade Complete **GMetrix Word 2013 Core Project 1** (Testing Mode)
 * You MUST complete the practice test with at least a score of 80. If you score less, retake the whole test.
 * Provide a screen shot using the snipping tool to Engrade.
 * This will mimic the actual certification exam in the way the test will be delivered. Completing this will give you the ability to see some of the required skills you will need on the exam.

Wednesday, Thursday, January 27 & 28
Warm Up: media type="youtube" key="BayBRhfrAgk" height="360" width="640" Answer the following questions about the video: MOS 2013 Exam Lesson:
 * Watch the following video concerning the Word Certification Exam
 * Log into Certiport (show Mr. Miller
 * Discuss testing procedures
 * Who is eligible to take the test
 * What happens if you are not ready to take the test
 * Test taking strategies
 * Review topics:
 * Tables
 * Smart Art
 * Absolute positioning
 * Multilevel List
 * Bullet List (Change Indent)
 * Hyperlink
 * Page number formatting
 * Themes
 * Settings
 * Inserting files

__**Homework**__: Complete Quiz found in Diving In.

=Week 23=

Microsoft Office Specialist (MOS) 2013 Certification Exam
Once the certification exam is taken and passed, work will begin in Excel Next week we will begin actual training in Excel as a class. The GMetrix is for those that complete the exam and have time in class still this week.
 * Prepare for exam in GMetrix
 * Sign up & take exam (Certiport)
 * Exam Group ID: 1686749
 * GMetrix: Excel 2013 Core Test 1 in Training Mode

=Week 24=

Monday & Tuesday, February 8 & 9
__**Warm Up**__: __**Lesson**__: media type="youtube" key="4PiBwkX7SUA" height="360" width="480"
 * Log into Pearson book (link at top of this page - Pearson Course)
 * Delete Old Word files with dates (in documents folder)
 * Delete dated folders in documents
 * Start Word Document and Save it as Excel Notebook
 * Vocabulary Excel (See Excel Vocabulary on right)
 * Lesson 2:
 * Clear cell contents
 * Inserting Built-In Header/Footer
 * Lesson 3
 * Entering Numeric Values
 * Edit Cells
 * Using AutoComplete
 * Using a Pick list
 * Check Spelling


 * Lesson 2 Apply (Page 360)
 * Lesson 3 Apply (Page 369)

Homework:
 * Complete vocabulary (Lessons 2 & 3)

Wednesday & Thursday, February 10 & 11
Warm Up: Lesson: media type="youtube" key="ODNC-4oth4Q" width="420" height="315"
 * Open notebook (spot check) begin working on vocabulary
 * Lesson 4
 * Apply Themes
 * AutoFit Columns
 * Formatting Cells
 * Applying Cell Styles
 * Merge and Center
 * Apply number Formats
 * Lesson 5
 * Formatting Dates
 * Autofill
 * Flash fill
 * Align Cells
 * Column widths/row heights
 * Lesson 4 Apply (Page 379)
 * Lesson 5 Apply (Page 388)

Homework:
 * Complete any vocabulary or Apply activities not completed in class

=Week 25 =

Tuesday/Wednesday February 16 & 17
__**Warm Up**__: __**Lesson**__: media type="youtube" key="QWHPtpenpmo" width="420" height="315" Lesson 6 Lesson 7
 * Quiz: GMetrix Excel Quiz
 * Vocabulary Excel Lesson 7
 * Selecting multiple cells
 * Merge and center
 * Set column widths/row heights
 * Add cells together
 * Multiply cells
 * Divide cells
 * Use autosum function
 * Use fill handle to copy formulas

Lesson 6 Apply (Page 395) Lesson 7 Apply (Page 402)

__**Homework**__:
 * Finish Vocabulary that was not done in class
 * Complete any Apply activities not completed in class

Thursday/Monday, February 18 & 22
Warm Up: __**Lesson**__: media type="youtube" key="o9nV6Frb4Qc" width="420" height="315" Lesson 8
 * See classroom board
 * Cut/Copy/Paste
 * Paste Values
 * Insert Function tool
 * Format paint cells
 * Relative references
 * Absolute references

Lesson 9:
 * Insert/Delete Rows & Columns
 * Hide/Unhide Rows and columns
 * Transpose Data

Lesson 8 Apply (Page 408) Lesson 9 Apply (Page 415 bottom)

Homework:
 * Complete vocabulary through Lesson 9

=Week 26=

Monday, February 22
Warm Up: __**Lesson**__: media type="youtube" key="o9nV6Frb4Qc" width="420" height="315" Lesson 8
 * See classroom board
 * Cut/Copy/Paste
 * Paste Values
 * Insert Function tool
 * Format paint cells
 * Relative references
 * Absolute references

Lesson 9:
 * Insert/Delete Rows & Columns
 * Hide/Unhide Rows and columns
 * Transpose Data

Lesson 8 Apply (Page 408) Lesson 9 Apply (Page 415 bottom)

Homework:
 * Complete vocabulary through Lesson 9

Tuesday/Wednesday February 23 & 24
__**Lesson**__: media type="youtube" key="vRfnjITNN3Q" height="360" width="480" Lesson 10:
 * Show formulas on spreadsheet
 * Change orientation
 * Print Titles
 * Center vertically and horizontally

Lesson 11
 * Use AutoSum (Add)
 * Use AutoSum (Average, Maximum, Minimum)
 * Use Insert Function (Median)

Lesson 10 Practice (Page 422) Lesson 11 Apply (Page 435) Skip steps 12-18

Homework:
 * Complete vocabulary through Lesson 10

Thursday/Monday February 25 & 29
Lesson: media type="youtube" key="W1e2m5Ffnv0" width="420" height="315" Lesson 12 Lesson 13
 * Create a Table in Excel
 * Format the table (Table style)
 * Using formulas in tables
 * Adding a Total Row (adjusting the total row)
 * Sorting Data
 * Filter Data
 * Use Name box to select cells
 * Create a Named Range
 * Use the named range in a formula

Lesson 12 Apply (Page 444) Lesson 13 Apply (Page 449)

=Week 27=

Tuesday/Wednesday March 1 & 2
Warm Up: Lesson: media type="youtube" key="nJ-qQiVrEOs" width="420" height="315" Lesson 14
 * Turn in Notebook (Lessons 6 - 11 will be graded)
 * Use the IF function
 * Use SumIf
 * Using Named Ranges in formulas

Video for Extra Credit Points - Excel Grader Project 1
media type="youtube" key="I-Gk2BvbxX0" width="420" height="315" Homework:
 * Lesson 14 Apply (Page 460) - Skip highlighted sections
 * Excel Grader Project 1
 * Handout
 * File
 * Notebook due next class

=Thursday/Monday March 3 & 7= media type="youtube" key="ZaedyR1jCYY" width="420" height="315" Lesson 15 (Text functions) Lesson 17 (Conditional Formatting)
 * __Lesson__**:
 * Use function: Concatenate
 * Use function: Left
 * Use function: Mid
 * Use function: Right
 * Standard Conditional Formatting
 * User defined Conditional Formatting


 * Lesson 15 Apply (Page 468)
 * Lesson 17 Apply (Page 478)

=Week 28=

Tuesday/Wednesday, March 8 & 9
__**Lesson**__: media type="youtube" key="Uq-gVqQ-M1U" width="420" height="315" Lesson 19 Lesson 20 media type="youtube" key="C5RpCcJ8t1k" width="420" height="315" Lesson 21
 * __Warm Up__**:
 * Vocabulary through lesson 21
 * Copy Worksheets
 * Rename Worksheets
 * Move Worksheets
 * Color Worksheet Tabs
 * Create 3D formulas (add & average)
 * Scaling
 * Print Titles
 * Print Column/Row headers
 * Set Print Area (review)
 * Insert Charts (Bar & Pie charts
 * Adding titles to charts
 * Removing Data from charts


 * Apply Lesson 20 (Page 498)
 * Apply Lesson 21 (Page 514)

Thursday/Monday, March 10 & 14
Warm Up:
 * Review Exercise (online instructions)

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)

Homework:
 * Notebook due next class (Lessons 12 - 21)

=Week 29=

Tuesday/Wednesday, March 15 & 16
Warm Up: Lesson: media type="youtube" key="tGWTQV59ikw" height="360" width="480"
 * [[file:Excel Review - Day 1.xlsx]]
 * Download the file & open
 * Instructions are in the file
 * Upload to Engrade (Excel Review 1)
 * Sorting Practice
 * Create new sheet
 * Rename sheets
 * Import Text File
 * Set Indent (Alignment)
 * Insert Picture
 * Create Hyperlink
 * Change color theme
 * Set document properties


 * Lesson 40 Practice (Page E-17)