Saturday, June 4, 2011

Grades are now in CUNYFirst

Though they might not show up until Monday for you.

If you got an F, don't fret! This is readily resolvable. It means that I am missing a test for you, for whatever cause, and did not want to give you a low grade without getting your attention. Otherwise, you might have gotten a B and not thought to ask me about it, when you should have gotten an A+, for example. Please contact me ASAP -- I'll try contacting you as well -- and we can resolve this quickly.

Sunday, May 8, 2011

every alternate chapter in the book is about how to develop web pages

http://www.w3schools.com/html/default.asp

cs12.cs.qc.cuny.edu

instructions for web page assignment
http://eniac.cs.qc.edu/~svitak/cs12/webpageassign.html


how do you log on to the cs12 machine (webserver)?

1) run WinSCP
2) log in to the machine with your credentials.

What are your credentials?
hostname: cs12.cs.qc.cuny.edu
login: wajo6789
password: all eight digits of your CUNYFirst ID
123456789
first two letters of last name
first two letters of first name
last four digits of your CUNYFirst ID

public_html
homepage.html

3) create the public_html folder (you only need to do this once)
4) create or edit the file(s) in the public_html folder

5) view the webpage in your web-browser?
http://cs12.cs.qc.cuny.edu/~wajo6789/homepage.html

Sunday, April 17, 2011

class is off

very few people showed up. see you after the break!

Sunday, April 3, 2011

ipmt
ppmt

csv = comma separated values
importing data

pivot tables
mixed refs
we know absolute refs
we know relative refs
mixed refs: one part absolute, one part relative

cs88

Tutoring schedule link

You can see when tutors are available here.

Practice exam 2

here is a link

Sunday, March 20, 2011

hw: ch 3, midlevel exercises and capstone

what is left?
Financial functions, in depth
Goal Seek
Solver
Pivot Tables
(Mixed references)
Go thru the practice exams

Financial functions, in depth
__________________________
time value of money

Present Value
Future Value
how many times am i collecting interest
what is the interest rate

Sunday, March 13, 2011

relative vs. absolute references

A1 -- relative reference
$A$1 -- absolute reference

A1 style
r1C1 style

what happens when your formula is wrong?
how do you find the "bug" and fix it?
Grace Hopper
http://en.wikipedia.org/wiki/Grace_Hopper

Sum function
range operator
:
cell ref : cell ref

hw: midlevel and capstone exercises, ch 2, excel

Sunday, March 6, 2011

To err is human; to really fowl things up takes a computer.

Excel
colon operator
is the range operator
A1:B6

relative references

HW:
Excel ch 1, mid-level exercises 1-5, capstone exercise

Sunday, February 27, 2011

We actually ran that C++ code, instructions.

If you want to learn how to code C++: CS111
If you want to learn how to code VB: CS80

how to count in binary

0 - 000
1 - 001
2 - 010
3 - 011
4 - 100
5 - 101
6 - 110
7 - 111

How to add in binary
we see it on the board.

practice:
convert 5 and 2 to binary. add them together

The World Wide Web is NOT the same as the Internet
the Internet is hardware
the Web is software

w3schools.com

HTML is the language you use to write web pages

hypertext markup language
web server
http://www.cs.qc.cuny.edu/tutors.html
HW #4:
midlevel and capstone exercises for ch 4

At home, try taking the practice Word Exam

Sunday, February 20, 2011

lecture notes, #3

what binary numbers mean

how to convert from base 2 to base 10
how to convert from base 10 to base 2
octal, hexademical numbers to binary and back
base 8, base 16

how do we count in hex?
0
1
2
3
4
5
6
7
8
9
A
B
C
D
E
F

0 - 0000
1 - 0001
2 - 0010
3 - 0011
4 - 0100
5 - 0101
6 - 0110
7 - 0111
8 - 1000
9 - 1001
A - 1010
B - 1011
C - 1100
D - 1101
E - 1110
F - 1111

Lecture HW#1:
1) Convert these decimal numbers to binary:
7
14
103

2) Convert these binary numbers to decimal:
11001
110
11
1101

