1 / 20

Basic Instructional Technology for Educational Settings

Basic Instructional Technology for Educational Settings. Database Session. Video for. frandall@unca.edu. In this video:. Database Oversimplification (filing cabinet) Examples (IRS, student records, Facebook, Google, ERIC) Any structured compilation of information can be called a database

didier
Download Presentation

Basic Instructional Technology for Educational Settings

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Basic Instructional Technology for Educational Settings

  2. Database Session Video for frandall@unca.edu

  3. In this video: • Database • Oversimplification (filing cabinet) • Examples (IRS, student records, Facebook, Google, ERIC) • Any structured compilation of information can be called a database • Relational Database Management System (RDBMS) • Flat verses Relational Database • Access (2007/2010) demo and dog-and-pony • Description of databaseassignment and run-through • Mention OpenOffice.org Base

  4. Minimums for the Database Assignment: • Create a database using Microsoft Access with provided data on SAT scores • Download (Right-click on link then selectSave Target As...) the Microsoft Word questions/answers document to the desktop. This document when completed will be posted to your website. • Answer the questions USING database tools (filters, sorting, and queries). NOT spreadsheets nor manually counting… • Post the completed questions/answers document to website • Post the database file (filename.accdb) to website • Modify EDUC 211 or EDU 216 Products Page to include database assignment link to the questions/answers document • Modify EDUC 211 or EDU 216 Products Page to include database assignment link to the database file filename.accdb

  5. Modify EDUC 211 or EDU 216 Products Page to include database assignment links

  6. Given data for database assignment 52 total records (50 states, DC, US average)

  7. Database assignment run through

  8. Oversimplification (filing cabinet) • The most common image is that of a filing cabinet. Create structure to capture data (filing system) (table) Capture data (data entry) Pull information out of the data (query) • Databases exist all around us: Campus student records, Wikipedia,Email, Google search, Facebook, …Farmville, Moodle (yes, even Farmville),Federal and State income tax files,and ERICare examples of databases. • Any structured compilation of data can be considered a database.

  9. Database From Wikipedia: A database is an organized collection of data for one or more purposes […]. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies). The term "database" refers both to the way its users view it, and to the logical and physical materialization of its data, content, in files, computer memory, and computer data storage. This definition is very general, and is independent of the technology used.

  10. (Geek note) Also from Wikipedia: The term database is correctly applied to the data and their supporting data structures, and not to the […] software system used to manage the database.

  11. Relational Database Management System (RDBMS) • Microsoft Access • Software system used to manage the database • Access is a database management system (DBMS) based on a relational model

  12. ID LAST FIRST EMPLOYER DATE 123 DOE JANE US SENATE 3/15/1932 286 MOUSE MICKEY DISNEY 11/1/1928 579 JAMES JESSIE SELF 8/1/1889 623 RANDALL FRAN UNCA 9/26/1996 Example of Database (Table) Field Names (Structure) Record Record Record Record Field  Field  Field  Field  Field 

  13. Flat verses Relational Database Flat-file database is self-contained database in a single table. Relational database is where a single database can be spread across several tables.

  14. Relational Database Example • Three tables • Blue line indicates relation by Student ID • Green line indicates relation by Description

  15. WHY NOT USE OTHER TOOLS? (or What is a “suite”?) • MS Word (tables): Application is text oriented. Table rows and columns are difficult to control and cross reference. • MS Excel (spreadsheet):Application is cell oriented.Can create tables, but poor record management and limited cross-reference capability. Excellent for calculations…

  16. WHY USE ACCESS? Microsoft • Application is record oriented. • Easy to create and maintain data structures. • Easy to capture data. • Easy to ask questions of the data. • Import and export capabilities(“plays well with others”including Word, Excel, & others). • Can link large volumes of data together. • Wide variety of report formats and input options.

  17. Oracle, SQL, etc… (the heavies) • Full featured. • Substantial learning curve. • Cost. • However, … Access plays well with these tools too.

  18. Focus - Three core components • Create structure (filing system) (table) • Capture data (data entry) • Ask questions of data (query) • Create input screens (forms) • Reports • Macros • Modules • Relationships

  19. Trademarks: • Access, Excel, and Word are trademarks of Microsoft (www.microsoft.com) • Oracle is a trademark of Oracle (www.oracle.com) • Sound effect resource: • Gary Kurtz (Producer), & George Lucas (Director). (1977). Star Wars Episode IV: A New Hope [Motion picture]. United States: 20th Century Fox.

More Related