A TECHTORIAL

USING EXCEL TO CREATE STUDY GUIDES

Excel also can be used to create study guides. Students might, for example:

  • Type the word TOPIC into cell A1, the word CAUSE into cell B1, the word EFFECT into cell C1, and the words CURRENT ISSUE into cell D1.
  • Type an historical event into cell A2, type the cause of that event into cell B2, type an immediate result of that event into cell C2, and type an example of how that event affects the world today into cell D2.
Study guides can be created to accommodate information in a number of disciplines. In a literature class, for example, headings might include Character, Motivation, Action, and Outcome.

Students could use spreadsheet study guides to review for AP or other tests, or to organize and synthesize information for their own use.

Next: Using Excel for classroom management tasks.

 

 
Close window