Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Basic Instructional Technology for Educational Settings PowerPoint Presentation
Download Presentation
Basic Instructional Technology for Educational Settings

Basic Instructional Technology for Educational Settings

115 Vues Download Presentation
Télécharger la présentation

Basic Instructional Technology for Educational Settings

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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.