Course Name: MSITA (Excel/Access)

MSITA SYLLABUS

Number of Credits: Elective course

Instructor Name andContact Information

Name: Mrs. Cynthia Bradshaw

Office Location: Room 118

Office Hours: 2nd block planning (10:10-11:42)or afterschool

Telephone: 336-570-6100

Email:

Classroom Meeting Times and Location: 1st, 3rd, and 4th blocks room 118

Text and Software

Text: Microsoft Office 2010 by Pasewark and Pasewark

Software: Microsoft Office 2010/ E-Learning

Course Description

In this class students will learn to use Microsoft® Office Excel 2010® 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® 2010 worksheets and workbooks.

The goal of this lesson is for students to successfully explore and describe the Access 2010 window. The student will spend time navigating through an Access Database.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.

Course Goals

This course will prepare students to use Microsoft Excel 2010 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 2010 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

Project Files

(Note to the Instructor: Each IT Academy Lesson Plan Project folder includes a student assignment document, data files needed to complete projects and an instructor answer key. Data files can be posted on the class web site for easy student access.)

Course Policies

Grading (ABSS has a 7 point grading scale)

Sample: % Grade GradeTest= 25%

100-93 AQuiz= 15%

92-85 BParticipation=60%

84-77 C

76-70 D

69 and below F

Attendance: Students are expected to attend school daily and on time in order to be successful. Tardies are not acceptable (after 2nd tardy=lunch detention, 4th=lunch detention & parent phone call, 5th=administrative referral)

Assignment Due Dates

Students will need to follow the guidelines as indicated in the student handbook for making up work with excused absences. It is the sole responsibility of the student to make up any missed assignments, tests, or quizzes. Your grades will be uploaded at least twice a week.

Lab Work

Students are required to complete his/her assignment during class time. Students are to be respectful of ABSS equipment and tools at all time. Any abuse will be reported immediately to the administrators. No food or drink in lab.

Learning Center

My Learning Center Day is on Mondays from 3:20-4:30pm. This is an opportunity to makeup work such as: quizzes, tests, and missed assignments. Additionally, this is chance to get assistance if you are struggling.

Supply List

Each student will need a 2 inch binder/notebook, wide-ruled notebook paper, writing supplies (pens, pencils, markers), at least 2.0 GB USB/flash drive and most of all, a positive attitude towards learning.

Hand sanitizer and Kleenex appreciated!

MS Certification

Students will have the opportunity to take certification tests for Excel and Access. This course is designed to prepare and aid the students in achieving Microsoft Certification. The certification exam is a timed 50 minute computerized test performed independently using the skills learned in this classroom. The minimal qualifying score is 700. Many students have been successful and you can be too!

Classroom Mannerism

Students will demonstrate respect to the teacher and it will be reciprocated. Students will also show respect to other students, faculty, and staff at all times. Otherwise, you will be referred to administration that will result in disciplinary action. Classroom rules are posted. Teacher dismisses the class; not the bell.

Adapted CTE Course Blueprint of Essential Standards

6419 Microsoft Excel and Access

(Recommended hours of instruction: 135-180)

This blueprint is aligned to the Objective Domains for Microsoft Excel and Access 2010 Certification Exams.

Essential Std # / Units, Essential Standards, and Indicators
(The Learner will be able to:) / Course
Weight / Approx. Number of Days / Dates to Cover
1 / 2 / 3
Total Course Weight / 100%
MICROSOFT EXCEL / 50%
1.00 / Understand basic, intermediate and advanced spreadsheet software skills using Microsoft Excel. / 50% / 47 / Jan 22- March 31
1.01Understand how to manage the worksheet environment in Excel.
1.02Understand how to create cell data in Excel.
1.03Understand how to format cells and worksheets in Excel.
1.04Understand how to manage worksheets and workbooks in Excel.
1.05Understand formulas and functions in Excel.
1.06Understand how to present data visually in Excel.
1.07Understand how to share worksheet data with other users in Excel.
1.08Understand how to analyze and organize data in Excel.
MICROSOFT ACCESS / 50%
2.00 / Understand basic database software skills using Microsoft Access. / 50% / 32 / April 1-May 23
2.01Understand how to manage the Access environment.
2.02Understand how to build tables in Access.
2.03Understand how to build forms in Access.
2.04Understand how to create and manage queries in Access.
2.05Understand how to design reports in Access.
Projects, E-Learning, and Certification Testing / TBA
Final Exam Review / May 27- 30
EXAM / June 2- 6

*Adapted CTE Course Blueprint based on Microsoft IT Academy objectives.