School census autumn 2010
This presentation is the property of its rightful owner.
Sponsored Links
1 / 81

School Census Autumn 2010 PowerPoint PPT Presentation


  • 68 Views
  • Uploaded on
  • Presentation posted in: General

Jim Haywood Product Manager for Statutory Returns. Version1.0. School Census Autumn 2010. Preparation. 1. School Census Autumn 2010. Learning Aims (Schools with 6 th Forms only). 2. Learning Aims. A. Taking account of any new classes.

Download Presentation

School Census Autumn 2010

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


School census autumn 2010

Jim HaywoodProduct Manager for Statutory Returns

Version1.0

School Census Autumn 2010

Preparation

1


School census autumn 20101

School Census Autumn 2010

Learning Aims(Schools with 6th Forms only)

2


School census autumn 2010

Learning Aims

A. Taking account of any new classes

  • Step 1: Ensure that any new post 16 classes defined in Nova-6 have the same subject and level combination as existing classes delivering the same course.

  • Step 2: Run Curriculum Matching in Nova-6. This will use the subject and level combination to link the new classes to existing courses or to create new courses as necessary.

3


School census autumn 2010

Learning Aims

B. Taking account of multi-year Learning Aims

  • Step 1: Identify which courses have members that will continue taking the course beyond the current academic year, these would include courses for International Baccalaureate and Diploma Learning Aims.

  • Step 2: Ensure that End Date and Planned End Date are correct for these courses and that they are protected from Update Course Membership.

4


School census autumn 2010

Learning Aims

C. Maintaining Course Membership information

  • Step 1: Make sure that the membership of classes reflects reality in terms of who is a member of the class and when their membership begins and ends (or is expected to end)

  • Step 2: Run Update Course Membership to ensure that course memberships reflects class memberships.

  • Step 3: Use Maintain Courses to update courses and course memberships that have been protected from the timetable and/or class membership (2 year courses).

5


School census autumn 2010

Learning Aims

C. Maintaining Course Membership information

  • Step 4: Take account of Re-sits by using Maintain Courses to add students and give them End Dates in line with the date of the examination – don’t forget to protect from Update Course Membership.

  • Step 5: Enter the completion status for any course membership that has finished prematurely – actual and planned end dates should have been calculated automatically be Update Course Membership

6


School census autumn 2010

Learning Aims

D. Check/Update Students’ Course Information

  • Step 1: Check students courses using Focus | Student | Courses or Focus | Student | Student Details (Courses Link)

  • Step 2: Use the links in the above functionality to open the relevant course in Maintain Course and update as necessary

7


School census autumn 2010

Learning Aims

E. Take Account of QAN/Discount Code Changes

  • Step 1: Download latest files from DfE QWS site https://data.dcsf.gov.uk/qwsweb/(S(fmajzr3pmtmb0045pctxjkmm))/default.aspx

  • Step 2: Use the downloaded files to update the QAN catalogue (Statutory Return Tools | Update DCSF QAN Catalogue). Ensuring that you import the Current.xml last.

  • Step 3: Use Exams base data to update course classifications (Statutory Return Tools | Update Course Classifications from Examinations Data)

8


School census autumn 2010

Learning Aims

E. Take Account of QAN/Discount Code Changes

  • Step 4: Import any QANs and Discount Codes that are needed but have not been put in place by Step 3 above (Statutory Return Tools | Import QAN and Discount Codes for Course Manager)

9


School census autumn 20102

School Census Autumn 2010

Bulk Update Course End Dates

10


School census autumn 2010

New to the Autumn Census

Bulk Update for Course End Dates

New functionality to allow bulk updating of course end dates to avoid August end dates and to take account of mistakes in expected end dates for leavers

11


School census autumn 2010

Bulk Update Course End Dates provides the best solution for multiple Learning End Date errors

12


School census autumn 2010

This first panel is about ensuring that courses don’t finish in August. Obviously, courses don’t actually finish in August, but more important, if a DfE school indicates that Learning Aims are completed in August they are likely to lose funding.

13


School census autumn 2010

Click to run a report to show the changes that would be made if this bulk update is carried out

14


School census autumn 2010

Click to run a report to show the changes that would be made if this bulk update is carried out

The Learning Aims End Dates would change from 31/08/2011 to the 31/07/2011 which would then meet DfE requirements

15


School census autumn 2010

Click to carry out the bulk update and to obtain a report of the changes made

16


School census autumn 2010

These changes should be marked as sent in error by the previous Census

Not only have the course membership end dates been updated, but the new end dates have been applied to the class membership end dates. This ensures that Update Course Memberships will not undo the changes made to course membership end dates.

17


School census autumn 2010

You can still back out even at this late stage.

18


School census autumn 2010

This second panel is about ensuring that pupils who leave between May and August are recorded as having completed the course. This is necessary where schools have used Nova T6 and/or Academic Management to set class membership end dates that are later than is actually planned.

19


School census autumn 2010

Click to run a report to show the changes that would be made if this bulk update is carried out

20


School census autumn 2010

Click to run a report to show the changes that would be made if this bulk update is carried out

The Learning Aims Planned End Dates would be brought in line with the date the student left and the Completion Statuses would change from Withdrawn to Completed

21


School census autumn 2010

