High School Computer Applications Lesson Plans


Exam Study Guide

Edline Update Note: Grades are posted to Edline with a “0” on all missed assignments, regardless of absences.  If the zero is due to an absence, you have time to make it up and get a grade for it.  The zero simply shows you what your grade will be if you don’t do your make up work.

Week of May 5th – 9th:

 

Monday

Catch Up Day

Tuesday

Jasc Paintshop Pro – Resizing Images and Picture Manipulation

Wednesday

Continue Picture Manipulations

Thursday

Finish Picture Manipulations

Friday

Review Microsoft Word

 

Week of May 12th – 16th:

 

Monday

Review Microsoft Excel

Tuesday

Review Microsoft Access

Wednesday

Review Microsoft PowerPoint

Thursday

Review Desktop Basics

Friday

Review Email Basics

 

Week of May 19th – 23rd:

 

Monday

Prepare for Exam (period 1 will take the exam today)

Tuesday

Exams -2nd and 5th periods

Wednesday

Exams – 3rd and 6th periods

Thursday

Exams – 4th and 7th periods

Friday

Exams – 8th period

 

 

 

_________________________________________________________________________________________________________________________________________________________

Week of August 6-10:

Monday

 Teacher In-Service

Tuesday

 Teacher In-Service

Wednesday

 First Day of High School w Half Day

Thursday

 No School

Friday

 Go over Groupwise E-mail System w Set Backgrounds w Internet Search Engines

Week of August 13-17:

Monday

Go over net drive, accessing school e-mail from home and have an introduction to typing (home row)

Tuesday

Introduction to Microsoft PowerPoint (pages 497-508) w Typing Bottom Row Keys

Wednesday

Typing Top Row Keys

Thursday

Typing Number Keys w Microsoft PowerPoint (pages 502-508)

Friday

Typing Practice w Microsoft PowerPoint (pages 508-515)

Week of August 20-24:

Monday

Typing Practice w Microsoft PowerPoint (pages 515-518) w Begin Chapter Summary Notes

Tuesday

 Typing Practice w Finish Chapter Summary Notes w Do PowerPoint Vocabulary

Wednesday

 Go over various drives and create folders w Practice e-mailing with attachments w Typing Practice

Thursday

 Set up templates for every class in Microsoft Word w Begin Class Assignments in PowerPoint Exercises (1-6) Due Tuesday

Friday

Work on PowerPoint Exercises (Due Tuesday) w Typing Practice on typershark.com or freetypinggame.net

Week of August 26-31:

Monday

  Work on PowerPoint Exercises (Due Tuesday) w Typing Practice on typershark.com or freetypinggame.net

Tuesday

 Work on PowerPoint Exercises (Due by the end of class) w Typing Practice on typershark.com or freetypinggame.net

Wednesday

 Beginning PowerPoint TEST

Thursday

 Typing Practice w PowerPoint pages 533-538

Friday

 No School

Week of September 3-7:

Monday

 No School

Tuesday

 Typing Practice w PowerPoint pages 538-541

Wednesday

 Typing Practice w PowerPoint pages 541-544

Thursday

 Typing Practice w PowerPoint pages 545-550

Friday

 Typing Practice w Create Chapter Summary Notes w Vocabulary

Week of September 10-14:

Monday

 Typing Practice w Begin Exercises 1-5 (Due Wednesday)

Tuesday

 Typing Practice w Work on Exercises 1-5 (Due Wednesday)

Wednesday

 Typing Practice w Finish Exercises 1-5 (Due by the End of Class)

Thursday

 TEST on Advanced PowerPoint

Friday

 View PowerPoints

Week of September 17-21:

Monday

 Begin Microsoft Word, pages 87-92

Tuesday

 Word, pages 93-98

Wednesday

 Word, pages 98-105

Thursday

 Word, pages 105-111 w Take Notes for Study Guide

Friday

 Assign Exercises 1, 3, 7 and 11 (due Wednesday by the end of class)

