Spreadsheets
Spreadsheets are designed to organize and manipulate numerical data, a term that stems from an accountants ledger for keeping records (Roblyer & Doering, 2012). They have several unique benefits in the classroom as outlined in the text (Roblyer & Doering, 2012, p. 122):
Databases are “an electronic filing system, a collection of information organized in such a way that a computer program can quickly select desired pieces of data.” While most of us do not create databases, we all use and access database information. Most websites are fed information from databases, such as Amazon, ZIP code lookup, or hotel reservation systems. Teachers can help students access complex information and turn it into an effective learning experience.
Spreadsheets are designed to organize and manipulate numerical data, a term that stems from an accountants ledger for keeping records (Roblyer & Doering, 2012). They have several unique benefits in the classroom as outlined in the text (Roblyer & Doering, 2012, p. 122):
- Save time: allow teachers to complete and update essential calculations quickly (e.g. grades)
- Organize displays of information: store information in columns (e.g. schedules, attendance)
- Support asking “what if” questions: students can visualize the impact of changes in numbers (e.g. charts and graphs)
- Increase motivation to work with mathematics: can make working with numbers more fun and engaging for students
Databases are “an electronic filing system, a collection of information organized in such a way that a computer program can quickly select desired pieces of data.” While most of us do not create databases, we all use and access database information. Most websites are fed information from databases, such as Amazon, ZIP code lookup, or hotel reservation systems. Teachers can help students access complex information and turn it into an effective learning experience.
Databases
Quizlet
Quizlet provides tools that are designed for the digital age, not just replacing paper predecessors (flashcards, matching games, etc), but using the best of new mobile and audio technologies to create new kinds of learning tools and games. And beyond tools for practice and recall, that they have added tools that focus on longer term learning and mastery for every level learner.
|
The Biology Corner
The Biology Corner is a resource site for biology and science teachers and students. It contains a variety of lessons, quizzes, labs, web quests, and information on science topics for all levels, including introductory life science and advanced placement biology. You can find lessons related to biology topics in the links listed under “topics” on the sidebar as well as specific curriculum for biology classes taught in high school.
|
Spreadsheets
Google Docs
Google Docs brings your documents to life with smart editing and styling tools to help you easily format text and paragraphs. Choose from hundreds of fonts, add links, images, and drawings. All for free.
docs.google.com
|
Kidszone with NCES
Kidszone with NCES allow students to engage in several games, quizzes and skill building about math, probability, graphing. In addition Kidszone gives students an easy to create graphs charts and much more.
|
Additional Links
Using Spreadsheets in K-12 classrooms: an excellent resource with links to interactive data, student and teacher examples, and online lessons.
http://www.alicechristie.org/edtech/ss/
http://www.alicechristie.org/edtech/ss/
Spreadsheets and Database Lesson Plan
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
edf_309__spreadsheets_and_database_lesson_plan_.docx | |
File Size: | 16 kb |
File Type: | docx |
![](http://www.weebly.com/weebly/images/file_icons/rtf.png)
edf_309_spreedsheet_and_database.docx | |
File Size: | 107 kb |
File Type: | docx |