CPD • Gifted and Talented • INSET Training • Events • Courses
Be excited by Excel
For:
Primary KS2
This course aims to enable staff to use Spreadsheets with their students. I plan to share both techniques and interesting lesson ideas. • Record data from investigations • Present data attractively, conditional formatting • Demystify formulas • Answer “What if?” questions and explore goal seeking
Where and When Tuesday 19 May 2011 1:00pm - 3:30pm South eLearning Centre Summerwood Lane Clifton Nottingham NG11 9DR Tel. 0115 9152971 Book a place at www.nelc.net
»
More
Developing ideas and making
EXCEL IS A POWERFUL TOOL! BUT staff knowle
2007 with an experienced user to guide you through the com
COURSE CONTENT: • Entering data from an investigation. • Using data entry techniques like drop down lists, cell formatting and conditional formatting. • Demystifying formulas. • Asking “What if?” and introducing goal seeking.
COND
• colou condi • usefu less th
GOAL RESOURCES
• how to guides • using popular puzzle games to explore mathematical patterns • pool ideas from the group
• Wha • Put i and E auto can t
g things happen.
edge and experience is often limited. Come and explore Excel mplexities. BECOME MORE CONFIDENT!!
DITIONAL FORMATTING
ur code cells according to certain itions ul to highlight data that is more than, han or equal to a certain value.
L SEEKING
at if? in the value of what you want Excel will alter variables omatically to get as close as it to your desired outcome.
DROP DOWN LISTS
• Great for quick data entry. • No need to type in what you want to enter, just choose from a list.
CPD • Gifted and Talented • INSET Training • Events • Courses •
Be excited by Excel This course is ideal for teachers who want: • to encourage handling and analysing numeric data • to improve their own development in this area Additional Information: • bring a memory stick with you to take away useful resources • ample parking
Course run by:
Janet Simner Maths, Textiles, Science
eLearning Consultant tel. 0115 9152971 e. janet.simner@nottinghamcity.gov.uk
NeLC contacts: Martin MacGillivray Centre Manger tel. 0115 915 9511 e. martin.macgillivray@nottinghamcity.gov.uk Marie-Line Antoine Media, Languages, Video, Photography tel. 0115 915 9511 e. mantoine@nottinghamcity.gov.uk Jan Gray Primary, Video, Animation tel. 0115 915 2971 e. jan.gray@nottinghamcity.gov.uk David Ellis Music, Media, Animation, 3D modelling tel. 0115 915 9511 e. david.ellis@nottinghamcity.gov.uk Jamie Tinney D&T, Animation, Art & Design tel. 0115 915 2971 e. jamie.tinney@nottinghamcity.gov.uk
To book a place go to: www.nelc.net
The cost of this course is: £75 per person Discounts apply: Deduct 50% for maintained Nottingham City Schools Deduct 15% for other Nottingham City Schools. Or use credits from your Course Bundle.