Essential question: What are my challenges and successes in implementing my unit?
My unit involves teaching adults how to use Excel for everyday use. I enjoy teaching tools that will enhance ones skills and can be used at one’s job. It is good to show both the personal and business side of spreadsheets. Excel has to be one of my all-time favorite go to tools.
10 reasons you should take time to increase your skill with formulas (Bruns, 2015):
- Formulas are important in many jobs. In a recent survey we conducted about formulas, over 90% of respondents said that Excel formulas were “important”, “very important”, or “vital” to their job.
- Formulas are a powerful way to capture and save a working solution. They let you repeat the solution again whenever you like, always with perfect accuracy. They are far better than your faulty memory.
- Formulas help you translate your vision into reality. Ever felt like you can explain what you want to do in plain English, but you have no idea how to do it in Excel? Formulas let you build the analysis that’s in your head.
- Your understanding of formulas helps you design better spreadsheets. You can organize data in a way that takes advantage of formulas, which drastically reduces errors and troubleshooting.
- Hardly anyone is really good with Excel formulas, so being good with formulas is a chance to differentiate yourself by providing more value and productivity. And all businesses love productivity.
- Being good with formulas allows you to build elegant solutions that avoid complexity. Nothing in Excel is more dangerous that unnecessary complexity — it makes it impossible to understand if a spreadsheet is really working correctly.
- Because the business world relies on spreadsheets to make decisions, being good with formulas keeps you close to the action.
- Formulas help you quickly visualize data. When you combine formulas with conditional formatting, you can instantly “see” important trends, insights, and relationships.
- Skill with formulas allows you to deploy a full set of razor-sharp tools when solving problems. Without formula skills, you are forced to use a dull saw on every job, no matter how large or tedious.
- Formulas let you get home on time. When you understand how to use formulas, you can do your work faster and spend more time with friends and family. Priceless.
Challenges: Different levels of learners can create setbacks when completing assignments. Differential Instruction might need to come into play when talking about navigation and functions. Some students might have zero exposure to spreadsheets while others will already have experience. I will need to plan a cushion in case I need to review certain features.
Success: I love hearing when my students tell me that they went home and played with spreadsheets. Hearing that they can use Excel to better plan for projects or make a budget is proof that my instruction is relevant to today’s world which is a great feeling. I always tell my students to go home and play with the templates to see what they can do with spreadsheets. I love seeing finished projects from my students.
Reasons to learn Excel according to Anwar:
- Excel is a universal language spoken in almost most offices
- Stop thinking of Excel as a spreadsheet (it’s a problem solving tool)
- Create more time
- Excel is not going anywhere
- Small data
- Excel is like an analytical sketchpad
- Value networking
- More Excel skills make you more marketable
Experience with spreadsheets is something that most business office jobs require experience. Knowing how to navigate through the menu and to create new project is a must for most jobs. I feel like these tools open the door for more advance programs like Access and SQL. The wonder of the functionalities create a curiosity to learn more simplistic programming applications.
Bruns, Dave. (2015 Nov 23). Top 10 Reasons to learn Excel Formulas. Retrieved on 4/5/2017 from: https://exceljet.net/top-10-reasons-to-learn-excel-formulas
Lee, Donn. (2013, Jan 13). Why you need to learn MS Excel. Retrieved on 4/5/2017 from: http://edonn.com/2013/01/13/why-you-need-to-learn-ms-excel-now/
Anwar, Sohail. (2015, Jan 12). 8 Reasons you must get better at Excel in 2015. Retrieved on 4/5/2017 from: http://chandoo.org/wp/2015/01/12/get-better-at-excel-this-year/