Week of September 24-28:

Monday

 Continue Exercises from Chapter 4 (Exercises 1, 3, 7 and 11)

Tuesday

 School Picture Day w Work on Exercises from Chapter 4 (Exercises 1, 3, 7 and 11)

Wednesday

 Finish exercises by the end of class w Test tomorrow! w Take Notes for Test

Thursday

 Test on Chapter 4

Friday

 Begin Formatting Documents w Pages 129-138

Week of October 1-5:

Monday

 Word, 138-146

Tuesday

 Word, 146-152 w Begin Exercises 1, 3, 5 and 7 (Due Friday by the end of class)

Wednesday

 Work on Exercises 1, 3, 5 and 7 (Due Friday)

Thursday

 Work on Exercises (Due Friday)

Friday

 End of First Quarter w Finish Exercises (Due today – no exceptions!)

October 8-12: Fall Break w No School!

Week of October 15-19:

Monday

½ Day – Work on Editing Pictures

Tuesday

Begin Unit on Desktop Publishing w Using Tables, pages 175-178

Wednesday

Format Styles, Hyphenating, and Using Outline View w Pages 178-183

Thursday

Creating a Table of Contents, a Hyperlink to a Heading, Sections, & Section Headers and Footers w Pages 183-188

Friday

Typing Test Day w Work on Homecoming Banners w Prepare for Pep Rally

Week of October 22-26:

Monday

Mrs. Deiss is in CA today.  You will have a substitute today.  For your assignment, click HERE.

Tuesday

Creating Diagrams and Organization Charts, Formatting Columns and Creating a Brochure w Pages 189-195

Wednesday

Creating a Newsletter, Pages 195-196

Thursday

Start working on Exercises 2 (p. 201) & 10 (make it about the school) - due Friday

Friday

Finish Exercises 2 & 10 and e-mail them to the teacher.

Week of October 29-November 2:

Monday

Take notes for the test

Tuesday

Test on Chapters 5 & 6 on Microsoft Word

Wednesday

Begin unit on Spreadsheets (entering data and editing cells) w pages 207-211

Thursday

Formatting Cells, Numeric Data, and Selecting Cells w pages 212-216

Friday

Using Formulas for Calculations & Displaying Formulas w pages 217-219

Week of November 5-9:

Monday

Using Cell References, Cut, Copy and Paste, and Copying Between Word & Excel w pages 219-224

Tuesday

Collaboration and E-mailing a Spreadsheet w pages 225-227

Wednesday

Adding a Picture, Hyperlinks in a Worksheet, Borders, Patterns & Color with Conditional Formatting w pages 228-232

Thursday

Templates and Creating an HTML file w pages 233-237

Friday

Chapter 7, Exercise 1 w page 245

Week of November 12-16:

Monday

NO SCHOOL – Veteran’s Day

Tuesday

Chapter 7, Exercise 2 w page 246

Wednesday

Chapter 7, Exercise 8 w page 252

Thursday

Chapter 7, Exercise 10 w page 253

Friday

Make Up Day and Typing Tests

Week of November 19-23:

Monday

Take Notes for Chapter 7 Test

Tuesday

Chapter 7 Test

Wednesday

NO SCHOOL – Thanksgiving Vacation

Thursday

NO SCHOOL – Thanksgiving Vacation

Friday

NO SCHOOL – Thanksgiving Vacation

Week of November 26-30:

Monday

Begin Chapter 8 on Working with Functions and Organizing Data w Pages 259-263 (Mileage Log)

Tuesday

Inserting a Function into a Formula, Common Error Values and The round Function w Pages 263-267 + Sorting Data, Inserting & Deleting Rows and Columns w Pages 267-269

Wednesday

Field Trip Day and Finish Yesterday’s Work

Thursday

The “If” Function, Printing a Large Worksheet and Using Text in the “If” Function w Pages 270-274

Friday

Participate in Science Project

Week of December 3-7:

