Wednesday,January 7, 2015

Learning Target: I can demonstrate my knowledge of Microsoft Excel – Organizing and Enhancing Worksheets!

Bellwork 7:In the Structures worksheet, freeze the top row. Hide Column F. In Buildings, apply conditional formatting to highlight the values for all buildings completed after the year 2000.

Agenda:

  • Lesson 19 CheckList– Due Wed, Jan 7
  • Complete Digital Driver’s License before end of year for test grade

Early Finish Choices:

oACT Question of the Day

oExcel IT Books

oReview previous lesson(s) training in SAM. Good review/repetition for IC3 certification exam.

oUCertify.com(IC3 Practice Tests)

oRead ahead in text

oMerriam Webster Spelling and Vocabulary Daily Quizzes

oTyping early finish activities link on teacher website.

oW3schools.com coding practice

oTechTerms.COM Questions and Term of the Day

oLearn something new on Khan Academy

oLearn something new on WolfRamAlpha:

oTo learn more about Operating Systems; Watch video Lectures 1-9:

oShare Get to Know Me Projects as time permits

Certiport Exam #2 Helps:

Excel Keyboard ShortCuts

Module 2 Lesson 19 Checklist – Due January 7, 2015
Name: ______Date: ______Class Period: ______
(52 points) (a)SAM Training at 100% -- OR – (b)Step by Step 19.1 thru Step by Step 19.15 submit files to website
(10 points) Complete Project 19-1. Submit file to website: ‘Revised Courses + your initials’
(10 points) Complete Project 19-2. Submit file to website: ‘Revised Support 1 + your initials’
(15 points) Complete Project 19-3. Submit file to website: ‘Revised Tall Structures + your initials’
(7 points) Complete Project 19-4. Submit file to website: ‘Updated Expense Report + your initials’
(7 points) Complete Project 19-5. Submit file to website: ‘Revised Updated Expense Report + your initials’
(11 points) Written bolded words from Lesson – attach and turn in
(25 points) Submit written answers for Lesson Review (T/F, MC, Short answer) Complete on your own then check/correct your answers.
TOTAL POSSIBLE POINTS: 137
______/137
Module 2 Lesson 19 Checklist – Due January 7, 2015
Name: ______Date: ______Class Period: ______
(52 points) (a)SAM Training at 100% -- OR – (b)Step by Step 19.1 thru Step by Step 19.15 submit files to website
(10 points) Complete Project 19-1. Submit file to website: ‘Revised Courses + your initials’
(10 points) Complete Project 19-2. Submit file to website: ‘Revised Support 1 + your initials’
(15 points) Complete Project 19-3. Submit file to website: ‘Revised Tall Structures + your initials’
(7 points) Complete Project 19-4. Submit file to website: ‘Updated Expense Report + your initials’
(7 points) Complete Project 19-5. Submit file to website: ‘Revised Updated Expense Report + your initials’
(11 points) Written bolded words from Lesson – attach and turn in
(25 points) Submit written answers for Lesson Review (T/F, MC, Short answer) Complete on your own then check/correct your answers.
TOTAL POSSIBLE POINTS: ______/137
Module 2 Lesson 20 Checklist – Due January 12, 2015
Name: ______Date: ______Class Period: ______
(32 points) (a)SAM Training at 100% -- OR – (b)Step by Step 20.1 thru Step by Step 20.10 submit files to website
(5 points) Complete Project 20-1. Submit file to website: ‘Revised MPG Data + your initials’
(10 points) Complete Project 20-2. Submit file to website: ‘Revised Q2 Mileage + your initials’
(10 points) Complete Project 20-3. Submit file to website: ‘Revised Oakland Sales + your initials’
(10 points) Complete Project 20-4. Submit file to website: ‘Revised City Data + your initials’
(5 points) Complete Project 20-5. Submit file to website: ‘Revised Utility Summary + your initials’
( 5 points) Watch video:
(15 points) Complete Flash Cards in SAM
(20 points) Submit written answers for Lesson Review (T/F, MC, Short answer) Complete on your own then check/correct your answers. Attach and turn into yellow basket.
TOTAL POSSIBLE POINTS: 112
______/112

Online Classroom: