Practice Word Exam.
Word practice exam file,
Word exam:
Sunday, October 30, 2011
Formula auditing
debugging your formulas
evaluate formula is one suich debugging tool
trace precedents (draws arrows...)
trace dependents (draws arrows...)
Relative reference - get changed as copy formula
Absolute reference - stays put
Using the Name Box, you can give Names to Absolute references
FUNCTION is basically a named operator
+-*/^
5 + 4
5 and 4 are operands
SQRT
SQRT(16)
operands we call parameters or arguments
we covered some basic functions
Number formatting:
There is a diff between the actual value stored in a cell and the way it displays.
Superman III, Office Space
maybe use the round function
Read through Ch 5 in the Lecture Book
Do quickchecks
No Quiz next week. Instead, a Word exam
IF function
VLOOKUP function
Do Practice Exercises for ch 2 in Excel
(you might want to also look at the mid-level exercises, since that won't have as much hand-holding, and you want to be able to develop and intuition about writing formulas, to prepare for the Excel hands-on exam.)
Sunday, October 23, 2011
workbook
has many worksheets
literals vs formulas
sometimes you will make a mistake
formula auditing is a "debugging" tool
Evaluate Formula
Word exam (hands on) - Nov 6
next week, Oct 30, quiz
on material from
SUNDAY, OCTOBER 16, 2011
http://qccs012.blogspot.com/2011/10/something-called-ip-address-httpen.html
http://qccs012.blogspot.com/2011/10/httpqcpages.html
plus, lecture book, ch 3, all sections
Please finish Ch 4 in lecture book
do the quickchecks
From lab book, do Practice Exercises for Ch1 of Excel
start with HTML images
for the src tag, you can give relative or absolute paths
we can store on the same webserver, or pull images from a different webserver
src="/images/pulpit.jpg"
this means that it is on the same webserver
src="http://img.thesun.co.uk/multimedia/archive/00440/cow_682_440047a.jpg"
What I just did, pulling the image from another webserver is called "hotlinking".
not nice; not a good idea
"stealing" bandwidth
we got up to the end of lists
that is it for now for HTML
CSS - cascading style sheets
http://www.w3schools.com/css/default.asp
font tag, and other tags were deprecated
CSS Syntax
selector
declarations
together, they form a CSS rule
simple selectors are based on the tag
class selectors, id selectors
We will start our web pages:
1) log in using WinSCP
2) We will create a folder called public_html
3) We will create a file called main.html inside the public_html folder
4) we will see our webpage in a webbrowser
hostname of OUR webserver is:
cs12.cs.qc.cuny.edu
username: wajo5678
password: 12345678
permissions
three groups:
you, group, universe
actions: read, write, execute
octal means base 8
so far, we have seen base 10 (decimal); base 2 (binary);
each 3 bits corresponds to a single octal digit, for the sake of setting permissions
chmod 705 main.html
would change the permissions to give all rights to the owner, none to the group, and read and execute to the universe
to see your webpage:
hostname/~loginname/filename
http://cs12.cs.qc.cuny.edu/~wajo5678/main.html
404 error: not found
you typed the URL wrong
or filename isn't actually in public_html
403 error: forbidden
you didn't set the permissions correctly
Every folder has two folder within it
One is called .
means myself
One is called ..
means parent
cmd line (DOS), text based interface to the Operating System
cd means change directory (a directory is a folder)
cd .
cd ..
HW: (not to hand it)
go home, log in to WinSCP, make an html page called new.html, put something there
Also, edit main.html
DropBox
https://www.dropbox.com/
Sunday, October 16, 2011
something called an IP address
http://en.wikipedia.org/wiki/IP_address
a 32-bit number
that means that there are 4 bytes in an IP address
hard to remember IP addresses
DNS - domain name server
will give you IP addresses in return for domain names
hosts file in a specific folder on your computer
can use it to block web sites
scammers can use it, so nowadays, only edit as admin
Domain:
everything from the :// until the first / after that
http://www.scamsite.ru/login/www.chase.com/
http://23.123.6.5/www.chase.com/login
http://0x62.0x1F.0x11.0x44/www.chase.com/login
TLDs - top level domain
TLAs = three letter acronym
.com
.org
.net
.gov
.edu
.xxx
whitehouse.gov
countries have their own top level domain
.uk
ac.uk
co.uk
google.co.uk
google.com
subdomain
www.google.com
www is a subdomain within google.com
google.com is the "real" domain
Dr. Svitak's website
http://eniac.cs.qc.edu/~svitak/cs12/
eniac.cs is the subdomain
http://www.chase.com.gimmeyourinfo.ru/login
This is NOT really chase.com
It is a Phishing scheme
Let us pretend that my name is Joshua Waxman and my CunyFirst ID is 12345678
hostname of OUR webserver is:
cs12.cs.qc.cuny.edu
login: first two letters of YOUR last name +
first two letters of YOUR first name +
last 4 digits of your CunyFirst ID
my login: wajo5678
my password: 12345678
#1: lowercase
#2: maybe the first and lastnames are reversed
#3: it is YOUR information, not mine
#4: if it still doesn't work, see Xiuyi
HW: Go home and install WinSCP on your computer
(or Fugu / TextWrangler if you have a Mac)
Usually, web pages are stored on web server
Your web browser is called the client
When you load up a webpage by typing in a URL
you are sending an "HTTP request"
http://en.wikipedia.org/wiki/Hypertext_Transfer_Protocol
You type in: http://en.wikipedia.org/wiki/Main_Page
something like: GET /wiki/Main_Page http/1.1
to host: en.wikipedia.org
The webserver responds with an Http response
HTTP/1.0 200 OK
followed by the contents of the requested html page
web client receives it, and renders it
other responses:
404 Page not found
403 Forbidden
The Web is NOT the Internet
it is one of the services available on the internet
there is software called WinSCP
is windows software for editing files remotely, and file transfer
if you have a Mac, you will need Fugu instead
follow this link
http://cs12.cs.qc.cuny.edu/~xiuyi/fugu.html
If you a PC (most of you do):
http://winscp.net/eng/download.php
Make sure you don't download the Beta version
What is Beta?
What is Alpha?
make sure to get the stable version
http://qcpages.qc.cuny.edu/weekend/
Finish Ch 3 in lecture book
(includes quickchecks)
Begin Ch 4 in lecture book
(sections A and B)
next time we meet (next week), quiz
on material from SUNDAY, OCTOBER 2, 2011
as well as Ch 2 in lecture book
Other ways of storing pictures
Pictures, Clip Art, Word Art, Symbols
Do practice exercises for Word, Ch 3
Word exam (hands-on), 3 weeks from now
Will be on ch 1-4 in the book,
plus Mail merge
http://eniac.cs.qc.edu/~svitak/cs12/MailMerge.pdf
A sample exam:
http://eniac.cs.qc.edu/~svitak/cs12/PracticeWord.pdf
Dr. Svitak's website:
http://eniac.cs.qc.edu/~svitak/cs12/
Sunday, October 2, 2011
HW:
Lab book: practice exercises for ch 2, maybe ch 3
Lecture book: ch 3, section A - C
Do the QuickChecks at the end of each section
Quiz next time we meet (two sundays from now):
everything from prev quiz until last week's material
that includes some basic HTML
also, Ch 1 in the lecture book
freeware, open source software
http://www.openoffice.org/
open source = they give you the source code = the instructions written in some programming language
http://sourceforge.net/
find, create, publish open source software for free
more HTML
a is for anchor
we finished HTML links on w3schools
anatomy of a URL:
http://en.wikipedia.org/wiki/Uniform_Resource_Locator
Uniform Resource Locator
syntax:
scheme://domain:port/path?query_string#fragment_id
http
hypertext transfer protocol
webclient and webserver communicate in this http protocol
https
it is secure
bank websites
domain indicates the computer
www.google.com is a domain
qc.cuny.edu is a domain
port is a number, for most websites, optional
scheme, or protocol, is the way we define the structure of the information
web technologies
Subscribe to:
Posts (Atom)