Advanced Computer Applications
Period 7
Room B108

Advanced Computer Applications is a fantastic class for students that enjoyed/did well in Computer Applications and would like to become more proficient in Microsoft Excel and Access.  We spend most of our time in those two programs but we will also review Microsoft Word and PowerPoint.  At the end of each program, students will take a test created by the University of Nebraska.  Students that are Juniors and Seniors and pass each of the four tests with an 80% or better will receive notification on their transcripts that they passed those exams.  Students that pass the exams and are enrolled in the Business Administration college of UN-L will receive a waiver for Business Administration 150.

Week 16 - April 28 - May 2, 2008

Monday, April 28

• Work Day - make up work.

Tuesday, April 29

• Lesson 12
  • White Pages - please upload
    • 12-2
    • 12-8
    • 12-10
    • 12-16
  • Exercises - please upload
    • 12-22
    • 12-23

Wednesday, April 30

• Unit 4 Applications
  • 4-1
  • 4-2
  • 4-3
  • 4-4
  • Upload when finished

Week 15 - April 21 - 25, 2008

Monday, April 21

• Lesson 9 - White Pages
• Upload 9-13 to Studocs when finished
• Make sure that your name is within the filename!

Tuesday, April 22

• Lesson 9 Exercises
• 9-18
• 9-19
• 9-20
• Turn into Studocs when finished.
• Make sure that your name is within the filenames of all of these!

Wednesday, April 23

• Unit 3 Applications
  • UA 3-1
  • UA 3-2
  • UA 3-3
  • UA 3-4
  • Please upload all to studocs when finished - make sure that your name is on it!

Thursday, April 24

• Lesson 10
  • White Pages - please upload
    • 10-5
    • 10-7
    • 10-8
  • Exercises - please upload
    • 10-13
    • 10-14
    • 10-15

Friday, April 25

• Lesson 11
  • White Pages - please upload
    • 11-3
    • 11-7
    • 11-12
  • Exercises
    • 11-17
    • 11-18
    • 11-19
• Extra Credit - students may work on the activities if they are finished with Lesson 11
  • http://richtech.ca/resources/comp/mspaint/

Week 14 - April 14 - 18, 2008

Thursday, April 17

• Lesson 8
• 8-15
• 8-16
• 8-17
• 8-18

Friday, April 18

• 8-20
• 8-21

Week 11 - March 31 - April 4, 2008

During this week the students will finish all of their Access assignments.

Final Access Test - next week.

Extra Credit:

Unit Application 4-2 - Print Step 19 - page 479

Unit Application 4-4 - Print

Week 10 - March 17 - 21, 2008

Monday, March 17 and Tuesday, March 18

• Lesson 11 - Working with Subreports
  • Complete White Pages
    • Print RptMainInvoice when finished (after Exercise 11-14)
  • Complete the following Exercises (the exercises go together, print at the end)
    • Ex. 11-23
    • Ex. 11-24
    • Ex. 11-25
    • Ex. 11-26
  • For Extra Credit, you may do Exercises 11-18 thru 11-22 for up to 20 points Extra Credit

Wednesday, March 19 and Thursday, March 20

• Lesson 12 - Integrating Access with Other Data
  • Complete White Pages
  • Complete the following Exercises and print
    • Ex. 12-16 - page 469
    • Ex. 12-23 - page 476

Week 9 - March 10 - 14, 2008

Monday and Tuesday (Wednesday, no class)

• Finish Unit 3 Lessons

Thursday, March 13

• Lesson 10 - Working with Report Wizards and Labels - refer to White Pages with questions
  • Ex. 10-19 - print page 1
  • Ex. 10-20 - print
  • Ex. 10-21 - print page 1
  • Ex. 10-22 - print
  • Ex. 10-23 - print page 1
  • Ex. 10-24 - print
  • Ex. 10-25 - print page 1
  • Ex. 10-27 - print - do this one for Extra Credit - up to 10 points!
  • Staple all Lesson 10 exercises together and turn in.

Friday, March 14

• Finish Lesson 10 Exercises

Week 8 - March 3 - 7, 2008

Monday, March 3

• 9-17
• 9-18
• 9-19
• Print as instructed (9-17 and 9-19)

