spread sheet notes [Good Stuff -- free & valuable resources]   Make Excel Part of Your Daily Class Work

Make Excel part of your daily class work to:
  • create accurate class records (saving time and material),
  • permit quick review of prior work,
  • model the creative process for student to emulate,
  • easily work and save DIGITAL MANIPULATIVE work,
  • include labs and graphics (Alt+PrintScreen) and hot computational cells in every class.

First Tasks - Complete Introductions
  1. Introduce yourself to those around you.
  2. Copy, from the presenter's thumb drive copy or the web, all material in

    and begin work on the material below.
  3.       Should you need it, below is a list of common computer commands necessary for this work.

14. Use the Stylus

      At some point each participant who has not used a stylus and pad should experiment with the Bamboo at the presenter's laptop. Please find time to do this. You will be creating a static graphic image, in this case a gif file linked here.

Next -- Basic Copy & Paste

      The work you are creating will look something like this. YOU MAY NEED TO CHANGE THE FONT AND MERGE FEATURES OF THE CELLS OF THE SPREAD SHEET TO DO THIS. Feel free to ask for help.

      It contains 2 images (one of which is a link) and 2 two web page names (one of which is a link).

  1. Open a spreadsheet with Excel and name it nov1409.xls.
  2. Open the saved thumb-drive version of page:


    or use the internet page:

          Each is a title, which is not an active link.

  3. Copy and paste one of the above web PAGE NAMES to your spreadsheet.
  4. Copy and paste a web PAGE LINK listed below to your spreadsheet.

  5.       www.mathnstuff.com/papers/amatyc9/amatyc9.htm

          Each is a title, which is also an active link.

  6. Copy and paste the graphic below to the left of your spreadsheet.
    spread sheet notes

          This tile is a static graphic, with the useful potential of being moved.

  7. Copy and paste the linked graphic below to the right of your spreadsheet.
    spread sheet notes

          This tile is an active link, anchored by a graphic. Notice the black box around the tile.

  8. (Optional) Perhaps copy and paste the above list of common computer commands in your spreadsheet.
  9. (Optional) Begin recording your notes, comments, questions on your spreadsheet.

11. Make A Visual Record of Work

      Before you make a visual record of the work you'll need to create a work that's worth saving.   Please:

  1. Open spreadsheet sine.xls or the web version of sine.xls linked here.
  2. Go to worksheet or page named "sine sine" and create an example similar to the one below. Think of it a graphing problem from a trig class or some work generated in class to be placed in notes.

  3. While your example is on your computer screen, hold down the [Alt] key and press the [Print Screen] key. It "selects" and creates an image. It places the image in the "clipboard" of your computer.
          This [Alt]+[Print Screen] feature varies from one computer operating system to another. It is a POWERFUL feature.
  4. Go to your nov1409.xls spreadsheet.
  5. Paste the image onto your spreadsheet, by pressing [Ctrl] + [V]. paste in notes
  6. Save your spreadsheet.
  7. Close the sine.xls spreadsheet. You don't need it again.
  8. Time permitting, crop the picture. Use View, Toolbars, Picture, Crop and work from the corner(s) of the picture.
          Take your time doing this. One need not rush.
      paste in notes

  9. If desired, and time permitting, compress a cropped picture. paste in notes
  10. (Optional, but strongly suggested) Make it a habit to save your spreadsheet as you take notes or work.

12. & 13. Make Another Visual Record and Also an Active Record of Work
paste in notes

      This time a spread sheet will be used as a manipulative work area and you will move and also copy and paste digitally but manipulatively. This done you will make a permanent visual record of the work and also keep a copy of the digital manipulatives on your spreadsheet for possible later work.

      Above and at the left, negative digital manipulative Term Tiles have been paired with positive Term Tiles to make "zero pairs" in order to simplify the expression.

      Just to the left, tiles have been selected so they may be copied and pasted to represent 3(x+3).


  1. Open spreadsheet a1208.xls or the web version linked here.
  2. Go to page "simplify," scroll down to the work, move the tiles to make "zero pairs" to simplify the expressing, and type the simplified expression.
          With this act, the spreadsheet becomes not just a storage area for links and pictures, not just a work area for computing, not just a space to record notes, but, it becomes a work space for digital manipulatives to be used and saved to be used again or never again. It's like having a art table of tools without the mess of having to clean up after each use. Things can remain untouched in the spreadsheet for use on another day.
  3. Make a permanent graphic record of your work using the process described above.
  4. Go to page "mult," scroll down to the work, select, copy, and paste tiles to represent triple three more than a number, 3(x+3).
  5. This pasted and completed, select the entire area of cells, tiles, and text and copy and paste it into your spreadsheet. You now have a collection of tiles you may use at a later date.
  6. (Optional) If desired, copy and paste tiles from the "storage" page of the to your spreadsheet for future use. Please also the source as stated on the "toc" page.
  7. Remember to save your spreadsheet.
  8. Close the a1208.xls spreadsheet. You don't need it again.
  9. (Optional with internet connection) If desired and time permitting, visit the Digital Manipulative Library to see other material.
  10. (Optional) If desired and time permitting and you wish more practice in moving, tiles open jig.xls.

15. Let's Talk and Share. Goal Setting and Who, What, When, Where, Why, How                    
  • brick-and-mortar prof
  • inet prof
  • brick-and-mortar student
  • inet student
  • administrator
  • other
  • private notes
  • class notes
  • public, nonclass notes
  • publication text / illustrations
  • pre class / semester
  • in class
  • post class / semester
  • private notes
  • web notes
  • other posted notes
  • external hard drive
  • thumb drive
  • web site
  • gypsy class room
  • lab
  • private use
  • public use
  • review material for class use
  • review material for test / quiz writting
  • notes for text / paid writing project
  • desk top
  • lap top
  • other

16. Show & Tell. Planning & Notetaking Stages Presented as ReRuns
Make Excel part of your daily class work to:
  • create accurate class records
    -- This time it is of the set up of the semester from a prof's perspective.
  • permit quick review of prior work
    -- This time using the PREVIEW feature of WINDOWS EXPLORER to review graphics & notes.
  • model the creative process for student to emulate
    -- Even digital natives can learn something from a digital immigrant.
  • easily work and save DIGITAL MANIPULATIVE work
    -- Actually pick up where you left off last class!
  • include labs and graphics (Alt+PrintScreen) and hot computational cells in every class
    -- Choose which format(s) work(s) best at a certain time.
Set Up ReRuns Precalc ReRuns

17. Debrief
These tasks have been completed:
  • Copy and paste into Excel from web page, etc.
  • Copy and paste into Excel using screen capture.
  • Edit, crop, save using Excel picture toolbar.
  • Use the stylus.
  • Collaborate on the tasks and goals at hand.
  • Use Excel in record notes.
  • Use an image to record notes.
  • Examine a rerun technique using Windows Explorer and Preview.
Reflect a moment and record your reflections on your spreadsheet before group debriefing.

[master list of all MSH! dictionary words] [tutorials & resource material arranged by topic [Good Stuff -- free & valuable resources] [MC,i. Home, site home page] spread sheet notes spread sheet notes [this semester's schedule w/links]
© 2009,
A. Azzolino