3) Convert those numbers in part 2 to octal.
4) Convert those numbers in part 2 to hexadecimal.

programming languages
low-level languages
one very close to the actual instruction set of the CPU


00100010010100101100100000001111100101010
machine language

assembly language
mov ax, 4
mov bx, 3
add ax, bx

correspondence between assembly instructions and machine
mov 00100
ax 0001
bx 0010

http://en.wikipedia.org/wiki/Assembly_language

high-level languages
http://en.wikipedia.org/wiki/High-level_language

Some C++ code to calculate costs:
http://www.functionx.com/cpp/examples/ifelse1.htm
#include <iostream>
using namespace std;

void main()
{
    unsigned int Miles;
    const double LessThan100 = 0.25;
    const double MoreThan100 = 0.15;
    double PriceLessThan100, PriceMoreThan100, TotalPrice;

    cout << "Enter the number of miles: ";
    cin >> Miles;

    if(Miles <= 100)
    {
        PriceLessThan100 = Miles * LessThan100;
        PriceMoreThan100 = 0;
    }
    else
    {
        PriceLessThan100 = 100 * LessThan100;
        PriceMoreThan100 = (Miles - 100) * MoreThan100;
    }

    TotalPrice = PriceLessThan100 + PriceMoreThan100;

    cout << "\nTotal Price = $" << TotalPrice << "\n\n";
}

compiler
interpreter

Java, C++ compiled language
JavaScript, python

Binary <--> Decimal Conversion

See here for how to convert a binary number to a decimal number.
See here for how to convert a decimal number to a binary number.

At each of these links, there is a detailed description of the process in text, as well as a video. However, they accidentally put the same video in each. To see how a video of how to convert binary --> decimal, see it on YouTube here.

Actually, I'll also post both videos in this blog post:

Decimal to Binary:


Binary to decimal:


For now, practice with the practice numbers they give at those two links. Eventually, I will assign other binary and decimal numbers to convert for a homework.

Here is an extended ASCII chart.

How to convert between binary and hexadecimal.
How to convert between octal and binary. There are better ways.

Making Office 2003 Compatible with Office 2007 formats

You can download the Office Compatibility Pack from Microsoft:
By installing the Compatibility Pack in addition to Microsoft Office 2000, Office XP, or Office 2003, you will be able to open, edit, and save files using the file formats in newer versions of Word, Excel, and PowerPoint . 

How to obtain Microsoft Office (for PCs)

You can get it from microsoft, in one of three ways:

1) You can use the 60 day free trial, available here:

2) You can buy the full version available for cheap to university students, here:
For this, you will need your QC email, since it requires an email which ends in .edu. $80 is a pretty
good price for the full version of office.

3) For free, you can use Office Web Apps:
These run in your web browser. Unfortunately, Microsoft Access is not included as a Web App, but
it does include PowerPoint, Word, and Excel.

You can get the data files you need for the exercise either by downloading it from Prentice Hall website:

or by bringing in a Flash drive to lab next time and copying the folder onto it.

Friday, February 11, 2011

Thursday, February 10, 2011

Update:

The college is indeed closed for this coming Sunday, Feb 13th.

I still have to set up Blackboard, so hold on to your homeworks for now.

Sunday, February 6, 2011

lecture notes, #2

qccs012.blogspot.com
see my email address on the sidebar

Intro to computers, computer science

what is a computer?
something that computes

input, output, math ability, memory, control

input:
keyboard, mouse, mike

output:
speakers, printer, monitor

memory
short term - RAM
long term - CD ROM, hard drive, flash drive, floppy drive

CPU
central processing unit
CPU has:
-ALU: arithmetic / logic unit
-control unit: what happens first, second, third

von Neumann architecture
http://en.wikipedia.org/wiki/Von_Neumann_architecture

data is carried by the "bus"

Old way:
dedicated computer for a specific task
IBN Sorting Machine
http://www-03.ibm.com/ibm/history/exhibits/attic3/attic3_136.html

hardware: physical components
vs. software

Universal, general purpose computer
it has the capability of being any particular computer

we make it into a particular, specific computer by feeding it instructions. software.

