Invigilated test

1 - Set exercises - 50

2 - Set exercises - 50

To view information for a specific offering, select a value from the drop down above.

<ul><li>Introduction to Excel techniques </li><li>Introduction to technical reporting (TAS100) </li><li>Spreadsheet modelling </li><li>Actuarial models in Excel and preparation of data for analysis </li><li>Data summaries and graphical representation </li><li>Reasonableness tests </li><li>Audit trail </li><li>Discussion of model extension, analysis and validation of new outputs, and drafting of final documentation </li><li>Summary and next steps </li></ul>

Feedback is provided in a number of ways throughout your module. This includes feedback you receive during teaching from both peers and lecturers and that provided for formative assessment. Following an assessment, you will be given your marks and feedback in line with the assessment regulations and policy. More information on the timing and type of feedback that will be provided for each assessment will be available from the module leader. <a href='https://www.citystgeorges.ac.uk/about/governance/policies/student-policies-and-regulations'>https://www.citystgeorges.ac.uk/about/governance/policies/student-policies-and-regulations</a>

This module will support the development of all the graduate attributes. Your module leader will provide you with information about how your learning, teaching and assessment activities support your development of these attributes. The graduate attributes are: - Always learning - Engaged in the world - Technical and digital - Connected Professional - Creating Impact

In-Person - 

Self-directed - 

Directed Asynchronous - 

BetterSolutions.com http://www.bettersolutions.com/default.aspx. 

You will also be provided with a link to an extensive list of case studies and examples from previous examinations of the Actuarial Profession. 

International Standards for Actuarial Practice: https://www.actuaries.org/IAA/Documents/CTTEES_ASC/Final_ISAPs_Posted/ISAP1_Review_adopted_1Dec2018.pdf. 

Institute and Faculty of Actuaries’ Core Reading for Subject CP2. 

Principles for Technical Actuarial Work: Guidance on application of TAS 100

Technical Actuarial Standards 100: Principles for Technical Actuarial Work

Microsoft Excel 2019 Bible: The Comprehensive Tutorial Resource

Microsoft Excel 2019: Data Analysis and Business Modeling (Business Skills)

SMM092 - Modelling Practice (CP2)

SMM092-PRD3-PER-ALV1

This will be a lab-based module, which will make extensive use of case studies to develop the modelling skills required by actuaries, the audit trails required to document the work, and the interpretation and communication of the results. 
You will be expected to spend a significant amount of time in self-directed study. 
Self-directed learning hours are for independent study and account for the minimum amount of time you should spend studying independently. For example, carrying out subject research, practising and reflecting on techniques learned in class, reading widely around the subject to develop a deeper understanding, carrying out activities using the VLE, attending induction and career development workshops, working in groups to complete assignments and presentations, and completing individual assignments and other homework.

Contact hours are designed to be flexible and are delivered using a variety of methods to help you learn in the most effective way. A proportion of the core content may be delivered online and additional support materials and content will also be made available through Moodle.

Modelling Practice (CP2)

Apply and interpret the results from an actuarial model. 

Skills

Construct and document actuarial models in Excel  

Knowledge

Apply a well-laid out and easily maintainable spreadsheet modelling approach. 

Values and attitudes

Demonstrate the steps involved in building an actuarial model and the importance of creating an audit trail to document these steps.  

Deliver results and conclusions to a technical audience. 

Communicate clearly in a final report the approach, results and conclusions, including a summary and the next steps. 

Design modelling in a systematic, logical, and structured manner. 

Communicate the actuarial modelling approach used. 

Implement modelling approach and explain the outcomes

Consider the ethical implications involved in building actuarial models, and the corporate responsibilities inherent in applying them. 