6.+Spreadsheets



//**Focus:**// Spreadsheets can be used to organize information, perform complex mathematical functions and present data in graph form.

//**Time:**// Approx. Cycle To Cycle (- )

//**Content To Be Learned:**//
 * 1) How can Spreadsheets be used in daily work life?
 * 2) How do you set up and edit spreadsheets?
 * 3) How do use worksheets?
 * 4) How do you apply simple & complicated formulas?


 * //Skills To Be Learned/Reviewed://**
 * Using SS terminology (cell, row, column, formula bar, function)
 * Using Short cuts (date & time)
 * Adjusting rows/columns sizes
 * Copying/moving info
 * Clearing contents of a cell
 * Using Edit > Fill
 * Formatting cells
 * Using Functions (Auto sum, Max, Min, Average, Count)
 * Using Simple & complex formulas
 * Using the chart wizard
 * Adjusting Page Setup (Portrait & Landscape)/ Page Margins
 * Inserting/Deleting worksheets
 * Formatting Worksheets (rename, tab colour, etc.)
 * Relative vs. Absolute values

1) Look through the [|Teach ICT websites' Excel theory section]and answer the following questions:
 * Homework From The Text: [[file:Excel Homework 1 - New Text SS Questions.doc]]**
 * Class Notes:**

2) This is helps you review very basic formulas:

1) As an introduction review the work done in Middle School. To start use this to create a budget outline for a charity fundraiser. How will you order/group the information presented on the sheet? What additional information do you need to include? How will you format it? Can you include a chart or graph? Good luck! 2) Do exercises 1-12 (except #5) found in the studentserver (due to copyright they cannot be posted here). These should be held in one excel file but placed on different worksheets. Call the worksheet the name that the instructions ask you to save it as. Save the whole file as //**9 Name Excel 1**//. For #11 I have posted the intro work we did in grade 8 to help you remember some of the concepts 3) Open the Word File Advanced Excel Functions Tutorial.doc in the studentserver and then open . Save **//9 Name Excel2.xls//** into your folder and rename with your name on it. Work through the tutorials putting your answers on the appropriate worksheets.
 * Order of Operations:**