| Week 12; Nov. 9-13 |
|
| Monday -- Download Datafiles for Lesson 3 EXCEL begin Steps pages 226 - 257
Tuesday -- Finish Steps Excel Lesson 3 do Guided Activities 1, 2, 3 & 4 pages. 261-263
Wednesday -- Finish Steps, Guided Activities then do Do It Yourself 1, 2 & 3 pages 264-267
Thursday -- 2nd Six-weeks Test -- work on Lesson 3 assignments
FRIDAY -- Make Up DAY; all 1st 6-wks work must be turned in today; or be working on Lesson 3 assignments.
|
| LESSON 3 Check list for PRINTING assignments |
| STEPS Print Black Text do NOT print GREEN TEXT
Job Openings useing filters DO NOT PRINT
Formulas -- pgs 229-232
Tenant Space -- pgs 233-234
Qtr1 Sales -- pg 235--238
Loan Comparison -- pg 239-241
Template Balance Sheet Save as BalanceSheet2-- pgs244-245
Sales Charts -- pg 247-250
Qtr2 Sales -- 250-252
Loan Comparison -- pg 253-254
Qtr2 Sales -- pg 254-255 DO NOT PRINT Web Discussions
Job Openings -- Save as web page DO NOT PRINT
DUE TO THE SIZE OF THIS LESSON WE WILL PRINT IN 2 SECTIONS STEPS TURNED IN TOGETHER THEN GUIDED ACTIVITIES AND DO IT YOURSELF ASSIGNMENTS. |
| Guided Activities
1. Expense Summary 2 -- pg 261
2. Payroll2 -- pgs 261-262
3. Loan Amortization Template -- pg 262
4. College Budget 2 -- pg 263
Do It Yourself
1. Blank Workbook -- Order of Operations -- pg 264-265
2. Sales Data 2 -- pg. 265
3. Payroll 3 -- pg 266-267 |
|
| Week 11; Nov 2 - 6 |
MONDAY -- Realignment Finish Lesson 2
TUESDAY -- Finish L2=esson 2
WEDNESDAY -- Begin Currency Conversion Project
THURSDAY -- Test Excel Lesson 1. Currency Conversion Project
FRIDAY - Finish Conversion Project. |
| Week 10; Oct. 26-30
|
| MONDAY -- Finish All Assignments required on checklist for Lesson 1 and print. Begin Excel Lesson 2 by downloading data files if you are finished with everything for lesson 1 and do not owe for any other work
TUESDAY -- Begin Lesson 2 Excel step by step assignments. Page. 188-212. PRINT the files when finished and then keep in the new folders you will receive today. Start Guided Activities 1 & 2 on pages 217-219, then print these as well keeping the assignments in order.
WEDNESDAY -- Do It yourself assignments 1 - 4 pages 219-222. Print these and keep in folder.
THURSDAY -- Test Excel Lesson 1.
FRIDAY - Handout assignment for currency Conversion Project. Files to be printed WITH your name in a Header: Stapled in this Order. Finished by FRIDAY -- October 30.
1. Mall Employees -- print at page 202
2. Facts & Figures -- print at page 211 & 213
3. Profit & Loss -- pg 217
4. Expense Summary -- pg 218
5. College Budget -- pgs 219-220
6. Inventory -- from new file -- pg 221
7. Balance Sheet -- pg 222
|
|
|
| Week 9; Oct. 19-23 |
| MONDAY -- Walk through expectations of Excel.
TUESDAY -- Begin Lesson 1 Unit 2 Excel step by step assignments. Page 161-177. Guided Activities 1 & 2 on pages 181-183.
WEDNESDAY -- Do It yourself assignments 1 - 4 pages 183-185.
THURSDAY -- Review Study Guide for Lesson 1 test.
FRIDAY -- Challenge Problem page 186-187 |
| Week 8; Oct. 12-16 |
MONDAY--Continue work on Menu/Webpage project.
TUESDAY -- Final day for MENU Project, late after today.
WEDNESDAY -- Do Parent Companies table with internet research
THURSDAY -- Test Lesson 4; Do Synonyms Assignment
FRIDAY -- Introduction to Excel, class follow along. If time, download datafiles for Lesson1 in Excel. Discuss filenames for this unit. |
| Week 7; Oct. 5-9 |
Monday: Short schedule: download datafiles for lesson 4; short review of skills in lesson 4,
Tuesday: Begin Lesson 4 steps.
Wednesday: Finish Lesson 4 steps and then the Do It Yourself assignments pgs. 143-145, Challenge problem pgs. 145-148.
Thursday: Online review Lesson 4 test Review of skills before project begins.check save location is in folder.
Friday: Begin Menu Project for test grade...expected finish date Monday. Late after Tuesday. |
|
| Week 6; Sept. 28- Oct. 2 |
| Monday -- Return Tests for Lessons 1, 2 & 3; Discuss Styles and Column Features
Tuesday -- Complete work for columns to turn previous typing assignment into newsletter columns.
Wednesday -- Makeup work day
Thursday -- Six-weeks test, then any makeup work needs to be finished and turned in. Six weeks test will be taken fromt he previous 3 chapter/lesson tests.
Friday -- Video Streaming. |
|
| Week 5; Sept. 21-28 |
| Monday -- Landmarks Assignment, using Internet and tables features to organize information
Tuesday -- Continue Landmarks
Wednesday -- Picture Day, Substitute, Landmarks Assignment
Thursday -- Begin keying report to be used next week to learn styles and newsletter columns
Friday -- Lesson 3 Test |
|
| Week 4; Sept. 14th-18th |
| Monday -- Download datafiles for lesson 3; work on pages 80-110.
Tuesday -- Finish steps Lesson 3 pgs 80-110. Then the Do It Yourself Problems 1 & 2 pgs. 115-116,
Wednesday -- Challenge Yourself Problem page 120- 121
Thursday -- Test Lesson 2. Certiprep when finished with test
Friday -- Table Activity. |
|
| Week 3; Sept. 7th-11th |
| MONDAY -- Holiday, no school
TUESDAY -- Finish Lesson 2 steps if needed, Do the Guided Activities; 1 & 2 pg 73-75 Study for Test Tomorrow, Study Guide is on BCIS1-09, then work on Certiprep until the end of class.
WEDNESDAY -- TEST Lesson 1 from study guide provided last Wed. Challenge Yourself, Polish a Research Paper, page 79
THURSDAY -- Test Review for Lesson 2; Begin Teacher created assignment. Finish Challenge problem, UPLOAD Challenge Problem pg 79 & Guided Activity 1 & 2 pgs 72&75
FRIDAY -- Pop Quiz – Lesson 2 Finish Teacher created assignment.
|
|
| Week 2 Aug 31- Sept 4 |
Monday -- downloaded datafiles for Lesson 1: started steps lesson 1 pages 2-29
Tuesday -- continue steps until finished then beginDo it Yourself Assignments #1 & #3 pages 35 & 36.
Wednesday -- Lesson 2 test review finish Lesson 1. Lesson 1 test will be next Wednesday, Sept 9th
Thursday -- Discussion Business Connections & Career Corners in Lesson 1: Download datafiles for lesson 2, begin lesson 2 pages 41-65 doing the steps.
Friday -- Continue with lesson 2, when finished with steps work on the Certiprep software. |
|
| Assignments for the Week of Aug. 24th-28th |
Monday -- Class discussions of rules, expectations and requirements for the class this year. Students will also be required to present a signed copy of the AUP form before they will be allowed on the network.
Tuesday -- Class Discussion of Internet Safety and Network Requirements. Begin logins as soon as they are ready.
Wednesday -- File Management and the use of the Teacher's Website. Download Data Files if there is time. Continue with passwords, File Saving and filenames within the network system.
Thursday -- Begin Review of MS Word functionality basics, and use of templates.
Friday -- Working with drawing tools in word to create flyer for hallways using school theme. |
|
|
|
|
