Saturday, May 22, 2010
Sunday, May 16, 2010
Saturday, April 17, 2010
Sunday, April 11, 2010
Friday, April 9, 2010
Sunday, March 14, 2010
What we did
worked a bit on web assignment.
finished ch 1 hands on 1-4
homework: ch 1, all 4 practice exercises
started ch 1 hands on 1 -- we finished step 1 and spoke about absolute vs relative references
finished ch 1 hands on 1-4
homework: ch 1, all 4 practice exercises
started ch 1 hands on 1 -- we finished step 1 and spoke about absolute vs relative references
Sunday, March 7, 2010
notes from class
making a web page with word
mail merge
1- write the letter to *one person*
2- create your database of information to merge in
3- modify your letter to make use of the "merge fields"
4- actually merge the document with the database (Finish and Merge / Edit Individual Document)
mdb -- microsoft database (Access 2003 file)
accdb -- microsoft database (Access 2007 file)
hw: take the practice test at home
svitak cs12
http://eniac.cs.qc.edu/~svitak/cs12/PracticeWord.pdf
http://eniac.cs.qc.edu/~svitak/cs12/practicedocx.exe
http://eniac.cs.qc.edu/~svitak/cs12/studyguideword.html
target: 2 weeks from now
hw: word ch 4, all 4 practice exercises
camstudio.org
microsoft moviemaker
excel
rows, cols, cells
functions, formulas
=
values, operators, references, functions
basic excel in *this* class
cs88 - advanced productivity tools for business
mail merge
1- write the letter to *one person*
2- create your database of information to merge in
3- modify your letter to make use of the "merge fields"
4- actually merge the document with the database (Finish and Merge / Edit Individual Document)
mdb -- microsoft database (Access 2003 file)
accdb -- microsoft database (Access 2007 file)
hw: take the practice test at home
svitak cs12
http://eniac.cs.qc.edu/~svitak/cs12/PracticeWord.pdf
http://eniac.cs.qc.edu/~svitak/cs12/practicedocx.exe
http://eniac.cs.qc.edu/~svitak/cs12/studyguideword.html
target: 2 weeks from now
hw: word ch 4, all 4 practice exercises
camstudio.org
microsoft moviemaker
excel
rows, cols, cells
functions, formulas
=
values, operators, references, functions
basic excel in *this* class
cs88 - advanced productivity tools for business
Sunday, February 28, 2010
Phishing scam
domains on URL (web addresses)
Anti-Phishing Phil
http://123.45.24.1/www.chase.com
understandingpersonalcomputers.blogpsot.com
whitehouse.gov
whitehouse.com
whitehouse.net
TLA -- three letter acronym
IP address
cmd
DNS
HTTP request
HTTP response
cache
HTML - hypertext markup language
we get our own website
cs12.cs.qc.cuny.edu/~wajo6789
login: wajo6789
password: 123456789
first two letters of last name
first two letters of first name
last 4 digits of social
Joshua Waxman
123456789
WINSCP download
hostname: cs12.cs.qc.cuny.edu
public_html
it will work
or it will say website or file or folder does not exist
or it will say that you do not have permission
hello.html
cs12.cs.qc.cuny.edu/~wajo6789/hello.html
w3schools.com
starts with this text is bold
This is a hyperlink
with an attribute
we are doing ch 3 hands on 3
plan: ch 4, ho 1,
i will quickly demonstrate ho 2
ho 3
skip ho 4
i will walk you thru mail merge
then, we will be finished with Microsoft word, and will start on Excel
domains on URL (web addresses)
Anti-Phishing Phil
http://123.45.24.1/www.chase.com
understandingpersonalcomputers.blogpsot.com
whitehouse.gov
whitehouse.com
whitehouse.net
TLA -- three letter acronym
IP address
cmd
DNS
HTTP request
HTTP response
cache
HTML - hypertext markup language
we get our own website
cs12.cs.qc.cuny.edu/~wajo6789
login: wajo6789
password: 123456789
first two letters of last name
first two letters of first name
last 4 digits of social
Joshua Waxman
123456789
WINSCP download
hostname: cs12.cs.qc.cuny.edu
public_html
it will work
or it will say website or file or folder does not exist
or it will say that you do not have permission
hello.html
cs12.cs.qc.cuny.edu/~wajo6789/hello.html
w3schools.com
starts with this text is bold
This is a hyperlink
with an attribute
we are doing ch 3 hands on 3
plan: ch 4, ho 1,
i will quickly demonstrate ho 2
ho 3
skip ho 4
i will walk you thru mail merge
then, we will be finished with Microsoft word, and will start on Excel
Sunday, February 21, 2010
goal for today
Ch 2 hands on exercise 2 - 4
Ch 3 hands on exercise 1
homework: Ch 3 hands on exercise 2
also, Ch 2, practice exercise 1-4
Ch 3 hands on exercise 1
homework: Ch 3 hands on exercise 2
also, Ch 2, practice exercise 1-4
notes 3
understandingpcs.blogspot.com
0000 0
0001 1
0010 2
0011 3
0100 4
0101 5
0110 6
0111 7
1000 8
1001 9
bit = binary digit
byte = 8 bits
nibble = 4 bits
word = 16 bits
dword = 32 bits
00
01
10
11 = total of 4 possible values
000
001
010
011
100
101
110
111 = total of 8 possible values
socks: red, green, blue
shoes: white, black
H
T
HHH
HHT
HTH
HTT
THH
THT
TTH
TTT
1 bit: 2^1 = 2
2 bits: 2^2 = 4
3 bits: 2*2*2 = 2^3 = 8
4 bits: 2^4 = 16
5 bits: 32
8 bits: 2^8 = 256
16 bits: 2^16 = 65,536
24 bits: 16.7 million
1024 = 2^10 bytes: kilobyte
1024x1024 bytes; 2^20: megabyte
2^30 = approx 1 billion: gigabyte
2^40: approx a trillion: terabyte
hertz
gigahertz
pixel = picture element
resolution
how many bits per pixel
24 bit color
900,054 bytes
24 bit bitmap
500 across
600 down
500 x 600 x 3 bytes
256 color
301,078 bytes
16 color
151,318 bytes
monochrome
38,462 bytes
HW from last time:
ch 1, practice exercise 1-4
0000 0
0001 1
0010 2
0011 3
0100 4
0101 5
0110 6
0111 7
1000 8
1001 9
bit = binary digit
byte = 8 bits
nibble = 4 bits
word = 16 bits
dword = 32 bits
00
01
10
11 = total of 4 possible values
000
001
010
011
100
101
110
111 = total of 8 possible values
socks: red, green, blue
shoes: white, black
H
T
HHH
HHT
HTH
HTT
THH
THT
TTH
TTT
1 bit: 2^1 = 2
2 bits: 2^2 = 4
3 bits: 2*2*2 = 2^3 = 8
4 bits: 2^4 = 16
5 bits: 32
8 bits: 2^8 = 256
16 bits: 2^16 = 65,536
24 bits: 16.7 million
1024 = 2^10 bytes: kilobyte
1024x1024 bytes; 2^20: megabyte
2^30 = approx 1 billion: gigabyte
2^40: approx a trillion: terabyte
hertz
gigahertz
pixel = picture element
resolution
how many bits per pixel
24 bit color
900,054 bytes
24 bit bitmap
500 across
600 down
500 x 600 x 3 bytes
256 color
301,078 bytes
16 color
151,318 bytes
monochrome
38,462 bytes
HW from last time:
ch 1, practice exercise 1-4
Sunday, February 7, 2010
class 2 notes
DropBox
show file extensions
.DOCX
.DOC
Syllabus:
Word, Excel, Access, ? Powerpoint
Computer concepts
HTML and web pages
DOS -- command line interface
3 hands-on tests
word, excel, access
20%, 20%, 25%
web page - 10%
hw - 15%
quizzes on computer concepts - 10%
book: grauer book(s)
w3schools.com
we learnt some basic html, up to but
not including HTML elements
von Neumann architecture
wikipedia
hardware
General purpose computer
software
bus
instruction set
RAM
x: 3 y: 4 z: 7
1. Say "please enter the first #"
2. get first number, store it in x
3. Say "please enter the second #"
4. get second number, store it in y
5. add x and y, store it in z
6. say x "and" y "=" z
7. Go to step 1
IP: 1
fetch-execute cycle
computer understands machine language
binary
01010111101
show file extensions
.DOCX
.DOC
Syllabus:
Word, Excel, Access, ? Powerpoint
Computer concepts
HTML and web pages
DOS -- command line interface
3 hands-on tests
word, excel, access
20%, 20%, 25%
web page - 10%
hw - 15%
quizzes on computer concepts - 10%
book: grauer book(s)
w3schools.com
we learnt some basic html, up to but
not including HTML elements
von Neumann architecture
wikipedia
hardware
General purpose computer
software
bus
instruction set
RAM
x: 3 y: 4 z: 7
1. Say "please enter the first #"
2. get first number, store it in x
3. Say "please enter the second #"
4. get second number, store it in y
5. add x and y, store it in z
6. say x "and" y "=" z
7. Go to step 1
IP: 1
fetch-execute cycle
computer understands machine language
binary
01010111101
Sunday, January 31, 2010
notes from class 1
Welcome to CS12 - understanding pcs
ms office package
word
excel
access
? powerpoint
html - making pages
dos - command line interface
windows
Exploring Microsoft Office Excel 2007
Exploring Microsoft Office Word 2007
Exploring Microsoft Office Access 2007
$219
$160
Exploring Microsoft Office 2007
robert grauer
office
volume 1, NOT volume 2
comprehensive is also OK, means 1 + 2
amazon
alibris
bookfinder.com
HW:
1) Get the book
start with word
2) Make sure you have Microsoft Office 2007 at home
WINWORD
EXCEL
MSACCESS
POWERPNT
What is a computer?
Something that computes.
input
keyboard, mouse, microphone
output
speakers, screen, printer
memory
short term memory
RAM
random access memory
long term memory
hard disk, floppy disk, USB
sequential memory
arithmetic ability
control
CPU
Central Processing Unit
ALU -- arithmetic / logic unit
control unit
von Neumann architecture
understandingpcs.blogspot.com
prenhall.com/grauer
web browsers
IEXPLORE
Chrome
Firefox
Opera
associations
formatting:
on the character level
on the paragraph level
on the section
three letter extension
word document ends .docx
ms office package
word
excel
access
? powerpoint
html - making pages
dos - command line interface
windows
Exploring Microsoft Office Excel 2007
Exploring Microsoft Office Word 2007
Exploring Microsoft Office Access 2007
$219
$160
Exploring Microsoft Office 2007
robert grauer
office
volume 1, NOT volume 2
comprehensive is also OK, means 1 + 2
amazon
alibris
bookfinder.com
HW:
1) Get the book
start with word
2) Make sure you have Microsoft Office 2007 at home
WINWORD
EXCEL
MSACCESS
POWERPNT
What is a computer?
Something that computes.
input
keyboard, mouse, microphone
output
speakers, screen, printer
memory
short term memory
RAM
random access memory
long term memory
hard disk, floppy disk, USB
sequential memory
arithmetic ability
control
CPU
Central Processing Unit
ALU -- arithmetic / logic unit
control unit
von Neumann architecture
understandingpcs.blogspot.com
prenhall.com/grauer
web browsers
IEXPLORE
Chrome
Firefox
Opera
associations
formatting:
on the character level
on the paragraph level
on the section
three letter extension
word document ends .docx
Subscribe to:
Posts (Atom)