Spreadsheets(NeoOffice)

=__**Lessons 6-7: Working with data:**__**Spreadsheets** Geography **& Data Logging**=

**L****esson 1:**
Editing Cell Contents, Formatting Cells, Formatting Numeric Data, Selecting Cells.
 * Learning Intentions:** Revise basic spreadsheet (neooffice) functions, sum, subtractions, multiplication and divisions and average and bar and pie chart


 * 1) **Practice the four main operations using the spreadsheet:**
 * ======Create two columns and use them to calculate the 7 times tables mult div(backwards and forwards).======
 * ======Record 5 different ways of using addition to make 100.======
 * ======Go to the ABC Weather Stationand work out the range in Temperature (high and low) for today.======

__**Plenary**__ How could we use the data from the Weather station graph (of outside temperature) to work out the average temperature for the day.(using only the data for the 4 hour intervals provided)


 * Some Examples that you may find helpful:**

\

__**Homework**__
 * ======Collect Geographical data on both temperature and wind speed for each day this week. **This should be recorded in your planner each day!**======
 * ======Use [] . You can choose any location in the world.======

**Lesson 2:**
__**Learning Intentions:**__ Formatting spreadsheets, finding the average(mean) and generating, generating line graphs, previewing and setting print options

Converting between **Degrees Celsius and Fahrenheit** Wind Speed MPH to KM **Temperature**

__**Question:**__ How could we write a function that would work to find the average?

> > **//*Don't forget to use : GO> smb://dc to open student docs.//** **Plenary:** We will share some of the graphs. Please let your teacher know if you would like to share yours, also be ready to discuss the impact that the rain and temperature may be having on the country.
 * Log the [|data] collected from last week and work out the average wind speed and temperature.
 * generate a graph of your data...this should be a line graph.
 * Format the spreadsheet appropriately.
 * Set the print options and preview your work.
 * Place a copy of your work in your ICT folder in Personal as well as one in Student Shared Docs>ICT.



media type="custom" key="4497392"