Click to carry out the bulk update and to obtain a report of the changes made

22


School census autumn 2010

These changes should be marked as sent in error by the previous Census

23


School census autumn 2010

You can still back out even at this late stage.

24


School census autumn 2010

Click to close the bulk update facilities

25


School census autumn 2010

This is the last chance to back out the changes

26


School census autumn 20103

School Census Autumn 2010

Duplicate QANs

27


School census autumn 2010

Click to run the Duplicate QAN report

28


School census autumn 2010

The report includes a row for each course with a QAN/Discount Code that has also been used by one or more other courses.

29


School census autumn 2010

In this case the same QAN/Discount Code has been used for AS English as for AS English Language, which is unlikely to be correct.

30


School census autumn 2010

In this case there are two types of issue as the QAN/Discount Code has been used for different subjects and different levels.

31


School census autumn 2010

In this case the same QAN/Discount Code has been used for an A-level and an AS-level, which incorrect.

32


School census autumn 2010

In this case the same QAN/Discount Code has been used for CDT Design & Comm and CDT Design & Real, which is unlikely to be correct.

33


School census autumn 20104

School Census Autumn 2010

Reconcile Learning Aims & Results

34


School census autumn 2010

New to the Autumn Census

Reconcile Learning Aims and Results

New functionality to help schools gauge if the information used for declaring Learning Aims could result in under funding

35


School census autumn 2010

We don’t claim to know exactly how the DfE will use the Learning Aims information provided in the Census for allocation funding, but we have worked with the (old) LSC to identify possible issues with a school’s Exams and Learning Aims information that could make it difficult for the DfE to match Learning Aims with results. Without such matches the DfE will be unable to reflect success rates in funding.

36


School census autumn 2010

Click to create the reconciliation reports.

37


School census autumn 2010

Click for a drop down of the available years

38


School census autumn 2010

39


School census autumn 2010

Click to choose the folder to hold the CSV files

40


School census autumn 2010

41


School census autumn 2010

Click to create the CSV files

42


School census autumn 2010

Message indicates that the CSV files have been generated and saved successfully

43


School census autumn 2010

This CSV file has been designed to show instances of Learning Aims that will be declared in a Census, but for which we have not been able to find a corresponding exam result.

44


School census autumn 2010

45


School census autumn 2010

This CSV file has been designed to show instances of exam results where we have not been able to find a corresponding instance of a Learning Aim that will be declared in a Census

.

46


School census autumn 2010

47


School census autumn 2010

This CSV file has been designed to

indicate where exam results are matched with Learning Aims on all factors other than QANs.

.

48


School census autumn 2010

Exam QAN is 5002640 ..

.

The QANs don’t match

.

.. while Learning Aim QAN is 1003630

.

49


School census autumn 2010

Exam QAN is 10008342 ..

.

The QANs match

.

.. and Learning Aim QAN is also 10008432

.

50


School census autumn 2010

This CSV file has been designed to

indicate exam results with QANs that don’t exist for Learning Aims or exist for Learning Aims where those Learning don’t match with exam results for other factors.

.

51


School census autumn 2010

52


School census summer 2010

School Census Summer 2010

Hours at Setting

53


School census autumn 2010

Click to update hours for 3 year olds

54


School census autumn 2010

Autumn is is the first term of the Academic Year so no attempt is made to default to hours entered for the Summer Term

2.55

55


School census autumn 2010

Double click to enter the hours for an individual pupil

56


School census autumn 2010

Type the number of hours as a decimal

57


School census autumn 2010

Entering 12.6 is not allowed as only increments of 0.5 are allowed

58


School census autumn 2010

Right Click for options

59


School census autumn 2010

Reset All will zero all of the Hours at Setting in the browse

60


School census autumn 2010

Right Click for options

61


School census autumn 2010

Select All will select all pupils displayed

62


School census autumn 2010

Click to enter the same number of hours for all highlighted pupils

63


School census autumn 2010

Enter the number in the same way as for an individual entry

64


School census autumn 2010

The number is automatically entered for all the highlighted pupils

65


School census autumn 2010

Click and then Shift Click can be used to highlight a group of consecutive pupils

66


School census autumn 2010

2.67

67


School census autumn 2010

Control Click can be used to highlight a group of non-consecutive pupils

68


School census autumn 2010

69


School census autumn 2010

70


School census autumn 2010

Click to save the changes

71


School census autumn 2010

Autumn has been auto selected, which means that the list will include all pupils who were three years of age on the 31/08/2010.

72


School census autumn 2010

We can filter by Year Group

73


School census autumn 2010

By Reg/Class

74


School census autumn 2010

Status can be particularly helpful as it provides a way to identify pupils with no Hours at Setting entered

75


School census autumn 2010

The blank display indicates that we have entered hours for all of the 3 year olds

76


School census autumn 2010

The approach for 2 and 4 year olds is exactly the same

77


School census summer 20101

School Census Summer 2010

Class Type(Primary School only)

78


School census autumn 2010

Click Update Class Type

79


School census autumn 2010

The interface works in the same way as Update Hours at Setting

80


School census autumn 20105

Jim HaywoodProduct Manager for Statutory Returns

School Census Autumn 2010

End of Preparation PresentationThank you for your time

81


  • Login