DIT+2016-17+Q3

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

This page will let you know what we will work on this week as well as what was completed last week. If you need a complete listing click on the Quarter link to the right.

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

=Week 20=

Monday & Tuesday, January 9 & 10
Warm Up: __**Lesson**__:
 * Log into Engrade (Check 2nd quarter grade, Mid-Term)
 * Log into Schoology (See your grade for Mid-Term --> In 2nd Quarter Folder)
 * Create Log in for GMetrix.net
 * Put GMetrix username and password in your notebook
 * Give Mr. Miller your GMetrix log in information.

Using the Snipping Tool
media type="custom" key="28944674"

Test Prep Topics
media type="custom" key="28944678"
 * Applying fills to shapes and pages
 * SmartArt
 * Tables
 * Multilevel list
 * Hyperlinks

Wednesday & Thursday, January 11 & 12
Warm Up: Review: Using the Snipping Tool media type="custom" key="28944682"

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 21 =

Tuesday & Wednesday, January 17 & 18

 * Log into Outlook (Show Mr. Miller you can log in/know your password)

__**Lesson**__: media type="custom" key="28958216"
 * How to Install Office 365 (Office 2013) on your Computer
 * Video Questions: Installing Microsoft Office (Repeat quiz until you score a perfect score)

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 & Monday, January 19 & 23** Complete **GMetrix Word 2013 Core Test 1** (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.

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.

=Week 22 =

Tuesday & Wednesday, January 24 & 25
Complete **GMetrix Word 2013 Core Project 1** (Testing Mode)
 * 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.

Thursday & Monday, January 26 & 31
__**Warm Up**__: media type="custom" key="28964721" 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 you can log in)
 * Exam Group ID: 1813799
 * 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:
 * [[file:Review Before Certification Test.pptx]] Instructions
 * [[file:Review before Certification.docx]]
 * [[file:Rose Types.docx]]
 * [[file:Rose.zip]]
 * 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

 * Prepare for exam in GMetrix
 * Sign up & take exam (Certiport)
 * Exam Group ID: 1813799

Once the certification exam is taken and passed, work will begin in Excel
 * GMetrix: Excel 2013 Core Test 1 in Training Mode

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.

=Week 24 =

Tuesday & Wednesday, February 7 & 8
__**Warm Up**__:
 * 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**__: media type="custom" key="28996429" Homework:
 * 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)
 * Complete vocabulary (Lessons 2 & 3)

Thursday & Monday, February 9 & 13
Warm Up: Lesson: media type="custom" key="28996435" Homework:
 * 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)
 * Complete any vocabulary or Apply activities not completed in class

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

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Tuesday/Wednesday, February 14 & 15
__**Warm Up**__:
 * Vocabulary Excel Lesson 7

__**Lesson**__: media type="custom" key="29014919" Lesson 6 Lesson 7 Lesson 6 Apply (Page 395) Lesson 7 Apply (Page 402)
 * 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

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

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Thursday/Monday, February 16 & 20
Warm Up: __**Lesson**__: media type="custom" key="29014925" Lesson 8 Lesson 9: Lesson 8 Apply (Page 408) Lesson 9 Apply (Page 415 bottom) Homework:
 * See classroom board
 * Cut/Copy/Paste
 * Paste Values
 * Insert Function tool
 * Format paint cells
 * Relative references
 * Absolute references
 * Insert/Delete Rows & Columns
 * Hide/Unhide Rows and columns
 * Transpose Data
 * Complete vocabulary through Lesson 9

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

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Tuesday/Wednesday, February 21 & 22
__**Lesson**__: media type="custom" key="29027145" Lesson 10: Lesson 11 Lesson 10 Practice (Page 422) Lesson 11 Apply (Page 435) Skip steps 12-18 Homework:
 * Show formulas on spreadsheet
 * Change orientation
 * Print Titles
 * Center vertically and horizontally
 * Use AutoSum (Add)
 * Use AutoSum (Average, Maximum, Minimum)
 * Use Insert Function (Median)
 * Complete vocabulary through Lesson 10

=Week 27=

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Thursday/Monday February 23 & 27
Lesson: media type="custom" key="29027147" Lesson 12 Lesson 13 Lesson 12 Apply (Page 444) Lesson 13 Apply (Page 449)
 * 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

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Tuesday/Wednesday, February 28 & March 1
Warm Up: Lesson: media type="custom" key="29039193" Lesson 14
 * Turn in Notebook (Lessons 6 - 11 will be graded)
 * Use the IF function
 * Use SumIf
 * Using Named Ranges in formulas

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Video for Extra Credit Points - Excel Grader Project 1
media type="custom" key="29039203" Video says extra credit, but it is an assignment: it is your Diving In Assignment Save the file to your OneDrive folder so you can work on it at home. This file gets turned into the __**Pearson Course**__ and is graded right away. I have placed a turn in for Engrade for the student that does NOT read this or is unable to log into Pearson at home.
 * [[file:rbma-it/Excel CH1 GraderProject Instructions.pdf|Handout]]
 * Get to the file by logging into Pearson
 * Course Materials
 * Student Resources
 * Grader Projects
 * Excel 2013 Grader Projects
 * Excel Chapter 1 Grader Project [Homework]
 * Download the file that has your name

Homework:
 * Lesson 14 Apply (Page 460) - Skip highlighted sections
 * Notebook due next class

=Week 28= =<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Thursday/Monday, March 2 & 6 = media type="custom" key="29051799" Lesson 15 (Text functions)
 * __Lesson__**:
 * Use function: Concatenate
 * Use function: Left
 * Use function: Mid
 * Use function: Right

Lesson 17 (Conditional Formatting) Lesson 15 Apply (Page 468) Lesson 17 Apply (Page 478)
 * Standard Conditional Formatting
 * User defined Conditional Formatting

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Tuesday/Wednesday, March 7 & 8
__**Lesson**__: media type="custom" key="29056639" Lesson 19
 * __Warm Up__**:
 * Vocabulary through lesson 21
 * Copy Worksheets
 * Rename Worksheets
 * Move Worksheets
 * Color Worksheet Tabs
 * Create 3D formulas (add & average)

Lesson 20
 * Scaling
 * Print Titles
 * Print Column/Row headers
 * Set Print Area (review)

media type="custom" key="29056635" Lesson 21 Apply Lesson 20 (Page 498) Apply Lesson 21 (Page 514) Homework:
 * Insert Charts (Bar & Pie charts)
 * Adding titles to charts
 * Removing Data from charts
 * Notebook due next class (Lessons 12 - 21)

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Thursday/Monday, March 9 & 13
Warm Up:
 * [[file:Excel Review - Day 1.xlsx]]
 * Download the file & open
 * Instructions are in the file
 * Upload to Engrade (Excel Review 1)

Lesson: media type="custom" key="29056611"
 * 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)

=Week 29=

<span style="color: #333333; font-family: arial,helvetica,sans-serif;">Tuesday/Wednesday/Thursday, March 14, 15 & 16
Warm Up:
 * =<span style="color: #333333; font-family: arial,helvetica,sans-serif;"> =
 * Review Exercise (online instructions)
 * Turn in Notebook

Lesson: Begin Review of Excel in GMetrix.
 * GMetrix: Excel 2013 Core Test 1 (Training Mode)
 * 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
 * Must score at least 90%
 * Excel Review Test 2 (Formulas, Data) - (Training Mode)
 * Excel Review Test 1 (Charts, Tables, Images) (Training Mode - score 90% or better)