Excel



Below is a list of some of the skills students need to master in order to become proficient users of spreadsheets. Your task is to select one and create a screen cast video that demonstrates that skill in a way other students can use to learn it.

When making your video:
 * Lower your screen resolution to at least 800x600 so that the screen elements are large enough to see in a YouTube sized video.
 * Explain the "why" as well as the "how"
 * Consider writing a short script, perhaps just as dot points.
 * You need to be really sure about what you are doing to provide clear explanations. Spend some time to learn the skill yourself first.
 * When you start a new project in iMovie, be sure to use the correct ration (4:3 if you recorded in 800x600)
 * No surnames or identifying content - videos will be public

When you are done, play it for Mr B and we'll discuss how it can be improved :-) Don't be amazed if it takes a few attempts - we are publishing globally so it needs to be good.

Basic terminology - column, row, cell references Differences between data types - labels vs. values Enter data using Fill Series Insert and delete rows or columns Adjust column widths and row heights Hide and unhide rows or columns Paste vs. Paste Special Freeze panes Enter formulas manually using math operators Enter formulas using Insert Function Search in the Function Library Use cell references in a formulas Differences between Relative and Absolute cell references Change a relative references to an absolute references Refer to data in another worksheet or workbook Create a SUM formula Create a COUNT formula Create a COUNTA formula Create an AVERAGE formula Create a MIN formula Create a MAX formula Create a CONCATENATE formula Display formulas on the screen View calculation results in the Status Bar