Tuesday, January 31, 2012

Welcome to CS88

Amazon store is here.

 CS 88
qccs88.blogspot.com
joshwaxman@gmail.com

primarily on Excel

homeworks - 20%
midterm, final - 45%, 35%, leaning towards the higher score

Lab, lecture

self-review of CS12, Excel

Excel practice exam files,
Practice Excel Exam 1.
Practice Excel Exam 2.
Practice Excel Exam 3.
Practice Excel Exam 4.
Practice Excel Exam 5.
Excel Review Presentation.

Excel is a powerful tool.
We can make use of its power in 3 ways.

1. Tools (icons)
2. ability to write formulas
essentially computer programming
3. VBA programming
Alt-F11 will launch programming environment

You should probably have Excel at home
http://www.microsoft.com/student/office/en-ca/default.aspx

Codecademy.com

HW:
#1: try to get the books
#2: Finish Getting to Know You, Part I on Codecademy
#3: Try 2. Confirm or Deny on Codecademy

meaning of extensions
XLS -- 2003
XLSX -- 2007 and on, without macros (VBA)
XLSM -- 2007 and on, with macros

underlying value
vs.
formatting

PEMDAS

bug
http://en.wikipedia.org/wiki/Grace_Hopper