Difference between revisions of "Excel Practice Problems"
(→Excel Format Problems) |
(→Excel Format Problems) |
||
| Line 34: | Line 34: | ||
|| ''This library of Excel-based versions of standard problems will be built over the course of <u>June/July 2021</u>.'' | || ''This library of Excel-based versions of standard problems will be built over the course of <u>June/July 2021</u>.'' | ||
|} | |} | ||
| + | |||
| + | {| class='wikitable' style='background-color: peachpuff; width: 1050px;' | ||
| + | |- | ||
| + | || <span style="color: black;">'''BattleActs Coffee Mug Challenge!'''</span> Alice has double-checked her RBC calculations but if you find an RBC calculation error that slipped past her, please let her know at <span style="color: blue;">info@battleacts.ca</span> and we'll send you a BattleActs coffee mug. (Typos get a shout-out.) Alice inserted 1 very obvious incorrect final answer somewhere in this article to make sure there is at least 1 mug winner. Finding it should be easy as pie. :-) ''This error was found [[Odomirok.19-RBC#Alice.27s_5th_Day_.28R0_and_Another_Exam_Problem.29 | in Alice's 5<sup>th</sup> Day (Example 6)]] by DB on Feb 15, 2021!'' | ||
| + | |} | ||
| + | |||
| + | : [[File: mug.png | 200px]] | ||
{| class='wikitable' | {| class='wikitable' | ||
Revision as of 13:52, 19 June 2021
Battleacts is here to help you prepare for not only the syllabus content but also the exam environment. Now that the CAS has moved to Computer Based Testing (CBT) with Pearson VUE we're providing Excel files which feel like the exam experience. As more information is made available about the testing experience we'll update the files accordingly.
For past exams: To get the most out of these files you should attempt each exam under timed conditions and then grade yourself carefully and harshly. The examiner's report is a great source of information about things the CAS didn't award credit for - read these carefully and relate them back to the question to avoid wasting time on BattleDay. You can also use the Exam Summaries wiki article to see individual questions and answers from the examiner's report.
Alice: "I've heard the F2 and F4 keys don't work in the Pearson environment. They do work in our Excel files but you've been warned for BattleDay!"
Past Exams
| Excel Problems | Examiner's Report |
| Exam 6U: 2019.Fall | 2019.Fall Examiner's Report |
| Exam 6U: 2019.Spring | 2019.Spring Examiner's Report |
| Exam 6U: 2018.Fall | 2018.Fall Examiner's Report |
Excel Format Problems
| This library of Excel-based versions of standard problems will be built over the course of June/July 2021. |
| BattleActs Coffee Mug Challenge! Alice has double-checked her RBC calculations but if you find an RBC calculation error that slipped past her, please let her know at info@battleacts.ca and we'll send you a BattleActs coffee mug. (Typos get a shout-out.) Alice inserted 1 very obvious incorrect final answer somewhere in this article to make sure there is at least 1 mug winner. Finding it should be easy as pie. :-) This error was found in Alice's 5th Day (Example 6) by DB on Feb 15, 2021! |
| Wiki Link | problem types | Set 1 | Set 2 |
|---|---|---|---|
| NAIC.IRIS | IRIS Ratios (Calculation & Acceptable Ranges) |
IRIS Ratios 1 | IRIS Ratios 2 |
| Odomirok.15-P | Schedule P - Parts 2,3,4 (basic layout) Schedule P - Part 5 Schedule P - Parts 2,3,4 (updating) Schedule P - Intercompany Pooling |
Schedule P 1 | |
| Odomirok.19-RBC | Overall RBC Ratio RBC Charges Calculate R1 Calculate R1 & R2 Calculate R3 Calculate R4 Calculate R5 Calculate Rcat |
RBC 1 | |
| more to come... |
