Actual Access Exam file.

Here is a link to the file for PivotTables in Excel.

Here is the exam file.
Here are the exam directions.

access exam pt 1


pt 2


pt 3


simple access queries

Practice Access directions and Practice Access File.

Here is the file for the Excel exam.

Simple Access Queries:

Here is the My First Database file. Right click and save it locally, and then open it.

Anti-phishing Phil.
http://cups.cs.cmu.edu/antiphishing_phil/

Here is a link to the Practice Excel Exam file.
Here is a link to the instructions.

1) Download winscp
involves searching for winscp on google
2) Install winscp
3) Run Winscp
4) hostname: cs12.cs.qc.cuny.edu
5) username: wajo6789
6) password: 123456789
7) Click on login
8) Click on Yes, first time

HW: Edit your web page to include a list of your favorite things.

A more local link to Camstudio.

Get the Optimization.xls file here.

Homework

Ch 1, practice exercise 3, 7

If you need it, here is the PowerPoint presentation I just developed.

Here is a link to the file I want you to modify.

Word exam walkthrough, part i


Word exam walkthrough, part ii.

Practice Word Exam files:

The directions.
And the file to work upon, using the directions. It is zipped up, so you need to run this file and unzip it, just as we did in class for the files for use with the book.

You can skip steps 1 and 2, about DOS.

Hopefully, a video walkthrough will be available online shortly.

Welcome to CS12. Check back at this website over the course of the semester for additional information.

The required book for this course is:
The Exploring Series, by Prentice Hall - Microsoft Office 2003, Volume 1.

Here is a link to the book on Amazon. And another. And another.

The Queens College Book Store should be open today. They will be selling packets for $140.

We will cover Operating Systems, the Microsoft Office package, and Internet technologies.

The first assignment is to apply for an account in order to be able to log on to the computers in the lab. This time, I logged into the computers for you. Go to this website (right click to open in a new window):

https://cams.qc.cuny.edu/login.aspx

Click on "I am a first time user and do not have an account."

You will need to fill in your College ID, your Pin #, and your Billing Zip Code.

College ID is your Social Security Number, not the number on your photo ID.
Pin #, if you have not changed it, is your birthdate in the format mmddyy.

If you have questions, arrange to meet with me. Office hours will be after the lab.

My email address is joshwaxman {at} gmail {Dot} com.

Also, please fill out this survey, either in class or when you get home.

The Final (covering Access):

A reminder: The Access test is this coming Sunday, May 18, at 9:30 AM, in the normal room. If you already took it on the last day of class, you do not have to come in on that day.

Actual Access Exam

Get the Database file here.

Get the Instructions here.

Access Exam Walk-through:

Part 1:


Part 2:


Part 3:

Practice Access Exam

Get the database file here.

Get the exam instructions here.

Download the file here.

You can download the practice Excel Exam file here.
And you can download the practice Excel exam instructions here.

Excel Practice Test

Homework:

Excel
ch 2 practice exercise 7, pg 384

Download the actual test here.

Homework:

Excel, Ch 1 Practice Exercise 6 (page 341)
You can set the earth weight to be 100, which will make it easier for me to check.

Some Useful Book Sites:

http://books.google.com/
http://scholar.google.com
http://www.gutenberg.org
http://amazon.com ?

Homework:

Excel section.
Ch 1, hands on exercise 2 (page 302 and on)
To complete the hands on exercise, you may wish to download the Grade Book Solution.xls file from this web page.
Ch 1, practice exercise 2 (pg 337)

Practice Microsoft Word Exam.
You can download the exam file here:

Part 1:
Character Formatting:


Part 2:
Paragraph Formatting:


Part 3:
Section Formatting:


Part 4:
Image Formatting:


Part 5:
Outlines, Tables, Mail Merge

Homework Review:
Mail Merge for Labels in Microsoft Word.
See the video here:

Click here for Phishing game.

Homework:

Microsoft Word:
Ch 3 Practice Exercise 7. Mailing Labels

Also, play 2 rounds in the Phishing game. Click here for Phishing game.

Attendance in the comments, please, if you have never signed a comment attendance sheet.

Instructions for the PowerPoint assignment:
Most of you have the PowerPoint component in your book, so you can just read these instructions in the book. This is only for the one or two of you that do not yet have that book (and will self-destruct in one week).

What we did in class:
Exploring Windows XP, hands-on-exercise 3
Exploring Word, hands-on-exercise 1
Exploring PowerPoint, hands on exercise 3

Homework:

Word: Ch 3, hands on exercise 2
PowerPoint: Ch 1, practice exercise 1

Homework #3 Walkthroughs:

1) Word Formatting


2) Word Keyboard Shortcuts


3) PowerPoint Creating a Presentation from Scratch

Installing OpenOffice:

Some of you do not have Microsoft Office at home, or do not have certain components of Microsoft Office. If so, this blogpost is directed towards you. Otherwise, not. I would not tell you to get Microsoft Office 2007, which seems to be the only one currently being sold in stores. Do not get it because the user interface is so different that you may have difficulties doing the homework, or applying what we learned in class. Instead, I would suggest you download and install OpenOffice.org, which is a free clone of Microsoft Office. There are slight differences from Microsoft Office, but it will be fairly straightforward to transfer what you learned in class, and vice versa.

Here is a video walkthrough of doing this:

HW3:
Word, Ch2, Practice Exercises 1 and 2
PowerPoint, Ch 1, Hands on Exercise 2

From Class:
Summary of what Ctrl keys do together with arrow keys:
Ctrl: Power Up
Shift: Select as I move

Here is a walkthrough of HW 2, which is basic editing in Microsoft Word.

Class 2 Class Notes

http://computersciencetwelve.blogspot.com/
Questions: joshwaxman@gmail.com
HW: computerscience12@gmail.com

CPU - Central Processing Unit
ALU - Arithmetic / Logic Unit
Control Unit

Control Unit keeps track of instruction to be
carried out. We fetch the data and
instructions from RAM. ALU works on
it. The control unit will update
to point to the next instruction.

RAM - Random Access Memory - you can get anywhere in equal time.

http://prenhall.com/grauer/

Using the Digital Dropbox to Submit Homework Assignments

We'll go over this in class, so don't worry about it, but here is a video taking you through the steps.

Class 1 homework:

1. Buy the book, Microsoft Office 2003 Enhanced, volume 1
2. At home, try running WINWORD, MSACCESS, EXCEL, POWERPNT to see if you have it.
3. Download from the Prentice Hall website the student data disk for the course.
4. See if you got an email to your QCMAIL account with your CUNY portal password. (This will be needed to use Blackboard.)
5. Play a game of Solitaire.
   
6. Have a good week!
   

class 1 summary

computersciencetwelve.blogspot.com
joshwaxman@gmail.com

Operating Systems
 Windows XP
 DOS
 UNIX
 Microsoft Office
  Word
  Excel
  Access
  Powerpoint
 Google Docs and Spreadsheets
 Web page development
 Create videos (webcam, Camstudio)



How to get Microsoft Office
* Go to CS Departmental Office
 ask Xiui Huang about Microsoft Academic Advantage
  to get Microsoft Office
* Go to CompUSA
* Download OpenOffice or StarOffice
 openoffice.org
* Work from labs
* Have it already

Starting application
 Start/Run
 WINWORD
 POWERPNT
 EXCEL
 MSACCESS
 SOL


prenhall.com/grauer

WYSIWG - What you see is what you get
* any text at all, including no text at all
? any single character