1 / 15

MSITA Excel / Access Boot Camp

MSITA Excel / Access Boot Camp. Marty Roettgen. Agenda. How do you measure Student Success Get Certified Set Expectations Student Control of Learning An Idea of How to Grade Fewer Assignments Certification Motivation Getting Students Certified Lab Questions.

neith
Download Presentation

MSITA Excel / Access Boot Camp

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MSITA Excel / Access Boot Camp Marty Roettgen

  2. Agenda • How do you measure Student Success • Get Certified • Set Expectations • Student Control of Learning • An Idea of How to Grade Fewer Assignments • Certification Motivation • Getting Students Certified • Lab • Questions

  3. How Do You Measure Student Success? • Final Exam Scores • % of Students that Certify • Enrollment increasing • Students learning how to learn • Self-motivated Students “A classroom where students chase learning and not just grades.”

  4. Get Certified • Teacher’s need to get certified • You need the experience so you can help your students to succeed in certifying • Hang your certification on the wall for students to see • Try to earn a perfect score and display score report • Re-test each year • You MUST believe students are capable

  5. Set Expectations – Day 1 • 90% productive • Responsible for themselves, tablemates, row mates and rest of the class • Set a high but achievable goal for the number of students that will pass the certification • Have a celebration when they achieve the goal • Students pick what to have at the celebration and plan it • Let students know that they will work at their own pace, but a minimum pace is required

  6. Set Expectations – Day 2 On • Don’t be quick to answer their questions • Let students answer each others questions • Pace much faster when many people answer questions • Once you have a feel for capability – put the best students next to those that are struggling. • Let the best student know that if by helping, they can’t get an assignment done to let you know. Tell them they will earn a 100 if needed • If student gets ahead and wants to try to certify – let them • The earlier someone certifies – the quicker the spark is lit

  7. Set Expectations – Day 2 On • If student finishes Lesson early have them go to the next • They review the PowerPoints, do the Step-by-Step and projects on their own. • Minimum Pace: • Everyone takes the lesson test at the same time • Everyone listens to the lecture at the beginning of next lesson

  8. Students in Control • Everything is in Blackboard by Day • Minimum Pace including day of Lesson test in Blackboard • Students progress at their own pace from Blackboard • They decide when they want to certify • Minimum pace dictates when everyone has to take test and move to next lesson • If they get ahead and want to learn another application on their own and certify, they can.

  9. Grade Fewer Assignments • For each Lesson • Test from the test bank • Skills test with focus on key skills and certification skills • This forces accountability for learning • 3 to 4 assignments that teach the skills for the lesson • Give a completion grade for Assignments • If Skill Test is less than an 85 (you pick the score) • Assignments are grade otherwise a 100 • Skill Test grades can only be improved by score on the certification test

  10. Certification Motivation • Celebration for Reaching the Certification Goal • Warn students early that they do not want to be the student that keeps the class from a celebration • Count kept on the board • Celebrate each successful certification attempt • Print their certifications same day if possible • Certification is only way to improve Skills test grades

  11. Getting Students Certified • Print the Skills Tested list with space for notes • Have students check off skills they know • Have them study what they don’t know • Have students do practice tests • After test, print score report • Write on Skills Tested list questions they did not know using score report to help on the areas to focus on • Pair students who passed with those who didn’t to review prior to retesting

  12. Where Students ChaseLearning and not Grades • I give no credit for earning “extra” certifications, but at least a third of my students do. • About 20% will earn Master level certifications and most have not taken Word / PPT. • For those really motivated – get them trying to become a US semi-finalist. • 2012: US Champion / 3rd in the World Excel • 2013: 4 US Semi-Finalists, US Champion / 3rd in the World Excel • 2014: US Champion in Excel (Worlds end of month)

  13. Lab • Describe New Certification Test and retake policy • Review Skill Checklist • Prep for Excel 2013 Certification Test • Discuss Access 2013 Certification Test

  14. Questions ? ? ? Marty Roettgen mroettgen@wcpss.net

More Related