fetch-execute cycle
we fetch an instruction
then we carry it out (executing it)
then, we fetch an instruction
then we carry it out (executing it)
then, we fetch an instruction
then we carry it out (executing it)
then, we fetch an instruction
then we carry it out (executing it)
then, we fetch an instruction
then we carry it out (executing it)

pseudo-code. instructions written for a human to understand. computer probably won't.

Adding machine.
program:
1) say "please enter a number"
2) get the number, store it in X
3) say "please enter another number"
4) get the 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, inside the control unit.

RAM is volatile memory, short term.
hard disk is not volatile, long term
copy into RAM
set IP= 1
both instructions, data are stored in RAM

this program "loops"

-----

three levels of memory
long term: hard disk
short term: RAM -- random access memory
really short term: registers

sequential access memory -- scroll,
random access memory -- book

http://en.wikipedia.org/wiki/Floppy_disk

parallel, perpendicular
one of them means 0, the other of them means 1

bit - binary digit; 0 or 1

http://en.wikipedia.org/wiki/CD_ROM

more complicated info by combining bits

0, 1, 2, 3

could store these four values in 2 bits

0 - 00
1 - 01
2 - 10
3 - 11

5 pants
8 shirts
40 combinations; 5 x 8

8 bits = byte
how many combinations?
2 x 2 x 2 x 2 x 2 x 2 x 2 x 2 = 2^8 = 256

three bits?
2^3
2 x 2 x 2

0 - 000
1 - 001
2 - 010
3 - 011
4 - 100
5 - 101
6 - 110
7 - 111

all the former possibilities with a leading 0
all the former possibilities with a leading 1
twice as many as before

you add a bit, you have twice as many possible values

four bits -- nibble
how many possible values?
2^4 = 16

0 - 0000
1 - 0001
2 - 0010
3 - 0011
4 - 0100
5 - 0101
6 - 0110
7 - 0111
8 - 1000
9 - 1001
10 - 1010
11 - 1011
12 - 1100
13 - 1101
14 - 1110
15 - 1111

we count memory in bytes
1 byte = byte
2 bytes = word
4 bytes = dword
1024 bytes = 2^10 = kilobyte ~= 10^3
1024 x 1024 bytes = 2^20 bytes = megabyte ~= 10^6
2^30 bytes = gigabyte ~= 10^9
2^40 bytes = terabyte ~= 10^12
http://en.wikipedia.org/wiki/Terabyte

used to be. but memory makers are greedy; they like to market to you also.
they use powers of 10

herz
kilohertz
megahertz
gigahertz

the bigger the number, the faster the computer

multiple CPUs


-----



in lab, we did the four practice exercises. you might want to go through the hands-on-exercises at home, once you get the book.

typography -- appearance of printed matter
font;
serif, sans-serif fonts
http://www.livescience.com/strangenews/more-difficult-fonts-improve-learning-110113.html

fixed-width (monospaced) vs. proportional
is every letter/symbol the same width?

W
i

  $   10.00
  $    0.54

lining up fonts

1 point = 1/72 inch
1 pica = 12 points

how do i make my paper:
adjust font face, point size
increase margins
line spacing
indent
how many sentences per paragraph
=rand(5,4)
lorem ipsem text

between character spacing; kerning
Wi

"WILL TYPE UP YOUR PAPERS. WILL ENSURE THAT THE SPELLING AND GRAMMER ARE CORRECT"

non-breaking space
non-breaking hyphen

windows and orphans

style - a bag of formatting
a way of separating formatting from meaning

reveal formatting - Shift F1

hw:
midlevel exercises and capstone exercise

Sunday, January 30, 2011

#1

To get an ADS account
https://cams.qc.cuny.edu/

You can go to the help desk in the I building
and they will aid you in setting up your account

qccs012.blogspot.com

You have the lab book; gives you instructions. You need the student data files.

C:\BlueJ\lib

file system; folder navigation

Shift-enter: line break, not a new paragraph

three levels of formatting in Word.
1) Character level
2) Paragraph level
3) Section level

Ctrl when used with arrow keys: power up
Shift with arrow keys: extend selection

