microsoft ultimate steal
http://www.microsoftstore.com/store/msstore/cat/categoryID.37826100

* import from Excel into Access
my advice: make sure that data type of foreign keys
and primary keys are set to what you want on import.
otherwise, you will problems in establishing relationships
in the relationship window.
set the primary key on Import

* In queries, here are the wildcards:
* means match anything, including nothing
j*sh
will match:
jsh
josh
jithsh
? means matching exactly one characted
j?sh
will match
josh
jish
NOT match jsh
NOT match jiiiish
contains Excel
*Excel*
Learning Excel Formulas
Excel Formulas 2010
Learning Excel
begins with
G*
Grauer
ends with
*ing
Starling

Like "*Excel*"


Today's date: Dec 16
Publish Date: Dec 1
Today's Date MINUS Publish Date <= 60
DATE() - PublDate <= 60


SELECT Book.Title, Book.Price, Book.PublDate
FROM Book
WHERE Book.PublDate > Date()-60;

joshwaxman@gmail.com

w3schools.com

select * from Accounts, Branch
where Accounts.BranchId = Branch.BranchID

SELECT Accounts.AccountID, Accounts.CustomerID, Accounts.BranchID, Accounts.Balance
FROM Branch INNER JOIN Accounts ON Branch.BranchID = Accounts.BranchID
WHERE (((Accounts.BranchID)="b50"))
ORDER BY Accounts.AccountID;

http://eniac.cs.qc.edu/~svitak/cs12/

quiz next week, based on multiple choice from
Access ch 1, 2, 3


SELECT Agents.FirstName, Agents.LastName, Properties.DateListed, Properties.ListPrice, Properties.SalePrice, Properties.SqFeet, Properties.Sold, [ListPrice]/[Beds] AS PricePerBR, ListPrice / (Beds + Baths) As PricePerRoom
FROM Agents INNER JOIN Properties ON Agents.AgentID = Properties.AgentID
WHERE (((Properties.Sold)=No));

Practice Access Exams

Practice Access Exam 1.
Practice Access Exam 2.

PracticeExamFiles.zip

Practice Access 1

Practice Access 2:

Next week, Excel Exam

Microsoft Access

Why? (Compared with Excel)

* more secure
* faster
* smaller
* more powerful
* more features

Database: stores your data, gives you ways of accessing your data, querying your data, changing your data

Database: a bunch of tables
Table: a bunch of records
Record: a bunch of fields
Field: col, or actually just one unit of data

Query: SQL:
select first, last, salary from Customers where Age >= 34 order by last

Also, query designer in Access

Forms: to view and edit your data
Reports: for printing
Macros: programming

Homework:
Ch 1, practice exercise 2, custom coffee
If you cannot do step j, don't worry about it.

Also, think to your major. Make an Access database, with the following tables. Eventually you are going to link them. Tables to make:
* Faculty
* Students
* CourseCatalog
* Rooms
* Spring2012
* The_Name_of_One_Specific_Course

Figure out which will be primary keys and which will be foreign keys. Don't put too much into the data. Think 3 to 5 records for each.

The wayback machine.

archive.org

www.bugmenot.com

www.retailmenot.com

google drive (google docs)

google groups (Usenet and more)

google books

google translate

* Goal Seek
* Solver
* Pivot Tables
Import / Export
* Macros
* VBA
* UDFs
* Express edition VB.NET Visual Studio

* CS courses
http://www.cs.qc.cuny.edu/

http://venus.cs.qc.cuny.edu/~ryba/

google reader
rss feed (XML) - extensible markup language

project gutenberg

Walkthru, Excel exams

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

PracticeExamFiles.zip

grace hopper, debugging

relative vs. absolute references, naming cells, mixed references

Homework:
Excel, ch 2, practice exercise 1

to submit homeworks, send to joshwaxman@gmail

colon operator
comma operator
space operator

http://www.ubuntu.com/download/desktop Homework: excel, chapter 1, practice exercise 1, midlevel exercise 3 Also for homework: Make up a bunch of temperatures. Convert them from F to Celsius, Kelvin, and Rankine http://en.wikipedia.org/wiki/Celsius

openoffice
libreoffice

http://www.snopes.com/

spybot search and destroy
http://www.safer-networking.org/

Quiz 2:

Quick-checks at the end of chapters 2 and 3 in lecture book
Multiple choice at the end of ch 3 in Grauer lab book

http://camstudio.org/
You too can record your screen.
At home, complete Word Ch 3, hands on exercise 3

Practice Word Exam.


Word practice exam file,

Word exam:

Search commands in the ribbon
http://www.microsoft.com/en-us/download/details.aspx?id=28559

first quiz, next week
questions will come from end of section quick-checks in New Perspectives book (Computer Concepts), chapter 1, sections A-E.

questions will come from Grauer book (exploring word), chapter 2, multiple choice.

