Sunday CS12

Practice Access Exams

2014-04-30T19:45:00.002-07:00

PracticeExamFiles.zip

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

Preparation for Word Exam (in two weeks)

2014-04-25T11:57:00.001-07:00

Practice Word Exam.

Word practice exam file,

Walkthrough:

Practice Excel Walkthroughs

2014-04-06T08:07:00.001-07:00

more to come...

2014-03-30T09:06:00.002-07:00

HW
Ch 1 on Windows 7
Ch 1 on Office Fundamentals
Ch 1-2 on Word
Ch 1-4 on Excel

practice and mid-level exercises
winscp download and install
read about HTML on w3schools
joshwaxman@gmail.com

quiz next week on
Excel mult choice ch 3, 4
Word mult choice ch 2

notes

2014-03-23T09:03:00.001-07:00

Word ch 2 hands-on exercise 1
pg 169 in the book
C:\WORD

w02h1simserv

Font face
Serif vs Sans Serif fonts
point size
a point = 1 / 72 of an inch

Fixed width vs proportional
Wi
ii

snopes.com

($200.00)
$23,924

Practice Exams for Excel

2014-03-16T08:55:00.002-07:00

Updated to include exam instructions. See below.
Updated to include exam file downloads. See below.

Lab Exam 2 Study Guide.

The first step to study for the Microsoft Excel Lab Exam is to read through the Excel Review Presentation:
Excel Review Presentation.
The second step to study for the Microsoft Excel Lab Exam and to get an idea of the format of the Microsoft Excel Lab Exam is taking the Practice Excel Exams:
Practice Excel Exam 1.
Practice Excel Exam 2.
Practice Excel Exam 3.
Practice Excel Exam 4.
Practice Excel Exam 5.

File downloads:
Practice Excel 1
Practice Excel 2
Practice Excel 3
Practice Excel 4
Practice Excel 5

lecture notes

2014-03-16T08:53:00.002-07:00

in cell I8:
=(SUM(B8:H8)-MIN(B8:H8))/(COUNT(B8:H8)-1)

in cell T8:
=SUM(J8:S8)

in cell W8:
=AVERAGE(U8:V8)

in cell Y8
=I8*$B$40+T8*$B$41+W8*$B$42+X8*$B$43

VLOOKUP:
#1: value you are looking for on the table
(this will be usually on the same row as you)
#2: table you are looking at to try to find that value
#3: once you have the row, what column?
#4: range lookup? TRUE

=VLOOKUP(Y8,Grades,2,TRUE)

=IF(Y8>=Passing,"Enroll in CS 202","RETAKE CS 101")

Student Rank
=RANK(Y8,$Y$8:$Y$30)

http://eniac.cs.qc.cuny.edu/~svitak/cs12/

lecture notes

2014-03-09T09:01:00.001-07:00

host: cs12.cs.qc.cuny.edu
user: wajo5678
pass: 12345678

public_html

http://cs12.cs.qc.cuny.edu/~wajo5678/index.html
gopher://
telnet://
ftp://

homework:
1: excel ch 3, do the practice and mid-level exercises
2: Go to w3schools.com and read in the HTML section, from HTML Home until HTML Elements

SSH Secure Shell
called secure shell client

(alternatively, you can get putty)

to get a directory listing:
ls -l
pwd
cd public_html
chmod 777 index.html

lecture 5 notes

2014-03-02T08:58:00.001-08:00

C:\Word
w01h1buffalo_WaxmanJoshua.docx

quiz next week
excel ch 2 mult choice
410
word ch 1 mult choice
pg 156
Computer Concepts, ch 1, quickchecks for sections A-E

hostname:
cs12.cs.qc.cuny.edu

username: wajo5678
password: 12345678

try to download winscp
http://winscp.net/eng/download.php
Don't click on any ads, even if it looks like a big green Download button

lecture notes class 4

2014-02-23T09:07:00.001-08:00

c:\excel

decision tree

time value of money
money today worth more than money a year from now because I can invest

PV = present value
FV = future value
use interest rate and time to move from PV to FV, or from FV to PV

plus and minus indicate directionality, flow of money
- money away from me
+ money towards me

C:\WORD

what does control do with the navigation keys?

lecture 3

2014-02-16T09:07:00.001-08:00

C:\Excel

prenhall.com/grauer
www.pearsonhighered.com/exploring/

