Machines PBL project

The Google Doc below is a PBL project that we created based on the work at the youtube chanel Mini Gear - below is a video of a most excellent candy dispenser. 

This was largely created by John - let him know what you think.

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

Thanks for looking and if you have any questions comment, tweet us at @mr_van_w,  or send me an email at catfisheducation@gmail.com

REPORT COMMENT WRITER

Here is a report writer and comment bank that I put together in a mad fit of procrastination.

Report Writer Link

If you prefer here is an Excel version (Report Writer).

It is a Google Sheet with linked sheets. The first sheet is the Report Writer with it has a column for the name of the student and then columns for drop-down menu selection of the comments. I find this structure really useful for making sure that I hit all the points I want to in a report. The final column uses the =CONCATENATE(string 1, " ", String 2, " ", ...) function to string all the different cells together in a coherent (as much as my reports are ever coherent) fashion. Not the " " places a space between the comments (Google Sheets - like Excel - removes the space at the end of the text in the cell).

The drop-down menus come from a "Data Validation" where the list is a data range from Sheet 2. This data range is populated with cannibalized comments from previous reports.

Please feel free to share and use this as you want. I've set the link to view only which means you should be able to make a copy of it to edit and play with yourself.

EDIT: Our school has some fairly aggressive limitations on characters in reports. You can use the conditional formatting with a custom rule to ensure that the cell with the final comment changes colour if it goes over the limit.

600 characters are our limit, therefore using a "custom rule" I've used the command "=Len(H2:H)>600" where "Len" is length, H2 is the first cell and I want this to be present in all H column cells after this.


This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.

 

Thanks for looking and if you have any questions comment, tweet us at @mr_van_w,  or send me an email at catfisheducation@gmail.com