Wednesday, April 30, 2014
Friday, April 25, 2014
Sunday, April 6, 2014
Sunday, March 30, 2014
Sunday, March 23, 2014
notes
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
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
Sunday, March 16, 2014
Practice Exams for Excel
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
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
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/
=(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/
Sunday, March 9, 2014
lecture notes
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
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
Sunday, March 2, 2014
lecture 5 notes
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
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
Sunday, February 23, 2014
lecture notes class 4
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?
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?
Sunday, February 16, 2014
lecture 3
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
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
Sunday, February 9, 2014
lecture 2
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
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
Sunday, February 2, 2014
Welcome
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
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
Subscribe to:
Posts (Atom)