Wednesday, March 28th
10:45-11:50
Criterion B Feedback - can redo for full credit - print up updated page and attach to feedback page. All resubmissions are due by next Wednesday.
Check Homework - Blown to Bit Chapter 2 Part 2 questions 1-8.
The shift between public and private information
Complete Database Queries 2007 part 2 - get this checked off today.
Begin Database Forms - making data entry easier and limiting access to data
Complete Importing DataBegin Producing Reports - making your data presentable
Andy Yen: Think your email's private? Think again
Complete any missing DB assignments.
Andy Yen: Think your email's private? Think again
How Google Protects Your Data - List several ways that Google protects your data.
Why is Google so serious about data protection?
If Google does a great job of protecting your data then how might a student still have their data breached?Submit your answers to school loop.
CBS Tour of Google Data Center
A look inside Google's Data Center
Exporting/Importing Database Data, CSV files
Normalization - part of the design process for creating a DB
SQL - the universal language of databases
DBMS, Data validation, Specialized databases - Google and BigTable, Database security (IC security?)
Homework
Create a new folder in your ITGS google drive folder called Exam Prep. Place the following document in that folder as well as any other documents related to the ITGS exams.
In the SUHSD teachers who were hired after 2015 need to complete 3 units of professional development every five years in order to keep their teaching credential current. The district database tracks all teachers and sends out notices to teachers who are approaching the renewal period for their credential and have not yet completed the necessary units of professional development.
Describe, step by step, how the IT system works. Before you write out your answer make a list of the IT terms you will use in your answer and list these at the top of the page. Submit your answer to school loop.
What
3.7 Databases
Databases lie at the heart of most IT systems whether in businesses, organizations or other institutions. Databases enable organizations to maintain accurate and comprehensive records. In order to appreciate the role that databases play, the ITGS student must have an understanding of how they work, which can only be gained from the design and creation of basic relational databases as well as by examining how databases are used in specified scenarios (for instance, schools, retail stores, online shopping, online reservations). The increasing use of databases raises a range of social impacts and ethical issues such as the rights of individuals with respect to the storage and potential sale of their personal data or the ease of data mining
and data matching. Students are expected to discuss these issues and, where appropriate, evaluate possible solutions.
Possible scenario
A vet requires information about pet owners and their pets. The ITGS student must be able to develop an original IT solution to meet the vet’s needs. This knowledge should be acquired through a practical activity where the student creates a (minimum) three-table relational database (first normal form only) that uses queries to interrogate the data, forms to enable the easy input and viewing of data, and reports to provide printed information as required.
IT concepts to address in this topic
Database organization
• Table
• Field, data types, key field/primary key, secondary key
• Record
• Flat-file database, relational database, normalization
• Database management system
• Specialized databases: for example, web databases, online encyclopedias
Functions
• Data validation: data types, range check, check digit, field size, input mask, drop-down list
• Queries: for example, searching, sorting, filtering, use of Boolean operators (AND, NOT, OR)
• Data entry form
• Report generation
• Macros
• Transfer of data between databases and other applications
Data storage and access
• Data integrity, reliability, redundancy
• Data matching, data mining
• Database security
Practical database techniques
• Table
• Field, data types, key field/primary key, secondary key
• Record
• Linking tables to create a relational database
• Data maintenance: changing, editing, deleting records
• Queries: for example, searching, sorting, filtering, use of Boolean operators (AND, NOT, OR)
• Data entry form
• Report generation
• Creating and editing simple macros
• Mail merge
Why
Databases lie at the heart of most IT systems whether in businesses, organizations or other institutions.