Difference between revisions of "Relational Database Programming Study Guide"

From RobotX
Jump to navigation Jump to search
Line 17: Line 17:
 
===Homework Assignment===
 
===Homework Assignment===
 
*Build an Excel Spreadsheet with a graph
 
*Build an Excel Spreadsheet with a graph
 +
**https://www.wikihow.com/Create-a-Graph-in-Excel
 +
**https://support.microsoft.com/en-us/office/present-your-data-in-a-scatter-chart-or-a-line-chart-4570a80f-599a-4d6b-a155-104a9018b86e
 +
**https://www.excel-easy.com/data-analysis/charts.html
 +
**https://www.youtube.com/watch?v=Vs6-_hDX0Eg
 
*Get an Intellipedia Wiki Account, set up a User Page, and A Sandbox page
 
*Get an Intellipedia Wiki Account, set up a User Page, and A Sandbox page
  

Revision as of 13:07, 14 September 2020

Study Guide

Session 1

Pre-Session Reading

Pre-Session Videos

Training Topics

  • Intro to EXCEL: Cell Mechanics, Formulas, Importing and Exporting CSV Files
  • Intro to Access Forms, Queries, Tables, Reports, Switchboard, VB IDE
  • Intro to a Wiki and it's Markup Language

Homework Assignment

Session 2

Pre-Session Reading

Pre-Session Videos

Training Topics

  • Intro to Access Table creation with Parent Child Relationships
  • Intro SQL Querries

Homework Assignment

Build a 3 Table Database with 2 child relationships

Retrieved from "http://OCRobotx.org/mediawiki/index.php?title=Relational_Database_Programming_Study_Guide&oldid=13379"