Term 3 Materials
Part A: Editing a Worksheet
Week 1: Edit, Move, Insert, Undo & Replace
Lesson Plan 1
Lesson Plan 2
Worksheet 1
Week 2: Formatting, Adjusting & Alignment
Lesson Plan
Quiz 1
Week 3: Styles, Themes, Conditional Formatting
Lesson Plan 1
Lesson Plan 2
Worksheet 2
Homework 1
Part B: Working with Charts
Week 4: Choosing Data, Changing Data, Layout & Style
Lesson Plan 1
Lesson Plan 2
Part C: Managing Workflow
Week 5: Splitting, Freezing & Page Setup
Lesson Plan 1
Homework 2
Project 1
Quiz 2
Week 6: System-Wide Quiz
Part D: Functions & Formulas
Week 7: Multiple Operators, Calculations & Logic
MOS - Task 3
Week 8: Hyperlinks, VLookup, Filtering & Sorting
Worksheet 3
Quiz 3
Week 9: Office Specialist Exam
Exam Review
Week 10: End-of-Year Exam
Lesson Plan 1
Lesson Plan 2
Worksheet 1
Week 2: Formatting, Adjusting & Alignment
Lesson Plan
Quiz 1
Week 3: Styles, Themes, Conditional Formatting
Lesson Plan 1
Lesson Plan 2
Worksheet 2
Homework 1
Part B: Working with Charts
Week 4: Choosing Data, Changing Data, Layout & Style
Lesson Plan 1
Lesson Plan 2
Part C: Managing Workflow
Week 5: Splitting, Freezing & Page Setup
Lesson Plan 1
Homework 2
Project 1
Quiz 2
Week 6: System-Wide Quiz
Part D: Functions & Formulas
Week 7: Multiple Operators, Calculations & Logic
MOS - Task 3
Week 8: Hyperlinks, VLookup, Filtering & Sorting
Worksheet 3
Quiz 3
Week 9: Office Specialist Exam
Exam Review
Week 10: End-of-Year Exam
Term 2 Materials
Part A: Microsoft Excel Specialist
Week 5: Creating and Manipulating Data
Week 6: Formatting Data and Content
Week 7: Named & Absolute Cell References
Week 8: Creating & Modifying Formulas
Week 10: IC3 Module 2 Review
Week 11: Final Exam Review
Week 12: Final Exam
Term 1 Materials
Course Outline Term 1 TAG MOS Study Guide
Part A: Introduction to Technology
Week 1: Account Setup & Recovery
My Account Settings
Week 2: Microsoft Office Applications
MS Word Video
Word Review
Week 3: Word Processing Functions
Word Resume Practice
Portfolio Task 1
Week 4: Word Processing Functions
Resume Worksheet
Resume Supplement
Week 5: Word Processing Functions
Creating the Perfect Resume
Minor Assessment 1
Week 6: Word Processing Functions
Project 1
Quiz Review
Week 7: Presentation Software
Creating a Presentation
Portfolio Task 2
Week 8: Presentation Software
Animation and Transitions
Project 2
Week 9: Intro to Excel
Creating a Spreadsheet
Minor Assessment 2
Week 10: Formatting a Spreadsheet
Lab Assignment 1
Portfolio Task 3
Week 11: Formulas & Graphs
Lab Assignment 2
Portfolio Task 4
Week 12: IC3 Review
Module 2 Review Video
MS Word Glossary
MS Word 2007 Review
Week 13: IC3 Exam
MS PowerPoint Glossary
MS PowerPoint 2007 Review
Week 14: IC3 Exam
MS Excel Glossary
MS Excel 2007 Review
Week 15: Final Exam Review
Final Exam Review 1
Final Exam Review 2
Final Exam Review 3
Final Exam Review 4
Final Exam Review 5
My Account Settings
Week 2: Microsoft Office Applications
MS Word Video
Word Review
Week 3: Word Processing Functions
Word Resume Practice
Portfolio Task 1
Week 4: Word Processing Functions
Resume Worksheet
Resume Supplement
Week 5: Word Processing Functions
Creating the Perfect Resume
Minor Assessment 1
Week 6: Word Processing Functions
Project 1
Quiz Review
Week 7: Presentation Software
Creating a Presentation
Portfolio Task 2
Week 8: Presentation Software
Animation and Transitions
Project 2
Week 9: Intro to Excel
Creating a Spreadsheet
Minor Assessment 2
Week 10: Formatting a Spreadsheet
Lab Assignment 1
Portfolio Task 3
Week 11: Formulas & Graphs
Lab Assignment 2
Portfolio Task 4
Week 12: IC3 Review
Module 2 Review Video
MS Word Glossary
MS Word 2007 Review
Week 13: IC3 Exam
MS PowerPoint Glossary
MS PowerPoint 2007 Review
Week 14: IC3 Exam
MS Excel Glossary
MS Excel 2007 Review
Week 15: Final Exam Review
Final Exam Review 1
Final Exam Review 2
Final Exam Review 3
Final Exam Review 4
Final Exam Review 5
No comments:
Post a Comment