link to description of web page assignment.

Practice Access walkthroughs

#1


and #2

Practice Access Exam 1.
Practice Access Exam 2.
Access Review Presentation.


Access practice exam files.





SELECT Balance, AID, BID, CID
FROM Accounts
WHERE Balance > 10000 OR
BID="B30"

SELECT Balance, AID, BID, CID
FROM Accounts
WHERE Balance > 10000 OR
BID="B30"
ORDER BY Balance

SELECT Accounts.AID, Accounts.CID, Accounts.BID, Accounts.Balance
FROM Accounts
WHERE (((Accounts.BID)="B50"))
ORDER BY Accounts.AID;

Select * From Accounts, Branch
Where Accounts.BID = Branch.BID

called an INNER JOIN

SELECT Customers.LastName, Customers.FirstName, Accounts.Balance, Branch.Location, Accounts.OpenDate
FROM Customers INNER JOIN (Branch INNER JOIN Accounts ON Branch.BranchID = Accounts.BID) ON Customers.CID = Accounts.CID
WHERE (((Accounts.Balance)<=2000) AND ((Accounts.OpenDate)>=#1/1/2007#));

Select * From Accounts, Branch, Customers
Where Accounts.BID = Branch.BID and Accounts.CID = Customers.CID

the only one able to view a cookie is the website that wrote the cookie

embed advertisements from other sites in a website

3rd party cookie


http://www.cs.qc.cuny.edu/fulltime.php


Database: collection of tables and means of dealing with that data.
Table: collection of records
Record: collection of fields
Field: a single unit of data

start access: msaccess
access must have a database file to work against
changes to your data automatically save
no undoing in access

back up their databases regularly

Create/ Table design
data vs. meta-data


redundancy
inconsistent data


solution:
relational database
primary key, foreign key

course index spring 2012
http://www.cs.qc.cuny.edu/schedule/sp12/sp12.htm

Goal seek
 good, but limited
  -- can only set the target cell to a specific value
  -- can only fiddle with one other cell
  -- no constraints
Solver
http://cs101.wvu.edu/media/1/10/19/35/Excel_Chapter_8.pdf

Pivot Tables

Text to Columns

in excel
hidden programming language
called VBA
visual basic for applications

imperative programming languages
Alt-f11: VBA editor
Ctrl-G immediate window
? means print

? 5
 5
? 5 + 2
 7
? 50 + 100 / 2
 100
? "Ryan"
Ryan
? Len("Ryan")
 4
myName = "Josh"
? myName
Josh


Excel Exam
Sun, Apr 22

First Web assignment:

1) Write up a single webpage about your favorite sport.
Use 2 pictures to illustrate it. Some text should be:
* bold
* italics
* bold italics
* underlined

Also, include a link to another webpage somewhere on the Web
which discusses your sport.

Use WinSCP to make this web page.



1) We logged in
2) We created public_html folder. (one time only)
3) We dbl-clicked on public_html to enter that folder
4) We created hello.html
5) We changed the properties on hello.html
6) We saw that web page in a web browser
http://cs12.cs.qc.cuny.edu/~loginname/hello.html

Prepare for the Excel exams

Excel practice exam files,

Practice Excel Exam 1.
Practice Excel Exam 2.
Practice Excel Exam 3.
Practice Excel Exam 4.
Practice Excel Exam 5.
Excel Review Presentation.


Walkthroughs:
Exam 1



Exam 2


Exam 3


Exam 4


Exam 5

mid function
in Excel
substitute in Excel
UPPER and LOWER in Excel
for next time, in codecademy,
"5. Editor and Arrays"

reference styles
A1
R1C1 reference style

serial numbers
date is offset, or number days, from Jan 0, 1900

for next week, prepare
Numbers n' Strings on codecademy

next week, section B in ch 5

* using tools, formatting
* writing formulas

=B5 + B5*C5
=B5 * (1 + C5)

are equivalent
PEMDAS
parentheses to enforce order of operation

debugging
bug - an error in computer instructions
http://en.wikipedia.org/wiki/Grace_Hopper

command line interface
GUI
graphical user interface

