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.

 

Excel basic

 

10 reasons you should take time to increase your skill with formulas (Bruns, 2015):

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. Because the business world relies on spreadsheets to make decisions, being good with formulas keeps you close to the action.
  8. Formulas help you quickly visualize data. When you combine formulas with conditional formatting, you can instantly “see” important trends, insights, and relationships.
  9. 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.
  10. 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.

 

Resources:

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/

 

 

Advertisements

2 thoughts on “EDET 637 Week 11

  1. I love Excel; I use it to budget, track changing numbers on all sorts of things, figure interest rates and percentages, etc. People laugh when I say I’m an Excel nerd…but it’s so true.

    Although I’ve never taught a class about the use of Excel, about 10 years ago I created a budget template for myself and have ended up sharing it with several friends, which generally requires some amount of orientation to the software. I’m always surprised, given that most of my friends grew up with technology and Microsoft, how little experience many of them have with Excel. What process do you go through/or what steps are you using to ensure that students are able to start where they need to in the content, given the diverse range of experience you may encounter?

    Like

  2. I would like to have taken this call. I did a little bit in a technology class that I took in high school, but I do not remember much. Everyone works at a different rate and this is always a challenge when working with a group of people. Some catch on really quickly and others need more time. Making sure everyone has the basics learned is the most important and then those who have mastered the basics can keep advancing.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s