|
The site is organized into 2 administrative tabs (Home and Status) and five categories of learning tabs (Excel, Finance, Economics, Statistics, and Accounting). Four of the learning categories (designated with -->) have more than one learning tab. Click on the category tab and you will see the learning tabs for that category. There are 24 learning tabs in all.
Each learning tab contains quizzes, exercises, and teaching materials.
Quizzes present you with at least one example of each exercise type for a given learning tab topic. You can view the quiz exercise solutions only after you have submitted a response to all quiz exercises. There are two quiz types: pre-quiz and post-quiz. As the names suggest, you are encouraged to take the pre-quiz first and the post-quiz last. A pre-quiz may only be submitted once. If you are not satisfied with your results to a post-quiz you may reset it, creating a new set of quiz exercises to work through and submit. Your submitted quiz results are stored and can be accessed by you during future sessions.
Teaching materials represent the material that I present in class to introduce exercise types, show formula derivations, explain solution methods, and demonstrate Excel worksheet solutions. Teaching materials are a mix of text, narrated slide lectures, and silent software demonstrations. Review only as much of the tutorial as you believe you need to improve your proficiency with solving problems. Tutorials open in a separate browser window.
Drill Exercises are variations of the quiz exercises that provide practice solving problems. Each time you click a link for a given exercise type, a new version appears with different numbers and in some cases different structure and question. When you submit a drill exercise solution you are then told whether your answer is correct and are immediately able to review a detailed solution that includes variable assignments, manual solution (using the relevant concepts, formula, and solution squence), an embedded Excel solution (where applicable) that you can export to Excel, and for financial math exercises a financial calculator solution.
I suggest the following approach to each learning tab:
1. Start each tab by taking the pre-quiz. This will serve as a baseline diagnostic for your proficiency with the topic. If you can correctly answer all the pre-quiz exercises then you are advised to move on to the next learning tab. Skip the pre-quiz if you don't need the results to remind you that you have absolutely no background in that topic.
2. Review the pre-quiz solutions. This will let you begin to understand the reasons for any errors. If your understanding of the topic is minimal then proceed to the teaching materials. If your errors are due to minor mistakes and your review of the pre-quiz solutions refreshes your memory about the relevant formulas and solution approaches then you are advised to skip the teaching materials and proceed to the exercises.
3. Review the teaching materials. The text tutorials and narrated lectures provide a fundamental overview of the underlying formulas and solution approaches for the various exercise types.
4. Work on drill exercises. For the exercise types that give you trouble, click the corresponding drill exercise type link to generate a sequence of related problems. Work on the problems and submit results. Review the solutions until you are proficient. Note that exercise solutions that you submit are not saved for future review. (Only quiz results are stored.)
5. Take the post-quiz. This is similar to the pre-quiz but involves different numbers. If, after submitting your results to a post-quiz, you are not satisfied with your proficiency, you may reset the post-quiz and work through a new set of quiz exercises. Start each post-quiz exercise from scratch without using solution templates from pre-quiz and drill exercises.
|