MOS Performance Based Exam

MOS_OD_Excel_Associate_1220.pdf
I1-D2-ProfitLossSpreadsheet.xls
I1-D3-CountryRevenue.docx

__

 Helpful Links
 External link opens in new tab or windowMac and PC Keyboard Shortcuts

Calendar | External link opens in new tab or windowEbook |External link opens in new tab or window Elab | External link opens in new tab or windowPretest |External link opens in new tab or window

External link opens in new tab or windowURL & Course code  RYiHq61d-29989    Course ID Spring 2022

Schedule: Mondays and Wednesdays 6:30PM- 9:30PM    starts January 10, 2022   -   Meeting ID:

UNIT 1: THE BIG PICTURE

Overview Chapter 1: Introducing Microsoft Office and Using Common Features,  -External link opens in new tab or window January 10, 2022

Homework: Read pages 1-18

Pretest

UNIT 2- Microsoft Word

Chapter 1 Word - External link opens in new tab or windowJanuary 12, 2022

Homework: W1-R1 and W1-R2 pages 33-36. Submit on Elab

                        Excel: Read and review pages 192-205


Word Chapter 3: Creating Reports, page 73 -

Word Chapter 4: Creating a Promotional Brochure, page 123

Word Chapter 5: Using Mail Merge, page 163 -

UNIT 3: MICROSOFT EXCEL

Excel Chapter 1: Tracking Customer Data,  External link opens in new tab or windowJanuary 17, 2022


Homework: Chapter 1 all RYS - pages214-216

Image below is how I brought back the Auto Fill Button that was missing last night. It's generally easier to figure things out when it's quiet and no pressure. To start I clicked File, Options, Advanced.



Excel Chapter 2: Calculating Student Grades Using Formulas  External link opens in new tab or windowJanuary 19, 2022

Homework: upload AYS and project graders, Chapter 1 Test

E2-R1, E2-R3, AYS E2-A1, E2-A2


Excel Chapter 3:Performing Calculations Using Functions, page 247 External link opens in new tab or window

Homework: complete E3-R1, 2 & 3

Excel Chapter 4: Data Visualization and Images, page 267 External link opens in new tab or window

Homework: Project Grader for chapter 3 P1 & P2, chapter 3 test


Homework: chapter 4 AYS, Project graders and Chapter 4 test

Excel Chapter 5: Organizing Large Worksheets, page 293

Homework: chapter 5 RYS


Homework: chapter 5 AYS and Project grader

Review for Excel certification 


Test Prep


Homework: Complete test Excel CH 1-5 - unit test, Complete Gmetrix Skill review 1 and write down task numbers if you have a question

Sessions 1-3 notes are below


External link opens in new tab or windowGuide for passing the test

Notes for Class

VLookup
E8-A1-Invoices.xlsx
GMEtrix Excel Lessons.docx
411-Grilled Cheese Sales.xlsx
421-Fuel Expenses.xlsx
431-Truck Names.xlsx
November 29 lesson updated
Pivot tables
432-Truck Names.xlsx
511-Weekly Sales.xlsx
521-Weekly Sales.xlsx
E8-R1-Race.xlsx