AHelpful Links   External link opens in new tab or windowMac and PC Keyboard Shortcuts. View the Excel tab for more shortcuts  Calendar 
Course URL:https://lms.labyrinthelab.com/addcourse.php?code=38n0G65d-36753
 External link opens in new tab or windowELAB
Course Code: 38n0G65d-36753External link opens in new tab or windowEbook: https://lablearning.webreader.io/#!/login
External link opens in new tab or windowCOPILOT

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      External link opens in new tab or windowFebruary 21, 2024

Homework: Word - Review up to page 15


Lesson 2   External link opens in new tab or windowFebruary 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        External link opens in new tab or windowFebruary 28, 2024

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

Homework: complete 55 and 67. Upload page 67


Lesson 4External link opens in new tab or window  External link opens in new tab or window External link opens in new tab or windowMarch 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 External link opens in new tab or windowMarch 6, 2024

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

Try to do test for Chapter 2


Lesson 6 External link opens in new tab or windowMarch 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 External link opens in new tab or windowShort Quiz


Lesson 8 External link opens in new tab or windowMarch 18, 2024

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

Homework: - RYS - E4-R1 & 2


Lesson 9 External link opens in new tab or windowMarch 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 External link opens in new tab or windowMarch 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 External link opens in new tab or windowMarch 27, 2024

Homework: complete all Chapter 5 R1, R2 & R3



Lesson 12 External link opens in new tab or windowApril 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 13External link opens in new tab or windowApril 3, 2024

Review Section 1 of hand out sheets


Lesson 14 External link opens in new tab or windowApril 8, 2024

Redo Practice test 1


Lesson 15 External link opens in new tab or windowApril 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: 521-Weekly sales. Compete and email to me cookiesetton@gmail.com


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

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

Download Lesson 1-3 Word Document below


MOS Performance Based Exam

MOS_OD_Excel_Associate_1220.pdf
Excel Lessons 1-3
112-Gourmet Weekly Sales.txt
112-Dessert Weekly Sales.csv
123-Menu Items.xlsx
136-sales-goals .xlsx
I1-D3-CountryRevenue.docx
221-Weekly Sales.xlsx
232-Daily Truck Sales Log.xlsx
231-Daily Truck Sales Log.xlsx
311-Truck Info.xlsx
321-Truck Info.xlsx
111-instructors.txt
112-class schedule.csv
Importing Data.docx

__

Notes for Class

Lesson 4
411-Grilled Cheese Sales.xlsx
412-student budget.xlsx
421-Fuel Expenses.xlsx
431-Truck Names.xlsx
432-Truck Names.xlsx
511-Weekly Sales.xlsx
531-Weekly Sales.xlsx
532-Weekly Sales.xlsx
531-Food Truck Logo.png
Inv 123.xlsx
Themes
Properties, Accessibility
521-Weekly Sales.xlsx
Pivot tables