Computer II

2012-2013 School Year
Full Year Course
Grades 9-12 Recommended
I Computer Science credit or 1 Elective credit
Tuesday

Course Tutor:
Larry Wilson
larry_a_wilson@yahoo.com


Course Description:

This is a one-year hands-on computer class.  It is geared toward the high school student who has basic computer skills.  All lessons in class are hands-on.  The intent of this class is to expand on the skills learned in Computer I and introduce the students to basic programming concepts.  Students will be expected to take notes and practice at home with the concepts learned each week.

 

The majority of the class grade will be based on performance on tests and in-class projects, although class attitude and weekly performance will also be taken into consideration..  It is expected that each student have at home, or at least have access to, a computer with Windows XP or above and Microsoft Office 2007 (including Access 2007).  In our class, we will be using Windows XP and Microsoft Office 2007.  Because of significant differences in the user interface between Office 2007 and previous versions, it is required that the student be able to practice on Office 2007 outside of class.

Topics to be covered in the course:

  • Review of basic Windows and Microsoft Office concepts.
  • Create footnotes, endnotes, tables of contents, and indexes in Word
  • Creation of styles and templates in Word
  • Use pivot tables and range names in Excel
  • Advanced charting concepts in Excel
  • Link and import data and charts into PowerPoint from Excel
  • Creation of macros
  • Basic programming concepts in Visual Basic for Applications (VBA)
  • Basic database concepts in Access (tables, queries, forms, and reports)


Course Prerequisites: Student must have passed Computer I (or have equivalent experience with the consent of the tutor).


Course Fees: $30.00 lab fee (billed by Teenworks office)


Copy Fee: No copy fee as all course materials will be sent home on a USB flash drive


Required Texts: None