Monday

Amortization Tables, the PMT Function, and Using Multiple Sheets w Pages 274-281

Tuesday

Chapter 8, Exercise 1 w page 287

Wednesday

Chapter 8, Exercise 3 w page 289

Thursday

Chapter 8, Exercise 7 w page 293

Friday

Chapter 8, Exercise 15 w pages 299-300

Week of December 10-14:

Monday

Take Notes for Test, Typing Test and Make Up Day

Tuesday

Test on Chapter 8, Working with Functions and Organizing Data

Wednesday

Work on Typing w Begin Taking Notes for Exam

Thursday

Work on Typing w Finish Taking Notes for Exam

Friday

Typing Test w Practice for Exam

Week of December 17-21 (STUDENTS WITH A 95% AVERAGE OR ABOVE [not rounded] ARE EXEMPT FROM THE EXAM):

Week of  December 17-21

 

Monday

8:15-9:45 1st Period Exam

10:00-11:30 5th Period Exam

Tuesday

8:15-9:45 2nd Period Exam

10:00-11:30 6th Period Exam

Wednesday

8:15-9:45 3rd Period Exam

10:00-11:30 7th Period Exam

Thursday

8:15-9:45 4th Period Exam

10:00-11:30 8th Period Exam

Friday

No School

 

December 21st-January 7th: Christmas Break

 

January 8th-11th: Interim Week

 

Week of January 14th-18th

 

Monday

Read Pages 301-303 w Practice: Continents Parts 1 and 2, pages 303-308

Tuesday

Read Pages 308-311 w Practice: Temperature Part 1, pages 311-318 w ½ of Class for Science Report Help

Wednesday

Read Pages 318-320 w Practice: Temperature Part 2, pages 320-324 w ½ of Class for Science Report Help

Thursday

Finish Previous Exercises and Get Help for Science Research Paper

Friday

Read Pages 324-325 w Begin Exercise 1 on pages 329-330: Education Expenses

 

Week of January 21st-25th

 

Monday

NO SCHOOL – Martin Luther King Day

Tuesday

Finish Exercise 1 on pages 329-330

Wednesday

Pages 332-333, Exercise 4: Country Statistics

Thursday

Pages 333-334, Exercise 5: Enrollment

Friday

Catch Up Day (Exercises 1, 4, and 5 due today)

 

Week of January 28th-February 1st

 

Monday

Page 335, Exercise 6: Break Even

Tuesday

Study for Test

Wednesday

Chapter 9 TEST on Creating Charts

Thursday

Read pages 343-344 w Practice: Employee Discount Program, pages 344-345

Friday

Read pages 345-349 w Practice: Payroll, 2 of 3, pages 349-350

 

Week of February 4th-8th

 

Monday

Read pages 351-352 w Practice: Payroll, 3 of 3, pages 352-353

Tuesday

Read pages 353-355 w Practice: Project Timeline, pages 355-357

Wednesday

Read pages 357-359 w Practice: Art Studio Students, pages 359-361

Thursday

Read page 362 w Practice: Company Name, pages 362-363 w Complete the practice exercise and e-mail it to Mrs. Deiss

Friday

Type out Chapter Summary and Vocabulary from pages 364 & 365 and e-mail it to the teacher.  This will be for a TEST grade.

 

Week of February 11th-15th

 

Monday

Read pages 377-382 w Practice: Widget parts 1 and 2 of 12, pages 381-389 (through step 7)

Tuesday

Finish part 2 pages 385-389 steps 8-9

Wednesday

Read pages 389-390 w Practice: Widget part 3 of 12, pages 390-394

Thursday

½ Day – Teacher in service (School is out at 11:45) w Periods 2, 4, 6 and 8 will meet, so we won’t meet.  Have a happy Valentine’s Day and President’s Day weekend.

Friday

NO SCHOOL – Teacher in service

 

Week of February 18th-22nd

 

Monday

NO SCHOOL – President’s Day

