1 / 24

Creating 2008-2009 IBEDS Assignment Forms

Creating 2008-2009 IBEDS Assignment Forms. SDE no-longer prints the Assignment sheets to be completed by your certificated staff ~ we now Provide you with an Excel file You can print the forms via a macro The file name ends with ‘‘…Assignment.xls”

donna-cotton
Télécharger la présentation

Creating 2008-2009 IBEDS Assignment Forms

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. Creating 2008-2009 IBEDS Assignment Forms SDE no-longer prints the Assignment sheets to be completed by your certificated staff ~ we now • Provide you with an Excel file • You can print the forms via a macro • The file name ends with ‘‘…Assignment.xls” • Example – Boise School District 001’s file is “001 Assignment.xls”

  2. Opening the Excel File What to do if this happens.. • When you open the “xxx Assignment.xls file – “Enable” the macros

  3. “Form” The “print” template Select this “tab” to start the macro to populate employee demographics Data Contains all certificated positions reported on your 2007-2008 IBEDS Data can be added, changed, deleted – see further instructions. ~ Good idea, always have a good backup before you make changes. Workbook has two (2) worksheets

  4. Worksheet named “FORM”

  5. Printing Assignment Forms • “Ctrl” + n – prints SSNs on forms • “Ctrl” + w – prints without any SSNs • (small n or small w)

  6. Printing Assignment FormsCaution~~ • Once you “trigger” the macro, ALL forms should print out • Soooo – be sure you’re ready before you start the macro

  7. If you’ve had a lot of changes since last year, you may want to update the data before you print Worksheet Named “DATA” 2008 -2009

  8. Data Changes to consider • Name changes • Building changes • Adding new employees • Removing terminated employees(otherwise forms will print)

  9. Data Changes to consider • Name changes • Building changes • Adding new employees • Removing terminated employees(otherwise forms will print)

  10. Data Changes to consider • Name changes • Employees now working in another building • Adding new employees • Removing terminated employees(otherwise forms will print)

  11. Data Changes to consider • Name changes • Building changes • New Employees – 2008-2009 • Removing terminated employees(otherwise forms will print)

  12. Data Changes to consider • Name changes • Building changes • Adding new employees • Employees no longer employed ~ terminated(otherwise forms will print)

  13. Data Changes to consider • Name changes • Building changes • Adding new employees • Removing terminated employees(otherwise forms will print) • Remember to sort in the order you want the forms to print. • Consult your district/charter IT department for technical assistance before contacting us (Myrna or LaRae at 332-6845) • ~ sorry folks, we would love to help but we’re a small support staff ~ but call if you cannot resolve any issues internally.

  14. What to do if….

  15. Go to ToolsMacroSecurity

  16. Change Security Level to “Medium”

  17. Close the excel file

  18. Open the excel file again

  19. Select “Enable Macros”

  20. Macro’s should now work

  21. When Completing the Assignment Forms ~~ Remind your staff • If it looks like a duck • Walks like a duck • Quacks like a duck • It’d better be called a duck

More Related