Learning
Experience 2:
Learning Outcomes:
Focus/Content: Students practise calculating financial ratios. Teacher scaffolds students to calculate ratios using excel spreadsheets and other interactive online resources
ICT: Excel Spread sheet, Digital audio/video podcast, Massively Open Online Courses (MOOC)/Tutorials
21st century skills: Creativity, innovation, empowerment, enterprising, communication skills in virtual environment, and the abilities to acquire the new knowledge and integrate it with prior knowledge and problem-solving.
Teaching strategies: DOL 2: Internalise: Setup practice schedule and Bloom’s Taxonomy questions
Learning procedures:
Introduction:
Teacher facilitates whole class discussion about financial ratios
Body:
Teacher models from board:
Conclusion:
Learning Outcomes:
Focus/Content: Students practise calculating financial ratios. Teacher scaffolds students to calculate ratios using excel spreadsheets and other interactive online resources
ICT: Excel Spread sheet, Digital audio/video podcast, Massively Open Online Courses (MOOC)/Tutorials
21st century skills: Creativity, innovation, empowerment, enterprising, communication skills in virtual environment, and the abilities to acquire the new knowledge and integrate it with prior knowledge and problem-solving.
Teaching strategies: DOL 2: Internalise: Setup practice schedule and Bloom’s Taxonomy questions
Learning procedures:
Introduction:
Teacher facilitates whole class discussion about financial ratios
Body:
Teacher models from board:
- Teacher writes a problem and the current ratio formula on an interactive whiteboard.
- Students write down the formula in their hardcopy notebook and calculate the current ratio using calculator.
- Students download the electronic financial statements that are in acrobat format and use them to get the required values for calculating the ratios.
- Students use the edit, find and copy functionality in acrobat files.
- Teacher encourages students to skim through large documents and quickly find the information they need.
- Teacher advises students to use the zoom functionality available in electronic annual reports and appreciate its flexibility and readability compared to hardcopy financial statements.
- Teacher demonstrates the process of copying the data from financial statements into excel spreadsheets.
- Students practise formatting excel spreadsheets to make them readable and user friendly. Students learn to use Microsoft excel functionality i.e. referring to other cells, conditional formatting such as displaying negative numbers in different colours, predefined functions, sorting data and assistance available through help.
- Teacher provides links to online interactive quizzes (http://vijay-financialratios-test.weebly.com/quizzes.html) of various complexities for students to practise calculating ratios and derive solutions.
- Students use Microsoft excel spreadsheet to solve the interactive quizzes (http://vijay-financialratios-test.weebly.com/quizzes.html).
- Teacher encourages students to research and explore other online resources to interpret various ratios for evaluating company’s financial performance.
- Teacher demonstrates the benefits of recording and maintaining the data electrically for improving accuracy, efficiency and ease of use.
- Teacher guidance:
- Teacher acts as a facilitator and encourages students to discover innovative ways of learning efficiently and master the financial paradigms.
- Teacher welcomes and rewards student’s creativity and innovation through the use of Information and Communication Technologies.
- Teacher encourages students to use the excel spreadsheets to perform ratio analysis, draw charts, write simple macros to do repetitive operations and publish on their web sites.
- Teacher demonstrates the process of importing the financial statements (income statement, balance sheet and cash flow statement) from the company’s web sites into excel spread sheets and use the data meaningfully.
- Students learn to use advanced formulas and aggregate functions in excel, synthesise and organise the information and link to other spread sheets.
- Teacher motivates students to learn to embed digital audio into excel.
Conclusion:
- Teacher encourages students to help their family members and friends with basic operations of Microsoft excel spreadsheets.
- Teacher inspires students to explore and use digital/video podcasts and Massively Open Online Resources (MOOC) and make their learning journey more productive and exciting (http://vijay-financialratios-test.weebly.com/online-courses.html).
- Teacher encourages students to develop curiosity and intrinsic motivation to demonstrate their creativity and enterprising skills in digital domain.
- Encourage students to complete the homework Bloom's taxonomy sequence of questions: Cognitive level “Application” http://vijay-financialratios-test.weebly.com/blooms-taxonomy-sequence-questions.html
- Teacher encourages students to use blog to share their learning experiences with their peers about using Microsoft excel and other online resources. (http://uni.vijay.8ing.com/courses/2013/T3/FAHE11001/blog/?page_id=146)