Saturday, March 22, 2014

Skills Checklist Update D


In this module, my goal was to complete my intervention data charts and merge them into parent information letters for each student.  I was able to successfully merge parent and student information into each letter.  I ran into some trouble trying to merge each student's chart into their individual parent letters.  From the research that I did, it seemed pretty complicated for someone like me who doesn't completely understand all of the formulas used in Excel.  So, since I didn't have many letters to complete, I opted to link the charts manually after I had merged the other fields (parent name, student name, etc.).  I watched a couple of video tutorials to learn the difference between just pasting vs. embedding and linking the chart.  I chose to link the chart so that it is automatically updated when the excel chart is updated.  I think this will work out great and save a lot of time when it's time for progress reporting.  All I have to do is enter the data and then update the letters.  I'm very excited that I was able to figure all of this out!



Merged Parent Intervention Letters

Skills Checklist Update D

Saturday, March 8, 2014

Skills Checklist Update C

During this module, I was able to create an Excel file to record data and turn that data into a chart.  Yea!  When I first started, I was fearful that I wouldn't actually be able to figure it out.  I tried out the Atomic Learning website and found some tutorial videos on Excel.  What a great resource.  I had no idea that I had access to all of that.  I will definitely be using that again.  These were very helpful.  I also ended up searching the help within Excel and watched a couple of their videos.  I must admit, though, I finally figured it out with some trial and error.  The videos helped me figure out how Excel is organized and then I was able to search and experiment with some of the appropriate tools.  I do not think I could have done this on my own.  Luckily Excel seems to have a formula for everything.  I was able to look at the formulas for the different types of charts and graphs and edit them to include the cells that I wanted to utilize and tweak the graph to represent the columns that I wanted.  I certainly couldn't have written the formula on my own.  Overall, I feel good that I could use the program and create something simple and useful for my classroom.  I'm going to use this data/chart to log progress monitoring for a reading intervention called Read Naturally.  I will use this as a way to report progress to parents.   

Here is my data: 
Progress Monitoring Chart
Skills Checklist Update C