Friday, March 9th
Congratulations, you made it! Now to get your project and report submitted.
You will be placing all of your files into one root folder. Name that folder using this naming convention:
LastName_ ITGS_IA with no spaces so my folder would be called Dodge_ITGS_IA
Inside this folder you should have the following items:
cover_page.htm - there are some modifications that need to be made to this file. Please make the following changes before submitting:
Candidate name: complete
School Number: leave blank
Session Number: M18
Everything else should be filled in.
Remember Links to: Product - this should link to your index page of your web site in the Product folder or your video or product. You should also have a Link to Live Web Site: which will do exactly that. If you have a video it should link to the Vimeo or YouTube video.
Documentation- this folder should have all of your criterion PDF files. Here is the list:
All files should be saved as PDFs.
Product - this folder has your project files
Screencast.MOV or .MP4STOP! At this point you should test to be sure your cover page correctly links to the correct PDF documents in your Documentation folder. Also be sure that it links to your index.htm page in your Product folder if you made a web site, if not then it should link to your video, excel file....
Move to another computer and make a copy of your LastName_ ITGS_IA folder on the desktop. Open the cover_page and be sure all of the links on the coverpage work. Scan the pdf files to be sure everything is there. Test the link to your product and be sure it works and your product works. Open your screencast and be sure it plays.
Now copy your folder to the ITGS submissions folder - go to Computer and then under network drives you will see the ITGS submissions folder. Once you have copied the folder check whith Mr. Dodge to confirm the file is on the server. Once he has confirmed the file you have successfully submitted your ITGS IA - Congratulations! Enjoy the weekend.
Homework
Have a great weekend!
Next Week - Intro to Databases!
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.