Mid-term review topics and questions

We will have a mid-term quiz next Tuesday and Wednesday for Computer Tech Ed class.

The following topics and questions will be covered:

Program		Questions
GMail		Cc, Bcc   - when would you use these features?
Word		Be able to create a table with column and row headers
Powerpoint		What feature would you use to make text fly into and onto a slide?
		Be able to create a slide or two which imports an image,
		has interesting font style (color, size) and that meets
		our standards for how to give a good presentation
		Create a slide that summarizes 5 key points of giving a good presentation.
Excel		Short problems: apply % Change, %markup and % discount formulas
		How much max rent as % of monthly income?
		How can you distinguish between a formula cell and a constant cell?
		Use Excel Date and Time functions to calculate # days to the Super Bowl.
Tech Terms		Identify Google hottest trends right now.
		Google Maps - how many minutes by car from New Haven Green to the Hyde School?
		Explain what Cyber Monday and Black Friday are.
		Explain the difference between brick and mortar retail sales vs online sales.
		What is DTCI and which web site can you go to to calculate it?
		Which web site would you recommend to get nutritional facts?
		Big Picture Questions
		Create a table in Excel or Word and tell me when you would
		use Word vs Powerpoint vs Excel.
		What is each program best suited for? Give examples.
		For which tasks would you use them?
		Icon comparitive checklist - which icons are found EXCLUSIVELY in
		Excel vs Word vs PPT
		Which icons are found in ALL 3 programs?
		Which program has a built-in dictionary and thesaurus?
		Which program is best for graphic design in your opinion
		(Excel, Word, or PPT)			Why?