Date of makeup Access final

This coming Sunday, Jan 3rd. It starts at 10:00 AM

The files and instructions for the test

You need two files for the test.

One is the Access database. It is available for download here.

The next is an Excel spreadsheet. It is available for download here.

Also, you might want the instructions for the test, despite getting a handout. It is available here.

Rescheduled final

We will have the rescheduled final this coming Sunday. Try to come that day. If for some reason you cannot make it, I will try to have another remake day as well...

Test cancelled on account of snow..

QC is closed on Sunday, so no test tomorrow.

The Access final, in terms of snow...

Check this blog to see if it is cancelled. As of right now, it is still on. {update: cancelled, for snow.} But if QC is closed for snow, then the test will need to be rescheduled. See also at qc.edu, for announcements about this...

Access Practice Test #2 Walkthru

Access Practice Test #1 Walkthru

Here it is:

Here is the Excel file we need

Here it is.

Links to the practice exams for Microsoft Access

Here are the instructions for exam 1 and exam 2.

Here is the download for these files.

No class, because of Thanksgiving weekend

Actual Excel Exam

Here are the instructions; Here is the file you need to download.

Here are the instructions; here is the download.

Word Exam Makeup

Word exam instructions and downloads.

Optimization workbook

Optimization

http://venus.cs.qc.cuny.edu/~joshwaxman/Optimization.xls

topics for quiz 2

traveling salesman problem
sorting algorithms
phishing scheme, anatomy of a URL
turing test, captcha
expert systems, decision trees
Excel:
absolute refs
relative refs, mixed
built-in functions
cell
name
financial functs

Here is a link to the text to put in your Exam document.

Word Exam Walkthrough

Anti-Phishing Phil

Play anti-Phishing Phil, and send me a screenshot of the end of level 5.

Here are links to the practice test

The instructions, and the file to work off of.

Hopefully, a video to follow shortly.

Also, to download a free 60 day trial of Microsoft Office 2007 (sufficient for the rest of the semester), click here.

And if you want to purchase it for $60 as a student, click here.

Word Exam Preparation

Links to online practice test for Word, and practice test instructions:

A study guide for Word Exam.

For Homework

Either get the entire zip from Prentice Hall's website.

Or get the file directly from here.

Ch 1 Hands On Exercise 3

Download the file from here.

The first step will be to Save it As another file name in order to rename it.

Try this out to make sure you know Chapter 1 material; you need to use Internet Explorer to make it work.

I discussed archive.org; people got gmail accounts.

Here is a link to Ch 2 Hands on Exercise 2.