Sunday, February 24, 2013


Times New Roman: serif, proportionally spaced

Arial: sans serif, proportionally spaced

Courier New: serif, fixed width font

Homework:
Convert these binary numbers to decimal:
1011
1101
110
1000

Count from 0 to 20 in binary.

In Exploring book,
Word Ch 2, practice and mid-level exercises
Excel Ch 2, practice and mid-level exercises

For quiz next week:
Based on:
multiple choice from Word Ch 2, Excel Ch 2
One question where you need to convert a small binary number to decimal. (E.g., what is 101 in decimal?)

Sunday, February 17, 2013


A1 reference style
R1C1 reference style


Homework:
Word Ch1 practice and mid-level exercises

Quiz next week based on:
a) quick-checks in Concepts book
b) multiple choice at end of Word Ch 1
c) keyboard shortcuts homework

Sunday, February 10, 2013


WYSIWYG

Show Hide Paragraph
Shift-F1 is reveal formatting
Alt-F9 is show Word Fields

Windows Essentials
http://windows.microsoft.com/en-US/windows-live/essentials-other-programs

Security Essentials
http://windows.microsoft.com/en-US/windows/security-essentials-download

Pandora.com
free music station, adjusts to your likes and dislikes


http://www.pearsonhighered.com/exploring/

HW:
make sure you get the books
Windows section, ch 1 Practice and Mid-Level Exercises at end
pg 45-48
This one is NOT to hand in
Excel ch1, Practice and Mid-Level exercises at the end
in my book, pg 364 and on

next week, we will have a quiz
for this first quiz, I will keep it simple.
all questions will be drawn from the mult choice sections of
the two chapters mentioned in the homework, namely on Windows 7 and on Excel.

Sunday, February 3, 2013


Direct links to cheap versions of the books

for $13, the Grauer Book (Exploring)
http://www.amazon.com/gp/offer-listing/0136122329/ref=sr_1_1_up_1_spi_olp?s=books&ie=UTF8&qid=1359911531&sr=1-1&condition=used

For $0.01, the Computer Concepts
http://www.amazon.com/gp/offer-listing/1423906101/ref=dp_olp_used?ie=UTF8&condition=used


universal computer


von Neumann architecture

1. Say "please enter a #"
2. Get the number, store it in X
3. Say "please enter a #"
4. Get the number, store it in Y
5. Add X and Y, store it in Z
6. Say X " plus " Y " is " Z
7. Go to Step 1
fetch-execute cycle
IP (instruction Pointer)
1

X: 3

Y: 9

Z: 12

Homework:


1) Get the books
2) If you want Office on your home computer, now would be a good time to check that it exists
3) Create that folder structure (i.e. Josh, the subfolders CS12, CS101, and hello.txt in CS101) on your own machine. Use both Windows explorer and CMD.
4) Write up a Word Document explaining what all of the keyboard shortcuts we did in Word actually do.

http://www.cs.qc.cuny.edu/tutors.html

Welcome to CS12


CS12
Joshua Waxman
joshwaxman@gmail.com

Username:
First 2 letters of LAST NAME, followed by
First 2 letters of FIRST NAME, followed by
Last 4 digits of CUNYfirst ID#

Password:
8 digits of CUNYfirst ID#

what if my cuny first id was:
12345678

login (for me): wajo5678
password: 12345678

username: lab
password: csstudent

Understanding Personal Computers

Assignment:
On your C: drive, create a folder called Josh
Within that Josh folder, create two subfolders, CS12 and CS101
in CS101, create a text document, called hello.txt, with the words "How are you doing?" inside.

Windows-Key E will launch windows explorer
double-click on C to get to the C drive
right-click to get popup menu (context sensitive)

Three exams
hands-on
Word - 10%
Excel - 25%
Access - 25%

Quizzes - 10%
Lecture Final - 10%
Web page assignment - 10%
Homeworks - 10%

Books
Exploring Microsoft Office 2010, Volume 1
New Perspectives on Computer Concepts (June Parsons Author), going back to 11th edition. Can also get 2010, 2011, 2012.

Assignment:
On your C: drive, create a folder called Josh2
Within that Josh folder, create two subfolders, CS12 and CS101
in CS101, create a text document, called hello.txt, with the words "How are you doing?" inside.

command line interface
GUI (graphical user interface)

CD \
brought me back to the root folder
(change directory)

MD Josh2
(make directory)

DIR
(give directory listing)

CD Josh2

md CS101
md CS12
cd CS101

Edit hello.txt

IEXPLORE
Grauer is the main author of the Exploring Book
prenhall.com/grauer
http://www.pearsonhighered.com/exploring/

What we need for this class
* books
* Microsoft Office
* files referred to in the Office book
* suggested: USB (flash) drive

http://wps.prenhall.com/bp_exploring_mso2010_vol1_2e/


Navigate to:
C:\Word2010


HELLO.TXT
HELLO.BAT
TERMPAPE.DOC
HOME.HTM


Windows-Key E
At top, type C:\Excel2010


rows, columns