Classrooms that Excel Sabine  |  Virtual School  |  Library  |  Search  |  Reference  |  Teachers  |  Viewlets

Excel Operations and Procedures

Contacts

Discussions

Resources

Lesson II builds upon Excel skills and procedures introduced in Lesson I.  Use Viewlets tutorials to introduce, guide, and practice examples and activities. 

Lesson II - Demonstrate  proficiency with procedures for formatting and organizing a worksheet. 

Terms Lesson II - Focus on Formatting

 

  1. Participants demonstrate Lesson I proficiency - procedures and terms

  2. Use Viewlets - Introduction and Review, Formatting

  3. Demonstrate proficiency with Excel "Terms" and associated applications.

  4. Review and practice - Viewlets coded O, R, LI

  5. Begin thinking about an original instructional activity that incorporates Excel.   (Review Resources for ideas).

  6. Post questions, comments, and share ideas via Discussions

  7. Browse Excel Resources

Workbook/worksheet Example

  • Student Test Assessment Report - IOWA  (will load slow because of size of file) Enter data in cells filled with green.  Values should be between 200 and 400.  Click on each cell that computes result to view formula.  Can you identify the absolute value?  The IF statement is used to suppress display of information if there is no data.  Manipulate and edit the formulas, remove the IF portions of the formula to see what may occur.  You CAN NOT destroy or harm the workbook or worksheets because it will not Save to the web.  You can Save As if you wish to save it to your computer. Note the Formatting and Comments.

Excel Instructional Activities and Ideas (A web page will be created listing Excel activities as participants submit and post ideas and completed lesson activities)

Excel Resources - MUST See