Be excited by Excel course

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.