| Author | |
SuzanneG
Forum Moderator
Joined: June 17 2006
Location: Idaho
Online Status: Offline
Posts: 5465
|
| Posted: Feb 18 2010 at 11:29pm | IP Logged
|
 |
|
I did something a year ago that has been really helpful, and wanted to mention it.
I made an Spreadsheet of all of the saint books we have with each saint name contained within.
Column A - saint name (Stephen of Hungary)
Column B - Name of book (Loyola Treasury of Saints)
Column C (not nec) - Feast Day
Then, I can sort it alphabetically by saint name, save it, and when I'm looking for a saint reading for a particular day or for a reason....I pull up the spreadsheet, and I have the 3 books that have Teresa of Avila in them. Go to those books and choose. It saves time looking in the TOC or index of each of the books.
It sounds crazy and like a lot of work, but actually it wasn't, especially if you have another READER in the house to help read the list of saint names and you type. It goes really fast.
At first I thought this was going to be one of those crazy things I'd do and not use, but I actually use it a lot. I think it saves time.
I also list: picture books, statues, and Glory Stories, etc. It helps the girls to make their own little display or plan for a feast day...they know how to go to the spreadsheet and look up a name.
__________________
Suzanne in ID
Wife to Pete
Mom of 7 (Girls - 14, 12, 11, 9, 7 and Boys - 4, 1)
|
| Back to Top |
|
| |
Chris V
Forum All-Star
Joined: Dec 03 2009
Location: Washington
Online Status: Offline
Posts: 1598
|
| Posted: Feb 18 2010 at 11:53pm | IP Logged
|
|
|
This is really excellent! 
It's been my intention (for way, way too long now, to make a spreadsheet of my resources and books.
... one of those things that typically gets pushed down on the list, behind, oh, say laundry  .
__________________
Chris
Happy Wife with my Happy Life
Mama to My Five Girls ('04~'07~'09~'11~'11) 
|
| Back to Top |
|
| |
Erin
Forum Moderator
Joined: Feb 23 2005
Location: Australia
Online Status: Offline
Posts: 5814
|
| Posted: Feb 19 2010 at 4:10am | IP Logged
|
|
|
Suzanne
Book talk, my favourite topic  A couple of years ago I also typed up a list of my resources (but it really needs updating as I have hardly any of our lovely Mosaic books listed. They were a later purchase) This was a huge process and took weeks. I wish I had done it in a Excel spreadsheet like yours. For me the most important part was your 'Column C'. I wanted to be able to look at the date for various feast days and know instantly what books to pull out.
I also added a 'key' so I can tell whether the book is for my older readers or my younger ones. When I have a chance to update I'd love to create extra details such as countries and time periods.
I'm impressed that your girls use it.
Love to encourage you to do it Chris.
__________________
Erin
Faith Filled Days
Seven Little Australians
|
| Back to Top |
|
| |
Mackfam
Board Moderator
Non Nobis
Joined: April 24 2006
Location: Alabama
Online Status: Offline
Posts: 14656
|
| Posted: Feb 19 2010 at 7:07am | IP Logged
|
|
|
I've been working on a project doing much the same thing. I had all my Catholic Mosaic books organized by Liturgical Year, but I have now undertaken ALL of our books that coordinate with the liturgical year (VISION books, Encounter the Saints, MFW, Louis deWohl, general saint's biographies). I'm organizing them by month first, and then further subdividing by century and location, because these books are also read for their historical context as well. I have readers all over the spectrum now, and this is what motivated me to start this project. I write in pencil on the first page of the book the:
Date of the Feast:
Century of the Saint:
Country:
And, I can see that a spreadsheet will be in my future!!
__________________
Jen Mackintosh
Wife to Rob, mom to dd 19, ds 16, ds 11, dd 8, and dd 3
Wildflowers and Marbles
|
| Back to Top |
|
| |
stefoodie
Forum Moderator
Joined: Feb 17 2005
Location: Ohio
Online Status: Offline
Posts: 8457
|
| Posted: Feb 19 2010 at 7:35am | IP Logged
|
|
|
i don't know if this is exactly what you gals have in mind, but
here's a thread from 3 years ago
and this
and finally here -- where i posted about the spreadsheet
i've been working on getting it onto a calendar, but it's been WAY TOO SLOW. if this is at all what you gals have in mind, perhaps we could work on it together?
if you click on my link below (The Homeschooler's Book Blog) you'll see the calendar on the right sidebar. Click on "Click for more" or scroll down on the calendar and you'll see what i've got on there. this has been an ongoing project since 2007 and i'm very frustrated that i haven't been able to get it done. yes, i'm begging for help if anyone is willing.
it seems we all want pretty much the same thing, we just need to agree on what medium to use (spreadsheet, calendar, what?) and how to do it. the thing that i love about the spreadsheet is that it's easily sortable, the thing i love about the calendar is the automated reminder and repeat. i'd love to brainstorm on how to get those 2 things to work together.
__________________
stef
mom to five
|
| Back to Top |
|
| |
stefoodie
Forum Moderator
Joined: Feb 17 2005
Location: Ohio
Online Status: Offline
Posts: 8457
|
| Posted: Feb 19 2010 at 7:37am | IP Logged
|
|
|
if you guys have any techie friends/hubbies, maybe one of them can decode this techspeak for us? or this?
__________________
stef
mom to five
|
| Back to Top |
|
| |
JennGM
Forum Moderator
Joined: Feb 07 2005
Location: Virginia
Online Status: Offline
Posts: 17702
|
| Posted: Feb 19 2010 at 9:20am | IP Logged
|
|
|
A great resource that has helped me organize and keep track of what books cover what saints, and what period is Reading the Saints: Lists of Catholic Books for Children plus Book Collecting Tips for the Home and School Library by Janet McKenzie.
__________________
Jennifer G. Miller
Wife to  & ds1  '03 & ds2  '07
Family in Feast and Feria
|
| Back to Top |
|
| |
Chris V
Forum All-Star
Joined: Dec 03 2009
Location: Washington
Online Status: Offline
Posts: 1598
|
| Posted: Feb 19 2010 at 10:05am | IP Logged
|
|
|
This is tremendous! Wow. 
Erin wrote:
Love to encourage you to do it Chris. |
|
|
Thank you  I need your encouragement! This is something that I really want done (however, I want to do it about as much as I *want* to do our taxes).
__________________
Chris
Happy Wife with my Happy Life
Mama to My Five Girls ('04~'07~'09~'11~'11)
|
| Back to Top |
|
| |
Erin
Forum Moderator
Joined: Feb 23 2005
Location: Australia
Online Status: Offline
Posts: 5814
|
| Posted: Feb 19 2010 at 4:08pm | IP Logged
|
|
|
Mackfam wrote:
| And, I can see that a spreadsheet will be in my future!! |
|
|
What!?? You haven't done one yet?? Slipping  
Stefoodie wrote:
where i posted about the spreadsheet
i've been working on getting it onto a calendar, but it's been WAY TOO SLOW. if this is at all what you gals have in mind, perhaps we could work on it together? |
|
|
Stef,
Very impressive, I like the spreadsheet format better than word doc like mine.
Stefoodie wrote:
| it seems we all want pretty much the same thing, we just need to agree on what medium to use (spreadsheet, calendar, what?) and how to do it. the thing that i love about the spreadsheet is that it's easily sortable, the thing i love about the calendar is the automated reminder and repeat. i'd love to brainstorm on how to get those 2 things to work together. |
|
|
I agree with you, I like both formats too.
I tried to dump bits into my google calendar but it wouldn't work, it appeared that I would have to manually enter all data (wasn't doing that again.) Mmm but I notice you link to a techspeak. Hoping someone can help here.
Originally when I shared my file on google I thought it could be useful to others but so many of my books are OOP. I'd be happy to do a joint project but what thoughts do you have about different people having different resources?
JennGM wrote:
| A great resource that has helped me organize and keep track of what books cover what saints, and what period is Reading the Saints: Lists of Catholic Books for Children plus Book Collecting Tips for the Home and School Library by Janet McKenzie. |
|
|
I have never heard of this resource!! Wow
[QUOTE=Chris V]Thank you I need your encouragement! This is something that I really want done (however, I want to do it about as much as I *want* to do our taxes).[?Quote]
Chris,
Thanks for your encouragement I think my dh thinks it's another of my "frustrated librarian" projects
Well look at it like this, how happy are you when you get that tax refund!
Maybe you can use my doc and Stef's to work out some of the saint's dates if you have some of the same books.
Suzanne, Can we have a peak at your spreadsheet?
__________________
Erin
Faith Filled Days
Seven Little Australians
|
| Back to Top |
|
| |
stefoodie
Forum Moderator
Joined: Feb 17 2005
Location: Ohio
Online Status: Offline
Posts: 8457
|
| Posted: Feb 19 2010 at 4:15pm | IP Logged
|
|
|
Quote:
| I'd be happy to do a joint project but what thoughts do you have about different people having different resources? |
|
|
yeah, i've been thinking about this all day and coming to the conclusion that ack..... there isn't one, is there? we all have different things in our houses and except for those we have in common, our spreadsheets/calendars would be useless for everyone else....
i still wish though. 
__________________
stef
mom to five
|
| Back to Top |
|
| |
JodieLyn
Forum Moderator
Joined: Sept 06 2006
Location: Oregon
Online Status: Offline
Posts: 12234
|
| Posted: Feb 19 2010 at 4:16pm | IP Logged
|
|
|
Low tech solution to using the two programs. Have the Saints' Days listed on your calender.. if you have books put an * next to the name.. then you'll know to check your spread sheet for which books/stories you have.
__________________
Jodie, wife to Dave
G-18, B-17, G-15, G-14, B-13, B-11, G-9, B-7, B-5, B-4
All men who have turned out worth anything have had the chief hand in their own education.
-Sir Walter Scott
|
| Back to Top |
|
| |
JodieLyn
Forum Moderator
Joined: Sept 06 2006
Location: Oregon
Online Status: Offline
Posts: 12234
|
| Posted: Feb 19 2010 at 4:17pm | IP Logged
|
|
|
It could help other just to know the time frames.. so even if you don't share the particular books.. the era and saints would be good to share.
__________________
Jodie, wife to Dave
G-18, B-17, G-15, G-14, B-13, B-11, G-9, B-7, B-5, B-4
All men who have turned out worth anything have had the chief hand in their own education.
-Sir Walter Scott
|
| Back to Top |
|
| |
Mackfam
Board Moderator
Non Nobis
Joined: April 24 2006
Location: Alabama
Online Status: Offline
Posts: 14656
|
| Posted: Feb 19 2010 at 4:30pm | IP Logged
|
|
|
Erin wrote:
Mackfam wrote:
| And, I can see that a spreadsheet will be in my future!! |
|
|
What!?? You haven't done one yet?? Slipping |
|
|
I know!!!! I can't let you down I'm definitely going to make one!
Erin wrote:
I have never heard of this resource!! Wow |
|
|
Erin,
If you don't have this I would track it down like a hound dog!!!! IMMENSELY helpful because it covers in print AND out of print books and SORTS ALL OF THEM!!!!!
I'm compiling in iCal right now because it's how I do my lesson planning so it's handy to have it right there. So, I add the Feast on the specific date and then in *notes* I add in all the books with authors as well as list the saint's century and location.
Suzanne mentioned it, but it's worthwhile mentioning again that this is SO GREAT for coordinating all those books that are collections of stories and breaking out the individual story which relates to a particular Feast and pegging it to the Feast day...books like, Journeys With Mary, Angel Food books, Celtic Heritage Saints, etc.
I made a general Lent category and just tagged it to Feb 1. I'm up through April so far...miles to go!!!
__________________
Jen Mackintosh
Wife to Rob, mom to dd 19, ds 16, ds 11, dd 8, and dd 3
Wildflowers and Marbles
|
| Back to Top |
|
| |
Erin
Forum Moderator
Joined: Feb 23 2005
Location: Australia
Online Status: Offline
Posts: 5814
|
| Posted: Feb 20 2010 at 12:42am | IP Logged
|
|
|
Mackfam wrote:
Erin,
If you don't have this I would track it down like a hound dog!!!! IMMENSELY helpful because it covers in print AND out of print books and SORTS ALL OF THEM!!!!!
|
|
|
Good hound dog that I am I have successfully tracked this book down Thought I'd share for anyone else interested. Book Depository, Betterworld and Abe Books all have copies. Now I just have to debate with myself as to will I now or will I later
__________________
Erin
Faith Filled Days
Seven Little Australians
|
| Back to Top |
|
| |
Erin
Forum Moderator
Joined: Feb 23 2005
Location: Australia
Online Status: Offline
Posts: 5814
|
| Posted: March 03 2010 at 9:22pm | IP Logged
|
|
|
Stef
Tried to work out converting doc to calendar but have to concede defeat at this stage. 
I've decided to convert my word doc to excel spreadsheet. What columns would you advise? Obviously Date, Book, page (for several stories in one book), Key (I have listed whether pic bk, colouring, chp bk etc); and reading Jen's ideas I could add century and country. Any other suggestions?
__________________
Erin
Faith Filled Days
Seven Little Australians
|
| Back to Top |
|
| |
Angel
Forum All-Star
Joined: April 22 2006
Online Status: Offline
Posts: 2293
|
| Posted: March 04 2010 at 7:10am | IP Logged
|
|
|
How did I miss this thread???
Erin, I would add a target age range. Are you just doing this for books you own? I was thinking in my databases that I would include books I didn't own, too, so I could check them out at the library, if possible. (Of course, I may just be giddy at the prospect of having access to a better library, thinking that they might have resources I don't.)
I'm wondering how you would pack up your faith-related books. I'm looking at organizing all my books a bit better before I put them in boxes. Right now I have my Catholic Mosaic books in a drawer in a closet where I keep picture books to rotate, and all my other Saint books (Vision books, big hardbacks, etc.) are mixed in with "general" books on the faith in baskets out in the living room. I figure if I do a good enough job of packing all my books, they'll be A LOT easier to unpack on the other end.
__________________
Angela
Mom to 9, 7 boys and 2 girls
Three Plus Two
|
| Back to Top |
|
| |
Erin
Forum Moderator
Joined: Feb 23 2005
Location: Australia
Online Status: Offline
Posts: 5814
|
| Posted: March 04 2010 at 2:09pm | IP Logged
|
|
|
The target range is covered by my key.
Key: Picture Book=PB
Long Picture Book=LPB
Colouring Book= CB
Activity Book =AB
Children’s Chapter Book= ChB
Short Chapter Book=SCB
Teenage Chap Bk=TCB
Adult Chapter Book= ACB
Short Story for Young Ch. =SYC
Short Story for Middle Ch.=SMC
Short Story for Older Ch.=SOC
Liturgical Resources=LR
Mosaic Book= MB
Poetry/Verse=PV
It is for my own books. My library has NO Saints books.
How exciting if you move to a better library
Packing: As you are thinking I would pack my Mosaic and Vision in their own boxes. I'm not too sure what else you own but I would tend to box by ages and series. Possibly like my key above and depending on how many books of each as to how many 'key categories' I would box together.
__________________
Erin
Faith Filled Days
Seven Little Australians
|
| Back to Top |
|
| |
SuzanneG
Forum Moderator
Joined: June 17 2006
Location: Idaho
Online Status: Offline
Posts: 5465
|
| Posted: March 05 2010 at 12:25am | IP Logged
|
|
|
Erin wrote:
| Suzanne, Can we have a peak at your spreadsheet? |
|
|
2010-03-05_002246_aaSaint_Books_-_Compilation_xls.xls
__________________
Suzanne in ID
Wife to Pete
Mom of 7 (Girls - 14, 12, 11, 9, 7 and Boys - 4, 1)
|
| Back to Top |
|
| |
Erin
Forum Moderator
Joined: Feb 23 2005
Location: Australia
Online Status: Offline
Posts: 5814
|
| Posted: March 05 2010 at 4:04am | IP Logged
|
|
|
Thank You Very helpful, and I just tried to imagine you and I were visiting and I was having a peek in person at your library with you.
__________________
Erin
Faith Filled Days
Seven Little Australians
|
| Back to Top |
|
| |
SeaStar
Forum Moderator
Joined: Sept 16 2006
Online Status: Offline
Posts: 9068
|
| Posted: Nov 04 2010 at 9:06pm | IP Logged
|
|
|
Bumping this up....
I saw that Sacred Heart Books has Reading the Saints in the clearance bin for $15. All orders over $25 ship free
__________________
Melinda, mom to ds ('02) and dd ('04)
SQUILT Music Appreciation
|
| Back to Top |
|
| |
Forum Locked) 
4Real Forums : Domestic Church
Topic: Organizing Saint Readings
