ProgressoGeek

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.

I would recommend you register for the Firstline support site where you can download all training guides, received the latest news and access the user forums. 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

What’s SIMs???? This is a standard report which has been set up in Progresso. Information like this can be provided via reports or the parental/pupil portal facilities in Progresso – it’s available from any location as Progresso (by Advanced Learning) is a cloud based solution.

Can you let me know who you've sent it to at Advanced Learning thanks.

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

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

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)

Hello Dawbs, There are pre-made cluster widgets already available for use at cluster level, and further system widgets from the support website. These can be uploaded and shared to any of the schools within the cluster. You can also create extra widgets (either based on existing ones or from scratch). Level 1 & 2 SSRS training should be sufficient to create or reinvent existing reports to tailor for your needs. To see a cluster widget taster have a look at my blog located within my signature. Kind regards, @ProgressoGeek

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)

In response to the original post, Progresso's data architecture is one of multiple schools under a single cluster. This approach allows for additional MIS functionality, such as pushing reports to individual schools within the cluster, managing system settings/users accounts/learner records e.t.c without the constant logging in and out of each school, plus the ability to report on all the data within each school without the need for 3rd party interfaces to name a few. If it helps, here's an example of a cluster dashboard.

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

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

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

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

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

"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

Another simple list report which lists learner contacts by group and priority filter. List all associated contacts or just the ones with above a priority level. http://3.bp.blogspot.com/-0twj4Jwy2RA/UrH-iqT2YEI/AAAAAAAAAWs/oQqFKVixgOE/s640/SPLR03+-+Learners+and+Contacts.PNG Download

Learner contact details (phone & email) by group type and priority. [A4 - Landscape] Download

Hi all. Great idea for a thread Mark. Here's a simple learner list by group report (A4). It includes the logo and colours based on selected theme. Download

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

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

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