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

Schedule: Mondays and Wednesdays 6:30PM- 9:30PM  - Feb 3, 2025


UNIT 1: Overview and Intro class        FExternal link opens in new tab or windowebruary 3, 2025

Homework: Word - Review up to page 16


Lesson 2 -External link opens in new tab or windowFeb 5, 2025

Homework: Word - Create an informal letter -

W1-R1 and upload it on elab.   

W1-R2  page 35 & 37, W1-R3 up to page 40


On Monday there will be a new format to the class.  All questions should be entered into the chat. I will address them along the way. 5 minutes before break, so that those that are comfortable with the work can take a longer break.



Lesson 3 External link opens in new tab or windowFebruary 10, 2025

Homework - E1-R3, E1-A1, A2, A3, E1-P1, P2 - Due by Feb. 16


Lesson 4    External link opens in new tab or window February 12, 2025


Homework: complete E3-R1, all assignments for chapters 1,2, should be completed


Lesson 5   External link opens in new tab or windowFebruary 17, 2025


Excel Chapter 4: Data Visualization and Images,

Homework: E1-R1, E1-R2,


Lesson 6  External link opens in new tab or windowFebruary 19, 2025

Complete E4-A1, A2, E4-P1, P2


Review the work we covered in class



Lesson 7 External link opens in new tab or windowFebruary 25, 2025

Homework: complete  Chapter 5 R1-R3



Homework: E5 project grader


 and a External link opens in new tab or windowShort Quiz


Lesson 9 External link opens in new tab or windowMarch 3, 2025

Homework, complete lesson 4 from handouts and 2 and 3. You can email it to me cookiesetton@gmail.com



LESSON 10 - External link opens in new tab or windowMARCH 10.2025

Homework: If you got into Gmetrix, review Practice 1. If not please reach out to support.

Watch the youtube videos from Lesson 12 below




Lesson 11

Notes for importing data is below. Redo the assignment on your own.

Review Section 1 of hand out sheets



Lesson 12

Review the following topics:

I linked a YouTube short video of each Function. Some of these will only work on Excel 365



Lesson13   Dec. 11, 2024

Review Lesson 4, GMetrix practices. Time yourself and see if it improves


Lesson 14  Dec 16, 2024

Exam





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


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
Class list.xlsx

__

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
vlookup.pdf