Jump to content

ProgressoGeek

Members
 View Profile  See their activity

  • Posts

    24

  • Joined

  • Last visited

 Content Type 

Blog Entries posted by ProgressoGeek

  1. ProgressoGeek

    Who's on Report Today?

    By ProgressoGeek,


    Dashboards
    As a teacher you may often hear the phrase "Can you sign my report card". However, this is usually at the end of the lesson, but would have been more helpful if mentioned at the start.
    Well here's a Progresso widget that may help teachers know who's actually on report based on the teachers timetable. It will highlight the current lesson too.
     

    http://3.bp.blogspot.com/-J73qRVZGxi0/U_SBYq9r7qI/AAAAAAAAAzw/VKVE5kDKhgE/s1600/SPLW10%2B-%2BOn%2BReport%2BToday.PNG

    Download

     
    A pre-requisite for this widget (apart from the selected member of staff having a timetable) is the creation of an Ad-hoc group.
     
    Simply create an Ad-hoc group called "On Report" and assign the relevant learners to that group. Alternatively, if you want to have a weekly on report log, create an Ad-hoc group with the suffix "Week XX" (e.g. "On Report Week 01") and set the start and end dates of the group to that week. The widget will only list the learners in active Ad-hoc groups so you can set-up next weeks learners who are on report in advance.
  2. ProgressoGeek
    Want to know how many of each SEN category in the school you have? You can also expand the SEN type as seen below to view which learners have that SEN type. Here you can see that the name has been set to a hyper link that allows you to go directly to their profile from the widget. Notice also that the same colour idea has been carried forward with the review dates as seen with the SEN Summary and Review Reminder widget.
    http://4.bp.blogspot.com/-1YNW8WfFQsQ/UzVxrPIiDSI/AAAAAAAAAso/rauXkxfrmIA/s1600/SPLW04+-+Learner+SEN+Summary.gif

    Download

  4. ProgressoGeek
    There's nothing wrong with a bit of competition and here's a widget that will allow you to tally up the positive behaviour points for a date range by House and Year.


    Why not create a dashboard with 3 of these widgets configured to show the dates of each term.
     



    http://1.bp.blogspot.com/-QqfiXcDqlC8/Ux9MjiE4GJI/AAAAAAAAApY/SXEfdjwM3ZM/s1600/SBEW01+-+Behaviour+League+Table+By+House.PNG

    Download




    A slightly different version by reg group and gender.
     



    http://1.bp.blogspot.com/-E6Sw3EApir0/UyGpHuXb2aI/AAAAAAAAAp0/JehOZVi5Ckw/s1600/SBEW08+-+Behaviour+League+Table+By+Reg+Group.PNG

    Download

  5. ProgressoGeek
    Form tutors, with great ease this widget will allow you to view the attendance percentage for your tutees, even providing a ranked list. Why not try and encourage some healthy competition!

    Alter the parameters/settings appropriately and this widget will also be great for Head’s of Year to keep an eye on all their learners without constantly reviewing attendance reports each week or even less regularly. Perhaps at the end of the year or each term, your SMT could view all the learners and easily identify and reward those at 100%. Remember every day counts!
     

    http://4.bp.blogspot.com/-RPd_1aF5rnk/UwzFSScfY5I/AAAAAAAAAoY/1NTxJ4UHGBQ/s1600/SATW02+-+Learner+Attendance+Percentage+by+Reg+Group.PNG

    Download

  6. ProgressoGeek
    View today's, yesterday's, or the last 7 day's behaviour by registration group. In fact, add the widget twice to show positive and negative events. Or even create a SLT/SMT Behaviour Dashboard showing summary behaviour for each year group.

    Build relationships further by commenting on positive behaviour in other classes. Make students aware that you know if they've had a poor lesson and provide support/sanctions.
     

    http://2.bp.blogspot.com/-M8puTfaRllE/UvkiGNhNf2I/AAAAAAAAAiY/odFuuw5q73Y/s1600/SBEW02+to+04+-+Behaviour+Summary+By+Type.PNG

     

    Download (Today's Summary)

    Download (Yesterday's Summary)

    Download (Last 7 Day's Summary)

     

    Update: Added 3 versions for schools with vertical reg groups

    Download (Today's Summary)

    Download (Yesterday's Summary)

    Download (Last 7 Day's Summary)

     

     

     



  7. ProgressoGeek

    Staff Utilisation Report

    By ProgressoGeek,


    Reports
    Want to know the total hours timetabled for a selection of staff across a date range? Well here's a report that can help.
     

    http://1.bp.blogspot.com/-RkJDSGnduIE/UvX_Ku5s8PI/AAAAAAAAAh0/8BHbVZf01GE/s1600/STTR01+-+Staff+Utilisation+%2528Landscape%2529.PNG

     

    http://1.bp.blogspot.com/-QQgrNBHaY9o/UvX_K4hRvaI/AAAAAAAAAh4/HkcxlxFIURI/s1600/STTR02+-+Staff+Utilisation+%2528Portrait%2529.PNG

    Download (Landscape Version)

    Download (Portrait Version)



  8. ProgressoGeek

    Cluster Reporting Widgets

    By ProgressoGeek,


    Dashboards
    I've had to revisit a number of my widgets so that they can also run at cluster level for individual schools within the cluster. A few hours work but it was worth the effort.

    Below is a Progresso Cluster User Dashboard which uses 2 widgets (previously posted on this blog) but the establishment parameter in each widget points at a different school within the cluster. Hey presto! I can see a summary of a number of schools on a single page.



    http://4.bp.blogspot.com/-zf-_F_4Oky4/UrIua_Tfl9I/AAAAAAAAAc0/IxIYAbkg8qA/s640/Cluster+-+Dashboard+2.PNG

     



    But what about viewing many schools data within a single widget you ask? Well I call those true cluster widgets. The establishment parameter in these type of widgets is a multi-choice field, so you can select just the schools you want (e.g. only the primaries within my trust, or just the secondaries as displayed in the dashboard below - Starters and Leavers).



    http://4.bp.blogspot.com/-O7qODgpQOR4/UrI4OezKmcI/AAAAAAAAAdY/eRd0RpYvL7Y/s640/Cluster+-+Dashboard+1.PNG

  9. ProgressoGeek

    Attainment vs National Average

    By ProgressoGeek,


    Widgets
    As an ex-teacher I remember having access to key information at the right time was always challenging. If I've entered the current assessment levels why can't I easily see it without having to navigate through the system?

    Well here's a widget that just might help with that.

    The Attainment vs National Average widget allows a user to select an assessment point (e.g. Year 4 / Autumn 1 / NC Level) and compares it to a specified level (e.g. National Average). The widget will produce a summary of the subjects with data recorded and identify the number of students that are below, at or above the set value. Furthermore, each subject can be expanded to show the individual students and their point difference.

    The image below shows part of a dashboard that contains 2 of these widgets showing Autumn 1 and 2 entry points. This provides a quick view to see what levels of improvement has been made over the term.
     

    http://1.bp.blogspot.com/-PNp57j31-Mw/UrH-hZYgpBI/AAAAAAAAAWQ/Gw-rq9eWwPo/s320/SASW01+-+Point+Score+vs+National+Average.PNG

    Download

  10. ProgressoGeek
    With so much going on at schools today, it's easy to miss things. So why can't your MIS remind you?


    Here's a simple little widget that lists the SEN reviews in chronological order and highlights any that have gone past their date (in red) and the ones to be done in the next 3 weeks (in green). Oh, and if the learner doesn't have a review date then these are also highlighted (in grey).
     



    http://2.bp.blogspot.com/-UK66Tt-eQ5E/UrH-kgvCtBI/AAAAAAAAAXk/XXqxMjyzfQo/s320/SPLW05+-+Learner+SEN+Reviews.PNG

    Download

  11. ProgressoGeek
    Not all data in Progresso is manually entered. What about all that information collected in the logs?

    I wanted to see if I could easily view who was logged on so I built this simple widget which looks at today's users and calculates how long they have been using the system.

    It's surprising what other data is stored, such as the IP address. This gave me the idea to try out the SSRS feature to launch an external URL. So if you click on the IP address a new window will open that showing the users login location (that's if it's not hidden).
     

    http://1.bp.blogspot.com/-piFn-PbaOUs/UrH-k9U33qI/AAAAAAAAAXg/bB4GYPWdt7c/s320/SSYW01+-+Todays+Logins.PNG

    Download

  12. ProgressoGeek

    Happy Birthday to you

    By ProgressoGeek,


    Widgets
    Did you know that your MIS can help remind you of those really important dates?


    Why not add the "Todays Birthdays" widget to your dashboard and set the parameters just to look at your Form/Tutor/Registration group.


    Btw, the widget only looks forward 7 days and the highlighted row is the current day.
     



    http://1.bp.blogspot.com/-7_v3_hO0QFo/UrH-jbAjveI/AAAAAAAAAXQ/x9I3xDp5KSg/s320/SPLW03+-+Learner+Birthdays.PNG

    Download

  13. ProgressoGeek

    Roll Call with Extra Column

    By ProgressoGeek,


    Reports
    "Yes, we know Progresso can easily take registers, but we want a paper version because we've not given our teachers access yet."

    A good point made here, and Progresso's roll call maintenance feature makes quick work of bulk entry from the completed forms.

    Also, because this question came from a primary school, we added the option of an additional column to be included (such as Lunch choice).
     

    http://4.bp.blogspot.com/-JMswB4W4P-U/UrH-hnEh7KI/AAAAAAAAAWY/9iPDJpjphGY/s640/SATR01+-+Roll+Call+Capture+Form.PNG

    Download

  15. ProgressoGeek
    I wanted to have an attempt at using the expand (show/hide) feature in SSRS so I wrote this little widget to summaries the total learners by category (Free School Meal, Gifted and Talented, Looked After Children and Pupil Premium).

    It consists of 3 tables, the 2nd and 3rd being a summary by gender. By clicking on the + you can expand or shrink each table.



    http://1.bp.blogspot.com/-X8VC6jb76jc/UxCKm9uEjlI/AAAAAAAAAo8/NSGlakHt2do/s1600/SPLW01+-+Learner+Categories+Summary.PNG

    Download

  16. ProgressoGeek
    Here's a simple A4 landscape learner list report that uses the selected theme to define it's heading and highlighted colours.

    Parameters include Academic year, Group Type and Group Code.



    http://4.bp.blogspot.com/-3EyQGEaKA4o/UrGPv4E4sQI/AAAAAAAAAVA/sHrkjKlPe5E/s640/SPLR01+-+Learner+Details.PNG

    Download

  17. ProgressoGeek
    After 2 days of training in SQL Server Reporting Services (SSRS) I have now written my first report.
    I wanted it to be useful but also to keep it simple what with it being my first venture into SSRS. As any of you who work with school's MIS databases will know the many different types of data that is recorded, so I decided to go for a report based on learner data.
    Also, I love the fact that you can place these reports within a widget on a users desktop. So as soon as a user logs on, POW! there's the information.
    Anyway, the report lists the different Ethnicity of the learners currently at the school. It also makes use of the 'Databar' feature which is a nice graphical way of viewing amounts.

    http://3.bp.blogspot.com/-5_20leKcA3M/UrGZjv4C_TI/AAAAAAAAAVk/fnbUaU1yYTo/s1600/SPLW02+-+Learner+Ethnicities+Summary.PNG

    Download

×
×
  • Create New...