Microsoft Excel & Access

COURSE DESCRIPTION 

In this class students will learn to use Microsoft® Office Excel 2013® as an effective tool for organizing, analyzing and presenting data. Students will learn how to enter data; move, copy and edit cells; construct tables and charts; and create and apply basic mathematical functions to spreadsheet data. Upon successful completion of this course, students will be able to create and edit basic Microsoft® Office Excel® 2013 worksheets and workbooks.

The goal of this lesson is for students to successfully explore and describe the Access 2013 window.  The student will create a table, modify the design of the table, and add records to the table. The student will open a previously created table, modify the field properties, and learn to sort and filter records and import information from an external source. The student will create forms from tables and queries, use the forms for data entry, and modify the form layout. The student will create reports from tables and queries and modify the report layout. The student will create a query based on specific criteria, run the query, and create a query using comparison operators as well as calculated fields.

 

OBJECTIVES

This course will prepare students to use Microsoft Excel 2013 for:

  •          Creating worksheets and workbooks for managing and presenting data
  •          Analyzing data using simple and complex formulas
  •          Formatting worksheets and workbooks
  •          Using formatted worksheets and charts to visually represent data

This course will prepare students to use Microsoft Access 2013 for:

  •          Answer "What is a database?"
  •          Start Access and open an existing database
  •          Move around in Access
  •          Open and close an object
  •          View a table in Database view and Design view
  •          Navigate within a table using the mouse pointer
  •          Navigate within a table using the keyboard

 

Instruction will focus on handson activities as well as lecture, group discussion, use of technology, and other methods. Students will have the opportunity to work both individually and as part of a

small  group to complete assignments.

Projects will require students to use academic skills in language arts, math, social sciences, and science. Community resources will be accessed by inviting guest speakers, conducting panel 

discussions, and organizing field trips. 

 

Materials Needed Daily:

  1.       3-ring binder (at least 1 ½‘’)
  2.       Loose-leaf paper
  3.       5 Divider Tabs
  4.       Pencils & Pens

Extra Credit:
 

  1. Pack of printer paper     
  2. Box of Kleenex

Grading Policy:

  1.       Grades given for class work, class participation, project and notebook.
  2.       Vocabulary and other tests during semester based on score.
  3.       Quarterly tests given to enhance learning
  4.       Final exam counts 25% of course grade.
  5.       Weights for course work:                                                             
  6.       Classwork / Vocabulary /  Homework                       40%
  7.       Tests / Projects                                                      20%
  8.       Quarterly Tests                                                      20%
  9.       Notebook                                                               20%

 

Missed Assignments and Make-Up Policy:

Any work missed will need to be made up. It is the student’s responsibility to make up work within five days. This policy also applies for any missed tests. Time can be arranged before and after school upon permission from the teacher.

 

Notebook Checks:

There will be notebook checks on test day. It is vital to keep a good notebook as notebook checks are 20% of your grade in this class.   

Class Expectations:                                 

  1.         Practice being a good citizen everyday! There should be no horseplay in the         classroom, always be respectful of everyone around you, and keep your workarea and the classroom clean.
  2.         Always be prepared for class by being in your seat when the bell rings andhave your pencils and notebook ready.
  3.         NEVER share your computer password with anyone. You are responsible forkeeping your electronic files secure.
  4. Absolutely NO food, drinks, candy, etc. allowed in the classroom.
  5.    Other expectations as described by the teacher in the classroom setting.

 

 

INTERNET USE POLICY:

In accordance with county policy, the internet will be used for curricul purposes only.  Personal use of the Inernet is not permitted at any time in the business lab.  Students must abide by WCPS Policy 3225-Internet and the Educational Program or lose the privilege of using the Inernet in the lab.