| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Digital Literacy - Spreadsheets - Websites

Page history last edited by Teachesict 11 years, 9 months ago

BACK TO SPREADSHEETS HOMEPAGE

 

Browse the lists below to find resources to help you deliver this section of #digitalstudies

Resources are not added in any order; however, to make it easier to find something that you can use in the classroom, each column can be sorted by simply clicking on the top row.

 

Resource Type  Example lesson? Name or related to Cost / additional resources  ▾ Description from resource Description of how resource can be used  If this resource is originally yours please add your twitter ID here Added to wiki by: 
Website  Spreadsheets - Lesson starters    8 very useful lesson starters on spreadsheets including quizzes    @largerama  @teachesict 
Website Y Spreadsheets - Introducing (Planning)   A collection of 5+ lessons from Simon showing how he introduces spreadsheets to his pupils.   @simonhaughton @teachesict
Website   Google Charts - How to make simple web based searchable charts  

A lot of data visualization requires the technical expertise of a programmer and skills that take time and resources to develop.

A rise in free tools, however, has made it easier to make interactive graphs in charts, whether you’re a designer, developer, Web producer or hobbyist. The Google Visualization API, for instance, gives you options without making the work too complicated.

I’ve created a tutorial below to help you make simple, Web-based Google charts. (You can click on any of the screenshots to go to a larger version.) In the first example, we’ll craft an interactive bar chart that compares the numbers of tornado-related deaths in the United States throughout the past four years. 

    @teachesict 
Website   Google Charts - 50 Cool things you can do with Google Charts API   Chartophiles and students, have you heard that Google has made it incredibly easy to generate your own slick-looking charts? It's true, and all it takes to make one is the ability to read and edit a URL. This has made it possible to get creative with charts and wow the audience for your next classroom presentation. Read on to see what's been done, and how you can easily do it yourself.      @teachesict 
Website Y Christmas Toy Shop Challenge  

Here are my planning notes for the first lesson in my new Y3 Christmas Toy Shop Challenge…

Ask the children if they have ever been to the supermarket with their mum or dad. Ask them if they can think of any ways in which the supermarket would use computers. Have any of them used the self service tills? Explain that supermarkets and other shops use computers to keep track of how much stock they have so they know what they need to order when they run though. They also use the computers to tell them which products are the most popular and which don’t sell very much.

Explain to the children that they are going to imagine they are running a toy shop and have to get ready for Christmas.

Show them the prepared Excel spreadsheet and demonstrate how it will work. Children will be given a set budget of £5000 and will have to choose which toys to stock from the list they are given, entering the information into the spreadsheet and making sure they don’t go over budget.

Show them how the spreadsheet will automatically calculate how much money they have spent and that the total spend will go red if they go below zero. Also show that they can adjust the quantities in order to spend as close to £5000 as possible.

In pairs the children need to open up the blank spreadsheet and then use the list of toys to pick 10 items for their shop. They need to input the name of the toy, the price and then adjust the quantity so that the amount they have spent gets as close to 0 as possible.

In following lessons they will receive orders for the toys in their shop and will see how much profit they can make.

  @chrisleach78
@teachesict
Website  Y Excel - Conditional Formatting  

Here's a nice activity idea I've just come up with to help consolidate children's understanding of basic formulae whilst at the same time teaching them how to use conditional formatting on cells.


 
@simonhaughton  @teachesict 
Website Y Chubby Grub - Restaurant Nutrition   Nutrition information from your favourite restaurants, all in one place Useful source of data that could be used in spreadsheet lessons.   @teachesict
Website Y Theme Park Spreadsheets   This year when I was delivering my 'theme park spreadsheets' project with Year 6, I found when I gave them more independence in completing the work a few children needed that bit extra challenge at the end when they had completed everything. I therefore produced a set of six mini challenge cards to help consolidate/teach them new spreadsheet skills: A great collection of posts from Simon showing how these lessons progress over a number of weeks   @simonhaughton
@teachesict
Website   2Graph - Graph / Analyse TV Ratings  

TV ratings are collected by an agency called BARB who give out special boxes to a selection of households in the UK which send back their resident’s viewing habits to them. These are then collated, up-scaled to reflect the actual population of the UK and published the following day on their site as ‘overnight’ ratings. Unfortunately, these are only available on the BARB website to paying subscribers – however a few kind Gallifrey Base members do share them in the Doctor Who forum and they are extremely interesting to look at.

Since I wanted the children to work with some of the data, I decided to select some ratings from a Saturday evening – a time when there are no soaps and the programs generally reflect a more family-oriented audience. I copied a portion of the 15-minute breakdowns for the two main UK TV channels (BBC1 and ITV1) for about a 3 hour period into a simple word processed table and then placed this onto the school network for children to access.

  @simonhaughton
@teachesict 
Website Y Six Nations Dream Team   Year 5 have been using Excel to create a spreadsheet for their 6 Nations Dream Team. They have each selected a team of players from all 6 countries and will be using the player ratings on the Guardian website to decide which team is the best.   @chrisleach78 @teachesict
Website (scheme of work) Y Spreadsheet Quizzes (minipops style)  

Remember Minipops?

Yes,it's spreadsheets! Bear with me though. Suitable for Y9 (or Y8 of you're feeling ambitious)- learners use advanced spreadsheet features to create a multiple choice quiz. They then feed back, peer assess and evaluate their work.

  @MrAColley @MrAColley
Website Y Spreadsheet - Love Calculator  

A couple of the year 8 girls were ‘playing’ on www.lovecalculator.com and as I was learning all the gossip from Year 8 I challenged them to work out the ‘code’ behind the Love Calculator. Working with them we started systematically by trying A loves A which gave a result of 0%. We then tried A loves B and got 0% again. We kept getting 0% until we tried A loves E which gave a result of 13%. One of the girls then suggested it would only work with the letters in the word loves which we tried and we discovered that…

Could use this idea on a spreadsheet using What if ... @chrisleach78 @teachesict

 

Comments (0)

You don't have permission to comment on this page.