Also, I will give a binary number and ask for the decimal equivalent. e.g. I'll tell you 1100. Tell me what it is in decimal.

end of definition of first quiz.

______

machine language
assembly language

x = 0
while (x < 10)
{
    print "hello";
    x = x + 1;   
}
print "this is the end of the program."

mov x, 0
10:
cmp x, 10
jnz 100
print "hello"
add x, 1
jmp 10

higher level languages (e.g. Fortran, C++, Java)
they let you write something closer to your natural language.

http://xkcd.com/
reuse
http://xkcd.com/792/
strength
http://xkcd.com/936/

rot13
ABCDEFGHIJKLM
NOPQRSTUVWXYZ

hello
uryyb

hello

Homework:
Word, ch 2, hands-on exercise 3. Styles. First watch me in class. You do not need to (eventually) hand this one in, but you should know how to do this.

To hand in (once blackboard is up):
Word, ch 2, practice exercise 2. Queen City Medical Equipment.

Khan Academy: intro to coloring (tutorial 2).
Make the smiley face yellow, with a red nose.
http://www.khanacademy.org/cs/intro-to-coloring/844038377

np11_1

C:\Word
In word, there 3 levels of formatting.
 character
 paragraph
 section
Word fields - calculated fields that display information.
 * page number
 * section number
 * total number of pages

qccs12.blogspot.com
http://www.cs.qc.cuny.edu/tutors.html
http://www.khanacademy.org/cs
homework:
get yourself a Khan Academy login
(username and password)
try out this first exercise
Intro to Drawing
assignment: draw a face
read:
Cosmo, the Hacker ‘God’ Who Fell to Earth
http://www.wired.com/gadgetlab/2012/09/cosmo-the-god-who-fell-to-earth/
Memory: short term memory, RAM, random access memory. This is very fast, volatile, meaning that pull plug, no more data there. Stores this as electrical charges. more expensive, less space. random access, which is faster.
Storage: long term memory, e.g. hard disk. Usually slower. permanent rather than volatile. cheaper, get more space. sequential access, which is slower.
flash drives
http://en.wikipedia.org/wiki/Solid-state_drive
how computer stores Numbers, letters, programs, etc.
for homework, for yourself. count to 10 in binary. tell yourself what 0111 is in decimal.
ASCII (sometimes ANSI). American Standard Code for Information Interchange.
bits
binary digits
decimal = base 10
binary = base 2
we combine these bits
byte = 8 bits
the more bits, the greater range of values I can store.
many bytes:
1000 or 1024 bytes = 1 kilobyte
1 million bytes, or 1024 x 1024 bytes = 1 megabyte
trilobite = extinct marine arthropod
1 billion bytes or ... = gigabyte
1 thousand gigabytes, 1 trillion bytes = terabyte
1 byte = 8 bits
2 bytes = word
4 bytes = dword
4 bits = half a byte = nibble

http://www.greaterthings.com/Humor/Spelling_Chequer.htm
Grauer homework:
word ch 1, practice exercise 2 (Aztec Computers)

Welcome!

Josh Waxman
joshwaxman@gmail.com
Microsoft Office
 Word
 Excel
 Access
Computer Concepts
 what is a computer
Hands-on exams
 Word exam - 10%
 Excel exam - 25%
 Access exam - 25%
lecture Homeworks - 10%
web projects - 10%
quizzes - 10%
lecture final - 10%
grauer
bookfinder.com
New Perspectives on Computer Concepts 2011: Comprehensive, June Parsons
ISBN-10: 0538744812
ISBN-13: 978-0538744812
Older versions, up to 10th edition, are also acceptable, and all are listed at the Amazon store.
Exploring Microsoft Office 2010, Volume 1, [Spiral-Bound], Robert Grauer
ISBN-10: 0136122329
ISBN-13: 978-0136122326
http://astore.amazon.com/parshablog-20
Dropbox

http://office.microsoft.com/en-us/try
prenhall.com/grauer
1 point = 1/72"
justify
increase font size (even by 1/2 a point)
fonts
Times New Roman - proportional width font, with serifs
Arial - proportional, sans serif
Courier New - fixed width font, with serifs

wikipedia
adjust margins
line spacing
tree structure
path
C:\Program Files\Adobe\Adobe CS5.5\hello.txt
C:\Word

control
math ability
memory
input
output
von Neumann architecture
ALU and control unit are what we have in a CPU
memory, we call RAM
input and output, we know
bus, carries info from one component to another

Adding machine
take two numbers, add 'em up, output result, loop to ask again, etc.
1. Say "Please enter first #".
2. Get number, store it in X.
3. Say "Please enter second #".
4. Get number, store it in Y.
5. Add X and Y, store result in Z.
6. Say X " plus " Y " is " Z
7. Goto step 1
IP (instruction pointer), part of control unit
fetch-execute cycle
hardware vs. software

Start Microsoft Word?
Start / WINWORD.EXE
WinSCP
http://winscp.net/eng/download.php