what is a good way to review microsoft excel formulas with students for an upcoming test? It can be in the form of a game or just a simple review. Anyone??
2007-09-26 03:36:05 · 5 answers · asked by Anonymous in Education & Reference ➔ Primary & Secondary Education
It's tricky to make a group review using Microsoft Excel. I suggest doing it on your own.
2007-09-26 03:44:51 · answer #1 · answered by earl s 1 · 0⤊ 2⤋
Depending on the formulas you are including in the exam, provide a scenario where they have to use Excel formulas to provide a desired result.
For example, give them a list of movies with identification numbers that you assign and corresponding prices, quantities, etc. On another sheet list all the customers who rented movies from the store and relevant data about the corresponding sales for, say, a one-week period. Have the students write excel formulas to determine various statistical information that a fictitious manager might request.
- Which movie had the most rentals this week?
- How many sales were there each day?
- How many movies are in stock that were not rented?
This scenario allows them to practice using formulas like COUNTIF, SUMIF, VLOOKUP, etc., and you can expand the scenario to provide an opportunity to apply other formulas to suit your needs. The key is to pick a situation with which nearly everyone can identify -- like a movie rental store. It also reassures them that formulas are not just book knowledge, it may come in handy in the "real world."
2007-09-26 12:33:46 · answer #2 · answered by DK 3 · 0⤊ 0⤋
Create a real life scenario type application where the students get grouped up into teams to create an Excel file that uses each Excel function that you want them to know to create the file. The team with the best program wins.
We did something similar in college but with Quattro Pro. One group created a workbook for a bank. My group created a dichotomous key to use for biology to determine different types of insects based on their characteristics.
It helps them learn the applications, makes it fun, and helps to somewhat put it into a real world perspective.
Basically you could have your own little version of the show Apprentice in a way. The team with the best presentation wins.
2007-09-27 05:00:54 · answer #3 · answered by devilishblueyes 7 · 0⤊ 0⤋
the common rule is that area money are credited to the bill entire, to not guy or woman products. you will have observed on expenses you have gained a notice to the result that every physique products stay the valuables of the seller until paid in finished. this facilitates the seizure of the products interior the form of non fee of the account.
2016-11-06 10:11:36 · answer #4 · answered by ? 4 · 0⤊ 0⤋
I would say test..... i took a million computer classes in high school and then went to business school for computers and thats the best way i learned formulas
2007-09-26 03:46:21 · answer #5 · answered by nikkimarie04 2 · 0⤊ 2⤋