You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialize correctly.
Notes
Play with a live Demo and get the code
Installation instructions:
- In an Apps Domain Google Site (sorry, works for Apps Domains ONLY), go to "More->Manage Site->Apps Scripts->Add new script" and copy and paste the script below into the script editor.
- Be sure to delete or paste over any existing lines of code in the code editor.
- Run the function "doGet" and authorize the script to run as "any domain user."
- Save the script with a name you will recognize later
- Create a Sites page or use an existing Sites page and insert an Apps Script Gadget.
- Insert->Apps script gadget
- You will see the script listed. Select it.
- Adjust the pixel dimensions, title, and settings as needed. You can eliminate the gadget border if you want.
- Refresh the browser. The first time your page loads, it will generate a copy of my starter spreadsheet to go with the script. If it gives an authorization error, do step 3 again.
- Play around with it. Change the template. Practice the tagging conventions. Build a new chart.
- I only recommend bringing your data into the provided starter spreadsheet once you are comfortable with how it's working.
- Once you have populated the data sheet and template with real values, return to the script and set the TEST_MODE variable to 'false.'
- Try assigning a row of data to your own email address so you can see if it is working in student (non-power user) mode.
- Populate the power user sheet with the emails of people who ought to have that level of access.
Security Note: The script is written to default to an "Access denied" note when a user is not listed in the data sheet or the power user sheet. Nevertheless, I recommend using sharing settings to restrict who can view the Sites page to your specific audience as an added layer of protection.
Push my thinking
How are you using the Reportlet Script in your school? Pay me back for my work by posting a hack to show it off! What doesn't the Reportlet do that it currently do that it could be modified to do?
Comments
rePortlet Script: Individualized data reports in a Google Sites Page
Published: 01/26/12
License: 
Views: 1,980
Problem of practice
How do you give students, teachers, and parents a private view of live, individualized reports without locking into a rigid, expensive commercial portal?
Solution
The Reportlet Script, written in Google Apps Script, serves up easily-templated tabular reports that can include custom data, images, and charts keyed to the logged in user. Power users get a dropdown to allow viewing of any report.
Cast your vote
Tweet this
Post to TwitterBrowse other items with similar tags
This is an attempt to create a simple tool that a team of teachers could use to track indicator-level data on shared assessments. It's low-stakes, hopefully approachable and can be customized to fit the team's needs.
Recommended by 8 educator(s).
The formMule (aka "The Mule") is a Google Apps script that is useful for automating lookups, emails and calendar events created dynamically from Google Forms.
Recommended by 31 educator(s).
This is a simple script housed in a google sheet that allows teachers to create handouts for their classroom, shares the student appropriately and organizes the handouts in a collection. It can be used to create sheets as well as docs.
Recommended by 12 educator(s).
This hack shows how to install a Google Apps Script in your Google Site to look up the grades of the currently logged-in student or parent and generate a live bar of progress from your Google spreadsheet!
Recommended by 13 educator(s).
This introductory module provides what you need to start building the modular and lightweight data system of your dreams. The first installment is a "Lateness Zapper" that automates logging, communications, and reporting on student lateness.
Recommended by 17 educator(s).
Using a script stolen from another project and a student template, this platform will allow a teacher to enter in their classroom roster, hit a button and automatically create goal setting sheets for their class and monitor their students' progress!
Recommended by 6 educator(s).
Written by an educator for educators, the free doctopus script gives teachers the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects.
Recommended by 99 educator(s).
powered by educators
empowered by
Many Thanks!
I just discovered youpd last night and downloaded your script today. I've really just started playing, but it looks like it could be a real killer app for me. Before I start tinkering with the code (and learning far more than I know right now) have you already looked at doing this for an actual assignment by assignment gradebook?
We're going one to one ipad next year, and I've been looking at grading workflow and whether it makes sense to continue to use an application that resides only on a desk top (currently Micrograde which has lots of features I like) and sync via cloud services, migrate to a web only app with the risk of having no access to my gradebook at a crucial moment, or consider other possibilities like your script or possibly simply pairing a really well designed gradebook spreadsheet with some kind of mail merge.
Thank you so much for providing such useful tools (I love Doctopus, too, about which we had professional development a couple of weeks ago.)
The load time on this has been drastically reduced.
Good news! I found a major time saver in my code that reduces the load time on reloads of the report via the dropdown (the initial load time is unchanged, but the refresh time is MUCH less).
Wow
I'm still wrapping my head around this, but....wow....
So, what if power users had the ability to group students - which I guess could happen in the spreadsheet pretty easily - just add a column for the various groupings to assign. And then select those groupings and filter based on the assessments, or assessment indicators (the columns). If that could happen, then you pretty much created ARIS local....for free...
Power User Student Groupings
Hi Evan,
Your idea to enable power users to group students is pretty much what I wanted to do when I first saw Andrew's rePortlet. I'd like to have power users with advisory groupings so that, when an advisor is the logged on user, the pulldown menu only sees his/her 15 or so advisees. Is that what you were thinking?
David
Groupings
That's kind of what I was thinking - it woud certainly be helpful. I was actually thinking that the teacher would be able to see their 30 or so students, but then select from a grouping dropdown (say select ESL) and see a list of those 7-8 ESL students and the charts would change to reflect that grouping. I'm wondering though if it's necessary to have the web-interface for this. You could do something pretty easily with a tracker spreadsheet for the teacher - the web interface is fantastic for being transparent to the end-users, but they don't need to know grouping data/info.
Groupings
Hi Evan, I like the idea of filtering the data for certain characteristics. I agree that this is pretty easy to do in spreadsheets and might be too cumbersome to build into this webtool, especially since it loads so slowly.