WALKERTOWN HIGH SCHOOL
DEPARTMENT OF BUSINESS AND MARKETING
TEACHER:Mrs. Nadine M. BurgessROOM:500
PLANNING:2nd period (M-F) Appointment Only
E-Mail:
TELEPHONE:Work (336) /703-6754
Textbooks:1.Microsoft Office 2007– Thompson South-Western
- Microsoft Office Excel IT BE Publishing
Microsoft Excel and Access
Course Number: 6419
Description:
Students in Microsoft IT Academies benefit from world-class Microsoft curriculum and cutting edge software tools to tackle real-world challenges in the classroom environment. The first part of the class is designed to help you use the newest version of Microsoft Excel interface, commands, and features to present, analyze, and manipulate various types of data. Students will learn to manage workbooks as well as how to manage, manipulate, and format data. In the second part of the class, students will learn how to create and work with a database and its objects by using the new and improved features in newest version of Microsoft Access. Students will learn how to create, modify, and locate information as well as how to create programmable elements and share and distribute database information. Mathematics is reinforced. Work-based learning strategies appropriate for this course include cooperative education, internship, service learning, and job shadowing. Apprenticeship is not available for this course. Future Business Leaders of America (FBLA) competitive events, community service, and leadership activities provide the opportunity to apply essential standards and workplace readiness skills through authentic experiences. This course can help prepare students for the Microsoft Office Specialist (MOS) in Excel and/or Access,
Materials Needed:Each student will need to purchasea 3”Portfolio Binder – Clear Plastic display cover on front, and Storage Disk (Thumb Drive), Black or Blue Pens (NORED PENS)and pencils. Daily participation points will be assessed partially based on class preparation.
A portfolio will be required to successfully pass the class. Class projects will accumulate by objective to create the portfolio.
Grading Policy: 93=A 85-92=B 77-84=C 70-76=DBelow 69=F
25%Test, Quizzes, Exams
25%Vocats EOC Exam(Mandatory—No Senior Exemptions)
30%Portfolio
15%Lab Work, Class Participation—All other class work
5%Bell Ringers
COURSE OUTLINE ((exam and test dates are subject to change)
Unit Objectives / TESTDATE / REVIEW/QUIZ
A / MICROSOFT EXCEL
A quiz will be given after each objective
1.00 / Apply basic spreadsheet software skills using Microsoft Excel.
1.01 / Create, edit, and format worksheets (Course 10296). 1.02 Insert charts and graphics (Course 10296). / Bell Ringers
2.00 / Apply intermediate and advanced spreadsheet software skills using Microsoft Excel.
2.01 / Enhance workbooks (Course 10393).
2.02 / Work with data, tables, and charts (Course 10393).
2.03 / Use advanced features (Course 10393).
2.04 / Customize Excel applications (Course 10394).
2.05 / Work with external data (Course 10394).
2.06 / Automate workbooks (Course 10394).
UNIT A EXAM - TBD
B / MICROSOFT ACCESS / Bell Ringers
A quiz will be given after each objective
3.00 / Apply basic database software skills using Microsoft Access.
3.01 / Create and edit a database (Course 10382). 3.02 Create and use a query, report, and form (Course 10382).
4.00 / Apply intermediate and advanced database software skills using Microsoft Access.
4.01 / Modify a database (Course 10383).
4.02 / Create complex queries to extract and process specific information (Course 10383).
4.03 / Create programmed elements to automate tasks and add functionality to objects and controls (Course 10384).
4.04 / Share and distribute database information (Course 10384).
UNIT B PROJECT
POWERPOINT PRESENTATION ON ENTIRE COURSE / BEGIN
PROJECT DUE (NO PROJECT WILL BE ACCEPTED AFTER THIS DATE) / END
Class participation is the key to success in a Computer Technology class. It is necessary for everystudent to attend every class session on time. Upon entering the class, students must log-on to Mrs. Burgess website (via WSFCS Website) and complete the scheduled “Hook” or Bell Ringer(assignments). Students will have 20 minutes to complete an assignment and credit points will be given. If you are unable to attend a class session, it is your responsibility to find out your make-up work and turn it in on the next day of attendance. Work not made up within 3 days of returning to class will be counted as zero credit and will not be re-issued.
Tardies/PoliciesWill be announced at a later date
Technology Use
Every Student will sign an acceptable use policy before using the Internet. Students may use the Internet only under the supervision of the classroom instructor. Any misuse will result in a possible fine and denial of use of the technology.
Class Room Procedures
- BE ON TIME
- COME TO CLASS PREPARED, AND READY TO WORK
3. SIT AT YOUR ASSIGNED SEATS AT ALL TIMES
(IF ASSIGNED)
4. NO ELECTRONIC DEVICES OF ANY KIND BROUGHT IN THE CLASS ROOM
5. WHEN ENTERING CLASS, COMPLETE BELL RINGERS AS ASSIGNED
6. ACCESS AND LOG-IN TO WSFCS WEBSITE,
GO TO MRS. BURGESS WEBSITE, AND GET YOUR WEEKLY /DAILY ASSIGNMENTS. PRINT AND COMPLETE AS ASSIGNED
7. BRING PEN (BLACK OR BLUE ONLY) OR PENCIL TO CLASS DAILY
8. RAISE YOUR HAND AND WAIT TO BE RECONIZED
9. FOOD, DRINKS, CANDY, AND CHEWING GUM
WILL NOT BE TOLERATED IN THIS LAB.
10. PROFANITY WILL NOT BE TOLERATED
11. BE MINDFUL AND RESPECTFUL OF OTHERS