select your book
student data files

lab
csstudent

in your c:\excel folder
e02h1loans.xlsx

save as
e02h1loans_LastNameFirstName.xlsx

reference styles in Excel
A1 reference style (columns are letters like A, rows as numbers like 1)
R1C1 reference style (R means row so Row 1, C means column, so column 1)

we can switch between reference styles
File tab / Excel Options / Formulas and check off or clear the checkbox for R1C1 reference style

Quiz: questions from pg 44
I will ask you to count to five in binary
000 0
001 1
010 2
011 3
100 4
101 5

hw: practice and mid-level exercises (45-48)
hw: practice and mid-level exercises for Excel ch 1 (364-370)

input
output
math ability
memory
control

necessary for computer

von Neumann
http://en.wikipedia.org/wiki/John_von_Neumann

Von Neumann architecture
general purpose computer
(universal computer)

memory (RAM)
CPU - central processing unit
control unit
ALU -- arithmetic / logic unit
input
output

fetch-execute cycle
first you fetch an instruction
from memory
and push it into the ALU
ALU executes it

it is a cycle
so the process starts

a computer program to add two numbers together

1. Say "please enter a number"
2. Read a number from input, push it into memory, calling it x
3. Say "please enter a second number"
4. Read a number from input, push it into memory, calling it y
5. Add x and y, store the result in memory, calling it z
6. Say x and y is z
7. Goto step 1

control unit has IP: 1

ADD AX, 5
MOV BX, 5
JMP 1
CMP AX, 7

lecture 2

2014-02-09T09:07:00.000-08:00

Can try it one month for free
Split it 5 ways for 9.99 a month before splitting
http://office.microsoft.com/en-us/try/

josh waxman
cunyfirst id: 12345678

login: wajo5678
password: 12345678

1 point = 1/72 "

Serial Numbers in Excel

a text file consist of a series of bytes:

"ABC"

what would stored is:
65 66 67

"65"

54 53

.txt
plain text files where each character corresponds to a single byte
ASCII code for that symbol

Attending

2014-02-09T05:37:00.001-08:00

Welcome

2014-02-02T05:16:00.000-08:00

CS12
Understanding Personal Computers

Josh Waxman

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

qccs12.blogspot.com

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

Exploring Microsoft Office 2010
either this one
or this one

Computer Concepts, June Parsons

New Perspectives on Computer Concepts 2011: Introductory (June Parsons Author)

3 big exams
Word - 10%
Excel - 25%
Access - 25%

quizzes - 10%
often on lecture material, maybe some hands-on small actions.
or pulled from mult choice in hands-on book

lecture final - 10%
very similar to on-paper quizzes

homework - 10%
project - 10%

http://eniac.cs.qc.cuny.edu/~svitak/cs12/

Word
Excel
Access

hw: make sure you have these three at home

Windows Key-R
WINWORD and press enter key
EXCEL and press enter key
MSACCESS and press enter key

We made a very simple webpage
name it web1.html

open notepad.
type something
save
change Save as type to All files (instead of Text files)

How to launch Excel
Navigate to the folder that contains EXCEL.EXE program and then double-click on that

1) Launch Windows Explorer (Windows Key-E)
2) Navigate to C drive
3) Navigate to Program Files subfolder
4) Navigate to Microsoft Office subfolder
C:\Program Files\Microsoft Office
5) Navigate to Office15 subfolder
C:\Program Files\Microsoft Office\Office15
6) scroll down until see EXCEL
7) double-click on EXCEL

Call the file
e01h1markup_WaxmanJoshua

we finished excel ch 1 hands on exercises 1-3

File Extensions
what they are, how to see them

8 letter names + 3 letter file extension
WINWORD.EXE
POWERPNT.EXE
EXCEL.EXE

.EXE computer program
.TXT text file
.DOC Microsoft Word Document
.XLS Microsoft Excel Spreadsheet
.HTM plain text, but contains Hypertext Markup language

File extension associations

For the Quiz:
the keyboard shortcuts
Ctrl-S
Ctrl-X
Ctrl-C
Ctrl-V
Shift-Del
Ctrl-Z
Alt-tab
Windows Key-R
Ctrl -
Ctrl +
Ctrl-`

Create a shortcut
Create a folder
Pin a program to the taskbar

End quiz

Binary

qccs12.blogspot.com