Tuesday, September 27, 2011
Sunday, September 25, 2011
cams.qc.cuny.edu
3 levels of formatting
* Character level
* paragraph level
* section level
Homework:
Word, Ch 1, practice exercises
Lecture Book, Ch 2, the quickchecks at the
end of each section
In lab, we finished Ch 2, hands-on-exercise 3. But we have not completed hands-on exercise 4 yet, so no practice exercises from the end of that chapter.
** file extensions, how we can see them, what
they mean
chap1_ho3_credit_solution.docx
file extensions mark the TYPE of the file
TXT = text
file associations
In old Operating Systems (like MS-DOS), you would first start the program, then you would open the file in the program
In modern Operating Systems, there are file associations. If the extension is .docx, then docx is associated with Microsoft Word. It will launch the program automatically.
In Access,
.accdb
.laccdb
In web pages:
.htm
.html
In Word:
.doc = word 2003 file (also word 97)
.docx = word 2007, 2010
.docm = macro enabled document
3 levels of formatting
* Character level
* paragraph level
* section level
Homework:
Word, Ch 1, practice exercises
Lecture Book, Ch 2, the quickchecks at the
end of each section
In lab, we finished Ch 2, hands-on-exercise 3. But we have not completed hands-on exercise 4 yet, so no practice exercises from the end of that chapter.
** file extensions, how we can see them, what
they mean
chap1_ho3_credit_solution.docx
file extensions mark the TYPE of the file
TXT = text
file associations
In old Operating Systems (like MS-DOS), you would first start the program, then you would open the file in the program
In modern Operating Systems, there are file associations. If the extension is .docx, then docx is associated with Microsoft Word. It will launch the program automatically.
In Access,
.accdb
.laccdb
In web pages:
.htm
.html
In Word:
.doc = word 2003 file (also word 97)
.docx = word 2007, 2010
.docm = macro enabled document
Sunday, September 18, 2011
lecture
* Macros in Word
Mail Merge
qccs012.blogspot.com
Visual Basic is a programming language
Visual Basic for Applications is a programming language
Macro
Mail Merge
* need database (of patients)
* template document
binary
bit
8 bits = byte
4 bits = nibble
2 bytes = word
4 bytes = dword
1024 bytes = 1 kilobyte
2^10 = 1024
2^20 bytes = approx 1 million = 1 megabyte
2^30 bytes = approx 1 billion = 1 gigabyte
trilobite = Trilobites (play /ˈtraɪləbaɪt/, /ˈtrɪləbaɪt/; meaning "three lobes") are a well-known fossil group of extinct marine arthropods that form the class Trilobita
2^40 bytes = terabyte
http://en.wikipedia.org/wiki/Terabyte
also in computer speed
megahertz
bigger number, faster the computer, more powerful
we saw how to convert from binary to decimal
11010111 is 215 in binary
HW:
Convert 24 to binary
Convert 124 to binary
What is 1000111 in decimal?
What is 10010 in decimal?
First quiz -- two weeks from now. up to this.
counting in binary, adding in binary
A comp can store #s
How do we store letters?
we store them as numbers
ASCII - american standard code for information interchange
ASCII chart
how many poss different characters can we store?
http://www.cdrummond.qc.ca/cegep/informat/Professeurs/Alain/images/ASCII1.GIF
7 bits = 128 poss values
extended ASCII, using all 8 bits
256 possible values
Unicode
http://en.wikipedia.org/wiki/Unicode
How do I encode colors?
pixels = picture element
in a 256 color bitmap
1 pixel = 1 byte
16 colors; each pixel = 1 nibble
monochrome, each pixel = 1 bit
True color
takes 3 bytes per pixel
RGB
red green blue
256 poss values for each
HW: Lecture book, quickcheck at the end of each lettered section in chapter 1
Mail Merge
qccs012.blogspot.com
Visual Basic is a programming language
Visual Basic for Applications is a programming language
Macro
Mail Merge
* need database (of patients)
* template document
binary
bit
8 bits = byte
4 bits = nibble
2 bytes = word
4 bytes = dword
1024 bytes = 1 kilobyte
2^10 = 1024
2^20 bytes = approx 1 million = 1 megabyte
2^30 bytes = approx 1 billion = 1 gigabyte
trilobite = Trilobites (play /ˈtraɪləbaɪt/, /ˈtrɪləbaɪt/; meaning "three lobes") are a well-known fossil group of extinct marine arthropods that form the class Trilobita
2^40 bytes = terabyte
http://en.wikipedia.org/wiki/Terabyte
also in computer speed
megahertz
bigger number, faster the computer, more powerful
we saw how to convert from binary to decimal
11010111 is 215 in binary
HW:
Convert 24 to binary
Convert 124 to binary
What is 1000111 in decimal?
What is 10010 in decimal?
First quiz -- two weeks from now. up to this.
counting in binary, adding in binary
A comp can store #s
How do we store letters?
we store them as numbers
ASCII - american standard code for information interchange
ASCII chart
how many poss different characters can we store?
http://www.cdrummond.qc.ca/cegep/informat/Professeurs/Alain/images/ASCII1.GIF
7 bits = 128 poss values
extended ASCII, using all 8 bits
256 possible values
Unicode
http://en.wikipedia.org/wiki/Unicode
How do I encode colors?
pixels = picture element
in a 256 color bitmap
1 pixel = 1 byte
16 colors; each pixel = 1 nibble
monochrome, each pixel = 1 bit
True color
takes 3 bytes per pixel
RGB
red green blue
256 poss values for each
HW: Lecture book, quickcheck at the end of each lettered section in chapter 1
Sunday, September 11, 2011
Welcome to CS12, Sunday!
qccs012.blogspot.com
Joshua Waxman
joshwaxman@gmail.com
* Lecture -- concepts of computers
* Lab -- hands on skills, microsoft office
Lecture:
New Perspectives on Computer Concepts, 10th Edition, Comprehensive (New Perspectives Series)
Lab:
Big diff bet Office 2003 and Office 2007
Exploring Microsoft Office 2007 Vol. 1 (3rd Edition) (Spiral-bound)
I-building, help desk
* three lab exams (word - 10%, excel - 25%, access - 25%)
* powerpoint project - 5%
* lecture exam - 10%
* hw - 10%
* web project - 10%
* quizzes - 10%
What do you need to do the lab exercises and lab homeworks?
* data - from prentice hall's website
* programs - Microsoft Ultimate Steal (Professional Academic Edition)
1 point = 1/72"
input
output
memory (RAM)
math ability
control
CPU - central processing unit. contains:
*ALU - arithmetic / logic unit
*control unit
von Neumann architecture
instead of specialized machines
universal computer, general purpose computer
hardware -- physical components
software -- instructions, computer programs
fetch-execute cycle
computer program: a bunch of instructions
1. Say: Please enter a #
2. Get a number, store it in X
3. Say: Please enter another #
4. Get a number, store it in Y
5. Add X and Y, store it in Z
6. Say: X + Y = Z
7. Go to step 1
IP: instruction pointer (within the control unit)
Artificial Intelligence
Alan Turing - Turing test
Don't need to get this, but C++ Express Edition
In C++
// calculator1.cpp : Defines the entry point for the console application.
//
#include "stdafx.h"
#include <iostream>
using namespace std;
int main()
{
int x, y, z;
beginning:
cout << "Please enter a #: ";
cin >> x;
cout << "Please enter another #: ";
cin >> y;
z = x + y;
cout << x << " + " << y << " = " << z << endl;
goto beginning;
return 0;
}
A computer only understands machine language
01000010001
annoying
assembly language
MOV AX, 4
MOV BX, 6
ADD AX, BX
SAY AX
there will be a computer program which takes an assembly language program as input, will spit out the machine language program as output
assembler
disassembler
still annoying
programming languages:
Visual Basic, C++, Java, Javascript, Python, Prolog, Lisp
we need to translate it
Visual basic:
For I = 1 to 10
Msgbox "Hello there!"
Next
translators:
* compiler
* interpreter
interpreted is slower
you get to send the original plaintext instructions for an interpreted languages
C++ compiled language
Javascript interpreted languages
how do I make a 9 page paper into a 10 page
paper?
* line spacing (multiple and exactly)
* adjust the margins
* increase size of period
* add footnotes and images
* add meaningful text
* font face. fixed width, proportional width
* letter spacing
* widow and orphan protection
i
Joshua Waxman
joshwaxman@gmail.com
* Lecture -- concepts of computers
* Lab -- hands on skills, microsoft office
Lecture:
New Perspectives on Computer Concepts, 10th Edition, Comprehensive (New Perspectives Series)
Lab:
Big diff bet Office 2003 and Office 2007
Exploring Microsoft Office 2007 Vol. 1 (3rd Edition) (Spiral-bound)
I-building, help desk
* three lab exams (word - 10%, excel - 25%, access - 25%)
* powerpoint project - 5%
* lecture exam - 10%
* hw - 10%
* web project - 10%
* quizzes - 10%
What do you need to do the lab exercises and lab homeworks?
* data - from prentice hall's website
* programs - Microsoft Ultimate Steal (Professional Academic Edition)
1 point = 1/72"
input
output
memory (RAM)
math ability
control
CPU - central processing unit. contains:
*ALU - arithmetic / logic unit
*control unit
von Neumann architecture
instead of specialized machines
universal computer, general purpose computer
hardware -- physical components
software -- instructions, computer programs
fetch-execute cycle
computer program: a bunch of instructions
1. Say: Please enter a #
2. Get a number, store it in X
3. Say: Please enter another #
4. Get a number, store it in Y
5. Add X and Y, store it in Z
6. Say: X + Y = Z
7. Go to step 1
IP: instruction pointer (within the control unit)
Artificial Intelligence
Alan Turing - Turing test
Don't need to get this, but C++ Express Edition
In C++
// calculator1.cpp : Defines the entry point for the console application.
//
#include "stdafx.h"
#include <iostream>
using namespace std;
int main()
{
int x, y, z;
beginning:
cout << "Please enter a #: ";
cin >> x;
cout << "Please enter another #: ";
cin >> y;
z = x + y;
cout << x << " + " << y << " = " << z << endl;
goto beginning;
return 0;
}
A computer only understands machine language
01000010001
annoying
assembly language
MOV AX, 4
MOV BX, 6
ADD AX, BX
SAY AX
there will be a computer program which takes an assembly language program as input, will spit out the machine language program as output
assembler
disassembler
still annoying
programming languages:
Visual Basic, C++, Java, Javascript, Python, Prolog, Lisp
we need to translate it
Visual basic:
For I = 1 to 10
Msgbox "Hello there!"
Next
translators:
* compiler
* interpreter
interpreted is slower
you get to send the original plaintext instructions for an interpreted languages
C++ compiled language
Javascript interpreted languages
how do I make a 9 page paper into a 10 page
paper?
* line spacing (multiple and exactly)
* adjust the margins
* increase size of period
* add footnotes and images
* add meaningful text
* font face. fixed width, proportional width
* letter spacing
* widow and orphan protection
i
Subscribe to:
Posts (Atom)