Microsoft Office Specialist
Schedule: Mondays and Wednesdays 6:30PM- 9:30PM February 21, 2024 - April 15, 2024
Zoom Meeting ID: 851 0753 8202
UNIT 1: Overview and Intro class February 21, 2024
Homework: Word - Review up to page 15
Lesson 2 February 26, 2024
Homework: Word - Create an informal letter -
W1-R1 and upload it on elab.
W1-R2 page 35 & 37 ,
W1-R3 up to page 40
Lesson 3 February 28, 2024
Review Excel Chapter 1: Tracking Customer Data, pages 197-210
Homework: complete 55 and 67. Upload page 67
Lesson 4 March 4, 2024
Excel Chapter 2: Calculating Student Grades Using Formulas
Homework: E1-R1, E1-R2, E1-R3 mandatory, A1. A2, A3 and project graders optional
Lesson 5 March 6, 2024
Homework: Complete all Chapter 2 RYS, & AYS, and project graders , EYS optional
Try to do test for Chapter 2
Lesson 6 March 11, 2024
Homework: complete E3-R1,
All tests and assignments for chapters 1,2 should be completed
Homework: All tests and assignments for chapters 1,2,3 should be completed
and a Short Quiz
Lesson 8 March 18, 2024
Excel Chapter 4: Data Visualization and Images,
Homework: - RYS - E4-R1 & 2
Lesson 9 March 20, 2024
Homework: E4-A3 and Project graders 1 & 2 and one EYS
Complete tests 1-4
You can try the short quiz above to test your skills. It should auto grade
Lesson 10 March 25, 2024
Excel Chapter 5: Organizing Large Worksheets
Review E5-DYS. No homework to submit from this chapter yet.
Homework: chapter 5 Review DYS
Lesson 11 March 27, 2024
Homework: complete all Chapter 5 R1, R2 & R3
Lesson 12 April 1, 2024
Homework: complete all Chapter 5 project graders and optional E1-3
Notes for importing data is below. Redo the assignment on your own.
Lesson 13April 3, 2024
Review Section 1 of hand out sheets
Lesson 14 April 8, 2024
Redo Practice test 1
Lesson 15 April 10, 2024
Homework - Redo Practice test one and 2.
Remember to review: Import data, Print Titles, Inspect document, charts
Lesson 16
Lesson 17
Homework: Download Lesson 1-3., 123-Menu Items, 136-Sales Goals, 221-weekly sales, 311-Truck Info
Lesson 4 up to Left, Mid, right
Homework: Download Lesson 4 notes and all files needed for the lesson. We will probably use the ones starting with 4 (411-432)
Homework: Complete Gmetrix Skill practice 1 and write down task numbers if you have a question
Last test Practice 1 simulated
with Powerpoint lesson in the second hour
Download Lesson 1-3 Word Document below
MOS Performance Based Exam
Notes for Class