Advanced Computer and Technology Applications and Skills Standards Testing

1
Advanced Computer and Technology
ApplicationsandSkills Standards Testing

• Presenter
• Karen Nash, Professional Development Coordinator
• Office of Career Technical Education

2
Qualifications

• Experience
• Teacher at Scott County High School for over 20
  years
• Taught both Computer and Technology Applications
  and Advanced Computer and Technology Applications
• Administrative Support Taskforce from the
  beginning
• Desire to see students succeed
• I work one floor below Nancy Graham

3
OBJECTIVES

• Give you some insight as to what to teach in
  Advanced Computer and Technology Applications
• Give you some ideas on how to incorporate certain
  topics into the curriculum
• Help your students score well on the
  Administrative Support Skills Standards

4
CHANGES

• Electronic Office has been removed from
  curriculum
• Advanced Computer Technology Applications
  replaces Electronic Office
• Administrative Support Skills Standard is now
  given as a part of Advanced Computer Technology
  Applications however, the material covered on
  the assessment is the same as Electronic Office

5
Course Description This course is designed to
provide students an advanced-level experience
with practical applications through hands-on
instruction. Course content will include
understanding of various hardware, software,
operating systems, care/operations,
administrative applications, and employability
skills. The software includes advanced business
applications using word processing, presentation,
spreadsheets, database management, desktop
publishing, and electronic communication.
Leadership development will be provided through
FBLA. Upon completion of this course, a student
will be ready to take the core level tests for
MOS Certification and/or the Administrative
Support Skill Standards Certificate. Leadership
development will be provided through FBLA.
Suggested Prerequisite Computer and Technology
Applications
6
TEACHERS EXPECTATIONS

• Improve keying skills
• Learn (enhance) software applications
• Prepare quality documents
• Learn good Internet researching skills

7
STUDENTS EXPECTATIONS

• Play on the computer
• Surf the Internet
• Class with no homework
• Very little typing
• Easy credit

8
CURRICULUM

• Committee put together a notebook for Advanced
  Computer and Technology Applicationseach school
  should have one copy.

9
What to Teach?

• This course expands on Computer Technology
  Applications
• Word Processing
• PowerPoint
• Excel
• Access

10
Additional Topics

• Internet
• Microsoft Publisher (Desktop Publishing)
• Web Design
• Microsoft Outlook

11
WORD PROCESSING

• USE FBLA FORMAT GUIDE CONTINUOUSLY DURING THE
  ENTIRE UNIT!

FBLA FORMAT GUIDE
http//www.kyfbla.org/
12
WORD PROCESSING CONT.

• Examples
• Mail Mergeuse opportunity to teach (review)
  letter formatting, including two page letters
• Use formatting guide to show difference in typing
  from scratch and using memo templates (make sure
  they can type from scratch)
• Take timings periodically to work on keyboarding
  skills (always a good thing). Make a game out of
  itan excellent Friday activity

13
WORD PROCESSING CONT.

• Career, Employment, Job Skills Unit
• Resume
• Letter of Application
• Follow-up Letter
• Interview Techniques (create a brochure)
• Guidelines for Office Worker (reference manual)
• All of this can be done utilizing word
  processing and its features

14
EXCELLENT LEARNING TOOL

• Have students create a Career Portfolio
  Notebooksomething they can use after graduation
• Resume
• Letter of Application
• References
• Samples of quality work
• Evaluations (if a co-op student)
• Certificates/Awards (especially KOSSA)

Career Portfolio
15
EXCEL (SPREADSHEETS) Teach the concept first,
then perform it on the computer

• Example . . . Teach payroll, then create a
  payroll register in Excel using formulas
• Example . . . Teach check register/bank
  reconciliation, then create the forms in Excel
  using formulas
• Example . . . Teach invoicing (discounts), then
  create an invoice in Excel using formulas

16
POWERPOINT

• Teach concepts for the advanced level of Computer
  Technology Applications
• Divide class (either in pairs or alone) to
  prepare a presentation on an assigned topic.
• Use work-related topicsharassment,
  discrimination, work ethics, general office
  topics (telephone, organization, etc.)
• Accountabilityhave students take notes on
  presentations for other assignments/tests

www.careersolutionsgroup.com
17
ACCESS (DATABASE)

• Teach concepts of recordkeeping first (filing
  rules), then teach how to keep records using
  Access.
• Hold students accountable for knowing filing
  rules.

18
SKILLS STANDARDS

• Make sure you are familiar with the Kentucky
  Occupational Skills Standards. There is at least
  one question (usually three) for each standard.
• http//education.ky.gov/NR/rdonlyres/39F24EE2-0FB2
  -48E4-8432-96359BD89F79/0/2001AdminstrativeSupport
  Services.doc

19
WAYS TO PREPARE STUDENTS FOR KOSSA (see pages
36-37 of notebook)

• Have Reviews
• Room set up as stations with each station
  reviewing a document
• Use written tests given throughout the year to
  review for multiple choice
• Use KOSSA Rubric to score classroom
  papers--students should know what is on rubrics
  and be accustomed to being graded in that way.

20
WAYS TO PREPARE STUDENTS CONT.

• Motivate Your Students
• Explain what they can earn by doing well on the
  assessment.
• Good employment credential
• College credit at several universities
• Explain the Perkins funding and point out
  equipment, software, etc., that has been bought
  for your department.

21
WAYS TO PREPARE STUDENTS CONT.

• When all else fails . . .
• Bribe them.
• Class party (before and/or after).
• Bonus points.
• Final exam grade.

22

• IF YOU ARE EXCITED, THEN YOUR STUDENTS WILL TRY
  HARDER. If you act like this is an
  inconvenience, then your students will feel that
  way and will not perform well.

23
TESTING TIPS

• You (as the teacher) should give the assessment
  to your students.
• Use Perkins money to get a substitute for ½ day.
• Make sure your students know the correct
  terminology for each program (fields, records,
  reports, query, etc.).
• Work with students on proofreading (one of the
  most missed questions).

24
TESTING TIPS CONT.

• ONLY test those students who are currently taking
  Advanced Computer Technology Applications
• Volunteer to grade the assessments in March

25
What it all boils down to

• KOSSA isnt going away.
• You are doing your students an injustice if you
  dont work to make them successful at this
  assessment.
• You are doing yourself and your school an
  injustice if you dont help to make your students
  successful (tied to Perkins funds).

26
QUESTIONS?
27
CONTACT INFORMATION

• Karen Nash
• Office of Career Technical Education
• 500 Mero Street
• 20th Floor, Capital Plaza Tower
• Frankfort, KY 40601
• 502-564-5551
• karen.nash_at_ky.gov