Tuesday, March 4

• 9-20
• 9-21
• 9-22

Wednesday, March 5 and Friday, March 7

• Unit Applications 3-1
• 3-2
• 3-3
• 3-4
• 3-5

Week 7 - February 25 - 29, 2008

Monday, February 25

• Finish working on Lesson 7 Exercises

Tuesday, February 26

• Lesson 8
  • 8-18
  • 8-19
  • 8-20
  • 8-21

Wednesday, February 27

• Continue with Lesson 8
  • 8-22 - print relationship
  • 8-23 - print Auto Report
  • 8-24
  • 8-25
  • 8-26 - print

Thursday, February 28

Finish working on Lesson 8

Friday, February 29

• 9-15
• 9-16
• Print as directed and turn in.

Week 6 - February 18 - 22, 2008

Monday, February 18

• Redo work - Lesson 6 and Unit Application 2

Tuesday, February 19 - Thursday, February 21

• Unit 1 Exam

Thursday, February 22

• Ex. 7-20 - page 283
• Ex. 7-21

Friday, February 23

• Ex. 7-22 - page 285 - print report
• Ex. 7-23 - page 285 - write answers on back of 7-22 report
• Ex. 7-25 - page 288 - print report when done.
• Ex. 7-26 - page 288 - print report when done.
• Ex. 7-27 - page 289 - print report when done.

Week 5 - February 11 - 15, 2008

Monday, February 11 to Wednesday, February 13

• Purple Pages - Unit 2 Applications
• 2-1, 2-2, 2-3, 2-4
• Print -
  • 6-27 - Current Inventory
  • 6-28 - Stuffed Animals - Page 1 only
  • 6-29 - Inventory Value - Page 1 only
  • Unit Application 2-2 - Form - Record 4 only
  • Unit Application 2-3 - Sales Campaign
  • Unit Application 2-4 - page 1 only

Thursday, February 14

• Reviewed printed homework - students redid assignments as needed.

Friday, February 15

• Review for Unit 2 Exam - to be taken on Monday.

Week 4 - February 4 - 8, 2008

Monday, February 4

• Finish Lesson 5 and turn in to Handin folder.

Tuesday, February 5

• White page, Lesson 6

Wednesday, February 6 - Friday, February 8

• White Pages, Lesson 6
• Exercises 6-27, 6-28, 6-29

Week 3 - January 28 - February 1, 2008

Monday, January 28

• Oscars - finish and print

Tuesday, January 29 and Wednesday, January 30

• Lesson 5 - Adding Forms to a Database
  • White Pages
  • Copy the first form in frmAnimals[your initials] to Word and upload to Studocs - save as YourNameFrmAnimals
  • Copy the first form in frmTimeCards[your initials] to Word and upload to Studocs - save as YourNameFrmTimeCards
  • Copy the first form in frmJobCodes[your initials] to Word and upload to Studocs - save as YourNameFrmJobCodes

Thursday, January 31 and Friday, February 1

• Less 5 Exercises
  • 5-25 - copy the form that it asks you to print and copy to Word - Save as YourNameEx5_25 - upload to Studocs
  • 5-26 - complete
  • 5-27 - copy the form that it asks you to print and copy to Word - Save as YourNameEx5_27 - upload to Studocs
  • 5-28 -

Week 2 - January 21 - 25, 2008

Monday, January 21

• NO SCHOOL - MLK, Jr. Day

Tuesday, January 22

• Unit 1 Review - Complete and turn in

Wednesday, January 23

• Lesson 4 - White Pages

Thursday, January 24

• Finish White Pages, Lesson 4 and complete
  • 4-22 - turn in to Studocs
  • 4-23 - turn in to Studocs
  • 4-24 - complete
  • 4-25 - turn in to Studocs

Friday, January 25

• Oscars

Week 1 - January 14 - 18, 2008

Monday, January 14

• NO SCHOOL

Tuesday, January 15

• Welcome to Class
• Class Procedures
• Computer Use Guidelines - both due Wednesday, January 23

Wednesday, January 16

• Review Access

Thursday, January 17

• Review Access

Friday, January 18

• Assign Trays
• Assign Access Books
• Unit 1, Lessons 1 and 2