Login Deets Stickers / Mail Merge?

[Joanne]

I've just been asked if all the children can have a sticker to put their Mathletics and Bug Club logins on.

 

Basically... what's the best way to do this? I have the stickers and the sticker template in word. Do I need to create a spreadsheet with each childs name, login for mathletics, login for bug club then on the word document do a mail merge field on each sticker?

 

Mathletics has a sticker printing tool, but unfortunately it doesn't line up with the stickers properly and they can't fix it. LAME!

 

How would you tackle this?

[Techie2000]

I found the templates in Word are iffy - we tend to download the templates from the label vendor. The biggest thing I noticed was that the J8160 labels from within SIMS for the 21-per page perfectly whereas the mail merge equivalent of the J8160 in the Labels Mail marge template are half off each label.

[sted]

that's basically what I do a sheet full of name login name passwords etc on just use one of the built in avery label templates in word. I just print them onto std a4 and run em through the guillotine to do cards then teachers can laminate if needed or I can just reprint them rather than using actual stickers

[LosOjos]

Before I start, I know this is not an ideal world and ultimately you're going to have to do what you're told, however...

 

I'd argue the case that you absolutely shouldn't do this. In an increasingly digital world, I feel we should be educating children best practice from day one - that means not writing down your login details and sticking them somewhere anyone can find them. Even making their passwords very simple (I know it can be tricky with young children) so that the teacher can work it out based on something as basic as their surname, teaching them to remember passwords and not share them is important.

 

My 2p

[Joanne]

Yeah I would be bothered normally, but mathletics logins are randomly generated.

 

I've done the card thing before, but pieces of paper get lost... although they could just stick them in. Doesn't help my bug club situation because they don't do login cards....

 

It's frustrating, but I know I'd have more work on my plate if the children were made to remember their logins... I put a list on staff shared, but da peeps don't get it!

[Alis_Klar]

sorry to butt in but can anyone shed light on using F9 braces in word to insert a page break after every class. Other wise you get a class page half way through a page which is a bit un professional.

 

Force each new category to a new page

As in the previous example, the key field in this example is { MERGEFIELD City }. When the value of CITY changes in the data file to a different city, a new page is added to the merged results, and the merge is continued at the top of the next page. To insert the field braces, press CTRL+F9.

 

{ If { MERGESEQ } = "1" "{ MERGEFIELD CITY }¶

" ""}{ SET Place1 { MERGEFIELD CITY }}¶

{ If { Place2 } <> { Place1 }"¶

----------------------------Page Break--------------------------------

{ MERGEFIELD CITY }¶

¶

{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶

 

Note To insert a page break, either press CTRL+ENTER, or click Break on the Insert menu, select Page Break, and then click OK.

from https://support.microsoft.com/en-gb/kb/294686

 

Also found this video but its not great and talks about directory merge rather than label

 

[jmak]

Before I start, I know this is not an ideal world and ultimately you're going to have to do what you're told, however...

 

I'd argue the case that you absolutely shouldn't do this. In an increasingly digital world, I feel we should be educating children best practice from day one - that means not writing down your login details and sticking them somewhere anyone can find them. Even making their passwords very simple (I know it can be tricky with young children) so that the teacher can work it out based on something as basic as their surname, teaching them to remember passwords and not share them is important.

 

My 2p

In principle you're right, but I think there needs to be a bit of compromise to make the classroom work for learning stuff other than good password practice. We put passwords on cards for the kids to use, but tell them to treat it like a toothbrush - I.E. don't share them.

 

And I really hope that passwords aren't a thing by the time this generation of infants leave school. It's a broken technology IMO

[Joanne]

Yeah we should be retina scanning by now

[sted]

Yeah we should be retina scanning by now

 

be cheaper to tattoo a barcode on their arm