web browser
download latest browser:
Internet Explorer
http://windows.microsoft.com/en-US/internet-explorer/downloads/ie

Google Chrome
https://www.google.com/chrome

Mozilla Firefox
http://www.mozilla.org/en-US/firefox/new/

Safari
http://www.apple.com/safari/download/

Let us say that my name is Joshua Waxman and my CunyFirst ID is 12345678
my login (user name) will be wajo5678
my password will be the full CunyFirst ID, 12345678

within WinSCP:
hostname: cs12.cs.qc.cuny.edu
username: wajo5678
password: 12345678

if not, send me an email
HW: try logging in to WinSCP from home

Notes, and Word Exam Walkthrough

For next time, try "Variables" on codecademy.com

$#,##0.00;[Red]($#,##0.00)

http://www.openoffice.org/
http://www.libreoffice.org/

SpyBot Search and Destroy
http://www.safer-networking.org/en/home/index.html


http://snopes.com/
The Urban Legend Webpage

HW: In both New Perspectives (ch 3) and Exploring (ch 3, ch 4, practice and mid-level exercises).

Practice Word Exam.
Word practice exam files,

lecture 3

New Perspectives Labs at the end of the chapter

HW:
W3Schools,
http://www.w3schools.com/html/default.asp
from HTML Elements to HTML Paragraphs

Codeacademy - JavaScript
http://www.codecademy.com/#!/exercises/0
Do "Getting To Know You"
Try "Confirm or Deny"

A useful website for Office 2010:
www.myitlab.com/compass

spybot search and destroy

lecture 2

prenahll.com/grauer

c:\office

Word Ch 1 hands on exercise 1
(pg 126)

c:\office\w01h1buffalo

Word formats based on:
* Characters
* Paragraphs
* Sections

Ctr- power up
Shift - select text / extend selection

Homework:
Word Ch1, Practice exercises and mid-level exercises

von Neumann architecture

input
output
memory
control
math ability

http://www.google.com/imgres?imgurl=http://upload.wikimedia.org/wikipedia/commons/thumb/8/84/Von_Neumann_architecture.svg/420px-Von_Neumann_architecture.svg.png&imgrefurl=http://en.wikipedia.org/wiki/File:Von_Neumann_architecture.svg&h=400&w=420&sz=16&tbnid=-u48fhNZU6qHYM:&tbnh=90&tbnw=95&zoom=1&docid=AfQfRQ5XGHoJnM&sa=X&ei=iKAuT6eIC-ry0gGZ_KjECg&ved=0CEEQ9QEwAg&dur=326


CPU: central processing unit
- control unit
- ALU

binary data
numbers are in base 2
decimal numbers are in base 10
45

instead of digits from 0 to 9
binary uses digits from 0 to 1
0 false, off
1 true, on

trilobite
http://en.wikipedia.org/wiki/Trilobite
is not a measure of computer storage
extinct marine arthropod

general pyurpose computer
instructions (software) to make this universal computer (hardware) into a specific computer

via the von Neumann architecture and the fetch-execute cycle

serif vs. sans serif
1 point = 1/72"

http://cs12.cs.qc.cuny.edu/~xiuyi/fugu.html

Welcome to CS12

Here is a link to the (tentative) syllabus.

Notes from today's class:

Microsoft Office
practical, hands-on skills

Computer Concepts

Computer Science dept website
http://www.cs.qc.cuny.edu/

For tutor hours
http://www.cs.qc.cuny.edu/tutors.html

Blackboard
gG56554645

qccs012.blogspot.com

Word Processing Software
Microsoft Word
Wordpad

www.openoffice.org

Web Browsers
Microsoft Internet Explorer
IEXPLORE
Mozilla Firefox
Google Chrome

Web-based email:
Yahoo.com
Hotmail.com
Gmail.com

Homework:
Buy the books
Get yourself a Gmail account
Download WinSCP (not the beta release)
W3schools Learn HTML: Read (and practice!) from “HTML Home” until “HTML Basic”
(see links on the syllabus for these last two.)

beta software
stable version

To open newer (2007 or 2010) office documents in 2003:
http://www.microsoft.com/download/en/details.aspx?id=3