So far I like it I think it is better than excel. You can drag a whole table around! That is good!
Woo Hee Jun
Sep 24, 2008
Inputing checkboxes (leaving them checked or unchecked) is a cool feature.
Fantasy Premier League
Sep 24, 2008
To drag a table around click on the table . The top left button can be clicked and the table dragged around. To add another table click on "tables" and select the type of table you want.
Kath Adams
Sep 24, 2008
It seems very versatile-love being able to insert photos though I have to think how I'm going to use that. Cell background, image fill select photo-for those interested
Helen Thompson
Sep 24, 2008
The check box is very useful in tables as recording assessments will be much easier. Want to know how to input formulas please
Kath Adams
Sep 24, 2008
Like inserting photos into cells-cell background, image fill, select photo. Though I have to think about how to use it.
desireelouw
Sep 24, 2008
You can put photos in the cells! So you could put a photo next to the students name on the list.
User Settings
Sep 24, 2008
to add a new wiki comment, you must select "save comment" or it won't save!
Aggie Huang
Sep 24, 2008
if you would like to change the color of your chart, you may go to the inspector, choose the chart and then dray the color to you chart. it worked!
Chris Klesch
Sep 24, 2008
Charts are cool. I also learned to widen columns, change column colors and drag colors into your chart.
desireelouw
Sep 24, 2008
I am the last!
Fantasy Premier League
Sep 24, 2008
Click and drag is fantastic, you can click and drag pictures and even videos into your document
Jillian Eyre-Walker
Sep 24, 2008
Numbers = Spread sheet View Show print view What ever you put on your header rows it will repeat Style draws (left hand bottom) you can style your table You can change the inside lines by going to the inspector and click on the table box. You need to highlight the area you want changed first. On the left hand side at the top you can double click on sheet. Now you can name your sheet. Then you double click on table just below and you can name your table. This is important because you can have lots of table on the one page. On the left hand corner up the top if you click on name the computer will then put the name of your table into your table. To make a second table go to the table icon at the top and click on it. Then select a type of table and you will see a second table on your page. Now to move that table click box in left hand top corner and drag table to its place. The thick blue line that moves will help you line up your tables. To move between cells click on any arrow key You can also press enter for down
Amy Keus
Sep 25, 2008
If you have questions about Numbers, then please post them here and I will answer the best that I can.
FORMULAE:
There will be a 2nd session on using Numbers' more advanced functions. However, if you'd like a heads-up on using formulae, I'll discuss this now.
Today I showed you how to total a column. This was by typing =sum(C1:C3), which will add columns C1, C2, and C3. You can also click in the cell below all of your data and click INSERT / FUNCTION / SUM. This, though, will add all data going up to the header, so if you have left some extra cells with data you don't want to be counted, you'll have a bit of a problem. If you are worried about this, then just do what I showed you --- type =sum( and then highlight the cells you want, and press ENTER.
Cindy Van den Heuvel
Sep 25, 2008
Amy, put your instruction movie on youtube
Nadean Curtiss
Sep 25, 2008
text organization template is one for multi media....can use the blank template for anything also
Cindy Van den Heuvel
Sep 25, 2008
Andrei discovered a problem with numbers
Elizabeth Solomon
Sep 25, 2008
I would like to know how to slant my labels when you have the time, thanks
Amy Keus
Sep 25, 2008
Andrei found something new! He discovered that you can resize the entire table in a similar way in which you can add or delete rows and columns. The problem comes in when you accidently click on the white handles instead of the grey. This will take as many rows and columns as you have - which might be dozens - and will make them so tiny that you can't read any of the data and the grey handles disappear, so you can't even add or delete columns.
Lesson learned? When you are trying to add or delete handles, make sure you are dragging the GREY handles.
Thanks Andrei, for showing us that!
Charlie Mcbride
Sep 25, 2008
thank you for the help. I think I need to go through the movie and practice the other options in numbers
Andrei Tyoschin
Sep 25, 2008
comand/space and type numbers
View - show print view right side three buttons headdress their only for text
In sheets window 2klick sheet and rename
To edit the table go to inspector - table
Scott Platt
Sep 25, 2008
I learned how to make a pie chart based on the information I'd entered into a table.
Isabelle Holovecz
Sep 25, 2008
If you highlight your chart and do a right click, you can also select your graph. Quite easy this way!
Cindy Van den Heuvel
Sep 25, 2008
Amy, you can't copy and paste a table into keynote as it loses all the cells and borders
Andrei Tyoschin
Sep 25, 2008
Formating go to toolbar (numbers,$....) or sell inspector To arrange numbers in ascending or descending order you need to type at least two numbers and drag, same with dates.
Niki Swart
Sep 25, 2008
Numbers - Blank - click view - click show view print - you then move your table onto one page from left to right and from bottom to top.
Resize the table: bottom right makes it larger and smaller (increasing and decreasing the number of columns) - click top right corner - see little squares and then resize keeping the same number of columns
Use the format bar or the inspector to do all your fomatting
Name your table - sheet and table on the left side
Cell borders: highlight, change the type of line, the thickness, the colour
Entering data: Hightlight the cells you want to enter data in - choose the type of data from the inspector using cell inspector
To create charts: hightlight the column(s) you want included in the chart - click chart - select the type of chart that you want and click
To add pictures etc - just drop and drag.
Jae Yong Hwangbo
Sep 25, 2008
Nice to meet you, Numbers! Thanks Amy for introducing a good friend for this holiday.
Amy Keus
Sep 25, 2008
MOVING FROM NUMBERS TO PAGES AND KEYNOTE:
I have just copied a table and a chart from Numbers to both Keynote and Pages, and they both pasted perfectly.
I did not highlight the table. Rather, I clicked on the table so that the white handles appeared. Then I clicked COMMAND+C. Going into Pages and Keynote, I clicked COMMAND+V to paste them in.
//
Any other questions? Keep them coming!
Candace Taylor-Weber
Sep 25, 2008
To record on computer, go to SMARTBOARD TOOLS (blue box looking icon on the task bar) | open | recorder. It will record the audio with the built in mic and also whatever happens on your screen.
Amy Keus
Sep 25, 2008
To repeat numbers, or to create patterns of information:
1. If you want 1,1,1,1,1,1,1,1,1,1 going all the way down the column. Type 1 into the first cell. When you click on it again, a tiny white circle will appear in the bottom right hand corner of the cell. Click and drag in the direction that you want to fill.
2. If you want a repeating pattern, such as 1,2,3,4,5,6 or 3,6,9,12, or Sept 1, Sept 3, Sept 5, Sept, going all the way down a row or column... Type the first 2 or 3 data into the first few cells. When you click on it again, a tiny white circle will appear in the bottom right hand corner of the cell. Click and drag in the direction that you want to fill.
Candace Taylor-Weber
Sep 25, 2008
Charts - just click the "chart" button. A table will automatically pop up when you choose the kind you want. Just modify the data and away you go. You can customize details in the inspector. Even cooler is you can double click one piece of a pie chart, and pull it out or separate it out (thank you Matthew).
Candace Taylor-Weber
Sep 25, 2008
Alpha tool (a little button at the top, and if it's not there, customize your toolbar by adding it there) will get rid of background in an image you might want to use. If you have, for example, a picture with a black background, you can erase the black and just have the leaf from the foreground.
Candace Taylor-Weber
Sep 26, 2008
Resource on public server | ICT_Resource | HowTo
Candace Taylor-Weber
Sep 26, 2008
To copy cell contents (repeat), just highlight the cell and select the white dot in the lower right hand corner. Drag that down and the contents will repeat. IF you want to fill the cells with a pattern, you need to highlight the cells that already hold the pattern (2-3 cells or whatever) and click the white dot in the corner and drag. If you fill with a pattern, it not only recognizes numerical patterns, but will also notice formatting patterns (a black 1, red 2, black 3, red, 4).
Aaron Thompson
Sep 26, 2008
In a pie chart click to select a "slice of pie" and drag it away from the graph to show the slice.
Chris Allen
Sep 26, 2008
I can't make a table when I copy stats from one row of information (that was the sum of columns).
Christina Wu
Sep 26, 2008
learn a lot of stuff!
Robin Hutchison
Sep 26, 2008
Life is about numbers and this session is further evidence of this.
Eunice Ong
Sep 26, 2008
I have learnt how to import sound, movies and pictures into numbers. It's interesting.
Jean Yang
Sep 26, 2008
Numbers is so much cooler than PPT ! o(^_^)o
liviasuri
Sep 26, 2008
This is going to be very useful for recording student data and keeping track of things.
Dorothy Wang
Sep 26, 2008
still have lots of things to learn and need to practice to familiar with it
Amy Keus
Sep 26, 2008
ADDING CHARTS USING ROWS
You can add charts whose ranges lie completely within rows. To do this, simply highlight the rows in question (and you can have multiple rows) and click on the Chart button. The main issue is which chart to choose -- choosing stacked charts will make one big chart, which is what the problem had been.
/groups/technologylearning/search/index.rss?sort=modifiedDate&sortDirection=reverse&tag=technology educationlist/groups/technologylearning/search/?sort=modifiedDate&sortDirection=reverse&tag=technology educationTechnology LearningCustomTagSidebarCustomTagSidebar?sort=modifiedDate&sortDirection=reverse&tag=technology education0/groups/technologylearning/sidebar/CustomTagSidebarmodifiedDate5CustomTagSidebarreversetechnology educationTechnology Learningcustom/groups/technologylearning/search/index.rss?tag=hotlist/groups/technologylearning/search/?tag=hotWhat’s HotHotListHot!?tag=hot14/groups/technologylearning/sidebar/HotListtimwojcikTim Wojcik2012-05-16 10:20:08+00:002012-05-16 10:20:08updated31timwojcikTim Wojcik2012-05-16 06:05:23+00:002012-05-16 06:05:23updated30timwojcikTim Wojcik2012-05-16 05:51:11+00:002012-05-16 05:51:11updated29timwojcikTim Wojcik2012-05-15 04:41:16+00:002012-05-15 04:41:16updated28timwojcikTim Wojcik2012-05-15 04:36:34+00:002012-05-15 04:36:34updated27timwojcikTim Wojcik2012-04-26 04:52:13+00:002012-04-26 04:52:13updated26timwojcikTim Wojcik2012-04-26 04:52:03+00:002012-04-26 04:52:03updated25timwojcikTim Wojcik2012-04-20 03:14:50+00:002012-04-20 03:14:50updated24timwojcikTim Wojcik2012-04-17 05:07:05+00:002012-04-17 05:07:05updated23timwojcikTim Wojcik2012-04-17 05:05:02+00:002012-04-17 05:05:02updated22timwojcikTim Wojcik2012-04-17 05:04:34+00:002012-04-17 05:04:34updated21timwojcikTim Wojcik2012-04-17 05:03:13+00:002012-04-17 05:03:13updated20timwojcikTim Wojcik2012-04-17 05:01:44+00:002012-04-17 05:01:44updated19timwojcikTim Wojcik2012-04-17 04:52:24+00:002012-04-17 04:52:24updated18timwojcikTim Wojcik2012-04-17 04:29:35+00:002012-04-17 04:29:35updated17timwojcikTim Wojcik2012-04-17 04:21:21+00:002012-04-17 04:21:21updated16timwojcikTim Wojcik2012-04-17 04:19:31+00:002012-04-17 04:19:31updated15timwojcikTim Wojcik2012-04-17 04:09:59+00:002012-04-17 04:09:59updated14timwojcikTim Wojcik2012-04-17 04:09:20+00:002012-04-17 04:09:20updated13timwojcikTim Wojcik2012-04-17 02:35:26+00:002012-04-17 02:35:26updated12timwojcikTim Wojcik2012-04-17 02:35:00+00:002012-04-17 02:35:00updated11timwojcikTim Wojcik2012-04-17 02:34:46+00:002012-04-17 02:34:46updated10timwojcikTim Wojcik2012-04-17 02:34:20+00:002012-04-17 02:34:20updated9timwojcikTim Wojcik2012-04-17 02:28:05+00:002012-04-17 02:28:05updated8Added tag - hottimwojcikTim Wojcik2012-04-17 02:06:35+00:002012-04-17 02:06:35addTag7Added tag - meetingtimwojcikTim Wojcik2012-04-17 02:06:34+00:002012-04-17 02:06:34addTag6Added tag - planningtimwojcikTim Wojcik2012-04-17 02:06:32+00:002012-04-17 02:06:32addTag5Added tag - lms committeetimwojcikTim Wojcik2012-04-17 02:06:25+00:002012-04-17 02:06:25addTag4Removed tag - lmstimwojcikTim Wojcik2012-04-17 02:06:22+00:002012-04-17 02:06:22removeTag3Added tag - lmstimwojcikTim Wojcik2012-04-17 02:06:17+00:002012-04-17 02:06:17addTag2First createdtimwojcikTim Wojcik2012-04-17 02:04:52+00:002012-04-17 02:04:52created1wiki2012-05-16T10:20:08+00:00groups/technologylearning/wiki/3a60eFalseLMS Committee/groups/technologylearning/wiki/3a60e/LMS_Committee.htmlTim Wojcik31 updatesLMS Committee
May 16 - Today's Agenda
Review Answers from Veracross re: Class Websites
Multiple teachers accessing...Falsetimwojcik2012-05-16T10:20:08+00:00brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 04:41:54+00:002012-05-04 04:41:54updated23brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 04:27:25+00:002012-05-04 04:27:25updated22brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 04:26:17+00:002012-05-04 04:26:17updated21timwojcikTim Wojcik2012-05-04 04:14:07+00:002012-05-04 04:14:07updated20brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 04:03:20+00:002012-05-04 04:03:20updated19brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 04:03:01+00:002012-05-04 04:03:01updated18brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 03:05:17+00:002012-05-04 03:05:17updated17brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 03:05:00+00:002012-05-04 03:05:00updated16brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 03:04:22+00:002012-05-04 03:04:22updated15brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 03:04:06+00:002012-05-04 03:04:06updated14brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 03:03:47+00:002012-05-04 03:03:47updated13brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 02:56:52+00:002012-05-04 02:56:52updated12brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 02:56:11+00:002012-05-04 02:56:11updated11brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 02:49:07+00:002012-05-04 02:49:07updated10brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 02:43:22+00:002012-05-04 02:43:22updated9brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 02:37:18+00:002012-05-04 02:37:18updated8brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 00:22:24+00:002012-05-04 00:22:24updated7Added tag - planningbrianlockwoodHow? What? Why? Questions for life and learning2012-05-04 00:14:29+00:002012-05-04 00:14:29addTag6Added tag - meetingbrianlockwoodHow? What? Why? Questions for life and learning2012-05-04 00:14:20+00:002012-05-04 00:14:20addTag5Added tag - hotbrianlockwoodHow? What? Why? Questions for life and learning2012-05-04 00:14:09+00:002012-05-04 00:14:09addTag4Added tag - tech committeebrianlockwoodHow? What? Why? Questions for life and learning2012-05-04 00:14:03+00:002012-05-04 00:14:03addTag3brianlockwoodHow? What? Why? Questions for life and learning2012-05-04 00:13:49+00:002012-05-04 00:13:49updated2First createdbrianlockwoodHow? What? Why? Questions for life and learning2012-05-04 00:12:38+00:002012-05-04 00:12:38created1weblog2012-05-04T04:41:54+00:00groups/technologylearning/weblog/4da93FalseTech Committee - May 4, 2012/groups/technologylearning/weblog/4da93/Tech_Committee__May_4_2012.htmlHow? What? Why? Questions for life and learning23 updatesTech Committee - May 4, 2012
Friday, May 4th
12:45-1:45, C136 (Francis' room)
May 30th visitor update, ideas and plans #delt17 is the twitter hash tag for 2...Falsebrianlockwood2012-05-04T04:41:54+00:00billclarkMr. Clark's English Stuff2012-04-27 03:50:29+00:002012-04-27 03:50:29updated13timwojcikTim Wojcik2012-04-27 01:21:28+00:002012-04-27 01:21:28updated12timwojcikTim Wojcik2012-04-27 01:20:17+00:002012-04-27 01:20:17updated11timwojcikTim Wojcik2012-04-27 01:18:11+00:002012-04-27 01:18:11updated10timwojcikTim Wojcik2012-04-27 01:14:57+00:002012-04-27 01:14:57updated9timwojcikTim Wojcik2012-04-27 01:01:19+00:002012-04-27 01:01:19updated8timwojcikTim Wojcik2012-04-27 00:57:56+00:002012-04-27 00:57:56updated7timwojcikTim Wojcik2012-04-24 11:01:31+00:002012-04-24 11:01:31updated6Added tag - meetingtimwojcikTim Wojcik2012-04-24 10:59:54+00:002012-04-24 10:59:54addTag5Added tag - planningtimwojcikTim Wojcik2012-04-24 10:59:52+00:002012-04-24 10:59:52addTag4Added tag - tech committeetimwojcikTim Wojcik2012-04-24 10:59:50+00:002012-04-24 10:59:50addTag3Added tag - hottimwojcikTim Wojcik2012-04-24 10:59:48+00:002012-04-24 10:59:48addTag2First createdtimwojcikTim Wojcik2012-04-24 10:59:45+00:002012-04-24 10:59:45created1weblog2012-04-27T03:50:29+00:00groups/technologylearning/weblog/99276FalseTech Committee - April 27, 2012/groups/technologylearning/weblog/99276/Tech_Committee__April_27_2012.htmlMr. Clark's English Stuff13 updatesTech Committee - April 27, 2012
Friday, April 27
12:45-1:45, C136 (Francis' room)
#beyondlaptops - recap/highlights/discus...Falsebillclark2012-04-27T03:50:29+00:00timwojcikTim Wojcik2012-04-11 03:49:09+00:002012-04-11 03:49:09updated9Added tag - meetingtimwojcikTim Wojcik2012-04-11 03:42:47+00:002012-04-11 03:42:47addTag8Added tag - tech committeetimwojcikTim Wojcik2012-04-11 03:42:44+00:002012-04-11 03:42:44addTag7Removed tag - tech commtimwojcikTim Wojcik2012-04-11 03:42:42+00:002012-04-11 03:42:42removeTag6Added tag - tech commtimwojcikTim Wojcik2012-04-11 03:42:39+00:002012-04-11 03:42:39addTag5Added tag - planningtimwojcikTim Wojcik2012-04-11 03:42:35+00:002012-04-11 03:42:35addTag4Added tag - hottimwojcikTim Wojcik2012-04-11 03:42:33+00:002012-04-11 03:42:33addTag3timwojcikTim Wojcik2012-04-11 03:42:28+00:002012-04-11 03:42:28updated2First createdtimwojcikTim Wojcik2012-04-11 03:40:40+00:002012-04-11 03:40:40created1weblog2012-04-11T03:49:09+00:00groups/technologylearning/weblog/bf360FalseTech Committee - Friday the 13th, April 2012/groups/technologylearning/weblog/bf360/Tech_Committee__Friday_the_13th_April_2012.htmlTim Wojcik9 updatesTech Committee - Friday the 13th, April 2012
Friday, April 13
12:45-1:45, C136 (Francis' room)
Surveys (Bill)
Digital Citizenship Discussion (Mari...Falsetimwojcik2012-04-11T03:49:09+00:00billclarkMr. Clark's English Stuff2012-03-30 03:44:28+00:002012-03-30 03:44:28updated7timwojcikTim Wojcik2012-03-28 06:47:41+00:002012-03-28 06:47:41updated6Added tag - planningtimwojcikTim Wojcik2012-03-28 06:44:14+00:002012-03-28 06:44:14addTag5Added tag - meetingtimwojcikTim Wojcik2012-03-28 06:44:12+00:002012-03-28 06:44:12addTag4Added tag - tech committeetimwojcikTim Wojcik2012-03-28 06:44:06+00:002012-03-28 06:44:06addTag3Added tag - hottimwojcikTim Wojcik2012-03-28 06:44:00+00:002012-03-28 06:44:00addTag2First createdtimwojcikTim Wojcik2012-03-28 06:43:32+00:002012-03-28 06:43:32created1weblog2012-03-30T03:44:28+00:00groups/technologylearning/weblog/ee1e7FalseTech Committee - March 30/groups/technologylearning/weblog/ee1e7/Tech_Committee__March_30.htmlMr. Clark's English Stuff7 updatesTech Committee - March 30
Friday, March 30
12:45-1:45, C136 (Francis' room)
Looking Ahead
Replacing the wikis -- A new Learn...Falsebillclark2012-03-30T03:44:28+00:00hot/groups/technologylearning/search/index.rss?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcomelist/groups/technologylearning/search/?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcomeRecent ChangesRecentChangesListUpdates?sort=modifiedDate&kind=all&sortDirection=reverse&excludePages=wiki/welcome0/groups/technologylearning/sidebar/RecentChangesListmodifiedDateallRecent ChangesRecentChangesListUpdateswiki/welcomeNo recent changes.reverse5search
Technology Learning
Comments
Kath Adams
Sep 24, 2008
No, I'm here too!
Fantasy Premier League
Sep 24, 2008
so am I
User Settings
Sep 24, 2008
how do I get my picture in there?
Matthew Lacey
Sep 24, 2008
Blimey Ron, you're here on time.
Chris Klesch
Sep 24, 2008
Ann types "There are my notes, this is cool."
Fantasy Premier League
Sep 24, 2008
So far I like it I think it is better than excel. You can drag a whole table around! That is good!
Woo Hee Jun
Sep 24, 2008
Inputing checkboxes (leaving them checked or unchecked) is a cool feature.
Fantasy Premier League
Sep 24, 2008
To drag a table around click on the table . The top left button can be clicked and the table dragged around.
To add another table click on "tables" and select the type of table you want.
Kath Adams
Sep 24, 2008
It seems very versatile-love being able to insert photos though I have to think how I'm going to use that. Cell background, image fill select photo-for those interested
Helen Thompson
Sep 24, 2008
The check box is very useful in tables as recording assessments will be much easier. Want to know how to input formulas please
Kath Adams
Sep 24, 2008
Like inserting photos into cells-cell background, image fill, select photo. Though I have to think about how to use it.
desireelouw
Sep 24, 2008
You can put photos in the cells! So you could put a photo next to the students name on the list.
User Settings
Sep 24, 2008
to add a new wiki comment, you must select "save comment" or it won't save!
Aggie Huang
Sep 24, 2008
if you would like to change the color of your chart, you may go to the inspector, choose the chart and then dray the color to you chart. it worked!
Chris Klesch
Sep 24, 2008
Charts are cool. I also learned to widen columns, change column colors and drag colors into your chart.
desireelouw
Sep 24, 2008
I am the last!
Fantasy Premier League
Sep 24, 2008
Click and drag is fantastic, you can click and drag pictures and even videos into your document
Jillian Eyre-Walker
Sep 24, 2008
Numbers = Spread sheet
View
Show print view
What ever you put on your header rows it will repeat
Style draws (left hand bottom) you can style your table
You can change the inside lines by going to the inspector and click on the table box. You need to highlight the area you want changed first.
On the left hand side at the top you can double click on sheet. Now you can name your sheet. Then you double click on table just below and you can name your table. This is important because you can have lots of table on the one page.
On the left hand corner up the top if you click on name the computer will then put the name of your table into your table.
To make a second table go to the table icon at the top and click on it. Then select a type of table and you will see a second table on your page.
Now to move that table click box in left hand top corner and drag table to its place. The thick blue line that moves will help you line up your tables.
To move between cells click on any arrow key
You can also press enter for down
Amy Keus
Sep 25, 2008
If you have questions about Numbers, then please post them here and I will answer the best that I can.
FORMULAE:
There will be a 2nd session on using Numbers' more advanced functions. However, if you'd like a heads-up on using formulae, I'll discuss this now.
Today I showed you how to total a column. This was by typing =sum(C1:C3), which will add columns C1, C2, and C3. You can also click in the cell below all of your data and click INSERT / FUNCTION / SUM. This, though, will add all data going up to the header, so if you have left some extra cells with data you don't want to be counted, you'll have a bit of a problem. If you are worried about this, then just do what I showed you --- type =sum( and then highlight the cells you want, and press ENTER.
Cindy Van den Heuvel
Sep 25, 2008
Amy, put your instruction movie on youtube
Nadean Curtiss
Sep 25, 2008
text organization template is one for multi media....can use the blank template for anything also
Cindy Van den Heuvel
Sep 25, 2008
Andrei discovered a problem with numbers
Elizabeth Solomon
Sep 25, 2008
I would like to know how to slant my labels when you have the time, thanks
Amy Keus
Sep 25, 2008
Andrei found something new! He discovered that you can resize the entire table in a similar way in which you can add or delete rows and columns. The problem comes in when you accidently click on the white handles instead of the grey. This will take as many rows and columns as you have - which might be dozens - and will make them so tiny that you can't read any of the data and the grey handles disappear, so you can't even add or delete columns.
Lesson learned? When you are trying to add or delete handles, make sure you are dragging the GREY handles.
Thanks Andrei, for showing us that!
Charlie Mcbride
Sep 25, 2008
thank you for the help. I think I need to go through the movie and practice the other options in numbers
Andrei Tyoschin
Sep 25, 2008
comand/space and type numbers
View - show print view
right side three buttons headdress their only for text
In sheets window 2klick sheet and rename
To edit the table go to inspector - table
Scott Platt
Sep 25, 2008
I learned how to make a pie chart based on the information I'd entered into a table.
Isabelle Holovecz
Sep 25, 2008
If you highlight your chart and do a right click, you can also select your graph. Quite easy this way!
Cindy Van den Heuvel
Sep 25, 2008
Amy, you can't copy and paste a table into keynote as it loses all the cells and borders
Andrei Tyoschin
Sep 25, 2008
Formating go to toolbar (numbers,$....) or sell inspector
To arrange numbers in ascending or descending order you need to type at least two numbers and drag, same with dates.
Niki Swart
Sep 25, 2008
Numbers - Blank - click view - click show view print - you then move your table onto one page from left to right and from bottom to top.
Resize the table: bottom right makes it larger and smaller (increasing and decreasing the number of columns) - click top right corner - see little squares and then resize keeping the same number of columns
Use the format bar or the inspector to do all your fomatting
Name your table - sheet and table on the left side
Cell borders: highlight, change the type of line, the thickness, the colour
Entering data: Hightlight the cells you want to enter data in - choose the type of data from the inspector using cell inspector
To create charts: hightlight the column(s) you want included in the chart - click chart - select the type of chart that you want and click
To add pictures etc - just drop and drag.
Jae Yong Hwangbo
Sep 25, 2008
Nice to meet you, Numbers! Thanks Amy for introducing a good friend for this holiday.
Amy Keus
Sep 25, 2008
MOVING FROM NUMBERS TO PAGES AND KEYNOTE:
I have just copied a table and a chart from Numbers to both Keynote and Pages, and they both pasted perfectly.
I did not highlight the table. Rather, I clicked on the table so that the white handles appeared. Then I clicked COMMAND+C. Going into Pages and Keynote, I clicked COMMAND+V to paste them in.
//
Any other questions? Keep them coming!
Candace Taylor-Weber
Sep 25, 2008
To record on computer, go to SMARTBOARD TOOLS (blue box looking icon on the task bar) | open | recorder. It will record the audio with the built in mic and also whatever happens on your screen.
Amy Keus
Sep 25, 2008
To repeat numbers, or to create patterns of information:
1. If you want 1,1,1,1,1,1,1,1,1,1 going all the way down the column. Type 1 into the first cell. When you click on it again, a tiny white circle will appear in the bottom right hand corner of the cell. Click and drag in the direction that you want to fill.
2. If you want a repeating pattern, such as 1,2,3,4,5,6 or 3,6,9,12, or Sept 1, Sept 3, Sept 5, Sept, going all the way down a row or column... Type the first 2 or 3 data into the first few cells. When you click on it again, a tiny white circle will appear in the bottom right hand corner of the cell. Click and drag in the direction that you want to fill.
Candace Taylor-Weber
Sep 25, 2008
Charts - just click the "chart" button. A table will automatically pop up when you choose the kind you want. Just modify the data and away you go. You can customize details in the inspector. Even cooler is you can double click one piece of a pie chart, and pull it out or separate it out (thank you Matthew).
Candace Taylor-Weber
Sep 25, 2008
Alpha tool (a little button at the top, and if it's not there, customize your toolbar by adding it there) will get rid of background in an image you might want to use. If you have, for example, a picture with a black background, you can erase the black and just have the leaf from the foreground.
Candace Taylor-Weber
Sep 26, 2008
Resource on public server | ICT_Resource | HowTo
Candace Taylor-Weber
Sep 26, 2008
To copy cell contents (repeat), just highlight the cell and select the white dot in the lower right hand corner. Drag that down and the contents will repeat. IF you want to fill the cells with a pattern, you need to highlight the cells that already hold the pattern (2-3 cells or whatever) and click the white dot in the corner and drag. If you fill with a pattern, it not only recognizes numerical patterns, but will also notice formatting patterns (a black 1, red 2, black 3, red, 4).
Aaron Thompson
Sep 26, 2008
In a pie chart click to select a "slice of pie" and drag it away from the graph to show the slice.
Chris Allen
Sep 26, 2008
I can't make a table when I copy stats from one row of information (that was the sum of columns).
Christina Wu
Sep 26, 2008
learn a lot of stuff!
Robin Hutchison
Sep 26, 2008
Life is about numbers and this session is further evidence of this.
Eunice Ong
Sep 26, 2008
I have learnt how to import sound, movies and pictures into numbers. It's interesting.
Jean Yang
Sep 26, 2008
Numbers is so much cooler than PPT ! o(^_^)o
liviasuri
Sep 26, 2008
This is going to be very useful for recording student data and keeping track of things.
Dorothy Wang
Sep 26, 2008
still have lots of things to learn and need to practice to familiar with it
Amy Keus
Sep 26, 2008
ADDING CHARTS USING ROWS
You can add charts whose ranges lie completely within rows. To do this, simply highlight the rows in question (and you can have multiple rows) and click on the Chart button. The main issue is which chart to choose -- choosing stacked charts will make one big chart, which is what the problem had been.