Building Your Hybrid Course Worksheet

Name of Instructor ______Kim L Mapes______

Online Module/Learning Unit Title_MicrosoftExcel Chapter 4__ Course__IT200 Intermediate PC Office Applications______

Note: You will need to complete 2 modules/learning units for the Online Learning Committee review.

Use this table to make notes for the content of one module/unit/week of your hybrid course.

Excel Chapter Four
Formula, Functions, Data Tables and Amortization Schedules
  • Control the color and thickness of outlines and borders
  • Assign a name to a cell and refer to the cell in a formula using the assigned name
  • Determine the monthly payment of a loan using the financial function PMT
  • Use the financial functions PV (present value) and FV (future value)
  • Create a data table to analyze data in a worksheet
  • Add a pointer to a data table
  • Create an amortization schedule
  • Analyze worksheet data by changing values
  • Use names and print sections of a worksheet
  • Set print options
  • Protect and unprotect cells in a worksheet
  • Use the formula checking features of Excel
  • Hide and unhide cell
gridlines, rows, columns, sheets, and workbooks /
  • 1.Control the color and thickness of outlines and borders
/ Face to Face
  • 2.Assign a name to a cell and refer to the cell in a formula using the assigned name
/ Face to Face
  • 3.Determine the monthly payment of a loan using the financial function PMT
/ Face to Face
  • 4. Use the financial functions PV (present value) and FV (future value)
/ Face to Face
  • 5. Create a data table to analyze data in a worksheet
/ Face to Face
  • 6. Add a pointer to a data table
/ Face to Face
  • 7. Create an amortization schedule
/ Face to Face
  • 8. Analyze worksheet data by changing values
/ Face to Face
  • 9. Use names and print sections of a worksheet
/ Face to Face
  • 10. Set print options
/ Face to Face
  • 11. Protect and unprotect cells in a worksheet
/ Face to Face
  • 12. Use the formula checking features of Excel
/ Face to Face
  • 13. Hide and unhide cell
gridlines, rows, columns, sheets, and workbooks / Face to Face
Course Content/Interaction What types of content will you use to present your story? (Voice over PPT, video, etc.) /
  1. 1. Reading Chapter
/ Online
  1. PowerPoint Slides
/ Online
  1. Lecture
/ F2F
Learning Activities – How will the students practice what they are learning? (discussion, paper, research) / 1.Chapter Tutorial / F2F
2.End of chapter exercises and Lab / Online
3.Mid-term Exam / F2F
Technology- What tools/ media will be used for the delivery of your course content? / 1.Blackboard / Online
2.Discussion Forum / Online
Assessment – How will you know the students learned the assigned items?
(quiz, discussion board, presentation) / 1.Grading of tutorial, exams and exercises / Online
2. Mid Term Exam / F2F

Adapted from: Creating a Hybrid College Course: Instructional Design Notes and Recommendations for Beginners, G.Hensely