Welcome to CS12

CS12
Understanding Personal Computers

Josh Waxman

we will learn about Computer Concepts
we will learn about Microsoft Office
other technologies, e.g. HTML

Free trial of Microsoft Office (for 30 days). Sufficient to get us past the exam next week.

Walkthroughs:
Practice 1:
Practice 2

where are we?
pwd: present working directory
what files are in folder?
ls: list of files
your web page must be in folder called
public_html immediately within your login
folder
how do you make a directory?
mkdir public_html
how do you change to a directory?
cd public_html
how do you edit a file?
every basic web page starts at the file index.html
we need a text editor

elm: electronic mail
pine: pine is not elm
pico: pine composer

pico index.html

chmod: change file permissions
need to know your binary

cd ..


lecture final:
like what was on quizzes
grauer chapters, multiple choice
ch 1-4 (maybe five if time) of concepts book, the end of section questions
a few extra questions here and there

agenda:

advanced word, excel, access (?)

lecture book (computer concepts), ch 5 and 6

review for access exam

Advanced Word:

macros, customizations, macros are in VBA (Visual Basic for Applications), regular expression search

Advanced Excel

macros, UDFs, pivottables, solver (advanced goal seek)

Advanced Access (maybe)

macros (which are different)

Web page project (in class)

how to log into the web server

change permissions for files, folders

html

www.w3schools.com has excellent tutorial, also Dr. Svitak's website

Where do we go from here?

other CS classes, now that you have the CS12 prereq

PracticeExamFiles.zip

Practice Access Exam 1.
Practice Access Exam 2.
Access Review Presentation.

we finished access ch 2, hands on 1 and 2
still need to finish the entire chapter

Practice Exams for Excel

Practice Excel Exam 1.
Practice Excel Exam 2.
Practice Excel Exam 3.
Practice Excel Exam 4.
Practice Excel Exam 5.
Excel Review Presentation.

PracticeExamFiles.zip

more to come...

Quiz next week:
word ch 4 multiple
computer concepts chapter 2

homework:
word ch 5, practice exercises and mid-level exercises

Preparation for Word Exam (in two weeks)

Practice Word Exam.

Word practice exam file,

Walkthrough:

Homework:
Word Ch 3, practice and mid-level exercises
Access Ch 1, practice and mid-level exercises

Quiz:
based on Word ch 3 multiple choice
based on Access ch 1 multiple choice

What is a database:
data + methods of interacting with your data
a collection of tables
what is a table?
a collection of records
what is a record?
a collection of fields
what is a field?
approx same as column in Excel, one unit of data

SELECT DISTINCTROW TOP 10 Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice
FROM Products
ORDER BY Products.UnitPrice DESC;

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?)

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

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.

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