Microsoft Office Specialist

 2  Helpful Links   Mac and PC Keyboard Shortcuts. View the Excel tab for more shortcuts  Calendar 

Course https://lms.labyrinthelab.com/addcourse.php?code=UkGI2668-37532	ELAB
Course Code: UkGI2668-37532	Ebook: https://lablearning.webreader.io/#!/login COPILOT

Schedule: Mondays and Wednesdays 6:30PM- 9:30PM   July 10, 2024 - September 4, 2024

Zoom Meeting ID:  826 5827 9891

UNIT 1: Overview and Intro class      July 10, 2024

Homework: Word - Review up to page 14

Lesson 2   July 15, 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       July 17, 2024

Review Excel Chapter 1: Tracking Customer Data,   pages 197-210

Homework: E1-R1 & R2

Lesson 4   July 22, 2024

Excel Chapter 2: Calculating Student Grades Using Formulas

Homework: E1-R1, E1-R2, E1-R3 mandatory, A1. A2, A3 and project graders

Lesson 5 July 24, 2024

Homework: Complete all Chapter 2 RYS,  & AYS, and project graders , EYS optional

Try to do test for Chapter 2

Lesson 6 July 29, 2024

Homework: complete E3-R1,

 and a Short Quiz

Lesson 8  August 1, 2024

Excel Chapter 4: Data Visualization and Images,

Homework: - RYS - E4-R1 & 2

Lesson 9   August 5, 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 August 7, 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 August 12, 2024

Homework: complete all Chapter 5 R1, R2 & R3

Lesson 12 August 14, 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 13August 19, 2024

Review Section 1 of hand out sheets

Lesson 14 826 5827 9891

Redo Practice test 1

Lesson 15

Homework - Redo Practice test one and 2.

Remember to review: Import data, Print Titles, Inspect document, charts

Lesson 16

Exam Review

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)