http://qccs012.blogspot.com/

All Midlevel exercises and the capstone exercise

Attendance

Practice Exam walkthroughs

Word exam:



Excel exam 1:


Excel exam 2:


Excel exam 3:


Excel exam 4:


Excel exam 5:



Access exam 1:


Access exam 2:

Thursday, January 27, 2011

Tentative point distribution

Book homeworks -- 10%
as follows:
 Word HW#1 -- 1%
 Word HW#2 -- 1%
 Word HW#3 -- 1%
 Word HW#4 -- 1%

 Excel HW#1 -- 1%
 Excel HW#2 -- 1%
 Excel HW#3 -- 1%
 Excel HW#4 -- 1%
 Access HW#1 -- 1%
 Access HW#2 -- 1%
 Access HW#3 -- 1%
 Access HW#4 -- 1%

This adds up to 12%, which means you can skip 2 of them. Half a percentage point lost on homeworks for each week late. Thus, one week late means 0.5%, and don't even bother with two weeks late.

Word Exam -- 10%
Excel Exam -- 25%
Access Exam -- 25%
PowerPoint project -- 5%
Web Project -- 10%
Lecture homeworks -- 5%
Lecture final -- 10%


Cheating policy: Please don't cheat. If you are caught cheating, it counts as a 0 for that assignment or exam.

The book for this class

For Labs:
We will be using Exploring Microsoft Office 2007, Volume 1

There are multiple versions of this book, but this is a good version. I will be using this version for teaching in class, but if you have a different version of the book, we can work around it.

For Lecture:
We will be using:
A Balanced Introduction to Computer Science, by David Reed
but there will likely be material even outside of this book

A partial schedule

There is other lecture material, and other homeworks and projects besides these. But this is a useful schedule for the material in the book(s), and a bit outside the books.


We meet
we cover
homework due
30-Jan
Word Chapter 1

6-Feb
Word Chapter 2

13-Feb
no classes
Word HW#1
20-Feb
Word Chapter 3
Word HW#2
27-Feb
Word Chapter 4
Word HW#3
6-Mar
Excel Chapter 1
Word HW#4
13-Mar
Excel Chapter 2
Word Exam, Excel HW#1 due
20-Mar
Excel Chapter 3
Excel HW#2
27-Mar
Excel Chapter 4
Excel HW#3
3-Apr
Access Chapter 1
Excel HW#4
10-Apr
Access Chapter 2
Excel Exam, Access HW#1
17-Apr
Access Chapter 3
Access HW#2
24-Apr
No Classes: Spring Break

1-May
Access Chapter 4
Access HW#3
8-May
PowerPoint Chapter  1
Access HW#4
15-May
PowerPoint Chapter 2

22-May
Finals
Access Exam, PowerPoint Project due


Some practice exams that are out there

though there will likely be material on the exams which do not appear on these practices:

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

Practice Access Exam 1.
Practice Access Exam 2.



Some downloads to be able to take the practice exams:
Word practice exam file,
Excel practice exam file,
Access practice exam file.

Weekend College Schedule

 ABC
1Weekend College                                                                                                                                                             Spring 2011 Calendar
2FridaySaturdaySunday
328-Jan29-Jan30-Jan
44-Feb5-Feb6-Feb
511-Feb                                               No Classes: Lincoln's Birthday12-Feb                                                 No Classes13-Feb                                                        No Classes
618-Feb19-Feb20-Feb
725-Feb26-Feb27-Feb
84-Mar5-Mar6-Mar
911-Mar12-Mar13-Mar
1018-Mar19-Mar20-Mar
1125-Mar26-Mar27-Mar
121-Apr2-Apr3-Apr
138-Apr9-Apr10-Apr
1415-Apr16-Apr17-Apr
1522-Apr                                             No Classes: Spring Break23-Apr                                             No Classes: Spring Break24-Apr                                             No Classes: Spring Break
1629-Apr30-Apr1-May
176-May7-May8-May
1813-May14-May15-May
1920-May                                                  Finals21-May                                                  Finals22-May                                                  Finals
20