CS 101/Additional Materials/Chapter 12

From Worcester State University Computer Science Department Wiki
Jump to: navigation, search

Section 12.1 Managing Information

Information Systems https://www.youtube.com/watch?v=Qujsd4vkqFI 03/30/2013-11/15/2015 This video is a informational explanation of why we need this information systems to store our data and accurately access it. With out these system it would be impossible to find all the data we create. In this video it explains how much data that actually is. Zachary Nader.

Information Systems: http://www.journals.elsevier.com/information-systems/ This video talks about a computer information system and how it's a system composed of people and computers that processes or interprets information. Christopher Phethean 4/15/16

https://www.youtube.com/watch?v=RdgFoFPTckw&nohtml5=False This video gave a good visual on information systems and the basics that the book discussed. Rebecca Campbell 4/9/2016

Section 12.2 Spreadsheets

https://www.youtube.com/watch?v=L7dHA_8GzKw This video provides a beginners looks at how spreadsheets work, specifically in Excel. I found this extremely useful as I personally never knew what spreadsheets were used for. Exampels are also provided which helped clear the air. Zack Squires 4/7/16 I found this youtube channel dedicated to teaching how to use spreadsheets, spreadsheets are typically confusing to me so this helped out. https://www.youtube.com/user/learnexcelfunctions -Matt Lanteigne

wwww.pcmag.com/article2/0,2817,24182,00.asp Before I took this class, I only has a brief idea of what spreadsheets were and how they work. I have learned that they are actually very important to familiarize yourself with since they are used in many environments such as work. -Danielle Gary (April 9th, 2016)

Introduction to Formulas - http://ccm.net/contents/673-spreadsheet-formulas Provides a lot of basic information about spreadsheets. Really helpful and easy to understand. Date Posted: Unknown. Date Added: 4/6/2016. - Samantha Stuart

Spreadsheet Formulas

http://deathbybloomingflowers.blogspot.com/2013/12/the-spreadsheet-tools.html Date Accessed: 11/3/15 Date Published: 12/20/13 Although this is just a person's blog it discussed the formulas you will sometimes see within spreadsheets. It provides valuable time-saving formulas to use within excel. The information is similar to what we have listed in the book but breaks it down just a little further.

http://www.baycongroup.com/excel2003/excel03.htm (Date Published: Year 1999 - 2015) This website is a step-by-step procedure on how to use the Spreadsheet Formulas, and it also give the functions of each operands. Although, they base this on Microsoft Excel 2003 it will also work with the latest version of Microsoft Excel. (Date Added: April 09, 2016)

http://ccm.net/contents/673-spreadsheet-formulas 4/10/16 This website has helpful information regarding formulas in spreadsheets and also shows several examples with pictures on how formulas work. - Mike Huynh

Circular References

http://www.excel-easy.com/examples/circular-reference.html 4/8/16. This website explains and shows examples of circular references in an excel spreadsheet. Mike Wilbur.

Excel - Circular References https://www.youtube.com/watch?v=v_bXGfcXxno Last updated on July 20th, 2014. Seen on April 9th, 2016. This 10 minute video on circular references in excel is q good way of understanding this topic. It gives a good step by step explanation of the topic and helps those, especially beginners, who may need to learn or revisit this topic. Urooj Haider

Spreadsheet Analysis

https://www.youtube.com/watch?v=vMveTKPR9gU This video helps explain how to use excel for queries in more details by going step by step. Jaclyn Mason

Section 12.3 Database Management Systems

https://www.youtube.com/watch?v=FR4QIeZaPeM Date posted: 4/11/2015 Date published: Jul 12, 2013 This video explains what a database management system is and the types of DBMS. Sudarshan T

https://www.youtube.com/watch?v=Q-PUoZA-VLA&list=PLnxBrInqFEs7DqOUljmVlgZ_xRRSsyesu&index=4 Date posted: Mar 21, 2014

http://www.brighthub.com/internet/web-development/articles/110654.aspx I chose this website because it broke down the various models in a very basic way. The definitions were easier to understand than in the book, I believe. Date Added: 11/13/2015 Zachary Brogna

This video helped me to understand databases and what a Database Management system is. https://www.youtube.com/watch?v=aR44FbeeFH8 This video gives the basic information of DMS. Posted April 4, 2013 Added April 11, 2015 by Leon Ngo

http://social.technet.microsoft.com/wiki/contents/articles/24236.importing-an-excel-spreadsheet-into-a-sql-server-database.aspx importing an excel spreadsheet into an SQL server.This website provides for the spreadsheet instruction in chapter 12 and correlates it to the SQL instruction in that chapter. Bob Lafrance

https://www.youtube.com/watch?v=6u2zsJOJ_GE This video is about introduction to Database Management Systems. It was uploaded by Bart Baesens on Sep 24, 2013. Sworup Ojha 4/6/16

The Relational Model


Structured Query Language

http://www.itl.nist.gov/div897/ctg/dm/sql_examples.htm This website helped me understand structured query language better. It provides examples and shows you how it is done. -Jess Krafft https://www.youtube.com/watch?v=mQ4D0drMrYI

http://www.sqlcourse.com/table.html This site teaches you the sign query language. It helped me to understand with better explanations than the text. -Nicole Berry

https://www.youtube.com/watch?v=44zAgV7zZi0 : Structured Query Language Tutorial. Date added: 12 April 2015. Date created: 4 November 2010. This video gives a basic introduction to SQL. It is the first in a series of CS videos. Olivia Giedymin.

http://www.sqlcourse.com/table.html I liked this website because it broke down each aspect of SQL on a different page with examples that made more sense than what the book says. Edited in 2015 Added: 11-17-15 ~Rebecca Sherr

SQL Structured Query Language https://www.youtube.com/watch?v=tOFyHyEjup8 posted on youtube March 3 2015 covers group by, union, except, natural joins, inner joins, outer join. Rebecca Peacott 3/24/2015


http://www.w3schools.com/sql/ This is a cool interactive SQL tutorial (Added by Zachary Halzel on April 7, 2016).

Modifying Database Content

Database Design

This video brings you through all the information and steps that deal with the entity relationship modeling. It shows definitions and examples explain in more detail about the process. I It helped me have a better understanding. - Steve Gannon

http://www3.ntu.edu.sg/home/ehchua/programming/sql/relational_database_design.html Date Added 11/14/15. Last Edited Sept. 2010. This link talks about the Relational Database Design. It goes over how this model came to be, what the objective of this design is, and the process of using this design. In the link briefly takes about each step of the process including how to define the purpose of the database, gather the data, specify the primary keys, how to organize tables, the different types of relationships between tables, and then how to refine and normalize the design. ~Caitlyn Lambert-Hutchinson

https://www.youtube.com/watch?v=vmFFEok91GU Date added 11/14/15. Date uploaded 7/30/14. This video focuses on database design using ER (entity-relationship) modeling. Calebthevideomaker on youtube has great tutorials and is always my first stop because they are simple and fun. After watching I had a better understanding of the concept and ER diagramming. Antoinette Cabral

Thia tutorial is great for using the number one spreadsheet program https://www.youtube.com/watch?v=0W_933RnCXM ~Liz Cochrane 4/6/16

Section 12.4 E-Commerce