Share ideas that matter on the social web and experience
the benefits of curating the world's best content.
I don't have a Facebook, a Twitter or a LinkedIn account
|
Scooped by pru onto Library collections for learning |
Scoop.it!
The problem is how excel handles the typing of cells. Excel essentially reads the first 10 cell values, and then guesses at the data type. When you see this happening, best practice is generally to select the entire column (just the cell won’t work usually) and change the cell format type to text. However, sometimes that doesn’t work. And when it doesn’t, you have to use the Text to Column function. Here’s the screenshots.
Are you sure you want to delete this scoop?
 Your new post is loading...
Scoop.it!
Click on the poster to download the pdf version for printing.
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Benjamin Carmel's curator insight,
May 6, 1:31 PM
Right, this is a topic I've been thinking and working with a lot lately. The authors discuss this as a tool for secondary school (mostly), but the principles apply equally to adult learners and collaboration, learning communities and communities of practice.
The reference list is also a valuable resource. More to add to my reading list... 
PaolaRicaurte's curator insight,
May 12, 8:49 AM
Robin Good's insight:
Paul Mihailidis, has an interesting essay on "Exploring Curation as a Core Competency in Digital an Media Literacy Education" in which he offers "a prospective attempt to build curation into the media literacy conversation..." by analyzing the analyzing effective curation practices, and six highly relevant teaching points for using a news curation tool like Storify in the classroom.
His essay "seeks to encourage instructors, particularly on secondary and tertiary education levels, to bridge the gap between informal learning outside of the classroom with formal learning to create a more dynamic place for students to advance critical inquiry, dialogue, and engagement through new forms of content creation, curation, and dissemination."
He writes: "Through student-driven, creation-driven, collective and integrated teaching approaches to curation, the framework aims to build towards savvy media consumption and production, critical evaluation and analysis, and participation in local, national and global dialog.
The framework also addresses the ability to see diversity and civic voice as core competencies in the curation process.
As students learn to build cohesive stories and ideas from a wide variety of sources, they can learn about the diverse types of content that inform a story, and the avenues they have-through social media tools and platforms-to be part of the discussion."
Curation can be an extremely effective approach to develop critical thinking skills and practices, as it forces students to evaluate, vet, verify and decide what really matters.
"When students develop a credible list of professional and personal sources around an issue and/or event, they must acknowledge how much subjective weight they place on a tweet, a blog, or a Facebook post and in relative comparison to an advocacy group, cable television operation, or news service. Arguing for the credibility of a myriad of voices online forces students to build valuable justifications for what they choose to believe, and why."
Informative. Examples-rich. Educationally useful. 8/10
Full essay: http://www-jime.open.ac.uk/jime/article/viewArticle/2013-02/html
Nancy White's curator insight,
May 13, 9:12 AM
I am very excited to find this work to share with my teachers. I continue to get pushback as I try to encourage them to allow time for students to curate. The fact of the matter is that true curation takes time, but the skills gained by students cannot be ignored, and research and critical analysis are found throughout the Common Core Standards. Curation is also a pathway to personalized learning as students pursue their own areas of interest through the art of curation. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
The Resource for Education Technology Leaders focusing on K-12 educators.
Good basic overview of Scoop.it and other curatioon tools; also reinforces the point that curation tools are also good search tools. Via callooh, Hans De Four, Theo Kuechel Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Librarians at the State Library of Victoria answer complex reference questions for patrons everyday, whether it be onsite, via email or on the phone. These Libguides are aimed as a one-stop shop for subjects like bushfires in Victoria, court cases in Australia, early Australian census records and more. Each libguide gives background information on the topic and the Library’s holdings, key resources and related web links.
pru's insight:
Recently published guides include: Children’s literatureAboriginal people and family historyWater in VictoriaMelbourne post-war photographyHistory of the State Library of VictoriaDelete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Ninety-nine percent of us live on the wrong side of a one-way mirror
pru's insight:
As libraries increasingly purchase online here is another side of personalisation.
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
The goal of the DIAGRAM Center at Benetech is to impact how image and graphic content for accessible instructional materials (AIM) is produced and accessed throughout the country. The DIAGRAM Cente... Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
pru's insight:
Check out the range of book-related tools and services available for publishers, libraries and vendors. How do these tools add value to a library's collection building activities? Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Create primary and secondary teaching programs directly from the Kindergarten to Year 10 NSW syllabuses for the Australian curriculum.
pru's insight:
Use your DEC NSW or Scootle login to access program builder. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
With the help of carefully crafted rubrics like the ones on this site, teachers can now follow a set of guidelines to select the apps that can work for them in their teaching. Parents too can use these checklists to sift through the piles and handpick the ones to give their kids. Via Karen Bonanno 
Karen Bonanno's curator insight,
March 5, 2:48 AM
Great checklists, guidelines and evaluation questions. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
The Library of Congress is archiving every public tweet ever posted, and it's now becoming clearer what research opportunities that data might present. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
The La Crosse Public Library in La Crosse, WI has just launched an heirloom seed library that will allow people to check out garden seeds to plant, grow, harvest and return to the library. "We are going to catalog them by genus and species eventually and have a catalog in a public area.
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Note: These are sample widgets. If you were using this in a real library, then each book would link to the book record in the catalog when clicked.
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
The problem is how excel handles the typing of cells. Excel essentially reads the first 10 cell values, and then guesses at the data type. When you see this happening, best practice is generally to select the entire column (just the cell won’t work usually) and change the cell format type to text. However, sometimes that doesn’t work. And when it doesn’t, you have to use the Text to Column function. Here’s the screenshots.
pru's insight:
Had this issue when moving ISBN data around via spreadsheets? Importing bulk e-book records from vendors for loading? Dealing with large book order files? Thanks for the screenshots. |
Scoop.it!
Just good 'ole having fun in a school library! (Making friends...making progress - Puzzles offer so much in school libraries. A necessity!
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Wikimedia Australia is partnering with The State Library of NSW
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
All OER have a life cycle: creation, publishing, repeated revision and reuse, senescence, death. Much effort and many resources have been expended on the creation and publishing of OER. The actual value of such resources, however, depends largely on the extent to which repeated revision and reuse can be sustained before the inevitable onset of senescence and death. The issue of sustainability is largely one of resources, and is a topic of considerable interest in the field of open education. Via Kim Flintoff Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Web App Reviews is a site dedicated to reviewing the best Chrome Web Apps and Extensions for Education. As schools are moving more and more towards cloud-based services, it is important to find high quality resources for the classroom. Via Karen Bonanno
Karen Bonanno's curator insight,
March 21, 4:44 PM
Each review includes a written blog post and a short video covering what the web app or extension does as well as practical ideas for use in schools. 
Nikki Bourlet's curator insight,
March 21, 10:27 PM
I particularly liked the information on GeoGebra, Tab Scissors and the video on other extensions available with Google Chrome. All-in-all a very useful site to curate and share with others. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Ninety-nine percent of us live on the wrong side of a one-way mirror
pru's insight:
As libraries increasingly purchase online, and personalisation becomes a goal,, here is another issue to bear in mind.
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
It used to be that once you’d finished slashing your way through the mobile game Infinity Blade for the umpteenth time, you were left with the choice of replaying the game yet again or letting it collect virtual dust on your iDevice’s home screen.
pru's insight:
Only at patent idea stage, and still very much on the terms of the publisher / ebooks store model, but possibly addressing one of the issues surrounding business models for e-resources.
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Throughout 2011 and 2012, the Board of Studies NSW developed new K–10 syllabuses for English, Mathematics, Science (incorporating Science and Technology K–6) and History that incorporate agreed Australian Curriculum content.
pru's insight:
Teacher librarians check out the Suggested texts for the English K-10 curriculum from NSW Board of Studies (PDF 1.8 MB, 322 pages). Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Crowdsourcing, members of the public adding information to records, is being used as a method for Libraries to enhance the details of their collections.
pru's insight:
This presentation from ALIA Online by Paul Hagon provides some interesting ideas on the use of user analytics in determining where to invest energy in library collection building and management, and in services. Recognise that there is a difference between priorities for users that can only access a collection online versus those who visit the collection in person. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
It is time to question the book. Time to question reading. What is a book? What is reading?
pru's insight:
Jamie McKenzie provides a much needed critique of ebooks which goes beyond format, and into the content, experience, usability and purpose of reading. "The software used to convert print to digital usually damages the original page design painstakingly achieved for the print book... In order to work on a wide range of devices ranging from smart phones to iPads and laptops, format is sacrificed to generic scrolling words." iBooks Author is given a positive wrap. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Professional learning for: Teacher Librarians, Librarians and Library Personnel. Program:
* Managing e-books for school libraries - Michael Jongen, Library Services Coordinator, SCIS, Education Services Australia
* Digital resources with Overdrive - Sue Warren, Educational Consultant, Softlink Australia * Wheelers ePlatform - Darren Brain - Business Development Manager (Schools), Wheelers * eBooks, ePubs, eTexts and open education resources - a perfect storm is brewing! - Dr Jill Abell, Director of Information Services & ICT at The Hutchins School, Hobart Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
A new market for second-hand digital downloads could let us hold virtual yard sales of our ever-growing piles of intangible possessions ("Amazon to open market in second-hand MP3s and e-books - New Scientist - New Scientist" good read
Delete the scoop?
Are you sure you want to delete this scoop?
Yes
Scoop.it!
Ford Street - Publishing Young Adult fiction in Australia. Extensive Teacher's notes are available for most Ford Street titles.
pru's insight:
Local publisher promotional publications provide alerts to new and upcoming titles and often useful teacher's notes that can help in promotion of resources. Ford Street also provide a service that helps organise literary events for schools meaning students and teachers can engage directly with authors. Delete the scoop?
Are you sure you want to delete this scoop?
Yes
|
Had this issue when moving ISBN data around via spreadsheets? Importing bulk e-book records from vendors for loading? Dealing with large book order files?
Thanks for the screenshots.