Home

User Manual. - North Star Negotiations

1. Save These Array Schools Load Array School Group ky e Save These Array Schools This button allows for saving the currently displayed list of Array Schools This is recommended for Array School Groups that are frequently used as it provides a quicker mechanism for switching between Array School Groups as well as the ability to perform comparisons against all the Groups at once o Clicking this button displays the Save Selected Array Schools form described below e Load Array School Group o This button will only be displayed if an Array School Group has been saved If not the button will be hidden o The button is itself separated into two parts Click the left part pad suey sched Coup to open the Selected Array Schools form described below Load Previously Click the right part 7 to open a menu with a list of all the previously saved Array School Groups This is a quicker method of switching between Array School Groups than using the Load Previously Selected Array Schools form When a Group name in this list is clicked or a value is selected via the Load Previously Selected Array Schools form the Array Schools in the Group will be loaded into the actual Array School List on this page described below 35 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 36 The Actual List School
2. 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Array School Selection Criteria Array School Selection Criteria Upper Limit 2 00 Ane Area Schools Lower Limit 0 50 113 Proximity Enrollment 226 Page 34 3 e 35 iJ D e This section displays quick information about the Subject School on the left and allows for quick inclusion of Array Schools on the right e First on the left we see the Enrollment limits and the Enrollment values they represent o These values are hard coded with an Upper Limit of 2 or 200 enrollment and a Lower Limit of 0 5 or 50 enrollment and may not be changed o Inthis example Deshler s enrollment is 226 so 200 of that is 452 while 50 of that is 113 o The Negotiations Module will look for Array Schools that have an enrollment between these two values e On the right we have two values that can be user edited These values will help select Array Schools o Area Schools By default the Area Schools drop down will be set to 9 Included in this number is the Subject School while the other 8 are the Array Schools To quickly increase or decrease the number of Array Schools simply select a new value in the drop down and hit the Magnifying glass button E below these values to refresh the page The Proximity value will be automatically updated with this change The CIR recommends 7
3. 5 161 494 az 9 124 354 Adj Total Costs o el 6 768 624 Era iait Gir 6 224 728 6 205 348 a IE 6 109 789 Page 46 Percentile 102 40 102 033 100 18 100 05 Es EERE 19 213 31 09 Wew Cash Option Analysis e This section displays the current year cost information for the Array Schools Array School names have been hidden in this example as some of the data has been changed for testing e Excluded districts appear at the bottom of the table None of the excluded district s values are used in the calculation A been excledod from thls Array School Comparison e The Adjusted Costs Adj Benefit Costs Adj Schedule Costs and Adj Total Costs have been adjusted for the difference in contract days between the Subject School and the Array Schools In the example above the costs are adjusted down because the Array Schools all have more contract days than the Subject School e The table is sorted by Adj Total Costs with the highest values appearing on top e The median row s for the Adj Total Costs is are italicized e The Staff Index Benefit Costs and Schedule Costs come from the placement of the Subject School s staff against the Array School s Contract Settlement Form information including the Salary Schedule e The Percentile column compares the district to the calculated Midpoint e Clicking the Array School District s Name which is the first column though it h
4. North Star Negotiations User Manual Last Updated 4 30 2015 Version 1 6 Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 1 Overview Salaries are a school district s number one expenditure every year NETS s North Star Negotiations Software provides districts the tools needed to succeed at the bargaining table stay competitive and achieve win win negotiations Utilizing the latest technology NETS North Star Negotiations Software will help your district ESU gain strategic advantages in all stages of the negotiation process by providing real time calculations comparing districts in your arrays Automatically compare data from similar sized districts and ESUs across the state to improve your success at the bargaining table even the playing field and know you are paying your employees fairly Table of Contents o Renee ete ener ere ee een ere eo eee ere en ne ee e 1 TIPS NG WME rico odiado octetos 3 a o A 4 GENET al SILC MtoOFMATION ssnin N N SR 6 Outdated Browser Detected iii cosccdcencatscvsssancnsienenhegeransasdvnesshesabsadcausasinn Decidir 6 o O o nn A 7 Pare POD ina tdo 7 LOS a E E E E E E 8 C Us FOT S ene eee g SE E Par A EE EA E VAN EE E E E A E E A A A E 10 A e 10 o Sr ATIVE ISON osa A E atenerse OE odas rinden soci open a rosca peste 10 USC Wines Teacher Role into ais 11 Users without North Star PerMissions
5. 45 Changing the EHA Rates 2014 2015 EHA Rates T e This section will only be displayed when the new EHA rates have been announced e By default the current year s EHA rates will be used in all of the calculations To use the new EHA rates choose the next fiscal year in the drop down which will also display the percentage a s Ml 5 y change before clicking the Force Recalculation button Changed Data Rows Changed Data Rows Y Add Changed Data Row ld Contract Staff Base Benefit Schedule Total Percentile Days Index Salary Costs Costs Costs Changed Data Row 182 BO AO MEA RO teed Da mg Nothing changed 100 00 mo Added Life and Vision Changed Data Row 182 135 1627 32 287 1053 205 5 087 551 6 141 056 100 00 insurance e Rows in this section are displayed when Changed Data Rows are added via the Add Changed Data Row page described below Otherwise this table will be empty e A significant number of Changed Data Rows may impact the overall performance of the program Otherwise feel free to add as many as you want e The rows inthis section are ordered by Total Costs with the lowest being on top e Costs can be influenced by rounding So even in rows where nothing was changed the calculated costs may be off by a small amount e The Description is displayed on the far right If no Description is provided a default value will be displayed in its place Descriptions make it easy to tell rows apart
6. Y and Z are all disabled Last Hame Experience Family Life FTE H A Category First Name Hire Year PR Married Spouse on Staff Children 18 EATON KRISTOFER 2007 2008 O 1 Cash Yes Yes E D se First Prev Next gt Last gt F On Page 30 Change 18 to 18 out of YD total Staf Members B E D EJFE 6 HIS KLAN OP QRETUYVY WX Y 2 Total FTE 62 9041 o Clicking the Change button will switch back to the standard view otherwise the On Page value is ignored when you are viewing Staff Members by their Last Names Edit Staff Member s Information e The page and functionality is the same as the Add New Staff Member page described above except for the following differences o The Educational History section This section is populated with the entries provided for this Staff Member Educational History Add new educational information ky e 2011 2012 Master s 10 Additional Hours e 2008 2009 Bachelor s No Additional Hours Remove educational information ky Click Add new educational information to provide additional Educational Information for this Staff Member described below Click Remove educational information to delete an existing Educational History entry for this Staff Member described below o A Delete button is included at the bottom of the page The process of removing an existing Staff Member is described below wD Delete 29 Page Copyrigh
7. page described in detail below as well as all the pages that link off of it e The Perform Array School Comparison with ALL Groups button will only be displayed if there is a Saved Array School Group o Clicking it will perform the Negotiations computations for all the Saved Array School Groups and compare them against each other This will take several minutes more than a standard comparison please be patient o This page process is described below 37 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 38 Array School Selection By Map Array 5chool Selection Criteria Upper Limit 200 452 Area Schools g z Q Lower Limit 0 50 113 Proximity 38 Enrollment 226 p F paa PAPA ag 2 D Fairmont i Blaine Greene Tragifing y Clay Center site Wilber Holstein F Campbell Beatrice J Fairbury Wifrore NLT rT Red Gloud Guide Rock 2 Chester 10 miles 20 km pp aero un 2043 Nokia amp 2014 Microsoft Grp oration View Larger Map Back to Array School Select e This page is accessed by using the View as Map link on the Array School List page e Ifyou are on an older browser or computer for performance reasons we recommend you do not open this page e This page shows a Bing map of the Subject School 0 a large blue dot with a Black outline Array Schools le a large blue dot
8. 18 y Eruning Davenport Unified System 85 2001 2 Thayer 160 0 71 13 Deshler Public Schools 45 0060 3 Thayer 226 1 00 O Thayer Central Community Schools 85 0070 3 Thayer 425 1 88 8 Superior Public Schools 65 0011 3 Nuckolle 427 1 89 20 D McCool Junction Public Schools 93 0083 2 fork 249 1 10 28 Sutton Public Schools 18 0002 3 Clay ate 1 67 34 This array includes schools and has a total geography of 38 miles View as Map lt lt Back to Year Select Perform Array School Comparison gt gt Perform Array School Comparison with ALL Groups Ly Header NASB TEST MEMBER SCHOOL DISTRICT 00 0000 2015 2016 Array 5chool Selection 4 30 2015 Print e The header will include your school name and District Number NASB s test school district is used as an example here e The header will also include the year for which you are negotiating This is NOT the year that was selected in the drop down instead it is the next fiscal year as we use one year s data to negotiate for the next year e The current page which for this example is Array School Selection is also displayed This value will change as we navigate between the different pages of the Negotiations Module e The current date is also displayed in this example it is 4 30 2015 Print a e Clicking the Print button will print the current page while also cleaning it up a bit e On some pages to the right of the Print button date is an Export button OO 33 Page Copyright
9. 24 1 28 1 32 1 32 1 36 1 40 1 24 1 28 1 32 1 36 1 36 1 40 1 44 1 28 1 32 1 36 1 40 1 40 1 44 1 48 1 32 1 36 1 40 1 44 1 44 1 48 1 52 1 36 1 40 1 44 1 48 1 48 1 52 1 56 1 44 1 48 1 52 1 52 1 56 1 60 O oGbaee 1 52 1 56 1 56 1 60 1 64 ses as a 1 60 1 60 1 64 1 68 seais a as fl eee le is 1 68 ae e ee mes eme ses es 1 76 The Salary Schedule Indices table is built off information provided in the CSF Longevity is also displayed in this table o Cells that correspond to Longevity are highlighted in blue and a note is added to the page 17 1 20 1 30 1 49 1 76 1 76 1 94 2 12 18 19 20 1 20 1 30 1 49 1 76 1 76 1 94 2 12 21 1 2375 1 3375 1 5275 1 7975 1 7975 1 9775 2 1575 Cells with Longevity are specially marked Rows that contain the same information are combined In the example above 18 19 and 20 are combined because they have the same Index values 17 is not combined because its last cell is not Longevity but just a regular cell while 21 is also not combined with the others because its Index values are different 51 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Salary Schedule Amounts 1 31 500 2 Je 760 3 34 020 4 35 280 E 36 540 34 800 7 39 060 5 40 320 ap see 40 ja j e B00 ii o 32 760 34 020 35 280 36 540 37 500 32 060 40 320 41 580 42 540 BA 18 24 020 35 280 36
10. 4572 Copyright 2013 2014 Nebraska Education Technology Services Inc All Rights Reserved Have a question 4sk WETS Or view the User Manual e The footer contains basic information about the site e Atthe bottom the Ask NETS Link opens the Contact Us Form described below e The User Manual link opens this document 7 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 8 Log On Account Information User name Password Remember me Log On e This page displays when o you click the Log On link in the header described above o youtryto access any of the sections that require a user including the Reports Module the Negotiated Agreements the Staff Information or the Negotiations Module e Log On by inputting the same User name and Password used to log into the NASB website This is also the Username and Password you would use with our Contract Settlement Form website e Check the box next to Remember me if this is a private unshared computer and you want to bypass this login page when you return to the website A cookie will be saved with your browser so when you return we will automatically log you back in 8 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 9 Contact Us Form Cont
11. 540 37 500 32 060 40 320 41 580 42 540 44 100 45 560 BA 27 35 280 36 540 37 500 32 060 40 320 41 580 42 540 44 100 45 560 46 620 47 880 36 540 37 500 32 060 40 320 41 580 42 540 44 100 45 560 46 620 47 860 42 140 30 400 36 540 37 500 32 060 40 320 41 580 42 540 44 100 45 560 46 620 47 860 42 140 30 400 37 500 32 060 40 320 41 580 42 540 44 100 45 360 46 620 47 880 42 140 30 400 91 560 12 220 39 060 40 320 41 580 42 540 44 100 45 560 46 620 47 860 42 140 30 400 91 560 52 220 34 160 99 440 Page 52 e The Salary Schedule Amounts table is built off information provided in the CSF including the Base Salary e Like with the Indices table Longevity cells are highlighted in blue and rows that contain the same data are combined l 17 18 19 21 Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved 0 32 000 32 000 32 000 40 219 42 250 42 250 42 250 453 469 de 425 de 425 de 425 42 641 9 200 9 200 oe 200 356 19 9 200 9 200 9 200 36 19 63 050 63 050 63 050 64 269 66 750 66 200 66 700 70 119 52 Page North Star Negotiations User Manual Page 53 Salary Schedule Staff Placement MA MA 9 e The Salary Schedule Amounts table is built off information provided in the CSF e This table shows how many teachers are at each place on the Salary Sc
12. 7 Page Header Ef N T gt North Star Negotiations welcome Billy Forester Log Off Reports Contracts Staff Information Negotiate Settings e The top header of every page contains these links o On the top left the NETS logo is a link rarely used that will open a new window tab to the NETS homepage http www nebtechservices com o On the top right the North Star Negotiations text is also a link which will direct the current page to the North Star Negotiations homepage the page that displays by default not displayed here o The Log On link appears directly below the North Star Negotiations link It will take you to the Log On page described below After you have logged in this section will change to display your name as well as a Log Off link L Log ff 1 that does what its name implies e As well as this menu too o The Reports link redirects the page to the Reports Module explained below The Contracts link redirects to the Negotiated Agreement page explained below o The Staff Information link redirects to the Staff List page explained below o The Negotiate link redirects the page to the Negotiations Module explained below o The Settings link on the right redirects to the Settings page explained below Page Footer Nebraska Education Technology Services Inc 1311 Stockwell Street Lincoln ME 665502 402 817 0120 800 422
13. 8 Records Schedule Percentile Da ys Index Salary Costs Costs Costs Costs Costs Costs Array Average 185 63 ESTER sel NE cheval tay baaa AMEN Fe ale ae 6 248 706 100 11 Array High 190 144 3028 33 085 1 103 192 5 585 258 6 627 310 1 103 192 5 350 089 6 391 561 102 40 Array Low 185 BESA laa a a ra AN A 6 109 789 oy Bo Adj Total Costs Mean 6 248 706 Median 6 234 708 Midpomt 6 241 707 e The Array Average row contains the average of all values in the Array School Comparison Information section described above e The Array High row is the largest values in the Array School Comparison Information section e The Array Low row is the smallest values in the Array School Comparison Information section e Adj Total Costs o Mean the value of the Adj Total Costs from the Array Average row o Median the Adj Total Costs for the Median school district s the Median district s is are italicized in the Array School Comparison Information section o Midpoint the average of the Mean and Median Adj Total Costs this value is also set as the Total Costs value for the Comparable Benchmark e One of the following Back to buttons will display o This will take you back to the Array School Selection page described above when that is where you came from lt lt Back to Array School Select o This will take you back to the Group Midpoint Analysis page described above when that is where you came
14. 9 Array Schools o Proximity This value represents the distance in miles to the furthest of the Array Schools By default since we have 8 Array Schools it matches the furthest of these 8 To widen or narrow the search simply provide a new value in the textbox and hit the magnifying glass button a below these values to refresh the page The Array Schools drop down will be automatically updated with this change 34 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 35 Array School List B Save These Array Schools Load Array School Group hi y School District Class County Size Ratio Miles Exeter Milligan Public Schools 30 0001 3 Fillmore 195 0 86 38 Meridian Public Schools 48 0303 3 Jefferson 14 0 73 24 e Shiektey Publie Sehaats 310 0054 3 Fiimore 43 05 4 Eruning Davenport Unified System 85 2001 2 Thayer 160 0 71 13 Deshler Public Schools 285 0060 3 Thayer 226 1 00 Thayer Central Community Schools 85 0070 3 Thayer 425 1 88 8 superior Public schools 65 0011 3 Muckols 427 1 89 20 McCool Junction Public Schools 93 0083 Ea York 249 1 10 28 Sutton Public Schools 18 0002 3 Clay ae ved 34 This array includes 7 schools and has a total geography of 38 miles View as Map lt lt Back to Year Select Perform Array School Comparison gt gt Perform Array School Comparison with ALL Groups s The Top Row of Buttons
15. Click the Description to be taken to the Projections page for this Changed Data Row e Click the Delete button at the left of the Description with the trashcan icon to permanently delete that Changed Data Row A Changed Data Row will display until it is deleted e Clicking the Add Changed Data Row button in the header of this section displays the Add Changed Data Row page described below 45 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Array School Comparison Information Array School Comparison Information Y School District Contract Da ys 120 185 185 1583 Ti 185 185 185 staff Index 143 6387 144 3028 137 3846 735 0909 TIRTA 136 9360 138 6303 138 0663 Base Salary 33 085 31 875 Se 32 200 pal 32 600 seman 32 100 Benefit Costs 1 042 052 1 050 782 1 003 402 1103 102 ARS 1 044 053 e 285 651 Schedule Costs A dea 200 5 405 870 EEEN 3 226 244 aa E TEMES 9 208 822 Total Costs Ball 6 456 652 b 12 a 6 329 23 F 6317 432 6 240 627 Bella 6 194 472 Adj Benefit Costs 1 041 471 1 050 417 tr s 7 703 192 patel ee 1 043 854 1 038 941 965 435 Adj Schedule Costs Se ei 5 9 18 208 W243 2 5 747 494 5 245 197
16. Max Miles Included Excluded Missing Total Costs Base Salary Choose your Preferred Target Calculation Percentile 100 amp Defaults E 0 0 32 6 053 540 31 298 2015 2016 Teacher Choice 11 0 0 36 6 073 471 31 423 Array School Group Comparison For more information please select the Array School Group below before proceeding Additional information includes the Midpoint Analysis page showing the calculations displayed here as well as the School Information Worksheet the Benefit Summary page Staff Summary page and the Suffictently Similar Cash Option Analysis Array School Group Defaults 6 053 540 29 View Array School Comparison Details gt gt lt lt Back to Array School Select e After clicking the Perform Array School Comparison with ALL Groups button then waiting several minutes this page is displayed e The schools displayed on the Array School Selection page described above are ignored for this page unless the displayed schools are themselves an Array School Group o Only districts in a Previously Saved Array School Group are displayed o Inthe example above we had two Groups saved and those are the two rows displayed e The Array School Groups are sorted by Total Costs with the lowest values on top The process for calculating these Total Costs is described below e Toview the Midpoint Analysis for a Group select it in the drop down then click View Array School Comparison Details The M
17. This button allows for saving the currently displayed list of Array Schools o This is recommended for Array School Groups that are frequently used as it provides a quicker mechanism for switching between Array School Groups both on this page and even better on the Reports page 14 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 15 e The Load Array School Group button a a located above the Array Schools list o Will only display if there are previously saved Array School Groups see the note above o Is split into two buttons The folder half of this button located on the left e Displays the Load Previously Selected Array Schools pop up form described below e Allows you to Load or Print the previously saved Array School Groups The arrow half of this button located on the right e Opens a menu with a list of all the previously saved Array School Groups e Isa quicker method of switching between Array School Groups than using the Load Previously Selected Array Schools form o Regardless of how they are loaded the districts loaded via these buttons are moved into the Array Schools list on this page Any other districts in the Array Schools list are removed and placed back in the Available Districts list e The Reset Selected Array Schools button at the bottom l
18. Total Compensation 68 877 506 Costs FTE Total Compensation 34 426 75 Costs Contract Day 4d Salary Costs 4477 044 49 4d FICA 340 691 02 Adj Retirement 433 905 5 Adj Other Insurance A ital ll dj Total Benefits as 4dj Total Compensation 6 281 790 02 Adj Total le Compensation FIE 49 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 50 Other Insurance OTHER INSURANCE CATEGORY SRATE RATE LIFE 1 85 0 00000 VISION 20 0 00000 LTO 0 00 0 00420 TOTALPrR 52 60 0 00490 e This section is only displayed for districts that have Other Insurance e Other Insurance is a combination of Long Term Disability Vision and Life Insurances e The rates for the items that combine into Other Insurance are displayed here if they have a value If none of the items are involved then the whole section will be hidden if only one of the items is displayed like in the example below then it will be the only item displayed OTHER INSURANCE CATEGORY SRATE RATE LTO 0 00 0 00340 TOTALPrR 0 00 0 00340 50 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 51 Salary Schedule Indices BA 9 BA 18 BA 27 BA 36 MA 9 MA 18 1 08 1 12 1 16 1 20 1 20 1 24 1 28 1 12 1 16 1 20 1 24 1 24 1 28 1 32 1 16 1 20 1 24 1 28 1 28 1 32 1 36 1 20 1
19. a user click the Remove Permission button next to the user s name a with the trashcan icon o When a Permission is removed it is saved automatically 11 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 12 Users without North Star Permissions Users without North Star Permissions These are the users without any permissions in the North Star program k Aike Riley Mike Thoompson naruto uzumaki North Star Testing New Users cannot be added wa this program this program can only add Morth Star permissions to existing users To add a new user go to the main MASB website http fun nasbontine ores After logging in select My Membership if you are not already on this pagel then Edit Contact Information then Add New You wall only be able to add new users if you have the requisite permissions If you have any questions about this process email METS The same username and password that works with North Star wall work on the main NASB website lf wou add a user wa the NASB website you wall need to click the following button to refresh the page and the list of users Refresh Users e Active users without any permissions in North Star appear in this list e New users cannot be added via this program NASB permissions dictate who can create new users not everyone with access to North Star To add new users
20. adjusts these array school costs for potentially differing contract days between the Subject School and the Array Schools The costs of Array Schools that have more days than the Subject School are adjusted down while costs of Array Schools with fewer days than the Subject School are adjusted up if the days are the same then nothing is adjusted These are the Adj or Adjusted values on the Midpoint Analysis page 4 The program then calculates the Mean and Median of the all the Adj Total Costs values for the Array Schools These two values can be found at the bottom of the Midpoint Analysis page below the Descriptive Statistics section In the Array School Comparison Information section the Median school s is are also italicized if you have an even number of Array Schools then you will have 2 Median schools if not there will be just 1 4 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 5 5 Then the program averages the Mean and Median values and labels this the Midpoint which can also be found at the bottom of the Midpoint Analysis page in the Descriptive Statistics section The Midpoint is the Total Costs value of the Comparable Benchmark If a Percentile other than 100 is selected as described below then the Total Costs of the Comparable Benchmark is adjusted up or down accordingly 6 From the calculated Total Costs N
21. ccccccccccssssssseeccccccsaeeseeccccceesuaeueeeccceeesauaesseceeeeeesauaaeeeeeeess 12 REDONS MOU PP cates esate e A O A 13 Advanced Array School Selection csccscsssresssssrecconssscucnssscnecsssestoussectouesscneussscnsousrestensssencussseneousrense 13 ROOMS V eW ETIE idad 16 C ntracts Negotiated Agreements aid dde R EAEAN Ei 18 Nesotiatioas Module srs T T 19 A A 19 import Sial No ma ON ia 19 llPage Copyright O 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Ada New Starr Members dana QUICK EQUCA TON UPA AS ln estoi O N Edit Staff Member s Information occcnccccnccnnnccnnnnnnnnnnnnannnnnnnnnnnonnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnaninnnnss Delete Stat Member s tormes Negotiations Process ia Ad Negotiations Contract Settlement Form SectiON ccooccccnnccnonocnnonacnnonacinonanononacnnnccnonarinonaso FSGS Al o elec ON Array SCHOO SCIECHION id Group Midpoint Analisis Midpoint AIVAIVSIS ves soccer toed dutch cette aes ads SCHOOL MMTORMALION Worksheets r A AN Benefit SUMMA ios CaSO DEON A Mal V SIS oran raid PO CCUG NS aii eae tae anaueid tana ra nepaptanen ne eos Stat SUMMA Ade Changea Data ROW sata ote as Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved 2 Page North Star Negotiations User Manual Page 3 Tips and Tricks e When you are viewing a Negotiations page report its name will be displayed
22. e This is the form that displays when the Save These Array Schools button on the Array School Selection page is clicked or when Save This Group of Array Schools on the Midpoint Analysis page is clicked e The name of the Array School Group is required o This Group Name is for internal use only though it may be visible on some of your school s pages which may in turn be printed out o Group Names must be unique per school district This means each district could have a Group named District s Array but each district may only have one Group with this name For example if Deshler already has a Group named District s Array and tries to save another Group with this same name the first Group will be replaced with the second however Superior s or any other district s Group with the Same name would be unaffected e Below the Group Name is a list of the Array Schools that are included in the Group o Note that Deshler as the Subject School is not in this list o Also note that Shickley is not included in this list as it was Excluded in the example above You may have a scrollbar on this form The order of the districts in the list is not important 40 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 41 Load Previously Selected Array Schools Load Previously Selected Array Schools x Load or Delete one of
23. in the top left e The most used Negotiations pages are o Midpoint Analysis the main page you land on after performing a Negotiation o Projections the page that shows the Current Costs on top and the change in total costs with varying Base Salaries o Staff Summary where you can verify the costs of each staff member including the Staff Index as determined by the program which you will want to verify e You can hover your mouse over most fields or headers in the Negotiations program to see additional details This could include an explanation of the field or how a value was calculated e Share the effort when compiling all the Educational History of your staff Send out a survey or excel spreadsheet asking your staff to provide that information for you It is in their best interests to do so The sample import file may provide a good base for this e lfthe program recommends an increase to the Base Salary you could instead change the amount of benefits offered Health Insurance Tuition Reimbursement Health Deductible Reimbursement etc An increase in Base Salary will also increase the amount of FICA and Retirement whereas most benefit increases will not incur this additional cost The Add Changed Data Row page will help you will this process e To include a district outside of the 50 200 enrollment range used by the Negotiations module you can use the Advanced Array School Selection page for the Reports then Save an A
24. of Monthly Dollar Amount a second drop down will appear that allows you to specify what the rate applies to just Salary or Salary and Benefits Long Term Disability Rate Rate is for Salary Only 15 00 o The Rate and Amount fields are the same the far right textbox o Enter Rates as a Decimal so 0 5 would be entered as 0 005 74 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 75 Reimburse Deductibles Reimburse Deductibles yearly amounts Q9 Employee E 0 00 Ee amp Child ren EC 0 00 Ee amp Spouse ES 0 00 Fe Spouse E Child ren ECS 0 00 e The full amount of the deductible will be considered regardless of how much is actually reimbursed since the district would have to budget for the full amount Cash In Lieu Cash In Lieu monthly amounts g Employee El 160 00 Ee amp Child ren EC 170 00 Ee amp Spouse ES 160 00 Ee Spouse amp Child ren ECS 190 00 e This section will add or adjust Cash In Lieu for your district e No staff members will be automatically switched to Cash In Lieu If your district does not currently offer CIL you may need to move Staff Members to the CIL Health Care Plan to take advantage of this change Do this via the Staff Summary Adjustments page per Array School if you do not want the change to be permanent You may also do this via the Edit Staff Mem
25. opened in programs such as Microsoft Excel e lf you arrive at this page via a Changed Data Row or the Comparable Benchmark row then that row will also be displayed in italics where it belongs amongst the Projection Rows The Comparable Benchmark will not affect the rest of the costs but the Changed Data Row will Comparable Benchmark Chenged Dota Row Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved Tae 132 em a 135 1627 ee 32 28 1 058 024 1 053 203 5 707 437 5 087 057 6 747 056 6 747 056 75 026 1 24 75 026 1 24 60 Page North Star Negotiations User Manual Page 61 Staff Summary Get to this page by clicking the Schedule Costs value for the appropriate district as found on the Midpoint Analysis page Last Name Experience Placement Retire H A H A Additional Other Education FTE FICA c c Benefi First Name DIS ADJ PR CR COL STEP INDEX ment Category Cost Benefits ins Albert Masters 10 5 0 D 5 MA9 6 1 4000 0 4 0 5600 17 640 1 349 1 742 E C 0 0 0 20 732 Brandon Baldwin Bachelors 0 2 8 10 10 BA 11 1 4000 0 8 1 1200 35 280 2 699 3 485 E 4 922 0 0 46 386 Jonathan Berry 3 En Doctorates 0 3 0 D 3 M4 18 4 1 3600 0 4 0 5440 17 136 1 311 1 693 ESIC 0 0 0 20 140 ric Bowe Masters 10 6 0 D 6 MAS 7 1 4400 0 8 1 1520 36 288 2 776 3 584 ES 10 086 0 0 52 735 Dwayne Dorsey Gl Doctorates O 9 2 10 11 M 18 12 1 6800 0 4 0 6720 21 168 1 619 2 09
26. page described below 25 Page Copyright O 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Staff List 1 Hali Tamba 15 Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved Last Hame First Hame Albert Brandon Baldwin Jonathan Bowe Dwayne Dorsey Glenn Fisher Enc Jackson Tyson Johnson Derrick Johnson Larry Words Sylvester Poe Dontan Sims Ryan Tait John Tynes Lawrence Experience Hire Year PR 2008 2009 2011 2012 2010 2011 2007 2008 2004 2005 2013 2014 2006 200 2009 2070 2005 2006 2003 2004 2000 2001 2012 2073 2002 2003 1299 2000 2001 2002 described below described above 0 FTE H A Category Cash Cash Total FTE 9 06 Married Spouse on 5taff Children Ho Basic Staff Information is displayed in the list Family Life Mo Page 26 Click the name of a Staff Member to go to the Edit Staff Member s Information page Click the Remove button with the trashcan icon to be directed to the Delete Staff Member s Information page described below This is the page that displays by default when you click Staff Information in the page header 26 Page North Star Negotiations User Manual Page 27 Staff List Search e Atthetop of the Staff List page is a text
27. return the value to the calculated Base Salary A slider appears below the Base Salary textbox to help select a Base Salary between 98 and 102 of the calculated value Whenever this textbox is displayed regardless of its value the Base Salary will NOT be Automatically calculated Clicking the Automatically calculate a Base Salary link will tell the program to automatically calculate a new Base Salary hiding the textbox and ignoring whatever value is in it Please note that the manually set Base Salary will be saved Changes in the calculated Comparable Benchmark Base Salary the CSF and or Staff Information will NOT have an effect on this value even if you use the 98 or 102 buttons f there are changes and you do want to recalculate the total costs with a new base salary then you will have to add a new Changed Data Row via this page 71 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 72 Part Time Benefits Part Time Benefits Benefits for Part Time Employees FTE y Beginning Level for Benefits 0 50 k e FTE Full Time Equivalent means partial benefits will be paid starting at the level provided for example a 3 4 time employee would get 75 of benefits e FTU Full Time Unit means full benefits will be paid starting at the level provided for example a 3 4 time employee would get 100 of benefits e For either o
28. select the user s name in the drop down and click the Add This Permission button o When a Permission is added it is saved automatically e To remove North Star Administrative permissions from a user click the Remove Permission button next to the user s name s With the trashcan icon o When a Permission is removed it is saved automatically 10 Page Copyright O 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 11 Users with the Teacher Role Users with the Teacher Role These are the users with TEACHER access to the North Star program w Katie Perry mu WT p Jimmy John W Donald Duck El Mike Thoompson T Add This Permission Teachers to Selected User Ly e Users in this list have Teacher permissions in North Star e Users may only have one role either Teacher or Administrator e Users with Teacher permissions can ONLY view Staff Information o They cannot edit delete or add Staff Information they can only view it o They cannot run any Reports o They cannot perform any Negotiations o They cannot view any Contracts o These users also cannot edit the permissions of other users e To add North Star Teacher permissions to a user select the user s name in the drop down and click the Add This Permission button o When a Permission is added it is saved automatically e To remove North Star Teacher permissions from
29. with a Green outline and all other Potential Array Schools a small blue dot with a Red outline o The Subject School and all Array Schools will be visible on the map but most of the Potential Array Schools will not be displayed as the map is zoomed in on the other districts o Only Array Schools that match the Enrollment criteria between 50 and 200 of the Subject School s enrollment will be displayed on the map 38 Page Copyright O 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 39 e Clicking on any school will display additional information about it like the following Eruning Davenpon Unified System This district is an array school Enrollment 143 Ratio 0 74 Wiles 13 County Thayer e Use the Bing map controls to zoom in and out on the map or to pan the map around the state an a 00 al e Surrounding the Array Schools is a green circle o As the proximity changes this circle will expand or contract o Above the map and below this text is a slider that will allow you to quickly change the Proximity which will automatically update the map o Using the slider control is similar to using a scrollbar simply click the white square and drag it left to decrease the proximity or to the right to increase the proximity or you can click the bar to the left or right of the box to quickly change the proximity value e Ab
30. 1 ECIC 0 0 0 24 878 enn Fisher En Bachelors 0 0 10 10 10 B 11 1 4000 O8 1 1200 35 280 2 699 3 485 EC 8 913 0 0 50 377 ric Hali Tak Doctorates O 7 0 D 7 M r 18 8 1 5200 0 4 0 6080 19 152 1 465 1 892 ESCIC 0 0 0 22 509 amba Jackson 8 T Masters OF 4 6 10 10 M 11 1 5600 0 8 1 2480 39 312 3 007 3 883 ESC 13 466 0 0 59 668 yson Johnson 9 Masters OF 8 2 10 10 AA 11 1 5600 0 2 0 3120 9 828 752 971 E C 0 0 0 11 551 Derrick Johnson 10 L Masters 10 10 0 0 10 MA9 9 1 5200 0 4 0 6080 19 152 1 465 1 892 E C 0 0 0 22 509 arry Morris 11 Masters 10 13 0 D 13 M 9 1 5200 0 6 0 9120 28 728 2 198 2 838 EC 3 691 0 0 37 455 Sylvester Poe 12 r me Bachelors O 1 9 10 10 BA 11 1 4000 0 8 1 1200 35 280 2 699 3 485 E C 4 922 0 0 46 386 ontari Sims 13 sa Doctorates O 11 0 O 11 M 18 10 1 6000 0 51 0 8160 25 704 1 966 2 539 E C 3 138 0 0 33 347 yan Tait 14 ch Doctorates 0 14 0 D 14 MA 18 10 1 6000 0 75 1 2000 37 800 2 892 3 734 E C 4 614 0 0 49 040 ohn Tynes 15 Doctorates 0 12 0 D 12 M 18 10 1 6000 1 1 6000 50 400 3 856 4 978 EC 6 152 0 0 65 386 Lawrence TOTALS 9 06 13 59 428 148 32 753 42 292 59 905 0 0 563 098 AVERAGES 0 9061 28 543 37 540 lt lt Back to Midpoint Analysis Need to make an Adjustment t e Detailed staff placement information is displayed here e The Staff Members come from the Subject School but the other information is calculated from the Array School s values in the CSF e Use the Export button B S in t
31. 200 32 300 32 400 32 300 32 600 32 00 32 500 1 079 624 1 042 543 1 042 543 1 042 542 1 042 543 1 042 542 1 042 543 1 042 542 1 042 542 1 042 543 1 042 543 5 026 406 3 024 874 9 040 452 9 056 645 ll 3 088 415 3 104 501 9 120 186 Sea 5 191 257 9 167 042 Contract Days Staff Index Base Salary Benefit Costs Schedule Costs Total Costs 6 066 030 6 044 423 6 070 303 6 106 194 6 122 073 6 137 709 6 153 850 6 167 136 6 185 621 6 201 506 a 5 increase Increase 58 393 54 270 40 164 56 050 71 935 587 820 103 706 119 594 135 476 151 362 0 14 0 40 0 66 0 92 1 19 1 45 1 71 1 97 2 23 2 50 e The Current Costs row from the Midpoint Analysis described above is always the first row e Below the Current Costs are the Projection rows All of the values are impacted by the Specifications described above as well as the Current Costs o If you arrive at this page via a Changed Data Row then those changes will also be reflected in the Projection rows e The S Increase is the difference between the Total Costs of the Projection Row and the Current Costs displayed as a dollar amount e The Increase is the difference between the Projection Row and the Comparable Benchmark displayed as a percent of the Current Costs s Total Costs e Use the Export button ae in the header to download this information as a CSV file that can be
32. 4 180 sr CI ae le Dl te le mm 55 440 Close 67 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 68 e Each change only affects the Staff Member whose name was clicked e Immediately after making an adjustment there will be messages displayed on the Staff Summary page stating the program needs to Recalculate with the new values This allows a user to make adjustments to multiple Staff Members without recalculating in between each change The change made is not yet reflected in the values Recalculate before these changes will take effect Last Name Experience Placement Staff Retire H A H A Additional Oth So Education FTE if Salary FICA SS i pe er Tota First Name DIS ADJ PR CR COL STEP INDEX Index ment Category Cost Benefits Ins Cost Albert 1 y Masters 10 5 0 5 MA 6 7 4000 0 4 0 5600 17 640 1 349 1 742 E C 0 0 0 20 732 Brandon Recaiculate before these changes will take effect e To Recalculate a new Recalculate button is displayed at the bottom of the page press this button or the Back to Midpoint Analysis button or refresh the page via the browser to force the program to recalculate all necessary calculated values Recalculate ka e After Recalculating the adjusted row on the Staff Summary page is highlighted with a light red background like it was when we needed to recalculate but now t
33. 445 AE 3 896 E EC 6 720 0 0 53 593 19 o Masters O 0 1 DO 1 AKA 2 1 2250 1 1 2250 42 097 9 903 4 158 C ESC 87 360 0 0 143 519 20 on Masters 1 0 1 0 1 M 2 1 2250 1 1 2250 42 097 3 735 4 158 Se 6 720 0 0 56 710 TOTALS for all pages 40 83 55 10 1 866 987 200 693 184 417 756 448 0 0 3 008 545 AVERAGES for all pages 1 2244 41 489 66 857 lt lt First Prev Next Last gt gt On Page 10 Change 11 to 20 out of 45 total Staff Members e fthe Staff List is large enough paging will be implemented and is conducted with a new row at the bottom of the Staff Summary page e The First link will take you to the first page of the Staff Summary In the example above the First page is the Previous page so hitting either link will take you to the First page in the list displaying Staff Members 1 10 e The Prev link will take you to the previous page of the Staff Summary In the example above the First page is the Previous page so hitting either link will take you to the First page in the list displaying Staff Members 1 10 e The Next link will take you to the next page of the Staff Summary In the example above the Next page would display Staff Members 21 30 62 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 63 e The Last link will take you to the last page of the Staff Summary In the example above t
34. 99 2000 O0 0 75 Cash Ho Ho O D e The Search is case insensitive so jo or JO would have found the same results as the example above 27 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 28 Staff List Paging se First lt Prev Next gt Last gt Un Page 30 Change 31 to 40 out of 45 total Staff Members e If the staff list has enough members paging will be implemented and is conducted with a new row at the bottom of the Staff List page An example of this row is shown above e The First link will take you to the first page of the Staff List In the example above the First page would display Staff Members 1 10 e The Prev link will take you to the previous page of the Staff List In the example above the Previous page would display Staff Members 21 30 e The Next link will take you to the next page of the Staff List In the example above the Next and Last pages are the same displaying Staff Members 41 45 e The Last link will take you to the last page of the Staff List In the example above the Next and Last pages are the same displaying Staff Members 41 45 e These links will be deactivated as necessary for example if the last page is displayed then the Next and Last links will be disabled se First Prev Next gt Last gt gt Un Page 30 Change 41 to 45 out of 45 tot
35. B Projects de ootstrap de NASE de browser detection de test results Je images de nasbdew dropbox di Scripts de log data live site de log data devservi Je themes Gb EducationImport csw lb EducationImport_ERRORS_TEST csv Libraries Documents ray EducationImport GOOD TEST csv a Music a Sike css E Pictures see Site Print css B videos i Site Screen css ray StaFFImport csy JE Computer Eb Staffimport_ERRORS TEST csv Ta Local Disk 125 en lL staffimport_GO0D_TEST csy E Network 3 ViewReport css Date modified 8 13 2013 3 47 PM 6 17 2014 10 43 4M 2 25 2014 7 54 AM 6 13 2014 8 57 AM 5 30 2013 1 30 PM 6 12 2014 4 32 PM 6 12 2014 4 39 PM 6 12 2014 4 43 PM 6 13 2014 10 54 AM 3 20 2014 10 48 4M 2 27 2014 1 38 PM 6 11 2014 2 33 PM 6 12 2014 4 39 PM 6 12 2014 11 48 AM 10 15 2013 8 41 4M File Folder File Folder File Folder File Folder File Folder Microsoft Excel Com Microsoft Excel Com Microsoft Excel Com Cascading Style Sh Cascading Style Sh Cascading Style 5h Microsoft Excel Com Microsoft Excel Com Microsoft Excel Com Cascading Style Sh 1 KB 1 KB KB 19 KB 1 EB 1 KB 1 KB 3 KB 3 KB 1 KE File name 7 E Files cel _ 21 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 22 e Imports can be performed even after Staff Info
36. C In certain circumstances the employee will qualify for a different health plan than they selected If so the health plan the staff member selected is listed with the health plan the staff member qualified for in parentheses like so E ES If a category does not have any information then it will not be included in this table See the example below where most rows are excluded H A BENEFIT 750 Deductible INFORMATION CIL Option 4 FTU Basis Eligible at 1 Category Cost Mo Cost Year FTE FTU Category Cost of Total Costs EIC 539 26 6 471 12 1 00 1 00 6 41 12 100 00 SUM 1 00 1 00 6 471 12 100 Cash In Lieu categories are also included in this table where applicable If Cash In Lieu is provided then the category name will include the non cash category that the Staff Members qualified for in parenthesis like the EC and ES in the example below CIEC 250 00 3 000 00 0 40 1 00 1 200 00 AE CIES 250 00 3 000 00 0 40 1 00 1 200 00 FOR 54 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 55 Benefit Summary Get to this page by clicking the Benefit Costs value from the Midpoint Analysis page The row you click will dictate who s information you see the Subject School including Current Costs Comparable Benchmark or a Changed Data Row or an Array School You may also get to this page from the School Informa
37. District Class County Size Ratio Miles Exeter Milligan Public Schools 30 0001 E Fillmore 195 0 86 38 Meridian Public Schools 48 0303 3 Jefferson 164 O73 24 Fi theke Hubheehonts 30 0054 gt o a E Ea Bruning Davenport Unified System 85 2001 2 Thayer 160 0 71 13 Deshler Public Schools 65 0060 Thayer 226 1 00 Thayer Central Community Schools 85 000 3 Thayer 425 1 88 8 Superior Public Schools 65 0011 3 Nuckolls 427 1 89 20 McCool Junction Public Schools 93 0083 E York 249 4140 28 Sutton Public Schools 18 0002 3 Clay 378 167 34 This array includes 7 schools and has a total geography of 38 miles View as Map e The Array Schools are displayed in this list along with the Subject School which is highlighted in blue with bolded text e The following District Information is included in this table School Name the NDE Number the Class the County the District resides in the Enrollment Size the Percent of the Subject School s Enrollment and the Distance this Array School is from the Subject School e Array Schools that have a smaller enrollment are displayed above the Subject School sorted by geographical distance from the Subject School e Array Schools that have a larger enrollment are displayed below the Subject School also sorted by geographical distance from the Subject School e Before each of the Array School names is a checkbox selecting this checkbox will Exclude the Array School from the Negotiations meaning its values wil
38. Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 21 e When you have an import file prepared click the appropriate button to upload the file o Uploaded files are NOT saved by NASB NETS the files are opened read and their data is saved into the Negotiations Module then the files are discarded The files will still be available on your computer they are not deleted until unless you delete them o The button text and appearance of the File Uploaded is dependent on the browser being used Below are some examples Browse Choose File No file chosen Browse o After clicking this button the Open File Dialog pictured below will appear Use it to browse your local files choose the file to import then click Open Only select one file at a time even if you are importing both Staff Members and their Educational History o Be sure you are importing the correct file the Staff Member file is first then the Educational History o Donotimport the same Staff Member multiple times as this will result in multiple entries in the Negotiations Module which will negatively impact the calculations o The file is not actually imported uploaded until the Perform Import button is clicked Source NorthSkarWegotiations NorthStarNegotiations Content Organize New Folder Recent Places al Lo NASB Websites bootst de NAS
39. Next gt gt e lf there are previously saved Array School Groups then this page will be skipped o Inthis case the first page of the Reports process will be the actual Reports Viewing Page described below o You will be able to come back to this page from the Reports Viewing Page e The Array Schools that will be included in the Report appear in the list on the right under the Array Schools heading e The list of districts available to be included in the Array Schools list appears on the left under the Available Districts heading o These schools will not be included in the Report until they are moved into the Array Schools list 13 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 14 e To move a district from the Available Districts list to the Array Schools list so the district will be included in the Report o First select the district in the Available Districts list o Second click the Add button located in between the two lists o The district is removed from the Available Districts and added to the bottom of the Array Schools list o This district will be included in the Reports until it is removed from the Array Schools list e To eliminate a district from the Array Schools list so the district will no longer be included in the Report o First select the dis
40. act Us Form Your Full Hame Your Email Address Subject North Star Negotiations Question Design HTML Preview Submit Email e This form is displayed when clicking the Have a question Ask NETS link in the footer section of every page e lf you have a question comment etc please fill out this form and submit it to NETS e This form will email everyone associated with the North Star program You will receive a response from the first person that can answer your question 9 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 10 Settings Page e Use the Settings link in the page header to access this page e Changes made via this page are saved automatically Permissions Administrative Users Administrative Users These are the users with ADMIN access to the North Star program the highest level of access s Billy Forester James Marthy W Mike Thoompson T Add This Permission Administrators to Selected User k Users in this list have Administrative permissions in North Star not necessarily elsewhere e Administrative Users have full access to the North Star Negotiations program o This includes editing Staff Information running Reports and performing Negotiations o Administrative Users may also edit the permissions of other users e To add North Star Administrative permissions to a user
41. al Staff Members e fyou want to display more than 10 Staff Members per page change the On Page drop down to the appropriate value then click the Change button The options are All 10 25 and 50 s First lt Prev Mext gt Last gt gt Un Page All Y Change 1 to 45 out of 45 total Staff Members e The text to the right of this section will let you know the Staff Members that are being displayed as well as the total number This will update as you move between pages 1 to 10 out of 45 total Staff Members 28 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 29 e lfthere are even more Staff Members an additional line of alphabetic links will display beneath the standard paging row o This row allows the Staff List page to be filtered by the first letter of the Last Name o Inthe example below E has been selected so only Staff Members with a last name starting with E are displayed and in this case it s only Kristofer Eaton Clicking the Next link will display the F names while the Prev link will display the C names since D has been disabled because there are no Staff Members with a Last Name starting with D likewise the First link will take you to the A names while Last will take you to the W names which is the Last letter that is available since X
42. ame for the Current Costs link though it will display Current information not Calculated e Clicking the Benefit Costs value will direct the user to the Benefit Summary page described below for the Subject School The Comparable Benchmark row will contain Calculated values whereas the Current Costs row will display Current information e Clicking the Schedule Costs value will direct the user to the Staff Summary page described below for the Subject School The Comparable Benchmark row will contain Calculated values whereas the Current Costs row will display Current information Changing the Percentile 100 A e The Percentile is a reflection of where a district or Changed Data Row stands compared to the calculated Midpoint value o If it matches it will be 100 o When the Total Costs are below the Midpoint the Percentile will be below 100 for example 98 o When the Total Costs are greater than the Midpoint the Percentile will be above 100 for example 102 e To change the Percentile for the Comparable Benchmark row select the desired Percentile value in the drop down before clicking Force Recalculation 2 o The new value will be saved as the default for future calculations o The default Percentile can also be set via the Settings page 44 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page
43. as been hidden above will direct the user to the School Information Worksheet page described below for the selected Array school e Clicking the Array School District s Benefit Costs value will direct the user to the Benefit Summary page described below for the Array school e Clicking the Array School District s Schedule Costs value will direct the user to the Staff Summary page described below for the Array school e Clicking the View Cash Option Analysis link at the bottom right of the table will display the Cash Option Analysis page for this Negotiation described below Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved 46 Page North Star Negotiations User Manual Page 47 e When a manual change is made to any Staff Members calculated information explained below the district is highlighted in light red on this page INE 185 13 6240 31 500 59 905 504 378 564 282 50 905 496 199 556 103 e fan Array School is missing required CSF information it will be displayed in this section with a blue background NASB is notified when this happens and we will attempt to get this information but for now the school is automatically removed from the calculations A not have Contract Settlement data Descriptive Statistics Descriptive Statistics Y Adj Contract Staff Base Benefit Schedule Total Adj Benefit Adj Total
44. asis Eligible at 0 5 Category Cost Mo Cost Year FTE FTU Category Cost of Total Costs E 540 07 6 480 84 0 80 1 00 5 184 607 8 213 E t 540 07 6 480 84 3 66 5 00 23 719 87 37 583 ES 978 52 11 742 20 0 80 1 00 9 393 76 14 88 ES 1 107 45 13 289 40 0 80 1 00 10 631 52 16 84 ESC 1 478 70 17 744 40 0 80 1 00 14 195 52 22 103 SUM 6 66 99 00 63 125 35 100 e This is the same table as that displayed on the School Information Worksheet page described above except o Cash In Lieu categories will not be included here as they have their own table see below o Empty categories will be included here In the example below some Staff Members qualify for the Employee Spouse plan but they are part time employees and they are not offered benefits the row is still displayed but the amount values are all zeroes ES 0 00 0 00 0 80 1 00 0 00 0 00 56 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 57 Cash Amounts Offered ANNUAL CASH AMOUNT OFFERED Cash Same to CIE 250 00 0 00 om 4 46 13 99 El Same to CIEC 250 00 0 00 at 0 40 1 25 a Same to CIES 250 00 0 00 al 0 40 1 25 a Same to CIESC 250 00 0 00 ai 0 40 1 25 3 Same to 16 980 00 0 00 All e ACash In Lieu option is calculated for each row though typically the values will all be the same e Like above even categories that do not contain any information are di
45. ber s Information page but a change there will last until it is changed back e Any staff members that are currently setup as opt out will get this new CIL benefit even if your district does not currently offer CIL 75 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 76 Additional Cash Amounts Additional Cash Amounts monthly amounts Ud Annuity Additional Amount 0 00 Other Additional Amount 0 00 Employee El 0 00 Ee amp Child ren EC 0 00 Ee amp Spouse ES 0 00 Ee Spouse amp Child ren ECS 0 00 e These values should not be mistaken for Cash In Lieu These values are separate from CIL and will be paid regardless of the Health Plan specified for the staff member e The Annuity Additional Amount and Other Additional Amount will be paid to every qualifying staff member e The rest of the amounts will be paid according to where qualified staff members are placed for health insurance 76 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 77 Additional Benefits Additional Benefits yearly amounts Hiring Bonus 0 00 J Tuition Reimbursement 0 00 Ww Employee Fringe Benefit Employer Contribution 0 00 Dependent Fringe Benefit Employer Contribution 0 00 e The Hiring Bonus is only paid to qualified
46. box followed by a button with a magnifying glass icon the textbox may or may not include the search placeholder text depending on your browser This is the searchbox search 5 e Enter text into the search box and the program will use it to match the First or Last names of Staff Members For this example Jo was provided o Which matched Johnson for both Derrick and Larry as well as Jonathan Baldwin and John Tait If the name you are looking for appears in the drop down you may click that name to be taken to the Edit Staff Member s Information page described below for that Staff Member If you are using an older browser this drop down may not display though you can still search see the following note ol p _ Baldwin Jonathan that Johnson Derrick Johnson Larry Tait John the Me o You may also click the magnifying glass button i or hit enter on the keyboard when you are in the searchbox to be taken to the search results page If the drop down does not display this is the only option for viewing Search Results The Search Results page appears and functions just like the Staff List page described above Last Name Experience Family Life FTE H A Category First Name Hire Year PR Married Spouse on Staff Children 1 Baldwin Jonathan 2011 2012 10 U8 E Mo Mo O D 2 Johnson Derrick 005 4006 10 U2 Cash Mo Mo O D 3 Johnson Larry 2003 2004 0 014 Cash Mo Mo O D 4 Tait Johna 19
47. d for the year the Staff Member is hired Additional entries can be added any time the Staff Member s Educational History changes when they get additional credit hours and or when they receive an advanced degree described below e This is the quickest method for adding one two or just a few Staff Members e The Import process explained above is an alternative method for adding Staff Members Adding Staff Members via this method is not required but Staff Information is required Quick Education Updates The Effective Year for all of these changes will be 2014 2015 s Last Name Educational Information First Hame Degree amp Additional Credit Hours 1 Albert Brandon Masters T 10 2 Baldwin Jonathan Bachelor s Y O E Berry Eric Doctorate s 0 a IAN vose s Mo JAN 5 Dorsey Glenn Doctorate s 0 Fisher Erie Bachelors Y 0 m 7 tat Tanta Doctorates 0 JE save 5 Jackson Tyson Master s T 0 9 Johnson Derrick Master s 7 O gt A Te a E F Nai z I 1 o gt 11 Morris Sylvester Masters Y 10 n 12 Poe Dontan Bachelor s 0 p E 5 ia m l f eed E 1 Tf a e 14 Tait John Doctorate s 0 E 15 Tynes Lawrence Doctorate s 0 2 Back to the List View e This page is accessed via the Quick Education Updates button on the Staff List page amp Quick Education Updates 24 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All R
48. ducation Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 6 General Site Information Outdated Browser Detected Pa l Outdated Browser Detected Our website has detected that you are using an outdated browser Using your current browser will prevent you from accessing features on our website An upgrade is not required but is strongly recommend to improve your browsing experience on our website Use the links below to download a new browser or upgrade your existing browser kh Apple Google Va Internet Opera Mozilla y f Safari Chrome Explorer Firefox Remind me later e fyou are accessing the site on an older browser you may see this section display over the regular page e Examples of older browsers are IE6 IE7 IE8 FireFox 3 5 Safari 4 etc o Ifyou are using one of these browsers or an older one you should strongly consider upgrading o Not only will this site run faster but other sites will too and you will be more protected against viruses and other online scams e f you see this message with a modern version of IE Microsoft s Internet Explorer please be sure you are not running in compatibility mode For more information on IE s compatibility mode please consult the sites returned by your preferred search engine 6 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page
49. e Contract Days report requires a Job Title which should be selected Job Title for Contract Days Please select a Job Title O Finally click the View Report button to display the Report on this page 16 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 17 e The Report displays below the Report Type Selection section Find Next b i ENROLLMENT 2014 2015 School Enrollment Eruning Davenport Unified System 160 Exeter Milligan Public Schools 195 McCool Junction Public Schools 249 Meridian Public Schools 164 shickley Public Schools 115 superior Public Schools AZ sutton Public Schools 370 Thayer Central Community Schools 425 Deshler Public Schools 226 6232014 11 07 AM Copyright 2014 Nebraska Education Technology Services Inc All Rights Reserved 1 of 1 e The Report section will grow or shrink onscreen as required by the Report after a few moments e Most Reports will use the selected Array Schools to display information Exceptions to this are noted onscreen with the following message after the Report is selected Your selected Array Schools will nat be used in this report os this report contains information solely pertaining to the subject school The Array Schools Will be stored and used again in reports that require them e Reports Contract Settlement Form Section lf the fiscal year you are lo
50. echnology Coordinator Media Specialists RN Nurse lt lt Back to the List View Page 23 Experience Information Hiring Year kJ 2016 2017 Previous Experience kJ 0 il Educational History After clicking Save below you will be prompted for Educational Information lt important that accurate educational information is provided starting with the year the Staff Member was hired Ly No educational history is available Mm Save e None of this information will be available to any other district it is only available to yours e The family information is required for placing this Staff Member against Array Schools during the Negotiation s calculation process e The displayed Job Titles will changed based on selections in the Contract Settlement Form Teacher will be selected by default Select all Job Titles that this Staff Member has e For Previous Experience provide the Staff Member s total experience at other districts not just what was accepted for placing the teacher at your district o If you only provide the information your district accepts then the Negotiation Module s calculations may be inaccurate 23 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 24 e Educational History will be requested after saving this information described below e An Educational History entry is require
51. ections link will display the Projections page for this Negotiation described below e The drop down in the header determines whether the new EHA Rates are used in the calculations when they are known described below 43 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 44 e The Compensation Range shows the statutory range of the Base Salary and the Total Costs which is between 98 and 102 of the calculated Midpoint o If we areina period of recession the bottom of the range falls from 98 to 95 The program will know when the state is in a recession based on statute o If the current salary is below 93 of the calculated value or above 107 we recommend normalizing the value over 3 years not all at once The following message will be displayed below the Comparable Benchmark Since the Base Salary for the Current Costs 31 900 and the Comparable Benchmark 38 430 at the 100th Percentile are so far apart the difference should not be made up just one year consider splitting it up over 3 years with a Base Salary of 33 819 for this year kJ e The Difference row shows the increase or decrease between the Current Costs and the Comparable Benchmark e Clicking the Comparable Benchmark link will direct the user to the School Information Worksheet page described below for the Subject School s Calculated values S
52. eft of the page will reorganize the selected schools in the Array Schools list so that only the Default values are selected Reset Selected Array Schools o Upto 20 districts that are geographically close to yours with an enrollment between 50 and 200 of yours are moved into the Array Schools list All other districts are moved into the Available Districts These default districts are always marked with a when they are in either list When coming to this page for the first time or without any previously selected Array Schools these schools will be selected by default hence their default designation o This list of Array Schools is not saved by the program as Enrollments or school locations change the Default districts will update as well If you want to save these districts click the Reset button before clicking the Save button on this page e Click the Next button on the bottom right of the page to proceed to the Reports Viewing Page described below 15 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 16 Reports Viewing Page Advanced Array School Selection Load Array School Group gt WwW Report Type Selection Report you want to view Enrollment 7 View Raport Q Report year to view 2014 2015 w e By default the Report section itself is not displayed Fill out the rest o
53. f the page to view this section of the page e f there are previously saved Array School Groups this page will display first o The Array School Groups are sorted alphabetically for the Load Array School Group button and the first is automatically selected for use Use the Load Array School Group or Advanced Array School Selection buttons to select other Array Schools o This page also displays after selecting Array Schools on the Advanced Array School Selection page described above e Click the Advanced Array School Selection button located on the top left of this page to go back to the Advanced Array School Selection page e Click the Load Array School Group to open a menu with a list of all the previously saved Array School Groups o This button will only display if there are Groups of previously saved Array Schools o This is a quicker method of switching between Array School Groups than using the Advanced Array School Selection page o This button will NOT display the Load Previously Selected Array Schools form if you want to see this form go back to the Advanced Array School Selection page described above e Inthe Report Type Selection section o First choose the Report you want to view in the drop down o Second in the drop down choose the year of the Report you want to view o Next if a Report requires additional information more controls will be displayed Th
54. for e Next the Negotiated Agreement table loads Then Select the Contract to Load Dundy County Stratton Public Schools Exeter Milligan Public Schools Fairbury Public Schools Newcastle Public Schools Stanton Community Schools Wilber Clatonia Public Schools e Simply click on the district name to open their Negotiated Agreement in a new window tab e The Contracts open as a PDF e Asa PDF there should be a toolbar allowing you to save or print the agreement if desired Examples of this toolbar are included here and vary by browser 18 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 19 Negotiations Module Staff Information e Before the Negotiation process can commence Staff Information for your district must be provided via these pages e Information like the Hire Year Education Level and Health Insurance selection are required to accurately place your Staff Members at other districts which is primarily what the Negotiations Module does e Only provide information for Staff Members that should be included in the Negotiations o These would be the Staff Members that are in the certificated bargaining unit grades K thru 12 o Staff members that do not meet all of these criteria should not be added as their inclusion will make the Negotiations calculations inaccurate for your school e No Staff information will be available to o
55. from lt lt Back to Array School Groups 47 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 48 School Information Worksheet e Getto this page by clicking on the name of the Array School in the Array School Comparison Information section For the Subject School click Current Costs or Comparable Benchmark in the Comparison Results section e All ofthe information on this page refers to a particular school district which could be the Subject School or one of the Array Schools e The Header at the top of the page will refer to the district being displayed Detailed Links DETAILED LINKS Staff Summary Benefits Summary All Links are for A e This section contains the links to the other pages described below Schedule Information 2014 2015 SCHEDULE INFORMATION Base Salary 31 500 Expenence Allowed Entry Level Step 2 Starting Index Step 1 H I 0 040 Ml 0 040 Bo of columns 8 Max Steps 14 Honzontal Movement Limit Vertical Movement Limit 1 e This section includes basic salary schedule information from the CSF including the Base Salary the amount of Experience new hires are allowed to bring from another district where Staff Members without any experience are placed etc e If this is for the Subject School the Base Salary is the calculated value 48 Page Copyright 2013 2015 Nebraska Education Technology Ser
56. g ones e You cannot select a lower degree or fewer Additional Credit hours for the same degree in a more recent year o For example if a 2012 2013 entry is Master s and 10 Additional Credit Hours then the 2014 2015 entry could not be for a Bachelor s degree but also could not be for a Master s degree with fewer than 10 Additional Credit Hours o However an entry for 2012 2013 could be provided with a Bachelor s degree or a Master s degree with fewer than 10 Additional Credit Hours because the new entry would overwrite the existing one during the saving process e Information is not additive Each entry should include the total number of Additional Credit Hours for this Staff Member above the selected Degree Level 30 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 31 Remove Educational Information Remove Education Information x Select the entry you would like to remove then click the Remove below Educational History Entry 2011 2012 Master s 10 Additional Hours Remove Selected Information Close e This form is displayed when the Remove educational information button is clicked when editing a Staff Member s information e The drop down list contains all the Educational History entries that have been provided for this Staff Member e Select the appropria
57. he Last page would display Staff Members 41 45 e These links will be deactivated as necessary for example if the first page is displayed then the First and Prev links will be disabled s2 First lt Prev Next gt Last gt F On Page 30 7 Change 1to 10 out of 45 total Staff Members ge e Ifyouwantto display more than 10 Staff Members per page change the On Page drop down to the appropriate value then click the Change button The options are All 10 25 and 50 lt lt First lt Prev Next gt Lasts gt On Pagel all Y Change 1 to 45 out of 45 total Staff Members e The text to the right of this section will let you know the Staff Members that are being displayed as well as the total number This will update as you move between pages 4 to 45 out of 45 total Staff Members e fthere are enough Staff Members an additional line of alphabetic links will display beneath the standard paging row o This row allows the Staff Summary page to be filtered by the first letter of the Last Name o Inthe example below E has been selected so only Staff Members with a last name starting with E are displayed and in this case it s only Kristofer Eaton Clicking the Next link will display the F names while the Prev link will display the C names since D has been disabled because there are no Staff Members with a Last Name starting with D likewise the First link w
58. he Number of Projection Rows determines how many rows are displayed e The Include EHA Rate Change will determine which EHA Rate to use for the Projected Rows either the current year or the new rates o This item is only displayed when the new EHA Rates are known o If the Current Costs are already based off of the new EHA Rates then this field is not displayed and all Projection Rows are based off of the new EHA Rates too e The Base Salary Increment will change the Base Salary for the Projections o The starting Base Salary is the Base Salary from the Current Costs o The Increment will increase this Base Salary for every Projection row e lf changes are made in this section click the Calculate New Projections button at the bottom right to reproduce the Projection rows displayed below 59 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Projections Page 60 Current Costs Projection for 31 900 Projection for 32 000 Projection for 32 100 Projection for 32 200 Projection for 32 300 Projection for 32 400 Projection for 32 500 Projection for 32 600 Projection for 32 700 Projection for 32 800 182 182 182 182 182 182 182 182 182 182 182 133 1627 135 1627 135 1627 135 1627 ESE 135 162 135 1627 135 1627 ETEN 135 1627 135 1627 31 900 31 200 32 000 32 100 32
59. he changed values are bolded Albert Brandon Masters 10 5 0 0 5 BA 36 9 1 4800 04 0 5920 18 648 1 427 1 842 E 0 0 0 21 917 e Likewise back on the Midpoint Analysis page the district where the adjustment was made is highlighted with a light red background and again the changed values are bolded There is also a small explanation of the light red background Lo 185 13 6240 37 500 59 905 504 373 564 232 50 905 496 199 556 103 Districts with a light red background above have adjustments which were made wia the district s Schedule Costs link 68 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 69 e Toremove adjustments o The Remove All Adjustments for button on the Adjust Staff Member s Information form will remove all adjustments for this user for this district it will not affect adjustments on any other district even those made for this Staff Member and it will not affect any adjustments made for any other Staff Member even those on this district Remove All Adjustments for Albert Brandon o After an adjustment is made the Remove button will enable on the Adjust Staff Member s Information form clicking this button will remove this adjustment for this Staff Member but will not affect any other districts other Staff Members or other adjustments on this Staff Member H A Information Edit thi
60. he header to download this information as a CSV file that can be opened in programs such as Microsoft Excel 61 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 62 e To make a manual change to Staff Member information click the Need to make an Adjustment button See below for details e When an Adjustment aka a manual change is made to a Staff Member explained below the row will be highlighted in light red Albert B H Masters 10 5 0 0 5 BA 36 9 1 4800 04 0 5920 18 648 1 427 1 842 E 0 0 0 21 917 randon Staff Summary Paging Experience Placement e Retire HA H A Additional Other Total Education ment Category Cost Benefits Ins Cost DIS ADJ PR CR COL STEP INDEX 11 Jam Bachelors 3 OQ 1 D 1 BA 2 1 0450 0 75 0 7838 27 595 2 497 2 726 ESC EC 5 040 0 0 37 857 12 ii Bachelors 8 D 1 1 1 BA 2 1 0450 1 1 0450 36 793 3 329 3 634 E EC 6 720 0 0 50 476 13 i Bachelors O JO 1 D 1 BA 2 1 0450 1 1 0450 36 793 3 329 3 634 ESC 6 720 0 0 50 476 14 E Bachelors D 1 Yi BA 2 1 0450 1 1 0450 36 793 mae Fa 3 634 ESU 6 720 0 0 50 476 15 H Bachelors O JO 1 D 1 BA 2 1 0450 1 1 0450 36 793 3 329 3 634 ESC 6 720 0 0 50 476 16 aa Bachelors O O 1 i BA 2 1 0450 1 1 0450 36 793 ayes 3 634 EX 6 720 0 0 50 476 17 Bachelors 12 0 1 D 1 BA 9 2 1 0900 1 1 0900 38 119 3 430 3 765 ESC ES 6 720 0 0 52 035 18 ad Bachelors 15 0 2 2 2 BA 9 3 1 1350 1 1 1350 39
61. he instance that a Staff Member was placed at the wrong point in the Salary Schedule table etc e Clicking Edit this H A Information displays the Adjust H A Information form where you can select a new Category before clicking Save Adjustments Adjust HA Information x For Albert Brandon Select the new HiA Category for this staff member Gash Save Adjustments Close 65 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 66 e Clicking Edit this Salary Information displays the Adjust Salary Schedule Information form where you can select a new Salary Index Simply click on the Salary Index that should be applied for this Staff Member Adjust Salary Schedule Information For Albert Brandon Using either table selectthe appropriate value below show Salary schedule Amount Table BA BA 9 BA 18 Bat BA 36 MA MA 9 MA 18 1 1 00 1 04 1 08 1 12 1 16 1 16 1 20 1 24 2 1 04 1 08 1 12 1 16 1 20 1 20 1 24 1 28 3 1 08 1 12 1 16 1 20 1 24 1 24 1 28 1 32 4 1 12 1 16 1 20 1 24 1 28 1 28 1 32 1 36 5 1 16 1 20 1 24 1 28 1 32 1 32 1 36 1 40 6 1 20 1 24 1 28 1 32 1 36 1 36 1 40 1 44 7 1 24 1 28 1 32 1 36 1 40 1 40 1 44 1 48 8 1 28 1 32 1 36 1 40 1 44 1 44 1 48 1 52 esi 1 36 1 40 1 44 1 48 1 48 1 52 1 56 w nee 1 44 1 48 1 52 1 52 1 56 1 60 eee ue ee 1 52 1 56 1 56 1 60 1 64 1 O IN eo 1 ee 1 60 1 60 1 64 1 68 a ez e
62. hedule e Squares are color coded to indicate which positions have the most staff members e Hover your mouse over one of the values to see a list of the staff members in that cell ALVAREZ TYRONE MYERS JERRY 53 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 54 H A Benefit Information H A BENEFIT 5750 Deductible INFORMATION CIL Option 4 FTE Basis Eligible at 0 5 Category Cost Mo Cost Year FTE FTU Category Cost of Total Costs E 512 70 6 152 40 0 80 1 00 4 921 92 5 22 Fic 512 70 6 152 40 3 66 5 00 22 517 78 37 59 EC 928 42 11 141 04 0 80 1 00 8 912 83 14 88 ES 1 050 68 12 608 10 O80 1 00 10 086 48 16 84 ESC 1 402 69 16 832 26 O80 1 00 13 465 80 22 48 SUM 6 86 9 00 59 904 82 100 e The header includes the deductible used by this district plus the Cash In Lieu rule and information on which Staff Members get benefits Each row contains information on a specific Health Insurance Plan o E Employee Only o EC Employee Child o ES Employee Spouse o ESC Employee Family In certain circumstances the Insurance Plan that the Staff Member has selected is not available at the Array School like in the example above where the Staff Member selected Cash In Lieu C which is not available at this Array School the Staff Member must be moved to another insurance plan like Employee Only which is then displayed like so E
63. idpoint Analysis page is described below including all the other pages accessible from it e You may change the Percentile that the program targets in its calculations by selecting the Lissa before clicking the Force Recalculate button S Percentage in the drop down This process is also described in below e Like with other pages anytime a manual change modification has been made described below that Array School Group s row is highlighted in light red Herd ta Find Districts de 128 2 aul 338 207 42 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 43 Midpoint Analysis Save These Array Schools as a Group Save These Array Schools as a Group This group of array schools has not been saved as an Array School Group Frequently used groups of array schools can be saved as Array School Groups which can then be quickly recalled on the Negotiations and Reporting modules and can even be processed against other Array School Groups simultaneously To save this group click the button below and prowde the group name when prompted Save This Group of Array Schools e This section will not display if the Array Schools are already saved as a Group e f the selected Array Schools are used often click Save This Group of Array Schools to save them for selection in future Negotiation sessions or periods Click this button t
64. ights Reserved North Star Negotiations User Manual Page 25 e For existing Staff Members this page allows you to quickly update Educational History Information e The rows are populated with the most recent Educational entry for the Staff Member e Only make changes to rows if a Staff Member has received a new degree or acquired additional credit hours e At the top of the page is the year in which the changes are taking effect change this value as necessary but most often it should be set to the upcoming fiscal year e Paging can be implemented on this page described below e As changes are made to rows to the Degree or Additional Credit Hours the Save button for the row is enabled as is the Save All Page Changes button at the bottom of the page 1 Albert Brandon Master s T 14 n Save B 2 Baldwin Jonathan Master s T O Save B Save All Page Changes 8 e Click the Save button to add a new Educational History Information entry for the Staff Member This will not affect any other Staff Members e Click the Save All Page Changes button at the bottom of the page to add new Educational History entries for every row on this page that has been changed o If Paging is enacted this button will only save changes made to the currently viewed page Do not leave this page without Saving changes or the changes will be lost e Click the name of a Staff Member to go to the Edit Staff Member s Information
65. ill take you to the A names while Last will take you to the W names which is the Last letter that is available since X Y and Z are all disabled Last Name Experience Placement Staff Ratira HA Sp pea ee Education FTE Salary FICA See itiona er Tota ment Category Cost Benefits Ins Cost First Name DIS ADJ PR CR COL STEP INDEX Index EATON j 7 0 0 7 MA amp 15500 1 15500 58 42 4 730 5 752 CIESC 3 600 0 191 72 501 KRISTOFER 7 Masters 7 TOTALS for all pages 62 90 93 52 3 513 153 270 133 347 022 603 813 0 12 484 4 746 605 AVERAGES for all pages 1 3360 50 188 67 809 lt lt First lt Prev Next gt Last gt gt On Page 10 Y Change 18 to 18 out of 70 total Staff Members o Clicking the Change button will switch you back to the standard On Page view otherwise the On Page value is ignored when we are viewing Staff Members by their Last Names 63 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 64 Staff Summary Adjustments After clicking the Need to make an Adjustment button described above Staff Members names are converted to buttons 1 Albert Masters 10 5 OF OF 5 A49 14000 0 4 0 5600 17 640 1 349 1 742 EIC 0 0 0 20 732 Brandon 2 Baldwin Bachelors 0 2 8 10 10 B 11 1 4000 0 8 1 1200 35 280 2 699 3 485 E 4 922 0 0 46 386 Jo
66. ired in the import and how they should be formatted az well az how the two imported files are connected cor e One way to add Staff Information is via the Import Staff Information page This page is accessed via the Import Staff Information button in the header of the Staff List page G Import Staff Information E e Import files should be in Comma Separated Value CSV format 19 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 20 e Use the two Download links on the right of this section to download sample Comma Separated Value CSV files one at a time e CSV files can be created and edited in Microsoft Excel e Both the Staff Member and Educational History files should be imported together e This is the quickest method for adding large numbers of Staff Members e Staff Members import o See the Staff Members section on the import page not shown here for a detailed explanation of the fields required for the import o This import file contains basic information about Staff Members including Staff Member s Name Year Hired Previous Experience etc o This file should also contain a unique ID for each Staff Member that corresponds to the row s in the Educational History import file that pertain to this Staff Member This is how the site will know which Educational History entries tie back to which Staff Membe
67. l be ignored o Inthe example above Shickley has been marked as Excluded which means Shickley will not be included in the Negotiation s calculations process o The CIR may not allow schools to be excluded but you may negotiate exclusions with your staff e Below the list of Array Schools is some text describing the array including the number of schools included and the distance to the furthest included district These values will update as schools are excluded from the array e To alter the schools in the array use the Array School Selection Criteria described above e Finally next to the descriptive text is the View as Map link which directs you to the Array School Selection By Map page described below 36 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 37 The Bottom Row of Buttons lt lt Back to Year Select Perform Array School Comparison gt gt Perform Array School Comparison with ALL Groups s e The Back to Year Select button will navigate you back to the Fiscal Year Selection page described above e The Perform Array School Comparison button will perform the Negotiations computations using the Array Schools in the list on this page described above This may take several minutes please be patient After the processing has completed you will be taken to the Midpoint Analysis
68. less of how much is offered o 4 No Cash Offered This means no CIL Amount is offered so Staff Members may be moved to their qualifying insurance plan 58 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 59 Projections Get to this page by clicking either Projections link in the Comparison Results section To see Projections for a Changed Data Row click its Description in the Changed Data Row section Projection Specifications Staff Index Increase Percentage 11 719 m Uy Atanually set Staff Index 1 Year y Humber of Projection Rows 130 y Include EHA Rate Change Wes Y W Base Salary Increment 100 k Calculate New Projections e The Projection Specifications at the top of the page will determine how the Projection rows below are calculated e The Staff Index Increase Percentage will change the Staff Index for the Projections o The Staff Index from the Current Costs is the base and the Increase Percentage is taken from this Each Projection row will have the same Staff Index To use the same Staff Index as the Current Costs use a O here Click the 1 Year button to have the program estimate your district s Staff Index for next year by moving your Staff down on your Salary Schedule without anticipating any Educational History changes o Click the Manually set Staff Index link to set a specific Staff Index e T
69. ma O e a e eo 1 68 1 72 IO O O IE IA O 1 76 Close 66 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 67 e Also on the Adjust Salary Schedule Information form is a Show Salary Schedule Amount Table link Clicking this link will convert the indices normally displayed to the actual salary dollar amounts based on the base salary value from the CSF Like with the index values simply click the Salary that should be applied for this Staff Member Adjust Salary Schedule Information For Albert Brandon Using either table selectthe appropriate value below show Salary Schedule Index Table Ba BA4 9 BA4 18 BA 27 BA 36 MA MA 9 MA 18 1 31 500 32 760 34 020 35 280 36 540 36 540 37 800 39 060 2 32 760 34 020 35 280 36 540 37 800 37 800 39 060 40 320 z 34 020 35 280 36 540 37 800 39 060 39 060 40 320 41 560 4 35 280 36 540 37 800 39 060 40 320 40 320 41 560 42 840 5 36 540 37 800 39 060 40 320 41 580 41 560 42 840 44 100 6 37 800 39 060 40 320 41 580 42 840 42 540 44 100 45 360 7 39 060 40 320 41 580 42 840 44 100 44 100 45 360 46 620 a 40 320 41 580 42 840 44 100 45 360 45 360 46 620 47 860 e eee 42 840 44 100 45 360 46 620 46 620 47 860 49 140 He as O eee 45 360 46 620 47 880 47 880 49 140 50 400 NI O ee 47 880 49 140 49 140 50 400 51 660 El ems ll sem me 50 400 50 400 51 560 52 920 a e a lec a teme eee 52 920 5
70. module lf you feel your district s information is not accurate please go to the Contract Settlement Form and correct it If you feel another district s information is innacurate please contact NETS e This section explains that most of the information used in the Negotiations Calculations comes from the Contract Settlement Form for your district and the Array Schools e This section appears at the bottom of most of the pages in the Negotiations Module e There are links provided to access the Contract Settlement Form where you can edit your district s data you will not be able to edit any other districts data e There is also a contact NETS link where you may notify NETS NASB of perceived inaccuracies in CSF data for an Array School Fiscal Year Selection Fiscal Year Selection Contract Settlement Form Fiscal Year 2014 2015 for 2015 2016 negotiations Next gt gt k The year selected corresponds to the information from the Contract Settlement Form that will be wed in this Negotiation You will most likely select the Most recent year As an example via the drop down abowe you would select the 2010 2011 contract information to we for the 2011 2012 negotiatiore e After the required Staff Information is provided explained above the first page of the Negotiations Module is the Fiscal Year Selection e Arrive at this page by clicking the Negotiate link in the page header described above as long as Staff Informati
71. nathan Berry 3 sal Doctorates 0 3 OF 0 3 A B 4 13600 0 4 0 5440 17 136 1 311 1 693 ESIC 0 0 0 20 140 Click the name button to make a change to the information for that Staff Member via the Adjust Staff Member s Information form Adjust Staff Members Information x For Albert Brandon Adjusted values are saved to the site and will be available for future visits These adjustments are only valid for this school district Meridian Public Schools and will not affect any of the other districts in the array Only these fields may be adjusted After adding or removing adjustments the data will need to be recalculated HIA Information Edit this H A Information H A Category y Cost Et 0 Salani Schedule Information Edit this Salary Information Placement FTE Staff index Salary COL STEP INDEX MA a 1 4000 0 4 0 5600 17 640 Remove All Adjustments for Albert Brandon Close 64 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 65 e Manual changes can be made to two fields for each Staff Member the Health Insurance and the Salary Schedule Placement information e These Adjustments are not related to the values that have been Adjusted for Contract Days like the values on the Midpoint Analysis page described above o The adjustments made via this process are to correct change the calculated information in t
72. new staff members e The full Tuition Reimbursement will be paid to each staff member regardless of how much is actually used since the district will have to budget for the full amount e The Employee Fringe Benefit is given to each qualified staff member regardless of their dependents or marital status e The Dependent Fringe Benefit will be paid for each dependent to qualified staff members o For example if the amount specified here were 100 and a staff member had 3 dependents then that staff member would be given 300 if another staff member had only 2 dependents then that staff member would only get 200 Description Description y lt lt Back to Ai dooint Analysis Add Changed Data Row e The Description field is used to distinguish Changed Data Rows from each other e Descriptions are especially useful when more than one row is displayed e Rows display in the Changed Data Rows section of the Midpoint Analysis page e After making all the necessary adjustments click the Add Changed Data Row button to save the information and calculate the costs 77 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved
73. nt is made internally only and not displayed e Ingeneral the Staff Index should not be changed here but instead can be changed on the Projections page 70 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 71 Base Salary a2 497 94 Any change in the Staff Index via this page will be evenly distributed amongst your staff even part timers A slider appears below the textbox to allow for easily changing this value The buttons to the right of this field also allow you to adjust the Staff Index Click the Manually set the Base Salary link to gain the ability to choose a new Base Salary for the program to calculate with This section is then displayed 98 100 102 Automatically calculate a Base Salary WwW By default the calculated Comparable Benchmark value is displayed If you have a specific Base Salary in mind you can enter it directly into the textbox Any value will be accepted here even if it is not between 98 and 102 of the calculated Comparable Benchmark value Click the 98 button to have the textbox automatically populated with 98 of the calculated Base Salary Similarly clicking the 102 button will populate the textbox with 102 of the calculated value By default the 100 value is displayed so clicking this button will not do anything unless the value has been changed in which case it will
74. o Goto the main NASB website http www nasbonline org Log in The same username and password that work in North Star will work here Select My Membership Select Edit Contact Information Click the Add New button Provide the new user s information and Save Go back to this Settings page in the North Star program and click the Refresh Users button This will tell the program to load your newly created user s e To deactivate a user you will also have to go to the main NASB website and Edit Contact Information The process is similar to creating new users described above O O O O 12 Page Copyright O 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 13 Reports Module Use the Reports link in the page header to access these pages Advanced Array School Selection Mowe schools to the Selected Array Schools list to be included in this report To move schools to the Selected Array Schools list select the anels you want to move in the Awailable Districts list then click Add Likewise to remove schools from the Selected Array Schools list select the schoolls to remove in the Selected Array Schools list then click Remove Schools removed from the Selected Array Schools list wall appear at the bottom of the Available Districts list and can be re added to the Selected Array Schools list at any time The reports are listed
75. o display the Save Selected Array Schools form described above Comparison Results Comparison Results 2014 2015 EHA Rates Y Contract Staff Base Benefit Schedule Total Percentile Days Index Salary Costs Costs Costs Current Costs 20142015 182 135 1627 31 900 1 039 624 5 026 406 6 066 030 View Current Costs Projections OB 10 Comparable Benchmark 142 W562 7 32 372 TOT 2d 5 101 437 0 141 056 View Comparable Projections 100 T E Difference 472 O 75 025 75 025 1 22 Base Salary 08 31 599 100 dee 102 33 145 Compensation Range Total Costs 08 6 018 254 100 6 141 056 103 6 465 877 e This section contains information for the Subject School e The Current Costs information uses the current year s CSF data to calculate the costs of the Subject School e The Comparable Benchmark row includes all the costs calculated in the Negotiations process Notably the new Base Salary based on the calculated Total Costs o This row and its values are explained in detail in the Overview section o Total Costs is the average of the Mean and Median Adj Total Costs for all the Array Schools described below adjusted for the selected Percentile described below o Benefit Costs are essentially the same as the current years costs adjusted for the new Base Salary where applicable o The Base Salary is calculated from the Total Costs and the Staff Index e Clicking the View Current Costs Projections or View Comparable Proj
76. oking for is not present in the drop down above please go to the Contract Settlement Form to prowde this information Since all of the information in the reports comes from the CSF if you feel your district s information is not accurate please go to the Contract Settlement Form and correct it lf you feel another district s information is innacurate please contact NETS o This section explains that all of the Reports values come from the Contract Settlement Form for your district and the selected Array Schools This section appears at the bottom of this page There are links provided to access the Contract Settlement Form where you can edit your own data o There is also a contact NETS link where you may notify NETS NASB of perceived inaccuracies in CSF data for an Array School 17 Page Copyright O 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 18 Contracts Negotiated Agreements Contracts Negotiated Agreements Please Select a Year Please Select a Year Then Select the Contract to Load e The Reports service is required for this page to display e Contracts refers to districts Negotiated Agreements e This page allows you to select the Negotiated Agreement of a specific school for a specific year as supplied by that school in the Contract Settlement Form e The first step is to select the year of the agreement you are looking
77. omparable Benchmark and Difference rows all refer to the Subject School your district The Current Costs are based on the current year s CSF information including the Base Salary while the Comparable Benchmark row is based on calculated values Here is an in depth explanation of the process the program undergoes when calculating the Comparable Benchmark 1 The program calculates the Staff Index for the Subject School by placing your teachers on your Salary Schedule This incorporates the teachers experience and their educational information provided via the North Star program It also includes all limits freezes and rollbacks etc as specified via the CSF All the Salary Schedule index values are added up for all the staff members entered into North Star which is the Staff Index value for the Comparable Benchmark 2 Your staff is then placed at each of the Array Schools This includes placement on the Array Schools salary schedules as well as all the other insurance and benefit information health and dental LTD Life Tuition Reimbursement etc which is based on the information the Array Schools provided in the CSF Details on the placement of each of your employees per array school can be found by clicking on the Schedule Costs for the array school The same detailed information can be found for your district based on the calculated costs by clicking the Schedule Costs link of the Comparable Benchmark row 3 Next the program
78. on an upcoming page Available Districts t B Array Schools Q9 Adams Central Public Schools Add Bruning Davenport Unified System Ainsworth Community Schools Exeter Milligan Public Schools 4 Allen Consolidated Schools i McCool Junction Public Schools 41 Alliance Public Schools Meridian Public Schools Alma Public Schools le Remove Shickley Public Schools Amherst Public Schools Superior Public Schools Anselmo Merma Public Schools Sutton Public Schools Ansley Public Schools Thayer Central Community Schools Arapahoe Public Schools Arcadia Public Schools Arlington Public Schools Arnold Public Schools Arthur County Schools Ashland Greenvood Public Schools Auburn Public Schools Aurora Public Schools Axtell Community School Bancroft Fozalie Community School Banner County Public Schools The selected list of array schools can be saved for quick access by clicking the appropriate button above the list Multiple groups of array schools may be saved If a group of schools is used often we recommend saving it Array school groups are shared between the Reporting and Negotiations modules By default the 20 geographically closest schools with an enrollment between 50 and 200 of your school s are in the Selected Array Schools list these schools are also marked with a J To reset the Selected Array Schools list to only these school simply click the appropriate button below Reset Selected Array Schools w
79. on has been provided e You want to select the year that corresponds to the Contract Settlement Form data you want to use This is not the year you are negotiating for as you will be using last years CSF data to negotiate for the upcoming year e Generally you will select the default value which will be the most recent year e Clicking Next will navigate you to the Array School Selection page described in detail below Before continuing be sure you have updated Staff Information as necessary o This includes adding all newly hired Staff Members explained above updating all Staff Members Educational History information explained above as well as any other demographic information that may have changed like a new dependent marriage etc explained above 32 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 33 Array School Selection Deshler Public chools 85 0060 2014 2015 Array School selection 6 16 2014 Array School Selection Criteria Upper Limit 2 00 452 Area 5chools 9 Lower Limit 0 50 113 Proximity 38 Enrollment 226 a e Save These Array Schools Ge Load Array School Group w School Y District Class County Size Ratio Miles Exeter Milligan Public Schools 30 0001 3 Fillmore 195 0 86 38 Meridian Public Schools 48 0303 3 Jefferson 164 O73 24 Shickley Public Schools 30 0054 3 Fillmore 123 0 54
80. orth Star then removes the Benefit Costs from the Current Costs row to determine what the Schedule Costs of the Comparable Benchmark should be o In doing this the program assumes that Benefit Costs for your district won t be changing in a major way from year to year though we do adjust for costs that are based on the salary for example when LTD costs are based on salary o To see what the costs would look like with changes to benefits costs use the Add Changed Data Row and from there adjust the benefits as desired you can add as many changed data rows as desired so feel free to play around with this 7 After calculating the Comparable Benchmark s Schedule Costs we then divide this value by the calculated Staff Index of the Comparable Benchmark row This gives us the new Base Salary for the Comparable Benchmark This is the Base Salary that we have calculated for your district based on all the other information and the rules the CIR follows o It could be above or below the Current Costs s Base Salary with the Difference shown in the row below the Comparable Benchmark o The CIR wants districts to be within 98 and 102 of the calculated values We provide this information below the Comparison Results section as Compensation Ranges o Ifyou want to see detailed information using a Base Salary other than the one we calculated like the 98 Base Salary you can adjust the Percentile 5 Page Copyright 2013 2015 Nebraska E
81. ove the slider control is the Array School Selection Criteria which will behave the same as it does on the regular Array School Select page e To get back click the Back to Array School Select button which will take you back to the Array School Selection page with the Actual List as described above and will keep any changes made e From this page you cannot Exclude any schools or interact with the Array School Groups saving or loading you will have to return to the list page for that e Finally at the bottom of the page is a link to view a larger map The large map not pictured here functions the same as the map on this page but may be easier to use for those with higher resolution monitors 39 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 40 Save Selected Array Schools Save Selected Array Schools x Provide a name for this group of Selected Array Schools save Name example District s Array If the name has already been used saving here will overwrite the previous group of Selected Array Schools without warning Here are the Selected Array Schools in this group Exeter Milligan Public Schools Meridian Public Schools Bruning Davenport Unified System Thayer Central Community Schools Superior Public Schools McCool Junction Public Schools Sutton Public Schools Save Array Schools Cancel
82. ption employees under the provided threshold get no benefits for example if the starting level of benefits is 0 6 a 1 2 time employee would get no benefits 72 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 73 Health Insurance Health Insurance Health Insurance Deductible 500 Deductible T Surcharge No Surcharge Discount Mo Discount T Include New EHA Rate 1 9 Change for Dental costs tool Mo Y Health Insurance Costs Monthly Premium Percent Paid by District Dollar Amount Paid by District Employee El doo 95 00 927 66 Ee 4 Child ren EC 1 027 56 51 35 52r 65 Ee amp Spouse E5 1 166 40 45 2950 927 66 Ee Spouse amp Childirenj ECS 1 566 18 33 69 927 69 e Selecting a new Health Insurance Deductible will update the table s information e Changing the Surcharge or Discount fields will also update the table s information accordingly These fields do not impact the Dental Insurance information e Including the EHA Rate or not will update both the Health Insurance and the Dental Insurance tables This option is only available when the new EHA rates are known e Updating the Premium or Percent Paid fields will automatically update the appropriate Dollar Amount Paid field e The Dollar Amount Paid by District field is the most important in this section the others are just there to help populate thi
83. rmation has been entered or imported o For example the initial import may contain all employees up to that point and new employees may be imported every year thereafter o However the Staff Members and Educational History files must match each other to both be imported so if you have a file of employee Educational History then it must be imported at the same time as the employee o Importing Staff Members will have no effect on any current Staff Information e The Import process is not required as Staff Members may be added via the Add New Staff Member link explained below Staff Information is required e Click the Perform Import button to import the selected file s No information is imported until this button is clicked e All Staff Members are imported as Teachers If they should have another Job Title you will need to edit them individually 22 Page Copyright O 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Add New Staff Member Basic Information First Name Last Name Does this staff member have a spouse y No F If this staff member is married is their spouse also an employee of this district No Y 5pecify the number of dependent children for this staff member a 0 r Employment Information Full Time Equivalency id 3 a H A Plan P Cash Opt Out Y Job Title s Teacher Athletic Director IT T
84. rray School Group which can be Loaded in the Negotiations Module e Try setting up multiple Array School Groups The Perform Array School Comparison with ALL Groups feature will compare them all yielding the cheapest set of Array Schools This will take longer to process than a standard comparison but may provide more informative results 3 Page Copyright O 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 4 The Calculations The Comparable Benchmark row on the Midpoint Analysis page is comprised of calculated values for your district These values are based on information your district provided via the Contract Settlement Form CSF the Array Schools selected via the North Star program information your Array Schools provided via the CSF and the staff information you provided via the North Star program Comparison Results 2014 2015 EHA Rates lo Contract Stalf Base Benefit Schedule Total Percentile Days index Salary Costs Costs Costs Current Costs 2014 2015 182 1351627 31 900 1 039 624 5 026 406 86 066 030 View Current Costs Projections Oe 10 Comparable Benchmark raz 133 1627 32 372 1039 624 5101431 6 747 056 View Comparable Projections 100 E Difference 477 0 75 075 75 075 1 22 Base Salary 08 31 599 100 Cane Fes 107 33 145 Compensation Range Total Costs 98 6 018 234 100 6 141 056 102 6 263 577 The Current Costs C
85. rs o Remember to remove the example row s when you use the example file e Educational History import o See the Educational History section on the import page not shown here for a detailed explanation of the fields required for the import This import file contains the Educational History for the Staff Members in the other O import file o This is a separate import file because most Staff Members will have multiple Educational History entries at least in the initial import o To correctly place Staff Members we need to know their entire Educational History from the year the Staff Member was hired o New entries are required when Staff Members acquire additional credit hours and or receive a new degree o Entries are not required for every year the Staff Member is employed only when their Educational History changes An Educational History entry is required for the hiring year of every Staff Member O o This file is not required Educational History information is required but it can manually be added later via the Edit Staff Member s Information page explained below If this information will be manually added it does not have to be imported here Remember to remove the example row s when you use the example file O Additional Credit Hours are not additive from one entry to the next each entry should represent the total Additional Credit Hours for that Staff Member O 20 Page Copyright O 2013 2015
86. s H A Information Remove H A Adjustments o After an adjustment is made the Remove ALL Adjustments button will be enabled on the Staff Summary page clicking this button will remove ALL adjustments for ALL Staff Members for THIS district This button will still not affect adjustments on any other district Remove ALL Adjustments e These changes adjustments are saved to the database and will remain in place every other time you perform a negotiation calculation until they are removed e These changes adjustments are not tied to a specific Array School Group so if a district with adjustments appears in multiple Array School Groups then the adjustment will be incorporated in the Negotiations calculation for that district in all the Groups it belongs regardless of whether the Group of Array Schools is saved or not 69 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 70 Add Changed Data Row e The Add Changed Data Row button is found on the Midpoint Analysis page in the header of the Changed Data Rows section described above Clicking this button displays this Add Changed Data Row page e This page is used to see what effect a change in certain benefits costs will have to your total costs You may change one or more benefit e There is no limit to the number of Changed Data Rows you can add However the more rows
87. s field e If in the CSF you indicated a switch in deductibles this fiscal year then the table data will contain the switched to deductible information 73 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 74 Dental Insurance Dental Insurance Dental Insurance Deductible Mon EHA T Dental Insurance Costs Monthly Premium Percent Paid by District Dollar Amount Paid by District Y Employee E 24 04 100 00 24 04 Ee amp Childiren EC 40 93 100 00 45 93 Ee amp Spouse E5 22 14 100 00 92 14 Es Spouse A Children ECS 70 04 100 00 0 04 e Selecting a new Dental Insurance Deductible will update the table s information e Updating the Premium or Percent Paid fields will automatically update the appropriate Dollar Amount Paid field e The Dollar Amount Paid by District field is the most important in this section the others are just there to help populate this field e If in the CSF you indicated a switch in deductibles this fiscal year then the table data will contain the switched to deductible information e The EHA Rate drop down in the Health Insurance section will affect this table too Other Insurance Other Insurance Life monthly amount 0 00 Mision monthly amount 0 00 Long Term Disability Monthly Dollar Amount 5 00 e Life and Vision are both monthly dollar amounts e Ifthe LTD is Rate based instead
88. splayed AAA AAA A A A A A A A A Same to CIE 250 00 0 00 a 3 66 26 35 p Same to CIEC 250 00 0 00 A 0 00 0 00 4 57 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 58 Cash Option Analysis Get to this page from the Midpoint Analysis page via a link below the Array School Comparison Information section MASB TEST MEMBER SCHOOL DISTRICT 290 r50 of negotiating school s CL amount is 145 00 Cash Amount Percent of Negotiating Qualifying school Offered School s Cash Amount CIL Rule No Cash Offered 4 No Cash Offered 4 167 Same to All 3 No Cash Offered 4 No Cash Offered 4 167 Same to All 3 No Cash Offered 4 No Cash Offered 4 e This page displays the Cash In Lieu CIL Rules for all the districts in the Array e Above the table the Subject School s CIL amount is listed in addition to 50 of that amount which comes into play with specific CIL rules e Here are the CIL Rules o 1 Sufficiently Similar This means the program will use the Array School s CIL Amount for those staff members that selected Cash o 2 Not Sufficiently Similar This means the program will use the Subject School s CIL Amount for those staff members that selected Cash because the Array School offers CIL but does not offer enough or is below 50 of the Subject Schools CIL o 3 Same to All This means the Array School s CIL Amount is used regard
89. t 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 30 Add New Educational Information Add Edit Education Information x This form is used to add or update this staff members educational information New entries only need to be provided when if a staff members educational history has changed which can happen ifthey receive applicable credit hours or a new degree You must start with the year the staf member was hired After that every change is important even ifthe staf member does not move on your salary schedule as they might move on an array School s salary schedule Effective Year 2015 2016 Y Degree Level Bachelors Additional Credit Hours a 30 Additional Credit Hours are not additive from one entry to the next each entry should represent the total Additional Credit Hours for that Staff Member r Accept New Values Close e After clicking Save when adding a new Staff Member or after clicking Add new educational information when editing a Staff Member this form displays e An entry is required for the year the Staff Member is hired at your district and is also required any time the Staff Member receives a new degree or even when the Staff Member acquires additional credit hours e Select the year you are providing information for If you select a year that already has an entry the new values will overwrite the existin
90. te entry in the drop down then click Remove Selected Information to have that entry deleted e The information is immediately removed when clicking Remove Selected Information clicking Save on the Edit Staff Member s Information page after making this change is not required though doing so will not cause any issues Delete Staff Member s Information e After clicking Delete when editing a new Staff Member or after clicking Remove from the Staff List the delete form displays not pictured e Click the Delete button at the bottom of the page to remove this Staff Member e The page looks the same as the Add New Staff Member page described above except for the following differences o There is no Save button the Delete button has moved over to take its place o Educational History may not be added or removed o Changing values on this page will have no affect since there is no Save button e fa Staff Member is removed accidentally and cannot easily be re added please contact us We may be able to re activate the deleted Staff Member 31 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 32 Negotiations Process Negotiations Contract Settlement Form Section Information from the Contract Settlement Form both for your district and the array schools is used to come up with the information in this Negotiation
91. ther Districts o An Array School will not be able to see any of your Staff Information they will only see their own Staff s Information o Similarly you will not be able to see the Staff information for any other districts you will only see your own Staff Members placed against the CSF values from the Array Schools o Again the Staff Information you provide will only be available to your district not any other schools e Use the Staff Information link in the page header to access these pages o The Staff List page described below will display first o This header displays at the top of the Staff List page and these buttons and features will be described first Add New Staff Member 2 Quick Education Updates D G Import Staff Information El Only provide information for staff members that should be included in the negotiations which would be those that are in the certificated bargaining unit K 12 Mo Staff information will be available to other Districts It is solely used to place your staff at other Districts in the Negotiations module Import Staff Information Import Files Staff Members Choose File No file chosen Download an import template for Staff Members here Educational History Choose File No file chosen Download an import template for Educational History here Wew more information on how the import works in the sections below The information below includes the fields Maes l Perform Import requ
92. tion Worksheet described above Summary Information Hi A Costs 233 09 Cash Options 10 280 00 FICA for Cash Options 839 97 Other Insurance 6 559 43 Total Benefits 18 708 49 e This summary section contains all the amounts that add up to the Benefit Costs on the Midpoint Analysis page e Inthis table Cash In Lieu costs are separate from the costs of the regular insurance Other Insurance LIFE 0 00 VISION 0 00 LTD 1 757 36 1 757 36 e This section expounds on the Other Insurance entries e The values that combine into the Other Insurance costs are individually listed here even if they are not offered by the district e Other sections like the Additional Cash Payments section or the Additional Benefits section may display if they are offered by the Subject school or one of the Array Schools 55 Page Copyright O 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 56 Additional Sections Cash Additional Amount 0 00 Hiring Bonuses 46 475 24 Cash Annuity Amount 452 709 12 Tuition Reimbursement 0 00 Cash Other Amount 0 00 Employee Fringe Benefit 0 00 452 709 12 Dependent Fringe 0 00 Benefit 46 475 24 e Sections like the Additional Cash Payments and Additional Benefits sections are displayed when these amounts are used by the Subject School or an Array School H A Benefit Information H A BENEFIT 500 Deductible INFORMATION CIL Option 4 FTE B
93. trict in the Array Schools list o Second click the Remove button located in between the two lists o The district is removed from the Array Schools and added to the bottom of the Available Districts list o This district will not be included in the Reports unless it is re added to the Array Schools list e The Sort button located above each list will re sort the appropriate list alphabetically o The districts included in either list will not be changed o Only the list below this button is sorted the other list remains the same though you could click its Sort button too e The Print button located above the Array Schools list will open a new printer friendly window tab listing all the Array Schools included in this list A sample of this page is displayed below Even if this list is a previously saved Array School Group the Group s name will not be displayed here to get the Group name on the printout use the print button from the Load Previously Selected Array Schools form described below Bronng Davenport Untied System Exeter Milligan Public Schools McCool Junction Public Schools Mendian Public Schools Shickley Public Schools Superior Public Schools Sutton Public Schools Thayer Central Commuruty Schools e The Save button located above the Array Schools list displays the Save Selected Array Schools form described below o
94. vices Inc All Rights Reserved North Star Negotiations User Manual Page 49 Summary Information SUMMARY INFORMATION Array School Contract Days 185 e The Summary Information section contains values calculated using the Subject School s Staff Information and this school s CSF data Deia 182 which could be the Subject School or an Array School Contract Days e This section includes more detailed values than those displayed FTU s 100 00 hd i on the Midpoint Analysis page described above PIES ER e The Adj values on this page are adjusted for the difference in Staff Index 142 7715 Contract Days between the Subject School and the Array School like on Salary Costs 4 550 841 93 the Midpoint Analysis page e 346 306 80 o These rows are only displayed if the Array School has a different number of Contract Days than the Subject School if the days Retirement dar 56 08 are the same then the values are not actually adjusted so the rows are Other Insurance cese aa not necessary Reimbursable can e Other rows like Reimburseable Deductible Amount in the AE enc examples below will only display when one or more of the districts Hi A Costs 1 002 431 03 Subject or Array in the calculations contain values even if the district Total Benefits 1024 644 12 for the page you are on does not have this value Total Compensation Reimbursable Deductible Reimburseable 6 368 949 62 187 50 0 00 Costs Amount Deductible Amount
95. you add the slower the calculations will run e The page is loaded with all your district s current values This information comes from the CSF This information is organized into sections that are explained here e Changed Data Rows and the values calculated from them are displayed on the Midpoint Analysis page Basic Info Basic Info Manually set the Base Salary ica Flat Salary yearly amount 0 00 Contract Days 182 24 Staff Index 139 162 w Default 1 Year 2 h 5 e By default the program will Automatically calculate a new Base Salary based on the changes made via this page o Automatically calculating a new Base Salary will be the most common choice o When you are adding or adjusting benefits via this page the Base Salary should be Automatically calculated o Automatically calculated Base Salaries will adjust according to the selected Percentile o Manually setting the Base Salary is discussed below e The Flat Salary amount is added to the salary after the Salary Schedule portion has been calculated FICA and Retirement will be calculated off of this amount e If you increase or decrease the number of Contract Days you should Automatically calculate a new Base Salary so the program will re adjust the Array Schools to the new number of Contract Days This will not change the Array School Comparison Information section of the Midpoint Analysis page which will continue to use the value specified in the CSF the adjustme
96. your previously saved groups of Selected Array schools Just select the name of the group and click the corresponding button below Array School Groups all schools 4 0 Load Array Schools Delete Group Cancel e The Array School Groups drop down includes the names of all the previously saved Array School Groups e To load a Group select it in the drop down then click the Load Array Schools button e To permanently delete a Group select it in the drop down then click the Delete Group button A confirmation message will display before the Group is actually removed e The Print button next to the Array School Groups drop down will open a new printer friendly window tab listing all the Array Schools included in this Group A partial sample of this page is displayed below showing the Group name on top with the array districts following all schools Adams Central Public schools Amsworth Community Schools e Allen Consolidated Schools Aliance Public Schools Alma Public Schools Amherst Public Schools Anselmo Merna Public Schools Ansley Public Schools Arapahoe Public Schools Arcadia Public Schools Arlington Public Schools a Arnal Dih h Arahal 41 Page Copyright 2013 2015 Nebraska Education Technology Services Inc All Rights Reserved North Star Negotiations User Manual Page 42 Group Midpoint Analysis Array School Counts Calculated Values Array School Group

User Manual. - North Star Negotiations

Contents

Download Pdf Manuals

Related Search

Related Contents