Excel In- Service Course

Inservice Course Agenda

  • Create a Spreadsheet
  • Use merge cells
  • Use Autosum
  • Create a chart
  • Create a gradebook
  • Create a budget
  • Create unique formula
  • Tutorials and handout references for future use
Microsoft Excel Modules from Internet4classrooms
Excel resources for teachers and students
Using Funtions- sum, autosum Tech on the Net Excel Resources references to formulas
  If command explained simply by Tech on the Net
Excel for Teachers part 1- media workshop Create a Pivot Table by Tech on the Net
Creating a Gradebook Change the font color based on the value of the cell- conditional formating by Tech on the Net
Sample Tech Team Data Sorting data alphabetically
Excel for Teachers part 2 media workshop  
Excel
  Excel Tutorial from the University of South Dakota
Excel Toolbars Excel Basics 97 from British Columbia
Pivot Table Tutorial Excel 2000 Tutorial from Florida Gulf Coast University
Using Charts and Diagrams in your classroom Sample Coordinator
Spreadsheet Formulas Grading- How to average and weigh grades
Internet Based Guide to Excel 97 Using Excel- tutorials, toolbars, templates from internet4classrooms
Civil War Excel Spreadsheet Examples Gradebook basics- creating a lookup table
Excel Templates from Microsoft include calendars, budgets, loans, graph paper Gradebook based on averages from Microsoft
Graph paper template Gradebook Template based on percentages
Multiplication table template Gradebook Template based on points
Timeline Template Example of Grade book based on points
Class Schedule Bingo Template
Teacher's Class plan To do list
Family Tree Excel Mad libs
Retirement Budget Logs- Reading log, Observation log, daily log
College Costs Probability- dice rolls and coin flips
Fitness Chart for Women Back in Time with Timelines
Fitness Chart for Men Computer Inventory
Simple Flowchart