Basically, what cfschedule can do is run the page and save it -- you just show the saved page to the user.
Create a .cfm page that does your queries and output them on the page -- create it as though you would show this to your users. Now to make the page static, you use cfschedule to run the page and save the page out to a file on your web server. Then just link to the static page instead of the .cfm version.
HTH,
Tim P.