Sunday, January 30, 2011

#1

To get an ADS account
https://cams.qc.cuny.edu/

You can go to the help desk in the I building
and they will aid you in setting up your account

qccs012.blogspot.com

You have the lab book; gives you instructions. You need the student data files.

C:\BlueJ\lib

file system; folder navigation

Shift-enter: line break, not a new paragraph

three levels of formatting in Word.
1) Character level
2) Paragraph level
3) Section level

Ctrl when used with arrow keys: power up
Shift with arrow keys: extend selection

http://qccs012.blogspot.com/

All Midlevel exercises and the capstone exercise

Attendance

Practice Exam walkthroughs

Word exam:



Excel exam 1:


Excel exam 2:


Excel exam 3:


Excel exam 4:


Excel exam 5:



Access exam 1:


Access exam 2:

Thursday, January 27, 2011

Tentative point distribution

Book homeworks -- 10%
as follows:
 Word HW#1 -- 1%
 Word HW#2 -- 1%
 Word HW#3 -- 1%
 Word HW#4 -- 1%

 Excel HW#1 -- 1%
 Excel HW#2 -- 1%
 Excel HW#3 -- 1%
 Excel HW#4 -- 1%
 Access HW#1 -- 1%
 Access HW#2 -- 1%
 Access HW#3 -- 1%
 Access HW#4 -- 1%

This adds up to 12%, which means you can skip 2 of them. Half a percentage point lost on homeworks for each week late. Thus, one week late means 0.5%, and don't even bother with two weeks late.

Word Exam -- 10%
Excel Exam -- 25%
Access Exam -- 25%
PowerPoint project -- 5%
Web Project -- 10%
Lecture homeworks -- 5%
Lecture final -- 10%


Cheating policy: Please don't cheat. If you are caught cheating, it counts as a 0 for that assignment or exam.

The book for this class

For Labs:
We will be using Exploring Microsoft Office 2007, Volume 1

There are multiple versions of this book, but this is a good version. I will be using this version for teaching in class, but if you have a different version of the book, we can work around it.

For Lecture:
We will be using:
A Balanced Introduction to Computer Science, by David Reed
but there will likely be material even outside of this book

A partial schedule

There is other lecture material, and other homeworks and projects besides these. But this is a useful schedule for the material in the book(s), and a bit outside the books.


We meet
we cover
homework due
30-Jan
Word Chapter 1

6-Feb
Word Chapter 2

13-Feb
no classes
Word HW#1
20-Feb
Word Chapter 3
Word HW#2
27-Feb
Word Chapter 4
Word HW#3
6-Mar
Excel Chapter 1
Word HW#4
13-Mar
Excel Chapter 2
Word Exam, Excel HW#1 due
20-Mar
Excel Chapter 3
Excel HW#2
27-Mar
Excel Chapter 4
Excel HW#3
3-Apr
Access Chapter 1
Excel HW#4
10-Apr
Access Chapter 2
Excel Exam, Access HW#1
17-Apr
Access Chapter 3
Access HW#2
24-Apr
No Classes: Spring Break

1-May
Access Chapter 4
Access HW#3
8-May
PowerPoint Chapter  1
Access HW#4
15-May
PowerPoint Chapter 2

22-May
Finals
Access Exam, PowerPoint Project due


Some practice exams that are out there

though there will likely be material on the exams which do not appear on these practices:

Practice Word Exam.
Practice Excel Exam 1.
Practice Excel Exam 2.
Practice Excel Exam 3.
Practice Excel Exam 4.
Practice Excel Exam 5.

Practice Access Exam 1.
Practice Access Exam 2.



Some downloads to be able to take the practice exams:
Word practice exam file,
Excel practice exam file,
Access practice exam file.

Weekend College Schedule

 ABC
1Weekend College                                                                                                                                                             Spring 2011 Calendar
2FridaySaturdaySunday
328-Jan29-Jan30-Jan
44-Feb5-Feb6-Feb
511-Feb                                               No Classes: Lincoln's Birthday12-Feb                                                 No Classes13-Feb                                                        No Classes
618-Feb19-Feb20-Feb
725-Feb26-Feb27-Feb
84-Mar5-Mar6-Mar
911-Mar12-Mar13-Mar
1018-Mar19-Mar20-Mar
1125-Mar26-Mar27-Mar
121-Apr2-Apr3-Apr
138-Apr9-Apr10-Apr
1415-Apr16-Apr17-Apr
1522-Apr                                             No Classes: Spring Break23-Apr                                             No Classes: Spring Break24-Apr                                             No Classes: Spring Break
1629-Apr30-Apr1-May
176-May7-May8-May
1813-May14-May15-May
1920-May                                                  Finals21-May                                                  Finals22-May                                                  Finals
20