CPTR 101 A

 

 

ASSIGNMENT

 

Week 1 Read the following sections: Overview,

the Binary Numbering System, and Hardware.

 

Write out the binary code for the numbers 0 - 15, and

figure out the ASCII-8 codes for a - z.

 

 

Week 2 Read the following section: Software.

Read pp. FM 11 FM 16 of Access 2010.

 

Show the results of all the logical operations described

for A and B if A is .TRUE. and B is .FALSE.

 

 

Week 3 Read pp. AC 1 AC 11 of Access 2010.

 

Do Handout #1.

 

 

Week 4 Read pp. AC 11 AC 14, AC 59 AC 69 of Access 2010.

 

Also see office.microsoft.com/access:

(under Popular topics):

  Create a new database

  Create a database without using a template

 

Lab: Tables

 

Do Handout #2.

 

Prepare review questions for Exam #1.

 

 

Week 5 Read pp. AC 111, AC 116 AC 119,

AC 139 AC 145, AC 548 AC 552 of Access 2010.

 

Lab: Queries

 

 

Week 6 Exam #1 today.

 

Midterm project due.

 

 

Week 7 Read pp. AC 167 AC 170, AC 307 AC 327 of Access 2010.

 

Lab: Forms

 

 

Week 8 Read pp. AC 192 AC 196, AC 361, AC 371 AC 373,

AC 378 AC 380, AC 395 AC 403 of Access 2010.

 

Lab: Reports

 

 

Week 9 Read pp. AC 91 AC 96, AC 121 AC 122,

AC 403 AC 406 of Access 2010.

 

Lab: Advanced queries

 

 

Week 10 Read pp. AC 522 AC 525 of Access 2010.

 

Prepare review questions for Exam #2.

 

Lab: Macros

 

Week 11 Read pp. AC 76 AC 81 of Access 2010.

 

Optional reading: office.microsoft.com/excel. . . .

 

HW #10: Definitions.

 

Prepare review questions for Exam #2.

 

 

Week 12 Optional reading: office.microsoft.com/powerpoint. . . .

 

Review questions and Final Project Workshop today.

 

 

Week 13 Exam #2 today.

 

Final project due.