Tuesday

Read pages 394-396 w Practice: Widget part 4 of 12, pages 396-397

Wednesday

Read pages 398-399 w Practice: Widget part 5 of 12, pages 400-402

Thursday

Catch Up Day: Make sure you have three tables (completed) with three corresponding forms (completed).  Make sure you have formatted the order form as well.

Friday

Read page 403 w Practice: Widget part 6 of 12, pages 403-405

 

Week of February 25th-29th

 

Monday

Read pages 405 w Practice: Products.html, page 406

Tuesday

Exercise 1, page 413

Wednesday

Finish Exercise 1 and Take notes for test

Thursday

Exercise 2, page 414.

Friday

Microsoft Access Data Base Test (over chapter 11)

 

Week of March 3rd-7th

 

Monday

Pages 429-433: Widget Parts 7 & 8

Tuesday

Pages 434-440: Widget Parts 9 – 11

Wednesday

Pages 440-444: Gadget Depot Parts 1 & 2

Thursday

Pages 445-451: June Sale

Friday

Pages 451-453 June Sale Labels

 

Week of March 10th-14th

 

Monday

Pages 454-457: Gadget Depot Part 3 & Widget Part 12

Tuesday

Chapter 12, Exercises 1 & 2: Page 463 (Due by Friday)

Wednesday

Take Notes for Test and Practice Typing!!!!!!

Thursday

Chapter 12 TEST w Case Question Only

Friday

CATCH UP DAY and TYPING TEST – End of 3rd Quarter

 

March 15th – March 24th: No School (SPRING BREAK)

 

Week of March 24th-28th:

 

Monday

No School

Tuesday

Pages 469-475: Gadget Depot parts 4 and 5 on Reports

Wednesday

Pages 476-479: Gadget Depot parts 6 and 7 on Modifying and Distributing Reports

Thursday

Pages 480-481: Gadget Depot part 8 on Calculation Fields w Work on Report Formatting and turning into a PDF file.

Friday

Pages 482-487: Practice: Products and Gadget Depot part 9 on Importing an Excel Worksheet

 

Week of March 31st – April 4th:

 

Monday

Read Page 488 on Linking Access Data to a Document

Type out Chapter Summary and Vocabulary from Pages 488-489

Go Over Access Commands and Buttons on Page 490

Tuesday

Answer Page 491 Review Questions in Complete Sentences (include the original question first).  Type everything out in a Word document and e-mail it to Mrs. Deiss

Wednesday

Page 492, Chapter 13: Exercise 1 – Museum Exhibits

Thursday

Page 492, Chapter 13: Exercise 2 – Library

Friday

Makeup Day (Finish the week’s work)

 

Week of April 7th – 11th:

 

Monday

Take Notes for Chapter 13 Test

Tuesday

Chapter 13 TEST on Analyzing Data in a Database

Wednesday

Publisher: Creating a Business Logo and Making a JPG Image

Thursday

Publisher: Creating a Business Card

Friday

Publisher: Creating a Business Brochure

 

Week of April 14th – 18th:

 

Monday

Publisher: Creating a Business Brochure - Continued

Tuesday

Finish Brochure and/or begin work on Invitation (see below)

Wednesday

Publisher: Creating a Business Open House Invitation

Thursday

Publisher: Creating a Business Flyer

Friday

HALF DAY (Teacher In-Service) w Finish Business Flyer

 

Week of April 21st – 25th:

 

Monday

No School (snow day)

Tuesday

Publisher: Creating a Business Letterhead

Wednesday

Publisher: Creating an Event Program

Thursday

Finish Event Program

Friday

Publisher: Creating a Resume

 

Week of April 28th – May 2nd:

 

Monday

Finish Resume

Tuesday

Publisher: Creating a Fun Calendar

Wednesday

Work On Publisher Calendar

Thursday

Finish Publisher Calendar

Friday

Microsoft Picture Manager: Basics of Image Manipulation