The Webquest I liked:
http://zunal.com/webquest.php?w=157042
Introducing Microsoft Excel and how it can be used in a specific trade is part of the course that I teach. The above is a good Webquest that introduces Excel to students. I like this Webquest also because the author uses a flipped classroom approach which I generally use in my classroom.
Based on the six parts that a typical Webquest contains, I would create my Webquest as follows. As an example, I’m going to use the automotive trade.
Introduction:
I would introduce the Webquest as an assignment to find out how work orders and maintenance reports are created using Microsoft Excel.
Task:
The task would be create a customized work order or vehicle maintenance report using Microsoft Excel using formatting that have been taught in class.
Information sources:
http://www.gcflearnfree.org/excel2013
This link provides tutorials to Excel formatting that students have already learnt in class.
http://www.spreadsheet123.com/ExcelTemplates/index.html
This link provides access to examples of various Excel work order templates that already exist.
https://www.youtube.com/watch?v=4cqpptVyyig
This link shows a Youtube video example of how a work order can be created.
I will provide these information sources in the process section of the Webquest.
Process:
I would list the following steps in the this section –
- Review all the formatting that we learnt in class. Use this link to refresh your memory.
- Use this link to look at examples of work order templates that already exist.
- Watch this video as an example of how work orders can be made on Excel.
- Create the Excel sheet with all the basic requirements that need to present on a work order.
- Be as creative as you can be.
Guidance / Evaluation:
The guidance part would be more of an evaluation step to make sure the work is done correctly.
- Make sure you have all the required fields on the work order.
- Make sure all the formulas work by trying out different numbers in all the fields.
- Make sure your work order prints on 1 page.
Conclusion:
In the conclusion part, I would congratulate the students on completing the assignment and provide instructions on when and where the assignment needs to be submitted.
A Webquest is a great tool that I would definitely be using in the future to make assignments more interesting.