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
Here is my data:
Progress Monitoring Chart
Skills Checklist Update C
Subscribe to:
Posts (Atom)